Module List >
Module Olympic PC tables
pc00751
You are currently viewing the COMPANY
database.
Change
|
COMPANY..pc00751 Table Definition
(COMPANY..pcbProjectTemp )
Field Definitions:
What is the 'source' column?
| zUserID |
char(15)
''
|
|
|
|
|
| zBudgetID |
char(21)
''
|
|
|
|
|
| zProjectID |
char(21)
''
|
|
|
|
|
| zMasterProjectID |
char(21)
''
|
|
|
|
|
| zProjectDescription |
char(81)
''
|
|
|
|
|
| zProjectStatusDDL |
smallint
0
|
p>Project ...(more) Join Now
|
|
|
|
| zProjectType |
char(15)
''
|
|
|
|
|
| zProjectSubType |
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
|
|
|
|
|
|