Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

Banner Operational Data Store
Composite View Target: AF_TRANSACTION_HISTORY

Description Source composite view contains all source detail transactions used to update the ledgers.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(6)

FGBTRND

FGBTRND_ACCT_CODE

NO

NO
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

NO

NO
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

NO

NO
ACTIVITY Code used to identify accounting data by activity. VARCHAR2(6)

FGBTRND

FGBTRND_ACTV_CODE

NO

NO
ACTIVITY_DATE Date that information for this record in the table was entered or last updated. DATE

FGBTRND

FGBTRND_ACTIVITY_DATE

NO

NO
ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
AMOUNT_IND Indicates the amount was posted. VARCHAR2(1)

FGBTRND

FGBTRND_AMT_IND

NO

NO
AUTO_JOURNAL_ID User-defined value providing unique identification for a recurring journal voucher. VARCHAR2(3)

FGBTRNH

FGBTRNH_AUTO_JRNL_ID

NO

NO
AVAILABLE_BUDGET_OVERRIDE Indicates if available fund checking was overridden when a lack of funds condition existed. VARCHAR2(1)

FGBTRNH

FGBTRNH_ABAL_OVERRIDE

NO

NO
BANK Code used to identify the bank account on all cash transactions. VARCHAR2(2)

FGBTRNH

FGBTRNH_BANK_CODE

NO

NO
BANK_DESC Name of the bank where the institution has accounts. VARCHAR2(35)

GXVBANK

GXVBANK_ACCT_NAME

NO

NO
BANK_UID Internal identification number of the bank used at the time the transaction occurred. NUMBER

GXVBANK

GXVBANK_BANK_CODE_PIDM

NO

NO
BUDGET_DISPOSITION Indicator that determines the year-end processing or budget requested encumbrance amounts. VARCHAR2(1)

FGBTRNH

FGBTRNH_BUD_DISPN

NO

NO
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

NO

NO
BUDGET_PERIOD Numeric value of the budget period being entered if this is a budget journal. VARCHAR2(2)

FGBTRNH

FGBTRNH_BUDGET_PERIOD

NO

NO
CHART_OF_ACCOUNTS Identifies the chart from other charts in a multi-chart environment. VARCHAR2(1)

FGBTRND

FGBTRND_COAS_CODE

NO

NO
CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
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

NO

NO
CHART_OF_ACCOUNTS_POOL_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

NO

NO
CHART_OF_ACCOUNTS_POOL_STATUS Retrieved current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
CHART_OF_ACCOUNTS_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
COMMIT_PERCENT Percentage of budget to be rolled into the next fiscal year as committed funds. NUMBER

FGBTRND

FGBTRND_CMT_PCT

NO

NO
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

NO

NO
CONVERT_AMOUNT Base currency amount calculated for this accounting record. NUMBER

FGBTRNH

FGBTRNH_CONVERT_AMT

NO

NO
COST_SHARE_RATE Cost share rate for this grant. NUMBER

FGBTRND

FGBTRND_CS_RATE_PERCENT

NO

NO
CURRENCY Type of currency represented in the amount field. VARCHAR2(4)

FGBTRNH

FGBTRNH_CURR_CODE

NO

NO
CURRENCY_DESC Currency code description or title. VARCHAR2(35)

GTVCURR

GTVCURR_TITLE

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
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

NO

NO
DEPOSIT_NUMBER Deposit number assigned to this transaction. VARCHAR2(8)

FGBTRNH

FGBTRNH_DEP_NUM

NO

NO
DETAIL_BUDGET_PERIOD Numeric value of the budget period used if this is a budget journal. VARCHAR2(2)

FGBTRND

FGBTRND_BUDGET_PERIOD

NO

NO
DETAIL_POSTING_PROCESS Code that identifies what accounting actions are to be taken with the ledgers. VARCHAR2(4)

FGBTRND

FGBTRND_PROC_CODE

NO

