CST_OPERATION_TRANSACTIONS
This entity will contain the operation transactions to be staged to the cost processor. The transactions are staged for each cost book within a cost organization.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_OPERATION_TRANSACTIONS_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_TRANSACTIONS to avoid id duplicating across the tables. | |
OP_YIELD_FACTOR | NUMBER | Indicates yield of a work order operation. | |||
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. | ||
RESEQUENCE_FLAG | VARCHAR2 | 1 | Flag used to indicate if the operation can be re-sequenced while executing the operation. Valid values are Y or N. | ||
EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence of the operation if the work order has re-sequence operations. | |||
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. | |||
PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
LE_TIMEZONE_CODE | VARCHAR2 | 50 | Legal Entity timezone. If NULL, then LE timezone is not enabled for the data in the row and the dates are assumed to be in database timezone. | ||
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 | Tablespace | Columns |
---|---|---|---|
CST_OPERATION_TRANSACTIONS_N1 | Non Unique | Default | POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID |
CST_OPERATION_TRANSACTIONS_N2 | Non Unique | Default | CST_WORK_ORDER_ID, COST_BOOK_ID |
CST_OPERATION_TRANSACTIONS_N3 | Non Unique | Default | COSTING_STATUS |
CST_OPERATION_TRANSACTIONS_N4 | Non Unique | Default | TXN_SOURCE_REF_DOC_NUMBER |
CST_OPERATION_TRANSACTIONS_N5 | Non Unique | Default | TRANSACTION_DATE |
CST_OPERATION_TRANSACTIONS_N6 | Non Unique | Default | INVENTORY_ITEM_ID, TRANSACTION_DATE |
CST_OPERATION_TRANSACTIONS_N7 | Non Unique | Default | ACCOUNTING_STATUS |
CST_OPERATION_TRANSACTIONS_PK | Unique | Default | OPERATION_TRANSACTION_ID |
CST_OPERATION_TRANSACTIONS_U1 | Unique | Default | COST_ORG_ID, COST_BOOK_ID, CST_WO_OPERATION_TXN_ID |