# View: Employee Timecard Job Details

RotoID: UP0044
Table: UPUTJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL: UPUTJB

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
UP0103 | UPUTCD | Employee Timecard Detail | UPUTCD
UP0143 | UPUTJO | Employee TC Jobs Opt Field Values | UPUTJO

## Keys: 2

Title | Fields
--- | ---
Employee Timecard Job Line Numbe | EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE, JOBLINE
Employee Timecard Job | EMPLOYEE, ENDDATE, PAYDATE, EARNDED, UNIQUE, CONTRACT, PROJECT, CCATEGORY, IDCUST, JOBLINE

## Fields: 33

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 |
JOBLINE | 6 | Integer | Job Line Number | E A K R |
CONTRACT | 7 | String*16 | Contract Code | E A R | Mask: %-16C
PROJECT | 8 | String*16 | Project Code | E A R | Mask: %-16N
CCATEGORY | 9 | String*16 | Category Code | E A R | Mask: %-16N
IDCUST | 10 | String*12 | Customer | A R | Mask: %-12C
CURRCODE | 11 | String*3 | Billing Currency | A C | Mask: %-3C
STARTTIME | 12 | Integer | Start Time | E A X |
STOPTIME | 13 | Integer | Stop Time | E A X |
HOURS | 14 | BCD*4.3 | Hours | E A X |
CNTBASE | 15 | BCD*10.3 | Pieces/Sales/Amt | E A X |
BILLTYPE | 16 | Integer | Billing Type | A P X | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 17 | BCD*10.6 | Billing Rate | A X |
ARITEMNO | 18 | String*16 | A/R Item Number | A X | Mask: %-16C
ARUNIT | 19 | String*10 | A/R Item UOM | A X | Mask: %-10C
WIPACCT | 20 | String*45 | Regular WIP/COS Acct | X |
OTWIPACCT | 21 | String*45 | Overtime WIP/COS Acct | X |
STWIPACCT | 22 | String*45 | Shift WIP/COS Acct | X |
VALUES | 23 | Long | Number of Optional Fields | E A C X |
PROJSTYLE | 24 | Integer | Project Style | A C | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | 25 | Integer | Project Type | A C | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
UFMTCONTNO | 26 | String*16 | Unformatted Contract Code | A C | Mask: %-16C
REVREC | 27 | Integer | Accounting Method | A C | List: 9 entries
0 | = |
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
7 | = | Completed Contract
8 | = | Accrual-Basis
COSTCLASS | 28 | Integer | Cost Class | A C | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
CURRDESC | 30 | String*30 | Currency Description | A C |
ALLOWGLOVR | 31 | Boolean | Allow cost center overrides | A C |
PROCESSCMD | 32 | Integer | Process Command Code | E A C | List: 1 entries
0 | = | Insert Optional Fields
RESOURCE | 50 | String*24 | Resource | E A P X | Mask: %-16N
RESDESC | 51 | String*60 | Resource Description | E A X |

This page was generated on 2008-May-02

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