Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
MOPRCTNM | MOP Receipt Number |
String | 22 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
PICKLISTSEQ | Picklist Seq |
Long Integer | 4 | View | |
POSITION_NUMBER | Position Number |
Integer | 2 | View | |
POSITION_NUMBER2 | Position Number2 |
Integer | 2 | View | |
USERID | User ID |
String | 16 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
ITMTRKOP | Item Tracking Option 1. None |
Integer | 2 | View | |
QTYPLANNEDTOCONSUME | QTY Planned To Consume |
Currency | 10 | View | |
QTYPLANNEDTOBACKFLUSH | QTY Planned To Backflush |
Currency | 10 | View | |
QTYTOCONSUME | QTY To Consume |
Currency | 10 | View | |
QTYTOBACKFLUSH | QTY To Backflush |
Currency | 10 | View | |
BACKFLUSHSITEID | Backflush Site ID |
String | 12 | View | |
BYPRODUCTSITEID | Byproduct Site ID |
String | 12 | View | |
QTYTOUSE | QTY To Use |
Currency | 10 | View | |
UOFM | U Of M |
String | 10 | View | |
MOP_REQUIRED_QUANTITY_I | MOP Required Quantity |
Currency | 10 | View | |
WIPQUANTITY | WIP Quantity |
Currency | 10 | View | |
QTYAVAIL | QTY Available |
Currency | 10 | View | |
QTYCONSUMEDTODATE | QTY Consumed To Date |
Currency | 10 | View | |
QTYBACKFLUSHEDTODATE | QTY Backflushed To Date |
Currency | 10 | View | |
QTYSLCTD | QTY Selected |
Currency | 10 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
NUMBERSCRAPPED_I | Number Scrapped |
Currency | 10 | View | |
BOMSINGLELOT_I | BOM_Single_Lot |
Boolean | 2 | View | |
BACKFLUSHCB | Backflush CB |
Boolean | 2 | View | |
ATYALLOC | QTY Allocated |
Currency | 10 | View | |
PLNDFIXDQTYTOCONS | Planned Fixed Quantity to Consume |
Currency | 10 | View | |
PLNDFIXDQTYTOBF | Planned Fixed Quantity to Backflush |
Currency | 10 | View | |
FIXDQTYTOCONS | Fixed Quantity to Consume |
Currency | 10 | View | |
FIXDQTYTOBF | Fixed Quantity to Backflush |
Currency | 10 | View | |
QTYSELCTDBF | QTY Selected Backflushed |
Currency | 10 | View | |
FLOORSTOCK_I | Floor Stock |
Boolean | 2 | View | |
NONINVENTORY | Non Inventory |
Boolean | 2 | View | |
STR20DUMMY_I | STR20 Dummy |
String | 22 | View | |
ITEMTYPE | Item Type 1. Sales Inventory (For SBM, this type is Stock Item.) |
Integer | 2 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
SUBASSEMBLYOF_I | Subassembly Of |
String | 32 | View |