     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