This table contains info for sales account
Module:
PARTY_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PARTY_ID | NUMBER | 38 | 0 | True | The Party Identifier foreign key to the HZ_PARTIES table. | DW_PARTY_D | PARTY_ID |
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. Source Record Identifier for SALES ACCOUNT It is used as the primary key. | ||||
| PARTY_NAME | VARCHAR2 | 512 | Name of this party | ||||
| PARTY_UNIQUE_NAME | VARCHAR2 | 999 | The Sales Account Unique Name | ||||
| 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 | ||||
| PREFERRED_CONTACT_NAME | VARCHAR2 | 512 | Name Of The Primary Contact Of Sales Account. | ||||
| INDUSTRY_CODE | VARCHAR2 | 64 | Industry code. Stores values such as 'Industrial Manufacturing', 'Life Sciences' , 'Consumer Goods' etc. | DW_CXS_INDUSTRY_TYPE_CODE_D_TL | CODE | ||
| ORGANIZATION_TYPE_CODE | VARCHAR2 | 64 | Organization type code. Stores values such as 'Public company', 'Private company', 'Government-owned corporation'. | DW_CXS_ORGANIZATION_TYPE_CODE_D_TL | CODE | ||
| ORGANIZATION_SIZE | VARCHAR2 | 32 | Organizational size based on revenue, number of employees, and so on. Possible values are small, medium, large, and so on. | ||||
| INTERNET_HOME_PAGE | VARCHAR2 | 999 | Uniform resource locator | ||||
| DUNS_NUMBER | VARCHAR2 | 32 | DUNS_NUMBER in VARCHAR format. Column value not restricted to nine digit DUNS Number. | ||||
| NEXT_FISCAL_YEAR_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year | |||||
| EMPLOYEES_TOTAL | NUMBER | NUMBER_OF_EMPLOYEES | |||||
| COMMENTS | VARCHAR2 | 999 | Denormalization of the COMMENTS in HZ_GROUP_PROFILES | ||||
| 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 | |||||
| ANNUAL_REVENUE | NUMBER | Annual revenue. | |||||
| ACCOUNT_BASE_CURRENCY_CODE | VARCHAR2 | 16 | CURRENCY_CODE | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
| ACCOUNT_CORPORATE_CURRENCY_CODE | VARCHAR2 | 16 | CORP_CURRENCY_CODE | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE |
Copyright © 2019, 2025, Oracle and/or its affiliates.