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

COMPANY..pc00390 Table Definition

(COMPANY..pcTaskMoveTemp )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
zProjectID char(21)
''

zTaskID char(21)
''

zHC_1 smallint
0

zHC_2 smallint
0

zHC_3 smallint
0

zHC_4 smallint
0

zHC_5 smallint
0

zHC_6 smallint
0

zHC_7 smallint
0

zHC_8 smallint
0

zHC_9 smallint
0

zTaskLevel smallint
0

zTaskDescription char(81)
''

zTaskType char(15)
''

zTaskSubType char(15)
''

zTaskStatusDDL smallint
0

zDateOpen datetime
'1/1/1900'

zDateClose datetime
'1/1/1900'

zDefaultMarkupPercent numeric
0.00

zAllowPurchaseCommitment tinyint
0

zAllowLbrCostCat tinyint
0

zNoMarkup tinyint
0

zAllowSCCostCat tinyint
0

zAllowPurCostCat tinyint
0

zAllowMtrlCostCat tinyint
0

zAllowEquipCostCat tinyint
0

zAllowAdjCostCat tinyint
0

zAllowSlsCostCat tinyint
0

zLaborAccountIndex int
0

zAllowScheduledBillings tinyint
0

zSubContractAccountIndex int
0

zPurchaseAccountIndex int
0

zMaterialAccountIndex int
0

zEquipmentAccountIndex int
0

zEquipOffsetAccountIndex int
0

zAdjustmentAccountIndex int
0

zSalesAccountIndex int
0

zTaskSort1 char(41)
''

zTaskSort2 char(41)
''

zTaskSort3 char(41)
''

zBurdenIndexLabor int
0

zBurdenIndexSubcontract int
0

zUserDefinedCurrency numeric(19,5)
0.00

zUserDefinedCurrency2 numeric(19,5)
0.00

zBurdenIndexPurchase int
0

zBurdenIndexMaterial int
0

zUserDefinedDate datetime
'1/1/1900'

zUserDefinedDate2 datetime
'1/1/1900'

zBurdenIndexEquipment int
0

zUserDefinedString char(21)
''

zTaxID_Labor char
''

zUserDefinedString2 char(21)
''

zTaxID_SubContract char
''

zTaxID_Purchase char
''

zTaskNumber int
0

zTaxID_Material char
''

zNoteIndex numeric(19,5)
0.00

zTaxID_Equipment char
''

zSourceTaskID char(21)
''

zTaxID_ScheduledBilling char
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
zTransactionDescription char
''

zParentNumber int
0

zSourceTaskNumber int
0

zBillingDescriptionText text
''

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