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