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

TABLE: FA.FA_GROUP_DEPRN_SUMMARY

Object Details
Object Name: FA_GROUP_DEPRN_SUMMARY
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_GROUP_DEPRN_SUMMARY
Subobject Name:
Status: VALID


Stores information about depreciation taken on a group asset, in a particular book in a particular period. This is a history table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_GROUP_DEPRN_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOK_TYPE_CODE
ColumnPERIOD_COUNTER
Columns
Name Datatype Length Mandatory Comments
GROUP_ASSET_ID NUMBER (15) Yes Unique key to identify group asset
BOOK_TYPE_CODE VARCHAR2 (15) Yes Book Type code
DEPRN_RUN_DATE DATE
Yes Depreciation run date
DEPRN_AMOUNT NUMBER
Yes Group depreciation amount for the period
YTD_DEPRN NUMBER
Yes Year to date group depreciation
DEPRN_RESERVE NUMBER
Yes Cumulative group depreciation
DEPRN_SOURCE_CODE VARCHAR2 (15)
Indicates whether the depreciation record was created by the Books window (BOOKS), by running the Depreciation program (DEPRN), or by the Member Asset Tracking functionality (TRACK).
ADJUSTED_COST NUMBER
Yes Adjust group asset cost
BONUS_RATE NUMBER

Bonus rate for group depreciation
LTD_PRODUCTION NUMBER

Life to date production.
PERIOD_COUNTER NUMBER (15) Yes Period counter for group transaction
PRODUCTION NUMBER

Production.
REVAL_AMORTIZATION NUMBER

Revalued amortization
REVAL_AMORTIZATION_BASIS NUMBER

Revalued amortization basis
REVAL_DEPRN_EXPENSE NUMBER

Revalued depreciation expense
REVAL_RESERVE NUMBER

Revalued reserve
YTD_PRODUCTION NUMBER

Year to date production
YTD_REVAL_DEPRN_EXPENSE NUMBER

Year to date revalued depreciation expense
PRIOR_FY_EXPENSE NUMBER

Prior Fiscal year expense
DEPRN_RATE NUMBER

The rate that was used to calculate group depreciation.
Query Text

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


SELECT GROUP_ASSET_ID
,      BOOK_TYPE_CODE
,      DEPRN_RUN_DATE
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      DEPRN_SOURCE_CODE
,      ADJUSTED_COST
,      BONUS_RATE
,      LTD_PRODUCTION
,      PERIOD_COUNTER
,      PRODUCTION
,      REVAL_AMORTIZATION
,      REVAL_AMORTIZATION_BASIS
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_PRODUCTION
,      YTD_REVAL_DEPRN_EXPENSE
,      PRIOR_FY_EXPENSE
,      DEPRN_RATE
FROM FA.FA_GROUP_DEPRN_SUMMARY;

Dependencies

[top of page]

FA.FA_GROUP_DEPRN_SUMMARY does not reference any database object

FA.FA_GROUP_DEPRN_SUMMARY is referenced by following:

SchemaFA
ViewFA_GROUP_DEPRN_SUMMARY#