This table contains info for sales account
Module: Opportunity Management
SALES_ACCOUNT_ID
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 | 1024 | 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 | 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 | ||
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 |