Oracle Fusion · Data dictionary
CST_ALL_COST_TRANSACTIONS_V
CostingUsed in 4 subject areas40 reporting columns
Cost Management (CST), denormalized view.
Primary key: not yet catalogued for CST_ALL_COST_TRANSACTIONS_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACCOUNTING_STATUS | ● | Status of the accounting. | |
| CONSIGNED_FLAG | ● | Indicator (Y/N) for the consigned. | |
| COST_DATE | ● | Cost date. | |
| COST_STATUS | ● | Status of the cost. | |
| COST_TRANSACTION_TYPE | ● | Type of cost transaction. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| FROM_GRADE_CODE | ● | Code identifying the from grade. | |
| GRADE_CODE | ● | Code identifying the grade. | |
| INTRANSIT_FLAG | ● | Indicator (Y/N) for the intransit. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LE_TIMEZONE_CODE | ● | Code identifying the legal entity timezone. | |
| LOT_NUMBER | ● | Lot number. | |
| PARENT_LOT_NUMBER | ● | Parent lot number. | |
| PERIOD_NAME | ● | Name of the period. | |
| PO_ITEM_DESCRIPTION | ● | Description of the purchase order item. | |
| PO_ITEM_DESCRIPTION_TYPE | ● | Type of purchase order item description. | |
| PRIMARY_QTY | ● | Primary quantity. | |
| PRIMARY_UOM_CODE | ● | Code identifying the primary unit of measure. | |
| QUANTITY | ● | Quantity. | |
| SECONDARY_TRANSACTION_QTY | ● | Secondary transaction quantity. | |
| SECONDARY_UOM_CODE | ● | Code identifying the secondary unit of measure. | |
| SERIAL_NUMBER | ● | Serial number. | |
| SUPPLY_TYPE | ● | Type of supply. | |
| TO_GRADE_CODE | ● | Code identifying the to grade. | |
| TRANSACTION_AMOUNT | ● | Transaction amount. | |
| TRANSACTION_CURRENCY_CODE | ● | Currency code for the transaction. | |
| TRANSACTION_DATE | ● | Transaction date. | |
| TRANSACTION_FLOW_TYPE | ● | Type of transaction flow. | |
| TRANSACTION_ID | ● | Identifier for the transaction. | |
| TRANSACTION_QTY | ● | Transaction quantity. | |
| TRANSACTION_UOM_CODE | ● | Code identifying the transaction unit of measure. | |
| TXN_SOURCE_DOC_NUMBER | ● | Transaction source doc number. | |
| TXN_SOURCE_DOC_TYPE | ● | Type of transaction source doc. | |
| TXN_SOURCE_REF_DOC_NUMBER | ● | Transaction source reference doc number. | |
| TXN_SOURCE_REF_DOC_TYPE | ● | Type of transaction source reference doc. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| VENDOR_LOT_NUMBER | ● | Vendor lot number. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Period Close Real Time
- Costing - Cost Accounting Real Time
- Costing - Work Order Costs Real Time
- Supply Chain Financial Orchestration Real Time
Need the extract + dbt staging for CST_ALL_COST_TRANSACTIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table