# Table: Employee Timecard Detail

Table: CPUTCD
View: CP0103
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 | Pooled Tips |
TIPSBASE | BCD*10.3 | Tips Based On |
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.