View: Employee Timecard Job Details

RotoID: CP0044
Table: CPUTJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:CPUTJB

Compositions: 2

RotoID Tables Title DLL

CP0103 CPUTCD Employee Timecard Detail CPUTCD
CP0143 CPUTJO Employee TC Jobs Opt Field Values CPUTJO

Keys: 2

Title Fields

Employee Timecard Job Line Numbe EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUEJOBLINE
Employee Timecard Job EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUECONTRACTPROJECTCCATEGORYIDCUSTJOBLINE

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