# Table: Timecard Detail

Table: CPTCDT
View: CP0032
Record length: 559
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Timecard |  | EMPLOYEE, PEREND, TIMECARD, LINENUM
Timecard Employee |  | EMPLOYEE, PEREND, TIMECARD, CATEGORY, EARNDED, LINENUM
|  | EARNDED, EMPLOYEE, PEREND, TIMECARD, CATEGORY, LINENUM

## Fields: 51

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
PEREND | Date | Period End Date |
TIMECARD | String*6 | Timecard | Mask: %-6N
LINENUM | Integer | Line Number |
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
EARNDED | String*6 | Earnings/Deduction | Mask: %-6N
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
EARDEDDATE | Date | Date |
STARTTIME | Integer | Start Time |
STOPTIME | Integer | Stop Time |
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 | List: 13 entries
1 | = | None
2 | = | Flat
3 | = | Fixed
4 | = | Hourly Rate
5 | = | Amount per Hour
6 | = | Piece Rate Table
7 | = | Percentage of Base
8 | = | Sales Commission Table
9 | = | Wage Bracket Table
10 | = | Hours per Hour Worked
12 | = | Hours per Frequency
13 | = | Tax Bracket Table
14 | = | Percentage of Another Tax
LIMITBASE | Integer | Base Limit |
CNTBASE | BCD*10.3 | Pieces/Sales/Base |
RATE | BCD*9.5 | E/D/Tax Rate/Amt/Percent |
PAYORACCR | Integer | Pay/Accrue Hours | List: 3 entries
1 | = | Payment
2 | = | Accrual
6 | = | n/a
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 Differential G/L Account |
ASSETACCT | String*45 | Asset Account |
OTSCHED | String*6 | Overtime Schedule |
SHIFTSCHED | String*6 | Shift Differential Schedule |
SHIFTNUM | Integer | Shift Number |
WCC | String*6 | Workers Compensation Code |
TAXWEEKS | BCD*4.3 | RESERVED - US Only |
TAXANNLIZ | BCD*5.5 | RESERVED - US Only |
WEEKLYNTRY | Boolean | INTERNAL USE |
ENTRYTYPE | Integer | Entry Type |
POOLEDTIPS | BCD*10.3 | Pooled Tips |
DAYS | Integer | Days Worked |
WCCGROUP | String*6 | Workers Comp. Group |
VALUES | Long | Number of Optional Fields |
OTHOURS | BCD*4.3 | Overtime Hours Override |
OTRATE | BCD*9.5 | Overtime Rate Override |
SWFLSA | Boolean | Include in Regular Rate OT Calc |
DISTCODE | String*6 | Distribution Code | Mask: %-6N
REXPACCT | String*45 | Employer Expense G/L Account |
RLIABACCT | String*45 | Employer Liability G/L Account |
SWALLOCJOB | Boolean | Jobs Alloc Based on Calc Base |
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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.