CREATE TABLE cmk_service_providers_b] (
    SERVICE_PROVIDER_ID          NUMBER(18, 0)     NOT NULL,
    SERVICE_PROVIDER_NAME        VARCHAR2(1024)    NOT NULL,
    EXT_PARTNER_ID               VARCHAR2(400) ,
    EXT_PARTNER_ID_TYPE          VARCHAR2(400) ,
    FROM_PARTNER_ID_TAG          VARCHAR2(2048),
    FROM_PARTNER_ID_TYPE_TAG     VARCHAR2(2048),
    TO_PARTNER_ID_TAG            VARCHAR2(2048),
    TO_PARTNER_ID_TYPE_TAG       VARCHAR2(2048),
    EXT_MSG_TYPE_TAG             VARCHAR2(2048),
    EXT_MSG_VERSION_TAG          VARCHAR2(2048),
    EXT_MSG_STANDARD_TAG         VARCHAR2(2048),
    SERVICE_PROVIDER_ID_TAG      VARCHAR2(2048),
    CREATED_BY                   VARCHAR2(256)     NOT NULL,
    CREATION_DATE                TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    MODULE_ID                    VARCHAR2(128) ,
    SEED_DATA_SOURCE             VARCHAR2(2048),
    OBN_ID                       VARCHAR2(400) ,
    DEL_STATUS_UPDATE_ENABLED    VARCHAR2(4)   ,
    MSG_EXCHANGE_STANDARD        VARCHAR2(400) ,
    ORA_SEED_SET1                VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                VARCHAR2(4)       NOT NULL,
    USER_DEFINED                 VARCHAR2(4)   ,
    PREDEFINED_ENDPT_IND         VARCHAR2(4)   ,
    SP_EXT_PARTNER_ID            VARCHAR2(1024),
    SP_CATEGORY                  VARCHAR2(1024),
    ATTCH_PROCESS_MTHD           VARCHAR2(400) ,
    CONNECTION_TYPE              VARCHAR2(400) ,
    ELECTRONIC_INVOICE_BU        VARCHAR2(2048),
    PTNR_SETUP_REQD_FLAG         VARCHAR2(4)   ,
    PROVIDER_TYPE                VARCHAR2(120)     NOT NULL
);
