CST_WO_OPS_TO_VALIDATE_GT
This transaction temporary table is used to load the distinct set of work order and operations for which pending transactions are to be evaluated.
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. | |
| 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. | ||
| WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying the work order in manufacturing. |