Competitor resource dimension
Module: Opportunity Management
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 | Unique identifier | ||||
PRIMARY_COMPETITOR_NAME | VARCHAR2 | 512 | Competitor name. | ||||
PRIMARY_COMPETITOR_UNIQUE_NAME | VARCHAR2 | 1024 | 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 |