1. Tables and Views for SCM
  2. CST_TRANSFER_SRC_TXNS_S_GT

CST_TRANSFER_SRC_TXNS_S_GT

This is a global temporary table used in internal processing within the cost processor to temporarily store 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: Default

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.
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.

Indexes

Index Uniqueness Columns
CST_TRANSFER_SRC_TXNS_S_GT_U1 Unique DEST_TRANSACTION_ID, SOURCE_TRANSACTION_ID