View: Cheque Details

RotoID: CP0049
Table: CPCHKD
Protocol: Detail, Ordered revisions
DLL: CPCHKD

Compositions: 3

RotoID  Tables  Title  DLL 
CP0048  CPCHKH  Cheque Header  CPCHKH
CP0134  CPCHDO  Cheque Details Optional Fields  CPCHDO
CP0056  CPCHJB  Cheque Job Details  CPCHJB

Keys: 2

Title  Fields
Employee  EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order  EMPLOYEE, PEREND, ENTRYSEQ, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

Fields: 58

Field  Index  Type  Title  Attributes  Presentation
EMPLOYEE  1  String*12  Employee  E A K R  Mask: %-12N
PEREND  2  Date  Period End Date  E A K R   
ENTRYSEQ  3  Long  Entry Sequence  E A K R   
CATEGORY  4  Integer  Category  E A K R  List: 10 entries
1=Accrual
2=Earning
3=Advance
4=Deduction
5=Expense Reimbursement
6=Benefit
7=Federal Tax
8=Provincial Tax
9=Local Tax
10=User Tax
EARNDED  5  String*6  Earning/Deduction-Tax  E A K R  Mask: %-6N
LINETYPE  6  Integer  Type  E A K R X  List: 9 entries
1=Payment
2=Accrual
3=Regular
4=Overtime
5=Shift Differential
6=n/a
7=Normal Withholding
8=Backup Withholding
9=Supplemental Withholding
LINENO  7  Integer  Line Number  E A K R   
EARDEDTYPE  8  Integer  Earning/Deduction-Tax Type  E A C X  List: 16 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Banked Time
10=
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Employment Tax
21=Pension Plan Tax
22=Health Tax
23=Other Tax
25=n/a
EARDEDDATE  9  Date  Earning/Deduction Date  E A X   
HOURS  10  BCD*4.3  Hours  E A X   
ECNTBASE  11  BCD*10.3  Employee Pieces/Sales/Base  E A X   
ERATE  12  BCD*9.5  Employee Rate/Amt/Pct  E A X   
EEXTEND  13  BCD*10.3  Employee Extended Amount  E A X   
EREGRATE  14  BCD*9.5  Regular Rate  E A X   
RCNTBASE  15  BCD*10.3  Employer Pieces/Base  E A X   
RRATE  16  BCD*9.5  Employer Amt/Pct  E A X   
REXTEND  17  BCD*10.3  Employer Extended Amount  E A X   
EXPACCT  18  String*45  Regular Pay Expense G/L Account  E A   
ELIABACCT  19  String*45  Employee Liability G/L Account  E A   
RLIABACCT  20  String*45  Employer Liability G/L Account  E A   
WCC  21  String*6  Workers' Compensation Code  P X   
GLSEG1  22  String*15  Cost Center Segment One  E A C X   
GLSEG2  23  String*15  Cost Center Segment Two  E A C X   
GLSEG3  24  String*15  Cost Center Segment Three  E A C X   
PARTIAL  25  Boolean  Detail Was Partially Taken or Not  E A   
TAXWEEKS  26  BCD*4.3  RESERVED - US Only  E A X   
TAXEARNS  27  BCD*10.3  No Ceiling Wage  E A X   
TXEARNCEIL  28  BCD*10.3  Ceiling Wage  E A X   
TAXTIPS  29  BCD*10.3  RESERVED - US Only  E A X   
TXTIPSCEIL  30  BCD*10.3  RESERVED - US Only  E A X   
TAXONTIPS  31  BCD*10.3  RESERVED - US Only  E A X   
UNCOLLTAX  32  BCD*10.3  RESERVED - US Only  E A X   
PCATEGORY  33  Integer  Print Category  A C  List: 5 entries
1=CHKD Earnings
2=CHKD Deductions
3=CHKD Taxes
4=CHKD Other
5=CHKD Benefits
PLINETYPE  34  Integer  Print Line Type  A C  List: 42 entries
11=CHKD Regular Line
11=CHKD Overtime Line
11=CHKD Shift Diff Line
14=CHKD Disbursed Tips
15=CHKD Vacation Payment
16=CHKD Sick Payment
17=CHKD Comp. Time Payment
21=CHKD Deduction Entry
31=CHKD Federal Income Entry
32=CHKD Federal Insurance Entry
33=CHKD Federal EI Entry
34=CHKD Federal Pension Entry
35=CHKD Federal Health Entry
36=CHKD Federal Other Entry
41=CHKD State Income Entry
42=CHKD State Insurance Entry
43=CHKD State EI Entry
44=CHKD State Pension Entry
45=CHKD State Health Entry
46=CHKD State Other Entry
51=CHKD Local Income Entry
52=CHKD Local Insurance Entry
53=CHKD Local EI Entry
54=CHKD Local Pension Entry
55=CHKD Local Health Entry
56=CHKD Local Other Entry
61=CHKD User Income Entry
62=CHKD User Insurance Entry
63=CHKD User EI Entry
64=CHKD User Pension Entry
65=CHKD User Health Entry
66=CHKD User Other Entry
71=CHKD Exp Reimbursement
72=CHKD Cash Advance
73=CHKD Reported Tips
74=CHKD Allocated Tips
75=CHKD Noncash Advance
76=CHKD Vac Accrual
77=CHKD Sick Accrual
78=CHKD Comp Accrual
81=CHKD Cash Benefit
82=CHKD Noncash Benefit
PCONTENTS  35  Integer  Print Line Contents  A C  List: 5 entries
1=CHKD Employee Only
2=CHKD Both EmpE And EmpR
3=CHKD Employer Only
4=CHKD Historical Entry
5=CHKD Tax Info Only Entry
TAXNONPER  36  BCD*10.3  Non-periodic Payment  E A X   
TAXEARNBD  37  BCD*10.3  Earnings before Deductions  E A X   
POOLEDTIPS  38  BCD*10.3  Pooled Tips  E A X   
DETAILDATE  39  Date  Detail Date  E A   
STARTTIME  40  Integer  Start Time  E A X   
STOPTIME  41  Integer  Stop Time  E A X   
WCCGROUP  42  String*6  Workers Comp. Group  P X   
VALUES  43  Long  Number of Optional Fields  E A C   
SWFLSA  44  Boolean  Included in Regular Rate OT Calc  E A   
DAYS  45  Integer  Days Worked  E A X   
OTSCHED  46  String*6  Overtime Schedule  E A  Mask: %-6N
OTHOURS  47  BCD*4.3  Overtime Hours Override  E A X   
STAMOUNT  48  BCD*10.3  Straight Time Earnings  E A   
PREMIUMRT  49  BCD*5.5  Overtime Rate Multiplier  E A   
JOBS  50  Long  Jobs  C X   
WORKCODE  51  String*6  Work Classification Code  X   
PROCESSCMD  100  Integer  Process Command Code  E A C  List: 2 entries
0=No Action
1=Insert Optional Fields
DTLTYPE  101  Integer  Detail Type  E A C  List: 2 entries
1=Earning/Deduction
2=Tax
ECALCMETH  102  Integer  Employee Calculation Method  E A C   
RCALCMETH  103  Integer  Employer Calculation Method  E A C   
HTAXSIDE  104  Integer  History Entry - Tax Side  E A C  List: 4 entries
0=Not Applicable
1=Employer Tax
2=Employee Tax
3=Employee and Employer Tax
TAXEARNSNT  105  BCD*10.3  RESERVED - US Only  E A X   
TXEARNCLNT  106  BCD*10.3  RESERVED - US Only  E A X   

This page was generated on 2009-Nov-19

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