JC_Job J/C Job Master File Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: N/A
SQL Def: N SysDB: N "MAS_"+%C$+"/JC"+%C$+"/JC_Job.M4T"
KPRIMARY: JobNo
KDESCRIPTION: JobDesc+JobNo
KESTIMATOR: Estimator+JobNo
KMANAGER: Manager+JobNo
KCUSTOMER: ARDivisionNo+CustomerNo+JobNo
KTYPE: JobType+JobNo
KSORT: SortField+JobNo
Fld Column Name M/L TUR Description/Notes Class
1 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO
FmtType:CHARNUM
2 JobDesc . . . . . . . . . . . 30 SNN Job Description . . . . . . . .DESCRIPTION
3 ARDivisionNo. . . . . . . . . 2 SYN A/R Division Number . . . . . .ARDIVISION
Mask:00
4 CustomerNo. . . . . . . . . . 20 SNN Customer Number . . . . . . . .CUSTOMERNO
FmtType:MASTERNUMC ChngTag:Re
place1/ARDivisionNo$
5 Address1. . . . . . . . . . . 30 SNN Address Line 1. . . . . . . . .ADDRESSLINE
6 Address2. . . . . . . . . . . 30 SNN Address Line 2. . . . . . . . .ADDRESSLINE
7 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . .COMMENT30
8 ContactName . . . . . . . . . 30 SNN Contact Name. . . . . . . . . .
9 TelephoneNo . . . . . . . . . 17 SNN Telephone No. . . . . . . . . .TELEPHONENO
10 TelephoneExt. . . . . . . . . 5 SNN Telephone Ext . . . . . . . . .TELEPHONEEXT
11 Estimator . . . . . . . . . . 10 SYN Estimator . . . . . . . . . . .
12 Manager . . . . . . . . . . . 10 SYN Manager . . . . . . . . . . . .
13 ContractNumber. . . . . . . . 15 SNN Contract Number . . . . . . . .
14 ContractDate. . . . . . . . . 8 SNN Contract Date . . . . . . . . .DATE
15 JobType . . . . . . . . . . . 3 SYN Job Type. . . . . . . . . . . .
16 AccountingMethod. . . . . . . 1 SYN Accnt Method (Percent Completio
Notes: Completed Contract
17 BillingMethod . . . . . . . . 1 SYN Bill Meth (None, Fixed, Time &
Valid:N,F,T
18 JobStatus . . . . . . . . . . 1 SYN Job Stat (Bid,Cmplt,Hld,Late,Op
Valid:B,C,H,L,O,X
19 StatusDate. . . . . . . . . . 8 SNN Status Date . . . . . . . . . .DATE
20 EstimatedStartDate. . . . . . 8 SNN Estimated Start Date. . . . . .DATE
21 EstimatedCompDate . . . . . . 8 SNN Estimated Completion Date . . .DATE
22 ActualStartDate . . . . . . . 8 SNN Actual Start Date . . . . . . .DATE
23 RetainJTDTransDetail. . . . . 1 SYN Retain Jtd Cost Detail. . . . .YESNO
DfltVal:N Valid:Y,N
24 UnitOfMeasureDesc . . . . . . 10 SNN Unit Of Measure Description . .
25 DateReported. . . . . . . . . 8 SNN Date Reported . . . . . . . . .DATE
26 LastCostTransDate . . . . . . 8 SNN Last Cost Transaction Date. . .DATE
27 LastBillDate. . . . . . . . . 8 SNN Last Bill Date. . . . . . . . .DATE
28 LastPaymentDate . . . . . . . 8 SNN Last Payment Date . . . . . . .DATE
29 SortField . . . . . . . . . . 10 SYN Sort Field. . . . . . . . . . .
30 CalculateSalesTax . . . . . . 1 SYN Calculate Sales Tax . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
In Billing Selection And
Entry
31 FutureSalesTax. . . . . . . . 12 SNN Sales Tax - Next Period . . . .
Mask:########.00- Notes:
32 JTDSalesTax . . . . . . . . . 12.2 NNN Sales Tax Job To Date . . . . .
Mask:#######0.00
33 RetentionPercent. . . . . . . 7.2 NNN Retention Percent . . . . . . .
Mask:##0.00
34 TotalJobUnits . . . . . . . . 10.0 NNN Total Job Units . . . . . . . .
Mask:#######0
35 OriginalEstimate. . . . . . . 12.2 NNN Original Estimate . . . . . . .
Mask:#######0.00
36 RevisedEstimate . . . . . . . 12.2 NNN Revised Estimate. . . . . . . .
Mask:#######0.00
37 OriginalContract. . . . . . . 12.2 NNN Original Contract . . . . . . .
Mask:#######0.00
38 RevisedContract . . . . . . . 12.2 NNN Revised Contract. . . . . . . .
Mask:#######0.00
39 ActualPercentComplete . . . . 7.2 NNN Actual Percent Complete . . . .
Mask:##0.00
40 PTDActualCosts. . . . . . . . 12.2 NNN Actual Costs Period To Date . .
Mask:#######0.00
41 YTDActualCosts. . . . . . . . 12.2 NNN Actual Costs Year To Date . . .
Mask:#######0.00
42 JTDActualCosts. . . . . . . . 12.2 NNN Actual Costs Job To Date . . .
Mask:#######0.00
43 PTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Period To Date .
Mask:#######0.00
44 YTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Year To Date . .
Mask:#######0.00
45 JTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Job To Date . .
Mask:#######0.00
46 PTDPaymentReceived. . . . . . 12.2 NNN Payment Received Period To Date
Mask:#######0.00
47 YTDPaymentReceived. . . . . . 12.2 NNN Payment Received Year To Date .
Mask:#######0.00
48 JTDPaymentReceived. . . . . . 12.2 NNN Payment Received Job To Date. .
Mask:#######0.00
49 RetentionBalance. . . . . . . 12.2 NNN Retention Balance . . . . . . .
Mask:#######0.00
50 DeferredRevenue . . . . . . . 12.2 NNN Deferred Revenue (Accntg Methd
Mask:#######0.00
51 UnbilledCost. . . . . . . . . 12.2 NNN Unbilled Cost . . . . . . . . .
Mask:#######0.00
52 FutureActualCosts . . . . . . 12.2 NNN Actual Costs Next Period. . . .
Mask:#######0.00
53 FutureInvoiceBilled . . . . . 12.2 NNN Invoice Billed Next Period. . .
Mask:#######0.00
54 FuturePaymentReceived . . . . 12.2 NNN Payment Received Next Period. .
Mask:#######0.00
55 DateCreated . . . . . . . . . 8 SNY Date Created. . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
56 TimeCreated . . . . . . . . . 8 SNY Time Created. . . . . . . . . .
Read Only:Y
57 UserCreatedKey. . . . . . . . 10 SYY User Created Key. . . . . . . .USER
Read Only:Y Mask:0000000000
58 DateUpdated . . . . . . . . . 8 SNN Date Updated. . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
59 TimeUpdated . . . . . . . . . 8 SNN Time Updated. . . . . . . . . .
Read Only:Y
60 UserUpdatedKey. . . . . . . . 10 SNN User Updated Key. . . . . . . .USER
Read Only:Y Mask:0000000000