BM10300 - Assembly Component | Prospr - Dynamics GP Table Reference

BM10300 - Assembly Component

Query Builder

Select * from BM10300

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRX_ID	TRX ID	String	20	View
Component_ID	Component ID	Long Integer	4	View
Parent_Component_ID	Parent Component ID	Long Integer	4	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
UOFM	U Of M	String	10	View
LOCNCODE	Location Code	String	12	View
Location_Code_Note_Index	Location Code Note Index	Currency	10	View
Stock_Quantity	Stock Quantity	Currency	10	View
Assemble_Quantity	Assemble Quantity	Currency	10	View
ATYALLOC	QTY Allocated	Currency	10	View
BM_Stock_Method	BM Stock Method	Integer	2	View
Cost_Type	Cost Type	Integer	2	View
INVINDX	Inventory Index	Long Integer	4	View
Inventory_Account_Reference	Inventory Account Reference	String	32	View
Inventory_Account_Note_I	Inventory Account Note Index	Currency	10	View
Variance_Index	Variance Index	Long Integer	4	View
Variance_Account_Reference	Variance Account Reference	String	32	View
Variance_Account_Note_In	Variance Account Note Index	Currency	10	View
Design_Quantity	Design Quantity	Currency	10	View
Scrap_Percentage	Scrap Percentage	Integer	2	View
STNDCOST	Standard Cost	Currency	10	View
Standard_Quantity	Standard Quantity	Currency	10	View
Extended_Standard_Cost	Extended Standard Cost	Currency	10	View
Extended_Standard_Quantity	Extended Standard Quantity	Currency	10	View
Ext_Assemble_Qty_Posting_Cost	Ext Assemble Qty Posting Cost	Currency	10	View
Ext_Stock_Receipt_Cost	Ext Stock Receipt Cost	Currency	10	View
Ext_Stock_Qty_Posting_Cost	Ext Stock Qty Posting Cost	Currency	10	View
Ext_Subasm_Posting_Cost	Ext Subasm Posting Cost	Currency	10	View
Ext_Subasm_Receipt_Cost	Ext Subasm Receipt Cost	Currency	10	View
BM_Component_Type	BM Component Type	Integer	2	View
Lvl	Level	Integer	2	View
QTYBSUOM	QTY In Base U Of M	Currency	10	View
Assemble_Serial_Lot_Count	Assemble Serial Lot Count	Currency	10	View
Stock_Serial_Lot_Count	Stock Serial Lot Count	Currency	10	View
Temp_Allocated_Quantity	Temp Allocated Quantity	Currency	10	View
Temp_Assemble_Quantity	Temp Assemble Quantity	Currency	10	View
Temp_Extended_Assemble_Q	Temp Extended Assemble Quantity	Currency	10	View
Temp_Location_Code	Temp Location Code	String	12	View
Temp_Stock_Quantity	Temp Stock Quantity	Currency	10	View
Temp_Extended_Stock_Quan	Temp Extended Stock Quantity	Currency	10	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
BM_Component_Errors	BM Component Errors	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
EXTQTYAL	Existing Qty Available	Currency	10	View
EXTQTYSEL	Existing Qty Selected	Currency	10	View
Temp_Extended_Standard_Q	Temp Extended Standard Quantity	Currency	10	View
Temp_Existing_Quantity_A	Temp Existing Quantity Available	Currency	10	View
Incl	Include	Integer	2	View
BM_Component_Options	BM Component Options	Long Integer	4	View
BIN	Bin	String	16	View

BM10300 - Assembly Component

Query Builder

Customer Service

Information

My Account

Contact Us