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

COMPANY..pc00100 Table Definition

(COMPANY..pcSystemMaster )
The pc00100 is the Project System Master table.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
zSetupKey smallint
0

zNextTransactionNumber int
0

zAllowDistributionEdit tinyint
0

zEnableProjectSecurity tinyint
0
zEnableProcessSecurity tinyint
0
zDefaultDistFrom smallint
0

zLaborAccountIndex int
0

zRequireReasonCodes tinyint
0
zEmailAlertForRejectTrx tinyint
0
zSubContractAccountIndex int
0

zPurchaseAccountIndex int
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

zApprovalBeforePayProces tinyint
0

zApprovalBeforePRProcess tinyint
0

zApprovalBeforeIVProcess tinyint
0

zPeriodSetupOption smallint
0

zUDProjectLabelCurrency char(21)
''

zUDProjectLabelCurrency2 char(21)
''

zUDProjectLabelDate char(21)
''

zUDProjectLabelDate2 char(21)
''

zProjectLabelSort1 char(41)
''

zProjectLabelSort2 char(41)
''

zProjectLabelSort3 char(41)
''

zUDProjectLabelString char(21)
''

zUDProjectLabelString2 char(21)
''

zUDTaskLabelCurrency char(21)
''

zUDTaskLabelCurrency2 char(21)
''

zUDTaskLabelDate char(21)
''

zUDTaskLabelDate2 char(21)
''

zTaskLabelSort1 char(41)
''

zTaskLabelSort2 char(41)
''

zTaskLabelSort3 char(41)
''

zUDTaskLabelString char(21)
''

zNextGroupNumber int
0
zUDTaskLabelString2 char(21)
''

zNextRoleNumber int
0
zUDTransactionLabelDate char(21)
''

zUDTransactionLabelDate2 char(21)
''

zNextRootNumber int
0
zUDTransactionLabelStr char(21)
''

zUDTransactionLabelStr2 char(21)
''

zNextUserNumber int
0
zUDTransactionLabelCurr char(21)
''

zUDTransactionLabelCurr2 char(21)
''

zDefaultLaborRatesFrom smallint
0

zNextProjectNumber int
0

zNextTaskNumber int
0

zUsePriceLevels tinyint
0

zDefaultPriceLevel char(11)
''

zLaborRateOptionDDL smallint
0
zDefaultMarkupPercent numeric(19,5)
0.00

zUsePCRates4UPRPayroll tinyint
0
zUpdatePCwithIVcosts tinyint
0

zDisableAutoOpen tinyint
0
zUpdatePCwithSOPcosts tinyint
0

zPostStdLaborCostsToGL tinyint
0

zUseUPRCosts tinyint
0

DisableAutoOpen tinyint
0

zProjectCostVersion_1 smallint
0

zProjectCostVersion_2 smallint
0

zProjectCostVersion_3 smallint
0

zRateID char
''
zWebVersion_1 smallint
0

zWebVersion_2 smallint
0

zWebVersion_3 smallint
0

zUseOverheadProcessing tinyint
0

zDisablePayGroupPeriods tinyint
0

zNextPMNumberUseGP tinyint
0
zNextErrorNumber smallint
0

zNextPMNumber int
0

zNextCMNumber int
0
zNextCMNumberSize smallint
0
zNextPMNumberSize smallint
0

zNextCMNumberUseGP tinyint
0
zNextPONumber int
0

zNextPONumberSize smallint
0

zNextRTNNumber int
0

zNextRTNNumberSize smallint
0

zNextPONumberUseGP tinyint
0
zNextSOPNumber int
0

zNextSOPNumberSize smallint
0

zNextRTNNumberUseGP tinyint
0
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
zNextSOPNumberUseGP tinyint
0
zAllowNegativeTEEntry tinyint
0
zUseInvoiceApproval4SB tinyint
0
zUseBudgetItemDesc4POs tinyint
0
zPOTypeDefault smallint
0
zEnableGPSiteSegReplace tinyint
0
zEnableIVSegmentReplace tinyint
0
zSegmentNumber smallint
0
zUseAutoProjectIDSetup tinyint
0
zAutoNumberPassword binary
0
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