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

Product:	GMI - Process Manufacturing Inventory
Description:	Inventory period balances
Implementation/DBA Data:	GMI.IC_PERD_BAL

Primary Key: IC_PERD_BAL_PK

PERIOD_ID
WHSE_CODE
ITEM_ID
LOT_ID
LOCATION

Primary Key: IC_PERD_BAL_U1

FISCAL_YEAR
PERIOD
WHSE_CODE
ITEM_ID
LOT_ID
LOCATION

Foreign Keys

Table	Foreign Table	Foreign Key Column
IC_PERD_BAL	IC_LOTS_MST	IC_PERD_BAL.ITEM_ID IC_PERD_BAL.LOT_ID
IC_PERD_BAL	IC_LOTS_STS	IC_PERD_BAL.LOT_STATUS
IC_PERD_BAL	IC_WHSE_STS	IC_PERD_BAL.PERIOD_ID IC_PERD_BAL.WHSE_CODE
IC_PERD_BAL	QC_HRES_MST	IC_PERD_BAL.QCHOLD_RES_CODE