Table: Manual Cheque Detail

Table: CPMCDT
View: CP0020
Record Length: 608

Flags: A R 

Keys: 2

Title Flags Fields

Employee/Line Number EMPLOYEEBANKCHECKNUMPERENDCHECKDATELINENUM
Employee/Earn Ded EMPLOYEEBANKCHECKNUMPERENDCHECKDATEEARNDEDLINENUM

Fields: 53

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
BANK String*8 Bank ID Mask: %-8N
CHECKNUM BCD*5.0 Cheque Number
PEREND Date Period End Date
CHECKDATE Date Cheque Date
LINENUM Integer Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
EARNDED String*6 Earning/Deduction Mask: %-6N
CATEGORY Integer Category 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
EARDEDTYPE Integer Type List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
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
LINETYPE Integer Transaction Type List:6 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Diff.
6 = n/a
EARDEDDATE Date Date
GLSEG1 String*15 G/L Segment One Mask: %-15N
GLSEG2 String*15 G/L Segment Two Mask: %-15N
GLSEG3 String*15 G/L Segment Three Mask: %-15N
HOURS BCD*4.3 Hours
CALCMETH Integer Calculation Method
LIMITBASE Integer Base Limit
CNTBASE BCD*10.3 Pieces/Base
RATE BCD*9.5 Rate/Amt/Percent
EXTEND BCD*10.3 Extended Amt
EXPACCT String*45 Regular Pay Expense G/L Account
LIABACCT String*45 Liability G/L Account
OTACCT String*45 Overtime Expense G/L Account
SHIFTACCT String*45 Shift Diff. Expense G/L Account
ASSETACCT String*45 Asset G/L Account
WCC String*6 Workers' Compensation Code
TAXWEEKS BCD*4.3 RESERVED - US Only
TAXANNUAL BCD*5.5 RESERVED - US Only
WEEKLYNTRY Boolean INTERNAL USE
ENTRYTYPE Integer Entry Type
CALCSS Integer RESERVED - US Only
CALCMED Integer RESERVED - US Only
POOLEDTIPS BCD*10.3 Pooled Tips
WCCGROUP String*6 Workers Comp. Group
VALUES Long Number of Optional Fields
DISTCODE String*6 Distribution Code Mask: %-6N
REXPACCT String*45 Employer Expense G/L Account
RLIABACCT String*45 Employer Liability G/L Account
JOBS Long Jobs
WORKCODE String*6 Work Classification Code Mask: %-6N
JOBHOURS BCD*4.3 Total Job Hours
JOBBASE BCD*10.3 Total Job Pieces/Sales/Amt
RCALCMETH Integer Employer Calc. Method
RLIMITBASE Integer Employer Base Limit
RRATEOVER Boolean Override Employer Rate/Amt/Pct
RRATE BCD*9.5 Employer Rate/Amt/Pct
GLSEG4 String*15 RESERVED - G/L Segment Four
GLSEG5 String*15 RESERVED - G/L Segment Five
GLSEG6 String*15 RESERVED - G/L Segment Six