CREATE TABLE ce_recon_matching_rules (
    RECON_MATCHING_RULE_ID     NUMBER(18, 0) ,
    MATCHING_RULE_NAME         VARCHAR2(400)     NOT NULL,
    DESCRIPTION                VARCHAR2(1440),
    ACTIVE_FLAG                VARCHAR2(4)   ,
    AP_SOURCE_FLAG             VARCHAR2(4)   ,
    AR_SOURCE_FLAG             VARCHAR2(4)   ,
    CE_SOURCE_FLAG             VARCHAR2(4)   ,
    EXT_SOURCE_FLAG            VARCHAR2(4)   ,
    PAY_SOURCE_FLAG            VARCHAR2(4)   ,
    MATCH_TYPE                 VARCHAR2(120)     NOT NULL,
    JOIN_CONDITION             VARCHAR2(4000),
    STMT_GROUPBY               VARCHAR2(4000),
    TRX_GROUPBY                VARCHAR2(4000),
    AMOUNT_MATCH_FLAG          VARCHAR2(4)       NOT NULL,
    DATE_MATCH_FLAG            VARCHAR2(4)       NOT NULL,
    TYPE_MATCH_FLAG            VARCHAR2(4)       NOT NULL,
    REFERENCE_ID_MATCH_FLAG    VARCHAR2(4)       NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    GL_SOURCE_FLAG             VARCHAR2(4)   ,
    SEED_DATA_SOURCE           VARCHAR2(2048),
    ORA_SEED_SET1              VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2              VARCHAR2(4)       NOT NULL,
    RECON_MATCHING_RULE_ID     NUMBER(18, 0) ,
    MATCHING_RULE_NAME         VARCHAR2(400)     NOT NULL,
    DESCRIPTION                VARCHAR2(1440),
    ACTIVE_FLAG                VARCHAR2(4)   ,
    AP_SOURCE_FLAG             VARCHAR2(4)   ,
    AR_SOURCE_FLAG             VARCHAR2(4)   ,
    CE_SOURCE_FLAG             VARCHAR2(4)   ,
    EXT_SOURCE_FLAG            VARCHAR2(4)   ,
    PAY_SOURCE_FLAG            VARCHAR2(4)   ,
    MATCH_TYPE                 VARCHAR2(120)     NOT NULL,
    JOIN_CONDITION             VARCHAR2(4000),
    STMT_GROUPBY               VARCHAR2(4000),
    TRX_GROUPBY                VARCHAR2(4000),
    AMOUNT_MATCH_FLAG          VARCHAR2(4)       NOT NULL,
    DATE_MATCH_FLAG            VARCHAR2(4)       NOT NULL,
    TYPE_MATCH_FLAG            VARCHAR2(4)       NOT NULL,
    REFERENCE_ID_MATCH_FLAG    VARCHAR2(4)       NOT NULL,
    LAST_UPDATE_DATE           TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)      NOT NULL,
    CREATED_BY                 VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    GL_SOURCE_FLAG             VARCHAR2(4)   ,
    SEED_DATA_SOURCE           VARCHAR2(2048),
    ORA_SEED_SET1              VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2              VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_ce_recon_matching_rules PRIMARY KEY (RECON_MATCHING_RULE_ID, RECON_MATCHING_RULE_ID)
);
