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_SHOP_FLOOR_STATUSES

Product:	WIP - Work in Process
Description:	Statuses assigned to particular jobs and schedules
Implementation/DBA Data:	WIP.WIP_SHOP_FLOOR_STATUSES

Primary Key: WIP_SHOP_FLOOR_STATUSES_PK

WIP_ENTITY_ID
OPERATION_SEQ_NUM
SHOP_FLOOR_STATUS_CODE
LINE_ID
INTRAOPERATION_STEP_TYPE

Foreign Keys

Table	Foreign Table	Foreign Key Column
WIP_SHOP_FLOOR_STATUSES	WIP_SHOP_FLOOR_STATUS_CODES	WIP_SHOP_FLOOR_STATUSES.SHOP_FLOOR_STATUS_CODE WIP_SHOP_FLOOR_STATUSES.ORGANIZATION_ID
WIP_SHOP_FLOOR_STATUSES	WIP_LINES	WIP_SHOP_FLOOR_STATUSES.LINE_ID
WIP_SHOP_FLOOR_STATUSES	WIP_ENTITIES	WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID
WIP_SHOP_FLOOR_STATUSES	WIP_DISCRETE_JOBS	WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID
WIP_SHOP_FLOOR_STATUSES	WIP_REPETITIVE_ITEMS	WIP_SHOP_FLOOR_STATUSES.WIP_ENTITY_ID WIP_SHOP_FLOOR_STATUSES.LINE_ID