Code |
Meaning |
Description |
ALL_ACCOUNT_NAMES |
All Account Names |
All account names for a party |
ALL_ACCOUNT_NUMBERS |
All Account Numbers |
All account numbers for a party |
ANALYSIS_FY |
Fiscal Year for Financial Analysis |
Fiscal year used as the course for financial information |
AVG_HIGH_CREDIT |
Average High Credit |
Average of all high credit extended to this organization |
BEST_TIME_CONTACT_BEGIN |
Best Time to Begin Contact |
Beginning of the best period of time to contact the person |
BEST_TIME_CONTACT_END |
Best Time to End Contact |
End of the best period of time to contact the person |
BRANCH_FLAG |
Branch Flag |
Indicates if the organization is a branch location (Y/N) |
BUSINESS_SCOPE |
Business Scope |
The physical class of business in which a business participate (local, national, international, etc.) |
CATEGORY_CODE |
Category Code |
User-defined category. Lookup type is CUSTOMER_CATEGORY |
CEO_NAME |
CEO Name |
Name of the chief executive officer |
CEO_TITLE |
CEO Title |
Formal title of the chief executive officer |
COMPETITOR_FLAG |
Competitor Flag |
Indicates if a party is a competitor (Y/N) |
CONG_DIST_CODE |
Congressional District Code |
U.S. Congressional District |
CONTENT_SOURCE_NUMBER |
Content Source Number |
Unique identification number to date source |
CONTENT_SOURCE_TYPE |
Content Source Type |
Source of data content |
CONTROL_YR |
Control Year |
Year when current ownership gained control |
CORPORATION_CLASS |
Corporation Class |
Taxation classification for corporation entities. |
CREDIT_SCORE |
Credit Score |
Indicates the risk of delinquent payments |
CREDIT_SCORE_AGE |
Credit Score Age |
Age of the credit score, expressed in months |
CREDIT_SCORE_CLASS |
Credit Score Class |
Measures the risk of severe delinquency by a sutomer account |
CREDIT_SCORE_COMMENTARY |
Credit Score Commentary |
Lookup for explanation code for the Credit Score |
CREDIT_SCORE_COMMENTARY10 |
Credit Score Commentary 10 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY2 |
Credit Score Commentary 2 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY3 |
Credit Score Commentary 3 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY4 |
Credit Score Commentary 4 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY5 |
Credit Score Commentary 5 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY6 |
Credit Score Commentary 6 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY7 |
Credit Score Commentary 7 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY8 |
Credit Score Commentary 8 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_COMMENTARY9 |
Credit Score Commentary 9 |
User for comments that are concerned with the credit score |
CREDIT_SCORE_DATE |
Credit Score Date |
Date when the credit score was calculated |
CREDIT_SCORE_INCD_DEFAULT |
Credit Score Incident Default |
Probability, expressed as a percentage, or delinquency for a score rance or class |
CREDIT_SCORE_NATL_PERCENTILE |
Credit Score National Percentile |
Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database |
CURR_FY_POTENTIAL_REVENUE |
Potential Revenue of Current Fiscal Year |
Organization's potential revenue of current fiscal year |
CUSTOM_ATTRIBUTE1 |
CUSTOM ATTRIBUTE 1 |
CUSTOM ATTRIBUTE 1 |
CUSTOM_ATTRIBUTE10 |
CUSTOM ATTRIBUTE 10 |
CUSTOM ATTRIBUTE 10 |
CUSTOM_ATTRIBUTE11 |
CUSTOM ATTRIBUTE 11 |
CUSTOM ATTRIBUTE 1 |
CUSTOM_ATTRIBUTE12 |
CUSTOM ATTRIBUTE 12 |
CUSTOM ATTRIBUTE 12 |
CUSTOM_ATTRIBUTE13 |
CUSTOM ATTRIBUTE 13 |
CUSTOM ATTRIBUTE 13 |
CUSTOM_ATTRIBUTE14 |
CUSTOM ATTRIBUTE 14 |
CUSTOM ATTRIBUTE 14 |
CUSTOM_ATTRIBUTE15 |
CUSTOM ATTRIBUTE 15 |
CUSTOM ATTRIBUTE 15 |
CUSTOM_ATTRIBUTE16 |
CUSTOM ATTRIBUTE 16 |
CUSTOM ATTRIBUTE 16 |
CUSTOM_ATTRIBUTE17 |
CUSTOM ATTRIBUTE 17 |
CUSTOM ATTRIBUTE 17 |
CUSTOM_ATTRIBUTE18 |
CUSTOM ATTRIBUTE 18 |
CUSTOM ATTRIBUTE 18 |
CUSTOM_ATTRIBUTE19 |
CUSTOM ATTRIBUTE 19 |
CUSTOM ATTRIBUTE 19 |
CUSTOM_ATTRIBUTE2 |
CUSTOM ATTRIBUTE 2 |
CUSTOM ATTRIBUTE 2 |
CUSTOM_ATTRIBUTE20 |
CUSTOM ATTRIBUTE 20 |
CUSTOM ATTRIBUTE 20 |
CUSTOM_ATTRIBUTE21 |
CUSTOM ATTRIBUTE 21 |
CUSTOM ATTRIBUTE 21 |
CUSTOM_ATTRIBUTE22 |
CUSTOM ATTRIBUTE 22 |
CUSTOM ATTRIBUTE 22 |
CUSTOM_ATTRIBUTE23 |
CUSTOM ATTRIBUTE 23 |
CUSTOM ATTRIBUTE 23 |
CUSTOM_ATTRIBUTE24 |
CUSTOM ATTRIBUTE 24 |
CUSTOM ATTRIBUTE 24 |
CUSTOM_ATTRIBUTE25 |
CUSTOM ATTRIBUTE 25 |
CUSTOM ATTRIBUTE 25 |
CUSTOM_ATTRIBUTE26 |
CUSTOM ATTRIBUTE 26 |
CUSTOM ATTRIBUTE 26 |
CUSTOM_ATTRIBUTE27 |
CUSTOM ATTRIBUTE 27 |
CUSTOM ATTRIBUTE 27 |
CUSTOM_ATTRIBUTE28 |
CUSTOM ATTRIBUTE 28 |
CUSTOM ATTRIBUTE 28 |
CUSTOM_ATTRIBUTE29 |
CUSTOM ATTRIBUTE 29 |
CUSTOM ATTRIBUTE 29 |
CUSTOM_ATTRIBUTE3 |
CUSTOM ATTRIBUTE 3 |
CUSTOM ATTRIBUTE 3 |
CUSTOM_ATTRIBUTE30 |
CUSTOM ATTRIBUTE 30 |
CUSTOM ATTRIBUTE 30 |
CUSTOM_ATTRIBUTE4 |
CUSTOM ATTRIBUTE 4 |
CUSTOM ATTRIBUTE 4 |
CUSTOM_ATTRIBUTE5 |
CUSTOM ATTRIBUTE 5 |
CUSTOM ATTRIBUTE 5 |
CUSTOM_ATTRIBUTE6 |
CUSTOM ATTRIBUTE 6 |
CUSTOM ATTRIBUTE 6 |
CUSTOM_ATTRIBUTE7 |
CUSTOM ATTRIBUTE 7 |
CUSTOM ATTRIBUTE 7 |
CUSTOM_ATTRIBUTE8 |
CUSTOM ATTRIBUTE 8 |
CUSTOM ATTRIBUTE 8 |
CUSTOM_ATTRIBUTE9 |
CUSTOM ATTRIBUTE 9 |
CUSTOM ATTRIBUTE 9 |
DATE_OF_BIRTH |
Date of Birth |
Date the person was born |
DATE_OF_DEATH |
Date of Death |
Date the person died |
DB_RATING |
Dun & Bradstreet Credit Rating |
Dun & Bradstreet credit rating |
DEBARMENTS_COUNT |
Debarments Count |
Count of filings by government agencies in the U.S. that prohibit the party from entering into contracts or transactions with those agencies |
DEBARMENTS_DATE |
Debarments Date |
Date of the most recent filing to prohibit the organization fom entering into contracts or transactions with a government agency of the U.S. |
DEBARMENT_IND |
Debarment Indicator |
Indicates if the organization is prohibited from entering into contracts or transactions with a government agency in the U.S. (Y/N) |
DECLARED_ETHNICITY |
Declared Ethnicity |
Declared ethnicity of the person |
DISADV_8A_IND |
Disadvantaged Under Title 8A Indicator |
Indicates if the organization is considered disadvantaged by the U.S. government agency under Title 8A (Y/N) |
DOMAIN_NAME |
E-Mail Domain |
E-Mail Domain |
DUNS_NUMBER_C |
DUNS Number |
Unique 9-digit identification number that is assigned to business entities by Dun & Bradstreet |
EFFECTIVE_END_DATE |
Effective End Date |
Date in which the organization profile data is no longer effective; used for date tracking capabilities |
EFFECTIVE_START_DATE |
Effective Start Date |
Date in which the organization profile data is effective. Used for date tracking capabilities |
EMPLOYEES_TOTAL |
Number of Employees |
Total number of employees |
EMP_AT_PRIMARY_ADR |
Number of Employees at Primary Address |
Number of employees at the referenced address |
EMP_AT_PRIMARY_ADR_EST_IND |
Number of Employees Estimation Indicator |
Lookup that indicates whether thie employee totla at the primary address is estimated; A is for estimated, N is for not estimated or actual |
EMP_AT_PRIMARY_ADR_MIN_IND |
Min/Max/Ave Number of Employees at Primary Address Indicator |
Minimum/Maximum/Average Employees at Primary Address Indicator |
EMP_AT_PRIMARY_ADR_TEXT |
Text Number of Employees at Primary Address |
Number of employees at the referenced address which cannot be mapped to a number |
ENQUIRY_DUNS |
Enquiry DUNS |
Identify used to query the Dun & Bradstreet data. If a location is a branch, then in some countries the headqusrters DUNS number is used to do the query. |
EXPORT_IND |
Export Indicator |
Indicates if the organization is an exporter (Y/N) |
FAILURE_SCORE |
Failure Score |
U.S.: the value representing the Failure Risk Class; Canada: Stability scosre that indicates the risk of business closure; Austrailia: percentile failure score |
FAILURE_SCORE_AGE |
Failure Score Age |
Age of failure score, expressed in months |
FAILURE_SCORE_CLASS |
Failure Score Class |
Measures the risk of financial stress for a customer account |
FAILURE_SCORE_COMMENTARY |
Failure Score Commentary |
Lookup for explanation code for the Failure Score |
FAILURE_SCORE_COMMENTARY10 |
Failure Score Commenty 10 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY2 |
Failure Score Commenty 2 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY3 |
Failure Score Commenty 3 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY4 |
Failure Score Commenty 4 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY5 |
Failure Score Commenty 5 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY6 |
Failure Score Commenty 6 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY7 |
Failure Score Commenty 7 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY8 |
Failure Score Commenty 8 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_COMMENTARY9 |
Failure Score Commenty 9 |
User for comments that are concerned with the failure score |
FAILURE_SCORE_DATE |
Failure Score Date |
Date when the failure score was calculated |
FAILURE_SCORE_INCD_DEFAULT |
Failure Score Incident Default |
Probability, expressed as percentage, of failure for a score range or class |
FAILURE_SCORE_OVERRIDE_CODE |
Failure Score Override Code |
Europe: indicates the reason for variance between the D&B rating and the Failure Score; U.S.: reason why no score was calculated, or that a score is equal to zero |
FISCAL_YEAREND_MONTH |
Last Month of Fiscal Year |
Month that fiscal year ends for the organization |
GENDER |
Gender |
Gender of the person |
GLOBAL_FAILURE_SCORE |
Global Failure Score |
Global score that indicates risk of business default |
GROUP_TYPE |
Group Type |
Lookup for group type |
GSA_INDICATOR_FLAG |
GSA Indicator Flag |
Indicates if the organization is a U.S. federal agency supported by the General Services Administration (GSA) (Y/N) |
HEAD_OF_HOUSEHOLD_FLAG |
Head of Household Flag |
Indicates if the person is the head of the household (Y/N) |
HIGH_CREDIT |
Highest Credit |
Maximum Credit ever extended to this organization |
HOUSEHOLD_INCOME |
Household Income |
Income of the household that this person is a part of |
HOUSEHOLD_SIZE |
Household Size |
Size of the household that the person is a part of |
HQ_BRANCH_IND |
HQ Branch Indicator |
Identifies if the organization is the HQ, a branch, or a single location |
IMPORT_IND |
Import Indicator |
Indicates if the organization is an importer (Y/N) |
INCORP_YEAR |
Year Incorporated |
year that the business was incorporated |
INTERNAL_FLAG |
Internal Flag |
Indicates whether the person is internal or external to the user's organization (Y/N) |
JGZZ_FISCAL_CODE |
JGZZ Fiscal Code |
Fiscal code of the person for certain European countries |
KNOWN_AS |
Known As 1 |
An alias or other name by which the person is known |
KNOWN_AS2 |
Known As 2 |
An alias or other name by which a person is known |
KNOWN_AS3 |
Known As 3 |
An alias or other name by which a person is known |
KNOWN_AS4 |
Known As 4 |
An alias or other name by which a person is known |
KNOWN_AS5 |
Known As 5 |
An alias or other name by which a person is known |
LABOR_SURPLUS_IND |
Labor Surplus Indicator |
Indicates if the organization operates in an area with a labor surplus. (Y/N) |
LANGUAGE_NAME |
Language Name |
Standard Name for a Language |
LAST_KNOWN_GPS |
Last Known GPS |
Geophysical location (GPS point) that was last reported for the person |
LEGAL_STATUS |
Legal Structure |
Legal Structure (e.g. partnership, corporation) |
LINE_OF_BUSINESS |
Line of Business |
Type of business activities performed at this site |
LOCAL_ACTIVITY_CODE |
Local Activity Classification Code |
Local activity classification code |
LOCAL_ACTIVITY_CODE_TYPE |
Local Activity Classification Code Type |
Local activity classification code type identifier |
LOCAL_BUS_IDENTIFIER |
Local Business Identifier |
Primary business ID number assigned tot he business by a government agency or industry association |
LOCAL_BUS_IDEN_TYPE |
Local Business Identifier Type |
Lookup for the primary domestic business ID number |
MARITAL_STATUS |
Marital Status |
Marital status of the person |
MARITAL_STATUS_EFFECTIVE_DATE |
Marital Status Effective Date |
Date when the person's marital status changed |
MAXIMUM_CREDIT_CURRENCY_CODE |
Maximum Credit Currency Code |
Currency used to state the MAXIMUM_CREDIT_RECOMMENDATION column |
MAXIMUM_CREDIT_RECOMMENDATION |
Maximum Credit Recommendation |
Maximum credit limit recommended for a specific currency |
MIDDLE_NAME_PHONETIC |
Person Middle Name Phonetic |
Japanese Kana, or phonetic representation of person's middle name |
MINORITY_OWNED_IND |
Minority Owned Indicator |
Indicates if the organization is primarily owned by an ethnic or racial minority (Y/N) |
MINORITY_OWNED_TYPE |
Minority Type |
Type of minority that primarily owns the organization |
NEXT_FY_POTENTIAL_REVENUE |
Potential Revenue of the Next Fiscal Year |
Organization's potential revenue of the next fiscal year |
OOB_IND |
Out of Business Indicator |
Indicates if the organzatio is out of business (Y/N) |
ORGANIZATION_NAME |
Organization Name |
Name of the organization |
ORGANIZATION_NAME_PHONETIC |
Phonetic Representation of Organization Name |
Japanese Kana, or phonetic representation of organization name |
ORGANIZATION_TYPE |
Organization Type |
User-defined organization types such as region, division, and department |
PARENT_SUB_IND |
Parent/Subsidiary Indicator |
Lookup that indicates if the organization is a parent or subsidiary |
PARTY_ALL_NAMES |
All Party Names |
All Party Names including Known As |
PARTY_NAME |
Party Name |
Name of the party |
PARTY_NUMBER |
Party Number |
Unique identification number of the party |
PARTY_SOURCE_SYSTEM_REF |
Party Source Details |
Party Source Details |
PARTY_TYPE |
Party Type |
Party type can only be Person, Organization, Group, or Relationship |
PAYDEX_NORM |
Paydex Norm |
Median paydex score for the industry which the organization belongs |
PAYDEX_SCORE |
Paydex Score |
Paydex score for the payment history over the last 12 months |
PAYDEX_THREE_MONTHS_AGO |
Paydex Score Three Months Ago |
Paydex score for payment history three months ago |
PERSONAL_INCOME |
Personal Income |
The estimated gross annual income of the person |
PERSON_ACADEMIC_TITLE |
Person Academic Title |
Academic title that is party of a person's name |
PERSON_FIRST_NAME |
Person First Name |
First name of the person |
PERSON_FIRST_NAME_PHONETIC |
Phonetic Representation of Person First Name |
Japanese Kana, or phonetic representation of person's first name |
PERSON_IDENTIFIER |
Personal Identification |
Identity reference field |
PERSON_IDEN_TYPE |
Type of Personal Identification |
Lookup representing most common personal identification number in a country |
PERSON_INITIALS |
Person Initials |
Name initials |
PERSON_LAST_NAME |
Person Last Name |
Last Name or surname of the person |
PERSON_LAST_NAME_PHONETIC |
Phonetic Representation of Person Last Name |
Japanese Kana, or phonetic representation of a person's last name |
PERSON_MIDDLE_NAME |
Person Middle Name |
Middle name of the person |
PERSON_NAME |
Person Name |
Name of the person |
PERSON_NAME_PHONETIC |
Phonetic Representation of Person Name |
Japanese Kana, or phonetic representation of a person name |
PERSON_NAME_SUFFIX |
Person Name Suffix |
Indicates the place in family structure |
PERSON_PREVIOUS_LAST_NAME |
Person Previous Last Name |
Previous last name or surname of person |
PERSON_PRE_NAME_ADJUNCT |
Person Pre-Name Adjunct |
Salutory introduction |
PERSON_TITLE |
Person Title |
A professional or family title |
PLACE_OF_BIRTH |
Place of Birth |
Where the person was born - typically, the city and country |
PREF_FUNCTIONAL_CURRENCY |
Preferred Functional Currency |
Organization's default currency code |
PRINCIPAL_NAME |
Principal Name |
Name of the highest rannking person in the organization |
PRINCIPAL_TITLE |
Principal Title |
Formal title of the highest ranking person in the organization |
PUBLIC_PRIVATE_OWNERSHIP_FLAG |
Private Ownership Flag |
Indicates is the organization is privately owned (Y/N) |
REFERENCE_USE_FLAG |
Reference Use Flag |
Indicates if customer has agreed to be a reference. (Y/N) |
REGISTRATION_TYPE |
Registration Type |
Lookup for type of registration, such as nonprofit |
RENT_OWN_IND |
Rent or Own Indicator |
Indicates if the person rents or owns his/her residence |
SALUTATION |
Salutation |
Phrase used to address a party in any correspondence |
SIC_CODE |
SIC Code |
Standard Industry Classification (SIC) Code |
SIC_CODE_TYPE |
SIC Code Version |
Version of Standard Industry Classification (SIC) Code |
SMALL_BUS_IND |
Small Business Indicator |
Indicates if the organization is considered to be a small business (Y/N) |
SOURCE_SYSTEM_REF |
fsdfs |
dfs |
STATUS |
Status |
Status flag |
TAX_NAME |
Tax Name |
Name of the party that is recognized by the tax authority |
TAX_REFERENCE |
Tax Reference |
Taxpayer identification number |
THIRD_PARTY_FLAG |
Third Party Flag |
Indicates if customer has a direct relationship with the organization using Oracle Receivables or through a third party vendor (Y/N) |
TOTAL_EMPLOYEES_IND |
Total Number of Employees Indicator |
Lookup that indicates whether subsidiaries are included in the calculation of total employees; A for totals without subsidiaries, B for totals with subsidiaries |
TOTAL_EMPLOYEES_TEXT |
Total Number of Employees in Text Format |
Total number of personnel employees if cannot be mapped to numeric field |
TOTAL_EMP_EST_IND |
Total Number of Employees Estimation Indicator |
Lookup that indicates whether the number of employees total is estimated; A for estimated, B for not estaimated or actual |
TOTAL_EMP_MIN_IND |
Total Number of Employees Min/Max/Ave Indicator |
Lookup that indicates whether the number is a minimum, maximum, or average number of total employees; A for minimum, B for maximum, C for average |
TOTAL_PAYMENTS |
Total Payments |
Total number of payment experiences |
VALIDATED_FLAG |
Validated Flag |
Indicates it the party was validated. (Y/N) |
WOMAN_OWNED_IND |
Woman Owned Index |
Indicates if the organization is primarily owned by a woman (Y/N) |
YEAR_ESTABLISHED |
Year Established |
Year that the organization began doing business |