Table: Check Details

Table: UPCHKD
View: UP0049
Record length: 423
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: 42


Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period End Date   
ENTRYSEQ  Long  Entry Sequence By Employee   
CATEGORY  Integer  Category code  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  Earnings/Deduction  Mask: %-6N
LINETYPE  Integer  Presentation List Type Pay  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  Unique Key Field   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
EARDEDTYPE  Integer  Earnings/Deduction 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  Earnings/Deduction Date   
HOURS  BCD*4.3  Earnings/Deduction Hours   
ECNTBASE  BCD*10.3  Employee Amt, Cnt, Base or Sales   
ERATE  BCD*9.5  Employee Hourly Rate or Percent   
EEXTEND  BCD*10.3  Employee Dollar Amounts   
EREGRATE  BCD*9.5  Base Regular Rate for OT   
RCNTBASE  BCD*10.3  Employer Amt, Cnt, Base or Sales   
RRATE  BCD*9.5  Employer Hourly Rate or Percent   
REXTEND  BCD*10.3  Employer Dollar Amounts   
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 No   
TAXWEEKS  BCD*4.3  Weeks Worked for the Taxing Auth   
TAXEARNS  BCD*10.3  Taxable Earnings   
TXEARNCEIL  BCD*10.3  Taxable Earnings Ceiling   
TAXTIPS  BCD*10.3  Taxable Tips Without a Ceiling   
TXTIPSCEIL  BCD*10.3  Taxable Tips With a Ceiling   
TAXONTIPS  BCD*10.3  Amount of Tax Calculated on Tips   
UNCOLLTAX  BCD*10.3  For Uncollected SS/Med   
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: 44 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
18=
21=CHKD Federal Income Entry
31=CHKD Federal Insurance Entry
32=CHKD Federal UI Entry
33=CHKD Federal Pension Entry
34=CHKD Federal Health Entry
35=CHKD Federal Other Entry
36=CHKD State Income Entry
41=CHKD State Insurance Entry
42=CHKD State UI Entry
43=CHKD State Pension Entry
44=CHKD State Health Entry
45=CHKD State Other Entry
46=CHKD Local Income Entry
51=CHKD Local Insurance Entry
52=CHKD Local UI Entry
53=CHKD Local Pension Entry
54=CHKD Local Health Entry
55=CHKD Local Other Entry
56=CHKD User Income Entry
61=CHKD User Insurance Entry
62=CHKD User UI Entry
63=CHKD User Pension Entry
64=CHKD User Health Entry
65=CHKD User Other Entry
66=CHKD Exp Reimbursement
71=CHKD Cash Advance
72=CHKD Reported Tips
73=CHKD Allocated Tips
74=CHKD Noncash Advance
75=CHKD Vac Accrual
76=CHKD Sick Accrual
77=CHKD Comp Accrual
78=CHKD Cash Benefit
78=CHKD Noncash Benefit
81=Include List
82=Include List
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  Taxable Non-periodic Earnings   
TAXEARNBD  BCD*10.3  Subject to Income tax befor dedu   
POOLEDTIPS  BCD*10.3  RESERVED - Cdn Only   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.