Table: Check Job Details

Table: UPCHJB
View: UP0056
Record Length: 519

Flags: A R 

Keys: 1

Title Flags Fields

Check Job Line Number EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINE

Fields: 44

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
PEREND Date Period End Date
ENTRYSEQ Long Entry Sequence
CATEGORY Integer Category List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = State Tax
9 = Local Tax
10 = User Tax
EARNDED String*6 Earning/Deduction Mask: %-6N
LINETYPE Integer Type List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
LINENO Integer 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 WIP/COS Acct
VALUES Long Number of Optional Fields
CURRDESC String*30 Currency Description
UFMTCONTNO String*16 Unformatted Contract Code Mask: %-16C
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
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
BEXTEND BCD*10.3 Extended Billing Amount
EEXTEND BCD*10.3 Employee Extended Amount
GLOVERHEAD String*45 Overhead Account
GLLABOR String*45 Labor Burden Account
FCOVRHDAMT BCD*10.3 (FC) Overhead Amount
SCOVRHDAMT BCD*10.3 Overhead Amount
FCLABORAMT BCD*10.3 (FC) Labor Burden Amount
SCLABORAMT BCD*10.3 Labor Burden Amount
PMTRANSNUM Long PJC Transaction Number
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