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