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