DW_CXS_PARTNER_D

Partner resource dimension

Details

Module:

Key Columns

PARTNER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PARTNER_ID NUMBER 38 0 True Unique identifier for the Partner
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique identifier
PARTNER_NAME VARCHAR2 512 Partner name.
CURRENT_FISCAL_YEAR_POTENTIAL_REVENUE NUMBER Current Potential revenue of partner
NEXT_FISCAL_YEAR_POTENTIAL_REVENUE NUMBER Next Potential Revenue of partner
PARTNER_OWNER_ID NUMBER 38 0 Partner owner name. DW_CXS_RESOURCE_D RESOURCE_ID
PARTNER_NUMBER VARCHAR2 32 partner number
ADDRESS1 VARCHAR2 256 First line of the Identifying address
ADDRESS2 VARCHAR2 256 Second line of the Identifying address
ADDRESS3 VARCHAR2 256 Third line of the Identifying address
ADDRESS4 VARCHAR2 256 Fourth line of the Identifying address
CITY VARCHAR2 64 City of the Identifying address
COUNTRY VARCHAR2 16 The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
COUNTY VARCHAR2 64 County of the Identifying address
POSTAL_CODE VARCHAR2 64 Postal Code 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 Latitude Information for the Location for Spatial Proximity and containment purposes
LONGITUDE NUMBER Used to store Longitude Information for the Location for Spatial Proximity and containment purposes
CERTIFICATION_LEVEL VARCHAR2 64
ORGANIZATION_NAME VARCHAR2 512
LEGAL_STATUS VARCHAR2 64
REGISTRATION_TYPE VARCHAR2 64
CERT_REASON_CODE VARCHAR2 64
COMPANY_NUMBER VARCHAR2 32
COMPLIANCE_STATUS VARCHAR2 64
PARTNER_LEVEL VARCHAR2 64
STATUS VARCHAR2 64
PARENT_PARTNER_PARTY_ID NUMBER 38 0
GEOGRAPHY_ID NUMBER 38 0