Table: Manual Cheque Detail

Table: CPMCDT
View: CP0020
Record length: 548
Flags: A R 

Keys: 2

Title  Flags  Fields

Employee/Line Number  EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, LINENUM
Employee/Earn Ded  EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, EARNDED, LINENUM

Fields: 46

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=
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   

This page was generated on 2008-May-02

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