Table: Timecard Detail

Table: UPTCDT
View: UP0032
Record length: 559
Flags: A R 

Keys: 3

Title  Flags  Fields

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

Fields: 51

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period End Date   
TIMECARD  String*6  Timecard  Mask: %-6N
LINENUM  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
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  Earnings/Deduction  Mask: %-6N
EARDEDTYPE  Integer  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  Date   
STARTTIME  Integer  Start Time   
STOPTIME  Integer  Stop Time   
GLSEG1  String*15  G/L Segment One   
GLSEG2  String*15  G/L Segment Two   
GLSEG3  String*15  G/L Segment Three   
HOURS  BCD*4.3  Hours   
CALCMETH  Integer  Calculation Method  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  Integer  Base Limit   
CNTBASE  BCD*10.3  Pieces/Sales/Base   
RATE  BCD*9.5  E/D/Tax Rate/Amt/Percent   
PAYORACCR  Integer  Pay/Accrue Hours  List: 3 entries
1=Payment
2=Accrual
6=n/a
EXPACCT  String*45  Regular Pay Expense G/L Account   
LIABACCT  String*45  Liability G/L Account   
OTACCT  String*45  Overtime Expense G/L Account   
SHIFTACCT  String*45  Shift Differential G/L Account   
ASSETACCT  String*45  Asset Account   
OTSCHED  String*6  Overtime Schedule   
SHIFTSCHED  String*6  Shift Differential Schedule   
SHIFTNUM  Integer  Shift Number   
WCC  String*6  Workers Compensation Code   
TAXWEEKS  BCD*4.3  Weeks Worked   
TAXANNLIZ  BCD*5.5  Tax Annualization Factor   
WEEKLYNTRY  Boolean  INTERNAL USE   
ENTRYTYPE  Integer  Entry Type   
POOLEDTIPS  BCD*10.3  RESERVED - Cdn Only   
DAYS  Integer  Days Worked   
WCCGROUP  String*6  Workers Comp. Group   
VALUES  Long  Number of Optional Fields   
OTHOURS  BCD*4.3  Overtime Hours Override   
OTRATE  BCD*9.5  Overtime Rate Override   
SWFLSA  Boolean  Include in FLSA Overtime Calc   
DISTCODE  String*6  Distribution Code  Mask: %-6N
REXPACCT  String*45  Employer Expense G/L Account   
RLIABACCT  String*45  Employer Liability G/L Account   
SWALLOCJOB  Boolean  Jobs Alloc Based on Calc Base   
JOBS  Long  Jobs   
WORKCODE  String*6  Work Classification Code  Mask: %-6N
JOBHOURS  BCD*4.3  Total Job Hours   
JOBBASE  BCD*10.3  Total Job Pieces/Sales/Amt   

This page was generated on 2009-Nov-19

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