Table: Timecard Detail

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

Keys: 2


Title  Flags  Fields

Timecard Employee   EMPLOYEE, PEREND, TIMECARD, CATEGORY, EARNDED, UNIQUE
  EARNDED, EMPLOYEE, PEREND, TIMECARD, CATEGORY, UNIQUE

Fields: 45


Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period end date   
TIMECARD  String*6  Timecard  Mask: %-6N
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
UNIQUE  Integer  Unique Key Field   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
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  Mask: %-15N
GLSEG2  String*15  G/L Segment Two  Mask: %-15N
GLSEG3  String*15  G/L Segment Three  Mask: %-15N
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/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   
REGHOURS  BCD*4.3  Regular Hours   
OTHOURS1  BCD*4.3  Overtime Hours 1   
OTHOURS2  BCD*4.3  Overtime Hours 2   
OTHOURS3  BCD*4.3  Overtime Hours 3   
OTHOURS4  BCD*4.3  Overtime Hours 4   
OTHOURS5  BCD*4.3  Overtime Hours 5   
OTHOURS6  BCD*4.3  Overtime Hours 6   

This page was generated on 2003-May-05

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