Dynamics GP Table Reference - COMPANY..BMPS0114 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 Manufacturing tables BMPS0114

You are currently viewing the COMPANY database.
Change

COMPANY..BMPS0114 Table Definition

(COMPANY..pref_bom_sys)

Field Definitions:

What is the 'source' column?

	Column Name	Data Type Default Value		Source
	CMPANYID	smallint 0	Company ID...(more) Join Now	POP10100.CMPANYID
join ... more text available
	BOMSCROLLDEF1_I_1	tinyint 0

	BOMSCROLLDEF1_I_2	tinyint 0

	BOMSCROLLDEF1_I_3	tinyint 0

	BOMSCROLLDEF1_I_4	tinyint 0

	BOMSCROLLDEF1_I_5	tinyint 0

	BOMSCROLLDEF1_I_6	tinyint 0

	BOMSCROLLDEF1_I_7	tinyint 0

	BOMSCROLLDEF1_I_8	tinyint 0

	BOMSCROLLDEF1_I_9	tinyint 0

	BOMSCROLLDEF1_I_10	tinyint 0

	BOMSCROLLDEF1_I_11	tinyint 0

	BOMSCROLLDEF1_I_12	tinyint 0

	BOMSCROLLDEF1_I_13	tinyint 0

	BOMSCROLLDEF1_I_14	tinyint 0

	BOMSCROLLDEF1_I_15	tinyint 0

	BOMSCROLLDEF1_I_16	tinyint 0

	BOMSCROLLDEF1_I_17	tinyint 0

	BOMSCROLLDEF1_I_18	tinyint 0

	BOMSCROLLDEF1_I_19	tinyint 0

	BOMSCROLLDEF2_I_1	tinyint 0

	BOMSCROLLDEF2_I_2	tinyint 0

	BOMSCROLLDEF2_I_3	tinyint 0

	BOMSCROLLDEF2_I_4	tinyint 0

	BOMSCROLLDEF2_I_5	tinyint 0

	BOMSCROLLDEF2_I_6	tinyint 0

	BOMSCROLLDEF2_I_7	tinyint 0

	BOMSCROLLDEF2_I_8	tinyint 0

	BOMSCROLLDEF2_I_9	tinyint 0

	BOMSCROLLDEF2_I_10	tinyint 0

	BOMSCROLLDEF2_I_11	tinyint 0

	BOMSCROLLDEF2_I_12	tinyint 0

	BOMSCROLLDEF2_I_13	tinyint 0

	BOMSCROLLDEF2_I_14	tinyint 0

	BOMSCROLLDEF2_I_15	tinyint 0

	BOMSCROLLDEF2_I_16	tinyint 0

	BOMSCROLLDEF2_I_17	tinyint 0

	BOMSCROLLDEF2_I_18	tinyint 0

	BOMSCROLLDEF2_I_19	tinyint 0

	BOMSCROLLLABEL_I_1	char(21) ''

	BOMSCROLLLABEL_I_2	char(21) ''

	BOMSCROLLLABEL_I_3	char(21) ''

	BOMSCROLLLABEL_I_4	char(21) ''

	BOMSCROLLLABEL_I_5	char(21) ''

	BOMSCROLLLABEL_I_6	char(21) ''

	BOMSCROLLLABEL_I_7	char(21) ''

	BOMSCROLLLABEL_I_8	char(21) ''

	BOMSCROLLLABEL_I_9	char(21) ''

	BOMSCROLLLABEL_I_10	char(21) ''

	BOMSCROLLLABEL_I_11	char(21) ''

	BOMSCROLLLABEL_I_12	char(21) ''

	BOMSCROLLLABEL_I_13	char(21) ''

	BOMSCROLLLABEL_I_14	char(21) ''

	BOMSCROLLLABEL_I_15	char(21) ''

	BOMSCROLLLABEL_I_16	char(21) ''

	BOMSCROLLLABEL_I_17	char(21) ''

	BOMUSERDEFLABEL1_I	char(21) ''

	BOMUSERDEFLABEL2_I	char(21) ''

	OFFSET_FROM_I	smallint 0

	BOMARCHIVEMASSCHG	tinyint 0

	BOMEXCLUDEARCHIVED	tinyint 0

	BOMEXCLUDECONFIG	tinyint 0

	BOMEXCLUDEENG	tinyint 0

	BOMEXCLUDESUPER	tinyint 0

	BOMEXCLUDEMFG	tinyint 0

	SECURITY_SETI	char(31) ''

	GRAPH_BOM_VS	smallint 0

	USEPHNTMSISSTO	tinyint 0

	COPY_REVISION_HISTORY_I	tinyint 0

	POS_NUM_INCREMENT	smallint 0

	ROLLUP_PHANTOM_LABOR_I	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..BMPS0114 Table Definition

Field Definitions: