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