Table: Print Cheques Detail Extension

Table: CPPCKD
View: CP0080
Record length: 130
Flags: A R 

Keys: 2

Title  Flags  Fields

Sort Code  SORTCODE, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order  SORTCODE, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

Fields: 20

Field  Type  Title  Presentation 

SORTCODE  BCD*10.0  Sort Code   
CATEGORY  Integer  Category  List: 11 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
11=EFT Entry
EARNDED  String*6  Earning/Deduction/Tax Code  Mask: %-6N
LINETYPE  Integer  Line Type  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  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SHORTDESC  String*15  Short Desc   
HOURS  BCD*4.3  Number of Hours   
ECNTBASE  BCD*10.3  Base Amount   
RATEFMT  Integer  Rate Format   
RATE  BCD*9.5  Hourly Rate/Percent/Amount   
CURRAMT  BCD*10.3  Current Amount   
YTDAMT  BCD*10.3  YTD Amount   
BALANCE  BCD*10.3  Accrual Balance   
PCATEGORY  Integer  Printing Category  List: 6 entries
1=CHKD Earnings
2=CHKD Deductions
3=CHKD Taxes
4=CHKD Other
5=CHKD Benefits
6=CHKE EFT Entries
PLINETYPE  Integer  Printing Line type  List: 45 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
91=CHKE EFT Entry - Fixed Amount
92=CHKE EFT Entry - % of Gross Earnings
93=CHKE EFT Entry - % of Net Pay
POOLEDTIPS  BCD*10.3  Pooled Tips   

This page was generated on 2009-Nov-19

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