     JC2    J/C Job Cost Detail File (JC2_JobCostDetail)                             Level: 4.40
            Record Type: 1    Job Cost Detail File (Header Record)                   08/28/2009

     File Type: Direct   Key Size: 26   Rec Len: 340     Min Len: 51     Define: Y

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(1,7)
     Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account     *(8,9)
     Cost Type (Blank) . . . . . . . . . . . CostType. . . . . . . . . . . String      *(17,1)
     Division Number (Blanks). . . . . . . . DivisionNumber. . . . . . . . String      *(18,2)
     Vendor Number (Blanks). . . . . . . . . VendorNumber. . . . . . . . . String      *(20,7)
     Description (Use Cost Cde Desc If Blank)Description . . . . . . . . . String      (27,30)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (57,9)
     Number Of Days For Startup. . . . . . . NoOfDaysFromStartup . . . . . Zero-Filled (66,4)
     Num Of Days For Completion After StartupNoOfDaysForCompletion . . . . Zero-Filled (70,4)
     Open String . . . . . . . . . . . . . . _S2 . . . . . . . . . . . . . Open String (74,10)
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [0]       0.
     Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [1]       0.
     Open Number . . . . . . . . . . . . . . _N3 . . . . . . . . . . . . . Open Number [2]       0.
     Open Number . . . . . . . . . . . . . . _N4 . . . . . . . . . . . . . Open Number [3]       0.
     Open Number . . . . . . . . . . . . . . _N5 . . . . . . . . . . . . . Open Number [4]       0.
     Open Number . . . . . . . . . . . . . . _N6 . . . . . . . . . . . . . Open Number [5]       0.
     Open Number . . . . . . . . . . . . . . _N7 . . . . . . . . . . . . . Open Number [6]       0.
     Open Number . . . . . . . . . . . . . . _N8 . . . . . . . . . . . . . Open Number [7]       0.
     Open Number . . . . . . . . . . . . . . _N9 . . . . . . . . . . . . . Open Number [8]       0.
     Open Number . . . . . . . . . . . . . . _N10. . . . . . . . . . . . . Open Number [9]       0.
     Open Number . . . . . . . . . . . . . . _N11. . . . . . . . . . . . . Open Number [10]      0.
     Open Number . . . . . . . . . . . . . . _N12. . . . . . . . . . . . . Open Number [11]      0.
     Open Number . . . . . . . . . . . . . . _N13. . . . . . . . . . . . . Open Number [12]      0.
     Open Number . . . . . . . . . . . . . . _N14. . . . . . . . . . . . . Open Number [13]      0.
     Open Number . . . . . . . . . . . . . . _N15. . . . . . . . . . . . . Open Number [14]      0.
     Open Number . . . . . . . . . . . . . . _N16. . . . . . . . . . . . . Open Number [15]      0.
     Open Number . . . . . . . . . . . . . . _N17. . . . . . . . . . . . . Open Number [16]      0.
     Open Number . . . . . . . . . . . . . . _N18. . . . . . . . . . . . . Open Number [17]      0.
     Open Number . . . . . . . . . . . . . . _N19. . . . . . . . . . . . . Open Number [18]      0.
     Open Number . . . . . . . . . . . . . . _N20. . . . . . . . . . . . . Open Number [19]      0.
     Open Number . . . . . . . . . . . . . . _N21. . . . . . . . . . . . . Open Number [20]      0.
                                                                                       ________
                                                                          Total Bytes  106

     JC2    J/C Job Cost Detail File (JC2_JobCostDetail)                             Level: 4.40
            Record Type: 2    Job Cost Detail File (Detail Record)                   08/28/2009

     File Type: Direct   Key Size: 26   Rec Len: 340     Min Len: 51     Define: Y

     Field Description                       Crystal/SQL/ALE/Column Name   Data Type   Pos/Len   Mask

     Job Number. . . . . . . . . . . . . . . JobNumber . . . . . . . . . . Uppercase   *(1,7)
     Cost Code . . . . . . . . . . . . . . . CostCode. . . . . . . . . . . Account     *(8,9)
     Cost Type . . . . . . . . . . . . . . . CostType. . . . . . . . . . . Uppercase   *(17,1)
     Division Number . . . . . . . . . . . . DivisionNumber. . . . . . . . Zero-Filled *(18,2)
     Vendor Number (For Cost Type S) . . . . VendorNumber. . . . . . . . . Account     *(20,7)
     Unit Of Measure . . . . . . . . . . . . UnitOfMeasure . . . . . . . . Uppercase   (27,4)
     Bill Method (Non, %Mrk, Unt Prc). . . . BillMethod. . . . . . . . . . Uppercase   (31,1)
     Completion Method (Unit, Cost). . . . . CompletionMethod. . . . . . . Uppercase   (32,1)
     Reported Date . . . . . . . . . . . . . ReportedDate. . . . . . . . . Date        (33,6)
     Liens Release Date   (For Cost Type "S")LiensReleaseDate. . . . . . . Date        (39,6)
     Workers' Comp Code (If P/R And Type "L")WorkersCompCode . . . . . . . String      (45,7)
     Open String . . . . . . . . . . . . . . _S1 . . . . . . . . . . . . . Open String (52,32)
     Rate/Price (Bill Method - %/U). . . . . RateOrPrice . . . . . . . . . Number      [0]       8.2
     Standard Unit Cost. . . . . . . . . . . StdUnitCost . . . . . . . . . Number      [1]       7.2
     Actual % Complete . . . . . . . . . . . ActualPercentComplete . . . . Number      [2]       3.2
     Liens Amount         (For Cost Type "S")LiensAmount . . . . . . . . . Number      [3]       8.2
     Cost Original Estimate. . . . . . . . . OriginalEstimatedCost . . . . Number      [4]       8.2
     Cost Revised Estimate . . . . . . . . . RevisedEstimatedCost. . . . . Number      [5]       8.2
     Cost Period To Date . . . . . . . . . . PTDCost . . . . . . . . . . . Number      [6]       8.2
     Cost Year To Date . . . . . . . . . . . YTDCost . . . . . . . . . . . Number      [7]       8.2
     Cost Job To Date. . . . . . . . . . . . JTDCost . . . . . . . . . . . Number      [8]       8.2
     Cost Unbilled (Wip) . . . . . . . . . . UnbilledCost. . . . . . . . . Number      [9]       8.2
     Units Original Estimate . . . . . . . . OriginalEstimatedUnits. . . . Number      [10]      7.2
     Units Revised Estimate. . . . . . . . . RevisedEstimatedUnits . . . . Number      [11]      7.2
     Units Period To Date. . . . . . . . . . PTDUnits. . . . . . . . . . . Number      [12]      7.2
     Units Year To Date. . . . . . . . . . . YTDUnits. . . . . . . . . . . Number      [13]      7.2
     Units Job To Date . . . . . . . . . . . JTDUnits. . . . . . . . . . . Number      [14]      7.2
     Units Unbilled (Wip). . . . . . . . . . UnbilledUnits . . . . . . . . Number      [15]      7.2
     Retention Rate (For Cost Type "S"). . . RetentionRate . . . . . . . . Number      [16]      3.2
     Cost Next Period. . . . . . . . . . . . FutureCost. . . . . . . . . . Number      [17]      8.2
     Units Next Period . . . . . . . . . . . FutureUnits . . . . . . . . . Number      [18]      7.2
     Open Number . . . . . . . . . . . . . . _N1 . . . . . . . . . . . . . Open Number [19]      0.
     Open Number . . . . . . . . . . . . . . _N2 . . . . . . . . . . . . . Open Number [20]      0.
                                                                                       ________
                                                                          Total Bytes  316