JCC J/C Cost Code Master File (JCC_CostCodeMaster) Level: 4.40 Record Type: 1 Cost Code Masterfile (Header) 08/28/2009 File Type: Direct Key Size: 13 Rec Len: 96 Min Len: 28 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Cost Code . . . . . . . . . . . . . . . CodeCost. . . . . . . . . . . Account *(1,9) KeyPad. . . . . . . . . . . . . . . . . KeyPad. . . . . . . . . . . . String *(10,3) Cost Type (Blank=Header). . . . . . . . CostType. . . . . . . . . . . Uppercase *(13,1) Cost Code Description . . . . . . . . . Description . . . . . . . . . String (14,30) Valid Cost Types For This Cost Code . . ValidCostTypesForThisCode . . Uppercase (44,12) Does Job Detail Exist? (Y/N). . . . . . DetailExists. . . . . . . . . Yes/No (56,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (57,7) Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0] 0. Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1] 0. ________ Total Bytes 67
JCC J/C Cost Code Master File (JCC_CostCodeMaster) Level: 4.40 Record Type: 2 Cost Code Masterfile (Detail) 08/28/2009 File Type: Direct Key Size: 13 Rec Len: 96 Min Len: 28 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Cost Code . . . . . . . . . . . . . . . CodeCost. . . . . . . . . . . Account *(1,9) KeyPad. . . . . . . . . . . . . . . . . KeyPad. . . . . . . . . . . . String *(10,3) Cost Type (LMSOBE + 6 User Defined. . . CostType. . . . . . . . . . . Uppercase *(13,1) Bill Method (N/%/ U). . . . . . . . . . BillingMethod . . . . . . . . Uppercase (14,1) N=None, %=%of cost, U=Unit price. . . . . . . . . . . . . . . . . Memo Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . String (15,4) G/L Cost Account. . . . . . . . . . . . GLCostAcct. . . . . . . . . . G/L Account (19,9) Completion Method (Unit, Cost). . . . . CompletionMethod. . . . . . . String (28,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (29,35) Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [0] 7.2 Bill Rate (Price) . . . . . . . . . . . BillingRate . . . . . . . . . Number [1] 7.2 ________ Total Bytes 89