JC_H2 J/C Job Cost History Detail File (JC_H2_JobCostHistoryDetail) 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
JC_H2 J/C Job Cost History Detail File (JC_H2_JobCostHistoryDetail) 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