View: Manual Cheque Job Details

RotoID: CP0043
Table: CPMCJB
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:CPMCJB

Compositions: 2

RotoID Tables Title DLL

CP0020 CPMCDT Manual Cheque Detail CPMCDT
CP0142 CPMCJO Manual Cheque Jobs Opt Fields CPMCJO

Keys: 2

Title Fields

Manual Cheque Job Line Number EMPLOYEEBANKCHECKNUMPERENDCHECKDATELINENUMJOBLINE
Manual Cheque Job EMPLOYEEBANKCHECKNUMPERENDCHECKDATELINENUMCONTRACTPROJECTCCATEGORYJOBLINE

Fields: 35

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
BANK 2 String*8 Bank ID E A K R  Mask: %-8N
CHECKNUM 3 BCD*5.0 Cheque Number E A K R 
PEREND 4 Date Period End Date E A K R 
CHECKDATE 5 Date Cheque Date E A K R 
LINENUM 6 Integer Line Number E A K R 
JOBLINE 7 Integer Job Line Number E A K R 
CONTRACT 8 String*16 Contract Code E A R  Mask: %-16C
PROJECT 9 String*16 Project Code E A R  Mask: %-16N
CCATEGORY 10 String*16 Category Code E A R  Mask: %-16N
IDCUST 11 String*12 Customer A R  Mask: %-12C
CURRCODE 12 String*3 Billing Currency A C  Mask: %-3C
STARTTIME 13 Integer Start Time E A X 
STOPTIME 14 Integer Stop Time E A X 
HOURS 15 BCD*4.3 Hours E A X 
CNTBASE 16 BCD*10.3 Pieces/Sales/Amt E A X 
BILLTYPE 17 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 18 BCD*10.6 Billing Rate A X 
ARITEMNO 19 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 20 String*10 A/R Item UOM A X  Mask: %-10C
WIPACCT 21 String*45 Regular WIP/COS Acct E A X 
OTWIPACCT 22 String*45 Overtime WIP/COS Acct E A X 
STWIPACCT 23 String*45 Shift WIP/COS Acct E 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