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 | 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.