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