Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCOUNT		Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer.	VARCHAR2(6)		FGBTRND	FGBTRND_ACCT_CODE
ACCOUNT_INDEX		Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns.	VARCHAR2(6)		FGBTRND	FGBTRND_ACCI_CODE
ACCRUAL_IND		Indicator used during the accrual period to determine if the system automatically generates transactions for both current and prior fiscal years.	VARCHAR2(1)		FGBTRNH	FGBTRNH_ACCRUAL_IND
ACTIVITY		Code used to identify accounting data by activity.	VARCHAR2(6)		FGBTRND	FGBTRND_ACTV_CODE
ACTIVITY_DATE		Date that information for this record in the table was entered or last updated.	DATE		FGBTRND	FGBTRND_ACTIVITY_DATE
ACTIVITY_DESC		Activity code title or description.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ACTIVITY_STATUS		Extracted current status of the associated activity.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
AMOUNT_IND		Indicates the amount was posted.	VARCHAR2(1)		FGBTRND	FGBTRND_AMT_IND
AUTO_JOURNAL_ID		User-defined value providing unique identification for a recurring journal voucher.	VARCHAR2(3)		FGBTRNH	FGBTRNH_AUTO_JRNL_ID
AVAILABLE_BUDGET_OVERRIDE		Indicates if available fund checking was overridden when a lack of funds condition existed.	VARCHAR2(1)		FGBTRNH	FGBTRNH_ABAL_OVERRIDE
BANK		Code used to identify the bank account on all cash transactions.	VARCHAR2(2)		FGBTRNH	FGBTRNH_BANK_CODE
BANK_DESC		Name of the bank where the institution has accounts.	VARCHAR2(35)		GXVBANK	GXVBANK_ACCT_NAME
BANK_UID		Internal identification number of the bank used at the time the transaction occurred.	NUMBER(8)		GXVBANK	GXVBANK_BANK_CODE_PIDM
BUDGET_DISPOSITION		Indicator that determines the year-end processing or budget requested encumbrance amounts.	VARCHAR2(1)		FGBTRNH	FGBTRNH_BUD_DISPN
BUDGET_ID		User-defined unique identification of the budget identifier. Generally Fiscal year for which the budget is being prepared.	VARCHAR2(6)		FGBTRND	FGBTRND_BUD_ID
BUDGET_PERIOD		Numeric value of the budget period being entered if this is a budget journal.	VARCHAR2(2)		FGBTRNH	FGBTRNH_BUDGET_PERIOD
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FGBTRND	FGBTRND_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_POOL		Code that denotes the pool chart of account that the investment fund code is participating.	VARCHAR2(1)		FGBTRNH	FGBTRNH_COAS_CODE_POOL
CHART_OF_ACCOUNTS_POOL_DESC		Retrieved description or title of the associated chart of accounts.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_POOL_STATUS		Retrieved current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
CHART_OF_ACCOUNTS_STATUS		Extracted current status of the associated chart of accounts.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
COMMIT_PERCENT		Percentage of budget to be rolled into the next fiscal year as committed funds.	NUMBER(6, 3)		FGBTRND	FGBTRND_CMT_PCT
COMMIT_TYPE		Indicates whether a line item represents funds committed from the prior year budget. U=uncommitted or C=committed.	VARCHAR2(1)		FGBTRND	FGBTRND_CMT_TYPE
CONVERT_AMOUNT	Converted Amount	Base currency amount calculated for this accounting record.	NUMBER(17,2)		FGBTRNH	FGBTRNH_CONVERT_AMT
COST_SHARE_RATE		Cost share rate for this grant.	NUMBER(7, 4)		FGBTRND	FGBTRND_CS_RATE_PERCENT
CURRENCY		Type of currency represented in the amount field.	VARCHAR2(4)		FGBTRNH	FGBTRNH_CURR_CODE
CURRENCY_DESC		Currency code description or title.	VARCHAR2(35)		GTVCURR	GTVCURR_TITLE
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DEBIT_CREDIT_IND		Determines a debit or credit effect on the ledgers; plus or minus, debit or credit.	VARCHAR2(1)		FGBTRND	FGBTRND_DR_CR_IND
DEPOSIT_NUMBER		Deposit number assigned to this transaction.	VARCHAR2(8)		FGBTRNH	FGBTRNH_DEP_NUM
DETAIL_BUDGET_PERIOD		Numeric value of the budget period used if this is a budget journal.	VARCHAR2(2)		FGBTRND	FGBTRND_BUDGET_PERIOD
DETAIL_POSTING_PROCESS		Code that identifies what accounting actions are to be taken with the ledgers.	VARCHAR2(4)		FGBTRND	FGBTRND_PROC_CODE
DETAIL_POSTING_PROCESS_DESC		Retrieves description for posting process.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
DETAIL_PROJECT		Work order code associated with the transaction.	VARCHAR2(8)		FGBTRND	FGBTRND_PRJD_CODE
DETAIL_REVERSAL_IND		Indicates if a document was canceled or reversed.	VARCHAR2(1)		FGBTRND	FGBTRND_REVERSAL_IND
DETAIL_SERIAL_NUMBER		Unique system assigned number to control unique creation of transaction source history records.	NUMBER(3)		FGBTRND	FGBTRND_SERIAL_NUM
DETAIL_SUM_POST_DOC_CODE		Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(8)		FGBTRND	FGBTRND_SUM_POST_DOC_CODE
DETAIL_USER_ID		Unique identification code of the user who entered the transaction.	VARCHAR2(30)		FGBTRND	FGBTRND_USER_ID
DIRECT_INDIRECT_IND		This field specifies the direct/indirect indicator.	VARCHAR2(1)		NA	NA
DISTRIBUTION_PERCENT		Percentage of the of the transaction total amount assigned to this accounting distribution.	NUMBER(6, 3)		FGBTRNH	FGBTRNH_DIST_PCT
DOCUMENT		User-defined or system generated document number.	VARCHAR2(8)		FGBTRNH	FGBTRNH_DOC_CODE
DOCUMENT_DATE		Document date.	DATE		NA	NA
DOCUMENT_TYPE		Unique identifier that internally defines document types or entities associated to this text.	NUMBER(2)		FGBTRNH	FGBTRNH_DOC_SEQ_CODE
DOCUMENT_TYPE_DESC		Document/entity type description.	VARCHAR2(35)		FTVDTYP	FTVDTYP_DESC
DOC_REFERENCE_NUMBER		User-defined number providing additional identification for the transaction.	VARCHAR2(8)		FGBTRNH	FGBTRNH_DOC_REF_NUM
DOC_REFERENCE_NUMBER2		The second user-defined number providing additional identification for the transaction.	VARCHAR2(1)		NA	NA
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ENCUMBRANCE_ACTION_IND		Liquidation action on encumbrances as partial, total, adjustment or original.	VARCHAR2(1)		FGBTRNH	FGBTRNH_ENCD_ACTION_IND
ENCUMBRANCE_ITEM_NUMBER		Number associated with each individual commodity on the encumbering document.	NUMBER(4)		FGBTRND	FGBTRND_ENCD_ITEM_NUM
ENCUMBRANCE_NUMBER		Unique encumbrance code of a document.	VARCHAR2(8)		FGBTRND	FGBTRND_ENCD_NUM
ENCUMBRANCE_SEQ_NUMBER		Number associated with each accounting distribution on an encumbering document.	NUMBER(4)		FGBTRND	FGBTRND_ENCD_SEQ_NUM
ENCUMBRANCE_TYPE		Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.	VARCHAR2(1)		FGBTRNH	FGBTRNH_ENCB_TYPE
EXCHANGE_AMOUNT	Exchange Amount	Exchange amount is the difference between the input transaction amount and the converted amount. Is used to balance the exchange accounts associated to each currency code.	NUMBER(17,2)		FGBTRNH	FGBTRNH_EXCHANGE_AMT
EXCHANGE_DIFFERENCE	Exchange Difference	Difference between the exchange amounts from when the invoice is recorded to when the check is written. Is also used to balance the exchange accounts associated to each currency code.	NUMBER(17,2)		FGBTRNH	FGBTRNH_EXCHANGE_DIFF
FIELD_CODE		Two-digit code that represents the specific ledger bucket being updated.	VARCHAR2(2)		FGBTRND	FGBTRND_FIELD_CODE
FISCAL_PERIOD_HEADER	Fiscal Period Header		VARCHAR2(2)
FISCAL_YEAR		Unique identifier or code for the fiscal year.	VARCHAR2(4)		CALCULATION	TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'),'YYYY')
FISCAL_YEAR_HEADER		A unique identifier code for the fiscal year being defined. Function fofyncv returns a four-digit year when supplied a two-digit year. This field is from the Transaction History table.	VARCHAR2(4)		CALCULATION	TO_CHAR(TO_DATE(FGBTRNH_FSYR_CODE,'RR'),'YYYY')
FISCAL_YEAR_TWO_CHAR		A unique identifier code for the fiscal year being defined. This field is from the Transaction History table and is not expanded.	VARCHAR2(2)		FGBTRNH	FGBTRNH_FSYR_CODE
FUND		Unique fiscal entity code.	VARCHAR2(6)		FGBTRND	FGBTRND_FUND_CODE
FUND_POOL		Code that denotes the pool fund that the investment fund code is participating.	VARCHAR2(6)		FGBTRNH	FGBTRNH_FUND_CODE_POOL
FUND_POOL_DESC		Transaction fund description.	VARCHAR2(35)		FTVFUND	FTVFUND_TITLE
FUND_POOL_STATUS		Extracted current status of the associated fund.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
INDIRECT_COST_MEMO_RATE		Indirect cost memo rate percentage.	NUMBER(7, 4)		FGBTRND	FGBTRND_IC_MEMO_RATE_PERCENT
INDIRECT_COST_RATE		Indirect cost rate percentage for the grant fund.	NUMBER(7, 4)		FGBTRND	FGBTRND_IC_RATE_PERCENT
ITEM		System-generated line item number that identifies each commodity line item for procurement documents.	NUMBER(4)		FGBTRNH	FGBTRNH_ITEM_NUM
LEDGER_IND		One-position field that indicates if the ledger updated by this transaction was the encumbrance, general or operating (subsidiary) ledger.	VARCHAR2(1)		FGBTRND	FGBTRND_LEDGER_IND
LIQUIDATION_AMOUNT		Liquidation amount.	NUMBER		NA	NA
LOCATION		Identification accounting code of the physical location of the financial manager.	VARCHAR2(6)		FGBTRND	FGBTRND_LOCN_CODE
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
ORGANIZATION_CODE		Identification accounting code used for the department.	VARCHAR2(6)		FGBTRND	FGBTRND_ORGN_CODE
OTHER_DATA		User-defined free-form description.	VARCHAR2(30)		FGBTRND	FGBTRND_OTHER_DATA
POSTING_PERIOD		Unique two-digit identifier of a period posted to with amounts within a fiscal year. Generally this contains values between 00 and 14.	VARCHAR2(2)		FGBTRND	FGBTRND_POSTING_PERIOD
PROGRAM		Identification accounting code use to identify the program classification structure or a subset or that structure as defined by the national council of higher education management systems.	VARCHAR2(6)		FGBTRND	FGBTRND_PROG_CODE
PROJECT		Work order code used within cost accounting module.	VARCHAR2(8)		FGBTRNH	FGBTRNH_PRJD_CODE
RECONCILIATION_IND		Indicates if a deposit has been reconciled.	VARCHAR2(1)		FGBTRND	FGBTRND_RECON_IND
REVERSAL_IND		Indicates if a document was canceled or reversed.	VARCHAR2(1)		FGBTRNH	FGBTRNH_REVERSAL_IND
RULE_CLASS		Accounting transaction code defining rules used to control transaction updates to the ledgers.	VARCHAR2(4)		FGBTRND	FGBTRND_RUCL_CODE
RULE_CLASS_DESC		Unique title assigned to a rule class.	VARCHAR2(35)		FTVRUCL	FTVRUCL_CLASS_TITLE
RULE_PROCESS		Four-digit field that is an assigned sequence number to each process within a rule code.	VARCHAR2(4)		FGBTRND	FGBTRND_RULP_CODE
SEQUENCE_NUMBER		System-generated one-up number to support split accounting within a document.	NUMBER(4)		FGBTRNH	FGBTRNH_SEQ_NUM
SERIAL_NUMBER		Unique system assigned number to control unique creation of transaction source history records.	NUMBER(3)		FGBTRNH	FGBTRNH_SERIAL_NUM
SUBMISSION_NUMBER		Submission number used for documents that utilized resubmission features.	NUMBER(3)		FGBTRNH	FGBTRNH_SUBMISSION_NUMBER
SUM_POSTING_DOCUMENT_CODE		Document number generated in a given posting run to facilitate summary general ledger postings. Format is MMDDHHMM.	VARCHAR2(8)		FGBTRNH	FGBTRNH_SUM_POST_DOC_CODE
TRANSACTION_AMOUNT	Transaction Amount	Amount of the transaction associated with this particular account distribution.	NUMBER(17,2)		FGBTRND	FGBTRND_TRANS_AMT
TRANSACTION_DATE		Date used by the finance system to control posting to the ledgers.	DATE		FGBTRNH	FGBTRNH_TRANS_DATE
TRANSACTION_DESC		Accounting transaction description.	VARCHAR2(35)		FGBTRNH	FGBTRNH_TRANS_DESC
USER_ID		Unique identification code of the user who entered the transaction.	VARCHAR2(30)		FGBTRNH	FGBTRNH_USER_ID
VENDOR_UID		System generated unique internal identification number used to access the vendor.	NUMBER(8)		FGBTRNH	FGBTRNH_VENDOR_PIDM
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: