JC_JobDetail JC Job Detail Rel: 4.40 Bld: 398 8/28/2009 Bus Obj: N/A SQL Def: Y SysDB: N "MAS_"+%C$+"/JC"+%C$+"/JC_JobDetail.M4T"
KPRIMARY: JobNo+CostCode+CostType+APDivisionNo+VendorNo
Fld Column Name M/L TUR Description/Notes Class
1 JobNo . . . . . . . . . . . . 7 SYN Job Number. . . . . . . . . . .JOBNO FmtType:CHARNUM 2 CostCode. . . . . . . . . . . 9 SYN Cost Code . . . . . . . . . . .COSTCODE 3 CostType. . . . . . . . . . . 1 SYN Cost Type . . . . . . . . . . . 4 APDivisionNo. . . . . . . . . 2 SYN AP Division Number. . . . . . .APDIVISION Mask:00 5 VendorNo. . . . . . . . . . . 7 SNN Vendor Number . . . . . . . . . ChngTag:Replace1/APDivisionNo $ 6 CostCodeDesc. . . . . . . . . 30 SNN Description . . . . . . . . . .DESCRIPTION 7 NumberOfDaysForStartup. . . . 4 SNN Number Of Days For Startup. . . 8 NumberOfDaysForCompletion . . 4 SNN Number Of Days For Completion . 9 UnitOfMeasure . . . . . . . . 4 SNN Unit Of Measure . . . . . . . .UNITOFMEASURE 10 BillMethod. . . . . . . . . . 1 SYN Bill Method . . . . . . . . . . Valid:N,F,T 11 CompletionMethod. . . . . . . 1 SYN Completion Method . . . . . . . Valid:U,C 12 ReportedDate. . . . . . . . . 8 SNN Reported Date . . . . . . . . .DATE 13 LiensReleaseDate. . . . . . . 8 SNN Liens Release Date. . . . . . .DATE 14 WorkersCompCode . . . . . . . 7 SNN Workers Comp Code . . . . . . . 15 RateOrPrice . . . . . . . . . 16.6 NNN Rate Or Price . . . . . . . . .PRICE Mask:##,###,###.000000- 16 StandardUnitCost. . . . . . . 16.6 NNN Standard Unit Cost. . . . . . .COST Mask:##,###,###.000000- 17 ActualPercentComplete . . . . 9.3 NNN Actual Percent Complete . . . . 18 LiensAmount . . . . . . . . . 12.2 NNN Liens Amount. . . . . . . . . . 19 OriginalEstimatedCost . . . . 12.2 NNN Original Estimated Cost . . . . 20 RevisedEstimatedCost. . . . . 12.2 NNN Revised Estimated Cost. . . . . 21 CostPeriodToDate. . . . . . . 12.2 NNN Cost Period-To-Date . . . . . . 22 CostYearToDate. . . . . . . . 12.2 NNN Cost Year-To-Date . . . . . . . 23 CostJobToDate . . . . . . . . 12.2 NNN Cost Job-To-Date. . . . . . . . 24 UnbilledCost. . . . . . . . . 12.2 NNN Unbilled Cost . . . . . . . . . 25 OriginalEstimatedUnits. . . . 10.2 NNN Original Estimated Units. . . . 26 RevisedEstimatedUnits . . . . 10.2 NNN Revised Estimated Units . . . . 27 UnitsPeriodToDate . . . . . . 10.2 NNN Units Period-To-Date. . . . . . 28 UnitsYearToDate . . . . . . . 10.2 NNN Units Year-To-Date. . . . . . . 29 UnitsJobToDate. . . . . . . . 10.2 NNN Units Job-To-Date . . . . . . . 30 UnbilledUnits . . . . . . . . 10.2 NNN Unbilled Units. . . . . . . . . 31 RetentionRate . . . . . . . . 5.2 NNN Retention Rate. . . . . . . . . 32 FutureCost. . . . . . . . . . 12.2 NNN Future Cost . . . . . . . . . . 33 FutureUnits . . . . . . . . . 10.2 NNN Future Units. . . . . . . . . .