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