eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: WMS_LPN_HISTORIES

Product:	WMS - Warehouse Management
Description:	Used to store the history information related to the container's past transactions
Implementation/DBA Data:	WMS.WMS_LPN_HISTORIES

Primary Key: WMS_LPN_HISTORIES_PK

LPN_HISTORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.PARENT_LPN_ID
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.LPN_ID
WMS_LPN_HISTORIES	MTL_SYSTEM_ITEMS_B	WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_HISTORIES	MTL_ITEM_REVISIONS_B	WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.REVISION
WMS_LPN_HISTORIES	MTL_LOT_NUMBERS	WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.LOT_NUMBER
WMS_LPN_HISTORIES	MTL_SERIAL_NUMBERS	WMS_LPN_HISTORIES.SERIAL_NUMBER WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_HISTORIES	WMS_LICENSE_PLATE_NUMBERS	WMS_LPN_HISTORIES.OUTERMOST_LPN_ID
WMS_LPN_HISTORIES	MTL_ITEM_LOCATIONS	WMS_LPN_HISTORIES.LOCATOR_ID WMS_LPN_HISTORIES.ORGANIZATION_ID
WMS_LPN_HISTORIES	MTL_SECONDARY_INVENTORIES	WMS_LPN_HISTORIES.SUBINVENTORY_CODE WMS_LPN_HISTORIES.ORGANIZATION_ID