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. . . . . . . . . .