1. Tables and Views for SCM
  2. CST_STD_COST_VARIANCES

CST_STD_COST_VARIANCES

This table stores the information pertaining to standard cost variances.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CST_STD_COST_VARIANCES_PK

STD_COST_VARIANCE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
STD_COST_VARIANCE_ID NUMBER 18 Yes Generated identifier for standard cost variances. Active
VARIANCE_CODE VARCHAR2 30 Yes Indicates the type of standard cost variance. Active
TRANSACTION_ID NUMBER 18 Yes Identifies the transaction based on which the standard cost variances was created. Active
TRANSACTION_COST_ID NUMBER 18 Yes Identifies the transaction cost based on which the standard cost variances was created. Active
DISTRIBUTION_ID NUMBER 18 Yes Identifies the distribution which accounted the standard cost variance. Active
STD_COST_ID NUMBER 18 Yes Identifies the standard cost record based on which the standard cost variance was created. Active
COST_ORG_ID NUMBER 18 Yes Identifies the cost organization for which the standard cost variance was created. Active
COST_BOOK_ID NUMBER 18 Yes Identifies the cost book for which the standard cost variance was created. Active
INVENTORY_ITEM_ID NUMBER 18 Yes Identifies the item for which the standard cost variance was created. Active
INVENTORY_ORG_ID NUMBER 18 Yes Identifies the master organization of the item for which the standard cost variance was created. Active
VAL_UNIT_ID NUMBER 18 Yes Identifies the valuation unit for which the standard cost variance was created. Active
TRANSACTION_DATE TIMESTAMP Yes Identifies the transaction date of the transaction based on which the standard cost variance was created. Active
COST_TRANSACTION_TYPE VARCHAR2 30 Identifies the cost transaction type of the transaction based on which the standard cost variance was created. Active
ADDITIONAL_PROCESSING_CODE VARCHAR2 240 Identifies the additional processing code of the transaction based on which the standard cost variance was created. Active
BASE_TXN_TYPE_ID NUMBER 18 Identifies the transaction type of the transaction based on which the standard cost variance was created. Active
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Identifies the transaction source type of the transaction based on which the standard cost variance was created. Active
BASE_TXN_ACTION_ID NUMBER 18 Identifies the transaction action type of the transaction based on which the standard cost variance was created. Active
QUANTITY NUMBER Indicates the transaction quantity of the transaction based on which the standard cost variance was created. Active
UOM_CODE VARCHAR2 30 Indicates the item's costing unit of measure on the transaction for which the standard cost variance was created. Active
VARIANCE_AMOUNT NUMBER Indicates the variance amount for the standard cost variance. Active
TOTAL_TRANSACTION_COST NUMBER Indicates the total transaction cost including any adjustments.
TOTAL_STD_COST NUMBER Indicates the total standard cost.
CURRENCY_CODE VARCHAR2 15 Indicates the currency code in which the standard cost variance was created. Active
CST_INV_TRANSACTION_ID NUMBER 18 Identifies the inventory transaction based on which the standard cost variance was created. Active
RCV_TRANSACTION_ID NUMBER 18 Identifies the receiving transaction based on which the standard cost variance was created. Active
PO_DISTRIBUTION_ID NUMBER 18 Identifies the purchasing distribution based on which the standard cost variance was created. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
CST_STD_COST_VARIANCES_N1 Non Unique Default TRUNC("TRANSACTION_DATE")
CST_STD_COST_VARIANCES_PK Unique FUSION_TS_TX_DATA STD_COST_VARIANCE_ID Active