Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACCOUNTING_SEQUENCE_NUMBER
|
Accounting Sequence Number
|
System-generated one-up number associated with an asset accounting record.
|
NUMBER
|
FFRADJA
|
FFRADJA_MASA_SEQ_NUM
|
ACCOUNT_ITEM
|
Account Item
|
System-generated one-up number associated with an asset being adjusted in the document.
|
NUMBER
|
FFRADJA
|
FFRADJA_ITEM
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
APPROVAL_IND
|
Approval Indicator
|
Indicates the document has met final approval.
|
VARCHAR2(63)
|
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
|
FFRADJD
|
FFRADJD_AMT
|
COMPLETED_IND
|
Completed Indicator
|
Indicates the fixed asset adjustment document is complete.
|
VARCHAR2(63)
|
FFBADJH
|
FFBADJH_COMPLETE_IND
|
DEPRECIATION_ADJUSTMENT_DATE
|
Depreciation Adjustment Date
|
Depreciation adjustment date defaults from the adjustment transaction date for every function processed.
|
DATE
|
FFBADJH
|
FFBADJH_DEPR_ADJ_DATE
|
DISPOSAL
|
Disposal
|
Code used to define method of disposal of an asset.
|
VARCHAR2(63)
|
FFRADJD
|
FFRADJD_DISP_CODE
|
DISPOSAL_DESC
|
Disposal Description
|
Disposal method description.
|
VARCHAR2(255)
|
FFVDISP
|
FFVDISP_DESC
|
DISTRIBUTION_PERCENT
|
Distribution Percent
|
Percentage of the of the transaction total amount assigned to this accounting distribution.
|
NUMBER
|
FFRADJA
|
FFRADJA_PCT
|
DOCUMENT
|
Document
|
User-defined or system generated document number.
|
VARCHAR2(63)
|
FFRADJA
|
FFRADJA_ADJH_CODE
|
DOCUMENT_REFERENCE_NUMBER
|
Document Reference Number
|
User-defined identification number further identifying this document and linking it to an external reference number.
|
VARCHAR2(63)
|
FFBADJH
|
FFBADJH_DOC_REF_NUM
|
EQUITY_ACCOUNT
|
Equity Account
|
Account code to record asset equity.
|
VARCHAR2(63)
|
FFRADJA
|
FFRADJA_ACCT_CODE_CAP_EQUITY
|
EQUITY_ACCOUNT_DESC
|
Equity Account Description
|
Extracted description or title of the associated account.
|
VARCHAR2(255)
|
FUNCTION
|
F_GET_FINANCE_DESC
|
EQUITY_ACCOUNT_STATUS
|
Equity Account Status
|
Extracted current status of the associated account.
|
VARCHAR2(63)
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
FISCAL_PERIOD
|
Fiscal Period
|
Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.
|
VARCHAR2(63)
|
FFRADJA
|
FFRADJA_PERIOD
|
FISCAL_YEAR
|
Fiscal Year
|
Unique identifier or code for the fiscal year.
|
VARCHAR2(63)
|
FUNCTION
|
FOFYCNV
|
FUNCTION_TYPE
|
Function Type
|
Function code of the adjustment action used on the asset in the document.
|
VARCHAR2(63)
|
FFBADJH
|
FFBADJH_FUNCTION_CODE
|
METHOD_OF_ACQUISITION
|
Method Of Acquisition
|
Code used to indicate the method used to acquire the asset.
|
VARCHAR2(63)
|
FFRADJD
|
FFRADJD_ACQM_CODE
|
METHOD_OF_ACQUISITION_DESC
|
Method Of Acquisition Description
|
Description of the method used to acquire the asset.
|
VARCHAR2(255)
|
FFVACQM
|
FFVACQM_DESC
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
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. This amount is used to determine any gain or loss on the asset when it is sold.
|
NUMBER
|
FFRADJD
|
FFRADJD_NET_BOOK_VALUE_AMT
|
ORIGINATION_TAG_NUMBER
|
Origination Tag Number
|
System generated tag number assigned when the asset is acquired.
|
VARCHAR2(63)
|
FFRADJD
|
FFRADJD_OTAG_CODE
|
PERMANENT_TAG_NUMBER
|
Permanent Tag Number
|
Unique user defined or system generated one-up number for this asset.
|
VARCHAR2(63)
|
FFBMAST
|
FFBMAST_PTAG_CODE
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
SEQUENCE_NUMBER
|
Sequence Number
|
System-generated one-up number to support split accounting within a document.
|
NUMBER
|
FFRADJA
|
FFRADJA_SEQ_NUM
|
TRANSACTION_AMOUNT
|
Transaction Amount
|
Amount of the transaction associated with this particular account distribution.
|
NUMBER
|
FFRADJA
|
FFRADJA_AMT
|
TRANSACTION_AMOUNT_ADJUSTED
|
Transaction Amount Adjusted
|
Actual adjustment amount used with functions for Write-Offs and Sales of Assets.
|
NUMBER
|
FFRADJA
|
FFRADJA_ADJ_AMT
|
TRANSACTION_DATE
|
Transaction Date
|
Date used by the finance system to control posting to the ledgers.
|
DATE
|
FFBADJH
|
FFBADJH_TRANS_DATE
|
TRANSACTION_DESC
|
Transaction Description
|
Accounting transaction description.
|
VARCHAR2(255)
|
FFBADJH
|
FFBADJH_DESC
|