CREATE TABLE fa_mc_deprn_detail (
    DISTRIBUTION_ID                   NUMBER(18, 0),
    BOOK_TYPE_CODE                    VARCHAR2(120),
    ASSET_ID                          NUMBER(18, 0)    NOT NULL,
    PERIOD_COUNTER                    NUMBER(18, 0),
    SET_OF_BOOKS_ID                   NUMBER(18, 0),
    DEPRN_SOURCE_CODE                 VARCHAR2(4)      NOT NULL,
    DEPRN_RUN_DATE                    DATE             NOT NULL,
    DEPRN_AMOUNT                      NUMBER           NOT NULL,
    YTD_DEPRN                         NUMBER           NOT NULL,
    DEPRN_RESERVE                     NUMBER           NOT NULL,
    ADDITION_COST_TO_CLEAR            NUMBER       ,
    COST                              NUMBER       ,
    DEPRN_ADJUSTMENT_AMOUNT           NUMBER       ,
    REVAL_AMORTIZATION                NUMBER       ,
    REVAL_DEPRN_EXPENSE               NUMBER       ,
    REVAL_RESERVE                     NUMBER       ,
    YTD_REVAL_DEPRN_EXPENSE           NUMBER       ,
    SOURCE_DEPRN_AMOUNT               NUMBER       ,
    SOURCE_YTD_DEPRN                  NUMBER       ,
    SOURCE_DEPRN_RESERVE              NUMBER       ,
    SOURCE_ADDITION_COST_TO_CLEAR     NUMBER       ,
    SOURCE_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    SOURCE_REVAL_AMORTIZATION         NUMBER       ,
    SOURCE_REVAL_DEPRN_EXPENSE        NUMBER       ,
    SOURCE_REVAL_RESERVE              NUMBER       ,
    SOURCE_YTD_REVAL_DEPRN_EXPENSE    NUMBER       ,
    CONVERTED_FLAG                    VARCHAR2(4)      NOT NULL,
    BONUS_DEPRN_AMOUNT                NUMBER       ,
    BONUS_YTD_DEPRN                   NUMBER       ,
    BONUS_DEPRN_RESERVE               NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT     NUMBER       ,
    EVENT_ID                          NUMBER(18, 0),
    CAPITAL_ADJUSTMENT                NUMBER       ,
    GENERAL_FUND                      NUMBER       ,
    IMPAIRMENT_AMOUNT                 NUMBER       ,
    IMPAIRMENT_RESERVE                NUMBER       ,
    YTD_IMPAIRMENT                    NUMBER       ,
    DEPRN_RUN_ID                      NUMBER(18, 0),
    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,
    ACCELERATED_DEPRN_AMOUNT          NUMBER       ,
    ACCELERATED_DEPRN_RESERVE         NUMBER       ,
    ACCELERATED_YTD_DEPRN             NUMBER       ,
    ACC_DEPRN_ADJUSTMENT_AMOUNT       NUMBER       ,
    REVAL_AMORT_BALANCE               NUMBER       ,
    YTD_REVAL_AMORTIZATION            NUMBER       ,
    REVAL_AMORTIZATION_ADJUSTMENT     NUMBER       ,
    BACKLOG_DEPRN_RESERVE             NUMBER       ,
    YTD_BACKLOG_DEPRN                 NUMBER       ,
    ANNUITY_INTEREST_AMOUNT           NUMBER       ,
    YTD_ANNUITY_INTEREST              NUMBER       ,
    LTD_ANNUITY_INTEREST              NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT       NUMBER       ,
    DISTRIBUTION_ID                   NUMBER(18, 0),
    BOOK_TYPE_CODE                    VARCHAR2(120),
    ASSET_ID                          NUMBER(18, 0)    NOT NULL,
    PERIOD_COUNTER                    NUMBER(18, 0),
    SET_OF_BOOKS_ID                   NUMBER(18, 0),
    DEPRN_SOURCE_CODE                 VARCHAR2(4)      NOT NULL,
    DEPRN_RUN_DATE                    DATE             NOT NULL,
    DEPRN_AMOUNT                      NUMBER           NOT NULL,
    YTD_DEPRN                         NUMBER           NOT NULL,
    DEPRN_RESERVE                     NUMBER           NOT NULL,
    ADDITION_COST_TO_CLEAR            NUMBER       ,
    COST                              NUMBER       ,
    DEPRN_ADJUSTMENT_AMOUNT           NUMBER       ,
    REVAL_AMORTIZATION                NUMBER       ,
    REVAL_DEPRN_EXPENSE               NUMBER       ,
    REVAL_RESERVE                     NUMBER       ,
    YTD_REVAL_DEPRN_EXPENSE           NUMBER       ,
    SOURCE_DEPRN_AMOUNT               NUMBER       ,
    SOURCE_YTD_DEPRN                  NUMBER       ,
    SOURCE_DEPRN_RESERVE              NUMBER       ,
    SOURCE_ADDITION_COST_TO_CLEAR     NUMBER       ,
    SOURCE_DEPRN_ADJUSTMENT_AMOUNT    NUMBER       ,
    SOURCE_REVAL_AMORTIZATION         NUMBER       ,
    SOURCE_REVAL_DEPRN_EXPENSE        NUMBER       ,
    SOURCE_REVAL_RESERVE              NUMBER       ,
    SOURCE_YTD_REVAL_DEPRN_EXPENSE    NUMBER       ,
    CONVERTED_FLAG                    VARCHAR2(4)      NOT NULL,
    BONUS_DEPRN_AMOUNT                NUMBER       ,
    BONUS_YTD_DEPRN                   NUMBER       ,
    BONUS_DEPRN_RESERVE               NUMBER       ,
    BONUS_DEPRN_ADJUSTMENT_AMOUNT     NUMBER       ,
    EVENT_ID                          NUMBER(18, 0),
    CAPITAL_ADJUSTMENT                NUMBER       ,
    GENERAL_FUND                      NUMBER       ,
    IMPAIRMENT_AMOUNT                 NUMBER       ,
    IMPAIRMENT_RESERVE                NUMBER       ,
    YTD_IMPAIRMENT                    NUMBER       ,
    DEPRN_RUN_ID                      NUMBER(18, 0),
    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,
    ACCELERATED_DEPRN_AMOUNT          NUMBER       ,
    ACCELERATED_DEPRN_RESERVE         NUMBER       ,
    ACCELERATED_YTD_DEPRN             NUMBER       ,
    ACC_DEPRN_ADJUSTMENT_AMOUNT       NUMBER       ,
    REVAL_AMORT_BALANCE               NUMBER       ,
    YTD_REVAL_AMORTIZATION            NUMBER       ,
    REVAL_AMORTIZATION_ADJUSTMENT     NUMBER       ,
    BACKLOG_DEPRN_RESERVE             NUMBER       ,
    YTD_BACKLOG_DEPRN                 NUMBER       ,
    ANNUITY_INTEREST_AMOUNT           NUMBER       ,
    YTD_ANNUITY_INTEREST              NUMBER       ,
    LTD_ANNUITY_INTEREST              NUMBER       ,
    ANNUITY_INTEREST_ADJ_AMOUNT       NUMBER       ,
    CONSTRAINT pk_fa_mc_deprn_detail PRIMARY KEY (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, SET_OF_BOOKS_ID, DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER, SET_OF_BOOKS_ID)
);
