Table: Employee Timecard Detail

Table: UPUTCD
View: UP0103
Record length: 129
Flags: A R 

Keys: 2

Title  Flags  Fields

Timecard Date  EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE
Timecard Earning  EMPLOYEE, ENDDATE, EARNDED, UNIQUE, PAYDATE

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   

This page was generated on 2009-Nov-19

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