# Table: US Payroll Superview

Table: PMUP
View: PM0451
Record length: 560
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
|  | SEQUENCENO

## Fields: 57

Field | Type | Title | Presentation
--- | --- | --- | ---
SEQUENCENO | Long |  |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CNTBTCH | BCD*5.0 | Batch |
LINENO | Integer | Line Number |
CHECKNUM | BCD*5.0 | Check Number |
FISCALYEAR | String*4 | Fiscal Year | Mask: %04D
FISCALPER | Integer | Fiscal Period | List: 13 entries
1 | = | 1
2 | = | 2
3 | = | 3
4 | = | 4
5 | = | 5
6 | = | 6
7 | = | 7
8 | = | 8
9 | = | 9
10 | = | 10
11 | = | 11
12 | = | 12
13 | = | 13
JOURNLDATE | Date | G/L Journal Date |
TRANSDATE | Date | Transaction Date |
CURRENCY | String*3 | Currency | Mask: %-3N
EXCHRATE | BCD*8.7 | Exchange Rate |
RATETYPE | String*2 | Rate Type | Mask: %-2N
RATEDATE | Date | Rate Date |
RATEOP | Integer | Rate Operator | List: 2 entries
1 | = | Multiply
2 | = | Divide
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CATEGORY | String*16 | Category | Mask: %-16N
EMPLOYEE | String*24 | Employee |
DOCTYPE | Integer | Document Type | List: 2 entries
1 | = | System Check
2 | = | Manual Check
TRANSTYPE | Integer | Transaction Type | List: 2 entries
1 | = | Posted
2 | = | Check Reversal
TRANSNUM | Long | PJC Transaction Number |
EARNINGS | String*6 | Earnings or Deduction Code |
QUANTITY | BCD*10.5 | Quantity |
HOURS | BCD*4.3 | Hours |
BASE | BCD*10.3 | Base |
UNITRATE | BCD*9.5 | Unit Rate |
PERCENT | BCD*9.5 | Percent |
EXTAMTHM | BCD*10.3 | Extended Amount (HM) |
EXTAMTSR | BCD*10.3 | Extended Amount (SR) |
BILLRATE | BCD*10.6 | Billing Rate |
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = | None
2 | = | Billable
3 | = | No Charge
1 | = | Non-billable
WIPACCT | String*45 | WIP Account | Mask: %-45C
TRANACCT | String*45 | Transaction Account | Mask: %-45C
OHACCT | String*45 | Overhead Account | Mask: %-45C
OHAMTSR | BCD*10.3 | Overhead Amount |
OHAMTHM | BCD*10.3 | Overhead Amount |
LABACCT | String*45 | Labor Account | Mask: %-45C
LABORSR | BCD*10.3 | Labor Amount |
LABORHM | BCD*10.3 | Labor Amount |
ARITEM | String*16 | A/R Item Number | Mask: %-16C
ARUOM | String*10 | A/R Unit of Measure | Mask: %-10C
OVERHD | Integer | Overhead Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Unit
5 | = | Percentage of Cost
OHEADRATE | BCD*10.6 | Overhead Rate |
HEADPER | BCD*5.5 | Overhead Percentage |
LABOR | Integer | Labor Type | List: 3 entries
1 | = | None
2 | = | Flat Rate Per Labor Hour/Unit
3 | = | Percentage of Labor Cost
LABORRATE | BCD*10.6 | Labor Rate |
LABORPER | BCD*5.5 | Labor Percentage |
DRILLSRCTY | Integer | Drill Down Type |
DRILLDWNLK | BCD*10.0 | Drill Down Link |
DRILLAPP | String*2 | Drill Down Application |
PROJSTAT | Integer | Project Status | List: 7 entries
10 | = | Estimate
20 | = | Approved
30 | = | Open
40 | = | On Hold
70 | = | Inactive
60 | = | Completed
50 | = | Closed
DIFF | Integer | Differential Record? |
EXPENSEREI | Integer | Exp. Reimbursement? |
RESOURCE | String*24 | Resource |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.