DW_CXS_SALES_ACCOUNT_D

This table contains info for sales account

Details

Module: Opportunity Management

Key Columns

SALES_ACCOUNT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SALES_ACCOUNT_ID NUMBER 38 0 True Unique Identifier and Primary Key for the Sales Account.    
SOURCE_RECORD_ID VARCHAR2 64     Source Record Identifier for SALES ACCOUNT It is used as the primary key.    
PARTY_ID NUMBER 38 0   The Party Identifier foreign key to the HZ_PARTIES table. DW_PARTY_D PARTY_ID
PARTY_NAME VARCHAR2 512     Name of this party    
PARTY_UNIQUE_NAME VARCHAR2 999     The Sales Account Unique Name    
SALES_ACCOUNT_NAME_ALIAS VARCHAR2 512     The Sales Account Name Alias.    
SALES_ACCOUNT_NAME_SUFFIX VARCHAR2 512     The Sales Account Name Suffix.    
SALES_ACCOUNT_TYPE VARCHAR2 32     This column stores value about sales account type , the possible values would be 'Customer' ,'Prospect' DW_CXS_SALES_ACCOUNT_TYPE_D_TL CODE
SALES_ACCOUNT_STATUS VARCHAR2 32     Sales Account Status    
INTERNAL_STATUS VARCHAR2 16     Internal status of a sales account    
SALES_ACCOUNT_NUMBER VARCHAR2 32     Public Unique Identification Number for this Sales Account    
EXISTING_FLAG VARCHAR2 16     Indicates whether there is an existing selling or billing relationship with the Sales Account    
NAMED_ACCOUNT_FLAG VARCHAR2 16     Flag indicating if this is a named account.    
ACCOUNT_DIRECTOR_ID NUMBER 38 0   The PARTY_ID of the resource designated as the director of the Sales Account. Foreign key to the HZ_PARTIES table DW_CXS_RESOURCE_D RESOURCE_ID
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    
PRIMARY_FLAG VARCHAR2 16     Identifies the Primary Sales Account for a Party.    
LAST_ASSIGNED_DT DATE       The date indicating when the Sales Account Territory Assignment was last run by Assignment Manager    
EXISTING_FLAG_LAST_UPDATE_DATE DATE       Date when the Existing flag is last modified    
PREFERRED_CONTACT_NAME VARCHAR2 512     Name Of The Primary Contact Of Sales Account.    
INDUSTRY_CODE VARCHAR2 64     Industry code. DW_CXS_INDUSTRY_TYPE_CODE_D_TL CODE
ORGANIZATION_TYPE_CODE VARCHAR2 64     Organization type code 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
PARENT_ACCOUNT_PARTY_ID NUMBER 38 0   Parent Account Identifier    
TOP_ACCOUNT_PARTY_ID NUMBER 38 0   Top Account Identifier DW_CXS_SALES_ACCOUNT_D PARTY_ID
SALES_ACCOUNT_FLAG VARCHAR2 16     Sales account flag for account    

Copyright © 2019, 2023, Oracle and/or its affiliates.