Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FIXED_ASSET_ADJUSTMENT

Description Contains all asset adjustments information by adjustment document number. This includes the type of adjustment, depreciation adjustment date, transaction date, disposal, net book value amount, fiscal year, fiscal period, transaction amount, distribution percent, transaction amount, and transaction amount adjusted.
Key & Frequency One row per adjustment document number per item number per sequence number per accounting sequence number.
Recommended Search Columns DOCUMENT, ACCOUNT_ITEM, SEQUENCE_NUMBER, ACCOUNTING_SEQUENCE_NUMBER
ORIGINATION_TAG_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNTING_SEQUENCE_NUMBER System-generated one-up number associated with an asset accounting record. NUMBER

FFRADJA

FFRADJA_MASA_SEQ_NUM

ACCOUNT_ITEM System-generated one-up number associated with an asset being adjusted in the document. NUMBER

FFRADJA

FFRADJA_ITEM

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPROVAL_IND Indicates the document has met final approval. VARCHAR2(63)

FFBADJH

FFBADJH_APPR_IND

ASSET_AMOUNT Amount entered by the user to determine the sale price of an asset or an adjustment. NUMBER

FFRADJD

FFRADJD_AMT

COMPLETED_IND Indicates the fixed asset adjustment document is complete. VARCHAR2(63)

FFBADJH

FFBADJH_COMPLETE_IND

DEPRECIATION_ADJUSTMENT_DATE Depreciation adjustment date defaults from the adjustment transaction date for every function processed. DATE

FFBADJH

FFBADJH_DEPR_ADJ_DATE

DISPOSAL Code used to define method of disposal of an asset. VARCHAR2(63)

FFRADJD

FFRADJD_DISP_CODE

DISPOSAL_DESC Disposal method description. VARCHAR2(255)

FFVDISP

FFVDISP_DESC

DISTRIBUTION_PERCENT Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER

FFRADJA

FFRADJA_PCT

DOCUMENT User-defined or system generated document number. VARCHAR2(63)

FFRADJA

FFRADJA_ADJH_CODE

DOCUMENT_REFERENCE_NUMBER User-defined identification number further identifying this document and linking it to an external reference number. VARCHAR2(63)

FFBADJH

FFBADJH_DOC_REF_NUM

EQUITY_ACCOUNT Account code to record asset equity. VARCHAR2(63)

FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

EQUITY_ACCOUNT_DESC Extracted description or title of the associated account. VARCHAR2(255)

FUNCTION

F_GET_FINANCE_DESC

EQUITY_ACCOUNT_STATUS Extracted current status of the associated account. VARCHAR2(63)

FUNCTION

F_GET_FINANCE_STATUS

FISCAL_PERIOD Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14. VARCHAR2(63)

FFRADJA

FFRADJA_PERIOD

FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(63)

FUNCTION

FOFYCNV

FUNCTION_TYPE Function code of the adjustment action used on the asset in the document. VARCHAR2(63)

FFBADJH

FFBADJH_FUNCTION_CODE

METHOD_OF_ACQUISITION Code used to indicate the method used to acquire the asset. VARCHAR2(63)

FFRADJD

FFRADJD_ACQM_CODE

METHOD_OF_ACQUISITION_DESC Description of the method used to acquire the asset. VARCHAR2(255)

FFVACQM

FFVACQM_DESC

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NET_BOOK_VALUE_AMOUNT Net book value of the asset calculated by the system as asset cost less depreciation plus or minus any asset adjustments. This amount is used to determine any gain or loss on the asset when it is sold. NUMBER

FFRADJD

FFRADJD_NET_BOOK_VALUE_AMT

ORIGINATION_TAG_NUMBER System generated tag number assigned when the asset is acquired. VARCHAR2(63)

FFRADJD

FFRADJD_OTAG_CODE

PERMANENT_TAG_NUMBER Unique user defined or system generated one-up number for this asset. VARCHAR2(63)

FFBMAST

FFBMAST_PTAG_CODE

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

SEQUENCE_NUMBER System-generated one-up number to support split accounting within a document. NUMBER

FFRADJA

FFRADJA_SEQ_NUM

TRANSACTION_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER

FFRADJA

FFRADJA_AMT

TRANSACTION_AMOUNT_ADJUSTED Actual adjustment amount used with functions for Write-Offs and Sales of Assets. NUMBER

FFRADJA

FFRADJA_ADJ_AMT

TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

FFBADJH

FFBADJH_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(255)

FFBADJH

FFBADJH_DESC



Ver: 8.0