CREATE TABLE fa_category_books_ (
    LEASE_RATE_GAIN_LOSS_ACCT_CCID    NUMBER(18, 0) ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    ASSET_COST_ACCOUNT_CCID           NUMBER(18, 0) ,
    ASSET_CLEARING_ACCOUNT_CCID       NUMBER(18, 0) ,
    WIP_COST_ACCOUNT_CCID             NUMBER(18, 0) ,
    WIP_CLEARING_ACCOUNT_CCID         NUMBER(18, 0) ,
    DEPRN_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    RESERVE_ACCOUNT_CCID              NUMBER(18, 0) ,
    BONUS_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    BONUS_RESERVE_ACCT_CCID           NUMBER        ,
    REVAL_AMORT_ACCOUNT_CCID          NUMBER(18, 0) ,
    REVAL_RESERVE_ACCOUNT_CCID        NUMBER(18, 0) ,
    UNPLAN_EXPENSE_ACCOUNT_CCID       NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)  ,
    CREATED_BY                        VARCHAR2(256) ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATED_BY                   VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)  ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE           VARCHAR2(120) ,
    ALT_COST_ACCOUNT_CCID             NUMBER(18, 0) ,
    WRITE_OFF_ACCOUNT_CCID            NUMBER(18, 0) ,
    IMPAIR_EXPENSE_ACCOUNT_CCID       NUMBER(18, 0) ,
    IMPAIR_RESERVE_ACCOUNT_CCID       NUMBER(18, 0) ,
    CAPITAL_ADJ_ACCOUNT_CCID          NUMBER(18, 0) ,
    GENERAL_FUND_ACCOUNT_CCID         NUMBER(18, 0) ,
    CATEGORY_BOOK_ID                  NUMBER(18, 0) ,
    GLOBAL_ATTRIBUTE1                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_CATEGORY         VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE_NUMBER1          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5          NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1            DATE          ,
    GLOBAL_ATTRIBUTE_DATE2            DATE          ,
    GLOBAL_ATTRIBUTE_DATE3            DATE          ,
    GLOBAL_ATTRIBUTE_DATE4            DATE          ,
    GLOBAL_ATTRIBUTE_DATE5            DATE          ,
    DEFAULT_EXPENSE_CCID_FLAG         VARCHAR2(4)   ,
    REVAL_LOSS_ACCOUNT_CCID           NUMBER(18, 0) ,
    COST_WRITE_OFF_ACCOUNT_CCID       NUMBER(18, 0) ,
    LEASE_LIABILITY_ACCOUNT_CCID      NUMBER(18, 0) ,
    LEASE_INT_EXPENSE_ACCOUNT_CCID    NUMBER(18, 0) ,
    LEASE_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    LEASE_GAIN_LOSS_ACCOUNT_CCID      NUMBER(18, 0) ,
    LEASE_CLEARING_ACCOUNT_CCID       NUMBER(18, 0) ,
    REVALUED_COST_ACCOUNT_CCID        NUMBER(18, 0) ,
    BACKLOG_DEPRN_RSV_ACCT_CCID       NUMBER(18, 0) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    CATEGORY_ID                       NUMBER(18, 0) ,
    ANNUITY_INT_EXP_ACCOUNT_CCID      NUMBER(18, 0) ,
    ANNUITY_INT_REV_ACCOUNT_CCID      NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_                VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_             VARCHAR2(4000),
    AUDIT_IMPERSONATOR_               VARCHAR2(256) ,
    SUPPRESS_MASSADD_AUTOPOST_FLAG    VARCHAR2(4)   ,
    CATEGORY_ID                       NUMBER(18, 0) ,
    LEASE_RATE_GAIN_LOSS_ACCT_CCID    NUMBER(18, 0) ,
    BOOK_TYPE_CODE                    VARCHAR2(120) ,
    ASSET_COST_ACCOUNT_CCID           NUMBER(18, 0) ,
    ASSET_CLEARING_ACCOUNT_CCID       NUMBER(18, 0) ,
    WIP_COST_ACCOUNT_CCID             NUMBER(18, 0) ,
    WIP_CLEARING_ACCOUNT_CCID         NUMBER(18, 0) ,
    DEPRN_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    RESERVE_ACCOUNT_CCID              NUMBER(18, 0) ,
    BONUS_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    BONUS_RESERVE_ACCT_CCID           NUMBER        ,
    REVAL_AMORT_ACCOUNT_CCID          NUMBER(18, 0) ,
    REVAL_RESERVE_ACCOUNT_CCID        NUMBER(18, 0) ,
    UNPLAN_EXPENSE_ACCOUNT_CCID       NUMBER(18, 0) ,
    CREATION_DATE                     TIMESTAMP(6)  ,
    CREATED_BY                        VARCHAR2(256) ,
    LAST_UPDATE_DATE                  TIMESTAMP(6)  ,
    LAST_UPDATED_BY                   VARCHAR2(256) ,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    OBJECT_VERSION_NUMBER             NUMBER(9, 0)  ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    ATTRIBUTE_CATEGORY_CODE           VARCHAR2(120) ,
    ALT_COST_ACCOUNT_CCID             NUMBER(18, 0) ,
    WRITE_OFF_ACCOUNT_CCID            NUMBER(18, 0) ,
    IMPAIR_EXPENSE_ACCOUNT_CCID       NUMBER(18, 0) ,
    IMPAIR_RESERVE_ACCOUNT_CCID       NUMBER(18, 0) ,
    CAPITAL_ADJ_ACCOUNT_CCID          NUMBER(18, 0) ,
    GENERAL_FUND_ACCOUNT_CCID         NUMBER(18, 0) ,
    CATEGORY_BOOK_ID                  NUMBER(18, 0) ,
    GLOBAL_ATTRIBUTE1                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE2                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE3                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE4                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE5                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE6                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE7                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE8                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE9                 VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE10                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE11                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE12                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE13                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE14                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE15                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE16                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE17                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE18                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE19                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE20                VARCHAR2(600) ,
    GLOBAL_ATTRIBUTE_CATEGORY         VARCHAR2(120) ,
    GLOBAL_ATTRIBUTE_NUMBER1          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER2          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER3          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER4          NUMBER        ,
    GLOBAL_ATTRIBUTE_NUMBER5          NUMBER        ,
    GLOBAL_ATTRIBUTE_DATE1            DATE          ,
    GLOBAL_ATTRIBUTE_DATE2            DATE          ,
    GLOBAL_ATTRIBUTE_DATE3            DATE          ,
    GLOBAL_ATTRIBUTE_DATE4            DATE          ,
    GLOBAL_ATTRIBUTE_DATE5            DATE          ,
    DEFAULT_EXPENSE_CCID_FLAG         VARCHAR2(4)   ,
    REVAL_LOSS_ACCOUNT_CCID           NUMBER(18, 0) ,
    COST_WRITE_OFF_ACCOUNT_CCID       NUMBER(18, 0) ,
    LEASE_LIABILITY_ACCOUNT_CCID      NUMBER(18, 0) ,
    LEASE_INT_EXPENSE_ACCOUNT_CCID    NUMBER(18, 0) ,
    LEASE_EXPENSE_ACCOUNT_CCID        NUMBER(18, 0) ,
    LEASE_GAIN_LOSS_ACCOUNT_CCID      NUMBER(18, 0) ,
    LEASE_CLEARING_ACCOUNT_CCID       NUMBER(18, 0) ,
    AUDIT_ACTION_TYPE_                VARCHAR2(40)  ,
    AUDIT_CHANGE_BIT_MAP_             VARCHAR2(4000),
    AUDIT_IMPERSONATOR_               VARCHAR2(256) ,
    REVALUED_COST_ACCOUNT_CCID        NUMBER(18, 0) ,
    BACKLOG_DEPRN_RSV_ACCT_CCID       NUMBER(18, 0) ,
    ATTRIBUTE_NUMBER1                 NUMBER        ,
    ATTRIBUTE_NUMBER2                 NUMBER        ,
    ATTRIBUTE_NUMBER3                 NUMBER        ,
    ATTRIBUTE_NUMBER4                 NUMBER        ,
    ATTRIBUTE_NUMBER5                 NUMBER        ,
    ATTRIBUTE_DATE1                   DATE          ,
    ATTRIBUTE_DATE2                   DATE          ,
    ATTRIBUTE_DATE3                   DATE          ,
    ATTRIBUTE_DATE4                   DATE          ,
    ATTRIBUTE_DATE5                   DATE          ,
    ANNUITY_INT_EXP_ACCOUNT_CCID      NUMBER(18, 0) ,
    ANNUITY_INT_REV_ACCOUNT_CCID      NUMBER(18, 0) ,
    SUPPRESS_MASSADD_AUTOPOST_FLAG    VARCHAR2(4)   ,
    CONSTRAINT pk_fa_category_books_ PRIMARY KEY (LAST_UPDATE_DATE, LAST_UPDATED_BY, CATEGORY_BOOK_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CATEGORY_BOOK_ID)
);
