Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: FA.FA_MC_BOOKS_SUMMARY#

Object Details
Object Name: FA_MC_BOOKS_SUMMARY#
Object Type: VIEW
Owner: FA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SET_OF_BOOKS_ID NUMBER (15) Yes
ASSET_ID NUMBER (15) Yes
BOOK_TYPE_CODE VARCHAR2 (15) Yes
PERIOD_COUNTER NUMBER (15) Yes
FISCAL_YEAR NUMBER (15)
PERIOD_NUM NUMBER (15)
CALENDAR_PERIOD_OPEN_DATE DATE

CALENDAR_PERIOD_CLOSE_DATE DATE

RESET_ADJUSTED_COST_FLAG VARCHAR2 (1)
CHANGE_IN_COST NUMBER

CHANGE_IN_ADDITIONS_COST NUMBER

CHANGE_IN_ADJUSTMENTS_COST NUMBER

CHANGE_IN_RETIREMENTS_COST NUMBER

CHANGE_IN_GROUP_REC_COST NUMBER

CHANGE_IN_CIP_COST NUMBER

COST NUMBER

CIP_COST NUMBER

SALVAGE_TYPE VARCHAR2 (30)
PERCENT_SALVAGE_VALUE NUMBER

SALVAGE_VALUE NUMBER

MEMBER_SALVAGE_VALUE NUMBER

RECOVERABLE_COST NUMBER

DEPRN_LIMIT_TYPE VARCHAR2 (30)
ALLOWED_DEPRN_LIMIT NUMBER

ALLOWED_DEPRN_LIMIT_AMOUNT NUMBER

MEMBER_DEPRN_LIMIT_AMOUNT NUMBER

ADJUSTED_RECOVERABLE_COST NUMBER

ADJUSTED_COST NUMBER

DEPRECIATE_FLAG VARCHAR2 (3)
DISABLED_FLAG VARCHAR2 (1)
DATE_PLACED_IN_SERVICE DATE

DEPRN_METHOD_CODE VARCHAR2 (12)
LIFE_IN_MONTHS NUMBER (4)
RATE_ADJUSTMENT_FACTOR NUMBER

ADJUSTED_RATE NUMBER

BONUS_RULE VARCHAR2 (30)
ADJUSTED_CAPACITY NUMBER

PRODUCTION_CAPACITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
REMAINING_LIFE1 NUMBER (4)
REMAINING_LIFE2 NUMBER (4)
FORMULA_FACTOR NUMBER

UNREVALUED_COST NUMBER

REVAL_AMORTIZATION_BASIS NUMBER

REVAL_CEILING NUMBER

CEILING_NAME VARCHAR2 (30)
EOFY_ADJ_COST NUMBER

EOFY_FORMULA_FACTOR NUMBER

EOFY_RESERVE NUMBER

EOP_ADJ_COST NUMBER

EOP_FORMULA_FACTOR NUMBER

SHORT_FISCAL_YEAR_FLAG VARCHAR2 (3)
GROUP_ASSET_ID NUMBER (15)
SUPER_GROUP_ID NUMBER (15)
OVER_DEPRECIATE_OPTION VARCHAR2 (30)
FULLY_RSVD_REVALS_COUNTER NUMBER (5)
CAPITALIZED_FLAG VARCHAR2 (1)
FULLY_RESERVED_FLAG VARCHAR2 (1)
FULLY_RETIRED_FLAG VARCHAR2 (1)
LIFE_COMPLETE_FLAG VARCHAR2 (1)
TERMINAL_GAIN_LOSS_AMOUNT NUMBER

TERMINAL_GAIN_LOSS_FLAG VARCHAR2 (1)
DEPRN_AMOUNT NUMBER

YTD_DEPRN NUMBER

DEPRN_RESERVE NUMBER

BONUS_DEPRN_AMOUNT NUMBER

BONUS_YTD_DEPRN NUMBER

BONUS_DEPRN_RESERVE NUMBER

BONUS_RATE NUMBER

LTD_PRODUCTION NUMBER

YTD_PRODUCTION NUMBER

PRODUCTION NUMBER

REVAL_AMORTIZATION NUMBER

REVAL_DEPRN_EXPENSE NUMBER

REVAL_RESERVE NUMBER

YTD_REVAL_DEPRN_EXPENSE NUMBER

DEPRN_OVERRIDE_FLAG VARCHAR2 (1)
SYSTEM_DEPRN_AMOUNT NUMBER

SYSTEM_BONUS_DEPRN_AMOUNT NUMBER

YTD_PROCEEDS_OF_SALE NUMBER

LTD_PROCEEDS_OF_SALE NUMBER

