JC_H1 J/C Job History Master File (JC_H1_JobHistoryMasterfile) Level: 4.40 Record Type: 1 J/C Job Masterfile 08/28/2009 File Type: Mkeyed Key Size: 7 Rec Len: 675 Min Len: 383 Define: Y
Main Key (KNO=0)JobNumber(1,7) 2nd Key (KNO=1) JobDescription(8,30)+JobNumber(1,7) 3rd Key (KNO=2) Estimator(182,10)+JobNumber(1,7) 4th Key (KNO=3) Manager(192,10)+JobNumber(1,7) 5th Key (KNO=4) DivisionNumber(312,2)+CustomerNumber(314,20)+JobNumber(1,7) 6th Key (KNO=5) JobType(223,3)+JobNumber(1,7) 7th Key (KNO=6) SortField(289,10)+JobNumber(1,7)
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7) Description . . . . . . . . . . . . . . JobDescription. . . . . . . . String (8,30) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (38,9) Address 1 . . . . . . . . . . . . . . . Address1. . . . . . . . . . . String (47,30) Address 2 . . . . . . . . . . . . . . . Address2. . . . . . . . . . . String (77,30) Comment . . . . . . . . . . . . . . . . Comment . . . . . . . . . . . String (107,30) Contact . . . . . . . . . . . . . . . . ContactName . . . . . . . . . String (137,30) Phone Number. . . . . . . . . . . . . . PhoneNo . . . . . . . . . . . Phone (167,10) Extension . . . . . . . . . . . . . . . Extension . . . . . . . . . . String (177,5) Estimator . . . . . . . . . . . . . . . Estimator . . . . . . . . . . Uppercase (182,10) Manager . . . . . . . . . . . . . . . . Manager . . . . . . . . . . . Uppercase (192,10) Contract Number . . . . . . . . . . . . ContractNumber. . . . . . . . String (202,15) Contract Date . . . . . . . . . . . . . ContractDate. . . . . . . . . Date (217,6) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase (223,3) Accnt Method (Percent Completion Cont)AcctMethod. . . . . . . . . . Uppercase (226,1) Completed Contract) . . . . . . . . . . . . . . . . . . . . . . . . Memo Bill Meth (None, Fixed, Time & Mat.L) . BillingMethod . . . . . . . . Uppercase (227,1) Job Stat (Bid,Cmplt,Hld,Late,Open,Xlosd)JobStatus . . . . . . . . . . Uppercase (228,1) Status Date . . . . . . . . . . . . . . StatusDate. . . . . . . . . . Date (229,6) Estimated Start Date. . . . . . . . . . EstimatedStartDate. . . . . . Date (235,6) Estimated Completion Date . . . . . . . EstimatedCompDate . . . . . . Date (241,6) Actual Start Date . . . . . . . . . . . ActualStartDate . . . . . . . Date (247,6) Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (253,1) Retain Jtd Cost Detail? (Y/N) . . . . . RetainJTDTransDetail. . . . . Yes/No (254,1) Unit Of Measure Description . . . . . . UnitOfMeasureDesc . . . . . . String (255,10) Date Reported . . . . . . . . . . . . . DateReported. . . . . . . . . Date (265,6) Last Cost Transaction Date. . . . . . . LastCostTransDate . . . . . . Date (271,6) Last Bill Date. . . . . . . . . . . . . LastBillDate. . . . . . . . . Date (277,6) Last Payment Date . . . . . . . . . . . LastPaymentDate . . . . . . . Date (283,6) Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . Uppercase (289,10) Calculate Sales Tax? (Y/N). . . . . . . CalcSalesTax. . . . . . . . . Yes/No (299,1) In Billing Selection And Entry. . . . . . . . . . . . . . . . . . . Memo Sales Tax - Next Period . . . . . . . . FutureSalesTax. . . . . . . . String (300,12) Mask Is ########.00-. . . . . . . . . . . . . . . . . . . . . . . . Memo Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (312,2) Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account (314,20) Open String . . . . . . . . . . . . . . _S3 . . . . . . . . . . . . . Open String (334,50) Sales Tax Job To Date . . . . . . . . . JTDSalesTax . . . . . . . . . Number [0] 8.2 Retention Percent . . . . . . . . . . . RetentionPercent. . . . . . . Number [1] 3.2 Total Job Units . . . . . . . . . . . . TotalJobUnits . . . . . . . . Number [2] 8.0 Original Estimate . . . . . . . . . . . OriginalEstimate. . . . . . . Number [3] 8.2 Revised Estimate. . . . . . . . . . . . RevisedEstimate . . . . . . . Number [4] 8.2 Original Contract . . . . . . . . . . . OriginalContract. . . . . . . Number [5] 8.2 Revised Contract. . . . . . . . . . . . RevisedContract . . . . . . . Number [6] 8.2 Actual Percent Complete . . . . . . . . ActualPercentComplete . . . . Number [7] 3.2 Actual Costs Period To Date . . . . . . PTDActualCost . . . . . . . . Number [8] 8.2 Actual Costs Year To Date . . . . . . . YTDActualCosts. . . . . . . . Number [9] 8.2 Actual Costs Job To Date . . . . . . . JTDActualCosts. . . . . . . . Number [10] 8.2 Invoice Billed Period To Date . . . . . PTDInvoiceBilled. . . . . . . Number [11] 8.2 Invoice Billed Year To Date . . . . . . YTDInvoiceBilled. . . . . . . Number [12] 8.2 Invoice Billed Job To Date . . . . . . JTDInvoiceBilled. . . . . . . Number [13] 8.2 Payment Received Period To Date . . . . PTDPaymentReceived. . . . . . Number [14] 8.2 Payment Received Year To Date . . . . . YTDPaymentReceived. . . . . . Number [15] 8.2 Payment Received Job To Date. . . . . . JTDPaymentReceived. . . . . . Number [16] 8.2 Retention Balance . . . . . . . . . . . RetentionBalance. . . . . . . Number [17] 8.2 Deferred Revenue (Accntg Methd = C) . . DeferredRevenue . . . . . . . Number [18] 8.2 Unbilled Cost . . . . . . . . . . . . . UnbilledCost. . . . . . . . . Number [19] 8.2 Actual Costs Next Period. . . . . . . . FutureActualCosts . . . . . . Number [20] 8.2 Invoice Billed Next Period. . . . . . . FutureInvoiceBilled . . . . . Number [21] 8.2 Payment Received Next Period. . . . . . FuturePaymentReceived . . . . Number [22] 8.2 ________ Total Bytes 672