CST_WO_COMPLETION_TXNS_GT
This temporary table is used to hold the product completion transactions which are to be processed after the work order is closed.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying the transaction. | |
| COST_ORG_ID | NUMBER | 18 | Surrogate ID identifying the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Surrogate ID identifying the cost book. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Surrogate ID identifying the work order against which the transaction is made. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Surrogate ID identifying the work order operation against which the transaction was made. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Surrogate identifying the item associated with this transaction. | |
| COMPLETION_QUANTITY | NUMBER | Net product completion quantity for the work order. | ||
| COST_DATE | TIMESTAMP | Indicates the cost date for the transaction. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Surrogate ID identifying the base transaction type. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Surrogate ID identifying the base transaction source. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Surrogate ID identifying the base transaction action. | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Surrogate ID identifying the source transaction. | |
| WORK_METHOD_CODE | VARCHAR2 | 30 | Indicates the work method code on the work order. | |
| COST_ALLOCATION_PERCENTAGE | NUMBER | Indicates the allocation of costs for the process output item. | ||
| WO_OUTPUT_TYPE | VARCHAR2 | 30 | Indicates the type of output e.g. FIXED. | |
| TXN_QUANTITY | NUMBER | Indicates the transaction quantity for the product transaction. |