Name |
Datatype |
Length |
Prcn |
ACTION_TYPE_P |
VARCHAR2
|
(30)
|
|
COMMON_OBJ_ID_P |
VARCHAR2
|
(255)
|
|
ORGANIZATION_ID_P |
NUMBER
|
|
|
ORIG_SYSTEM_P |
VARCHAR2
|
(30)
|
|
ORIG_SYSTEM_REFERENCE_P |
VARCHAR2
|
(255)
|
|
PARTY_NUMBER_P |
VARCHAR2
|
(30)
|
|
VALIDATED_FLAG_P |
VARCHAR2
|
(1)
|
|
STATUS_P |
VARCHAR2
|
(1)
|
|
CATEGORY_CODE_P |
VARCHAR2
|
(30)
|
|
SALUTATION_P |
VARCHAR2
|
(60)
|
|
ATTRIBUTE_CATEGORY_P |
VARCHAR2
|
(30)
|
|
ATTRIBUTE1_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE2_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE3_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE4_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE5_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE6_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE7_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE8_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE9_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE10_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE11_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE12_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE13_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE14_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE15_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE16_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE17_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE18_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE19_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE20_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE21_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE22_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE23_P |
VARCHAR2
|
(150)
|
|
ATTRIBUTE24_P |
VARCHAR2
|
(150)
|
|
ORGANIZATION_NAME_P |
VARCHAR2
|
(360)
|
|
DUNS_NUMBER_P |
VARCHAR2
|
(30)
|
|
ENQUIRY_DUNS_P |
VARCHAR2
|
(15)
|
|
CEO_NAME_P |
VARCHAR2
|
(240)
|
|
CEO_TITLE_P |
VARCHAR2
|
(240)
|
|
PRINCIPAL_NAME_P |
VARCHAR2
|
(240)
|
|
PRINCIPAL_TITLE_P |
VARCHAR2
|
(240)
|
|
LEGAL_STATUS_P |
VARCHAR2
|
(30)
|
|
CONTROL_YR_P |
NUMBER
|
|
|
EMPLOYEES_TOTAL_P |
NUMBER
|
|
|
HQ_BRANCH_IND_P |
VARCHAR2
|
(30)
|
|
BRANCH_FLAG_P |
VARCHAR2
|
(1)
|
|
OOB_IND_P |
VARCHAR2
|
(30)
|
|
LINE_OF_BUSINESS_P |
VARCHAR2
|
(240)
|
|
CONG_DIST_CODE_P |
VARCHAR2
|
(2)
|
|
SIC_CODE_P |
VARCHAR2
|
(30)
|
|
IMPORT_IND_P |
VARCHAR2
|
(30)
|
|
EXPORT_IND_P |
VARCHAR2
|
(30)
|
|
LABOR_SURPLUS_IND_P |
VARCHAR2
|
(30)
|
|
DEBARMENT_IND_P |
VARCHAR2
|
(30)
|
|
MINORITY_OWNED_IND_P |
VARCHAR2
|
(30)
|
|
MINORITY_OWNED_TYPE_P |
VARCHAR2
|
(30)
|
|
WOMAN_OWNED_IND_P |
VARCHAR2
|
(30)
|
|
DISADV_8A_IND_P |
VARCHAR2
|
(30)
|
|
SMALL_BUS_IND_P |
VARCHAR2
|
(30)
|
|
RENT_OWN_IND_P |
VARCHAR2
|
(30)
|
|
DEBARMENTS_COUNT_P |
NUMBER
|
|
|
DEBARMENTS_DATE_P |
DATE
|
|
|
FAILURE_SCORE_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_NATNL_PER_P |
NUMBER
|
|
|
FAILURE_SCORE_OVERRIDE_CODE_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY_P |
VARCHAR2
|
(30)
|
|
GLOBAL_FAILURE_SCORE_P |
VARCHAR2
|
(5)
|
|
DB_RATING_P |
VARCHAR2
|
(5)
|
|
CREDIT_SCORE_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY_P |
VARCHAR2
|
(30)
|
|
PAYDEX_SCORE_P |
VARCHAR2
|
(3)
|
|
PAYDEX_THREE_MONTHS_AGO_P |
VARCHAR2
|
(3)
|
|
PAYDEX_NORM_P |
VARCHAR2
|
(3)
|
|
BEST_TIME_CONTACT_BEGIN_P |
DATE
|
|
|
BEST_TIME_CONTACT_END_P |
DATE
|
|
|
ORGANIZATION_NAME_PHONETIC_P |
VARCHAR2
|
(320)
|
|
TAX_REFERENCE_P |
VARCHAR2
|
(50)
|
|
GSA_INDICATOR_FLAG_P |
VARCHAR2
|
(1)
|
|
JGZZ_FISCAL_CODE_P |
VARCHAR2
|
(20)
|
|
ANALYSIS_FY_P |
VARCHAR2
|
(5)
|
|
FISCAL_YEAREND_MONTH_P |
VARCHAR2
|
(30)
|
|
CURR_FY_POTENTIAL_REVENUE_P |
NUMBER
|
|
|
NEXT_FY_POTENTIAL_REVENUE_P |
NUMBER
|
|
|
YEAR_ESTABLISHED_P |
NUMBER
|
|
|
MISSION_STATEMENT_P |
VARCHAR2
|
(2000)
|
|
ORGANIZATION_TYPE_P |
VARCHAR2
|
(30)
|
|
BUSINESS_SCOPE_P |
VARCHAR2
|
(20)
|
|
CORPORATION_CLASS_P |
VARCHAR2
|
(60)
|
|
KNOWN_AS_P |
VARCHAR2
|
(240)
|
|
KNOWN_AS2_P |
VARCHAR2
|
(240)
|
|
KNOWN_AS3_P |
VARCHAR2
|
(240)
|
|
KNOWN_AS4_P |
VARCHAR2
|
(240)
|
|
KNOWN_AS5_P |
VARCHAR2
|
(240)
|
|
LOCAL_BUS_IDEN_TYPE_P |
VARCHAR2
|
(30)
|
|
LOCAL_BUS_IDENTIFIER_P |
VARCHAR2
|
(60)
|
|
PREF_FUNCTIONAL_CURRENCY_P |
VARCHAR2
|
(30)
|
|
REGISTRATION_TYPE_P |
VARCHAR2
|
(30)
|
|
TOTAL_EMPLOYEES_TEXT_P |
VARCHAR2
|
(60)
|
|
TOTAL_EMPLOYEES_IND_P |
VARCHAR2
|
(30)
|
|
TOTAL_EMP_EST_IND_P |
VARCHAR2
|
(30)
|
|
TOTAL_EMP_MIN_IND_P |
VARCHAR2
|
(30)
|
|
PARENT_SUB_IND_P |
VARCHAR2
|
(30)
|
|
INCORP_YEAR_P |
NUMBER
|
|
|
SIC_CODE_TYPE_P |
VARCHAR2
|
(30)
|
|
PUBLIC_PRIVATE_OWNER_FLAG_P |
VARCHAR2
|
(1)
|
|
INTERNAL_FLAG_P |
VARCHAR2
|
(30)
|
|
LOCAL_ACTIVITY_CODE_TYPE_P |
VARCHAR2
|
(30)
|
|
LOCAL_ACTIVITY_CODE_P |
VARCHAR2
|
(30)
|
|
EMP_AT_PRIMARY_ADR_P |
VARCHAR2
|
(10)
|
|
EMP_AT_PRIMARY_ADR_TEXT_P |
VARCHAR2
|
(12)
|
|
EMP_AT_PRIMARY_ADR_EST_IND_P |
VARCHAR2
|
(30)
|
|
EMP_AT_PRIMARY_ADR_MIN_IND_P |
VARCHAR2
|
(30)
|
|
HIGH_CREDIT_P |
NUMBER
|
|
|
AVG_HIGH_CREDIT_P |
NUMBER
|
|
|
TOTAL_PAYMENTS_P |
NUMBER
|
|
|
CREDIT_SCORE_CLASS_P |
NUMBER
|
|
|
CREDIT_SCORE_NATL_PERCENTILE_P |
NUMBER
|
|
|
CREDIT_SCORE_INCD_DEFAULT_P |
NUMBER
|
|
|
CREDIT_SCORE_AGE_P |
NUMBER
|
|
|
CREDIT_SCORE_DATE_P |
DATE
|
|
|
CREDIT_SCORE_COMMENTARY2_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY3_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY4_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY5_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY6_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY7_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY8_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY9_P |
VARCHAR2
|
(30)
|
|
CREDIT_SCORE_COMMENTARY10_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_CLASS_P |
NUMBER
|
|
|
FAILURE_SCORE_INCD_DEFAULT_P |
NUMBER
|
|
|
FAILURE_SCORE_AGE_P |
NUMBER
|
|
|
FAILURE_SCORE_DATE_P |
DATE
|
|
|
FAILURE_SCORE_COMMENTARY2_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY3_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY4_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY5_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY6_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY7_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY8_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY9_P |
VARCHAR2
|
(30)
|
|
FAILURE_SCORE_COMMENTARY10_P |
VARCHAR2
|
(30)
|
|
MAXIMUM_CREDIT_RECOMMEND_P |
NUMBER
|
|
|
MAXIMUM_CREDIT_CURRENCY_CODE_P |
VARCHAR2
|
(240)
|
|
DISPLAYED_DUNS_PARTY_ID_P |
NUMBER
|
|
|
PROGRAM_UPDATE_DATE_P |
DATE
|
|
|
CREATED_BY_MODULE_P |
VARCHAR2
|
(150)
|
|
CREATED_BY_NAME_P |
VARCHAR2
|
(100)
|
|
CREATION_DATE_P |
DATE
|
|
|
LAST_UPDATE_DATE_P |
DATE
|
|
|
LAST_UPDATED_BY_NAME_P |
VARCHAR2
|
(100)
|
|
DO_NOT_CONFUSE_WITH_P |
VARCHAR2
|
(255)
|
|
ACTUAL_CONTENT_SOURCE_P |
VARCHAR2
|
(30)
|
|
ORIG_SYS_OBJS |
HZ_ORIG_SYS_REF_OBJ_TBL
|
|
|
EXT_ATTRIBUTES_OBJS |
HZ_EXT_ATTRIBUTE_OBJ_TBL
|
|
|
CONTACT_OBJS |
POS_ORG_CONTACT_BO_TBL
|
|
|
PARTY_SITE_OBJS |
POS_PARTY_SITE_BO_TBL
|
|
|
PREFERENCE_OBJS |
HZ_PARTY_PREF_OBJ_TBL
|
|
|
PHONE_OBJS |
HZ_PHONE_CP_BO_TBL
|
|
|
TELEX_OBJS |
HZ_TELEX_CP_BO_TBL
|
|
|
EMAIL_OBJS |
HZ_EMAIL_CP_BO_TBL
|
|
|
WEB_OBJS |
HZ_WEB_CP_BO_TBL
|
|
|
EDI_OBJS |
HZ_EDI_CP_BO_TBL
|
|
|
EFT_OBJS |
HZ_EFT_CP_BO_TBL
|
|
|
RELATIONSHIP_OBJS |
HZ_RELATIONSHIP_OBJ_TBL
|
|
|
CLASS_OBJS |
HZ_CODE_ASSIGNMENT_OBJ_TBL
|
|
|
FINANCIAL_REPORT_OBJS |
HZ_FINANCIAL_BO_TBL
|
|
|
CREDIT_RATING_OBJS |
HZ_CREDIT_RATING_OBJ_TBL
|
|
|
CERTIFICATION_OBJS |
HZ_CERTIFICATION_OBJ_TBL
|
|
|
FINANCIAL_PROF_OBJS |
HZ_FINANCIAL_PROF_OBJ_TBL
|
|
|
CONTACT_PREF_OBJS |
HZ_CONTACT_PREF_OBJ_TBL
|
|
|
PARTY_USAGE_OBJS |
HZ_PARTY_USAGE_OBJ_TBL
|
|
|