1. Tables and Views for Financials
  2. FA_DEPRN_OVERRIDE

FA_DEPRN_OVERRIDE

FA_DEPRN_OVERRIDE contains depreciation information provided by users which overrides system calculated depreciation amounts.

Details

  • Schema: FUSION

  • Object owner: FA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

FA_DEPRN_OVERRIDE_PK

DEPRN_OVERRIDE_ID

Columns

Name Datatype Length Precision Not-null Comments
DEPRN_OVERRIDE_ID NUMBER 18 Yes Identifier of the depreciation override transaction.
BOOK_TYPE_CODE VARCHAR2 30 Yes Unique book identification name.
ASSET_ID NUMBER 18 Yes Identifier of the asset number.
PERIOD_NAME VARCHAR2 15 Yes Asset book depreciation calendar period name.
DEPRN_AMOUNT NUMBER Asset depreciation expense amount.
BONUS_DEPRN_AMOUNT NUMBER Bonus depreciation expense. Amount included in DEPRN_AMOUNT.
SUBTRACTION_FLAG VARCHAR2 1 Subtraction method indicator for depreciation override calculation.
USED_BY VARCHAR2 15 Yes Transaction that will use the depreciation override. Possible values are ADJUSTMENT, and DEPRECIATION.
STATUS VARCHAR2 15 Status of the override depreciation.
TRANSACTION_HEADER_ID NUMBER 18 Identifier of the asset transaction.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SUBTRACT_YTD_FLAG VARCHAR2 1 Subtraction method indicator for depreciation expense calculation. Possible values are Y for depreciation expense calculation using the subtraction method and N or Null for depreciation expense calculation not using the subtraction method.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
COMMENTS VARCHAR2 240 Comments about the depreciation override entry.
PRIOR_STATUS VARCHAR2 15 Prior status of the override depreciation.
ERROR_MSG VARCHAR2 1000 Oracle internal use only. Encoded message text associated with a failure of the validation process.
PRIOR_DEPRN_AMOUNT NUMBER Prior asset depreciation expense amount.
PRIOR_BONUS_DEPRN_AMOUNT NUMBER Prior bonus depreciation expense amount. Amount included in PRIOR_DEPRN_AMOUNT.

Foreign Keys

Table Foreign Table Foreign Key Column
FA_DEPRN_OVERRIDE fa_book_controls BOOK_TYPE_CODE
FA_DEPRN_OVERRIDE fa_additions_b ASSET_ID
FA_DEPRN_OVERRIDE fa_transaction_headers TRANSACTION_HEADER_ID, BOOK_TYPE_CODE

Indexes

Index Uniqueness Tablespace Columns
FA_DEPRN_OVERRIDE_N1 Non Unique Default BOOK_TYPE_CODE, ASSET_ID, PERIOD_NAME, USED_BY, STATUS
FA_DEPRN_OVERRIDE_N2 Non Unique Default STATUS, BOOK_TYPE_CODE, USED_BY, TRANSACTION_HEADER_ID
FA_DEPRN_OVERRIDE_U1 Unique Default DEPRN_OVERRIDE_ID