NO
DETAIL_POSTING_PROCESS_DESC Retrieves description for posting process. VARCHAR2(35)

FUNCTION

FOKODSF.F_GET_SDAT_TITLE

NO

NO
DETAIL_PROJECT Work order code associated with the transaction. VARCHAR2(8)

FGBTRND

FGBTRND_PRJD_CODE

NO

NO
DETAIL_REVERSAL_IND Indicates if a document was canceled or reversed. VARCHAR2(1)

FGBTRND

FGBTRND_REVERSAL_IND

NO

NO
DETAIL_SERIAL_NUMBER Unique system assigned number to control unique creation of transaction source history records. NUMBER

FGBTRND

FGBTRND_SERIAL_NUM

NO

NO
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

NO

NO
DETAIL_USER_ID Unique identification code of the user who entered the transaction. VARCHAR2(30)

FGBTRND

FGBTRND_USER_ID

NO

NO
DIRECT_INDIRECT_IND This field specifies the direct/indirect indicator. VARCHAR2(1)

NA

NA

NO

NO
DISTRIBUTION_PERCENT Percentage of the of the transaction total amount assigned to this accounting distribution. NUMBER

FGBTRNH

FGBTRNH_DIST_PCT

NO

NO
DOCUMENT User-defined or system generated document number. VARCHAR2(8)

FGBTRNH

FGBTRNH_DOC_CODE

NO

NO
DOCUMENT_DATE Document date. DATE

NA

NA

NO

NO
DOCUMENT_TYPE Unique identifier that internally defines document types or entities associated to this text. NUMBER

FGBTRNH

FGBTRNH_DOC_SEQ_CODE

NO

NO
DOCUMENT_TYPE_DESC Document/entity type description. VARCHAR2(35)

FTVDTYP

FTVDTYP_DESC

NO

NO
DOC_REFERENCE_NUMBER User-defined number providing additional identification for the transaction. VARCHAR2(8)

FGBTRNH

FGBTRNH_DOC_REF_NUM

NO

NO
DOC_REFERENCE_NUMBER2 The second user-defined number providing additional identification for the transaction. VARCHAR2(1)

NA

NA

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
ENCUMBRANCE_ACTION_IND Liquidation action on encumbrances as partial, total, adjustment or original. VARCHAR2(1)

FGBTRNH

FGBTRNH_ENCD_ACTION_IND

NO

NO
ENCUMBRANCE_ITEM_NUMBER Number associated with each individual commodity on the encumbering document. NUMBER

FGBTRND

FGBTRND_ENCD_ITEM_NUM

NO

NO
ENCUMBRANCE_NUMBER Unique encumbrance code of a document. VARCHAR2(8)

FGBTRND

FGBTRND_ENCD_NUM

NO

NO
ENCUMBRANCE_SEQ_NUMBER Number associated with each accounting distribution on an encumbering document. NUMBER

FGBTRND

FGBTRND_ENCD_SEQ_NUM

NO

NO
ENCUMBRANCE_TYPE Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition. VARCHAR2(1)

FGBTRNH

FGBTRNH_ENCB_TYPE

NO

NO
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

FGBTRNH

FGBTRNH_EXCHANGE_AMT

NO

NO
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

FGBTRNH

FGBTRNH_EXCHANGE_DIFF

NO

NO
FIELD_CODE Two-digit code that represents the specific ledger bucket being updated. VARCHAR2(2)

FGBTRND

FGBTRND_FIELD_CODE

NO

NO
FISCAL_PERIOD_HEADER   VARCHAR2(2)       NO
FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

CALCULATION

TO_CHAR(TO_DATE(FGBTRND_FSYR_CODE,'RR'),'YYYY')

NO

NO
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')

NO

NO
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

NO

NO
FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(6)

FGBTRND

FGBTRND_FUND_CODE

NO

NO
FUND_POOL Code that denotes the pool fund that the investment fund code is participating. VARCHAR2(6)

