     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