     JC2_JobCostDetail                   J/C Job Cost Detail File          Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: N  SysDB: N                                            "MAS_"+%C$+"/JC"+%C$+"/JC2"+%C$+".soa"

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  JobNumber . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .
       2  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .Accnt
       3  CostType. . . . . . . . . . .     1 SNN  Cost Type (Blank) . . . . . . .
       4  DivisionNumber. . . . . . . .     2 SNN  Division Number . . . . . . . .
       5  VendorNumber. . . . . . . . .     7 SNN  Vendor Number (Blanks). . . . .
       6  Description . . . . . . . . .    30 SNN  Description (Use Cost Cde Desc
       7  _S1 . . . . . . . . . . . . .     9 SNN  Open String . . . . . . . . . .
       8  NoOfDaysFromStartup . . . . .     4 SNN  Number Of Days For Startup. . .
                                                    Mask:0000
       9  NoOfDaysForCompletion . . . .     4 SNN  Num Of Days For Completion Afte
                                                    Mask:0000
      10  _S2 . . . . . . . . . . . . .    10 SNN  Open String . . . . . . . . . .
      11  _N1 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      12  _N2 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      13  _N3 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      14  _N4 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      15  _N5 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      16  _N6 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      17  _N7 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      18  _N8 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      19  _N9 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      20  _N10. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      21  _N11. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      22  _N12. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      23  _N13. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      24  _N14. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      25  _N15. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      26  _N16. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      27  _N17. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      28  _N18. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      29  _N19. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      30  _N20. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      31  _N21. . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      32  Job Cost Detail File (Detail R    0 NN   . . . . . . . . . . . . . . .
                                                    Valid:
      33  JobNumber . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .
      34  CostCode. . . . . . . . . . .     9 SNN  Cost Code . . . . . . . . . . .Accnt
      35  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .
      36  DivisionNumber. . . . . . . .     2 SNN  Division Number . . . . . . . .
                                                    Mask:00
      37  VendorNumber. . . . . . . . .     7 SNN  Vendor Number (For Cost Type S)Accnt
      38  UnitOfMeasure . . . . . . . .     4 SYN  Unit Of Measure . . . . . . . .
      39  BillMethod. . . . . . . . . .     1 SYN  Bill Method (Non, %Mrk, Unt Prc
      40  CompletionMethod. . . . . . .     1 SYN  Completion Method (Unit, Cost).
      41  ReportedDate. . . . . . . . .     6 SNN  Reported Date . . . . . . . . .DATE*MAS90
      42  LiensReleaseDate. . . . . . .     6 SNN  Liens Release Date   (For Cost DATE*MAS90
      43  WorkersCompCode . . . . . . .     7 SNN  Workers' Comp Code (If P/R And
      44  _S1 . . . . . . . . . . . . .    32 SNN  Open String . . . . . . . . . .
      45  RateOrPrice . . . . . . . . . 12.2  NNN  Rate/Price (Bill Method - %/U).
                                                    Mask:#######0.00
      46  StdUnitCost . . . . . . . . . 11.2  NNN  Standard Unit Cost. . . . . . .
                                                    Mask:######0.00
      47  ActualPercentComplete . . . .  7.2  NNN  Actual % Complete . . . . . . .
                                                    Mask:##0.00
      48  LiensAmount . . . . . . . . . 12.2  NNN  Liens Amount         (For Cost
                                                    Mask:#######0.00
      49  OriginalEstimatedCost . . . . 12.2  NNN  Cost Original Estimate. . . . .
                                                    Mask:#######0.00
      50  RevisedEstimatedCost. . . . . 12.2  NNN  Cost Revised Estimate . . . . .
                                                    Mask:#######0.00
      51  PTDCost . . . . . . . . . . . 12.2  NNN  Cost Period To Date . . . . . .
                                                    Mask:#######0.00
      52  YTDCost . . . . . . . . . . . 12.2  NNN  Cost Year To Date . . . . . . .
                                                    Mask:#######0.00
      53  JTDCost . . . . . . . . . . . 12.2  NNN  Cost Job To Date. . . . . . . .
                                                    Mask:#######0.00
      54  UnbilledCost. . . . . . . . . 12.2  NNN  Cost Unbilled (Wip) . . . . . .
                                                    Mask:#######0.00
      55  OriginalEstimatedUnits. . . . 11.2  NNN  Units Original Estimate . . . .
                                                    Mask:######0.00
      56  RevisedEstimatedUnits . . . . 11.2  NNN  Units Revised Estimate. . . . .
                                                    Mask:######0.00
      57  PTDUnits. . . . . . . . . . . 11.2  NNN  Units Period To Date. . . . . .
                                                    Mask:######0.00
      58  YTDUnits. . . . . . . . . . . 11.2  NNN  Units Year To Date. . . . . . .
                                                    Mask:######0.00
      59  JTDUnits. . . . . . . . . . . 11.2  NNN  Units Job To Date . . . . . . .
                                                    Mask:######0.00
      60  UnbilledUnits . . . . . . . . 11.2  NNN  Units Unbilled (Wip). . . . . .
                                                    Mask:######0.00
      61  RetentionRate . . . . . . . .  7.2  NNN  Retention Rate (For Cost Type "
                                                    Mask:##0.00
      62  FutureCost. . . . . . . . . . 12.2  NNN  Cost Next Period. . . . . . . .
                                                    Mask:#######0.00
      63  FutureUnits . . . . . . . . . 11.2  NNN  Units Next Period . . . . . . .
                                                    Mask:######0.00
      64  _N1 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .
      65  _N2 . . . . . . . . . . . . .  1.0  NNN  Open Number . . . . . . . . . .