View: Cheque Job Details

RotoID: CP0056
Table: CPCHJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:CPCHJB

Compositions: 2

RotoID Tables Title DLL

CP0049 CPCHKD Cheque Details CPCHKD
CP0144 CPCHJO Cheque Jobs Optional Fields Values CPCHJO

Keys: 1

Title Fields

Cheque Job Line Number EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENOJOBLINE

Fields: 41

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 
ENTRYSEQ 3 Long Entry Sequence E A K R 
CATEGORY 4 Integer Category E A K R  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARNDED 5 String*6 Earning/Deduction E A K R  Mask: %-6N
LINETYPE 6 Integer Type E A K R  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 7 Integer Line Number E A K R 
JOBLINE 8 Integer Job Line Number E A K R 
CONTRACT 9 String*16 Contract Code E A R  Mask: %-16C
PROJECT 10 String*16 Project Code E A R  Mask: %-16N
CCATEGORY 11 String*16 Category Code E A R  Mask: %-16N
IDCUST 12 String*12 Customer E A  Mask: %-12C
CURRCODE 13 String*3 Billing Currency E A  Mask: %-3C
STARTTIME 14 Integer Start Time E A 
STOPTIME 15 Integer Stop Time E A 
HOURS 16 BCD*4.3 Hours E A 
CNTBASE 17 BCD*10.3 Pieces/Sales/Amt E A 
BILLTYPE 18 Integer Billing Type E A P  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 19 BCD*10.6 Billing Rate E A 
ARITEMNO 20 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 21 String*10 A/R Item UOM E A  Mask: %-10C
WIPACCT 22 String*45 WIP/COS Acct E A 
VALUES 23 Long Number of Optional Fields E A C 
CURRDESC 24 String*30 Currency Description E A 
UFMTCONTNO 25 String*16 Unformatted Contract Code E A  Mask: %-16C
PROJSTYLE 26 Integer Project Style E A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 27 Integer Project Type E A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 28 Integer Accounting Method E A  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 29 BCD*10.3 Extended Billing Amount E A 
EEXTEND 30 BCD*10.3 Employee Extended Amount E A 
GLOVERHEAD 31 String*45 Overhead Account E A 
GLLABOR 32 String*45 Labor Burden Account E A 
FCOVRHDAMT 33 BCD*10.3 (FC) Overhead Amount E A 
SCOVRHDAMT 34 BCD*10.3 Overhead Amount E A 
FCLABORAMT 35 BCD*10.3 (FC) Labor Burden Amount E A 
SCLABORAMT 36 BCD*10.3 Labor Burden Amount E A 
PMTRANSNUM 37 Long PJC Transaction Number E A 
COSTCLASS 38 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 39 String*24 Resource E A P  Mask: %-16N
RESDESC 40 String*60 Resource Description E A 
PROCESSCMD 100 Integer Process Command Code E A C  List:2 entries
0 = No Action
1 = Insert Optional Fields