BM10400 - Assembly Serial Lot
Dynamics GP table BM10400 (Assembly Serial Lot) contains 21 columns including TRX_ID, Component_ID, SLTYPE....
SQL Query Builder
21 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| TRX_ID | TRX ID | String | 20 | ||
| Component_ID | Component ID | Long Integer | 4 | ||
| SLTYPE | Serial/Lot Type | Integer | 2 | ||
| SLTSQNUM | Serial/Lot SEQ Number | Long Integer | 4 | ||
| SERLTNUM | Serial/Lot Number | String | 22 | ||
| SERLTQTY | Serial/Lot QTY | Currency | 10 | ||
| ITEMNMBR | Item Number | String | 32 | ||
| QTYTYPE | QTY Type1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | Integer | 2 | ||
Quantity Type values (5) 1 = On Hand2 = Returned3 = In Use4 = In Service5 = Damaged | |||||
| DATERECD | Date Received | Date | 4 | ||
| DTSEQNUM | Date SEQ Number | Currency | 10 | ||
| OVRSERLT | Override Serial/Lot | Integer | 2 | ||
| PARSLSEQN | Parent Serial/Lot SEQ Number | Long Integer | 4 | ||
| Parent_Component_ID | Parent Component ID | Long Integer | 4 | ||
| ITMTRKOP | Item Tracking Option1. None2. Serial Numbers3. Lot Numbers | Integer | 2 | ||
Item Tracking Option values (3) 1 = None2 = Serial Numbers3 = Lot Numbers | |||||
| TRXSORCE | TRX Source | String | 14 | ||
| UNITCOST | Unit Cost | Currency | 10 | ||
| Status | Status | Integer | 2 | ||
| LOCNCODE | Location Code | String | 12 | ||
| BIN | Bin | String | 16 | ||
| MFGDATE | Manufacture Date | Date | 4 | ||
| EXPNDATE | Expiration Date | Date | 4 | ||
Related Tables
Tables that share columns with BM10400. Click "Join" to add to your query.