CST_WO_OPS_TO_VALIDATE

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COST_ORG_ID	NUMBER		18	Yes	Surrogate ID identifying the cost organization associated to the plant where the work order is executed.
COST_BOOK_ID	NUMBER		18	Yes	Surrogate ID identifying the cost book associated to the cost organization.
CST_WORK_ORDER_ID	NUMBER		18		Surrogate ID identifying the work order in costing.
CST_WORK_ORDER_OPERATION_ID	NUMBER		18	Yes	Surrogate ID identifying the work order operation in costing.
PARENT_CST_WO_OPERATION_ID	NUMBER		18		Identifies the parent work order operation in costing that is associated with this rework operation.
OPERATION_SEQ_NUMBER	NUMBER			Yes	Indicates a number that identifies the operation sequence within this work order.
CUTOFF_DATE	TIMESTAMP			Yes	Indicates the date and time used to filter the transactions.
PENDING_TXNS_FLAG	VARCHAR2	1			Indicates if there are any transactions pending to be processed for this operation.
WORK_METHOD_CODE	VARCHAR2	30			Indicates the work method of the work order.
WO_CLOSED_FLAG	VARCHAR2	1			Indicates if the work order is closed. Valid values are Y, N and Null.
WORK_ORDER_TYPE	VARCHAR2	30			Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. The value for which comes from a lookup_type = 'WIE_WO_TYPE'. This lookup is system defined and not alterable by the user.
INVENTORY_ITEM_ID	NUMBER		18		This refers to the primary product that needs to be manufactured and can be any active item that has the "Build in WIP" flag checked at the Item organization (plant) level.
SERVER_TZ_CUTOFF_DATE	TIMESTAMP				Indicates the server time zones date and time used to filter the transactions.
PAC_BOOK_FLAG	VARCHAR2	5			Indicates if it is a periodic average cost book. Valid values are N, Y and NULL.
RECOVERABLE_FLAG	VARCHAR2	1			Indicates if the error can get recovered within a cost processor job.
REWORK_FLAG	VARCHAR2	1			Flag used to indicate if this operation is a rework operation. Valid values: Y, N, or NULL (treated as N).
WORK_ORDER_ID	NUMBER		18		Surrogate ID identifying the work order in manufacturing.
CYCLIC_WORK_ORDER_FLAG	VARCHAR2	1			A flag that indicates whether the work order have same item as component and product for a non rework work order. Possible values are: NULL : Non cyclic work order, Y : Cyclic work order.
ENABLE_PARALLEL_OPS_FLAG	VARCHAR2	1			A flag that indicates whether parallel operations are enabled for this work order. Valid values for the flag are: N or null - denotes parallel operations are not enabled, Y - denotes parallel operations are enabled.
PARENT_OP_SEQ_NUMBERS	VARCHAR2	4000			Delimited list of all operations that precede the current operation in the operation dependency setup.
ALL_PARENT_OP_SEQ_NUMBERS	VARCHAR2	4000			Delimited list of all operations up to and including the highest-numbered (or last) operation being processed in the current job run.