BM30300 - Assembly Component History
Dynamics GP table BM30300 (Assembly Component History) contains 41 columns including TRX_ID, Component_ID, Parent_Component_ID....
SQL Query Builder
41 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 | ||
| 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 | ||
| Variance_Index | Variance Index | Long Integer | 4 | ||
| Variance_Account_Reference | Variance Account Reference | String | 32 | ||
| 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 | ||
| 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 | ||
| Inventory_Account_Note_I | Inventory Account Note Index | Currency | 10 | ||
| Variance_Account_Note_In | Variance Account Note Index | Currency | 10 | ||
| BM_Component_Errors | BM Component Errors | Long Integer | 4 | ||
| TRXSORCE | TRX Source | String | 14 | ||
| BIN | Bin | String | 16 | ||
Related Tables
Tables that share columns with BM30300. Click "Join" to add to your query.