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