Table: Timecard Detail

Table: CPTCDT
View: CP0032
Record Length: 619

Flags: A R 

Keys: 3

Title Flags Fields

Timecard EMPLOYEEPERENDTIMECARDLINENUM
Timecard Employee EMPLOYEEPERENDTIMECARDCATEGORYEARNDEDLINENUM
Timecard Earn/Ded EARNDEDEMPLOYEEPERENDTIMECARDCATEGORYLINENUM

Fields: 58

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