# Table: Manual Cheque Detail

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

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Employee |  | EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, EARNDED, UNIQUE

## Fields: 39

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 |
EARNDED | String*6 | Earning/Deduction | Mask: %-6N
UNIQUE | Integer | Unique Key Field |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
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 |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.