CREATE TABLE exm_exch_rate_options (
    EXCHANGE_RATE_ID           NUMBER(18, 0),
    ORG_ID                     NUMBER(18, 0)    NOT NULL,
    DFLT_EXCHANGE_RATE_FLAG    VARCHAR2(4)  ,
    EXCHANGE_RATE_TYPE         VARCHAR2(120)    NOT NULL,
    WARNING_TOLERANCE          NUMBER       ,
    ERROR_TOLERANCE            NUMBER       ,
    DISP_WARNING_TO_USER       VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    EXCHANGE_RATE_ID           NUMBER(18, 0),
    ORG_ID                     NUMBER(18, 0)    NOT NULL,
    DFLT_EXCHANGE_RATE_FLAG    VARCHAR2(4)  ,
    EXCHANGE_RATE_TYPE         VARCHAR2(120)    NOT NULL,
    WARNING_TOLERANCE          NUMBER       ,
    ERROR_TOLERANCE            NUMBER       ,
    DISP_WARNING_TO_USER       VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)     NOT NULL,
    CREATION_DATE              TIMESTAMP(6)     NOT NULL,
    CREATED_BY                 VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN          VARCHAR2(128),
    LAST_UPDATE_DATE           TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY            VARCHAR2(256)    NOT NULL,
    CONSTRAINT pk_exm_exch_rate_options PRIMARY KEY (EXCHANGE_RATE_ID, EXCHANGE_RATE_ID)
);
