JC3_TransactionDetail J/C Job Cost Transaction Detail File Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: N SysDB: N "MAS_"+%C$+"/JC"+%C$+"/JC3"+%C$+".soa"
Fld Column Name M/L TUR Description/Notes Class
1 JobNumber . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . . 2 RecordType. . . . . . . . . . 1 SNN Rec Type (0=Contract Change Ord Mask:0 3 CostCode. . . . . . . . . . . 9 SNN Cost Code (Not Used) . . . . . 4 CostType. . . . . . . . . . . 1 SNN Cost Type (Not Used). . . . . . 5 DivisionNumber. . . . . . . . 2 SNN Division Number (Not Used) . . 6 VendorNumber. . . . . . . . . 7 SNN Vendor Number (Not Used). . . . 7 CostDetailType. . . . . . . . 1 SNN Cost Detail Type (Not Used) . . 8 TransactionDate . . . . . . . 6 SNN Transaction Date. . . . . . . .DATE*MAS90 9 SourceCode. . . . . . . . . . 2 SNN Source Code ("CO"=Change Order) 10 SeqNo . . . . . . . . . . . . 4 SNN Sequence Counter. . . . . . . . Mask:0000 11 Billed. . . . . . . . . . . . 1 SYN Billed (Not Used) . . . . . . .YESNO 12 TransactionComment. . . . . . 40 SNN Transaction Comment . . . . . . 13 _S3 . . . . . . . . . . . . . 13 SNN Open String . . . . . . . . . . 14 TransactionUnits. . . . . . . 11.2 NNN Trans Units . . . . . . . . . . Mask:######0.00 15 TransactionUnitCost . . . . . 11.2 NNN Transaction Unit Cost . . . . . Mask:######0.00 16 TransactionAmount . . . . . . 12.2 NNN Transaction Amount. . . . . . . Mask:#######0.00 17 CostRetensionAmount . . . . . 12.2 NNN Cost Retension Amount (Not Used 18 J/C Cost Transaction File (Bi 0 NN . . . . . . . . . . . . . . . Valid:1 19 JobNumber . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . . 20 RecordType. . . . . . . . . . 1 SNN Rec Type (1=Bill Detail). . . . Mask:0 21 CostCode. . . . . . . . . . . 9 SNN Cost Code (Not Used). . . . . . 22 CostType. . . . . . . . . . . 1 SNN Cost Type (Not Used). . . . . . 23 DivisionNumber. . . . . . . . 2 SNN Division Number (Not Used). . . 24 VendorNumber. . . . . . . . . 7 SNN Vendor Number (Not Used). . . . 25 CostDetailType. . . . . . . . 1 SNN Cost Detail Type (Not used) . . 26 TransactionDate . . . . . . . 6 SNN Transaction Date. . . . . . . .DATE*MAS90 27 TypeCode. . . . . . . . . . . 1 SNN Type Code ("I"=Invoice, "P"=Pay 28 SourceCodeBillDetl. . . . . . 1 SNN Source Code ("A"=A/R, "J"=J/C). 29 SeqNo . . . . . . . . . . . . 4 SNN Sequence Counter. . . . . . . . Mask:0000 30 Billed. . . . . . . . . . . . 1 SYN Billed (Not Used) . . . . . . .YESNO 31 TransactionComment. . . . . . 40 SNN Transaction Comment . . . . . . 32 _S3 . . . . . . . . . . . . . 13 SNN Open String . . . . . . . . . . 33 BillRetentionAmount . . . . . 12.2 NNN Retention Amount. . . . . . . . Mask:#######0.00 34 BillSalesTaxAmount. . . . . . 11.2 NNN Sales Tax Amount. . . . . . . . Mask:######0.00 35 BilledOrPaymentAmount . . . . 12.2 NNN Billed/Payment Amount . . . . . Mask:#######0.00 36 CostRetensionAmount . . . . . 12.2 NNN Cost Retension Amount (Not Used 37 J/C Cost Transaction File (Cos 0 NN . . . . . . . . . . . . . . . Valid:2 38 JobNumber . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . . 39 RecordType. . . . . . . . . . 1 SNN Rec Type (2=Cost Detail). . . . Mask:0 40 CostCode. . . . . . . . . . . 9 SNN Cost Code . . . . . . . . . . .Accnt 41 CostType. . . . . . . . . . . 1 SNN Cost Type . . . . . . . . . . . 42 DivisionNumber. . . . . . . . 2 SNN Division Number . . . . . . . . Mask:00 43 VendorNumber. . . . . . . . . 7 SNN Vendor Number (If Cost Type "S" 44 CostDetailType. . . . . . . . 1 SNN Cost Dtl Typ (0=Sub Cntrct C/O, Mask:0 45 TransactionDate . . . . . . . 6 SNN Transaction Date. . . . . . . .DATE*MAS90 46 SourceCode. . . . . . . . . . 2 SNN Source Code ("CO"=Change Order) 47 SeqNo . . . . . . . . . . . . 4 SNN Sequence Counter. . . . . . . . Mask:0000 48 Billed. . . . . . . . . . . . 1 SYN Billed. . . . . . . . . . . . .YesNo 49 TransactionComment. . . . . . 40 SNN Transaction Comment . . . . . . 50 _S1 . . . . . . . . . . . . . 13 SNN Open String . . . . . . . . . . 51 TransactionUnits. . . . . . . 11.2 NNN Trans Units . . . . . . . . . . Mask:######0.00 52 TransactionUnitCost . . . . . 11.2 NNN Transaction Unit Cost . . . . . Mask:######0.00 53 TransactionAmount . . . . . . 12.2 NNN Transaction Amount. . . . . . . Mask:#######0.00 54 CostRetentionAmount . . . . . 12.2 NNN Retention Amount (If Cost Type Mask:#######0.00