Table: Employee Timecard Detail

Table: UPUTCD
View: UP0103
Record Length: 129

Flags: A R 

Keys: 2

Title Flags Fields

Timecard Date EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUE
Timecard Earning EMPLOYEEENDDATEEARNDEDUNIQUEPAYDATE

Fields: 23

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
ENDDATE Date End Date
PAYDATE Date Pay Date
EARNDED String*6 Earning/Exp/Tip/Accrual Code Mask: %-6N
UNIQUE Integer Unique Key Field
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CATEGORY Integer Category List:7 entries
0 = Hours
1 = Tips
2 = Expense
3 = Piece Rate
4 = Sales Commissions
5 = Sick Accrual Payment
6 = Vacation Accrual Payment
STARTTIME Integer Start Time
STOPTIME Integer Stop Time
HOURS BCD*4.3 Hours Worked
TIPSEXP BCD*9.5 Tips/Expense/Pieces/Sales Amount
SHIFTSCHED String*6 Shift Differential Schedule Mask: %-6N
SHIFTNUM Integer Shift Number
VALUES Long Number of Optional Fields
POOLEDTIPS BCD*10.3 RESERVED - Cdn Only
TIPSBASE BCD*10.3 RESERVED - Cdn Only
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