Reporting View Target: FIXED_ASSET

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

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 Local Source Local Target

ACCOUNTING_SEQUENCE_NUMBER System-generated one-up number associated with an asset accounting record. NUMBER
FFRADJA

FFRADJA_MASA_SEQ_NUM

NO
NO

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

FFRADJA_ITEM

NO
NO

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

NA

NO
NO

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

FFBADJH_APPR_IND

NO
NO

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

FFRADJD_AMT

NO
NO

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

FFBADJH_COMPLETE_IND

NO
NO

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

FFBADJH_DEPR_ADJ_DATE

NO
NO

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

FFRADJD_DISP_CODE

NO
NO

DISPOSAL_DESC Disposal method description. VARCHAR2(255)
FFVDISP

FFVDISP_DESC

NO
NO

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

FFRADJA_PCT

NO
NO

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

FFRADJA_ADJH_CODE

NO
NO

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

NO
NO

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

FFRADJA_ACCT_CODE_CAP_EQUITY

NO
NO

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

F_GET_FINANCE_DESC

NO
NO

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

F_GET_FINANCE_STATUS

NO
NO

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

NO
NO

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

FOFYCNV

NO
NO

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

FFBADJH_FUNCTION_CODE

NO
NO

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

FFRADJD_ACQM_CODE

NO
NO

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

FFVACQM_DESC

NO
NO

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

NA

NO
NO

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

NA

NO
NO

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

NO
NO

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

FFRADJD_OTAG_CODE

NO
NO

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

FFBMAST_PTAG_CODE

NO
NO

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

NA

NO
NO

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

FFRADJA_SEQ_NUM

NO
NO

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

FFRADJA_AMT

NO
NO

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

FFRADJA_ADJ_AMT

NO
NO

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

FFBADJH_TRANS_DATE

NO
NO

TRANSACTION_DESC Accounting transaction description. VARCHAR2(255)
FFBADJH

FFBADJH_DESC

NO
NO

Ver: 9.2

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	Local Source	Local Target
ACCOUNTING_SEQUENCE_NUMBER	System-generated one-up number associated with an asset accounting record.	NUMBER	FFRADJA	FFRADJA_MASA_SEQ_NUM	NO	NO
ACCOUNT_ITEM	System-generated one-up number associated with an asset being adjusted in the document.	NUMBER	FFRADJA	FFRADJA_ITEM	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(63)	FFBADJH	FFBADJH_APPR_IND	NO	NO
ASSET_AMOUNT	Amount entered by the user to determine the sale price of an asset or an adjustment.	NUMBER	FFRADJD	FFRADJD_AMT	NO	NO
COMPLETED_IND	Indicates the fixed asset adjustment document is complete.	VARCHAR2(63)	FFBADJH	FFBADJH_COMPLETE_IND	NO	NO
DEPRECIATION_ADJUSTMENT_DATE	Depreciation adjustment date defaults from the adjustment transaction date for every function processed.	DATE	FFBADJH	FFBADJH_DEPR_ADJ_DATE	NO	NO
DISPOSAL	Code used to define method of disposal of an asset.	VARCHAR2(63)	FFRADJD	FFRADJD_DISP_CODE	NO	NO
DISPOSAL_DESC	Disposal method description.	VARCHAR2(255)	FFVDISP	FFVDISP_DESC	NO	NO
DISTRIBUTION_PERCENT	Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER	FFRADJA	FFRADJA_PCT	NO	NO
DOCUMENT	User-defined or system generated document number.	VARCHAR2(63)	FFRADJA	FFRADJA_ADJH_CODE	NO	NO
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	NO	NO
EQUITY_ACCOUNT	Account code to record asset equity.	VARCHAR2(63)	FFRADJA	FFRADJA_ACCT_CODE_CAP_EQUITY	NO	NO
EQUITY_ACCOUNT_DESC	Extracted description or title of the associated account.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
EQUITY_ACCOUNT_STATUS	Extracted current status of the associated account.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
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	NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV	NO	NO
FUNCTION_TYPE	Function code of the adjustment action used on the asset in the document.	VARCHAR2(63)	FFBADJH	FFBADJH_FUNCTION_CODE	NO	NO
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(63)	FFRADJD	FFRADJD_ACQM_CODE	NO	NO
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(255)	FFVACQM	FFVACQM_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(63)	FFRADJD	FFRADJD_OTAG_CODE	NO	NO
PERMANENT_TAG_NUMBER	Unique user defined or system generated one-up number for this asset.	VARCHAR2(63)	FFBMAST	FFBMAST_PTAG_CODE	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SEQUENCE_NUMBER	System-generated one-up number to support split accounting within a document.	NUMBER	FFRADJA	FFRADJA_SEQ_NUM	NO	NO
TRANSACTION_AMOUNT	Amount of the transaction associated with this particular account distribution.	NUMBER	FFRADJA	FFRADJA_AMT	NO	NO
TRANSACTION_AMOUNT_ADJUSTED	Actual adjustment amount used with functions for Write-Offs and Sales of Assets.	NUMBER	FFRADJA	FFRADJA_ADJ_AMT	NO	NO
TRANSACTION_DATE	Date used by the finance system to control posting to the ledgers.	DATE	FFBADJH	FFBADJH_TRANS_DATE	NO	NO
TRANSACTION_DESC	Accounting transaction description.	VARCHAR2(255)	FFBADJH	FFBADJH_DESC	NO	NO