     JCG    J/C Job Estimate Master File (JCG_JobEstimateMasterfile)                 Level: 4.40
            Record Type: 1    J/C Job Estimate Masterfile                            08/28/2009

     File Type: Mkeyed   Key Size: 7    Rec Len: 400     Min Len: 350    Define: Y

     Main Key (KNO=0)EstimateNumber(1,7)
     2nd Key (KNO=1) Description(8,30)+EstimateNumber(1,7)

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Estimate Number . . . . . . . . . . . . EstimateNumber. . . . . . . . Uppercase   *(1,7)
     Description . . . . . . . . . . . . . . Description . . . . . . . . . String      (8,30)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (38,9)
     Job Address 1 . . . . . . . . . . . . . JobAddress1 . . . . . . . . . String      (47,30)
     Job Address 2 . . . . . . . . . . . . . JobAddress2 . . . . . . . . . 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)
     Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase   (192,3)
     Estimate Status (New,Open,Closed) . . . EstimateStatus. . . . . . . . String      (195,1)
     Status Date . . . . . . . . . . . . . . StatusDate. . . . . . . . . . Date        (196,6)
     Last Revision Date. . . . . . . . . . . LastRevisionDate. . . . . . . Date        (202,6)
     Estimated Starting Date . . . . . . . . EstimatedStartingDate . . . . Date        (208,6)
     Estimated Completion Date . . . . . . . EstimatedCompletionDate . . . Date        (214,6)
     Sort Field. . . . . . . . . . . . . . . SortField . . . . . . . . . . Uppercase   (220,10)
     Unit Of Measure Description . . . . . . UnitOfMeasureDesc . . . . . . Uppercase   (230,10)
     Customer Name . . . . . . . . . . . . . CustomerName. . . . . . . . . Uppercase   (240,30)
     Tax Schedule. . . . . . . . . . . . . . TaxSchedule . . . . . . . . . Uppercase   (270,9)
     Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled (279,2)
     Customer Number . . . . . . . . . . . . CustomerNumber. . . . . . . . Account     (281,20)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (301,50)
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0]       0.
     Total . . . . . . . . . . . . . . . . . Total . . . . . . . . . . . . Number      [1]       8.2
     Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [2]       0.
     Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [3]       0.
                                                                                       ________
                                                                          Total Bytes  368