1. Tables and Views for SCM
  2. CST_TRANSFER_SRC_TXNS

CST_TRANSFER_SRC_TXNS

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_TRANSACTION_ID NUMBER 18 Yes Identifies the source transaction.
ACROSS_INV_ORGS VARCHAR2 1 Identifies if the source and destination transactions fall across inventory organizations.
SOURCE_QUANTITY NUMBER Represents the transaction quantity of the source transaction.
SOURCE_INV_ORG_ID NUMBER 18 Identifies the inventory organization ID of the source transaction.
SOURCE_SET_ID NUMBER 18 Identifies the set ID associated to the cost organization of the source transaction.
SOURCE_COST_DATE TIMESTAMP Stores the CT cost date for the source transaction identified in the row.
UOM_CONVERSION_FACTOR NUMBER UOM Conversion factor from primary UOM to costing UOM.
STAGED_FOR_TXFR_COST_FLAG VARCHAR2 5 Indicates if the transfer transaction has the cost from source transaction staged in the cst_transfer_txn_costs tables for transfer cost pre-processing.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions of periodic average cost method.
PAC_XFR_CO_FLAG VARCHAR2 1 Indicates if a transfer shipment will use the prior period PAC cost or the current shipment cost as the transfer cost. This value is only applicable for transfer shipments using PAC cost method. Valid values are Y - Use prior period PAC cost, NULL - Use shipment cost.
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_SRC_TXNS cst_transactions DEST_TRANSACTION_ID
CST_TRANSFER_SRC_TXNS cst_transactions SOURCE_TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns
CST_TRANSFER_SRC_TXNS_N1 Non Unique Default STAGED_FOR_TXFR_COST_FLAG
CST_TRANSFER_SRC_TXNS_N2 Non Unique Default SOURCE_TRANSACTION_ID
CST_TRANSFER_SRC_TXNS_U1 Unique FUSION_TS_TX_DATA DEST_TRANSACTION_ID, SOURCE_TRANSACTION_ID