VIEW: FA.FA_BOOK_CONTROLS_HISTORY#

Source

View Text - Preformatted

select BOOK_TYPE_CODE BOOK_TYPE_CODE, DATE_ACTIVE DATE_ACTIVE, DATE_INACTIVE DATE_INACTIVE, BOOK_TYPE_NAME BOOK_TYPE_NAME, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, AMORTIZE_FLAG AMORTIZE_FLAG, GL_POSTING_ALLOWED_FLAG GL_POSTING_ALLOWED_FLAG, ALLOW_MASS_CHANGES ALLOW_MASS_CHANGES, ALLOW_DEPRN_ADJUSTMENTS ALLOW_DEPRN_ADJUSTMENTS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, DATE_INEFFECTIVE DATE_INEFFECTIVE, JE_RETIREMENT_CATEGORY JE_RETIREMENT_CATEGORY, JE_DEPRECIATION_CATEGORY JE_DEPRECIATION_CATEGORY, JE_RECLASS_CATEGORY JE_RECLASS_CATEGORY, GL_JE_SOURCE GL_JE_SOURCE, JE_ADDITION_CATEGORY JE_ADDITION_CATEGORY, JE_ADJUSTMENT_CATEGORY JE_ADJUSTMENT_CATEGORY, JE_TRANSFER_CATEGORY JE_TRANSFER_CATEGORY, COPY_RETIREMENTS_FLAG COPY_RETIREMENTS_FLAG, COPY_ADJUSTMENTS_FLAG COPY_ADJUSTMENTS_FLAG, ALLOW_COST_CEILING ALLOW_COST_CEILING, ALLOW_DEPRN_EXP_CEILING ALLOW_DEPRN_EXP_CEILING, JE_DEFERRED_DEPRN_CATEGORY JE_DEFERRED_DEPRN_CATEGORY, ITC_ALLOWED_FLAG ITC_ALLOWED_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ALLOW_MASS_COPY ALLOW_MASS_COPY, ALLOW_PURGE_FLAG ALLOW_PURGE_FLAG, ALLOW_REVAL_FLAG ALLOW_REVAL_FLAG, AMORTIZE_REVAL_RESERVE_FLAG AMORTIZE_REVAL_RESERVE_FLAG, AP_INTERCOMPANY_ACCT AP_INTERCOMPANY_ACCT, AR_INTERCOMPANY_ACCT AR_INTERCOMPANY_ACCT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD, COPY_SALVAGE_VALUE_FLAG COPY_SALVAGE_VALUE_FLAG, COST_OF_REMOVAL_CLEARING_ACCT COST_OF_REMOVAL_CLEARING_ACCT, COST_OF_REMOVAL_GAIN_ACCT COST_OF_REMOVAL_GAIN_ACCT, COST_OF_REMOVAL_LOSS_ACCT COST_OF_REMOVAL_LOSS_ACCT, DEFAULT_LIFE_EXTENSION_CEILING DEFAULT_LIFE_EXTENSION_CEILING, DEFAULT_LIFE_EXTENSION_FACTOR DEFAULT_LIFE_EXTENSION_FACTOR, DEFAULT_MAX_FULLY_RSVD_REVALS DEFAULT_MAX_FULLY_RSVD_REVALS, DEFAULT_REVAL_FULLY_RSVD_FLAG DEFAULT_REVAL_FULLY_RSVD_FLAG, DEFERRED_DEPRN_EXPENSE_ACCT DEFERRED_DEPRN_EXPENSE_ACCT, DEFERRED_DEPRN_RESERVE_ACCT DEFERRED_DEPRN_RESERVE_ACCT, DEPRN_ALLOCATION_CODE DEPRN_ALLOCATION_CODE, JE_CIP_ADJUSTMENT_CATEGORY JE_CIP_ADJUSTMENT_CATEGORY, JE_CIP_ADDITION_CATEGORY JE_CIP_ADDITION_CATEGORY, JE_CIP_RECLASS_CATEGORY JE_CIP_RECLASS_CATEGORY, JE_CIP_RETIREMENT_CATEGORY JE_CIP_RETIREMENT_CATEGORY, JE_CIP_REVAL_CATEGORY JE_CIP_REVAL_CATEGORY, JE_CIP_TRANSFER_CATEGORY JE_CIP_TRANSFER_CATEGORY, JE_REVAL_CATEGORY JE_REVAL_CATEGORY, NBV_AMOUNT_THRESHOLD NBV_AMOUNT_THRESHOLD, NBV_FRACTION_THRESHOLD NBV_FRACTION_THRESHOLD, NBV_RETIRED_GAIN_ACCT NBV_RETIRED_GAIN_ACCT, NBV_RETIRED_LOSS_ACCT NBV_RETIRED_LOSS_ACCT, PROCEEDS_OF_SALE_CLEARING_ACCT PROCEEDS_OF_SALE_CLEARING_ACCT, PROCEEDS_OF_SALE_GAIN_ACCT PROCEEDS_OF_SALE_GAIN_ACCT, PROCEEDS_OF_SALE_LOSS_ACCT PROCEEDS_OF_SALE_LOSS_ACCT, REVALUE_ON_RETIREMENT_FLAG REVALUE_ON_RETIREMENT_FLAG, REVAL_DEPRN_RESERVE_FLAG REVAL_DEPRN_RESERVE_FLAG, REVAL_RSV_RETIRED_GAIN_ACCT REVAL_RSV_RETIRED_GAIN_ACCT, REVAL_RSV_RETIRED_LOSS_ACCT REVAL_RSV_RETIRED_LOSS_ACCT, DEPRN_ADJUSTMENT_ACCT DEPRN_ADJUSTMENT_ACCT, IMMEDIATE_COPY_FLAG IMMEDIATE_COPY_FLAG, JE_DEPRN_ADJUSTMENT_CATEGORY JE_DEPRN_ADJUSTMENT_CATEGORY, DEPR_FIRST_YEAR_RET_FLAG DEPR_FIRST_YEAR_RET_FLAG, FLEXBUILDER_DEFAULTS_CCID FLEXBUILDER_DEFAULTS_CCID, RETIRE_REVAL_RESERVE_FLAG RETIRE_REVAL_RESERVE_FLAG, COPY_ADDITIONS_FLAG COPY_ADDITIONS_FLAG, USE_PERCENT_SALVAGE_VALUE_FLAG USE_PERCENT_SALVAGE_VALUE_FLAG, REVAL_POSTING_FLAG REVAL_POSTING_FLAG, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, MC_SOURCE_FLAG MC_SOURCE_FLAG, REVAL_YTD_DEPRN_FLAG REVAL_YTD_DEPRN_FLAG, ALLOW_CIP_ASSETS_FLAG ALLOW_CIP_ASSETS_FLAG, ORG_ID ORG_ID, ALLOW_GROUP_DEPRN_FLAG ALLOW_GROUP_DEPRN_FLAG, ALLOW_CIP_DEP_GROUP_FLAG ALLOW_CIP_DEP_GROUP_FLAG, ALLOW_INTERCO_GROUP_FLAG ALLOW_INTERCO_GROUP_FLAG, COPY_GROUP_ASSIGNMENT_FLAG COPY_GROUP_ASSIGNMENT_FLAG, COPY_GROUP_ADDITION_FLAG COPY_GROUP_ADDITION_FLAG, ALLOW_CIP_MEMBER_FLAG ALLOW_CIP_MEMBER_FLAG, ALLOW_MEMBER_TRACKING_FLAG ALLOW_MEMBER_TRACKING_FLAG, INTERCOMPANY_POSTING_FLAG INTERCOMPANY_POSTING_FLAG, ALLOW_BACKDATED_TRANSFERS_FLAG ALLOW_BACKDATED_TRANSFERS_FLAG, ALLOW_COST_SIGN_CHANGE_FLAG ALLOW_COST_SIGN_CHANGE_FLAG, ALLOW_IMPAIRMENT_FLAG ALLOW_IMPAIRMENT_FLAG, SORP_ENABLED_FLAG SORP_ENABLED_FLAG, COPY_AMORT_ADAJ_EXP_FLAG COPY_AMORT_ADAJ_EXP_FLAG, COPY_GROUP_CHANGE_FLAG COPY_GROUP_CHANGE_FLAG, PREVENT_PRIOR_PERIOD_TXNS_FLAG PREVENT_PRIOR_PERIOD_TXNS_FLAG, ALLOW_UNALLOCATED_LINES_FLAG ALLOW_UNALLOCATED_LINES_FLAG, DEFAULT_PERIOD_END_REVAL_FLAG DEFAULT_PERIOD_END_REVAL_FLAG, IMPORT_ALLOC_INV_LINES_AS_NEW IMPORT_ALLOC_INV_LINES_AS_NEW from "FA"."FA_BOOK_CONTROLS_HISTORY"

