DW_INV_LOT_NUMBERS_G
This table stores inventory Lot number details. During receiving transactions, it will create entry based on receiving organization and lot number for an item.
Details
Module: Purchasing
Key Columns
LOT_NUMBER, INVENTORY_ITEM_ID, ORGANIZATION_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| INVENTORY_ITEM_ID | NUMBER | 38 | 0 | True | This identifies the inventory item. | ||
| ORGANIZATION_ID | NUMBER | 38 | 0 | True | This identifies the inventory organization. | ||
| LOT_NUMBER | VARCHAR2 | 128 | True | This number identifies an inventory lot. | |||
| SOURCE_RECORD_ID | VARCHAR2 | 256 | This column is for Oracle Internal use only. System | ||||
| DESCRIPTION | VARCHAR2 | 512 | Description for the Lot Number - Used by WMS only | ||||
| DISABLE_FLAG | VARCHAR2 | 32 | Flag indicates whether the lot number is disabled. | ||||
| EXPIRATION_DATE | DATE | This is the date of the lot expiration. | |||||
| MATURITY_DATE | DATE | The date on which the item matures - Used By WMS Only | |||||
| ORIGINATION_DATE | DATE | Lot creation date (as in the BRD) - Used By WMS Only | |||||
| CREATION_DATE | TIMESTAMP | The creation timestamp of the lot number row. |