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

COMPANY..pc10005 Table Definition

(COMPANY..pcTransactionImport )
The pc10005 is the PC Imports Staging table.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
zBatchID char(15)
''

zImportID char(15)
''

zImportType smallint
0

zAllowAdjCostCat tinyint
0
zAllowDistributionEdit tinyint
0
zTransactionState smallint
0

zValidData tinyint
0

zAllowEquipCostCat tinyint
0
zAllowLbrCostCat tinyint
0
zProjectID char(21)
''

zAllowMtrlCostCat tinyint
0
zTaskID char(21)
''

zTransactionNumber int
0

zAllowPurCostCat tinyint
0
zAllowSCCostCat tinyint
0
zTransactionDate datetime
'1/1/1900'

zUserID char(15)
''

zAllowScheduledBillings tinyint
0
zAllowSlsCostCat tinyint
0
zCostCategoryDDL smallint
0
Incomplete...(more) Join Now
zCostCategoryString char(15)
''

zBillingCycleDDL smallint
0
zSubCostCategory smallint
0

zSubCostCategoryString char(15)
''

zBillingFormatDDL smallint
0
zBillingMethod char
''
zJournalEntry int
0

zPostingDate datetime
'1/1/1900'

zSalesPostingDate datetime
'1/1/1900'

zPeriodNumber int
0

zBillToAddressCode char
''
zTransactionDescription char(61)
''

zBudgetDescription char
''
zBillingDescriptionLine1 char(51)
''

zBillingDescriptionLine2 char(51)
''

zBudgetElement char
''
zBudgetElementDesc char
''
zBillingDescriptionLine3 char(51)
''

zBillingDescriptionLine4 char(51)
''

zBudgetID char
''
zBurdenIndexEquipment int
0
zSalesAccountIndex int
0

zSalesAccountString char(41)
''

zBurdenIndexLabor int
0
zBurdenIndexMaterial int
0
zDistDocumentTypeDDL smallint
0

zBurdenIndexPurchase int
0
zDistDocumentNumber char(21)
''

zDistSequenceNumber int
0

zBurdenIndexSubcontract int
0
zSalesDocumentTypeDDL smallint
0

zSalesDocumentNumber char(21)
''

zBurdenStringEquipment char
''
zBurdenStringLabor char
''
zSalesLineNumber int
0

zDistHistoryYear smallint
0

zBurdenStringMaterial char
''
zBurdenStringPurchase char
''
zSeriesDDL smallint
0

zBurdenStringSubcontract char
''
zSourceDoc char(11)
''

zWebSource smallint
0

zContractAmount numeric
0.00
zOrigDocumentNumber char(21)
''

zOrigDocumentDate datetime
'1/1/1900'

zOrigID char(21)
''

zOrigName char(65)
''

zCustomerID char
''
zCustomerName char
''
zExpenseStatusDDL smallint
0

zCustomerPONumber char
''
zApprovalUserIDCost char(15)
''

zAccountIndex int
0

zDateClose datetime
'1900-01-01'
zDateOpen datetime
'1900-01-01'
zAccountNumberString char(41)
''

zBillingStatusDDL smallint
0

zDefaultDistFrom smallint
0
zDefaultMarkupPercent numeric
0.00
zApprovalUserIDBilling char(15)
''

zDefaultPriceLevel char
''
zBillingWorkQty numeric(19,5)
0.00

zDepartmentID char
''
zBillingWorkAmt numeric(19,5)
0.00

zQty numeric(19,5)
0.00

zQtyBilled numeric(19,5)
0.00

zEmployeeClass char
''
zUnitCost numeric(19,5)
0.00

zUnitPrice numeric(19,5)
0.00

zEquipmentAccountIndex int
0
zEquipmentAccountString char
''
zRevenueAmt numeric(19,5)
0.00

zEquipOffsetAccountIndex int
0
zOriginatingRevenueAmt numeric(19,5)
0.00

zEquipOffsetAcctString char
''
zCostAmtEntered numeric(19,5)
0.00

zCostAmt numeric(19,5)
0.00

zOriginatingCostAmt numeric(19,5)
0.00

zExclude tinyint
0
zPayGroupID char(15)
''

zPayrollStatusDDL smallint
0

zExpirationDate datetime
'1900-01-01'
zEmployeeID char(15)
''

zEmployeeName char(65)
''

zHoursEntered numeric(19,5)
0.00

zHoursPaid numeric(19,5)
0.00

zPayRecord char(7)
''

zItemID char(31)
''

zHC_1 smallint
0
zHC_2 smallint
0
zItemDescription char(51)
''

zHC_3 smallint
0
zUofM char(9)
''

See I... more text available
zHC_4 smallint
0
zItemQty numeric(19,5)
0.00

zHC_5 smallint
0
zBurdenStatusDDL smallint
0

zHC_6 smallint
0
zUserDefinedDate datetime
'1/1/1900'

