CST_STD_COSTS_HISTORY
This table contains item cost records which have been obsoleted by publish process from cost planning because the old costs and the new costs have the same effective date and are overwritten.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STD_COST_ID | NUMBER | 18 | Yes | Generated identifier for standard cost. | |
| 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. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization for which the standard cost is entered. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book for which the standard cost is entered. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the item for which the standard cost is entered. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Identifies the master organization of the item for which the standard cost is entered. | |
| ASSIGNMENT_LEVEL | VARCHAR2 | 30 | Yes | Indicates one of the three values for assignment level : REFERENCE, INVENTORY_CONTROL_ATTRIBUTES, VALUATION_UNIT. | |
| 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. | ||
| 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. | ||
| EFFECTIVE_END_DATE | DATE | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | |||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the status of the standard cost. | |
| TOTAL_COST | NUMBER | Indicates the total standard cost during the effective dates. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Indicates the currency code in which the standard cost is entered. | |
| UOM_CODE | VARCHAR2 | 30 | Yes | Indicates the unit of measure of the standard cost. | |
| COST_ESTIMATE_ID | NUMBER | 18 | Identifies the cost estimate based on which the standard cost was created. | ||
| 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. | |||
| PREVIOUS_TOTAL_COST | NUMBER | Indicates the total standard cost of the previous standard cost record if any, which this standard cost record replaces. | |||
| STD_COST_ADJUST_ID | NUMBER | 18 | Identifies the standard cost adjustment created because of this standard cost record becoming effective. | ||
| 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. | ||
| 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 referenced standard cost for creating the current standard cost row. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 240 | Reference Information from an External system (external to Cost Management). | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Reference Information from an External system (external to Cost Management). | ||
| INV_VAL_USE_FLAG | VARCHAR2 | 1 | Indicates whether the cost needs to be used by the Inventory Valuation Program. | ||
| LAST_USED_DATE | TIMESTAMP | Indicates the date when the standard cost was last used by the cost processor. | |||
| 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. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| SOURCE_DI | VARCHAR2 | 3 | Indicates if the record was inserted using the desktop integration interface. | ||
| 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 | Indicates the reference of scenario rollup header when the record is published from cost planning. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_STD_COSTS_HISTORY_PK | Unique | FUSION_TS_TX_DATA | STD_COST_ID |