CREATE TABLE fa_deprn_override (
    DEPRN_OVERRIDE_ID           NUMBER(18, 0) ,
    BOOK_TYPE_CODE              VARCHAR2(120)     NOT NULL,
    ASSET_ID                    NUMBER(18, 0)     NOT NULL,
    PERIOD_NAME                 VARCHAR2(60)      NOT NULL,
    DEPRN_AMOUNT                NUMBER        ,
    BONUS_DEPRN_AMOUNT          NUMBER        ,
    SUBTRACTION_FLAG            VARCHAR2(4)   ,
    USED_BY                     VARCHAR2(60)      NOT NULL,
    STATUS                      VARCHAR2(60)  ,
    TRANSACTION_HEADER_ID       NUMBER(18, 0) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    SUBTRACT_YTD_FLAG           VARCHAR2(4)   ,
    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,
    COMMENTS                    VARCHAR2(960) ,
    PRIOR_STATUS                VARCHAR2(60)  ,
    ERROR_MSG                   VARCHAR2(4000),
    PRIOR_DEPRN_AMOUNT          NUMBER        ,
    PRIOR_BONUS_DEPRN_AMOUNT    NUMBER        ,
    DEPRN_OVERRIDE_ID           NUMBER(18, 0) ,
    BOOK_TYPE_CODE              VARCHAR2(120)     NOT NULL,
    ASSET_ID                    NUMBER(18, 0)     NOT NULL,
    PERIOD_NAME                 VARCHAR2(60)      NOT NULL,
    DEPRN_AMOUNT                NUMBER        ,
    BONUS_DEPRN_AMOUNT          NUMBER        ,
    SUBTRACTION_FLAG            VARCHAR2(4)   ,
    USED_BY                     VARCHAR2(60)      NOT NULL,
    STATUS                      VARCHAR2(60)  ,
    TRANSACTION_HEADER_ID       NUMBER(18, 0) ,
    REQUEST_ID                  NUMBER(18, 0) ,
    SUBTRACT_YTD_FLAG           VARCHAR2(4)   ,
    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,
    COMMENTS                    VARCHAR2(960) ,
    PRIOR_STATUS                VARCHAR2(60)  ,
    ERROR_MSG                   VARCHAR2(4000),
    PRIOR_DEPRN_AMOUNT          NUMBER        ,
    PRIOR_BONUS_DEPRN_AMOUNT    NUMBER        ,
    CONSTRAINT pk_fa_deprn_override PRIMARY KEY (DEPRN_OVERRIDE_ID, DEPRN_OVERRIDE_ID)
);
