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 EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order EMPLOYEE, PEREND, ENTRYSEQ, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

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 

This page was generated on 2023-Aug-31

© 2023 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).