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