YTD_COST_OF_REMOVAL NUMBER

LTD_COST_OF_REMOVAL NUMBER

DEPRN_ADJUSTMENT_AMOUNT NUMBER

EXPENSE_ADJUSTMENT_AMOUNT NUMBER

UNPLANNED_AMOUNT NUMBER

RESERVE_ADJUSTMENT_AMOUNT NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CHANGE_IN_EOFY_RESERVE NUMBER

SWITCH_CODE VARCHAR2 (2)
TRANSACTION_HEADER_ID_IN NUMBER (15)
TRANSACTION_HEADER_ID_OUT NUMBER (15)
POLISH_DEPRN_BASIS NUMBER

POLISH_ADJ_REC_COST NUMBER

IMPAIRMENT_AMOUNT NUMBER

YTD_IMPAIRMENT NUMBER

IMPAIRMENT_RESERVE NUMBER

CAPITAL_ADJUSTMENT NUMBER

GENERAL_FUND NUMBER

REVAL_LOSS_BALANCE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SET_OF_BOOKS_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      FISCAL_YEAR
,      PERIOD_NUM
,      CALENDAR_PERIOD_OPEN_DATE
,      CALENDAR_PERIOD_CLOSE_DATE
,      RESET_ADJUSTED_COST_FLAG
,      CHANGE_IN_COST
,      CHANGE_IN_ADDITIONS_COST
,      CHANGE_IN_ADJUSTMENTS_COST
,      CHANGE_IN_RETIREMENTS_COST
,      CHANGE_IN_GROUP_REC_COST
,      CHANGE_IN_CIP_COST
,      COST
,      CIP_COST
,      SALVAGE_TYPE
,      PERCENT_SALVAGE_VALUE
,      SALVAGE_VALUE
,      MEMBER_SALVAGE_VALUE
,      RECOVERABLE_COST
,      DEPRN_LIMIT_TYPE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      MEMBER_DEPRN_LIMIT_AMOUNT
,      ADJUSTED_RECOVERABLE_COST
,      ADJUSTED_COST
,      DEPRECIATE_FLAG
,      DISABLED_FLAG
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_RATE
,      BONUS_RULE
,      ADJUSTED_CAPACITY
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      FORMULA_FACTOR
,      UNREVALUED_COST
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      CEILING_NAME
,      EOFY_ADJ_COST
,      EOFY_FORMULA_FACTOR
,      EOFY_RESERVE
,      EOP_ADJ_COST
,      EOP_FORMULA_FACTOR
,      SHORT_FISCAL_YEAR_FLAG
,      GROUP_ASSET_ID
,      SUPER_GROUP_ID
,      OVER_DEPRECIATE_OPTION
,      FULLY_RSVD_REVALS_COUNTER
,      CAPITALIZED_FLAG
,      FULLY_RESERVED_FLAG
,      FULLY_RETIRED_FLAG
,      LIFE_COMPLETE_FLAG
,      TERMINAL_GAIN_LOSS_AMOUNT
,      TERMINAL_GAIN_LOSS_FLAG
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      BONUS_DEPRN_AMOUNT
,      BONUS_YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      BONUS_RATE
,      LTD_PRODUCTION
,      YTD_PRODUCTION
,      PRODUCTION
,      REVAL_AMORTIZATION
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
,      DEPRN_OVERRIDE_FLAG
,      SYSTEM_DEPRN_AMOUNT
,      SYSTEM_BONUS_DEPRN_AMOUNT
,      YTD_PROCEEDS_OF_SALE
,      LTD_PROCEEDS_OF_SALE
,      YTD_COST_OF_REMOVAL
,      LTD_COST_OF_REMOVAL
,      DEPRN_ADJUSTMENT_AMOUNT
,      EXPENSE_ADJUSTMENT_AMOUNT
,      UNPLANNED_AMOUNT
,      RESERVE_ADJUSTMENT_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_IN_EOFY_RESERVE
,      SWITCH_CODE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      POLISH_DEPRN_BASIS
,      POLISH_ADJ_REC_COST
,      IMPAIRMENT_AMOUNT
,      YTD_IMPAIRMENT
,      IMPAIRMENT_RESERVE
,      CAPITAL_ADJUSTMENT
,      GENERAL_FUND
,      REVAL_LOSS_BALANCE
FROM FA.FA_MC_BOOKS_SUMMARY#;

Dependencies

[top of page]

FA.FA_MC_BOOKS_SUMMARY# references the following:

SchemaFA
TableFA_MC_BOOKS_SUMMARY
FA.FA_MC_BOOKS_SUMMARY# is referenced by following:

SchemaAPPS
SynonymFA_MC_BOOKS_SUMMARY