View: Timecard Job Details

RotoID: UP0042
Table: UPTCJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:UPTCJB

Compositions: 2

RotoID Tables Title DLL

UP0032 UPTCDT Timecard Detail UPTCDT
UP0141 UPTCJO Timecard Jobs Optional Field Values UPTCJO

Keys: 3

Title Fields

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

Fields: 35

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
PEREND 2 Date Period End Date E A K R 
TIMECARD 3 String*6 Timecard E A K R  Mask: %-6N
LINENUM 4 Integer Timecard Line Number E A K R 
JOBLINE 5 Integer Job Line Number E A K R 
CONTRACT 6 String*16 Contract Code E A R  Mask: %-16C
PROJECT 7 String*16 Project Code E A R  Mask: %-16N
CCATEGORY 8 String*16 Category Code E A R  Mask: %-16N
IDCUST 9 String*12 Customer A R  Mask: %-12C
CURRCODE 10 String*3 Billing Currency A C  Mask: %-3C
STARTTIME 11 Integer Start Time E A X 
STOPTIME 12 Integer Stop Time E A X 
HOURS 13 BCD*4.3 Hours E A X 
CNTBASE 14 BCD*10.3 Pieces/Sales/Amt E A X 
BILLTYPE 15 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 16 BCD*10.6 Billing Rate A X 
ARITEMNO 17 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 18 String*10 A/R Item UOM A X  Mask: %-10C
WIPACCT 19 String*45 Regular WIP/COS Acct E A X 
OTWIPACCT 20 String*45 Overtime WIP/COS Acct E A X 
STWIPACCT 21 String*45 Shift WIP/COS Acct E A X 
OTHOURS 22 BCD*4.3 Overtime Hours Override E A X 
OTBILLRATE 23 BCD*10.6 Overtime Billing Rate Override A X 
VALUES 24 Long Number of Optional Fields E A C X 
PROJSTYLE 25 Integer Project Style A C  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 26 Integer Project Type A C  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
UFMTCONTNO 27 String*16 Unformatted Contract Code A C  Mask: %-16C
REVREC 28 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 29 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 
KEYACTION 31 Integer INTERNAL USE - Key Action A C 
ALLOWGLOVR 32 Boolean Allow cost center overrides A C 
PROCESSCMD 33 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