View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, DATE_ACTIVE DATE_ACTIVE
, DATE_INACTIVE DATE_INACTIVE
, BOOK_TYPE_NAME BOOK_TYPE_NAME
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, AMORTIZE_FLAG AMORTIZE_FLAG
, GL_POSTING_ALLOWED_FLAG GL_POSTING_ALLOWED_FLAG
, ALLOW_MASS_CHANGES ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS ALLOW_DEPRN_ADJUSTMENTS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, JE_RETIREMENT_CATEGORY JE_RETIREMENT_CATEGORY
, JE_DEPRECIATION_CATEGORY JE_DEPRECIATION_CATEGORY
, JE_RECLASS_CATEGORY JE_RECLASS_CATEGORY
, GL_JE_SOURCE GL_JE_SOURCE
, JE_ADDITION_CATEGORY JE_ADDITION_CATEGORY
, JE_ADJUSTMENT_CATEGORY JE_ADJUSTMENT_CATEGORY
, JE_TRANSFER_CATEGORY JE_TRANSFER_CATEGORY
, COPY_RETIREMENTS_FLAG COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG COPY_ADJUSTMENTS_FLAG
, ALLOW_COST_CEILING ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING ALLOW_DEPRN_EXP_CEILING
, JE_DEFERRED_DEPRN_CATEGORY JE_DEFERRED_DEPRN_CATEGORY
, ITC_ALLOWED_FLAG ITC_ALLOWED_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ALLOW_MASS_COPY ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG AMORTIZE_REVAL_RESERVE_FLAG
, AP_INTERCOMPANY_ACCT AP_INTERCOMPANY_ACCT
, AR_INTERCOMPANY_ACCT AR_INTERCOMPANY_ACCT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, CAPITAL_GAIN_THRESHOLD CAPITAL_GAIN_THRESHOLD
, COPY_SALVAGE_VALUE_FLAG COPY_SALVAGE_VALUE_FLAG
, COST_OF_REMOVAL_CLEARING_ACCT COST_OF_REMOVAL_CLEARING_ACCT
, COST_OF_REMOVAL_GAIN_ACCT COST_OF_REMOVAL_GAIN_ACCT
, COST_OF_REMOVAL_LOSS_ACCT COST_OF_REMOVAL_LOSS_ACCT
, DEFAULT_LIFE_EXTENSION_CEILING DEFAULT_LIFE_EXTENSION_CEILING
, DEFAULT_LIFE_EXTENSION_FACTOR DEFAULT_LIFE_EXTENSION_FACTOR
, DEFAULT_MAX_FULLY_RSVD_REVALS DEFAULT_MAX_FULLY_RSVD_REVALS
, DEFAULT_REVAL_FULLY_RSVD_FLAG DEFAULT_REVAL_FULLY_RSVD_FLAG
, DEFERRED_DEPRN_EXPENSE_ACCT DEFERRED_DEPRN_EXPENSE_ACCT
, DEFERRED_DEPRN_RESERVE_ACCT DEFERRED_DEPRN_RESERVE_ACCT
, DEPRN_ALLOCATION_CODE DEPRN_ALLOCATION_CODE
, JE_CIP_ADJUSTMENT_CATEGORY JE_CIP_ADJUSTMENT_CATEGORY
, JE_CIP_ADDITION_CATEGORY JE_CIP_ADDITION_CATEGORY
, JE_CIP_RECLASS_CATEGORY JE_CIP_RECLASS_CATEGORY
, JE_CIP_RETIREMENT_CATEGORY JE_CIP_RETIREMENT_CATEGORY
, JE_CIP_REVAL_CATEGORY JE_CIP_REVAL_CATEGORY
, JE_CIP_TRANSFER_CATEGORY JE_CIP_TRANSFER_CATEGORY
, JE_REVAL_CATEGORY JE_REVAL_CATEGORY
, NBV_AMOUNT_THRESHOLD NBV_AMOUNT_THRESHOLD
, NBV_FRACTION_THRESHOLD NBV_FRACTION_THRESHOLD
, NBV_RETIRED_GAIN_ACCT NBV_RETIRED_GAIN_ACCT
, NBV_RETIRED_LOSS_ACCT NBV_RETIRED_LOSS_ACCT
, PROCEEDS_OF_SALE_CLEARING_ACCT PROCEEDS_OF_SALE_CLEARING_ACCT
, PROCEEDS_OF_SALE_GAIN_ACCT PROCEEDS_OF_SALE_GAIN_ACCT
, PROCEEDS_OF_SALE_LOSS_ACCT PROCEEDS_OF_SALE_LOSS_ACCT
, REVALUE_ON_RETIREMENT_FLAG REVALUE_ON_RETIREMENT_FLAG
, REVAL_DEPRN_RESERVE_FLAG REVAL_DEPRN_RESERVE_FLAG
, REVAL_RSV_RETIRED_GAIN_ACCT REVAL_RSV_RETIRED_GAIN_ACCT
, REVAL_RSV_RETIRED_LOSS_ACCT REVAL_RSV_RETIRED_LOSS_ACCT
, DEPRN_ADJUSTMENT_ACCT DEPRN_ADJUSTMENT_ACCT
, IMMEDIATE_COPY_FLAG IMMEDIATE_COPY_FLAG
, JE_DEPRN_ADJUSTMENT_CATEGORY JE_DEPRN_ADJUSTMENT_CATEGORY
, DEPR_FIRST_YEAR_RET_FLAG DEPR_FIRST_YEAR_RET_FLAG
, FLEXBUILDER_DEFAULTS_CCID FLEXBUILDER_DEFAULTS_CCID
, RETIRE_REVAL_RESERVE_FLAG RETIRE_REVAL_RESERVE_FLAG
, COPY_ADDITIONS_FLAG COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG USE_PERCENT_SALVAGE_VALUE_FLAG
, REVAL_POSTING_FLAG REVAL_POSTING_FLAG
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, MC_SOURCE_FLAG MC_SOURCE_FLAG
, REVAL_YTD_DEPRN_FLAG REVAL_YTD_DEPRN_FLAG
, ALLOW_CIP_ASSETS_FLAG ALLOW_CIP_ASSETS_FLAG
, ORG_ID ORG_ID
, ALLOW_GROUP_DEPRN_FLAG ALLOW_GROUP_DEPRN_FLAG
, ALLOW_CIP_DEP_GROUP_FLAG ALLOW_CIP_DEP_GROUP_FLAG
, ALLOW_INTERCO_GROUP_FLAG ALLOW_INTERCO_GROUP_FLAG
, COPY_GROUP_ASSIGNMENT_FLAG COPY_GROUP_ASSIGNMENT_FLAG
, COPY_GROUP_ADDITION_FLAG COPY_GROUP_ADDITION_FLAG
, ALLOW_CIP_MEMBER_FLAG ALLOW_CIP_MEMBER_FLAG
, ALLOW_MEMBER_TRACKING_FLAG ALLOW_MEMBER_TRACKING_FLAG
, INTERCOMPANY_POSTING_FLAG INTERCOMPANY_POSTING_FLAG
, ALLOW_BACKDATED_TRANSFERS_FLAG ALLOW_BACKDATED_TRANSFERS_FLAG
, ALLOW_COST_SIGN_CHANGE_FLAG ALLOW_COST_SIGN_CHANGE_FLAG
, ALLOW_IMPAIRMENT_FLAG ALLOW_IMPAIRMENT_FLAG
, SORP_ENABLED_FLAG SORP_ENABLED_FLAG
, COPY_AMORT_ADAJ_EXP_FLAG COPY_AMORT_ADAJ_EXP_FLAG
, COPY_GROUP_CHANGE_FLAG COPY_GROUP_CHANGE_FLAG
, PREVENT_PRIOR_PERIOD_TXNS_FLAG PREVENT_PRIOR_PERIOD_TXNS_FLAG
, ALLOW_UNALLOCATED_LINES_FLAG ALLOW_UNALLOCATED_LINES_FLAG
, DEFAULT_PERIOD_END_REVAL_FLAG DEFAULT_PERIOD_END_REVAL_FLAG
, IMPORT_ALLOC_INV_LINES_AS_NEW IMPORT_ALLOC_INV_LINES_AS_NEW
FROM "FA"."FA_BOOK_CONTROLS_HISTORY"