Table: Check Details

Table: UPCHKD
View: UP0049
Record length: 481
Flags: A R 

Keys: 2

Title  Flags  Fields

Employee  EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order  EMPLOYEE, PEREND, ENTRYSEQ, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

Fields: 55

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period End Date   
ENTRYSEQ  Long  Entry Sequence   
CATEGORY  Integer  Category  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  String*6  Earning/Deduction-Tax  Mask: %-6N
LINETYPE  Integer  Type  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  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
EARDEDTYPE  Integer  Earning/Deduction-Tax Type  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  Date  Earning/Deduction Date   
HOURS  BCD*4.3  Hours   
ECNTBASE  BCD*10.3  Employee Pieces/Sales/Base   
ERATE  BCD*9.5  Employee Rate/Amt/Pct   
EEXTEND  BCD*10.3  Employee Extended Amount   
EREGRATE  BCD*9.5  Regular Rate   
RCNTBASE  BCD*10.3  Employer Pieces/Base   
RRATE  BCD*9.5  Employer Amt/Pct   
REXTEND  BCD*10.3  Employer Extended Amount   
EXPACCT  String*45  Regular Pay Expense G/L Account   
ELIABACCT  String*45  Employee Liability G/L Account   
RLIABACCT  String*45  Employer Liability G/L Account   
WCC  String*6  Workers' Compensation Code   
GLSEG1  String*15  Cost Center Segment One   
GLSEG2  String*15  Cost Center Segment Two   
GLSEG3  String*15  Cost Center Segment Three   
PARTIAL  Boolean  Detail Was Partially Taken or Not   
TAXWEEKS  BCD*4.3  Weeks Worked   
TAXEARNS  BCD*10.3  Earn Subj to Tax (No Ceiling)   
TXEARNCEIL  BCD*10.3  Earn Subj to Tax   
TAXTIPS  BCD*10.3  No Ceiling Tips   
TXTIPSCEIL  BCD*10.3  Ceiling Tips   
TAXONTIPS  BCD*10.3  Tax on Tips   
UNCOLLTAX  BCD*10.3  Uncollected Tax on Tips   
PCATEGORY  Integer  Print Category  List: 5 entries
1=CHKD Earnings
2=CHKD Deductions
3=CHKD Taxes
4=CHKD Other
5=CHKD Benefits
PLINETYPE  Integer  Print Line Type  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  Integer  Print Line Contents  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  BCD*10.3  RESERVED - Cdn Only   
TAXEARNBD  BCD*10.3  RESERVED - Cdn Only   
POOLEDTIPS  BCD*10.3  RESERVED - Cdn Only   
DETAILDATE  Date  Detail Date   
STARTTIME  Integer  Start Time   
STOPTIME  Integer  Stop Time   
WCCGROUP  String*6  Workers Comp. Group   
VALUES  Long  Number of Optional Fields   
SWFLSA  Boolean  Included in FLSA Overtime Calc   
DAYS  Integer  Days Worked   
OTSCHED  String*6  Overtime Schedule  Mask: %-6N
OTHOURS  BCD*4.3  Overtime Hours Override   
STAMOUNT  BCD*10.3  Straight Time Earnings   
PREMIUMRT  BCD*5.5  Overtime Rate Multiplier   
JOBS  Long  Jobs   
WORKCODE  String*6  Work Classification Code   

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.