Table: Timecard Job Details

Table: UPTCJB
View: UP0042
Record Length: 431

Flags: A R 

Keys: 3

Title Flags Fields

Timecard Job Line Number EMPLOYEEPERENDTIMECARDLINENUMJOBLINE
Timecard Job EMPLOYEEPERENDTIMECARDLINENUMCONTRACTPROJECTCCATEGORYIDCUSTJOBLINE
Timecard Job Line Number M  EMPLOYEEPERENDTIMECARDLINENUMSTARTTIMEJOBLINE

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