1. Tables and Views for SCM
  2. CST_STD_COSTS

CST_STD_COSTS

This table stores the information pertaining to standard costs.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CST_STD_COSTS_PK

STD_COST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
STD_COST_ID NUMBER 18 Yes Generated identifier for standard cost. Active
PROCESSED_FLAG VARCHAR2 1 Indicates if standard cost is picked up by cost processor. Possible values are: N - standard cost not picked up by cost processor, W - standard cost is being processed, Y - standard cost is processed.
SCENARIO_ID NUMBER 18 Identifies the scenario for which the standard cost is entered.
COST_ESTIMATE_ASSIGN_ID NUMBER 18 Identifies the cost estimate assignment for which the standard cost is entered.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
COST_ORG_ID NUMBER 18 Yes Identifies the cost organization for which the standard cost is entered. Active
COST_BOOK_ID NUMBER 18 Yes Identifies the cost book for which the standard cost is entered. Active
INVENTORY_ITEM_ID NUMBER 18 Yes Identifies the item for which the standard cost is entered. Active
INVENTORY_ORG_ID NUMBER 18 Yes Identifies the master organization of the item for which the standard cost is entered. Active
ASSIGNMENT_LEVEL VARCHAR2 30 Indicates one of the four values for assignment level: REFERENCE, INVENTORY_CONTROL_ATTRIBUTES, VALUATION_UNIT, ROLLED_UP_COSTS.
VAL_UNIT_COMBINATION_ID NUMBER 18 Identifies the valuation unit code combination.
VAL_STRUCTURE_ID NUMBER 18 Yes Identifies the valuation structure for which the standard cost is entered.
COST_PROFILE_ID NUMBER 18 Yes Identifies the cost profile for which the standard cost is entered.
VAL_UNIT_ID NUMBER 18 Identifies the valuation unit for which the standard cost is entered. Active
ORGANIZATION_ID NUMBER 18 Indicates the manufacturing plant for which the rolled-up costs are populated. This information is populated only for costs with assignments level as "ROLLED_UP_COSTS". For other assignment levels, this attribute is not populated.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. Active
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective. Active
FROM_PERIOD_NAME VARCHAR2 15 Indicates the period from which the standard cost is effective for periodic average books.
TO_PERIOD_NAME VARCHAR2 15 Indicates the period till which the standard cost is effective for periodic average books.
STATUS_CODE VARCHAR2 30 Yes Indicates the status of the standard cost. Active
TOTAL_COST NUMBER Indicates the total standard cost during the effective dates. Active
CURRENCY_CODE VARCHAR2 15 Yes Indicates the currency code in which the standard cost is entered. Active
UOM_CODE VARCHAR2 30 Yes Indicates the unit of measure of the standard cost. Active
COST_ESTIMATE_ID NUMBER 18 Identifies the cost estimate based on which the standard cost was created. Active
PREVIOUS_STD_COST_ID NUMBER 18 Identifies the previous standard cost record if any, which this standard cost record replaces.
PREVIOUS_EFFECTIVE_START_DATE TIMESTAMP Indicates the date from which the previous standard cost record if any, was effective.
PREVIOUS_EFFECTIVE_END_DATE TIMESTAMP Indicates the date till which the previous standard cost record if any, was effective. Active
PREVIOUS_TOTAL_COST NUMBER Indicates the total standard cost of the previous standard cost record if any, which this standard cost record replaces. Active
STD_COST_ADJUST_ID NUMBER 18 Identifies the standard cost adjustment created because of this standard cost record becoming effective. Active
SCENARIO_PUBLISH_HEADER_ID NUMBER 18 Indicates the surrogate key reference of the scenario publish header.
SCENARIO_EVENT_ID NUMBER 18 Indicates the scenario event from which the standard item cost was published from.
COST_ESTIMATE_LINE_ID NUMBER 18 Indicates the surrogate key reference of the cost estimate line.
SCENARIO_ROLLUP_HEADER_ID NUMBER 18 Identifies the cost planning scenario rollup header based on which the standard cost record was published from.
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
STAGED_FOR_STD_COST_ADJ_FLAG VARCHAR2 1 Indicates whether this cost has been staged for standard cost adjustment and inventory valuation.
REF_STD_COST_ID NUMBER 18 Indicates the buy cost type reference record from which this standard cost type record was created.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 240 Reference Information from an External system (external to Cost Management). Active
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Reference Information from an External system (external to Cost Management). Active
INV_VAL_USE_FLAG VARCHAR2 1 Indicates whether the cost needs to be used by the Inventory Valuation Program. Active
LAST_USED_DATE TIMESTAMP Indicates the date when the standard cost was last used by the cost processor. 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
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield. Active
SOURCE_DI VARCHAR2 3 Indicates if the record was inserted using the desktop integration interface.
BATCH_ID NUMBER 18 Indicates the Batch identifier through which the standard cost is entered.
COST_TYPE VARCHAR2 30 Indicates the cost type. This can be either a STANDARD or a BUY cost.
SCCR_SOURCE_TYPE_CODE VARCHAR2 5 Indicates the supply chain cost rollup source types of buy, make, and transfer. Valid values are: NULL, B, BM, BMT, BT, M, MT, T.

Foreign Keys

Table Foreign Table Foreign Key Column
cst_std_cost_details cst_std_costs STD_COST_ID

Indexes

Index Uniqueness Tablespace Columns Status
CST_STD_COSTS_N1 Non Unique FUSION_TS_TX_IDX SCENARIO_ROLLUP_HEADER_ID Active
CST_STD_COSTS_N2 Non Unique Default PREVIOUS_STD_COST_ID
CST_STD_COSTS_N3 Non Unique Default INVENTORY_ORG_ID, INVENTORY_ITEM_ID
CST_STD_COSTS_PK Unique FUSION_TS_TX_DATA STD_COST_ID
CST_STD_COSTS_U1 Unique FUSION_TS_TX_IDX COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, EFFECTIVE_START_DATE, COST_TYPE Active
CST_STD_COSTS_U2 Unique FUSION_TS_TX_DATA SCENARIO_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, COST_TYPE