DW_EB_X_EBS_COMMON_W_ITEM_COST_G
DW_EB_X_EBS_COMMON_W_ITEM_COST_G, a reference table, is used to maintain standard cost information or moving average price (as applicable) on all products handled by a business organization ¿ at a specific inventory or product supply location. This standard cost information for a product is typically arrived at as part of a periodic costing exercise that looks at past data related to pricing inputs for these products. For example, the standard cost related to finished goods (sales products) would be a combination of variable costs (related to direct inputs) and fixed costs (related to indirect inputs) The standard cost related to raw materials (production inputs) & operation support products would be a weighted average of expenses incurred in sourcing such components from suppliers or outside contractors. Moving average prices may also be maintained for such products (as applicable). The information in this table is mostly expected to be static in nature and would not represent information related to the current stock levels of the product (such information is maintained in the inventory balance table).Type II information is enabled for this dimension table. Products can enter this table when a business organization expands its sales product line or purchases new kinds of products to maintain its operations.
Details
Module: Common Tables (EBS_COMMON)
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| ROW_WID | NUMBER | 38 | True | Surrogate key to uniquely identify the Item Cost record. | ||
| ACTIVE_FLG | VARCHAR2 | 1 CHAR | This identifies whether the source record is Active/Enabled or not | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| COST_METHOD | VARCHAR2 | 80 CHAR | Identifies the Costing Method associated with the Product/Organization record. | |||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CURRENT_FLG | VARCHAR2 | 1 CHAR | This is a flag for marking dimension records as "Y" in order to represent the current state of a dimension entity. This flag is typically critical for Type II slowly-changing dimensions, as records in a Type II situation tend to be numerous. | |||
| CURR_CODE | VARCHAR2 | 80 CHAR | Identifies the Currency code associated with Product/Organization record. | |||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| EFFECTIVE_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| EFFECTIVE_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the dimension record is effective. A value is either assigned by Siebel Applications or extracted from the source. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | |||
| ORGANIZATION_ID | VARCHAR2 | 80 CHAR | Indicated the Organization that owns the product for which the Cost is being provided. | |||
| PRODUCT_ID | VARCHAR2 | 80 CHAR | Indicates the product for which the Cost is being provided. | |||
| SRC_EFF_FROM_DT | TIMESTAMP | 6 | This column stores the date from which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| SRC_EFF_TO_DT | TIMESTAMP | 6 | This column stores the date up to which the source record (in the Source system) is effective. The value is extracted from the source (whenever available) | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| UNIT_COST | NUMBER | 38,10 | Identifies the Unit Cost associated with Product/Organization record | |||
| UOM_CODE | VARCHAR2 | 80 CHAR | Identifies the Unit of Measure associated with Product/Organization record. | |||
| W_COST_METHOD | VARCHAR2 | 200 CHAR | Identifies the Data Warehouse conformed code for the Costing Method associated with the Product/Organization record. | |||
| W_CURRENCY | VARCHAR2 | 200 CHAR | Identifies the Data Warehouse conformed code for the Currency code associated with the Product/Organization record. | |||
| W_UOM | VARCHAR2 | 200 CHAR | Identifies the Data Warehouse conformed code for the Unit of Measure associated with the Product/Organization record. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |