Reporting View Target: FIXED_ASSET

Go To View:	RETURN TO BANNER ODS META DATA 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 Name Business Definition Database Data Type Domain Value Source Name Source Column

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

FFRADJA_MASA_SEQ_NUM

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

FFRADJA_ITEM

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

NA

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

FFBADJH_APPR_IND

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

FFRADJD_AMT

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

FFBADJH_COMPLETE_IND

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

FFBADJH_DEPR_ADJ_DATE

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

FFRADJD_DISP_CODE

DISPOSAL_DESC Disposal Description Disposal method description. VARCHAR2(255)
FFVDISP

FFVDISP_DESC

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

FFRADJA_PCT

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

FFRADJA_ADJH_CODE

DOCUMENT_REFERENCE_NUMBER 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 Equity Account Account code to record asset equity. VARCHAR2(63)
FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

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

F_GET_FINANCE_DESC

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

F_GET_FINANCE_STATUS

FISCAL_PERIOD 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 Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)
FUNCTION

FOFYCNV

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

FFBADJH_FUNCTION_CODE

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

FFRADJD_ACQM_CODE

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

FFVACQM_DESC

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

NA

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

NA

NET_BOOK_VALUE_AMOUNT 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 Origination Tag Number System generated tag number assigned when the asset is acquired. VARCHAR2(63)
FFRADJD

FFRADJD_OTAG_CODE

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

FFBMAST_PTAG_CODE

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

NA

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

FFRADJA_SEQ_NUM

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

FFRADJA_AMT

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

FFRADJA_ADJ_AMT

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

FFBADJH_TRANS_DATE

TRANSACTION_DESC Transaction Description Accounting transaction description. VARCHAR2(255)
FFBADJH

FFBADJH_DESC

Ver: 9.0

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