View: Timecard Detail

RotoID: UP0032
Table: UPTCDT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:UPTCDT

Compositions: 3

RotoID Tables Title DLL
UP0031 UPTCHD Timecard Header UPTCHD
UP0128 UPTCDO Timecard Details Optional Field Values UPTCDO
UP0042 UPTCJB Timecard Job Details UPTCJB

Keys: 3

Title Fields
Timecard EMPLOYEE, PEREND, TIMECARD, LINENUM
Timecard Employee EMPLOYEE, PEREND, TIMECARD, CATEGORY, EARNDED, LINENUM
Timecard Earn/Ded EARNDED, EMPLOYEE, PEREND, TIMECARD, CATEGORY, LINENUM

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 = State 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:15 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Compensatory Time
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Unemployment 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 Weeks Worked E A X 
TAXANNLIZ 30 BCD*5.5 Tax Annualization Factor E A X 
WEEKLYNTRY 31 Boolean INTERNAL USE X 
ENTRYTYPE 32 Integer Entry Type E A C 
POOLEDTIPS 33 BCD*10.3 RESERVED - Cdn Only 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 RESERVED - Cdn Only 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 FLSA Overtime 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 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).