CST_WO_UPD_EVENT_TO_PROC_GT

This table stores the distinct set of work order close transactions for which item cost profiles need to be established.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
CST_WO_UPDATE_EVENT_ID	NUMBER		18	Surrogate ID identifying the work order update event.
COST_ORG_ID	NUMBER		18	Surrogate ID identifying the cost organization.
COST_BOOK_ID	NUMBER		18	Surrogate ID identifying the cost book.
MASTER_ORGANIZATION_ID	NUMBER		18	Surrogate ID identifying the master organization associated to the cost organization.
INVENTORY_ITEM_ID	NUMBER		18	Surrogate ID identifying the end item on the work order.
COST_PROFILE_TYPE_FLAG	VARCHAR2	1		Indicates the cost profile type to be generated A or E.
BASE_TXN_SOURCE_TYPE_ID	NUMBER		18	Surrogate ID indicating the base txn type.
BASE_TXN_ACTION_ID	NUMBER		18	Surrogate ID identifying the base transaction action.
CST_WORK_ORDER_ID	NUMBER		18	Surrogate ID identifying the work order in costing.
EVENT_DATE	TIMESTAMP			Identifies the system date time when the work order update was performed.
TRANSACTION_DATE	TIMESTAMP			Indicates the date entered by the user while making the status change.
WORK_ORDER_STATUS_ID	NUMBER		18	Surrogate ID identifying the current work order status.
WO_SYSTEM_STATUS_CODE	VARCHAR2	30		Indicates the system status code derived using WIE_WO_STATUSES_VL.
PRIOR_WORK_ORDER_STATUS_ID	NUMBER		18	Surrogate ID identifying the prior work order status.
PRIOR_WO_SYSTEM_STATUS_CODE	VARCHAR2	30		Indicates the prior system status code derived using WIE_WO_STATUSES_VL.
LATEST_STATUS_FLAG	VARCHAR2	1		Indicates if the row represents the latest status for a work order.
INVENTORY_ORGANIZATION_ID	NUMBER		18	Manufacturing Organization in which the work order is created.
INVENTORY_ASSET_FLAG	VARCHAR2	1		Internal column. Indicates whether the end item on the work order is asset or expense.
WORK_ORDER_NUMBER	VARCHAR2	120		Work Order Number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level.