INV_MIN_MAX_GT
Inventory Min-Max Replenishment Global Temporary table which is used by the Min-Max Replenishment report
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Comments |
|---|---|---|---|
| ITEM_SEGMENTS | VARCHAR2 | 800 | Item Number |
| DESCRIPTION | VARCHAR2 | 240 | Item description |
| ERROR | VARCHAR2 | 300 | Replenishment report error |
| SORTEE | VARCHAR2 | 300 | Replenishment report sorting order |
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Replenishment secondary inventory |
| MIN_QTY | NUMBER | Minimum replenishment quantity for the item | |
| MAX_QTY | NUMBER | Maximum replenishment quantity for the item | |
| ONHAND_QTY | NUMBER | Total on hand quantity for the item | |
| SUPPLY_QTY | NUMBER | Total supply quantity for the item | |
| DEMAND_QTY | NUMBER | Total demand quantity for the item | |
| TOT_AVAIL_QTY | NUMBER | Total available quantity for the item | |
| MIN_ORD_QTY | NUMBER | Minimum order quantity for the item | |
| MAX_ORD_QTY | NUMBER | Maximum order quantity for the item | |
| FIX_MULT | NUMBER | Fixed lot multiple for the item | |
| REORD_QTY | NUMBER | Replenishment order quantity for the item | |
| MINMAX_QTY_UOM | VARCHAR2 | 25 | Minimum Maximum quantity unit of measure |
| ORDER_QTY_UOM | VARCHAR2 | 25 | Replenishment order quantity unit of measure |