CREATE TABLE hz_parties_ (
    PARTY_ID                       NUMBER(18, 0) ,
    PARTY_NUMBER                   VARCHAR2(120) ,
    PARTY_NAME                     VARCHAR2(1440),
    PARTY_TYPE                     VARCHAR2(120) ,
    LAST_UPDATED_BY                VARCHAR2(256) ,
    PARTY_UNIQUE_NAME              VARCHAR2(3600),
    CREATION_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    CREATED_BY                     VARCHAR2(256) ,
    LAST_UPDATE_DATE               TIMESTAMP(6)  ,
    ATTRIBUTE_CATEGORY             VARCHAR2(120) ,
    ATTRIBUTE1                     VARCHAR2(600) ,
    ATTRIBUTE2                     VARCHAR2(600) ,
    ATTRIBUTE3                     VARCHAR2(600) ,
    ATTRIBUTE4                     VARCHAR2(600) ,
    ATTRIBUTE5                     VARCHAR2(600) ,
    ATTRIBUTE6                     VARCHAR2(600) ,
    ATTRIBUTE7                     VARCHAR2(600) ,
    ATTRIBUTE8                     VARCHAR2(600) ,
    ATTRIBUTE9                     VARCHAR2(600) ,
    ATTRIBUTE10                    VARCHAR2(600) ,
    ATTRIBUTE11                    VARCHAR2(600) ,
    ATTRIBUTE12                    VARCHAR2(600) ,
    ATTRIBUTE13                    VARCHAR2(600) ,
    ATTRIBUTE14                    VARCHAR2(600) ,
    ATTRIBUTE15                    VARCHAR2(600) ,
    ATTRIBUTE16                    VARCHAR2(600) ,
    ATTRIBUTE17                    VARCHAR2(600) ,
    ATTRIBUTE18                    VARCHAR2(600) ,
    ATTRIBUTE19                    VARCHAR2(600) ,
    ATTRIBUTE20                    VARCHAR2(600) ,
    URL                            VARCHAR2(4000),
    ORIG_SYSTEM_REFERENCE          VARCHAR2(960) ,
    SIC_CODE                       VARCHAR2(120) ,
    ANALYSIS_FY                    VARCHAR2(20)  ,
    FISCAL_YEAREND_MONTH           VARCHAR2(120) ,
    YEAR_ESTABLISHED               NUMBER(4, 0)  ,
    GSA_INDICATOR_FLAG             VARCHAR2(4)   ,
    JGZZ_FISCAL_CODE               VARCHAR2(80)  ,
    MISSION_STATEMENT              VARCHAR2(4000),
    VALIDATED_FLAG                 VARCHAR2(4)   ,
    ATTRIBUTE21                    VARCHAR2(600) ,
    ATTRIBUTE22                    VARCHAR2(600) ,
    ATTRIBUTE23                    VARCHAR2(600) ,
    ATTRIBUTE24                    VARCHAR2(600) ,
    CURR_FY_POTENTIAL_REVENUE      NUMBER        ,
    NEXT_FY_POTENTIAL_REVENUE      NUMBER        ,
    PERSON_PRE_NAME_ADJUNCT        VARCHAR2(120) ,
    PERSON_FIRST_NAME              VARCHAR2(600) ,
    PERSON_MIDDLE_NAME             VARCHAR2(240) ,
    PERSON_LAST_NAME               VARCHAR2(600) ,
    PERSON_NAME_SUFFIX             VARCHAR2(120) ,
    PERSON_TITLE                   VARCHAR2(240) ,
    PERSON_PREVIOUS_LAST_NAME      VARCHAR2(600) ,
    MARITAL_STATUS                 VARCHAR2(120) ,
    GROUP_TYPE                     VARCHAR2(120) ,
    HQ_BRANCH_IND                  VARCHAR2(120) ,
    PERSON_ACADEMIC_TITLE          VARCHAR2(120) ,
    COUNTRY                        VARCHAR2(8)   ,
    ADDRESS1                       VARCHAR2(960) ,
    ADDRESS2                       VARCHAR2(960) ,
    ADDRESS3                       VARCHAR2(960) ,
    ADDRESS4                       VARCHAR2(960) ,
    CITY                           VARCHAR2(240) ,
    POSTAL_CODE                    VARCHAR2(240) ,
    STATE                          VARCHAR2(240) ,
    PROVINCE                       VARCHAR2(240) ,
    STATUS                         VARCHAR2(4)   ,
    COUNTY                         VARCHAR2(240) ,
    SIC_CODE_TYPE                  VARCHAR2(120) ,
    EMAIL_ADDRESS                  VARCHAR2(1280),
    EMPLOYEES_TOTAL                NUMBER        ,
    LANGUAGE_NAME                  VARCHAR2(120) ,
    CATEGORY_CODE                  VARCHAR2(120) ,
    THIRD_PARTY_FLAG               VARCHAR2(4)   ,
    SALUTATION                     VARCHAR2(240) ,
    DUNS_NUMBER_C                  VARCHAR2(120) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)  ,
    CREATED_BY_MODULE              VARCHAR2(120) ,
    CERTIFICATION_LEVEL            VARCHAR2(120) ,
    CERT_REASON_CODE               VARCHAR2(120) ,
    PRIMARY_PHONE_CONTACT_PT_ID    NUMBER(18, 0) ,
    PRIMARY_PHONE_PURPOSE          VARCHAR2(120) ,
    PRIMARY_PHONE_LINE_TYPE        VARCHAR2(120) ,
    PRIMARY_PHONE_COUNTRY_CODE     VARCHAR2(40)  ,
    PRIMARY_PHONE_AREA_CODE        VARCHAR2(80)  ,
    PRIMARY_PHONE_NUMBER           VARCHAR2(160) ,
    PRIMARY_PHONE_EXTENSION        VARCHAR2(80)  ,
    PREFERRED_CONTACT_METHOD       VARCHAR2(120) ,
    HOME_COUNTRY                   VARCHAR2(8)   ,
    PREFERRED_NAME_ID              NUMBER(18, 0) ,
    PREFERRED_NAME                 VARCHAR2(1440),
    PERSON_LAST_NAME_PREFIX        VARCHAR2(120) ,
    PERSON_SECOND_LAST_NAME        VARCHAR2(600) ,
    PREFERRED_CONTACT_PERSON_ID    NUMBER(18, 0) ,
    TRADING_PARTNER_IDENTIFIER     VARCHAR2(120) ,
    USER_GUID                      VARCHAR2(256) ,
    IDEN_ADDR_PARTY_SITE_ID        NUMBER(18, 0) ,
    IDEN_ADDR_LOCATION_ID          NUMBER(18, 0) ,
    PRIMARY_EMAIL_CONTACT_PT_ID    NUMBER(18, 0) ,
    PRIMARY_URL_CONTACT_PT_ID      NUMBER(18, 0) ,
    CONFLICT_ID                    NUMBER(18, 0) ,
    USER_LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    ATTRIBUTE25                    VARCHAR2(600) ,
    ATTRIBUTE26                    VARCHAR2(600) ,
    ATTRIBUTE27                    VARCHAR2(600) ,
    ATTRIBUTE28                    VARCHAR2(600) ,
    ATTRIBUTE29                    VARCHAR2(600) ,
    ATTRIBUTE30                    VARCHAR2(1020),
    DATE_OF_BIRTH                  DATE          ,
    GENDER                         VARCHAR2(120) ,
    INTERNAL_FLAG                  VARCHAR2(4)   ,
    PREF_FUNCTIONAL_CURRENCY       VARCHAR2(60)  ,
    CEO_NAME                       VARCHAR2(960) ,
    COMMENTS                       VARCHAR2(4000),
    CPDRF_VER_SOR                  NUMBER(9, 0)  ,
    CPDRF_VER_PILLAR               NUMBER(9, 0)  ,
    CPDRF_LAST_UPD                 VARCHAR2(60)  ,
    ATTRIBUTE_NUMBER1              NUMBER        ,
    ATTRIBUTE_NUMBER2              NUMBER        ,
    ATTRIBUTE_NUMBER3              NUMBER        ,
    ATTRIBUTE_NUMBER4              NUMBER        ,
    ATTRIBUTE_NUMBER5              NUMBER        ,
    ATTRIBUTE_NUMBER6              NUMBER        ,
    ATTRIBUTE_NUMBER7              NUMBER        ,
    ATTRIBUTE_NUMBER8              NUMBER        ,
    ATTRIBUTE_NUMBER9              NUMBER        ,
    ATTRIBUTE_NUMBER10             NUMBER        ,
    ATTRIBUTE_NUMBER11             NUMBER        ,
    ATTRIBUTE_NUMBER12             NUMBER        ,
    ATTRIBUTE_DATE1                DATE          ,
    ATTRIBUTE_DATE2                DATE          ,
    ATTRIBUTE_DATE3                DATE          ,
    ATTRIBUTE_DATE4                DATE          ,
    ATTRIBUTE_DATE5                DATE          ,
    ATTRIBUTE_DATE6                DATE          ,
    ATTRIBUTE_DATE7                DATE          ,
    ATTRIBUTE_DATE8                DATE          ,
    ATTRIBUTE_DATE9                DATE          ,
    ATTRIBUTE_DATE10               DATE          ,
    ATTRIBUTE_DATE11               DATE          ,
    ATTRIBUTE_DATE12               DATE          ,
    PERSONAL_ADDRESS_FLAG          VARCHAR2(4)   ,
    PERSONAL_EMAIL_FLAG            VARCHAR2(4)   ,
    PERSONAL_PHONE_FLAG            VARCHAR2(4)   ,
    SALES_ACCOUNT_ID               NUMBER(18, 0) ,
    OBJECT_TYPE                    VARCHAR2(120) ,
    AUDIT_ACTION_TYPE_             VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_          VARCHAR2(4000),
    AUDIT_IMPERSONATOR_            VARCHAR2(256) ,
    MASTER_PARTY_ID                NUMBER(18, 0) ,
    PARTY_ID                       NUMBER(18, 0) ,
    PARTY_NUMBER                   VARCHAR2(120) ,
    PARTY_NAME                     VARCHAR2(1440),
    PARTY_TYPE                     VARCHAR2(120) ,
    LAST_UPDATED_BY                VARCHAR2(256) ,
    PARTY_UNIQUE_NAME              VARCHAR2(3600),
    CREATION_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATE_LOGIN              VARCHAR2(128) ,
    REQUEST_ID                     NUMBER(18, 0) ,
    JOB_DEFINITION_NAME            VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE         VARCHAR2(3600),
    CREATED_BY                     VARCHAR2(256) ,
    LAST_UPDATE_DATE               TIMESTAMP(6)  ,
    ATTRIBUTE_CATEGORY             VARCHAR2(120) ,
    ATTRIBUTE1                     VARCHAR2(600) ,
    ATTRIBUTE2                     VARCHAR2(600) ,
    ATTRIBUTE3                     VARCHAR2(600) ,
    ATTRIBUTE4                     VARCHAR2(600) ,
    ATTRIBUTE5                     VARCHAR2(600) ,
    ATTRIBUTE6                     VARCHAR2(600) ,
    ATTRIBUTE7                     VARCHAR2(600) ,
    ATTRIBUTE8                     VARCHAR2(600) ,
    ATTRIBUTE9                     VARCHAR2(600) ,
    ATTRIBUTE10                    VARCHAR2(600) ,
    ATTRIBUTE11                    VARCHAR2(600) ,
    ATTRIBUTE12                    VARCHAR2(600) ,
    ATTRIBUTE13                    VARCHAR2(600) ,
    ATTRIBUTE14                    VARCHAR2(600) ,
    ATTRIBUTE15                    VARCHAR2(600) ,
    ATTRIBUTE16                    VARCHAR2(600) ,
    ATTRIBUTE17                    VARCHAR2(600) ,
    ATTRIBUTE18                    VARCHAR2(600) ,
    ATTRIBUTE19                    VARCHAR2(600) ,
    ATTRIBUTE20                    VARCHAR2(600) ,
    URL                            VARCHAR2(4000),
    ORIG_SYSTEM_REFERENCE          VARCHAR2(960) ,
    SIC_CODE                       VARCHAR2(120) ,
    ANALYSIS_FY                    VARCHAR2(20)  ,
    FISCAL_YEAREND_MONTH           VARCHAR2(120) ,
    YEAR_ESTABLISHED               NUMBER(4, 0)  ,
    GSA_INDICATOR_FLAG             VARCHAR2(4)   ,
    JGZZ_FISCAL_CODE               VARCHAR2(80)  ,
    MISSION_STATEMENT              VARCHAR2(4000),
    VALIDATED_FLAG                 VARCHAR2(4)   ,
    ATTRIBUTE21                    VARCHAR2(600) ,
    ATTRIBUTE22                    VARCHAR2(600) ,
    ATTRIBUTE23                    VARCHAR2(600) ,
    ATTRIBUTE24                    VARCHAR2(600) ,
    CURR_FY_POTENTIAL_REVENUE      NUMBER        ,
    NEXT_FY_POTENTIAL_REVENUE      NUMBER        ,
    PERSON_PRE_NAME_ADJUNCT        VARCHAR2(120) ,
    PERSON_FIRST_NAME              VARCHAR2(600) ,
    PERSON_MIDDLE_NAME             VARCHAR2(240) ,
    PERSON_LAST_NAME               VARCHAR2(600) ,
    PERSON_NAME_SUFFIX             VARCHAR2(120) ,
    PERSON_TITLE                   VARCHAR2(240) ,
    PERSON_PREVIOUS_LAST_NAME      VARCHAR2(600) ,
    MARITAL_STATUS                 VARCHAR2(120) ,
    GROUP_TYPE                     VARCHAR2(120) ,
    HQ_BRANCH_IND                  VARCHAR2(120) ,
    PERSON_ACADEMIC_TITLE          VARCHAR2(120) ,
    COUNTRY                        VARCHAR2(8)   ,
    ADDRESS1                       VARCHAR2(960) ,
    ADDRESS2                       VARCHAR2(960) ,
    ADDRESS3                       VARCHAR2(960) ,
    ADDRESS4                       VARCHAR2(960) ,
    CITY                           VARCHAR2(240) ,
    POSTAL_CODE                    VARCHAR2(240) ,
    STATE                          VARCHAR2(240) ,
    PROVINCE                       VARCHAR2(240) ,
    STATUS                         VARCHAR2(4)   ,
    COUNTY                         VARCHAR2(240) ,
    SIC_CODE_TYPE                  VARCHAR2(120) ,
    EMAIL_ADDRESS                  VARCHAR2(1280),
    EMPLOYEES_TOTAL                NUMBER        ,
    LANGUAGE_NAME                  VARCHAR2(120) ,
    CATEGORY_CODE                  VARCHAR2(120) ,
    THIRD_PARTY_FLAG               VARCHAR2(4)   ,
    SALUTATION                     VARCHAR2(240) ,
    DUNS_NUMBER_C                  VARCHAR2(120) ,
    OBJECT_VERSION_NUMBER          NUMBER(9, 0)  ,
    CREATED_BY_MODULE              VARCHAR2(120) ,
    CERTIFICATION_LEVEL            VARCHAR2(120) ,
    CERT_REASON_CODE               VARCHAR2(120) ,
    PRIMARY_PHONE_CONTACT_PT_ID    NUMBER(18, 0) ,
    PRIMARY_PHONE_PURPOSE          VARCHAR2(120) ,
    PRIMARY_PHONE_LINE_TYPE        VARCHAR2(120) ,
    PRIMARY_PHONE_COUNTRY_CODE     VARCHAR2(40)  ,
    PRIMARY_PHONE_AREA_CODE        VARCHAR2(80)  ,
    PRIMARY_PHONE_NUMBER           VARCHAR2(160) ,
    PRIMARY_PHONE_EXTENSION        VARCHAR2(80)  ,
    PREFERRED_CONTACT_METHOD       VARCHAR2(120) ,
    HOME_COUNTRY                   VARCHAR2(8)   ,
    PREFERRED_NAME_ID              NUMBER(18, 0) ,
    PREFERRED_NAME                 VARCHAR2(1440),
    PERSON_LAST_NAME_PREFIX        VARCHAR2(120) ,
    PERSON_SECOND_LAST_NAME        VARCHAR2(600) ,
    PREFERRED_CONTACT_PERSON_ID    NUMBER(18, 0) ,
    TRADING_PARTNER_IDENTIFIER     VARCHAR2(120) ,
    USER_GUID                      VARCHAR2(256) ,
    IDEN_ADDR_PARTY_SITE_ID        NUMBER(18, 0) ,
    IDEN_ADDR_LOCATION_ID          NUMBER(18, 0) ,
    PRIMARY_EMAIL_CONTACT_PT_ID    NUMBER(18, 0) ,
    PRIMARY_URL_CONTACT_PT_ID      NUMBER(18, 0) ,
    CONFLICT_ID                    NUMBER(18, 0) ,
    USER_LAST_UPDATE_DATE          TIMESTAMP(6)  ,
    ATTRIBUTE25                    VARCHAR2(600) ,
    ATTRIBUTE26                    VARCHAR2(600) ,
    ATTRIBUTE27                    VARCHAR2(600) ,
    ATTRIBUTE28                    VARCHAR2(600) ,
    ATTRIBUTE29                    VARCHAR2(600) ,
    ATTRIBUTE30                    VARCHAR2(1020),
    DATE_OF_BIRTH                  DATE          ,
    GENDER                         VARCHAR2(120) ,
    INTERNAL_FLAG                  VARCHAR2(4)   ,
    PREF_FUNCTIONAL_CURRENCY       VARCHAR2(60)  ,
    CEO_NAME                       VARCHAR2(960) ,
    COMMENTS                       VARCHAR2(4000),
    CPDRF_VER_SOR                  NUMBER(9, 0)  ,
    CPDRF_VER_PILLAR               NUMBER(9, 0)  ,
    CPDRF_LAST_UPD                 VARCHAR2(60)  ,
    ATTRIBUTE_NUMBER1              NUMBER        ,
    ATTRIBUTE_NUMBER2              NUMBER        ,
    ATTRIBUTE_NUMBER3              NUMBER        ,
    ATTRIBUTE_NUMBER4              NUMBER        ,
    ATTRIBUTE_NUMBER5              NUMBER        ,
    ATTRIBUTE_NUMBER6              NUMBER        ,
    ATTRIBUTE_NUMBER7              NUMBER        ,
    ATTRIBUTE_NUMBER8              NUMBER        ,
    ATTRIBUTE_NUMBER9              NUMBER        ,
    ATTRIBUTE_NUMBER10             NUMBER        ,
    ATTRIBUTE_NUMBER11             NUMBER        ,
    ATTRIBUTE_NUMBER12             NUMBER        ,
    ATTRIBUTE_DATE1                DATE          ,
    ATTRIBUTE_DATE2                DATE          ,
    ATTRIBUTE_DATE3                DATE          ,
    ATTRIBUTE_DATE4                DATE          ,
    ATTRIBUTE_DATE5                DATE          ,
    ATTRIBUTE_DATE6                DATE          ,
    ATTRIBUTE_DATE7                DATE          ,
    ATTRIBUTE_DATE8                DATE          ,
    ATTRIBUTE_DATE9                DATE          ,
    ATTRIBUTE_DATE10               DATE          ,
    ATTRIBUTE_DATE11               DATE          ,
    ATTRIBUTE_DATE12               DATE          ,
    PERSONAL_ADDRESS_FLAG          VARCHAR2(4)   ,
    PERSONAL_EMAIL_FLAG            VARCHAR2(4)   ,
    PERSONAL_PHONE_FLAG            VARCHAR2(4)   ,
    AUDIT_ACTION_TYPE_             VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_          VARCHAR2(4000),
    AUDIT_IMPERSONATOR_            VARCHAR2(256) ,
    SALES_ACCOUNT_ID               NUMBER(18, 0) ,
    OBJECT_TYPE                    VARCHAR2(120) ,
    MASTER_PARTY_ID                NUMBER(18, 0) ,
    CONSTRAINT pk_hz_parties_ PRIMARY KEY (PARTY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE, PARTY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE)
);
