JCB J/C Burden/Overhead Master File (JCB_BurdenRate) Level: 4.40 Record Type: 1 J/C Burden/Overhead Rate File (Burden) 08/28/2009 File Type: Direct Key Size: 5 Rec Len: 64 Min Len: 33 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("B" = Burden Record) . . . RecordType. . . . . . . . . . Uppercase *(1,1) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(2,3) Cost Type (Blank) . . . . . . . . . . . CostType. . . . . . . . . . . Uppercase *(5,1) Burden Cost Code. . . . . . . . . . . . BurdenOverheadCostCode. . . . Account (6,9) Burden Cost Type. . . . . . . . . . . . BurdenOverheadCostType. . . . Uppercase (15,1) G/L Burden Debit Account. . . . . . . . GLDebitAcctNumber . . . . . . G/L Account (16,9) G/L Burden Credit Account . . . . . . . GLCreditAcctNumber. . . . . . G/L Account (25,9) Calc Method (Hourly, Percentage). . . . CalcMethod. . . . . . . . . . Uppercase (34,1) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (35,9) Burden Rate . . . . . . . . . . . . . . BurdenOverheadRate. . . . . . Number [0] 5.4 ________ Total Bytes 57
JCB J/C Burden/Overhead Master File (JCB_BurdenRate) Level: 4.40 Record Type: 2 J/C Burden/Overhead Rate File (Overhead) 08/28/2009 File Type: Direct Key Size: 5 Rec Len: 64 Min Len: 33 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Record Type ("O" = Overhead Record) . . RecordType. . . . . . . . . . Uppercase *(1,1) Job Type. . . . . . . . . . . . . . . . JobType . . . . . . . . . . . Uppercase *(2,3) Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . Uppercase *(5,1) Overhead Cost Code. . . . . . . . . . . BurdenOverheadCostCode. . . . Account (6,9) Overhead Cost Type. . . . . . . . . . . BurdenOverheadCostType. . . . Uppercase (15,1) G/L Overhead Debit Account. . . . . . . GLDebitAcctNumber . . . . . . G/L Account (16,9) G/L Overhead Credit Account . . . . . . GLCreditAcctNumber. . . . . . G/L Account (25,9) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (34,10) Overhead Rate . . . . . . . . . . . . . BurdenOverheadRate. . . . . . Number [0] 5.4 ________ Total Bytes 57