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