CST_STD_ITEM_COSTS_GT
This tables stores the item cost information being published to cost accounting temporarily during the process of publishing.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| COST_ESTIMATE_ASSIGN_ID | NUMBER | 18 | Identifies the item cost plan's control attribute assignment. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization to which the cost is being published to. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book to which the cost is being published to. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the item for which the cost is being published. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Identifies the inventory organization of the item for which the cost is being published. | |
| ASSIGNMENT_LEVEL | VARCHAR2 | 30 | Indicates the level to which the cost is being published. Valid values as inventory control attributes, valuation unit and valuation structure. | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Identifies the structure of the control attributes for which the item costs are being published. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Identifies the inventory control attributes for which the costs are being published. | ||
| VAL_STRUCTURE_TYPE_CODE | VARCHAR2 | 30 | Indicates the type of item cost. Valid values are asset (ASSET) and expense (EXPENSE). | ||
| VAL_STRUCTURE_ID | NUMBER | 18 | Identifies the valuation structure to which the cost is being published to. | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies the cost profile to which the cost is being published to. | ||
| VAL_UNIT_ID | NUMBER | 18 | Identifies the valuation unit to which the cost is being published to. | ||
| ORGANIZATION_ID | NUMBER | 18 | Indicates the manufacturing plant for the rolled-up costs. | ||
| 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 | Yes | Date Effective Entity: indicates the date at the end of the date range within which the row is effective. | ||
| 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 item cost being published. Successfully validated records would have a status of success. Records that have failed the validation would have the error code which was generated based on the validations. | |
| TOTAL_COST | NUMBER | Indicates the total cost of the item for which costs are being published. | |||
| FROM_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the from currency code for which the conversion rates are calculated. | ||
| TO_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the to currency for which the conversion rates are calculated. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Indicates the currency conversion type for which the conversion rates are calculated. | ||
| CURRENCY_CONVERSION_DATE | DATE | Indicates the currency conversion date based on which the conversion rates are calculated. | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Indicates the calculated currency conversion rate. Default value is 1, when the from and to currency codes are the same. | |||
| FROM_UOM_CODE | VARCHAR2 | 3 | Indicates the from UOM code used for the UOM conversion factor calculations. | ||
| TO_UOM_CODE | VARCHAR2 | 3 | Indicates the to UOM code used for the UOM conversion factor calculations. | ||
| UOM_CONVERSION_FACTOR | NUMBER | Indicates the calculated UOM conversion factor. Default value is 1, when the from and to UOM codes are the same. | |||
| PREVIOUS_STD_COST_ID | NUMBER | 18 | Indicates the previous standard cost identifier which is currently valid in cost accounting prior to the current cost being published. | ||
| PREVIOUS_EFFECTIVE_START_DATE | DATE | Indicates the previous standard cost start date which is currently valid in cost accounting prior to the current cost being published. | |||
| PREVIOUS_EFFECTIVE_END_DATE | DATE | Indicates the previous standard cost end date which is currently valid in cost accounting prior to the current cost being published. | |||
| PREVIOUS_LAST_USED_DATE | DATE | Indicates the last date when the previous standard cost which is currently valid was used in cost accounting prior to the current cost being published. | |||
| PREVIOUS_TOTAL_COST | NUMBER | Indicates the total standard cost of the previous standard cost record if any, which this standard cost record replaces. | |||
| FUTURE_STD_COST_ID | NUMBER | 18 | Indicates the future standard cost identifier which is currently valid in cost accounting prior to the current cost being published. | ||
| FUTURE_EFFECTIVE_START_DATE | DATE | Indicates the future standard cost start date which is currently valid in cost accounting prior to the current cost being published. | |||
| FUTURE_EFFECTIVE_END_DATE | DATE | Indicates the future standard cost end date which is currently valid in cost accounting prior to the current cost being published. | |||
| SCENARIO_PUBLISH_HEADER_ID | NUMBER | 18 | Identifies the publish header based on which the current item cost is being published. | ||
| SCENARIO_EVENT_ID | NUMBER | 18 | Yes | Identifies the scenario event which was invoked using which the current item cost is being published. | |
| COMPONENT_GROUP_ID | NUMBER | 18 | Identifies the cost component mapping, which would be used for translating the cost component information to cost elements. | ||
| SCENARIO_ROLLUP_HEADER_ID | NUMBER | 18 | Identifies the scenario rollup header reference for the item cost being published. This value is populated for components which are used in rollup as well as the rolled-up item costs being published. | ||
| STD_COST_ID | NUMBER | 18 | Yes | Identifies the standard cost identifier for the item cost being published. | |
| COST_ESTIMATE_ID | NUMBER | 18 | Identifies the cost estimate identifier based on which the item cost is being published. This value is populated for components which are used in rollup and for items which are part of the cost estimate but are not part of the rollup process. | ||
| COST_ESTIMATE_LINE_ID | NUMBER | 18 | Identifies the cost estimate line identifier based on which the item cost is being published. This value is populated for components which are used in rollup and for items which are part of the cost estimate but are not part of the rollup process. | ||
| REF_STD_COST_ID | NUMBER | 18 | Indicates the buy cost type reference record from which this standard cost type record was created. | ||
| LAST_USED_DATE | DATE | Indicates the last date when the standard cost was used in cost accounting. | |||
| SCENARIO_ID | NUMBER | 18 | Indicates the surrogate key reference of the cost planning scenario. | ||
| ROLLUP_ITEM_TYPE | VARCHAR2 | 30 | Indicates whether the item being rolled up is (1) Standard (2) Purchased CTO (3) Manufactured CTO. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_STD_ITEM_COSTS_GT_N1 | Non Unique | SCENARIO_ROLLUP_HEADER_ID |
| CST_STD_ITEM_COSTS_GT_PK | Unique | STD_COST_ID |