DW_CXS_COMPETITOR_D

Competitor resource dimension

Details

Module:

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 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