CST_PLANNING_WORK_ORDERS

This table contains the list of work orders which have been interfaced into cost planning for processing by cost rollup process.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CST_PLANNING_WORK_ORDERS_PK	PLANNING_WORK_ORDER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PLANNING_WORK_ORDER_ID	NUMBER		18	Yes	Indicates the surrogate key for the planning work orders table.
WORK_ORDER_ID	NUMBER		18	Yes	Indicates the work order identifier which is being interfaced for processing by cost rollup processor.
ORGANIZATION_ID	NUMBER		18	Yes	Indicates the plant for which the work order was created.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Refers to the top level, final assembly, or model item which belongs to the given organization.
WORK_ORDER_TYPE	VARCHAR2	30			Indicates the type of work order. Values are contained withing WIE_WO_TYPE lookup.
WORK_ORDER_SUB_TYPE	VARCHAR2	30			Sub type specifically would be populated for non-standard work order. This is used to derive the approporuate costing account for non-standard work. Values are contained in WIE_WO_SUB_TYPE lookup.
BOM_ITEM_TYPE	NUMBER				Indicates the type of item as whether CTO or standard. If the value is 4, then the work order created is for a CTO item.
WORK_DEFINITION_VERSION_ID	NUMBER		18		Indicates the work definition version of the work definition identified for the work order.
WORK_DEFINITION_ID	NUMBER		18		Indicates the work definition identified for the work order.
WORK_DEFINITION_AS_OF_DATE	TIMESTAMP				Indicates the date and time used to identify the work definition version for the work order.
PLANNED_START_QUANTITY	NUMBER			Yes	Indicates the planned work order quantity which should be greater than zero for standard work orders and can be equal to or greater than zero for non-standard work orders.
UOM_CODE	VARCHAR2	3		Yes	Indicates the UOM code of the planned start quantity. It is used to get the work definition explosion information using the manufacturing API.
PLANNED_START_DATE	TIMESTAMP				Indicates the planned start date of the work order.
ACTUAL_START_DATE	TIMESTAMP				Indicates the actual start date of the work order.
RELEASED_DATE	TIMESTAMP				Indicates the released date of the work order.
STATUS_CODE	VARCHAR2	30		Yes	Indicates the status of the interfaced work order. It is used internally by costing for knowing the status of processing for the work order.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index	Uniqueness	Tablespace	Columns
CST_PLANNING_WORK_ORDERS_PK	Unique	Default	PLANNING_WORK_ORDER_ID
CST_PLANNING_WORK_ORDERS_U1	Unique	Default	WORK_ORDER_ID