1. Tables and Views for SCM
  2. CST_TRANSFER_TXN_COSTS

CST_TRANSFER_TXN_COSTS

Contains the transfer transaction cost details generated internally by the costing engine. The cost is in terms of the shipping cost organization and contains a reference to the destination cost transaction identifier. The costs are converted by mapping cost elements and converting currencies from the source to the destination.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments
DEST_TRANSACTION_ID NUMBER 18 Yes Identifies the destination cost transaction.
SOURCE_COST_ELEMENT_ID NUMBER 18 Yes Identifies the source cost element. Holds the transfer cost in terms of the shipping cost organization's cost elements.
SOURCE_EXPENSE_POOL_ID NUMBER 18 Yes Identifies the source expense pool.
SOURCE_ABSORPTION_TYPE VARCHAR2 30 Identifies the absorption type for which this cost is created.
SOURCE_TXFR_COST_DATE TIMESTAMP Yes Identifies the maximum transfer transaction cost date.
SOURCE_UNIT_COST NUMBER Identifies the source unit cost of the transfer transaction cost element.
SOURCE_COST_ORG_ID NUMBER 18 Identifies the source cost organization.
SOURCE_COST_BOOK_ID NUMBER 18 Identifies the source cost book.
SOURCE_SET_ID NUMBER 18 Identifies the set identifier of the source cost organization.
SOURCE_CURRENCY_CODE VARCHAR2 30 Identifies the source currency code.
SOURCE_INV_ORG_ID NUMBER 18 Identifies the source inventory organization. It is used to retrieve the profit in inventory cost element.
COST_ELEMENT_TYPE VARCHAR2 30 Identifies the cost element type. When the source cost element ID is set to 0, this column specifies what type or category the cost is. For example, if this row is profit in inventory, this column value becomes PROFIT_IN_INVENTORY, specifying it as such. Note that this column has no correlation with the column of the same name (COST_ELEMENT_TYPE) on table CST_COST_ELEMENTS_B. There is no LOOKUP_TYPE for these codes.
ADJUSTMENT_FLAG VARCHAR2 1 Yes Identifies if the cost row represents and adjustment cost being propagated. N - No, Y - Yes. These is no lookup for these codes.
MAPPING_REQUIRED_FLAG VARCHAR2 1 Yes Indicates whether cost element to cost element mapping is required on transfers that have multiple legs consisting of physical and logical transfer issues and receipts. The flag helps to avoid unnecessary mapping of cost elements. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes.
POSTED_FLAG VARCHAR2 5 Yes Indicates if the transfer costs have been inserted into CST_TRANSACTION_COSTS table in the cost element mapping and currency code of the destination cost organization. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions of periodic average cost method.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_TRANSFER_TXN_COSTS cst_transactions DEST_TRANSACTION_ID
CST_TRANSFER_TXN_COSTS cst_cost_elements_b SOURCE_COST_ELEMENT_ID

Indexes

Index Uniqueness Tablespace Columns
CST_TRANSFER_TXN_COSTS_N1 Non Unique FUSION_TS_TX_DATA POSTED_FLAG, DEST_TRANSACTION_ID
CST_TRANSFER_TXN_COSTS_U1 Unique FUSION_TS_TX_DATA DEST_TRANSACTION_ID, SOURCE_TXFR_COST_DATE, SOURCE_COST_ELEMENT_ID, SOURCE_EXPENSE_POOL_ID