zUserDefinedDate2 datetime
'1/1/1900'

zHC_7 smallint
0
zHC_8 smallint
0
zUserDefinedString char(21)
''

zUserDefinedString2 char(21)
''

zHC_9 smallint
0
zUserDefinedCurrency numeric(19,5)
0.00

zUserDefinedCurrency2 numeric(19,5)
0.00

zVendorID char(15)
''

zImportNumber char
''
zImportRow int
0
zReference char(31)
''

zImportTypeDDL smallint
0
zGLSourceDoc char(11)
''

zGLOpenYear smallint
0

zGLClosedYear smallint
0

zGLPeriodID smallint
0

zLaborAccountIndex int
0
zLaborAccountString char
''
zGLHistoryTrx tinyint
0

zNoteIndex numeric(19,5)
0.00

zMasterProjectID char
''
zMaterialAccountIndex int
0
zLaborRateProcessingDDL smallint
0

zMaterialAccountString char
''
zErrorDescription char(81)
''

zNoMarkup tinyint
0
DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
zNoStdLaborPosting tinyint
0
zErrorDetail text
zPayCodeID char
''
zProjectDescription char
''
zProjectSort1 char
''
zProjectSort2 char
''
zProjectSort3 char
''
zProjectStatusDDL smallint
0
 p>Project ...(more) Join Now
zProjectSubType char
''
zProjectType char
''
zPurchaseAccountIndex int
0
zPurchaseAccountString char
''
zQtyBilling numeric
0.00
zRateID char
''
zRenewalDate datetime
'1900-01-01'
zRenewalQty numeric
0.00
zRenewalRevenueAmt numeric
0.00
zRenewalUnitPrice numeric
0.00
zSalesPersonID char
''
zShipToAddressCode char
''
zSOPInvoiceTypeID char
''
zSOPReturnTypeID char
''
zSubContractAccountIndex int
0
zSubContractAcctString char
''
zSubscriptionCB tinyint
0
zTaskDescription char
''
zTaskLevel smallint
0
zTaskParent char
''
zTaskSort1 char
''
zTaskSort2 char
''
zTaskSort3 char
''
zTaskStatusDDL smallint
0
zTaskSubType char
''
zTaskType char
''
zTerritoryID char
''
zTotalTimeStatusDDL smallint
0
zUDCheckBox_1 tinyint
0
zUDCheckBox_2 tinyint
0
zUDCheckBox_3 tinyint
0
zUDCheckBox_4 tinyint
0
zUDCheckBox_5 tinyint
0
zUDCheckBox_6 tinyint
0
zUDCheckBox_7 tinyint
0
zUDCheckBox_8 tinyint
0
zUDCheckBox_9 tinyint
0
zUDCheckBox_10 tinyint
0
zUDCheckBox_11 tinyint
0
zUDCheckBox_12 tinyint
0
zUDCheckBox_13 tinyint
0
zUDCheckBox_14 tinyint
0
zUDCheckBox_15 tinyint
0
zUDCurrency2_1 numeric
0.00
zUDCurrency2_2 numeric
0.00
zUDCurrency2_3 numeric
0.00
zUDCurrency5_1 numeric
0.00
zUDCurrency5_2 numeric
0.00
zUDDate_1 datetime
'1900-01-01'
zUDDate_2 datetime
'1900-01-01'
zUDDate_3 datetime
'1900-01-01'
zUDDate_4 datetime
'1900-01-01'
zUDDate_5 datetime
'1900-01-01'
zUDDate_6 datetime
'1900-01-01'
zUDDate_7 datetime
'1900-01-01'
zUDDate_8 datetime
'1900-01-01'
zUDDate_9 datetime
'1900-01-01'
zUDDate_10 datetime
'1900-01-01'
zUDLong_1 int
0
zUDLong_2 int
0
zUDLong_3 int
0
zUDLong_4 int
0
zUDLong_5 int
0
zUDString20_1 char
''
zUDString20_2 char
''
zUDString20_3 char
''
zUDString20_4 char
''
zUDString20_5 char
''
zUDString20_6 char
''
zUDString20_7 char
''
zUDString20_8 char
''
zUDString20_9 char
''
zUDString30_1 char
''
zUDString30_2 char
''
zUDString30_3 char
''
zUDString30_4 char
''
zUDString30_5 char
''
zUDString50_1 char
''
zUDString50_2 char
''
zUDString50_3 char
''
zUDString50_4 char
''
zUDString50_5 char
''
zUDString50_6 char
''
zUDString50_7 char
''
zUDString50_8 char
''
zUDString50_9 char
''
zUDString50_10 char
''
zUDString50_11 char
''
zUDString50_12 char
''
zUDString50_13 char
''
zUDString50_14 char
''
zUDString50_15 char
''
zUnitCostOptionDDL smallint
0
zUnitPriceOptionDDL smallint
0
zValuationClassID char
''
zWorkOrderNumber char
''
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