CREATE TABLE fun_av_metadata_measures (
    MEASURE_ID                 NUMBER(18, 0),
    MEASURE_NAME               VARCHAR2(600)    NOT NULL,
    MEASURE_CODE               VARCHAR2(120)    NOT NULL,
    AMOUNT_TYPE_CODE           VARCHAR2(120)    NOT NULL,
    ACCOUNTING_PERIOD_LEVEL    NUMBER(1, 0)     NOT NULL,
    SCENARIO_CODE              VARCHAR2(120)    NOT NULL,
    ALLOCATION_DEFAULT_FLAG    CHAR(4)          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,
    MEASURE_ID                 NUMBER(18, 0),
    MEASURE_NAME               VARCHAR2(600)    NOT NULL,
    MEASURE_CODE               VARCHAR2(120)    NOT NULL,
    AMOUNT_TYPE_CODE           VARCHAR2(120)    NOT NULL,
    ACCOUNTING_PERIOD_LEVEL    NUMBER(1, 0)     NOT NULL,
    SCENARIO_CODE              VARCHAR2(120)    NOT NULL,
    ALLOCATION_DEFAULT_FLAG    CHAR(4)          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,
    CONSTRAINT pk_fun_av_metadata_measures PRIMARY KEY (MEASURE_ID, MEASURE_ID)
);