FGBTRNH

FGBTRNH_FUND_CODE_POOL

NO

NO
FUND_POOL_DESC Transaction fund description. VARCHAR2(35)

FTVFUND

FTVFUND_TITLE

NO

NO
FUND_POOL_STATUS Extracted current status of the associated fund. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

NO

NO
INDIRECT_COST_MEMO_RATE Indirect cost memo rate percentage. NUMBER

FGBTRND

FGBTRND_IC_MEMO_RATE_PERCENT

NO

NO
INDIRECT_COST_RATE Indirect cost rate percentage for the grant fund. NUMBER

FGBTRND

FGBTRND_IC_RATE_PERCENT

NO

NO
ITEM System-generated line item number that identifies each commodity line item for procurement documents. NUMBER

FGBTRNH

FGBTRNH_ITEM_NUM

NO

NO
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

NO

NO
LIQUIDATION_AMOUNT Liquidation amount. NUMBER

NA

NA

NO

NO
LOCATION Identification accounting code of the physical location of the financial manager. VARCHAR2(6)

FGBTRND

FGBTRND_LOCN_CODE

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
ORGANIZATION_CODE Identification accounting code used for the department. VARCHAR2(6)

FGBTRND

FGBTRND_ORGN_CODE

NO

NO
OTHER_DATA User-defined free-form description. VARCHAR2(30)

FGBTRND

FGBTRND_OTHER_DATA

NO

NO
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

NO

NO
PROGRAM Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(6)

FGBTRND

FGBTRND_PROG_CODE

NO

NO
PROJECT Work order code used within cost accounting module. VARCHAR2(8)

FGBTRNH

FGBTRNH_PRJD_CODE

NO

NO
RECONCILIATION_IND Indicates if a deposit has been reconciled. VARCHAR2(1)

FGBTRND

FGBTRND_RECON_IND

NO

NO
REVERSAL_IND Indicates if a document was canceled or reversed. VARCHAR2(1)

FGBTRNH

FGBTRNH_REVERSAL_IND

NO

NO
RULE_CLASS Accounting transaction code defining rules used to control transaction updates to the ledgers. VARCHAR2(4)

FGBTRND

FGBTRND_RUCL_CODE

NO

NO
RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(35)

FTVRUCL

FTVRUCL_CLASS_TITLE

NO

NO
RULE_PROCESS Four-digit field that is an assigned sequence number to each process within a rule code. VARCHAR2(4)

FGBTRND

FGBTRND_RULP_CODE

NO

NO
SEQUENCE_NUMBER System-generated one-up number to support split accounting within a document. NUMBER

FGBTRNH

FGBTRNH_SEQ_NUM

NO

NO
SERIAL_NUMBER Unique system assigned number to control unique creation of transaction source history records. NUMBER

FGBTRNH

FGBTRNH_SERIAL_NUM

NO

NO
SUBMISSION_NUMBER Submission number used for documents that utilized resubmission features. NUMBER

FGBTRNH

FGBTRNH_SUBMISSION_NUMBER

NO

NO
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

NO

NO
TRANSACTION_AMOUNT Amount of the transaction associated with this particular account distribution. NUMBER

FGBTRND

FGBTRND_TRANS_AMT

NO

NO
TRANSACTION_DATE Date used by the finance system to control posting to the ledgers. DATE

FGBTRNH

FGBTRNH_TRANS_DATE

NO

NO
TRANSACTION_DESC Accounting transaction description. VARCHAR2(35)

FGBTRNH

FGBTRNH_TRANS_DESC

NO

NO
USER_ID Unique identification code of the user who entered the transaction. VARCHAR2(30)

FGBTRNH

FGBTRNH_USER_ID

NO

NO
VENDOR_UID System generated unique internal identification number used to access the vendor. NUMBER

FGBTRNH

FGBTRNH_VENDOR_PIDM

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: