DW_EB_X_EBS_COMMON_W_SALES_PRODUCT_D
This table is a sales oriented view of the product dimension.This is the sales view of the material master table. It stores all materials that can be sold and sales specific attributes. Oracle: Sales Product is unique by Inventory Organization. In the case of Oracle, Sales Products are no different than Products because Oracle does not different Products by Sales Organizations. In the case of SAP, Sales Product is unique by Sales Area (Sales Org, Sales Channel and Sales Division) and Client Code.
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 |
|---|---|---|---|---|---|---|
| DATASOURCE_NUM_ID | NUMBER | 38 | True | 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. | ||
| ACTIVE_FLG | VARCHAR2 | 100 CHAR | Indicates if sales product is active. | |||
| 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. | |||
| CHNL_TYPE_WID | NUMBER | 38 | Identifies the channel type. The lowest level of the channel type is stored as the channel point. For example, if the channel type is email, the channel point would be the email address. | DW_EB_X_EBS_COMMON_W_CHNL_TYPE_D | ||
| 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 | 100 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. | |||
| DELETE_FLG | VARCHAR2 | 100 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 | 100 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. | |||
| PRODUCT_WID | NUMBER | 38 | Identifies the product. | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| ROW_WID | NUMBER | 38 | Surrogate key to uniquely identify a record. | |||
| SALES_DIVISION_CODE | VARCHAR2 | 100 CHAR | This is the sales division code. | |||
| SALES_DIVISION_NAME | VARCHAR2 | 100 CHAR | This is the name of the sales division code. | |||
| SALES_MODEL_CODE | VARCHAR2 | 100 CHAR | This code identifies the model of the product. | |||
| SALES_MODEL_NAME | VARCHAR2 | 100 CHAR | This is the model name of the product. | |||
| SALES_ORG_WID | NUMBER | 38 | Identifies the sales organization. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_PRODUCT_DESC | VARCHAR2 | 100 CHAR | This is the detailed description of the product. | |||
| SALES_PRODUCT_HIER1_CODE | VARCHAR2 | 100 CHAR | This is the level1 sales product code. | |||
| SALES_PRODUCT_HIER1_NAME | VARCHAR2 | 100 CHAR | This is the level1 sales product name. | |||
| SALES_PRODUCT_HIER2_CODE | VARCHAR2 | 100 CHAR | This is the level2 sales product code. | |||
| SALES_PRODUCT_HIER2_NAME | VARCHAR2 | 100 CHAR | This is the level2 sales product name. | |||
| SALES_PRODUCT_HIER3_CODE | VARCHAR2 | 100 CHAR | This is the level3 sales product code. | |||
| SALES_PRODUCT_HIER3_NAME | VARCHAR2 | 100 CHAR | This is the level3 sales product name. | |||
| SALES_PRODUCT_HIER4_CODE | VARCHAR2 | 100 CHAR | This is the level4 sales product code. | |||
| SALES_PRODUCT_HIER4_NAME | VARCHAR2 | 100 CHAR | This is the level4 sales product name. | |||
| SALES_PRODUCT_HIER5_CODE | VARCHAR2 | 100 CHAR | This is the level5 sales product code. | |||
| SALES_PRODUCT_HIER5_NAME | VARCHAR2 | 100 CHAR | This is the level5 sales product name. | |||
| SALES_PRODUCT_HIER6_CODE | VARCHAR2 | 100 CHAR | This is the level6 sales product code. | |||
| SALES_PRODUCT_HIER6_NAME | VARCHAR2 | 100 CHAR | This is the level6 sales product name. | |||
| SALES_PRODUCT_NUM | VARCHAR2 | 100 CHAR | This is the product number. | |||
| 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) | |||
| STATUS_CODE | VARCHAR2 | 100 CHAR | This is the status code. | |||
| STATUS_NAME | VARCHAR2 | 100 CHAR | This is the name of the status code. | |||
| TENANT_ID | VARCHAR2 | 100 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. | |||
| W_INSERT_DT | TIMESTAMP | 6 | This column stores the date on which the record was inserted in the data warehouse table. | |||
| W_UPDATE_DT | TIMESTAMP | 6 | This column stores the date on which the record was last updated in the data warehouse table. | |||
| X_CUSTOM | VARCHAR2 | 100 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |