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