CST_PAC_OPERATION_TXNS_INT
This interface table is used to store work order operation transactions for processing by periodic average processor. Data in this table is cleaned at the end of processing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
CST_PAC_OPERATION_TXNS_INT_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. | |
OPERATION_ADJ_TXN_ID | NUMBER | 18 | Surrogate ID indicating the adjustment transaction which is triggered on work order close. | ||
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. | |
PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the primary product associated to the work order where the resource was consumed. | |
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. | ||
DEFAULT_COST_ELEMENT_ID | NUMBER | 18 | Identifies the default cost element to be used when a input cost is not available. | ||
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. | |
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. | |
TOTAL_SCRAP_QTY | NUMBER | Net total of scrap quantity reported at the work order operation linked to this operation transaction. | |||
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. | ||
EXECUTION_SEQUENCE | NUMBER | Indicates the execution sequence of the operation if the work order has re-sequence operations. | |||
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. | |||
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. | ||
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. | ||
POSTED_FLAG | VARCHAR2 | 5 | Yes | Indicates if the transaction has been processed and costs created in CST_OPERATION_TXN_COSTS. | |
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_TXNS_INT_N1 | Non Unique | DEFAULT | REQUEST_ID |
CST_PAC_OPERATION_TXNS_INT_U1 | Unique | DEFAULT | OPERATION_TRANSACTION_ID |