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 | This column is for Oracle Internal use only. 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 |
Copyright © 2019, 2024, Oracle and/or its affiliates.