This table contains details of Organization, Person, and Group party types.
Module:
PARTY_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
PARTY_ID | NUMBER | 38 | 0 | True | Party identifier. It is used as the primary key. | ||
SOURCE_RECORD_ID | NUMBER | 38 | 0 | Source record identifier. | |||
PARTY_NAME | VARCHAR2 | 512 | Party name. | ||||
PARTY_NUMBER | VARCHAR2 | 32 | Party number. | ||||
PARTY_UNIQUE_NAME | VARCHAR2 | 999 | Unique party name. | ||||
ORGANIZATION_PROFILE_ID | NUMBER | 38 | 0 | Organization Profile Identifier | |||
PERSON_TITLE | VARCHAR2 | 64 | Title prefixed to a person's name. | ||||
PERSON_FIRST_NAME | VARCHAR2 | 256 | First name of a person. | ||||
PERSON_MIDDLE_NAME | VARCHAR2 | 64 | Middle name of a person. | ||||
PERSON_LAST_NAME | VARCHAR2 | 256 | Last name of a person. | ||||
PERSON_NAME_SUFFIX | VARCHAR2 | 32 | Suffix added to a person's name. | ||||
PERSON_ACADEMIC_TITLE | VARCHAR2 | 32 | Academic title of a person. | ||||
PARTY_TYPE | VARCHAR2 | 32 | Party type. | ||||
GROUP_TYPE | VARCHAR2 | 32 | Group type code. | ||||
GROUP_SIZE | NUMBER | 38 | 0 | Group size. | |||
GENDER | VARCHAR2 | 32 | Gender of a person. | ||||
AVERAGE_AGE | NUMBER | 38 | 0 | Average age. | |||
MEDIAN_AGE | NUMBER | 38 | 0 | Median age. | |||
NUMBER_OF_CHILDS_0_TO_6 | NUMBER | 38 | 0 | Number of children aged 0 to 6 years. | |||
NUMBER_OF_CHILDS_7_TO_12 | NUMBER | 38 | 0 | Number of children aged 7 to 12 years. | |||
NUMBER_OF_CHILDS_13_TO_18 | NUMBER | 38 | 0 | Number of children aged 13 to 18 years. | |||
NUMBER_OF_DEPENDENTS | NUMBER | 38 | 0 | Number of dependents. | |||
ESTABLISHED_YEAR | NUMBER | 38 | 0 | Year of establishment. | |||
DECLARED_ETHNICITY | VARCHAR2 | 64 | Ethnicity declared by a person. | ||||
DATE_OF_BIRTH | TIMESTAMP | Date of birth. | |||||
DATE_OF_DEATH | TIMESTAMP | Date of death. | |||||
PLACE_OF_BIRTH | VARCHAR2 | 64 | Place of birth. | ||||
LAST_CONTACT_DATE | TIMESTAMP | Last contact date. | |||||
STATUS | VARCHAR2 | 16 | Account status. | ||||
CUSTOMER_CATEGORY_CODE | VARCHAR2 | 32 | Customer category code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE = CUSTOMER_CATEGORY. | ||||
CUSTOMER_SINCE_DATE | TIMESTAMP | Date when the party became a customer. | |||||
ORGANIZATION_TYPE_CODE | VARCHAR2 | 64 | Organization type code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE = ORGANIZATION_TYPE. | ||||
MARITAL_STATUS | VARCHAR2 | 32 | Marital status of a person. | ||||
INTERNET_HOME_PAGE | VARCHAR2 | 999 | Home page of the organization website. | ||||
EMAIL_ADDRESS | VARCHAR2 | 512 | Email. | ||||
PRIMARY_PHONE_NUMBER | VARCHAR2 | 64 | Primary phone number. | ||||
PRIMARY_PHONE_AREA_CODE | VARCHAR2 | 32 | Primary phone area code. | ||||
PRIMARY_PHONE_COUNTRY_CODE | VARCHAR2 | 16 | Primary phone country code. | ||||
PRIMARY_PHONE_EXTENSION | VARCHAR2 | 32 | Primary phone extension. | ||||
PREFERRED_CONTACT_METHOD | VARCHAR2 | 32 | Preferred contact method. | ||||
PREFERRED_CONTACT_NAME | VARCHAR2 | 512 | Preferred contact name. | ||||
PRIMARY_RELATIONSHIP_ID | NUMBER | 38 | 0 | Primary customer relationship identifier. | |||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | 16 | Currency code. | ||||
CITY | VARCHAR2 | 64 | City. | ||||
COUNTY | VARCHAR2 | 64 | County. | ||||
PROVINCE | VARCHAR2 | 64 | Province. | ||||
STATE | VARCHAR2 | 64 | State. | ||||
COUNTRY | VARCHAR2 | 16 | Country. | ||||
POSTAL_CODE | VARCHAR2 | 64 | Postal code. | ||||
ADDRESS_LINE_1 | VARCHAR2 | 256 | First line of address. | ||||
ADDRESS_LINE_2 | VARCHAR2 | 256 | Second line of address. | ||||
ADDRESS_LINE_3 | VARCHAR2 | 256 | Third line of address. | ||||
ADDRESS_LINE_4 | VARCHAR2 | 256 | Fourth line of address. | ||||
ANNUAL_INCOME | NUMBER | Annual income. | |||||
SUPPLIER_ID | NUMBER | 38 | 0 | Supplier identifier. | |||
PARENT_SUPPLIER_ID | NUMBER | 38 | 0 | Parent supplier identifier. | |||
SUPPLIER_GROUP_CODE | VARCHAR2 | 32 | Supplier group code. | ||||
SUPPLIER_NUMBER | VARCHAR2 | 32 | Supplier number. | ||||
SUPPLIER_SINCE_DATE | TIMESTAMP | Date when the party became a supplier. | |||||
SUPPLIER_TYPE_CODE | VARCHAR2 | 32 | Supplier type code. | ||||
SIC_CODE | VARCHAR2 | 32 | Standard Industry Classification (SIC) code. Use combination of SIC_CODE and SIC_CODE_TYPE to lookup on table DW_PARTY_SIC_CODE_TYPE_TL. | DW_PARTY_SIC_CODE_TYPE_TL | SIC_CODE_TYPE,SIC_CODE | ||
SIC_CODE_TYPE | VARCHAR2 | 32 | Standard Industry Classification (SIC) code type | DW_PARTY_SIC_CODE_TYPE_TL | SIC_CODE_TYPE,SIC_CODE | ||
DNB_CREDIT_RATING | VARCHAR2 | 16 | Dun and Bradstreet rating. | ||||
DUNS_NUMBER | VARCHAR2 | 32 | D-U-N-S number of the party. | ||||
PARENT_DUNS_NUMBER | VARCHAR2 | 32 | D-U-N-S number of the parent organization. Parent is a corporation that owns more than 50% of the organization's capital stock. | ||||
GLOBAL_ULT_DUNS_NUMBER | VARCHAR2 | 32 | D-U-N-S number of the topmost entity in global organization hierarchy. | ||||
DOMESTIC_ULT_DUNS_NUMBER | VARCHAR2 | 32 | D-U-N-S number of the topmost entity in domestic organization hierarchy. | ||||
INDUSTRY_CODE | VARCHAR2 | 64 | Industry code. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=SIC_CODE. | DW_CODE_VALUES_LKP_TL | CODE | ||
LINE_OF_BUSINESS | VARCHAR2 | 256 | Line of business. | ||||
MINORITY_GROUP_CODE | VARCHAR2 | 32 | Minority group code. | ||||
DISADV_8A_INDICATOR | VARCHAR2 | 32 | Indicates a company that is considered disadvantaged by the US government under Title 8A. Possible values are Yes or No. | ||||
OUT_OF_BUSINESS_INDICATION | VARCHAR2 | 32 | Indicates if this organization is out of business. Y for businesses that are out of business, N for active businesses. | ||||
NUMBER_OF_EMPLOYEES | NUMBER | Number of employees. | |||||
ORGANIZATION_SIZE | VARCHAR2 | 32 | Organizational size based on revenue, number of employees, and so on. Possible values are small, medium, large, and so on. | ||||
ANNUAL_REVENUE | NUMBER | Annual revenue. | |||||
REVENUE_GROWTH | NUMBER | Revenue growth in percentage. | |||||
SALES_ACCOUNT_SINCE_DATE | TIMESTAMP | Date when sales account is created. | |||||
STOCK_SYMBOL | VARCHAR2 | 32 | Stock symbol. | ||||
SALES_AFFINITY_CODE | VARCHAR2 | 32 | Sales affinity code. | ||||
SALES_BUYING_ROLE_CODE | VARCHAR2 | 32 | Sales buying role code. | ||||
WEALTH_AMOUNT | NUMBER | Wealth Amount. | |||||
ACTIVE_FLAG | VARCHAR2 | 16 | Indicates that the party is still active in business. Possible values are Yes or No. | ||||
CONTACT_FLAG | VARCHAR2 | 16 | Indicates the customer contact. Possible values are Yes or No. | ||||
BRANCH_FLAG | VARCHAR2 | 16 | Indicates a branch of an organization. Possible values are Yes or No. | ||||
COMPETITOR_FLAG | VARCHAR2 | 16 | Indicates a competitor. Possible values are Yes or No. | ||||
CUSTOMER_FLAG | VARCHAR2 | 16 | Indicates a customer. Possible values are Yes or No. | ||||
DISABLED_VETERAN_OWNED_FLAG | VARCHAR2 | 16 | Indicates an entity owned by a disabled veteran. Possible values are Yes or No. | ||||
HUB_ZONE_FLAG | VARCHAR2 | 16 | Indicates a business located in a HUBZone. Possible values are Yes or No. | ||||
MANUFACTURER_FLAG | VARCHAR2 | 16 | Indicates a manufacturer. Possible values are yes or No. | ||||
INTERNAL_FLAG | VARCHAR2 | 16 | Indicates an internal customer. Possible values are Yes or No. | ||||
PARTNER_FLAG | VARCHAR2 | 16 | Indicates a partner. Possible values are Yes or No. | ||||
MINORITY_OWNED_FLAG | VARCHAR2 | 16 | Indicates a minority owned business. Possible values are Yes or No. | ||||
PROSPECT_FLAG | VARCHAR2 | 16 | Indicates that the party is a prospective customer. Possible values are Yes or No. | ||||
PUBLIC_LISTING_FLAG | VARCHAR2 | 16 | Indicates the presence of a public listing. Possible values are Yes or No. | ||||
SALES_REFERENCE_FLAG | VARCHAR2 | 16 | Indicates a sales reference. Possible values are Yes or No. | ||||
SALES_ACCOUNT_FLAG | VARCHAR2 | 16 | Indicates a sales account. Possible values are Yes or No. | ||||
SMALL_BUSINESS_FLAG | VARCHAR2 | 16 | Indicates a small business. Possible values are Yes or No. | ||||
SUPPLIER_ACTIVE_FLAG | VARCHAR2 | 16 | Indicates an active supplier. Possible values are Yes or No. | ||||
SUPPLIER_FLAG | VARCHAR2 | 16 | Indicates a supplier. Possible values are Yes or No. | ||||
SUPPLIER_ONE_TIME_FLAG | VARCHAR2 | 16 | indicates that the party is a one-time supplier. Possible values are Yes or No. | ||||
SUPPRESS_CALL_FLAG | VARCHAR2 | 16 | Indicates that the party's phone number is suppressed. Possible values are Yes or No. | ||||
SUPPRESS_EMAIL_FLAG | VARCHAR2 | 16 | Indicate that the party's Email is suppressed. Possible values are Yes or No. | ||||
SUPPRESS_MAIL_FLAG | VARCHAR2 | 16 | Indicates that party's mailing address is suppressed. Possible values are Yes or No. | ||||
VETERAN_OWNED_FLAG | VARCHAR2 | 16 | Indicates a veteran owned business. Possible values are Yes or No. | ||||
WOMAN_OWNED_FLAG | VARCHAR2 | 16 | Indicates a woman owned business. Possible values are Yes or No. | ||||
DECEASED_FLAG | VARCHAR2 | 16 | Indicates a deceased person. Possible values are Yes or No. | ||||
EMPLOYEE_FLAG | VARCHAR2 | 16 | Indicates an employee. Possible values are Yes or No. | ||||
SUPPLIER_END_DATE_ACTIVE | DATE | Date on which the supplier became inactive | |||||
SUPPLIER_CREATION_SOURCE | VARCHAR2 | 32 | Displays the lookup code of the source from which the supplier was created. Values are derived from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=POZ_CREATION_SOURCE. The possible values are: MANUAL, IMPORT, REGISTRATION and INTERNAL_REGISTRATION. | DW_CODE_VALUES_LKP_TL | CODE | ||
SUPPLIER_CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. | |||||
JOB_TITLE | VARCHAR2 | 128 | Job title of the person - this is outside the context of any relationship the person may have. | ||||
JOB_TITLE_CODE | VARCHAR2 | 32 | Code given to the job title | ||||
OWNER_PARTY_ID | NUMBER | 38 | 0 | The PARTY_ID of the resource designated as the owner of the Sales Profile. Foreign key to the HZ_PARTIES table. | |||
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 | |||||
ACCOUNT_BASE_CURRENCY_CODE | VARCHAR2 | 16 | CURRENCY_CODE | ||||
ACCOUNT_CORP_CURRENCY_CODE | VARCHAR2 | 16 | CORP_CURRENCY_CODE | ||||
NEXT_FY_POTENTIAL_REVENUE | NUMBER | Organization's potential revenue for next fiscal year |