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   

This page was generated on 2008-May-01

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