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

COMPANY..pc00200 Table Definition

(COMPANY..pcProjectMaster )
The pc00200 is the Project master record table.
4Penny.net

Field Definitions:

What is the 'source' column?

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

zProjectDescription char(81)
''

zMasterProjectID char(21)
''

zProjectType char(15)
''

zProjectSubType char(15)
''

zCustomerID char(15)
''

zCustomerName char(65)
''

zCustomerPONumber char(17)
''

zBillToAddressCode char
''
zProjectCustomerAddrCode char(15)
''

zContractAmount numeric(19,5)
0.00

zShipToAddressCode char
''
zWorkOrderNumber char(15)
''

zProjectStatusDDL smallint
0
p>Project ...(more) Join Now
zTerritoryID char(15)
''

zSalesPersonID char(15)
''

zProjectSort1 char(41)
''

zProjectSort2 char(41)
''

zProjectSort3 char(41)
''

zDateOpen datetime
'1/1/1900'

zDateClose datetime
'1/1/1900'

zBillingCycleDDL smallint
0

zBillingFormatDDL smallint
0

zBillingMethod char(41)
''

zAllowDistributionEdit tinyint
0

zDefaultDistFrom smallint
0

zLaborAccountIndex int
0

zSubContractAccountIndex int
0

zPurchaseAccountIndex int
0

zMaterialAccountIndex int
0

zEquipmentAccountIndex int
0

zEquipOffsetAccountIndex int
0

zAdjustmentAccountIndex int
0

zSalesAccountIndex int
0

zBudgetID char(21)
''

zNoStdLaborPosting tinyint
0

zOverheadID char(21)
''

zBudgetIDEstToComplete char
''
zBudgetIDEstAtCompletion char
''
zBurdenIndexLabor int
0

zBudgetIDOriginal char
''
zBurdenIndexSubcontract int
0

zBurdenIndexPurchase int
0

zBurdenIndexMaterial int
0

zRateID char
''
zBurdenIndexEquipment int
0

zValuationClassID char(15)
''

zUserDefinedCurrency numeric(19,5)
0.00

zUserDefinedCurrency2 numeric(19,5)
0.00

zUserDefinedDate datetime
'1/1/1900'

zUserDefinedDate2 datetime
'1/1/1900'

zUserDefinedString char(21)
''

zUserDefinedString2 char(21)
''

zProjectNumber int
0

zSOPInvoiceTypeID char
''
zSOPReturnTypeID char
''
zDefaultMarkupPercent numeric(19,5)
0.00

zDefaultPriceLevel char(11)
''

zTaxID_Labor char
''
zTaxID_SubContract char
''
zNoteIndex numeric(19,5)
0.00

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