Competitor resource dimension
Module:
COMPETITOR_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| COMPETITOR_ID | NUMBER | 38 | 0 | True | Unique identifier for the Competitor | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Unique identifier | ||||
| PRIMARY_COMPETITOR_NAME | VARCHAR2 | 512 | Competitor name. | ||||
| PRIMARY_COMPETITOR_UNIQUE_NAME | VARCHAR2 | 999 | Unique Competitor name. | ||||
| PRIMARY_COMPETITOR_STATUS_CODE | VARCHAR2 | 16 | Status Code of competitor | DW_CXS_SALES_COMPETITOR_STATUS_D_TL | Code | ||
| ADDRESS1 | VARCHAR2 | 256 | First line of the Identifying address for Competitor | ||||
| ADDRESS2 | VARCHAR2 | 256 | Second line of the Identifying address for Competitor | ||||
| ADDRESS3 | VARCHAR2 | 256 | Third line of the Identifying address for Competitor | ||||
| ADDRESS4 | VARCHAR2 | 256 | Fourth line of the Identifying address for Competitor | ||||
| CITY | VARCHAR2 | 64 | City of the Identifying address | ||||
| COUNTRY | VARCHAR2 | 16 | Country of the Identifying address | ||||
| COUNTY | VARCHAR2 | 64 | County of the Identifying address | ||||
| POSTAL_CODE | VARCHAR2 | 64 | State of the Identifying address | ||||
| PROVINCE | VARCHAR2 | 64 | Province of the Identifying address | ||||
| STATE | VARCHAR2 | 64 | State of the Identifying address | ||||
| LATITUDE | NUMBER | Used to store Longitude Information for the Location for Spatial Proximity and containment purposes | |||||
| LONGITUDE | NUMBER | Used to store Latitude Information for the Location for Spatial Proximity and containment purposes |
Copyright © 2019, 2024, Oracle and/or its affiliates.