Partner resource dimension
Module:
PARTNER_ID
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.