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