[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_BOOK_CONTROLS_HISTORY# |
|---|---|
| Object Type: | VIEW |
| Owner: | FA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | |
| DATE_ACTIVE | DATE | Yes | ||
| DATE_INACTIVE | DATE | |||
| BOOK_TYPE_NAME | VARCHAR2 | (30) | Yes | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
| AMORTIZE_FLAG | VARCHAR2 | (3) | Yes | |
| GL_POSTING_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | |
| ALLOW_MASS_CHANGES | VARCHAR2 | (3) | Yes | |
| ALLOW_DEPRN_ADJUSTMENTS | VARCHAR2 | (3) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| DATE_INEFFECTIVE | DATE | |||
| JE_RETIREMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_DEPRECIATION_CATEGORY | VARCHAR2 | (30) | ||
| JE_RECLASS_CATEGORY | VARCHAR2 | (30) | ||
| GL_JE_SOURCE | VARCHAR2 | (30) | ||
| JE_ADDITION_CATEGORY | VARCHAR2 | (30) | ||
| JE_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_TRANSFER_CATEGORY | VARCHAR2 | (30) | ||
| COPY_RETIREMENTS_FLAG | VARCHAR2 | (3) | Yes | |
| COPY_ADJUSTMENTS_FLAG | VARCHAR2 | (3) | Yes | |
| ALLOW_COST_CEILING | VARCHAR2 | (3) | Yes | |
| ALLOW_DEPRN_EXP_CEILING | VARCHAR2 | (3) | Yes | |
| JE_DEFERRED_DEPRN_CATEGORY | VARCHAR2 | (30) | ||
| ITC_ALLOWED_FLAG | VARCHAR2 | (3) | Yes | |
| CREATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ALLOW_MASS_COPY | VARCHAR2 | (3) | Yes | |
| ALLOW_PURGE_FLAG | VARCHAR2 | (3) | ||
| ALLOW_REVAL_FLAG | VARCHAR2 | (3) | Yes | |
| AMORTIZE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | ||
| AP_INTERCOMPANY_ACCT | VARCHAR2 | (25) | ||
| AR_INTERCOMPANY_ACCT | VARCHAR2 | (25) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
| CAPITAL_GAIN_THRESHOLD | NUMBER | |||
| COPY_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | Yes | |
| COST_OF_REMOVAL_CLEARING_ACCT | VARCHAR2 | (25) | Yes | |
| COST_OF_REMOVAL_GAIN_ACCT | VARCHAR2 | (25) | ||
| COST_OF_REMOVAL_LOSS_ACCT | VARCHAR2 | (25) | ||
| DEFAULT_LIFE_EXTENSION_CEILING | NUMBER | |||
| DEFAULT_LIFE_EXTENSION_FACTOR | NUMBER | |||
| DEFAULT_MAX_FULLY_RSVD_REVALS | NUMBER | (15) | ||
| DEFAULT_REVAL_FULLY_RSVD_FLAG | VARCHAR2 | (3) | ||
| DEFERRED_DEPRN_EXPENSE_ACCT | VARCHAR2 | (25) | ||
| DEFERRED_DEPRN_RESERVE_ACCT | VARCHAR2 | (25) | ||
| DEPRN_ALLOCATION_CODE | VARCHAR2 | (1) | Yes | |
| JE_CIP_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_ADDITION_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_RECLASS_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_RETIREMENT_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_REVAL_CATEGORY | VARCHAR2 | (30) | ||
| JE_CIP_TRANSFER_CATEGORY | VARCHAR2 | (30) | ||
| JE_REVAL_CATEGORY | VARCHAR2 | (30) | ||
| NBV_AMOUNT_THRESHOLD | NUMBER | |||
| NBV_FRACTION_THRESHOLD | NUMBER | |||
| NBV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | ||
| NBV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | ||
| PROCEEDS_OF_SALE_CLEARING_ACCT | VARCHAR2 | (25) | ||
| PROCEEDS_OF_SALE_GAIN_ACCT | VARCHAR2 | (25) | ||
| PROCEEDS_OF_SALE_LOSS_ACCT | VARCHAR2 | (25) | ||
| REVALUE_ON_RETIREMENT_FLAG | VARCHAR2 | (3) | ||
| REVAL_DEPRN_RESERVE_FLAG | VARCHAR2 | (3) | ||
| REVAL_RSV_RETIRED_GAIN_ACCT | VARCHAR2 | (25) | ||
| REVAL_RSV_RETIRED_LOSS_ACCT | VARCHAR2 | (25) | ||
| DEPRN_ADJUSTMENT_ACCT | VARCHAR2 | (25) | ||
| IMMEDIATE_COPY_FLAG | VARCHAR2 | (3) | ||
| JE_DEPRN_ADJUSTMENT_CATEGORY | VARCHAR2 | (30) | ||
| DEPR_FIRST_YEAR_RET_FLAG | VARCHAR2 | (3) | Yes | |
| FLEXBUILDER_DEFAULTS_CCID | NUMBER | (15) | ||
| RETIRE_REVAL_RESERVE_FLAG | VARCHAR2 | (3) | ||
| COPY_ADDITIONS_FLAG | VARCHAR2 | (3) | Yes | |
| USE_PERCENT_SALVAGE_VALUE_FLAG | VARCHAR2 | (3) | ||
| REVAL_POSTING_FLAG | VARCHAR2 | (3) | ||
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| MC_SOURCE_FLAG | VARCHAR2 | (1) | ||
| REVAL_YTD_DEPRN_FLAG | VARCHAR2 | (3) | ||
| ALLOW_CIP_ASSETS_FLAG | VARCHAR2 | (3) | ||
| ORG_ID | NUMBER | (15) | ||
| ALLOW_GROUP_DEPRN_FLAG | VARCHAR2 | (1) | ||
| ALLOW_CIP_DEP_GROUP_FLAG | VARCHAR2 | (1) | ||
| ALLOW_INTERCO_GROUP_FLAG | VARCHAR2 | (1) | ||
| COPY_GROUP_ASSIGNMENT_FLAG | VARCHAR2 | (1) | ||
| COPY_GROUP_ADDITION_FLAG | VARCHAR2 | (1) | ||
| ALLOW_CIP_MEMBER_FLAG | VARCHAR2 | (1) | ||
| ALLOW_MEMBER_TRACKING_FLAG | VARCHAR2 | (1) | ||
| INTERCOMPANY_POSTING_FLAG | VARCHAR2 | (1) | ||
| ALLOW_BACKDATED_TRANSFERS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_COST_SIGN_CHANGE_FLAG | VARCHAR2 | (1) | ||
| ALLOW_IMPAIRMENT_FLAG | VARCHAR2 | (1) | ||
| SORP_ENABLED_FLAG | VARCHAR2 | (1) | ||
| COPY_AMORT_ADAJ_EXP_FLAG | VARCHAR2 | (1) | ||
| COPY_GROUP_CHANGE_FLAG | VARCHAR2 | (1) | ||
| PREVENT_PRIOR_PERIOD_TXNS_FLAG | VARCHAR2 | (1) | ||
| ALLOW_UNALLOCATED_LINES_FLAG | VARCHAR2 | (1) | ||
| DEFAULT_PERIOD_END_REVAL_FLAG | VARCHAR2 | (1) | ||
| IMPORT_ALLOC_INV_LINES_AS_NEW | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, DATE_ACTIVE
, DATE_INACTIVE
, BOOK_TYPE_NAME
, SET_OF_BOOKS_ID
, AMORTIZE_FLAG
, GL_POSTING_ALLOWED_FLAG
, ALLOW_MASS_CHANGES
, ALLOW_DEPRN_ADJUSTMENTS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, DATE_INEFFECTIVE
, JE_RETIREMENT_CATEGORY
, JE_DEPRECIATION_CATEGORY
, JE_RECLASS_CATEGORY
, GL_JE_SOURCE
, JE_ADDITION_CATEGORY
, JE_ADJUSTMENT_CATEGORY
, JE_TRANSFER_CATEGORY
, COPY_RETIREMENTS_FLAG
, COPY_ADJUSTMENTS_FLAG
, ALLOW_COST_CEILING
, ALLOW_DEPRN_EXP_CEILING
, JE_DEFERRED_DEPRN_CATEGORY
, ITC_ALLOWED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ALLOW_MASS_COPY
, ALLOW_PURGE_FLAG
, ALLOW_REVAL_FLAG
, AMORTIZE_REVAL_RESERVE_FLAG
, AP_INTERCOMPANY_ACCT
, AR_INTERCOMPANY_ACCT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, CAPITAL_GAIN_THRESHOLD
, COPY_SALVAGE_VALUE_FLAG
, COST_OF_REMOVAL_CLEARING_ACCT
, COST_OF_REMOVAL_GAIN_ACCT
, COST_OF_REMOVAL_LOSS_ACCT
, DEFAULT_LIFE_EXTENSION_CEILING
, DEFAULT_LIFE_EXTENSION_FACTOR
, DEFAULT_MAX_FULLY_RSVD_REVALS
, DEFAULT_REVAL_FULLY_RSVD_FLAG
, DEFERRED_DEPRN_EXPENSE_ACCT
, DEFERRED_DEPRN_RESERVE_ACCT
, DEPRN_ALLOCATION_CODE
, JE_CIP_ADJUSTMENT_CATEGORY
, JE_CIP_ADDITION_CATEGORY
, JE_CIP_RECLASS_CATEGORY
, JE_CIP_RETIREMENT_CATEGORY
, JE_CIP_REVAL_CATEGORY
, JE_CIP_TRANSFER_CATEGORY
, JE_REVAL_CATEGORY
, NBV_AMOUNT_THRESHOLD
, NBV_FRACTION_THRESHOLD
, NBV_RETIRED_GAIN_ACCT
, NBV_RETIRED_LOSS_ACCT
, PROCEEDS_OF_SALE_CLEARING_ACCT
, PROCEEDS_OF_SALE_GAIN_ACCT
, PROCEEDS_OF_SALE_LOSS_ACCT
, REVALUE_ON_RETIREMENT_FLAG
, REVAL_DEPRN_RESERVE_FLAG
, REVAL_RSV_RETIRED_GAIN_ACCT
, REVAL_RSV_RETIRED_LOSS_ACCT
, DEPRN_ADJUSTMENT_ACCT
, IMMEDIATE_COPY_FLAG
, JE_DEPRN_ADJUSTMENT_CATEGORY
, DEPR_FIRST_YEAR_RET_FLAG
, FLEXBUILDER_DEFAULTS_CCID
, RETIRE_REVAL_RESERVE_FLAG
, COPY_ADDITIONS_FLAG
, USE_PERCENT_SALVAGE_VALUE_FLAG
, REVAL_POSTING_FLAG
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, MC_SOURCE_FLAG
, REVAL_YTD_DEPRN_FLAG
, ALLOW_CIP_ASSETS_FLAG
, ORG_ID
, ALLOW_GROUP_DEPRN_FLAG
, ALLOW_CIP_DEP_GROUP_FLAG
, ALLOW_INTERCO_GROUP_FLAG
, COPY_GROUP_ASSIGNMENT_FLAG
, COPY_GROUP_ADDITION_FLAG
, ALLOW_CIP_MEMBER_FLAG
, ALLOW_MEMBER_TRACKING_FLAG
, INTERCOMPANY_POSTING_FLAG
, ALLOW_BACKDATED_TRANSFERS_FLAG
, ALLOW_COST_SIGN_CHANGE_FLAG
, ALLOW_IMPAIRMENT_FLAG
, SORP_ENABLED_FLAG
, COPY_AMORT_ADAJ_EXP_FLAG
, COPY_GROUP_CHANGE_FLAG
, PREVENT_PRIOR_PERIOD_TXNS_FLAG
, ALLOW_UNALLOCATED_LINES_FLAG
, DEFAULT_PERIOD_END_REVAL_FLAG
, IMPORT_ALLOC_INV_LINES_AS_NEW
FROM FA.FA_BOOK_CONTROLS_HISTORY#;
FA
FA_BOOK_CONTROLS_HISTORY
APPS
FA_BOOK_CONTROLS_HISTORY
|
|
|
|