Module List >
Module Olympic PC tables
pc00754
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc00754 Table Definition
(COMPANY..pcbSubCostCategoryTemp )
Field Definitions:
What is the 'source' column?
| zUserID |
char(15)
''
|
|
|
|
|
| zBudgetID |
char(21)
''
|
|
|
|
|
| zMasterProjectID |
char(21)
''
|
|
|
|
|
| zProjectID |
char(21)
''
|
|
|
|
|
| zTaskID |
char(21)
''
|
|
|
|
|
| zCostCategoryDDL |
smallint
0
|
Incomplete...(more) Join Now
|
|
|
|
| zCostCategoryString |
char(15)
''
|
|
|
|
|
| zSubCostCategory |
smallint
0
|
|
|
|
|
| zSubCostCategoryString |
char(15)
''
|
|
|
|
|
| zProjectDescription |
char(81)
''
|
|
|
|
|
| zProjectType |
char(15)
''
|
|
|
|
|
| zProjectSubType |
char(15)
''
|
|
|
|
|
| zTaskDescription |
char(81)
''
|
|
|
|
|
| zTaskStatusDDL |
smallint
0
|
|
|
|
|
| zTaskType |
char(15)
''
|
|
|
|
|
| zTaskSubType |
char(15)
''
|
|
|
|
|
| zActualCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zCommitmentAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zTotalCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualSaleAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zActualGM |
numeric(19,5)
0.00
|
|
|
|
|
| zActualGMPercent |
smallint
0
|
|
|
|
|
| zBudgetCostAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetSaleAmt |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetGM |
numeric(19,5)
0.00
|
|
|
|
|
| zBudgetGMPercent |
smallint
0
|
|
|
|
|
| zVarianceCost |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceCostPercent |
smallint
0
|
|
|
|
|
| zVarianceSales |
numeric(19,5)
0.00
|
|
|
|
|
| zVarianceSalesPercent |
smallint
0
|
|
|
|
|
| zActualLaborHours |
numeric
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| zActualBillingHours |
numeric
0.00
|
|
|
|
|
| zBudgetCostHours |
numeric
0.00
|
|
|
|
|
| zBudgetBillingHours |
numeric
0.00
|
|
|
|
|
| zVarianceCostHours |
numeric
0.00
|
|
|
|
|
| zVarianceBillingHours |
numeric
0.00
|
|
|
|
|
|