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

Copyright © 2019, 2023, Oracle and/or its affiliates.