CST_OPERATION_TXNS_GT
Transaction temporary table will be used to hold the operation transactions before they are inserted in operation transactions table.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
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. | ||
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 | Indicates the work center where the operation was performed. | ||
TRANSACTION_DATE | TIMESTAMP | Yes | Identifies the date and time when the transaction was performed. | ||
PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Possible Values: Value at standard cost Value at last actual cost Value at perpetual average cost. | ||
OPERATION_SCRAP_COST_TYPE | VARCHAR2 | 30 | Can take the following values: Include in Inventory Expense Out | ||
OPERATION_SCRAP_VALUATION_TYPE | VARCHAR2 | 30 | 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. | ||
PREPROCESSING_STATUS | VARCHAR2 | 30 | Yes | Indicates the preprocessing status of the operation transaction. Possible values are SUCCESS/ERROR. | |
POSTED_FLAG | VARCHAR2 | 5 | Indicates the posted flag. Possible values E/N. | ||
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 procesors, 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 |