JC3 J/C Job Cost Transaction Detail File (JC3_TransactionDetail) 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) CostCode (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) Billed (Not Used) . . . . . . . . . . . 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 Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [3] 0. ________ Total Bytes 184
JC3 J/C Job Cost Transaction Detail File (JC3_TransactionDetail) 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) Billed (Not Used) . . . . . . . . . . . Billed. . . . . . . . . . . . Yes/No (41,1) Transaction Comment . . . . . . . . . . TransactionComment. . . . . . String (42,53) Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . 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
JC3 J/C Job Cost Transaction Detail File (JC3_TransactionDetail) 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 . . . . . . . . . . . . . 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