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
APPROVAL_IND	Indicates the document has met final approval.	VARCHAR2(1)	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(1)	FFBADJH	FFBADJH_COMPLETE_IND	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	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(2)	FFRADJD	FFRADJD_DISP_CODE	NO	NO
DISPOSAL_DESC	Disposal method description.	VARCHAR2(35)	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(8)	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(15)	FFBADJH	FFBADJH_DOC_REF_NUM	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
EQUITY_ACCOUNT	Account code to record asset equity.	VARCHAR2(6)	FFRADJA	FFRADJA_ACCT_CODE_CAP_EQUITY	NO	NO
EQUITY_ACCOUNT_DESC	Extracted description or title of the associated account.	VARCHAR2(35)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
EQUITY_ACCOUNT_STATUS	Extracted current status of the associated account.	VARCHAR2(1)	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(2)	FFRADJA	FFRADJA_PERIOD	NO	NO
FISCAL_YEAR	Unique identifier or code for the fiscal year.	VARCHAR2(4)	FUNCTION	FOFYCNV	NO	NO
FUNCTION_TYPE	Function code of the adjustment action used on the asset in the document.	VARCHAR2(4)	FFBADJH	FFBADJH_FUNCTION_CODE	NO	NO
METHOD_OF_ACQUISITION	Code used to indicate the method used to acquire the asset.	VARCHAR2(2)	FFRADJD	FFRADJD_ACQM_CODE	NO	NO
METHOD_OF_ACQUISITION_DESC	Description of the method used to acquire the asset.	VARCHAR2(35)	FFVACQM	FFVACQM_DESC	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	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.	NUMBER	FFRADJD	FFRADJD_NET_BOOK_VALUE_AMT	NO	NO
ORIGINATION_TAG_NUMBER	System generated tag number assigned when the asset is acquired.	VARCHAR2(9)	FFRADJD	FFRADJD_OTAG_CODE	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(35)	FFBADJH	FFBADJH_DESC	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: