Table: Canadian Payroll Superview

Table: PMCP
View: PM0450
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 ^1 Mask: %-16C
PROJECT String*16 ^2 Mask: %-16N
CATEGORY String*16 ^3 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 ^2 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