CREATE TABLE fv_sam_trading_partner_int (
    UNIQUE_ENTITY_IDENTIFIER_SAM      VARCHAR2(48) ,
    UNIQUE_ENTITY_IDENTIFIER_DUNS     VARCHAR2(60) ,
    ENTITY_EFT_INDICATOR              VARCHAR2(40) ,
    CAGE_CODE                         VARCHAR2(20) ,
    DODAAC_CODE                       VARCHAR2(36) ,
    SAM_EXTRACT_CODE                  VARCHAR2(4)  ,
    PURPOSE_OF_REGISTRATION_CODE      VARCHAR2(8)  ,
    INITIAL_REGISTRATION_DATE         DATE         ,
    REGISTRATION_EXPIRATION_DATE      DATE         ,
    SAM_TRD_PARTNER_UPDATED_DATE      DATE         ,
    ACTIVATION_DATE                   DATE         ,
    LEGAL_BUSINESS_NAME               VARCHAR2(480),
    DBA_NAME                          VARCHAR2(480),
    ENTITY_DIVISION_NAME              VARCHAR2(240),
    ENTITY_DIVISION_NUMBER            VARCHAR2(40) ,
    PHYS_ADDR_LINE_1                  VARCHAR2(600),
    PHYS_ADDR_LINE_2                  VARCHAR2(600),
    PHYS_ADDR_CITY                    VARCHAR2(160),
    PHYS_ADDR_PROVINCE_OR_STATE       VARCHAR2(220),
    PHYS_ADDR_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    PHYS_ADDR_ZIP_CODE_PLUS_4         NUMBER       ,
    PHYS_ADDR_COUNTRY_CODE            VARCHAR2(12) ,
    CONGRESSIONAL_DISTRICT            NUMBER       ,
    D_AND_B_OPEN_DATA_FLAG            VARCHAR2(4)  ,
    ENTITY_START_DATE                 DATE         ,
    FISCAL_YEAR_CLOSE_DATE            VARCHAR2(16) ,
    COMPANY_SECURITY_LEVEL            VARCHAR2(8)  ,
    TOP_EMPLOYEE_SECURITY_LEVEL       VARCHAR2(8)  ,
    ENTITY_URL                        VARCHAR2(800),
    ENTITY_STRUCTURE_CODE             VARCHAR2(8)  ,
    STATE_OF_INCORPORATION            VARCHAR2(8)  ,
    COUNTRY_OF_INCORPORATION          VARCHAR2(12) ,
    BUSINESS_TYPE_COUNT               NUMBER       ,
    BUSINESS_TYPES_INFORMATION        CLOB         ,
    AGENCY_BUSINESS_PURPOSE_CODE      VARCHAR2(4)  ,
    PRIMARY_NAICS_CODE                VARCHAR2(24) ,
    NAICS_CODE_COUNT                  NUMBER       ,
    NAICS_CODES_INFORMATION           CLOB         ,
    PSC_CODE_COUNT                    NUMBER       ,
    PSC_CODES_INFORMATION             CLOB         ,
    CREDIT_CARD_USAGE_CODE            VARCHAR2(4)  ,
    CORRESPONDENCE_CODE               VARCHAR2(4)  ,
    MAIL_ADDR_LINE_1                  VARCHAR2(600),
    MAIL_ADDR_LINE_2                  VARCHAR2(600),
    MAIL_ADDR_CITY                    VARCHAR2(160),
    MAIL_ADDR_ZIP_POSTAL_CODE         VARCHAR2(200),
    MAIL_ADDR_ZIP_CODE_PLUS_4         NUMBER       ,
    MAIL_ADDR_COUNTRY                 VARCHAR2(12) ,
    MAIL_ADDR_STATE_OR_PROVINCE       VARCHAR2(220),
    GOV_POC_FIRST_NAME                VARCHAR2(260),
    GOV_POC_MIDDLE_INITIAL            VARCHAR2(12) ,
    GOV_POC_LAST_NAME                 VARCHAR2(260),
    GOV_POC_TITLE                     VARCHAR2(200),
    GOV_POC_ST_ADDR_1                 VARCHAR2(600),
    GOV_POC_ST_ADDR_2                 VARCHAR2(600),
    GOV_POC_CITY                      VARCHAR2(160),
    GOV_POC_ZIP_OR_POSTAL_CODE        VARCHAR2(200),
    GOV_POC_ZIP_CODE_PLUS_4           NUMBER       ,
    GOV_POC_COUNTRY_CODE              VARCHAR2(12) ,
    GOV_POC_STATE_OR_PROVINCE         VARCHAR2(220),
    GOV_POC_US_PHONE                  VARCHAR2(120),
    GOV_POC_US_PHONE_EXT              VARCHAR2(100),
    GOV_POC_NON_US_PHONE              VARCHAR2(120),
    GOV_POC_FAX_US_ONLY               VARCHAR2(120),
    GOV_POC_EMAIL                     VARCHAR2(320),
    ALT_GOV_POC_FIRST_NAME            VARCHAR2(260),
    ALT_GOV_POC_MIDDLE_INITIAL        VARCHAR2(12) ,
    ALT_GOV_POC_LAST_NAME             VARCHAR2(260),
    ALT_GOV_POC_TITLE                 VARCHAR2(200),
    ALT_GOV_POC_ST_ADDR_1             VARCHAR2(600),
    ALT_GOV_POC_ST_ADDR_2             VARCHAR2(600),
    ALT_GOV_POC_CITY                  VARCHAR2(160),
    ALT_GOV_POC_ZIP_POSTAL_CODE       VARCHAR2(200),
    ALT_GOV_POC_ZIP_CODE_PLUS_4       NUMBER       ,
    ALT_GOV_POC_COUNTRY_CODE          VARCHAR2(12) ,
    ALT_GOV_POC_STATE_OR_PROVINCE     VARCHAR2(220),
    ALT_GOV_POC_US_PHONE              VARCHAR2(120),
    ALT_GOV_POC_US_PHONE_EXT          VARCHAR2(100),
    ALT_GOV_POC_NON_US_PHONE          VARCHAR2(120),
    ALT_GOV_POC_FAX_US_ONLY           VARCHAR2(120),
    ALT_GOV_POC_EMAIL                 VARCHAR2(320),
    PAST_PERF_FIRST_NAME              VARCHAR2(260),
    PAST_PERF_MIDDLE_INITIAL          VARCHAR2(12) ,
    PAST_PERF_LAST_NAME               VARCHAR2(260),
    PAST_PERF_TITLE                   VARCHAR2(200),
    PAST_PERF_ST_ADDR_1               VARCHAR2(600),
    PAST_PERF_ST_ADDR_2               VARCHAR2(600),
    PAST_PERF_CITY                    VARCHAR2(160),
    PAST_PERF_ZIP_POSTAL_CODE         VARCHAR2(200),
    PAST_PERF_ZIP_CODE_PLUS_4         NUMBER       ,
    PAST_PERF_COUNTRY_CODE            VARCHAR2(12) ,
    PAST_PERF_STATE_OR_PROVINCE       VARCHAR2(220),
    PAST_PERF_US_PHONE                VARCHAR2(120),
    PAST_PERF_US_PHONE_EXT            VARCHAR2(100),
    PAST_PERF_NON_US_PHONE            VARCHAR2(120),
    PAST_PERF_FAX_US_ONLY             VARCHAR2(120),
    PAST_PERF_EMAIL                   VARCHAR2(320),
    ALT_PAST_FIRST_NAME               VARCHAR2(260),
    ALT_PAST_MIDDLE_INITIAL           VARCHAR2(12) ,
    ALT_PAST_LAST_NAME                VARCHAR2(260),
    ALT_PAST_TITLE                    VARCHAR2(200),
    ALT_PAST_ST_ADDR_1                VARCHAR2(600),
    ALT_PAST_ST_ADDR_2                VARCHAR2(600),
    ALT_PAST_CITY                     VARCHAR2(160),
    ALT_PAST_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    ALT_PAST_ZIP_CODE_PLUS_4          NUMBER       ,
    ALT_PAST_COUNTRY_CODE             VARCHAR2(12) ,
    ALT_PAST_STATE_OR_PROVINCE        VARCHAR2(220),
    ALT_PAST_US_PHONE                 VARCHAR2(120),
    ALT_PAST_US_PHONE_EXT             VARCHAR2(100),
    ALT_PAST_NON_US_PHONE             VARCHAR2(120),
    ALT_PAST_FAX_US_ONLY              VARCHAR2(120),
    ALT_PAST_EMAIL                    VARCHAR2(320),
    E_BIZ_POC_FIRST_NAME              VARCHAR2(260),
    E_BIZ_POC_MIDDLE_INITIAL          VARCHAR2(12) ,
    E_BIZ_POC_LAST_NAME               VARCHAR2(260),
    E_BIZ_POC_TITLE                   VARCHAR2(200),
    E_BIZ_POC_ST_ADDR_1               VARCHAR2(600),
    E_BIZ_POC_ST_ADDR_2               VARCHAR2(600),
    E_BIZ_POC_CITY                    VARCHAR2(160),
    E_BIZ_POC_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    E_BIZ_POC_ZIP_CODE_PLUS_4         NUMBER       ,
    E_BIZ_POC_COUNTRY_CODE            VARCHAR2(12) ,
    E_BIZ_POC_STATE_OR_PROVINCE       VARCHAR2(220),
    E_BIZ_POC_US_PHONE                VARCHAR2(120),
    E_BIZ_POC_US_PHONE_EXT            VARCHAR2(100),
    E_BIZ_POC_NON_US_PHONE            VARCHAR2(120),
    E_BIZ_POC_FAX_US_ONLY             VARCHAR2(120),
    E_BIZ_POC_EMAIL                   VARCHAR2(320),
    ALT_E_BIZ_FIRST_NAME              VARCHAR2(260),
    ALT_E_BIZ_MIDDLE_INITIAL          VARCHAR2(12) ,
    ALT_E_BIZ_LAST_NAME               VARCHAR2(260),
    ALT_E_BIZ_TITLE                   VARCHAR2(200),
    ALT_E_BIZ_ST_ADDR_1               VARCHAR2(600),
    ALT_E_BIZ_ST_ADDR_2               VARCHAR2(600),
    ALT_E_BIZ_CITY                    VARCHAR2(160),
    ALT_E_BIZ_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    ALT_E_BIZ_ZIP_CODE_PLUS_4         NUMBER       ,
    ALT_E_BIZ_COUNTRY_CODE            VARCHAR2(12) ,
    ALT_E_BIZ_STATE_OR_PROVINCE       VARCHAR2(220),
    ALT_E_BIZ_US_PHONE                VARCHAR2(120),
    ALT_E_BIZ_US_PHONE_EXT            VARCHAR2(100),
    ALT_E_BIZ_NON_US_PHONE            VARCHAR2(120),
    ALT_E_BIZ_FAX_US_ONLY             VARCHAR2(120),
    ALT_E_BIZ_EMAIL                   VARCHAR2(320),
    CERT_POC_FIRST_NAME               VARCHAR2(260),
    CERT_POC_MIDDLE_INITIAL           VARCHAR2(12) ,
    CERT_POC_LAST_NAME                VARCHAR2(260),
    CERT_POC_TITLE                    VARCHAR2(200),
    CERT_POC_ST_ADDR_1                VARCHAR2(600),
    CERT_POC_ST_ADDR_2                VARCHAR2(600),
    CERT_POC_CITY                     VARCHAR2(160),
    CERT_POC_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    CERT_POC_ZIP_CODE_PLUS_4          NUMBER       ,
    CERT_POC_COUNTRY_CODE             VARCHAR2(12) ,
    CERT_POC_STATE_OR_PROVINCE        VARCHAR2(220),
    CERT_POC_US_PHONE                 VARCHAR2(120),
    CERT_POC_US_PHONE_EXT             VARCHAR2(100),
    CERT_POC_NON_US_PHONE             VARCHAR2(120),
    CERT_POC_FAX_US_ONLY              VARCHAR2(120),
    CERT_POC_EMAIL                    VARCHAR2(320),
    SOLE_PROP_POC_FIRST_NAME          VARCHAR2(260),
    SOLE_PROP_POC_MIDDLE_INITIAL      VARCHAR2(12) ,
    SOLE_PROP_POC_LAST_NAME           VARCHAR2(260),
    SOLE_PROP_POC_TITLE               VARCHAR2(200),
    SOLE_PROP_POC_US_PHONE            VARCHAR2(120),
    SOLE_PROP_POC_US_PHONE_EXT        VARCHAR2(100),
    SOLE_PROP_POC_NON_US_PHONE        VARCHAR2(120),
    SOLE_PROP_POC_FAX_US_ONLY         VARCHAR2(120),
    SOLE_PROP_POC_EMAIL               VARCHAR2(320),
    IMMED_PARENT_LEGAL_BIZ_NAME       VARCHAR2(600),
    IMMED_PARENT_UEI_SAM              VARCHAR2(48) ,
    IMMED_PARENT_ST_ADDR_1            VARCHAR2(600),
    IMMED_PARENT_ST_ADDR_2            VARCHAR2(600),
    IMMED_PARENT_CITY                 VARCHAR2(160),
    IMMED_PARENT_POSTAL_CODE          VARCHAR2(200),
    IMMED_PARENT_COUNTRY_CODE         VARCHAR2(12) ,
    IMMED_PARENT_STATE_OR_PROVINCE    VARCHAR2(220),
    IMMED_PARENT_PHONE                VARCHAR2(120),
    HQ_PARENT_LEGAL_BIZ_NAME          VARCHAR2(600),
    HQ_PARENT_UEI_SAM                 VARCHAR2(48) ,
    HQ_PARENT_UEI_DUNS                VARCHAR2(60) ,
    HQ_PARENT_ST_ADDR_1               VARCHAR2(600),
    HQ_PARENT_ST_ADDR_2               VARCHAR2(600),
    HQ_PARENT_CITY                    VARCHAR2(160),
    HQ_PARENT_POSTAL_CODE             VARCHAR2(200),
    HQ_PARENT_COUNTRY_CODE            VARCHAR2(12) ,
    HQ_PARENT_STATE_OR_PROVINCE       VARCHAR2(220),
    HQ_PARENT_PHONE                   VARCHAR2(120),
    ULT_DPARENT_LEGAL_BIZ_NAME        VARCHAR2(600),
    ULT_DPARENT_UEI_SAM               VARCHAR2(48) ,
    ULT_DPARENT_UEI_DUNS              VARCHAR2(60) ,
    ULT_DPARENT_ST_ADDR_1             VARCHAR2(600),
    ULT_DPARENT_ST_ADDR_2             VARCHAR2(600),
    ULT_DPARENT_CITY                  VARCHAR2(160),
    ULT_DPARENT_POSTAL_CODE           VARCHAR2(200),
    ULT_DPARENT_COUNTRY_CODE          VARCHAR2(12) ,
    ULT_DPARENT_STATE_OR_PROVINCE     VARCHAR2(220),
    ULT_DPARENT_PHONE                 VARCHAR2(120),
    ULT_PARENT_LEGAL_BIZ_NAME         VARCHAR2(600),
    ULT_PARENT_UEI_SAM                VARCHAR2(48) ,
    ULT_PARENT_UEI_DUNS               VARCHAR2(60) ,
    ULT_PARENT_ST_ADDR_1              VARCHAR2(600),
    ULT_PARENT_ST_ADDR_2              VARCHAR2(600),
    ULT_PARENT_CITY                   VARCHAR2(160),
    ULT_PARENT_POSTAL_CODE            VARCHAR2(200),
    ULT_PARENT_COUNTRY_CODE           VARCHAR2(12) ,
    ULT_PARENT_STATE_OR_PROVINCE      VARCHAR2(220),
    ULT_PARENT_PHONE                  VARCHAR2(120),
    EVS_OUT_OF_BIZ_FLAG               VARCHAR2(4)  ,
    EVS_MONITOR_LAST_UPDATE_DATE      DATE         ,
    EVS_MONITOR_STATUS_FLAG           VARCHAR2(4)  ,
    EVS_MONITOR_LEGAL_BIZ_NAME        VARCHAR2(480),
    EVS_MONITOR_DBA_NAME              VARCHAR2(480),
    EVS_MONITOR_ADDRESS_1             VARCHAR2(600),
    EVS_MONITOR_ADDRESS_2             VARCHAR2(600),
    EVS_MONITOR_CITY                  VARCHAR2(160),
    EVS_MONITOR_POSTAL_CODE           VARCHAR2(200),
    EVS_MONITOR_COUNTRY_CODE          VARCHAR2(12) ,
    EVS_MONITOR_STATE_OR_PROVINCE     VARCHAR2(220),
    PROVIDE_EDI_FLAG                  VARCHAR2(4)  ,
    EDI_VAN_PROVIDER                  VARCHAR2(80) ,
    ISA_QUALIFIER                     VARCHAR2(8)  ,
    ISA_IDENTIFIER                    VARCHAR2(60) ,
    FUNCTIONAL_GROUP_IDENTIFIER       VARCHAR2(60) ,
    REQUEST_820S_FLAG                 VARCHAR2(4)  ,
    EDI_POC_FIRST_NAME                VARCHAR2(260),
    EDI_POC_MIDDLE_INITIAL            VARCHAR2(12) ,
    EDI_POC_LAST_NAME                 VARCHAR2(260),
    EDI_POC_TITLE                     VARCHAR2(200),
    EDI_POC_US_PHONE                  VARCHAR2(120),
    EDI_POC_US_PHONE_EXT              VARCHAR2(100),
    EDI_POC_NON_US_PHONE              VARCHAR2(120),
    EDI_POC_FAX_US_ONLY               VARCHAR2(120),
    EDI_POC_EMAIL                     VARCHAR2(320),
    TAX_IDENTIFIER_TYPE_CODE          VARCHAR2(4)  ,
    TAX_IDENTIFIER_NUMBER             VARCHAR2(100),
    AVERAGE_NUMBER_OF_EMPLOYEES       VARCHAR2(100),
    AVERAGE_ANNUAL_REVENUE            VARCHAR2(100),
    FINANCIAL_INSTITUTE_NAME          VARCHAR2(200),
    ENTITY_ACCOUNT_NUMBER             VARCHAR2(120),
    ABA_ROUTING_ID                    NUMBER       ,
    ACCOUNT_TYPE_CODE                 VARCHAR2(4)  ,
    LOCKBOX_NUMBER                    VARCHAR2(80) ,
    AUTHORIZATION_DATE                DATE         ,
    EFT_WAIVER_FLAG                   VARCHAR2(4)  ,
    ACH_US_PHONE                      VARCHAR2(120),
    ACH_NON_US_PHONE                  VARCHAR2(120),
    ACH_FAX                           VARCHAR2(120),
    ACH_EMAIL                         VARCHAR2(320),
    REMITTANCE_NAME                   VARCHAR2(480),
    REMITTANCE_ADDRESS_LINE_1         VARCHAR2(600),
    REMITTANCE_ADDRESS_LINE_2         VARCHAR2(600),
    REMITTANCE_CITY                   VARCHAR2(160),
    REMITTANCE_STATE_OR_PROVINCE      VARCHAR2(220),
    REMITTANCE_ZIP_OR_POSTAL_CODE     VARCHAR2(200),
    REMITTANCE_ZIP_CODE_PLUS_4        NUMBER       ,
    REMITTANCE_COUNTRY_CODE           VARCHAR2(12) ,
    AR_POC_FIRST_NAME                 VARCHAR2(260),
    AR_POC_MIDDLE_INITIAL             VARCHAR2(12) ,
    AR_POC_LAST_NAME                  VARCHAR2(260),
    AR_POC_TITLE                      VARCHAR2(200),
    AR_POC_US_PHONE                   VARCHAR2(120),
    AR_POC_US_PHONE_EXT               VARCHAR2(100),
    AR_POC_NON_US_PHONE               VARCHAR2(120),
    AR_POC_FAX_US_ONLY                VARCHAR2(120),
    AR_POC_EMAIL                      VARCHAR2(320),
    AP_POC_FIRST_NAME                 VARCHAR2(260),
    AP_POC_MIDDLE_INITIAL             VARCHAR2(12) ,
    AP_POC_LAST_NAME                  VARCHAR2(260),
    AP_POC_TITLE                      VARCHAR2(200),
    AP_POC_ST_ADDR_1                  VARCHAR2(600),
    AP_POC_ST_ADDR_2                  VARCHAR2(600),
    AP_POC_CITY                       VARCHAR2(160),
    AP_POC_ZIP_OR_POSTAL_CODE         VARCHAR2(200),
    AP_POC_ZIP_CODE_PLUS_4            NUMBER       ,
    AP_POC_COUNTRY_CODE               VARCHAR2(12) ,
    AP_POC_STATE_OR_PROVINCE          VARCHAR2(220),
    AP_POC_US_PHONE                   VARCHAR2(120),
    AP_POC_US_PHONE_EXT               VARCHAR2(100),
    AP_POC_NON_US_PHONE               VARCHAR2(120),
    AP_POC_FAX_US_ONLY                VARCHAR2(120),
    AP_POC_EMAIL                      VARCHAR2(320),
    MPI_NUMBER                        VARCHAR2(36) ,
    NAICS_EXCEPTION_COUNT             NUMBER       ,
    NAICS_EXCEPTIONS_INFORMATION      CLOB         ,
    DEBT_SUBJECT_TO_OFFSET_FLAG       VARCHAR2(4)  ,
    EXCLUSION_STATUS_CODE             VARCHAR2(4)  ,
    SBA_BIZ_TYPES_COUNT               NUMBER       ,
    SBA_BIZ_TYPES_INFORMATION         CLOB         ,
    SAM_NUMERIC_TYPES_COUNT           NUMBER       ,
    SAM_NUMERIC_TYPES_INFORMATION     CLOB         ,
    NO_PUBLIC_DISPLAY_CODE            VARCHAR2(16) ,
    DISASTER_RESPONSE_COUNT           NUMBER       ,
    DISASTER_RESPONSES_INFORMATION    CLOB         ,
    ANNUAL_IGT_REVENUE                VARCHAR2(100),
    AGENCY_LOCATION_CODE              VARCHAR2(32) ,
    DISBURSING_OFFICE_SYMBOL          VARCHAR2(20) ,
    MERCHANT_ID_1                     VARCHAR2(520),
    MERCHANT_ID_2                     VARCHAR2(520),
    ACCOUNTING_STATION                VARCHAR2(24) ,
    SOURCE_ENTITY_CODE                VARCHAR2(28) ,
    DEPARTMENT_CODE                   VARCHAR2(8)  ,
    HIERARCHY_DEPARTMENT_CODE         VARCHAR2(16) ,
    HIERARCHY_DEPARTMENT_NAME         VARCHAR2(600),
    HIERARCHY_AGENCY_CODE             VARCHAR2(16) ,
    HIERARCHY_AGENCY_NAME             VARCHAR2(600),
    HIERARCHY_OFFICE_CODE             VARCHAR2(24) ,
    ELIM_POC_FIRST_NAME               VARCHAR2(260),
    ELIM_POC_MIDDLE_INITIAL           VARCHAR2(12) ,
    ELIM_POC_LAST_NAME                VARCHAR2(260),
    ELIM_POC_TITLE                    VARCHAR2(200),
    ELIM_POC_ST_ADDR_1                VARCHAR2(600),
    ELIM_POC_ST_ADDR_2                VARCHAR2(600),
    ELIM_POC_CITY                     VARCHAR2(160),
    ELIM_POC_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    ELIM_POC_ZIP_CODE_PLUS_4          NUMBER       ,
    ELIM_POC_COUNTRY_CODE             VARCHAR2(12) ,
    ELIM_POC_STATE_OR_PROVINCE        VARCHAR2(220),
    ELIM_POC_US_PHONE                 VARCHAR2(120),
    ELIM_POC_US_PHONE_EXT             VARCHAR2(100),
    ELIM_POC_NON_US_PHONE             VARCHAR2(120),
    ELIM_POC_FAX_US_ONLY              VARCHAR2(120),
    ELIM_POC_EMAIL                    VARCHAR2(320),
    SALES_POC_FIRST_NAME              VARCHAR2(260),
    SALES_POC_MIDDLE_INITIAL          VARCHAR2(12) ,
    SALES_POC_LAST_NAME               VARCHAR2(260),
    SALES_POC_TITLE                   VARCHAR2(200),
    SALES_POC_ST_ADDR_1               VARCHAR2(600),
    SALES_POC_ST_ADDR_2               VARCHAR2(600),
    SALES_POC_CITY                    VARCHAR2(160),
    SALES_POC_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    SALES_POC_ZIP_CODE_PLUS_4         NUMBER       ,
    SALES_POC_COUNTRY_CODE            VARCHAR2(12) ,
    SALES_POC_STATE_OR_PROVINCE       VARCHAR2(220),
    SALES_POC_US_PHONE                VARCHAR2(120),
    SALES_POC_US_PHONE_EXT            VARCHAR2(100),
    SALES_POC_NON_US_PHONE            VARCHAR2(120),
    SALES_POC_FAX_US_ONLY             VARCHAR2(120),
    SALES_POC_EMAIL                   VARCHAR2(320),
    TAXPAYER_NAME                     VARCHAR2(480),
    SAM_REC_STATUS                    VARCHAR2(120)    NOT NULL,
    LOAD_REQUEST_ID                   NUMBER       ,
    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),
    ATTRIBUTE_NUMBER1                 NUMBER       ,
    ATTRIBUTE_NUMBER2                 NUMBER       ,
    ATTRIBUTE_NUMBER3                 NUMBER       ,
    ATTRIBUTE_NUMBER4                 NUMBER       ,
    ATTRIBUTE_NUMBER5                 NUMBER       ,
    ATTRIBUTE_DATE1                   DATE         ,
    ATTRIBUTE_DATE2                   DATE         ,
    ATTRIBUTE_DATE3                   DATE         ,
    ATTRIBUTE_DATE4                   DATE         ,
    ATTRIBUTE_DATE5                   DATE         ,
    ATTRIBUTE_CATEGORY                VARCHAR2(600),
    CREATION_DATE                     TIMESTAMP(6) ,
    CREATED_BY                        VARCHAR2(256),
    LAST_UPDATE_DATE                  TIMESTAMP(6) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    LAST_UPDATED_BY                   VARCHAR2(256),
    UNIQUE_ENTITY_IDENTIFIER_SAM      VARCHAR2(48) ,
    UNIQUE_ENTITY_IDENTIFIER_DUNS     VARCHAR2(60) ,
    ENTITY_EFT_INDICATOR              VARCHAR2(40) ,
    CAGE_CODE                         VARCHAR2(20) ,
    DODAAC_CODE                       VARCHAR2(36) ,
    SAM_EXTRACT_CODE                  VARCHAR2(4)  ,
    PURPOSE_OF_REGISTRATION_CODE      VARCHAR2(8)  ,
    INITIAL_REGISTRATION_DATE         DATE         ,
    REGISTRATION_EXPIRATION_DATE      DATE         ,
    SAM_TRD_PARTNER_UPDATED_DATE      DATE         ,
    ACTIVATION_DATE                   DATE         ,
    LEGAL_BUSINESS_NAME               VARCHAR2(480),
    DBA_NAME                          VARCHAR2(480),
    ENTITY_DIVISION_NAME              VARCHAR2(240),
    ENTITY_DIVISION_NUMBER            VARCHAR2(40) ,
    PHYS_ADDR_LINE_1                  VARCHAR2(600),
    PHYS_ADDR_LINE_2                  VARCHAR2(600),
    PHYS_ADDR_CITY                    VARCHAR2(160),
    PHYS_ADDR_PROVINCE_OR_STATE       VARCHAR2(220),
    PHYS_ADDR_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    PHYS_ADDR_ZIP_CODE_PLUS_4         NUMBER       ,
    PHYS_ADDR_COUNTRY_CODE            VARCHAR2(12) ,
    CONGRESSIONAL_DISTRICT            NUMBER       ,
    D_AND_B_OPEN_DATA_FLAG            VARCHAR2(4)  ,
    ENTITY_START_DATE                 DATE         ,
    FISCAL_YEAR_CLOSE_DATE            VARCHAR2(16) ,
    COMPANY_SECURITY_LEVEL            VARCHAR2(8)  ,
    TOP_EMPLOYEE_SECURITY_LEVEL       VARCHAR2(8)  ,
    ENTITY_URL                        VARCHAR2(800),
    ENTITY_STRUCTURE_CODE             VARCHAR2(8)  ,
    STATE_OF_INCORPORATION            VARCHAR2(8)  ,
    COUNTRY_OF_INCORPORATION          VARCHAR2(12) ,
    BUSINESS_TYPE_COUNT               NUMBER       ,
    BUSINESS_TYPES_INFORMATION        CLOB         ,
    AGENCY_BUSINESS_PURPOSE_CODE      VARCHAR2(4)  ,
    PRIMARY_NAICS_CODE                VARCHAR2(24) ,
    NAICS_CODE_COUNT                  NUMBER       ,
    NAICS_CODES_INFORMATION           CLOB         ,
    PSC_CODE_COUNT                    NUMBER       ,
    PSC_CODES_INFORMATION             CLOB         ,
    CREDIT_CARD_USAGE_CODE            VARCHAR2(4)  ,
    CORRESPONDENCE_CODE               VARCHAR2(4)  ,
    MAIL_ADDR_LINE_1                  VARCHAR2(600),
    MAIL_ADDR_LINE_2                  VARCHAR2(600),
    MAIL_ADDR_CITY                    VARCHAR2(160),
    MAIL_ADDR_ZIP_POSTAL_CODE         VARCHAR2(200),
    MAIL_ADDR_ZIP_CODE_PLUS_4         NUMBER       ,
    MAIL_ADDR_COUNTRY                 VARCHAR2(12) ,
    MAIL_ADDR_STATE_OR_PROVINCE       VARCHAR2(220),
    GOV_POC_FIRST_NAME                VARCHAR2(260),
    GOV_POC_MIDDLE_INITIAL            VARCHAR2(12) ,
    GOV_POC_LAST_NAME                 VARCHAR2(260),
    GOV_POC_TITLE                     VARCHAR2(200),
    GOV_POC_ST_ADDR_1                 VARCHAR2(600),
    GOV_POC_ST_ADDR_2                 VARCHAR2(600),
    GOV_POC_CITY                      VARCHAR2(160),
    GOV_POC_ZIP_OR_POSTAL_CODE        VARCHAR2(200),
    GOV_POC_ZIP_CODE_PLUS_4           NUMBER       ,
    GOV_POC_COUNTRY_CODE              VARCHAR2(12) ,
    GOV_POC_STATE_OR_PROVINCE         VARCHAR2(220),
    GOV_POC_US_PHONE                  VARCHAR2(120),
    GOV_POC_US_PHONE_EXT              VARCHAR2(100),
    GOV_POC_NON_US_PHONE              VARCHAR2(120),
    GOV_POC_FAX_US_ONLY               VARCHAR2(120),
    GOV_POC_EMAIL                     VARCHAR2(320),
    ALT_GOV_POC_FIRST_NAME            VARCHAR2(260),
    ALT_GOV_POC_MIDDLE_INITIAL        VARCHAR2(12) ,
    ALT_GOV_POC_LAST_NAME             VARCHAR2(260),
    ALT_GOV_POC_TITLE                 VARCHAR2(200),
    ALT_GOV_POC_ST_ADDR_1             VARCHAR2(600),
    ALT_GOV_POC_ST_ADDR_2             VARCHAR2(600),
    ALT_GOV_POC_CITY                  VARCHAR2(160),
    ALT_GOV_POC_ZIP_POSTAL_CODE       VARCHAR2(200),
    ALT_GOV_POC_ZIP_CODE_PLUS_4       NUMBER       ,
    ALT_GOV_POC_COUNTRY_CODE          VARCHAR2(12) ,
    ALT_GOV_POC_STATE_OR_PROVINCE     VARCHAR2(220),
    ALT_GOV_POC_US_PHONE              VARCHAR2(120),
    ALT_GOV_POC_US_PHONE_EXT          VARCHAR2(100),
    ALT_GOV_POC_NON_US_PHONE          VARCHAR2(120),
    ALT_GOV_POC_FAX_US_ONLY           VARCHAR2(120),
    ALT_GOV_POC_EMAIL                 VARCHAR2(320),
    PAST_PERF_FIRST_NAME              VARCHAR2(260),
    PAST_PERF_MIDDLE_INITIAL          VARCHAR2(12) ,
    PAST_PERF_LAST_NAME               VARCHAR2(260),
    PAST_PERF_TITLE                   VARCHAR2(200),
    PAST_PERF_ST_ADDR_1               VARCHAR2(600),
    PAST_PERF_ST_ADDR_2               VARCHAR2(600),
    PAST_PERF_CITY                    VARCHAR2(160),
    PAST_PERF_ZIP_POSTAL_CODE         VARCHAR2(200),
    PAST_PERF_ZIP_CODE_PLUS_4         NUMBER       ,
    PAST_PERF_COUNTRY_CODE            VARCHAR2(12) ,
    PAST_PERF_STATE_OR_PROVINCE       VARCHAR2(220),
    PAST_PERF_US_PHONE                VARCHAR2(120),
    PAST_PERF_US_PHONE_EXT            VARCHAR2(100),
    PAST_PERF_NON_US_PHONE            VARCHAR2(120),
    PAST_PERF_FAX_US_ONLY             VARCHAR2(120),
    PAST_PERF_EMAIL                   VARCHAR2(320),
    ALT_PAST_FIRST_NAME               VARCHAR2(260),
    ALT_PAST_MIDDLE_INITIAL           VARCHAR2(12) ,
    ALT_PAST_LAST_NAME                VARCHAR2(260),
    ALT_PAST_TITLE                    VARCHAR2(200),
    ALT_PAST_ST_ADDR_1                VARCHAR2(600),
    ALT_PAST_ST_ADDR_2                VARCHAR2(600),
    ALT_PAST_CITY                     VARCHAR2(160),
    ALT_PAST_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    ALT_PAST_ZIP_CODE_PLUS_4          NUMBER       ,
    ALT_PAST_COUNTRY_CODE             VARCHAR2(12) ,
    ALT_PAST_STATE_OR_PROVINCE        VARCHAR2(220),
    ALT_PAST_US_PHONE                 VARCHAR2(120),
    ALT_PAST_US_PHONE_EXT             VARCHAR2(100),
    ALT_PAST_NON_US_PHONE             VARCHAR2(120),
    ALT_PAST_FAX_US_ONLY              VARCHAR2(120),
    ALT_PAST_EMAIL                    VARCHAR2(320),
    E_BIZ_POC_FIRST_NAME              VARCHAR2(260),
    E_BIZ_POC_MIDDLE_INITIAL          VARCHAR2(12) ,
    E_BIZ_POC_LAST_NAME               VARCHAR2(260),
    E_BIZ_POC_TITLE                   VARCHAR2(200),
    E_BIZ_POC_ST_ADDR_1               VARCHAR2(600),
    E_BIZ_POC_ST_ADDR_2               VARCHAR2(600),
    E_BIZ_POC_CITY                    VARCHAR2(160),
    E_BIZ_POC_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    E_BIZ_POC_ZIP_CODE_PLUS_4         NUMBER       ,
    E_BIZ_POC_COUNTRY_CODE            VARCHAR2(12) ,
    E_BIZ_POC_STATE_OR_PROVINCE       VARCHAR2(220),
    E_BIZ_POC_US_PHONE                VARCHAR2(120),
    E_BIZ_POC_US_PHONE_EXT            VARCHAR2(100),
    E_BIZ_POC_NON_US_PHONE            VARCHAR2(120),
    E_BIZ_POC_FAX_US_ONLY             VARCHAR2(120),
    E_BIZ_POC_EMAIL                   VARCHAR2(320),
    ALT_E_BIZ_FIRST_NAME              VARCHAR2(260),
    ALT_E_BIZ_MIDDLE_INITIAL          VARCHAR2(12) ,
    ALT_E_BIZ_LAST_NAME               VARCHAR2(260),
    ALT_E_BIZ_TITLE                   VARCHAR2(200),
    ALT_E_BIZ_ST_ADDR_1               VARCHAR2(600),
    ALT_E_BIZ_ST_ADDR_2               VARCHAR2(600),
    ALT_E_BIZ_CITY                    VARCHAR2(160),
    ALT_E_BIZ_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    ALT_E_BIZ_ZIP_CODE_PLUS_4         NUMBER       ,
    ALT_E_BIZ_COUNTRY_CODE            VARCHAR2(12) ,
    ALT_E_BIZ_STATE_OR_PROVINCE       VARCHAR2(220),
    ALT_E_BIZ_US_PHONE                VARCHAR2(120),
    ALT_E_BIZ_US_PHONE_EXT            VARCHAR2(100),
    ALT_E_BIZ_NON_US_PHONE            VARCHAR2(120),
    ALT_E_BIZ_FAX_US_ONLY             VARCHAR2(120),
    ALT_E_BIZ_EMAIL                   VARCHAR2(320),
    CERT_POC_FIRST_NAME               VARCHAR2(260),
    CERT_POC_MIDDLE_INITIAL           VARCHAR2(12) ,
    CERT_POC_LAST_NAME                VARCHAR2(260),
    CERT_POC_TITLE                    VARCHAR2(200),
    CERT_POC_ST_ADDR_1                VARCHAR2(600),
    CERT_POC_ST_ADDR_2                VARCHAR2(600),
    CERT_POC_CITY                     VARCHAR2(160),
    CERT_POC_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    CERT_POC_ZIP_CODE_PLUS_4          NUMBER       ,
    CERT_POC_COUNTRY_CODE             VARCHAR2(12) ,
    CERT_POC_STATE_OR_PROVINCE        VARCHAR2(220),
    CERT_POC_US_PHONE                 VARCHAR2(120),
    CERT_POC_US_PHONE_EXT             VARCHAR2(100),
    CERT_POC_NON_US_PHONE             VARCHAR2(120),
    CERT_POC_FAX_US_ONLY              VARCHAR2(120),
    CERT_POC_EMAIL                    VARCHAR2(320),
    SOLE_PROP_POC_FIRST_NAME          VARCHAR2(260),
    SOLE_PROP_POC_MIDDLE_INITIAL      VARCHAR2(12) ,
    SOLE_PROP_POC_LAST_NAME           VARCHAR2(260),
    SOLE_PROP_POC_TITLE               VARCHAR2(200),
    SOLE_PROP_POC_US_PHONE            VARCHAR2(120),
    SOLE_PROP_POC_US_PHONE_EXT        VARCHAR2(100),
    SOLE_PROP_POC_NON_US_PHONE        VARCHAR2(120),
    SOLE_PROP_POC_FAX_US_ONLY         VARCHAR2(120),
    SOLE_PROP_POC_EMAIL               VARCHAR2(320),
    IMMED_PARENT_LEGAL_BIZ_NAME       VARCHAR2(600),
    IMMED_PARENT_UEI_SAM              VARCHAR2(48) ,
    IMMED_PARENT_ST_ADDR_1            VARCHAR2(600),
    IMMED_PARENT_ST_ADDR_2            VARCHAR2(600),
    IMMED_PARENT_CITY                 VARCHAR2(160),
    IMMED_PARENT_POSTAL_CODE          VARCHAR2(200),
    IMMED_PARENT_COUNTRY_CODE         VARCHAR2(12) ,
    IMMED_PARENT_STATE_OR_PROVINCE    VARCHAR2(220),
    IMMED_PARENT_PHONE                VARCHAR2(120),
    HQ_PARENT_LEGAL_BIZ_NAME          VARCHAR2(600),
    HQ_PARENT_UEI_SAM                 VARCHAR2(48) ,
    HQ_PARENT_UEI_DUNS                VARCHAR2(60) ,
    HQ_PARENT_ST_ADDR_1               VARCHAR2(600),
    HQ_PARENT_ST_ADDR_2               VARCHAR2(600),
    HQ_PARENT_CITY                    VARCHAR2(160),
    HQ_PARENT_POSTAL_CODE             VARCHAR2(200),
    HQ_PARENT_COUNTRY_CODE            VARCHAR2(12) ,
    HQ_PARENT_STATE_OR_PROVINCE       VARCHAR2(220),
    HQ_PARENT_PHONE                   VARCHAR2(120),
    ULT_DPARENT_LEGAL_BIZ_NAME        VARCHAR2(600),
    ULT_DPARENT_UEI_SAM               VARCHAR2(48) ,
    ULT_DPARENT_UEI_DUNS              VARCHAR2(60) ,
    ULT_DPARENT_ST_ADDR_1             VARCHAR2(600),
    ULT_DPARENT_ST_ADDR_2             VARCHAR2(600),
    ULT_DPARENT_CITY                  VARCHAR2(160),
    ULT_DPARENT_POSTAL_CODE           VARCHAR2(200),
    ULT_DPARENT_COUNTRY_CODE          VARCHAR2(12) ,
    ULT_DPARENT_STATE_OR_PROVINCE     VARCHAR2(220),
    ULT_DPARENT_PHONE                 VARCHAR2(120),
    ULT_PARENT_LEGAL_BIZ_NAME         VARCHAR2(600),
    ULT_PARENT_UEI_SAM                VARCHAR2(48) ,
    ULT_PARENT_UEI_DUNS               VARCHAR2(60) ,
    ULT_PARENT_ST_ADDR_1              VARCHAR2(600),
    ULT_PARENT_ST_ADDR_2              VARCHAR2(600),
    ULT_PARENT_CITY                   VARCHAR2(160),
    ULT_PARENT_POSTAL_CODE            VARCHAR2(200),
    ULT_PARENT_COUNTRY_CODE           VARCHAR2(12) ,
    ULT_PARENT_STATE_OR_PROVINCE      VARCHAR2(220),
    ULT_PARENT_PHONE                  VARCHAR2(120),
    EVS_OUT_OF_BIZ_FLAG               VARCHAR2(4)  ,
    EVS_MONITOR_LAST_UPDATE_DATE      DATE         ,
    EVS_MONITOR_STATUS_FLAG           VARCHAR2(4)  ,
    EVS_MONITOR_LEGAL_BIZ_NAME        VARCHAR2(480),
    EVS_MONITOR_DBA_NAME              VARCHAR2(480),
    EVS_MONITOR_ADDRESS_1             VARCHAR2(600),
    EVS_MONITOR_ADDRESS_2             VARCHAR2(600),
    EVS_MONITOR_CITY                  VARCHAR2(160),
    EVS_MONITOR_POSTAL_CODE           VARCHAR2(200),
    EVS_MONITOR_COUNTRY_CODE          VARCHAR2(12) ,
    EVS_MONITOR_STATE_OR_PROVINCE     VARCHAR2(220),
    PROVIDE_EDI_FLAG                  VARCHAR2(4)  ,
    EDI_VAN_PROVIDER                  VARCHAR2(80) ,
    ISA_QUALIFIER                     VARCHAR2(8)  ,
    ISA_IDENTIFIER                    VARCHAR2(60) ,
    FUNCTIONAL_GROUP_IDENTIFIER       VARCHAR2(60) ,
    REQUEST_820S_FLAG                 VARCHAR2(4)  ,
    EDI_POC_FIRST_NAME                VARCHAR2(260),
    EDI_POC_MIDDLE_INITIAL            VARCHAR2(12) ,
    EDI_POC_LAST_NAME                 VARCHAR2(260),
    EDI_POC_TITLE                     VARCHAR2(200),
    EDI_POC_US_PHONE                  VARCHAR2(120),
    EDI_POC_US_PHONE_EXT              VARCHAR2(100),
    EDI_POC_NON_US_PHONE              VARCHAR2(120),
    EDI_POC_FAX_US_ONLY               VARCHAR2(120),
    EDI_POC_EMAIL                     VARCHAR2(320),
    TAX_IDENTIFIER_TYPE_CODE          VARCHAR2(4)  ,
    TAX_IDENTIFIER_NUMBER             VARCHAR2(100),
    AVERAGE_NUMBER_OF_EMPLOYEES       VARCHAR2(100),
    AVERAGE_ANNUAL_REVENUE            VARCHAR2(100),
    FINANCIAL_INSTITUTE_NAME          VARCHAR2(200),
    ENTITY_ACCOUNT_NUMBER             VARCHAR2(120),
    ABA_ROUTING_ID                    NUMBER       ,
    ACCOUNT_TYPE_CODE                 VARCHAR2(4)  ,
    LOCKBOX_NUMBER                    VARCHAR2(80) ,
    AUTHORIZATION_DATE                DATE         ,
    EFT_WAIVER_FLAG                   VARCHAR2(4)  ,
    ACH_US_PHONE                      VARCHAR2(120),
    ACH_NON_US_PHONE                  VARCHAR2(120),
    ACH_FAX                           VARCHAR2(120),
    ACH_EMAIL                         VARCHAR2(320),
    REMITTANCE_NAME                   VARCHAR2(480),
    REMITTANCE_ADDRESS_LINE_1         VARCHAR2(600),
    REMITTANCE_ADDRESS_LINE_2         VARCHAR2(600),
    REMITTANCE_CITY                   VARCHAR2(160),
    REMITTANCE_STATE_OR_PROVINCE      VARCHAR2(220),
    REMITTANCE_ZIP_OR_POSTAL_CODE     VARCHAR2(200),
    REMITTANCE_ZIP_CODE_PLUS_4        NUMBER       ,
    REMITTANCE_COUNTRY_CODE           VARCHAR2(12) ,
    AR_POC_FIRST_NAME                 VARCHAR2(260),
    AR_POC_MIDDLE_INITIAL             VARCHAR2(12) ,
    AR_POC_LAST_NAME                  VARCHAR2(260),
    AR_POC_TITLE                      VARCHAR2(200),
    AR_POC_US_PHONE                   VARCHAR2(120),
    AR_POC_US_PHONE_EXT               VARCHAR2(100),
    AR_POC_NON_US_PHONE               VARCHAR2(120),
    AR_POC_FAX_US_ONLY                VARCHAR2(120),
    AR_POC_EMAIL                      VARCHAR2(320),
    AP_POC_FIRST_NAME                 VARCHAR2(260),
    AP_POC_MIDDLE_INITIAL             VARCHAR2(12) ,
    AP_POC_LAST_NAME                  VARCHAR2(260),
    AP_POC_TITLE                      VARCHAR2(200),
    AP_POC_ST_ADDR_1                  VARCHAR2(600),
    AP_POC_ST_ADDR_2                  VARCHAR2(600),
    AP_POC_CITY                       VARCHAR2(160),
    AP_POC_ZIP_OR_POSTAL_CODE         VARCHAR2(200),
    AP_POC_ZIP_CODE_PLUS_4            NUMBER       ,
    AP_POC_COUNTRY_CODE               VARCHAR2(12) ,
    AP_POC_STATE_OR_PROVINCE          VARCHAR2(220),
    AP_POC_US_PHONE                   VARCHAR2(120),
    AP_POC_US_PHONE_EXT               VARCHAR2(100),
    AP_POC_NON_US_PHONE               VARCHAR2(120),
    AP_POC_FAX_US_ONLY                VARCHAR2(120),
    AP_POC_EMAIL                      VARCHAR2(320),
    MPI_NUMBER                        VARCHAR2(36) ,
    NAICS_EXCEPTION_COUNT             NUMBER       ,
    NAICS_EXCEPTIONS_INFORMATION      CLOB         ,
    DEBT_SUBJECT_TO_OFFSET_FLAG       VARCHAR2(4)  ,
    EXCLUSION_STATUS_CODE             VARCHAR2(4)  ,
    SBA_BIZ_TYPES_COUNT               NUMBER       ,
    SBA_BIZ_TYPES_INFORMATION         CLOB         ,
    SAM_NUMERIC_TYPES_COUNT           NUMBER       ,
    SAM_NUMERIC_TYPES_INFORMATION     CLOB         ,
    NO_PUBLIC_DISPLAY_CODE            VARCHAR2(16) ,
    DISASTER_RESPONSE_COUNT           NUMBER       ,
    DISASTER_RESPONSES_INFORMATION    CLOB         ,
    ANNUAL_IGT_REVENUE                VARCHAR2(100),
    AGENCY_LOCATION_CODE              VARCHAR2(32) ,
    DISBURSING_OFFICE_SYMBOL          VARCHAR2(20) ,
    MERCHANT_ID_1                     VARCHAR2(520),
    MERCHANT_ID_2                     VARCHAR2(520),
    ACCOUNTING_STATION                VARCHAR2(24) ,
    SOURCE_ENTITY_CODE                VARCHAR2(28) ,
    DEPARTMENT_CODE                   VARCHAR2(8)  ,
    HIERARCHY_DEPARTMENT_CODE         VARCHAR2(16) ,
    HIERARCHY_DEPARTMENT_NAME         VARCHAR2(600),
    HIERARCHY_AGENCY_CODE             VARCHAR2(16) ,
    HIERARCHY_AGENCY_NAME             VARCHAR2(600),
    HIERARCHY_OFFICE_CODE             VARCHAR2(24) ,
    ELIM_POC_FIRST_NAME               VARCHAR2(260),
    ELIM_POC_MIDDLE_INITIAL           VARCHAR2(12) ,
    ELIM_POC_LAST_NAME                VARCHAR2(260),
    ELIM_POC_TITLE                    VARCHAR2(200),
    ELIM_POC_ST_ADDR_1                VARCHAR2(600),
    ELIM_POC_ST_ADDR_2                VARCHAR2(600),
    ELIM_POC_CITY                     VARCHAR2(160),
    ELIM_POC_ZIP_OR_POSTAL_CODE       VARCHAR2(200),
    ELIM_POC_ZIP_CODE_PLUS_4          NUMBER       ,
    ELIM_POC_COUNTRY_CODE             VARCHAR2(12) ,
    ELIM_POC_STATE_OR_PROVINCE        VARCHAR2(220),
    ELIM_POC_US_PHONE                 VARCHAR2(120),
    ELIM_POC_US_PHONE_EXT             VARCHAR2(100),
    ELIM_POC_NON_US_PHONE             VARCHAR2(120),
    ELIM_POC_FAX_US_ONLY              VARCHAR2(120),
    ELIM_POC_EMAIL                    VARCHAR2(320),
    SALES_POC_FIRST_NAME              VARCHAR2(260),
    SALES_POC_MIDDLE_INITIAL          VARCHAR2(12) ,
    SALES_POC_LAST_NAME               VARCHAR2(260),
    SALES_POC_TITLE                   VARCHAR2(200),
    SALES_POC_ST_ADDR_1               VARCHAR2(600),
    SALES_POC_ST_ADDR_2               VARCHAR2(600),
    SALES_POC_CITY                    VARCHAR2(160),
    SALES_POC_ZIP_OR_POSTAL_CODE      VARCHAR2(200),
    SALES_POC_ZIP_CODE_PLUS_4         NUMBER       ,
    SALES_POC_COUNTRY_CODE            VARCHAR2(12) ,
    SALES_POC_STATE_OR_PROVINCE       VARCHAR2(220),
    SALES_POC_US_PHONE                VARCHAR2(120),
    SALES_POC_US_PHONE_EXT            VARCHAR2(100),
    SALES_POC_NON_US_PHONE            VARCHAR2(120),
    SALES_POC_FAX_US_ONLY             VARCHAR2(120),
    SALES_POC_EMAIL                   VARCHAR2(320),
    TAXPAYER_NAME                     VARCHAR2(480),
    SAM_REC_STATUS                    VARCHAR2(120)    NOT NULL,
    LOAD_REQUEST_ID                   NUMBER       ,
    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),
    ATTRIBUTE_NUMBER1                 NUMBER       ,
    ATTRIBUTE_NUMBER2                 NUMBER       ,
    ATTRIBUTE_NUMBER3                 NUMBER       ,
    ATTRIBUTE_NUMBER4                 NUMBER       ,
    ATTRIBUTE_NUMBER5                 NUMBER       ,
    ATTRIBUTE_DATE1                   DATE         ,
    ATTRIBUTE_DATE2                   DATE         ,
    ATTRIBUTE_DATE3                   DATE         ,
    ATTRIBUTE_DATE4                   DATE         ,
    ATTRIBUTE_DATE5                   DATE         ,
    ATTRIBUTE_CATEGORY                VARCHAR2(600),
    CREATION_DATE                     TIMESTAMP(6) ,
    CREATED_BY                        VARCHAR2(256),
    LAST_UPDATE_DATE                  TIMESTAMP(6) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128),
    LAST_UPDATED_BY                   VARCHAR2(256),
    CONSTRAINT pk_fv_sam_trading_partner_int PRIMARY KEY (UNIQUE_ENTITY_IDENTIFIER_SAM, ENTITY_EFT_INDICATOR, LOAD_REQUEST_ID, UNIQUE_ENTITY_IDENTIFIER_SAM, ENTITY_EFT_INDICATOR, LOAD_REQUEST_ID)
);
