DW_CXS_SALES_ACCOUNT_D

This table contains info for sales account

Details

Module:

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 This column is for Oracle Internal use only. 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