DW_PARTY_ORGANIZATION_D

This table contains info for sales account

Details

Module:

Key Columns

PARTY_ID

Columns

Columns
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