| zUserID |
char(15)
''
|
|
|
|
|
| zProjectID |
char(21)
''
|
|
|
|
|
| zProjectDescription |
char(81)
''
|
|
|
|
|
| zBudgetID |
char(21)
''
|
|
|
|
|
| zBudgetDescription |
char(81)
''
|
|
|
|
|
| zOverheadID |
char(21)
''
|
|
|
|
|
| zRateID |
char
''
|
|
|
|
|
| zRateDescription |
char
''
|
|
|
|
|
| zOverheadDescription |
char(41)
''
|
|
|
|
|
| zActualSaleAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualLaborAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualSubcontractAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualPurchaseAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualMaterialAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualEquipmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualAdjustmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentLaborAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentSCAmt |
numeric
0.00
|
|
|
|
|
| zCommitmentSubcontractAm |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentPurchaseAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentMaterialAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentEquipmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualLaborTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualLaborBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualSubcontractTtlAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActSubcontractBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualPurchaseTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualPurchaseBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualMaterialTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualMaterialBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualEquipmentTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualEquipBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualAdjustmentTtlAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualGrandTotal |
numeric(19,5)
0.00
|
|
|
|
|
| zActualGrossMarginAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualGenAdminAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualNetProfitAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateLaborPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateSubcontrPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRatePurchasePct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateMaterialPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateEquipmentPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateGenAdminPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBurdenRateNetProfitPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetSaleAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetLaborAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetLaborBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetSubcontractAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetSubcontrBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetPurchaseAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetPurchaseBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetMaterialAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetMaterialBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetEquipmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetEquipBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetGrossMarginAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetGenAdminAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetNetProfitAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenLaborPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenSubcontrPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenNetPrftPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenPurchasePct |
numeric
0.00
|
|
|
|
|
| zBudgetBurdenMaterialPct |
numeric
0.00
|
|
|
|
|
| zVarianceSaleAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceLaborAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenEquipmentPc |
numeric
0.00
|
|
|
|
|
| zBudgetBurdenGenAdminPct |
numeric
0.00
|
|
|
|
|
| zVarianceLaborBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceSubcontractAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceSubconBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVariancePurchaseAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVariancePrchBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceMaterialAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceMtrlBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceEquipmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceEquipBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceAdjustmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceGrossMarginAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceGenAdminAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceNetProfitAmt |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|