CST_WO_UPDATE_EVENT_TXNS_S_GT
This table is used to temporarily store a subset of the data from cst_wo_update_event_txns table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_UPD_EVENT_TXNS_S_GT_PK |
WO_UPDATE_EVENT_TXN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying a work order update event in costing. This column will reuse the CST_TRANSACTION_S sequence to maintain the uniqueness of transactions at the distribution level. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order for which update was performed. | |
| 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. | |
| EVENT_DATE | TIMESTAMP | Yes | Indicates the date and time when the work order update was performed. | ||
| TRANSACTION_DATE | TIMESTAMP | Indicates the date entered by user while making the status change. | |||
| LOGICAL_CLOSE_DATE | TIMESTAMP | Indicates the date and time when a close event is processed again because of more costs posted on a work order. For the original transaction received from source system this will remain NULL. | |||
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the plant associated to the work order. | |
| COST_DATE | TIMESTAMP | Cost date derived for sequencing the work order close transactions. | |||
| LE_TIMEZONE_CODE | VARCHAR2 | 50 | Legal Entity time zone. If NULL, then LE time zone is not enabled for the data in the row and the dates are assumed to be in database time zone. | ||
| CST_WO_UPDATE_EVENT_ID | NUMBER | 18 | Yes | Surrogate ID identifying the source update event in costing. | |
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Document Type of the transaction. E.g. "WO" indicating a Work Order. | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | Document Number of the transaction. This is the Work Order Number. | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | For R11, this is the same as the Transaction Source Doc Type. In later release this can be a FPO linked to a WO. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | For R11, this is the same as the Transaction Source Doc Number. In later release this can be a FPO Number linked to a WO. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Transaction type identifier. For close transactions this value comes from CST_INTERNAL_TXN_TYPES_VL. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Transaction source type identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. This value will always be 0. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Transaction action identifier. For close transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Identifies the item cost profile of the primary product of the Work Order associated to the close transaction. | ||
| COST_PROFILE_ID | NUMBER | 18 | Surrogate ID identifying the cost profile based on the item setup being asset/expense. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | Cost method associated with cost profile of the primary item. This will be used to determine how to process the job close transaction e.g. to expense or create variance. | ||
| TOTAL_COMPLETION_QUANTITY | NUMBER | This value would be populated at the time of processing this transaction to indicate the total completion quantity. | |||
| TOTAL_SCRAP_QUANTITY | NUMBER | This value would be populated at the time of processing this transaction to indicate the total scrap quantity. | |||
| PRODUCT_ADJ_PROCESSED_FLAG | VARCHAR2 | 5 | Yes | Indicates if product completions and returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y. | |
| UOM_CODE | VARCHAR2 | 3 | Indicates the unit of measure for the completion quantity. | ||
| SCRAP_ADJ_PROCESSED_FLAG | VARCHAR2 | 5 | Yes | Indicates if scrap and scrap returns have been adjusted after the work order close to reflect the latest WIP value. Default N. Valid values are X, N and Y. | |
| WORK_ORDER_STATUS_ID | NUMBER | 18 | Yes | Indicates the current status of the work order after the update. | |
| WO_SYSTEM_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the system status code derived using WIE_WO_STATUSES_VL. | |
| PRIOR_WORK_ORDER_STATUS_ID | NUMBER | 18 | Indicates the prior status of the work order before the update was performed. | ||
| PRIOR_WO_SYSTEM_STATUS_CODE | VARCHAR2 | 30 | Indicates the prior system status code derived using WIE_WO_STATUSES_VL. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary item associated to the work order. | |
| EXPENSE_REVERSED_FLAG | VARCHAR2 | 4 | Indicates the reversal status for the job close transaction that was earlier expensed. Possible values N - Not reversed, Y - Reversed and NULL. | ||
| REVERSAL_COST_DATE | TIMESTAMP | Indicates the cost date derived for booking the reversal of this expense transaction. | |||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | Indicates the preprocessing status SUCCESS, ERROR. | |
| ERROR_CODE | VARCHAR2 | 30 | FND error code identifying the error message in case the transaction is in error. | ||
| POSTED_FLAG | VARCHAR2 | 5 | Indicates whether the update transaction has been processed by the cost processor. N-No, Y-Yes Null. | ||
| COSTING_STATUS | VARCHAR2 | 1 | Status of the transaction which denotes, whether a transaction has been pre-processed, processed by cost processors, distributions have been created or processed by sub-ledger accounting etc. C Fully costed E Error N Not processed P Partially costed X Excluded W Pending | ||
| ACCOUNTING_STATUS | VARCHAR2 | 1 | Current accounting status of the transaction for display: D Draft accounted E Error F Final accounted N Not accounted X Excluded from accounting Z Not applicable | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_WO_UPD_EVENT_TXNS_S_GT_U1 | Unique | WO_UPDATE_EVENT_TXN_ID |