CREATE TABLE fa_mc_conversion_rates (
    SET_OF_BOOKS_ID          NUMBER(18, 0),
    BOOK_TYPE_CODE           VARCHAR2(120),
    ASSET_ID                 NUMBER(18, 0),
    STATUS                   VARCHAR2(8)      NOT NULL,
    COST                     NUMBER       ,
    PRIMARY_CUR_COST         NUMBER           NOT NULL,
    EXCHANGE_RATE            NUMBER       ,
    CONVERSION_BASIS         VARCHAR2(4)  ,
    LAST_PERIOD_COUNTER      NUMBER(18, 0)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    LEASE_ID                 NUMBER(18, 0),
    SET_OF_BOOKS_ID          NUMBER(18, 0),
    BOOK_TYPE_CODE           VARCHAR2(120),
    ASSET_ID                 NUMBER(18, 0),
    STATUS                   VARCHAR2(8)      NOT NULL,
    COST                     NUMBER       ,
    PRIMARY_CUR_COST         NUMBER           NOT NULL,
    EXCHANGE_RATE            NUMBER       ,
    CONVERSION_BASIS         VARCHAR2(4)  ,
    LAST_PERIOD_COUNTER      NUMBER(18, 0)    NOT NULL,
    CREATION_DATE            TIMESTAMP(6)     NOT NULL,
    CREATED_BY               VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE         TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY          VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_LOGIN        VARCHAR2(128),
    OBJECT_VERSION_NUMBER    NUMBER(9, 0)     NOT NULL,
    LEASE_ID                 NUMBER(18, 0),
    CONSTRAINT pk_fa_mc_conversion_rates PRIMARY KEY (SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID, SET_OF_BOOKS_ID, BOOK_TYPE_CODE, ASSET_ID)
);
