     JC_JobDetail                           JC Job Detail                  Rel: 4.40  Bld: 398  8/28/2009
     Bus Obj: N/A
     SQL Def: Y  SysDB: N                                          "MAS_"+%C$+"/JC"+%C$+"/JC_JobDetail.M4T"

     KPRIMARY: JobNo+CostCode+CostType+APDivisionNo+VendorNo

     Fld  Column Name                     M/L TUR  Description/Notes              Class

       1  JobNo . . . . . . . . . . . .     7 SYN  Job Number. . . . . . . . . . .JOBNO
                                                    FmtType:CHARNUM
       2  CostCode. . . . . . . . . . .     9 SYN  Cost Code . . . . . . . . . . .COSTCODE
       3  CostType. . . . . . . . . . .     1 SYN  Cost Type . . . . . . . . . . .
       4  APDivisionNo. . . . . . . . .     2 SYN  AP Division Number. . . . . . .APDIVISION
                                                    Mask:00
       5  VendorNo. . . . . . . . . . .     7 SNN  Vendor Number . . . . . . . . .
                                                    ChngTag:Replace1/APDivisionNo
                                                    $
       6  CostCodeDesc. . . . . . . . .    30 SNN  Description . . . . . . . . . .DESCRIPTION
       7  NumberOfDaysForStartup. . . .     4 SNN  Number Of Days For Startup. . .
       8  NumberOfDaysForCompletion . .     4 SNN  Number Of Days For Completion .
       9  UnitOfMeasure . . . . . . . .     4 SNN  Unit Of Measure . . . . . . . .UNITOFMEASURE
      10  BillMethod. . . . . . . . . .     1 SYN  Bill Method . . . . . . . . . .
                                                    Valid:N,F,T
      11  CompletionMethod. . . . . . .     1 SYN  Completion Method . . . . . . .
                                                    Valid:U,C
      12  ReportedDate. . . . . . . . .     8 SNN  Reported Date . . . . . . . . .DATE
      13  LiensReleaseDate. . . . . . .     8 SNN  Liens Release Date. . . . . . .DATE
      14  WorkersCompCode . . . . . . .     7 SNN  Workers Comp Code . . . . . . .
      15  RateOrPrice . . . . . . . . . 16.6  NNN  Rate Or Price . . . . . . . . .PRICE
                                                    Mask:##,###,###.000000-
      16  StandardUnitCost. . . . . . . 16.6  NNN  Standard Unit Cost. . . . . . .COST
                                                    Mask:##,###,###.000000-
      17  ActualPercentComplete . . . .  9.3  NNN  Actual Percent Complete . . . .
      18  LiensAmount . . . . . . . . . 12.2  NNN  Liens Amount. . . . . . . . . .
      19  OriginalEstimatedCost . . . . 12.2  NNN  Original Estimated Cost . . . .
      20  RevisedEstimatedCost. . . . . 12.2  NNN  Revised Estimated Cost. . . . .
      21  CostPeriodToDate. . . . . . . 12.2  NNN  Cost Period-To-Date . . . . . .
      22  CostYearToDate. . . . . . . . 12.2  NNN  Cost Year-To-Date . . . . . . .
      23  CostJobToDate . . . . . . . . 12.2  NNN  Cost Job-To-Date. . . . . . . .
      24  UnbilledCost. . . . . . . . . 12.2  NNN  Unbilled Cost . . . . . . . . .
      25  OriginalEstimatedUnits. . . . 10.2  NNN  Original Estimated Units. . . .
      26  RevisedEstimatedUnits . . . . 10.2  NNN  Revised Estimated Units . . . .
      27  UnitsPeriodToDate . . . . . . 10.2  NNN  Units Period-To-Date. . . . . .
      28  UnitsYearToDate . . . . . . . 10.2  NNN  Units Year-To-Date. . . . . . .
      29  UnitsJobToDate. . . . . . . . 10.2  NNN  Units Job-To-Date . . . . . . .
      30  UnbilledUnits . . . . . . . . 10.2  NNN  Unbilled Units. . . . . . . . .
      31  RetentionRate . . . . . . . .  5.2  NNN  Retention Rate. . . . . . . . .
      32  FutureCost. . . . . . . . . . 12.2  NNN  Future Cost . . . . . . . . . .
      33  FutureUnits . . . . . . . . . 10.2  NNN  Future Units. . . . . . . . . .