DW_EB_X_EBS_COMMON_W_PRODUCT_TYPE_D
The DW_EB_X_EBS_COMMON_W_PRODUCT_TYPE_D is an aggregate dimension table that stores different product type records stored in the Products Dimension (DW_EB_X_EBS_COMMON_W_PRODUCT_D).
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 a 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. | |||
| 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. | |||
| PRODUCT_TYPE_CODE | VARCHAR2 | 50 CHAR | This code identifies the product type. Examples includes 'raw materials' 'finished goods' or ' trade'. This column represents the primary identifier of records in this table. | |||
| 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. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |