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 EMPLOYEE, PEREND, TIMECARD, LINENUM, JOBLINE
Timecard Job EMPLOYEE, PEREND, TIMECARD, LINENUM, CONTRACT, PROJECT, CCATEGORY, IDCUST, JOBLINE
Timecard Job Line Number EMPLOYEE, PEREND, TIMECARD, LINENUM, STARTTIME, JOBLINE

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