| zProjectID |
char(21)
''
|
|
|
|
|
| zProjectDescription |
char(81)
''
|
|
|
|
|
| zBudgetID |
char(21)
''
|
|
|
|
|
| zBudgetDescription |
char(81)
''
|
|
|
|
|
| zRateID |
char
''
|
|
|
|
|
| zOverheadID |
char(21)
''
|
|
|
|
|
| zOverheadDescription |
char(41)
''
|
|
|
|
|
| zRateDescription |
char
''
|
|
|
|
|
| zValuationClassID |
char(15)
''
|
|
|
|
|
| zValuationMethodDDL |
smallint
0
|
|
|
|
|
| zPercentCompleteTypeDDL |
smallint
0
|
|
|
|
|
| zIncludeSubContractCB |
tinyint
0
|
|
|
|
|
| zPercentComplete |
numeric(19,5)
0.00
|
|
|
|
|
| zEarnedRevenue |
numeric(19,5)
0.00
|
|
|
|
|
| zDistHistoryYear |
smallint
0
|
|
|
|
|
| zPeriodNumber |
int
0
|
|
|
|
|
| zJournalEntry |
int
0
|
|
|
|
|
| zPostingDate |
datetime
'1/1/1900'
|
|
|
|
|
| zAdjSalesCmpltdContract |
numeric(19,5)
0.00
|
|
|
|
|
| zSalesOffSetIndex |
int
0
|
|
|
|
|
| zDeferredRevenueIndex |
int
0
|
|
|
|
|
| zAdjCostCmpltdContract |
numeric(19,5)
0.00
|
|
|
|
|
| zWipOffSetIndex |
int
0
|
|
|
|
|
| zBalWipIndex |
int
0
|
|
|
|
|
| zCostsInExcessOfBillings |
numeric(19,5)
0.00
|
|
|
|
|
| zAdjCostsExBillingIndex |
int
0
|
|
|
|
|
| zBalCostsExBillingIndex |
int
0
|
|
|
|
|
| zBillingsInExcessOfCosts |
numeric(19,5)
0.00
|
|
|
|
|
| zAdjBillingExCostsIndex |
int
0
|
|
|
|
|
| zBalBillingExCostsIndex |
int
0
|
|
|
|
|
| zProvisionLossContract |
numeric(19,5)
0.00
|
|
|
|
|
| zProvLossContractIndex |
int
0
|
|
|
|
|
| zBalLossContractIndex |
int
0
|
|
|
|
|
| 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
|
|
|
|
|
| zActualLaborBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActSubcontractBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualPurchaseBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualMaterialBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualEquipBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualLaborHours |
numeric(19,5)
0.00
|
|
|
|
|
| zActualSubcontractHours |
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
|
|
|
|
|
| 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
|
|
|
|
|
| zBudgetLaborHours |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetSubcontractHours |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenLaborPct |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenSubcontrPct |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|