# Table: Timecard Job Details

Table: UPTCJB
View: UP0042
Record length: 431
Flags: A R

## Keys: 3

Title | Flags | Fields
--- | --- | ---
Timecard Job Line Number |  | EMPLOYEE, PEREND, TIMECARD, LINENUM, JOBLINE
Timecard Job |  | EMPLOYEE, PEREND, TIMECARD, LINENUM, CONTRACT, PROJECT, CCATEGORY, IDCUST, JOBLINE
Timecard Job Line Number | M | EMPLOYEE, PEREND, TIMECARD, LINENUM, STARTTIME, JOBLINE

## Fields: 35

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
PEREND | Date | Period End Date |
TIMECARD | String*6 | Timecard | Mask: %-6N
LINENUM | Integer | Timecard Line Number |
JOBLINE | Integer | Job Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CONTRACT | String*16 | Contract Code | Mask: %-16C
PROJECT | String*16 | Project Code | Mask: %-16N
CCATEGORY | String*16 | Category Code | Mask: %-16N
IDCUST | String*12 | Customer | Mask: %-12C
CURRCODE | String*3 | Billing Currency | Mask: %-3C
STARTTIME | Integer | Start Time |
STOPTIME | Integer | Stop Time |
HOURS | BCD*4.3 | Hours |
CNTBASE | BCD*10.3 | Pieces/Sales/Amt |
BILLTYPE | Integer | Billing Type | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | BCD*10.6 | Billing Rate |
ARITEMNO | String*16 | A/R Item Number | Mask: %-16C
ARUNIT | String*10 | A/R Item UOM | Mask: %-10C
WIPACCT | String*45 | Regular WIP/COS Acct |
OTWIPACCT | String*45 | Overtime WIP/COS Acct |
STWIPACCT | String*45 | Shift WIP/COS Acct |
OTHOURS | BCD*4.3 | Overtime Hours Override |
OTBILLRATE | BCD*10.6 | Overtime Billing Rate Override |
VALUES | Long | Number of Optional Fields |
PROJSTYLE | Integer | Project Style | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | Integer | Project Type | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
UFMTCONTNO | String*16 | Unformatted Contract Code | Mask: %-16C
REVREC | Integer | Accounting Method | 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 | Integer | Cost Class | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | String*24 | Resource | Mask: %-16N
RESDESC | String*60 | Resource Description |

This page was generated on 2008-May-02

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