Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_FIXED_ASSET_ADJUSTMENT

Description Source composite view contains detailed information on the adjustments of fixed assets.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACCOUNTING_SEQUENCE_NUMBER System-generated one-up number associated with an asset accounting record.    

FFRADJA

FFRADJA_MASA_SEQ_NUM

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

FFRADJA

FFRADJA_ITEM

 
APPROVAL_IND Indicates the document has met final approval.    

FFBADJH

FFBADJH_APPR_IND

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

FFRADJD

FFRADJD_AMT

 
COMPLETED_IND Indicates the fixed asset adjustment document is complete.    

FFBADJH

FFBADJH_COMPLETE_IND

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

FFBADJH

FFBADJH_DEPR_ADJ_DATE

 
DISPOSAL Code used to define method of disposal of an asset.    

FFRADJD

FFRADJD_DISP_CODE

 
DISPOSAL_DESC Disposal method description.    

FFVDISP

FFVDISP_DESC

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

FFRADJA

FFRADJA_PCT

 
DOCUMENT User-defined or system generated document number.    

FFRADJA

FFRADJA_ADJH_CODE

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

FFBADJH

FFBADJH_DOC_REF_NUM

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined.    

NA

NA

 
EQUITY_ACCOUNT Account code to record asset equity.    

FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

 
EQUITY_ACCOUNT_DESC Extracted description or title of the associated account.    

FUNCTION

F_GET_FINANCE_DESC

 
EQUITY_ACCOUNT_STATUS Extracted current status of the associated account.    

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.    

FFRADJA

FFRADJA_PERIOD

 
FISCAL_YEAR Unique identifier or code for the fiscal year.    

FUNCTION

FOFYCNV

 
FUNCTION_TYPE Function code of the adjustment action used on the asset in the document.    

FFBADJH

FFBADJH_FUNCTION_CODE

 
METHOD_OF_ACQUISITION Code used to indicate the method used to acquire the asset.    

FFRADJD

FFRADJD_ACQM_CODE

 
METHOD_OF_ACQUISITION_DESC Description of the method used to acquire the asset.    

FFVACQM

FFVACQM_DESC

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

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.    

FFRADJD

FFRADJD_NET_BOOK_VALUE_AMT

 
ORIGINATION_TAG_NUMBER System generated tag number assigned when the asset is acquired.    

FFRADJD

FFRADJD_OTAG_CODE

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

FFRADJA

FFRADJA_SEQ_NUM

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

FFRADJA

FFRADJA_AMT

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

FFRADJA

FFRADJA_ADJ_AMT

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

FFBADJH

FFBADJH_TRANS_DATE

 
TRANSACTION_DESC Accounting transaction description.    

FFBADJH

FFBADJH_DESC

 
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3