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

Product:	WIP - Work in Process
Description:	Stores periodic balance of all WIP entities within a cost group by period
Implementation/DBA Data:	WIP.WIP_PAC_PERIOD_BALANCES

Primary Key: WIP_PAC_PERIOD_BALANCES_UK

PAC_PERIOD_ID
COST_GROUP_ID
ORGANIZATION_ID
WIP_ENTITY_ID
LINE_ID
OPERATION_SEQ_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_PAC_PERIOD_BALANCES	CST_PAC_PERIODS	WIP_PAC_PERIOD_BALANCES.PAC_PERIOD_ID
WIP_PAC_PERIOD_BALANCES	CST_COST_GROUPS	WIP_PAC_PERIOD_BALANCES.COST_GROUP_ID
WIP_PAC_PERIOD_BALANCES	CST_COST_TYPES	WIP_PAC_PERIOD_BALANCES.COST_TYPE_ID
WIP_PAC_PERIOD_BALANCES	MTL_PARAMETERS	WIP_PAC_PERIOD_BALANCES.ORGANIZATION_ID
WIP_PAC_PERIOD_BALANCES	WIP_ENTITIES	WIP_PAC_PERIOD_BALANCES.WIP_ENTITY_ID
WIP_PAC_PERIOD_BALANCES	WIP_LINES	WIP_PAC_PERIOD_BALANCES.LINE_ID