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

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.