DW_CXS_COMPETITOR_D

Competitor resource dimension

Details

Module: Opportunity Management

Key Columns

COMPETITOR_ID

Columns

Columns
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