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. |