Module List > Module Olympic PC tables pc00752
You are currently viewing the COMPANY database.
Change

COMPANY..pc00752 Table Definition

(COMPANY..pcbTaskTemp )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
zUserID char(15)
''

zBudgetID char(21)
''

zMasterProjectID char(21)
''

zProjectID char(21)
''

zProjectDescription char(81)
''

zProjectType char(15)
''

zProjectSubType char(15)
''

zTaskID char(21)
''

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

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3