CST_OPERATION_TXNS_S_GT
This table is used to temporarily store a subset of the data from cst_operation_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_OPERATION_TXNS_S_GT_PK |
OPERATION_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| OPERATION_TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation transaction in costing. This column will use the existing sequence for CST_TRANSACTION to avoid id duplicating across the tables. | |
| 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. | |
| INVENTORY_ORGANIZATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the plant where the operation was performed. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary product associated to the work order where the resource was consumed. | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Identifies the item cost profile of the primary product of the Work Order associated to the operation transaction. | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies the Asset/Expense Cost Profile linked to the item cost profile. This cost profile is used to get the valuation options for the transaction. | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Cost transaction type for the transaction. E.g. RECEIPT/ISSUE. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Transaction type identifier. For operation transactions this value comes from CST_INTERNAL_TXN_TYPES_VL. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Transaction source type identifier. For operation 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 operation transactions this value will come from CST_INTERNAL_TXN_TYPES_VL. | |
| 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. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | For R11, this is the same as the Transaction Source Doc Number. | ||
| PRIMARY_QUANTITY | NUMBER | Yes | Transaction quantity in primary unit of measure. | ||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Yes | Primary unit of measure for the item. | |
| TRANSACTION_QUANTITY | NUMBER | Yes | Transactional primary product quantity that is moved. | ||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Yes | Transactional unit of measure of the primary product quantity that is moved. | |
| CST_WO_OPERATION_TXN_ID | NUMBER | 18 | Yes | Surrogate ID identifying the operation transaction in costing. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order for which operation transaction was performed. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation at which this operation was performed. | |
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Number identifying the operation sequence within a work order. This is the sequence in which operation will be performed in the work order. | ||
| FROM_DISPATCH_STATE | VARCHAR2 | 30 | Yes | The status from which this transaction takes place. Lookup type WIE_DISPATCH_STATE. | |
| TO_DISPATCH_STATE | VARCHAR2 | 30 | Yes | The end resulting status where the transaction quantity moves to. Lookup type WIE_DISPATCH_STATE. | |
| WORK_CENTER_ID | NUMBER | 18 | Surrogate ID identifying the work center where the operation was performed. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | Identifies the date and time when the transaction was performed. | ||
| COST_DATE | TIMESTAMP | Costing internal date derived for sequencing of transactions for processing. | |||
| 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. | ||
| PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Indicates how to process partial completions. Possible Values: Value at standard cost Value at last actual cost Value at perpetual average cost. | ||
| OPERATION_SCRAP_COST_TYPE | VARCHAR2 | 30 | Indicates how to handle scrap costs. Can take the following values: Include in Inventory - remaining quantity absorbs the full work order costs. Expense Out - scrap cost is expensed out. | ||
| OPERATION_SCRAP_VALUATION_TYPE | VARCHAR2 | 30 | Indicates when to calculate the value of scrap transactions. Can take the following values: -Value at WO close -Value immediately and at WO close -Value at cost cutoff date and WO close | ||
| REASON_CODE | VARCHAR2 | 30 | Reason for either rejecting the quantities at the operation or scrapping at the operation. | ||
| WO_UPDATE_EVENT_TXN_ID | NUMBER | 18 | Surrogate ID identifying the work order close transaction. This reference is used to track if the scrap transaction was available in the system during work order close. | ||
| PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | Indicates the preprocessing status of the transactions. Possible values are SUCCESS, ERROR. | |
| POSTED_FLAG | VARCHAR2 | 5 | Indicates if the transaction has been processed and costs created in CST_OPERATION_TXN_COSTS. | ||
| ERROR_CODE | VARCHAR2 | 30 | FND error code identifying the error message in case the transaction is in error. | ||
| 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_OPERATION_TXNS_S_GT_U1 | Unique | OPERATION_TRANSACTION_ID |