GP Tables

BM10300 - Assembly Component

Dynamics GP table BM10300 (Assembly Component) contains 54 columns including TRX_ID, Component_ID, Parent_Component_ID....

SQL Query Builder

54 Columns

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

Related Tables

Tables that share columns with BM10300. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

ITEMNMBR

AAG20001 AAG20011 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

LOCNCODE

ASIEXP04 ASIEXP06 ASIEXP11 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23

DECPLCUR

AAG2001T ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23

DECPLQTY

AAG00400 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

ITEMDESC

ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24 ASIEXP26

UOFM

ADItemP2 ADItemPr ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP26 ASIEXP28 BM00101

ITMTRKOP

ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24 ASIEXP28

INVINDX

ASIEXP20 ASIEXP21 ASIEXP26 ASIEXP28 BM30300 ENCAA10210V IVC10101 POP10110