RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Operational Data Store
Composite View Target: AF_FIXED_ASSET_ADJUSTMENT

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

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(4)

FFRADJA

FFRADJA_MASA_SEQ_NUM

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

FFRADJA

FFRADJA_ITEM

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

FFBADJH

FFBADJH_APPR_IND

ASSET_AMOUNT Amount entered by the user to determine the sale price of an asset or an adjustment. NUMBER(12, 2)

FFRADJD

FFRADJD_AMT

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

FFBADJH

FFBADJH_COMPLETE_IND

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

NA

SYSDATE

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(2)

FFRADJD

FFRADJD_DISP_CODE

DISPOSAL_DESC Disposal method description. VARCHAR2(35)

FFVDISP

FFVDISP_DESC

DISTRIBUTION_PERCENT Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER(7, 4)

FFRADJA

FFRADJA_PCT

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

FFRADJA

FFRADJA_ADJH_CODE

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

FFBADJH

FFBADJH_DOC_REF_NUM

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

NA

NA

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

FFRADJA

FFRADJA_ACCT_CODE_CAP_EQUITY

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

FUNCTION

F_GET_FINANCE_DESC

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

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(2)

FFRADJA

FFRADJA_PERIOD

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

FUNCTION

FOFYCNV

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

FFBADJH

FFBADJH_FUNCTION_CODE

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

FFRADJD

FFRADJD_ACQM_CODE

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

FFVACQM

FFVACQM_DESC

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

NA

NA

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

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. NUMBER(12, 2)

FFRADJD

FFRADJD_NET_BOOK_VALUE_AMT

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

FFRADJD

FFRADJD_OTAG_CODE

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

FFRADJA

FFRADJA_SEQ_NUM

TRANSACTION_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER(12, 2)

FFRADJA

FFRADJA_AMT

TRANSACTION_AMOUNT_ADJUSTED Actual adjustment amount used with functions for Write-Offs and Sales of Assets. NUMBER(12, 2)

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(35)

FFBADJH

FFBADJH_DESC

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

NA

NA



Ver: 3.1