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