CST_PREP_RESOLVE_IDS_GT
This temporary table is used to resolve any IDs during Costing pre-processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Code identifying the external system owning this transaction. | |
EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the transaction. | |
WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying the work order. | ||
WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work order operation. | ||
WO_OPERATION_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying the work order operation transaction. | ||
CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying a work order in costing. | ||
CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying a work order operation in costing. | ||
CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Surrogate ID identifying the manufacturing operation transaction creating the material transaction. |