Table: Employee Timecard Job Details

Table: CPUTJB
View: CP0044
Record Length: 422

Flags: A R 

Keys: 2

Title Flags Fields

Employee Timecard Job Line Numbe EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUEJOBLINE
Employee Timecard Job EMPLOYEEENDDATEPAYDATEEARNDEDUNIQUECONTRACTPROJECTCCATEGORYIDCUSTJOBLINE

Fields: 34

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
ENDDATE Date End Date
PAYDATE Date Pay Date
EARNDED String*6 Earning/Expense/Tip Code Mask: %-6N
UNIQUE Integer Unique Key Field
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
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