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