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
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	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	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	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	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(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: