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