Module List >
Module Olympic PC tables
pc00851
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc00851 Table Definition
(COMPANY..pcProjectModelDetail )
Field Definitions:
What is the 'source' column?
| zUserID |
char(15)
''
|
|
|
|
|
| zProjectID |
char(21)
''
|
|
|
|
|
| zProjectDescription |
char(81)
''
|
|
|
|
|
| zBudgetID |
char(21)
''
|
|
|
|
|
| zBudgetDescription |
char(81)
''
|
|
|
|
|
| zDepartmentID |
char
''
|
|
|
|
|
| zDepartmentDescription |
char
''
|
|
|
|
|
| zOverheadID |
char(21)
''
|
|
|
|
|
| zOverheadDescription |
char(41)
''
|
|
|
|
|
| zCostCategoryDDL |
smallint
0
|
Incomplete...(more) Join Now
|
|
|
|
| zSubCostCategory |
smallint
0
|
|
|
|
|
| zSubCostCategoryString |
char(15)
''
|
|
|
|
|
| zActualCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenRate |
numeric
0.00
|
|
|
|
|
| zBurdenRate |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetBurdenAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetTotalAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceAmt |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|