View: Timecard Detail

RotoID: CP0032
Table: CPTCDT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:CPTCDT

Compositions: 3

RotoID Tables Title DLL

CP0031 CPTCHD Timecard Header CPTCHD
CP0128 CPTCDO Timecard Details Optional Field Values CPTCDO
CP0042 CPTCJB Timecard Job Details CPTCJB

Keys: 3

Title Fields

Timecard EMPLOYEEPERENDTIMECARDLINENUM
Timecard Employee EMPLOYEEPERENDTIMECARDCATEGORYEARNDEDLINENUM
Timecard Earn/Ded EARNDEDEMPLOYEEPERENDTIMECARDCATEGORYLINENUM

Fields: 75

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
PEREND 2 Date Period End Date E A K R 
TIMECARD 3 String*6 Timecard E A K R  Mask: %-6N
LINENUM 4 Integer Line Number E A K R 
CATEGORY 5 Integer Category E A R  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 6 String*6 Earnings/Deduction E A R  Mask: %-6N
EARDEDTYPE 7 Integer Type E A C  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 8 Date Date E A X 
STARTTIME 9 Integer Start Time E A X 
STOPTIME 10 Integer Stop Time E A X 
GLSEG1 11 String*15 G/L Segment One E A X  Mask: %-15N
GLSEG2 12 String*15 G/L Segment Two E A X  Mask: %-15N
GLSEG3 13 String*15 G/L Segment Three E A X  Mask: %-15N
HOURS 14 BCD*4.3 Hours E A X 
CALCMETH 15 Integer Calculation Method E A C  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 16 Integer Base Limit E A C 
CNTBASE 17 BCD*10.3 Pieces/Sales/Base X 
RATE 18 BCD*9.5 E/D/Tax Rate/Amt/Percent X 
PAYORACCR 19 Integer Pay/Accrue Hours E A X  List:3 entries
1 = Payment
2 = Accrual
6 = n/a
EXPACCT 20 String*45 Regular Pay Expense G/L Account E A X D 
LIABACCT 21 String*45 Liability G/L Account X 
OTACCT 22 String*45 Overtime Expense G/L Account X 
SHIFTACCT 23 String*45 Shift Differential G/L Account X 
ASSETACCT 24 String*45 Asset Account X 
OTSCHED 25 String*6 Overtime Schedule P X 
SHIFTSCHED 26 String*6 Shift Differential Schedule P X 
SHIFTNUM 27 Integer Shift Number X 
WCC 28 String*6 Workers Compensation Code P X 
TAXWEEKS 29 BCD*4.3 RESERVED - US Only X 
TAXANNLIZ 30 BCD*5.5 RESERVED - US Only X 
WEEKLYNTRY 31 Boolean INTERNAL USE X 
ENTRYTYPE 32 Integer Entry Type E A C 
POOLEDTIPS 33 BCD*10.3 Pooled Tips X 
DESC 34 String*60 E/D/Tax Description E A C 
GLSEGID1 35 String*6 G/L Segment Name One E A C 
GLSEGDESC1 36 String*60 G/L Segment Description One E A C 
GLSEGID2 37 String*6 G/L Segment Name Two E A C 
GLSEGDESC2 38 String*60 G/L Segment Description Two E A C 
GLSEGID3 39 String*6 G/L Segment Name Three E A C 
GLSEGDESC3 40 String*60 G/L Segment Description Three E A C 
KEYACTION 41 Integer INTERNAL USE - Key Action E A C 
WORKPROV 42 Integer Province of Employment E A C 
PROCESSCMD 43 Integer Process Command Code E A C  List:5 entries
0 = Process Cost Centers
1 = Insert Optional Fields
2 = Update Info to Match Jobs
3 = Clear OT Override Fields
4 = Clear Jobs
NKEMPLOYEE 44 String*12 INTERNAL USE - New Key Employee E A C  Mask: %-12N
NKPEREND 45 Date INTERNAL USE - New Key Period End E A C 
NKTIMECARD 46 String*6 INTERNAL USE - New Key Timecard E A C  Mask: %-6N
NKLINENUM 47 Integer INTERNAL USE - New Key Line Number E A C 
GLSEGID4 48 String*6 RESERVED - G/L Segment Name Four E A C 
GLSEGDESC4 49 String*60 RESERVED - G/L Segment Description Four E A C 
GLSEGID5 50 String*6 RESERVED - G/L Segment Name Five E A C 
GLSEGDESC5 51 String*60 RESERVED - G/L Segment Description Five E A C 
GLSEGID6 52 String*6 RESERVED - G/L Segment Name Six E A C 
GLSEGDESC6 53 String*60 RESERVED - G/L Segment Description Six E A C 
DAYS 100 Integer Days Worked E A X 
WCCGROUP 108 String*6 Workers Comp. Group P X 
VALUES 109 Long Number of Optional Fields E A C 
OTHOURS 110 BCD*4.3 Overtime Hours Override X 
OTRATE 111 BCD*9.5 Overtime Rate Override X 
SWFLSA 112 Boolean Include in Regular Rate OT Calc X 
DISTCODE 113 String*6 Distribution Code E A X  Mask: %-6N
REXPACCT 114 String*45 Employer Expense G/L Account X 
RLIABACCT 115 String*45 Employer Liability G/L Account X 
SWALLOCJOB 116 Boolean Jobs Alloc Based on Calc Base X 
JOBS 117 Long Jobs C X 
WORKCODE 118 String*6 Work Classification Code E A  Mask: %-6N
JOBHOURS 119 BCD*4.3 Total Job Hours E A C X 
JOBBASE 120 BCD*10.3 Total Job Pieces/Sales/Amt C X 
RCALCMETH 121 Integer Employer Calc. Method E A C 
RLIMITBASE 122 Integer Employer Base Limit E A C 
RRATEOVER 123 Boolean Override Employer Rate/Amt/Pct X 
RRATE 124 BCD*9.5 Employer Rate/Amt/Pct X 
DEFRRATE 125 BCD*9.5 Default Employer Rate/Amt/Pct E A C 
GLSEG4 126 String*15 RESERVED - G/L Segment Four X 
GLSEG5 127 String*15 RESERVED - G/L Segment Five X 
GLSEG6 128 String*15 RESERVED - G/L Segment Six X