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