DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3