CST_ALL_COST_ELEMENTS_GT
This table is a temporary table used by the perpetual cost engine to create superset of all cost element that are possible for a given transaction. This information is used to identify any missing cost elements in cst_transaction_costs table and hence use it in the perpetual average cost calculation.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| COST_ORG_ID | NUMBER | 18 | Identifies the cost organization. | |
| COST_BOOK_ID | NUMBER | 18 | Identifies the cost book associated to cost organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the inventory item for cost. | |
| VAL_UNIT_ID | NUMBER | 18 | Identifies the valuation unit to which the cost belongs. | |
| COST_ELEMENT_ID | NUMBER | 18 | Identifies the cost element to which cost belongs. | |
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of cost. | |
| COST_PROFILE_ID | NUMBER | 18 | Identifies cost profile associated with the transaction. | |
| EFF_DATE | TIMESTAMP | Date from which the cost is effective. | ||
| TRANSACTION_ID | NUMBER | Identifies the transaction to which the cost belongs. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Inventory transaction identifier for costing inventory table. | |
| CURRENCY_CODE | VARCHAR2 | 30 | Identifies the currency of the cost. | |
| COST_DATE | TIMESTAMP | Cost date of the transaction or adjustments. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Identifies the transaction type of the cost. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Identifies the transaction source type of the cost. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Identifies the transaction action of the cost. | |
| RECEIPT_WITHOUT_COST_CODE | VARCHAR2 | 30 | The values can be either of FIRST, LAST, CURRENT (Default) and dictates which receipt cost will be used for receipt without cost. | |
| UOM_CODE | VARCHAR2 | 3 | Unit of measure code of the transaction quantity. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_ALL_COST_ELEMENTS_GT_N1 | Non Unique | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_ELEMENT_ID, EFF_DATE, TRANSACTION_ID |