Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Asset Amount	Amount entered by the user to determine the sale price of an asset or an adjustment.	NUMBER(17,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 Amount	Net book value of the asset calculated by the system as asset cost, less depreciation, plus or minus any asset adjustments.	NUMBER(17,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	Transaction Amount	Amount of the transaction associated with this particular account distribution.	NUMBER(17,2)		FFRADJA	FFRADJA_AMT
TRANSACTION_AMOUNT_ADJUSTED	Transaction Amount Adjusted	Actual adjustment amount used with functions for Write-Offs and Sales of Assets.	NUMBER(17,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: