# View: Employee Timecard Detail

RotoID: UP0103
Tables: UPUTCD
DLL: UPUTCD

## Compositions: 2

RotoID | Title | Tables | DLL
--- | --- | --- | ---
UP0102 | Employee Timecard Header | UPUTCH | UPUTCH
UP0132 | Empl Timecard Details Opt Flds | UPUTDO | UPUTDO

## Keys: 2

Title | Fields
--- | ---
Timecard Date | EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE
Timecard Earning | EMPLOYEE, ENDDATE, EARNDED, UNIQUE, PAYDATE

## Fields: 15

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
ENDDATE | 2 | Date | End Date | E A K R |
PAYDATE | 3 | Date | Pay Date | E A K R |
EARNDED | 4 | String*6 | Earning/Expense/Tip Code | E A K R | Mask: %-6N
UNIQUE | 5 | Integer | Unique Key Field | E A K R |
CATEGORY | 6 | Integer | Category | A C | List: 3 entries
0 | = | Hours
1 | = | Tips
2 | = | Expense
STARTTIME | 7 | Integer | Start Time | E A X |
STOPTIME | 8 | Integer | Stop Time | E A X |
HOURS | 9 | BCD*4.3 | Hours Worked | E A X |
TIPSEXP | 10 | BCD*9.5 | Tips/Expense Amount | X |
SHIFTSCHED | 11 | String*6 | Shift Differential Schedule | E A X | Mask: %-6N
SHIFTNUM | 12 | Integer | Shift Number | X |
VALUES | 13 | Long | Number of Optional Fields | E A C |
DOW | 20 | Integer | Day of the Week | A | List: 7 entries
1 | = | Sunday
2 | = | Monday
3 | = | Tuesday
4 | = | Wednesday
5 | = | Thursday
6 | = | Friday
7 | = | Saturday
PROCESSCMD | 21 | Integer | Process Command Code | E A C | List: 2 entries
0 | = | No Action
1 | = | Insert Optional Fields

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.