JC8 J/C Daily Job Transaction File (JC8_DailyJobTransaction) Level: 4.40 Record Type: 1 J/C Daily Job Transaction File 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 200 Min Len: 144 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date *(1,6) Source. . . . . . . . . . . . . . . . . Source. . . . . . . . . . . . String *(7,2) Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(9,7) Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(16,9) Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . Uppercase *(25,1) Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(26,2) Vendor Number . . . . . . . . . . . . . VendorNumber. . . . . . . . . Account *(28,7) Sequence No . . . . . . . . . . . . . . SeqNo . . . . . . . . . . . . String *(35,3) Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . String (38,4) Reference / Posting Remark. . . . . . . ReferencePostingRemark. . . . String (42,53) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (95,50) Unit Cost . . . . . . . . . . . . . . . UnitCost. . . . . . . . . . . Number [0] 7.2 Units . . . . . . . . . . . . . . . . . Units . . . . . . . . . . . . Number [1] 7.2 Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number [2] 8.2 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. ________ Total Bytes 184
JC8 J/C Daily Job Transaction File (JC8_DailyJobTransaction) Level: 4.40 Record Type: 2 Posting Restart Record 08/28/2009 File Type: Direct Key Size: 37 Rec Len: 200 Min Len: 144 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
rs1 . . . . . . . . . . . . . . . . . . rs1 . . . . . . . . . . . . . String (1,44) rn1 . . . . . . . . . . . . . . . . . . rn1 . . . . . . . . . . . . . Number [0] 8.3 rn2 . . . . . . . . . . . . . . . . . . rn2 . . . . . . . . . . . . . Number [1] 8.3 rs2 . . . . . . . . . . . . . . . . . . rs2 . . . . . . . . . . . . . String (1,2) ________ Total Bytes 77