This table stores inventory Lot number details. During receiving transactions, it will create entry based on receiving organization and lot number for an item.
Module: Purchasing
LOT_NUMBER, INVENTORY_ITEM_ID, ORGANIZATION_ID
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 | 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 |