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     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