This table contains info for sales account
Module:
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 | 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.