View: Check Details

RotoID: UP0049
Table: UPCHKD
Protocol: Detail, Ordered revisions
DLL:UPCHKD

Compositions: 3

RotoID Tables Title DLL

UP0048 UPCHKH Check Header UPCHKH
UP0134 UPCHDO Check Details Optional Fields UPCHDO
UP0056 UPCHJB Check Job Details UPCHJB

Keys: 2

Title Fields

Employee EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENO
Print Order EMPLOYEEPERENDENTRYSEQPCATEGORYPLINETYPEEARNDEDLINETYPELINENO

Fields: 73

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 
ENTRYSEQ 3 Long Entry Sequence E A K R 
CATEGORY 4 Integer Category E A K 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 5 String*6 Earning/Deduction-Tax E A K R  Mask: %-6N
LINETYPE 6 Integer Type E A K R X  List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
LINENO 7 Integer Line Number E A K R 
EARDEDTYPE 8 Integer Earning/Deduction-Tax Type E A C X  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 9 Date Earning/Deduction Date E A X 
HOURS 10 BCD*4.3 Hours E A X 
ECNTBASE 11 BCD*10.3 Employee Pieces/Sales/Base E A X 
ERATE 12 BCD*9.5 Employee Rate/Amt/Pct E A X 
EEXTEND 13 BCD*10.3 Employee Extended Amount E A X 
EREGRATE 14 BCD*9.5 Regular Rate E A X 
RCNTBASE 15 BCD*10.3 Employer Pieces/Base E A X 
RRATE 16 BCD*9.5 Employer Amt/Pct E A X 
REXTEND 17 BCD*10.3 Employer Extended Amount E A X 
EXPACCT 18 String*45 Regular Pay Expense G/L Account E A 
ELIABACCT 19 String*45 Employee Liability G/L Account E A 
RLIABACCT 20 String*45 Employer Liability G/L Account E A 
WCC 21 String*6 Workers' Compensation Code A P X  Mask: %-6N
GLSEG1 22 String*15 Cost Center Segment One E A C X 
GLSEG2 23 String*15 Cost Center Segment Two E A C X 
GLSEG3 24 String*15 Cost Center Segment Three E A C X 
PARTIAL 25 Boolean Detail Was Partially Taken or Not E A 
TAXWEEKS 26 BCD*4.3 Weeks Worked E A X 
TAXEARNS 27 BCD*10.3 Earn Subj to Tax (No Ceiling) E A X 
TXEARNCEIL 28 BCD*10.3 Earn Subj to Tax E A X 
TAXTIPS 29 BCD*10.3 No Ceiling Tips E A X 
TXTIPSCEIL 30 BCD*10.3 Ceiling Tips E A X 
TAXONTIPS 31 BCD*10.3 Tax on Tips E A X 
UNCOLLTAX 32 BCD*10.3 Uncollected Tax on Tips E A X 
PCATEGORY 33 Integer Print Category A C  List:5 entries
1 = CHKD Earnings
2 = CHKD Deductions
3 = CHKD Taxes
4 = CHKD Other
5 = CHKD Benefits
PLINETYPE 34 Integer Print Line Type A C  List:42 entries
11 = CHKD Regular Line
11 = CHKD Overtime Line
11 = CHKD Shift Diff Line
14 = CHKD Disbursed Tips
15 = CHKD Vacation Payment
16 = CHKD Sick Payment
17 = CHKD Comp. Time Payment
21 = CHKD Deduction Entry
31 = CHKD Federal Income Entry
32 = CHKD Federal Insurance Entry
33 = CHKD Federal UI Entry
34 = CHKD Federal Pension Entry
35 = CHKD Federal Health Entry
36 = CHKD Federal Other Entry
41 = CHKD State Income Entry
42 = CHKD State Insurance Entry
43 = CHKD State UI Entry
44 = CHKD State Pension Entry
45 = CHKD State Health Entry
46 = CHKD State Other Entry
51 = CHKD Local Income Entry
52 = CHKD Local Insurance Entry
53 = CHKD Local UI Entry
54 = CHKD Local Pension Entry
55 = CHKD Local Health Entry
56 = CHKD Local Other Entry
61 = CHKD User Income Entry
62 = CHKD User Insurance Entry
63 = CHKD User UI Entry
64 = CHKD User Pension Entry
65 = CHKD User Health Entry
66 = CHKD User Other Entry
71 = CHKD Exp Reimbursement
72 = CHKD Cash Advance
73 = CHKD Reported Tips
74 = CHKD Allocated Tips
75 = CHKD Noncash Advance
76 = CHKD Vac Accrual
77 = CHKD Sick Accrual
78 = CHKD Comp Accrual
81 = CHKD Cash Benefit
82 = CHKD Noncash Benefit
PCONTENTS 35 Integer Print Line Contents A C  List:5 entries
1 = CHKD Employee Only
2 = CHKD Both EmpE And EmpR
3 = CHKD Employer Only
4 = CHKD Historical Entry
5 = CHKD Tax Info Only Entry
TAXNONPER 36 BCD*10.3 RESERVED - Cdn Only E A X 
TAXEARNBD 37 BCD*10.3 RESERVED - Cdn Only E A X 
POOLEDTIPS 38 BCD*10.3 RESERVED - Cdn Only E A X 
DETAILDATE 39 Date Detail Date E A 
STARTTIME 40 Integer Start Time E A X 
STOPTIME 41 Integer Stop Time E A X 
WCCGROUP 42 String*6 Workers Comp. Group A P X  Mask: %-6N
VALUES 43 Long Number of Optional Fields E A C 
SWFLSA 44 Boolean Included in FLSA Overtime Calc E A 
DAYS 45 Integer Days Worked E A X 
OTSCHED 46 String*6 Overtime Schedule E A  Mask: %-6N
OTHOURS 47 BCD*4.3 Overtime Hours Override E A X 
STAMOUNT 48 BCD*10.3 Straight Time Earnings E A 
PREMIUMRT 49 BCD*5.5 Overtime Rate Multiplier E A 
JOBS 50 Long Jobs C X 
WORKCODE 51 String*6 Work Classification Code X 
LOCTAXCODE 52 String*10 Local Tax Code E A X 
WCBASE 53 BCD*10.3 WC Base A X 
WCRATE 54 BCD*6.6 WC Rate A X 
WCEXTEND 55 BCD*10.5 WC Assessment A C X 
WCEXPACCT 56 String*45 WC Expense Account E A X 
WCLIABACCT 57 String*45 WC Liability Account E A X 
CSEFTSTAT 58 Integer Child Support EFT Status E A X  List:2 entries
0 = Not EFTed
1 = EFTed
DISTCODE 59 String*6 Distribution Code E A  Mask: %-6N
DISTRNAME 60 String*15 Distribution Description E A 
GLSEG4 61 String*15 Cost Center Segment Four E A C X 
GLSEG5 62 String*15 Cost Center Segment Fix E A C X 
GLSEG6 63 String*15 Cost Center Segment Six E A C X 
TAXNONDED 64 BCD*10.3 RESERVED - Cdn Only E A X 
TAXREPAY 65 BCD*10.3 RESERVED - Cdn Only E A X 
PROCESSCMD 100 Integer Process Command Code E A C  List:5 entries
0 = No Action
1 = Insert Optional Fields
2 = Calculate Workers' Compensation
3 = Post YTDS
9 = Clear Cache
DTLTYPE 101 Integer Detail Type E A C  List:2 entries
1 = Earning/Deduction
2 = Tax
ECALCMETH 102 Integer Employee Calculation Method E A C 
RCALCMETH 103 Integer Employer Calculation Method E A C 
HTAXSIDE 104 Integer History Entry - Tax Side E A C  List:4 entries
0 = Not Applicable
1 = Employer Tax
2 = Employee Tax
3 = Employee and Employer Tax
TAXEARNSNT 105 BCD*10.3 No Ceiling Wage E A X 
TXEARNCLNT 106 BCD*10.3 Ceiling Wage E A X 
CHECKDATE 107 Date Check Date E A C