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 pc00300
You are currently viewing the COMPANY database.
Change

COMPANY..pc00300 Table Definition

(COMPANY..pcTaskMaster )
The pc00300 is the Task master record table.
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
zAllowLbrCostCat tinyint
0

zAllowSCCostCat tinyint
0

zNoMarkup tinyint
0
zAllowPurCostCat tinyint
0

zAllowMtrlCostCat tinyint
0

zAllowEquipCostCat tinyint
0

zAllowAdjCostCat tinyint
0

zAllowSlsCostCat tinyint
0

zLaborAccountIndex int
0

zSubContractAccountIndex int
0

zPurchaseAccountIndex int
0

zAllowScheduledBillings tinyint
0
zMaterialAccountIndex int
0

zEquipmentAccountIndex int
0

zEquipOffsetAccountIndex int
0

zAdjustmentAccountIndex int
0

zSalesAccountIndex int
0

zBurdenIndexLabor int
0

zBurdenIndexSubcontract int
0

zBurdenIndexPurchase int
0

zBurdenIndexMaterial int
0

zBurdenIndexEquipment int
0

zTaskSort1 char(41)
''

zTaskSort2 char(41)
''

zTaskSort3 char(41)
''

zTaxID_Labor char
''
zUserDefinedCurrency numeric(19,5)
0.00

zUserDefinedCurrency2 numeric(19,5)
0.00

zTaxID_SubContract char
''
zTaxID_Purchase char
''
zUserDefinedDate datetime
'1/1/1900'

zUserDefinedDate2 datetime
'1/1/1900'

zTaxID_Material char
''
zTaxID_Equipment char
''
zUserDefinedString char(21)
''

zUserDefinedString2 char(21)
''

zTaxID_ScheduledBilling char
''
zTaskNumber int
0

zNoteIndex numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
zTransactionDescription char
''
zParentNumber 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