JC_H3 J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
Record Type: 1 J/C Cost Trans File (Contract Chnge/Ord) 08/28/2009
File Type: Direct Key Size: 40 Rec Len: 200 Min Len: 144 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7)
Rec Type (0=Contract Change Orders) . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
Cost Code (Not Used). . . . . . . . . . CostCode. . . . . . . . . . . Account *(9,9)
Cost Type (Not Used). . . . . . . . . . CostType. . . . . . . . . . . String *(18,1)
Division Number (Not Used). . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
Vendor Number (Not Used). . . . . . . . VendorNumber. . . . . . . . . String *(21,7)
Cost Detail Type (Not Used) . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date *(29,6)
Source Code ("CO"=Change Order) . . . . SourceCode. . . . . . . . . . String *(35,2)
Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (41,1)
Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String (42,53)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (95,50)
Trans Units . . . . . . . . . . . . . . TransactionUnits. . . . . . . Number [0] 7.2
Transaction Unit Cost . . . . . . . . . TransactionUnitCost . . . . . Number [1] 7.2
Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number [2] 8.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
________
Total Bytes 184
JC_H3 J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
Record Type: 2 J/C Cost Transaction File (Bill Detail) 08/28/2009
File Type: Direct Key Size: 40 Rec Len: 200 Min Len: 144 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7)
Rec Type (1=Bill Detail). . . . . . . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
Cost Code (Not Used). . . . . . . . . . CostCode. . . . . . . . . . . Account *(9,9)
Cost Type (Not Used). . . . . . . . . . CostType. . . . . . . . . . . String *(18,1)
Division Number (Not Used). . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
Vendor Number (Not Used). . . . . . . . VendorNumber. . . . . . . . . String *(21,7)
Cost Detail Type (Not Used) . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date *(29,6)
Type Code ("I"=Invoice, "P"=Payment). . TypeCode. . . . . . . . . . . String *(35,1)
Source Code ("A"=A/R, "J"=J/C). . . . . SourceCodeBillDetl. . . . . . String *(36,1)
Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (41,1)
Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String (42,53)
Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (95,50)
Retention Amount. . . . . . . . . . . . BillRetentionAmount . . . . . Number [0] 8.2
Sales Tax Amount. . . . . . . . . . . . BillSalesTaxAmount. . . . . . Number [1] 7.2
Billed/Payment Amount . . . . . . . . . BilledOrPaymentAmount . . . . Number [2] 8.2
Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0.
________
Total Bytes 185
JC_H3 J/C Job History Transaction Detail File (JC_H3_TransactionDetailHistory) Level: 4.40
Record Type: 3 J/C Cost Transaction File (Cost Detail) 08/28/2009
File Type: Direct Key Size: 40 Rec Len: 200 Min Len: 144 Define: Y
Field Description Crystal/SQL/ALE/Column Name Data Type Pos/Len Mask
Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase *(1,7)
Rec Type (2=Cost Detail). . . . . . . . RecordType. . . . . . . . . . Zero-Filled *(8,1)
Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account *(9,9)
Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . String *(18,1)
Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(19,2)
Only with Cost Type = S . . . . . . . . . . . . . . . . . . . . . . Memo
Vendor Number (If Cost Type "S"). . . . VendorNumber. . . . . . . . . String *(21,7)
Only with Cost Type = S . . . . . . . . . . . . . . . . . . . . . . Memo
Cost Detail Type. . . . . . . . . . . . CostDetailType. . . . . . . . Zero-Filled *(28,1)
0 = Subcontract C/O, 1 = Costs. . . . . . . . . . . . . . . . . . . Memo
Transaction Date. . . . . . . . . . . . TransactionDate . . . . . . . Date *(29,6)
Source Code ("CO"=Change Order) . . . . SourceCode. . . . . . . . . . String *(35,2)
Sequence Counter. . . . . . . . . . . . SeqNo . . . . . . . . . . . . Zero-Filled *(37,4)
Billed. . . . . . . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No (41,1)
Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String (42,53)
Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (95,50)
Trans Units . . . . . . . . . . . . . . TransactionUnits. . . . . . . Number [0] 7.2
Transaction Unit Cost . . . . . . . . . TransactionUnitCost . . . . . Number [1] 7.2
Transaction Amount. . . . . . . . . . . TransactionAmount . . . . . . Number [2] 8.2
Retention Amount (If Cost Type = "S") . CostRetentionAmount . . . . . Number [3] 8.2
________
Total Bytes 196