JC1_JobMaster 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$+"/JC1"+%C$+".soa"
Fld Column Name M/L TUR Description/Notes Class
1 JobNumber . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . . FmtType:CHARNUM 2 JobDescription. . . . . . . . 30 SNN Description . . . . . . . . . . 3 _S3 . . . . . . . . . . . . . 9 SNN Open String . . . . . . . . . . 4 Address1. . . . . . . . . . . 30 SNN Address 1 . . . . . . . . . . . 5 Address2. . . . . . . . . . . 30 SNN Address 2 . . . . . . . . . . . 6 Comment . . . . . . . . . . . 30 SNN Comment . . . . . . . . . . . . 7 ContactName . . . . . . . . . 30 SNN Contact . . . . . . . . . . . . 8 PhoneNo . . . . . . . . . . . 10 SNN Phone Number. . . . . . . . . .Phone 9 Extension . . . . . . . . . . 5 SNN Extension . . . . . . . . . . . 10 Estimator . . . . . . . . . . 10 SYN Estimator . . . . . . . . . . . 11 Manager . . . . . . . . . . . 10 SYN Manager . . . . . . . . . . . . 12 ContractNumber. . . . . . . . 15 SNN Contract Number . . . . . . . . 13 ContractDate. . . . . . . . . 6 SNN Contract Date . . . . . . . . .DATE*MAS90 14 JobType . . . . . . . . . . . 3 SYN Job Type. . . . . . . . . . . . 15 AcctMethod. . . . . . . . . . 1 SYN Accnt Method (Percent Completio Notes: Completed Contract) 16 BillingMethod . . . . . . . . 1 SYN Bill Meth (None, Fixed, Time & 17 JobStatus . . . . . . . . . . 1 SYN Job Stat (Bid,Cmplt,Hld,Late,Op 18 StatusDate. . . . . . . . . . 6 SNN Status Date . . . . . . . . . .DATE*MAS90 19 EstimatedStartDate. . . . . . 6 SNN Estimated Start Date. . . . . .DATE*MAS90 20 EstimatedCompDate . . . . . . 6 SNN Estimated Completion Date . . .DATE*MAS90 21 ActualStartDate . . . . . . . 6 SNN Actual Start Date . . . . . . .DATE*MAS90 22 _S1 . . . . . . . . . . . . . 1 SNN Open String . . . . . . . . . . 23 RetainJTDTransDetail. . . . . 1 SYN Retain Jtd Cost Detail? (Y/N) .YesNo 24 UnitOfMeasureDesc . . . . . . 10 SNN Unit Of Measure Description . . 25 DateReported. . . . . . . . . 6 SNN Date Reported . . . . . . . . .DATE*MAS90 26 LastCostTransDate . . . . . . 6 SNN Last Cost Transaction Date. . .DATE*MAS90 27 LastBillDate. . . . . . . . . 6 SNN Last Bill Date. . . . . . . . .DATE*MAS90 28 LastPaymentDate . . . . . . . 6 SNN Last Payment Date . . . . . . .DATE*MAS90 29 SortField . . . . . . . . . . 10 SYN Sort Field. . . . . . . . . . . 30 CalcSalesTax. . . . . . . . . 1 SYN Calculate Sales Tax? (Y/N). . .YesNo Notes: In Billing Selection And Entry 31 FutureSalesTax. . . . . . . . 12 SNN Sales Tax - Next Period . . . . Notes: Mask Is ########.00- 32 DivisionNumber. . . . . . . . 2 SNN Division Number . . . . . . . . Mask:00 33 CustomerNumber. . . . . . . . 20 SNN Customer Number . . . . . . . .Accnt 34 _S2 . . . . . . . . . . . . . 50 SNN Open String . . . . . . . . . . 35 JTDSalesTax . . . . . . . . . 12.2 NNN Sales Tax Job To Date . . . . . Mask:#######0.00 36 RetentionPercent. . . . . . . 7.2 NNN Retention Percent . . . . . . . Mask:##0.00 37 TotalJobUnits . . . . . . . . 10.0 NNN Total Job Units . . . . . . . . Mask:#######0 38 OriginalEstimate. . . . . . . 12.2 NNN Original Estimate . . . . . . . Mask:#######0.00 39 RevisedEstimate . . . . . . . 12.2 NNN Revised Estimate. . . . . . . . Mask:#######0.00 40 OriginalContract. . . . . . . 12.2 NNN Original Contract . . . . . . . Mask:#######0.00 41 RevisedContract . . . . . . . 12.2 NNN Revised Contract. . . . . . . . Mask:#######0.00 42 ActualPercentComplete . . . . 7.2 NNN Actual Percent Complete . . . . Mask:##0.00 43 PTDActualCost . . . . . . . . 12.2 NNN Actual Costs Period To Date . . Mask:#######0.00 44 YTDActualCosts. . . . . . . . 12.2 NNN Actual Costs Year To Date . . . Mask:#######0.00 45 JTDActualCosts. . . . . . . . 12.2 NNN Actual Costs Job To Date . . . Mask:#######0.00 46 PTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Period To Date . Mask:#######0.00 47 YTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Year To Date . . Mask:#######0.00 48 JTDInvoiceBilled. . . . . . . 12.2 NNN Invoice Billed Job To Date . . Mask:#######0.00 49 PTDPaymentReceived. . . . . . 12.2 NNN Payment Received Period To Date Mask:#######0.00 50 YTDPaymentReceived. . . . . . 12.2 NNN Payment Received Year To Date . Mask:#######0.00 51 JTDPaymentReceived. . . . . . 12.2 NNN Payment Received Job To Date. . Mask:#######0.00 52 RetentionBalance. . . . . . . 12.2 NNN Retention Balance . . . . . . . Mask:#######0.00 53 DeferredRevenue . . . . . . . 12.2 NNN Deferred Revenue (Accntg Methd Mask:#######0.00 54 UnbilledCost. . . . . . . . . 12.2 NNN Unbilled Cost . . . . . . . . . Mask:#######0.00 55 FutureActualCosts . . . . . . 12.2 NNN Actual Costs Next Period. . . . Mask:#######0.00 56 FutureInvoiceBilled . . . . . 12.2 NNN Invoice Billed Next Period. . . Mask:#######0.00 57 FuturePaymentReceived . . . . 12.2 NNN Payment Received Next Period. . Mask:#######0.00