Dynamics GP Table Reference - COMPANY..B3900100 fields

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

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Module List > Module BS tables B3900100

You are currently viewing the COMPANY database.
Change

COMPANY..B3900100 Table Definition

(COMPANY..BSSI_Setup)

Field Definitions:

What is the 'source' column?

Column Name	Data Type Default Value		Source
SETUPKEY	smallint 0	Setup Key...(more) Join Now	ASILOC90.SETUPKEY

BSSI_Facility_Segment	char(15) ''

BSSI_Department_Segment	char(15) ''

BSSI_Department_ID	char(67) ''

BSSI_AutoNumbering	tinyint 0

BSSI_Reuse_Number	tinyint 0

BSSI_Vendor_Security	tinyint 0

BSSI_Item_Security	tinyint 0

BSSI_Site_Security	tinyint 0

BSSI_Account_Security	tinyint 0

BSSI_Customer_Security	tinyint 0

BSSI_Use_AP	tinyint 0

BSSI_Use_AR	tinyint 0

BSSI_Use_Payroll	tinyint 0

BSSI_Use_POP	tinyint 0

BSSI_Use_SOP	tinyint 0

BSSI_Use_CA	tinyint 0

BSSI_Use_Inventory	tinyint 0

BSSI_Use_Fixed_Assets	tinyint 0

BSSI_Use_Project_Account	tinyint 0

BSSI_Automatic_Intercomp	tinyint 0

BSSI_Enable_SOP_Replace_	tinyint 0

BSSI_Credit_Memo_IC	tinyint 0

BSSI_Portfolio_Security	tinyint 0

BSSI_Payroll_IC	tinyint 0

BSSI_Disable_MFP	tinyint 0

BSSI_Disable_Cost_Cate	tinyint 0

BSSI_Disable_Acct_Subst	tinyint 0

BSSI_AP_Mass_Setup	smallint 0

BSSI_FA_IsOnlyDefault_Ac	tinyint 0

BSSI_GL_Security	tinyint 0

BSSI_EnableBankTransfer	tinyint 0

BSSI_Print1099ByChild	tinyint 0

BSSI_EnableCashAcctSub	tinyint 0

BSSI_SmartList_Security	tinyint 0

BSSI_EnableJECreationOnA	tinyint 0

BSSI_EnableStopPost	tinyint 0

BSSI_DisableAutoRollDown	tinyint 0

BSSI_EnableGLLockDown	tinyint 0

BSSI_EnablePayrollTaxes	tinyint 0

BSSI_EnableDiscByChild	tinyint 0

BSSI_bDisableIntransitTo	tinyint 0

BSSI_bEnableWithholdin	tinyint 0

BSSI_bEnableWithholdWith	tinyint 0

BSSI_dWithholdWith1099Li	numeric(19,5) 0.00

BSSI_Use_Manufacturing	tinyint 0

BSSI_EnablePRJSecByUser	tinyint 0

BSSI_DisablePayrollAccou	tinyint 0

BSSI_EnablePaymentSecuri	tinyint 0

BSSI_DisableProjectAcctS	tinyint 0

BSSI_DisableFinancialRep	tinyint 0

BSSI_EnableVendorClassRo	tinyint 0

BSSI_Use_PDK	tinyint 0

BSSI_EnableDistBySOPItem	tinyint 0

BSSI_PDKFacilityFromEmp	tinyint 0

BSSI_bEnablePeriodCloseF	tinyint 0

BSSI_EDIFacility	smallint 0

BSSI_UniqFacilityByCust	tinyint 0

BSSI_UniqFacilityByItem	tinyint 0

BSSI_Use_BasicWS	tinyint 0

BSSI_bEnableHomeFacility	tinyint 0

BSSI_Use_AdvancedWS	tinyint 0

BSSI_bEnablePOPFacilityB	tinyint 0

BSSI_UseCN	tinyint 0

BSSI_bEnStopPostForActSb	tinyint 0

BSSI_bDisableFacCkbookID	tinyint 0

BSSI_UseRMA	tinyint 0

DEX_ROW_ID	int auto number (1,1)	Unique ide...(more) Join Now

Table Definition Quick Links

All Tables

SOP Tables

RM Tables

GL Tables

POP Tables

HR Tables

PM Tables

UPR Tables

IV Tables

Olympic Tables

DynDeveloper.com

COMPANY..B3900100 Table Definition

Field Definitions: