CREATE TABLE cmk_external_msg_types_b] (
    EXT_MESSAGE_TYPE_ID           NUMBER(18, 0)     NOT NULL,
    EXT_MESSAGE_TYPE_NAME         VARCHAR2(1024)    NOT NULL,
    MESSAGE_TYPE                  VARCHAR2(400)     NOT NULL,
    VERSION                       VARCHAR2(400)     NOT NULL,
    STANDARD                      VARCHAR2(400)     NOT NULL,
    DOCUMENT_SUBTYPE              VARCHAR2(2048),
    DOCUMENT_TYPE                 VARCHAR2(1024)    NOT NULL,
    VALIDATION_PAYLOAD            CLOB          ,
    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) ,
    CONFIGURABLE_FLAG             VARCHAR2(400) ,
    SEED_DATA_SOURCE              VARCHAR2(2048),
    IN_IDENTIFICATION_XPATH       VARCHAR2(4000),
    MESSAGE_IDENTIFIER_XPATH      VARCHAR2(4000),
    TP_IDENTIFIER_XPATH           VARCHAR2(4000),
    TP_TYPE_IDENTIFIER_XPATH      VARCHAR2(4000),
    OBJECT_XPATH                  VARCHAR2(4000),
    OBN_DOC_TYPE_MAP              VARCHAR2(1024),
    PO_LINE_XPATH                 VARCHAR2(4000),
    ORA_SEED_SET1                 VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                 VARCHAR2(4)       NOT NULL,
    REFERENCE_OBJECT_KEY_XPATH    VARCHAR2(4000),
    USER_DEFINED                  VARCHAR2(4)       NOT NULL
);
