Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST


Accounts Receivable Reporting View Meta Data Reports

Target Reports:

Reporting ViewDescriptionKey & FrequencyRecommended Search Columns
APPLICATION_OF_PAYMENT
Contains accounts receivable information for payments applied to charges Reporting can be by the payment transaction number, charge transaction number, applied amount, posting document, cashier, and session information.Multiple rows per account per payment transaction.ACCOUNT_UID
ACCOUNT_UID, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER
APPL_OF_PAY_DETAIL_ACCOUNTING
Contains accounting information sent to Finance for each payment applied to a charge on a receivable account. Multiple rows per account_id per pay_tran_number per charge_tran_number.
CONTRACT
Contains third party contract and exemption information for a student including academic period, contract number, contract description, contract expiration date, third party, detail code, and account IDOne row per academic period per person per contract priority. PERSON_UID
ACADEMIC_PERIOD, THIRD_PARTY_UID, CONTRACT_NUMBER
ACADEMIC_PERIOD, PERSON_UID, CONTRACT_NUMBER
DEPOSIT
Contains accounts receivable deposits including account ID, detail code, academic period, transaction number, original amount, balance amount, payment detail code, post cashier, deposit entry date, deposit receipt number, minimum remaining deposit amount, and posting document.One row per account per transaction number.ACCOUNT_UID, TRANSACTION_NUMBER
ACCOUNT_UID, DETAIL_CODE
EXEMPTION
Contains student exemption information inclucing academic period, account ID, exemption priority, exemption, authorized amount, amount paid, exemption payment code, detail code, and expiration date.One row per person per academic period per exemption priority.PERSON_UID
PERSON_UID, EXEMPTION
EXEMPTION, START_DATE, END_DATE, PERSON_UID
ACADEMIC_PERIOD, PERSON_UID
INSTALLMENT_PLAN
Contains installment plan information (short-term loans, tuition payment plans, etc.) for each account inlcuding installment plan reference number, academic period, number of payments, first installment date, plan amount, interest rate, and late fee amount.One row per installment reference number.ACCOUNT_UID, INSTALLMENT_PLAN
REFERENCE_NUMBER
MEMO
Contains Charge/Payment Detail Memo information.One row per pidm per transaction number.
MISCELLANEOUS_TRANSACTION
Contains miscellaneous transaction detail for receivable accounting. This includes receipt number, payment and charge detail codes, cashier, amount, transaction description, payment and charge accounting distribution, external accounting line, credit card number, posting document, person name and address. Used to track payments and charges not on a student's account.One row per receipt number per user per transaction numberENTITY_UID
RECEIPT_NUMBER
RECEIVABLE_ACCOUNT
Contains general account information for each person or non person including name, tax ID, account balance, current amount due, deposit balance, hold counts, delinquency, collection information, and credit limit.One row per account.ACCOUNT_UID
COLLECTION_AGENCY_UID
RECEIVABLE_ACCOUNTING
Contains detail code ledger accounting distribution information by effective date for debits and credits to be sent to post into the ledgers. This includes the percentage each accounting transaction is applied to on each transaction amount. Use this view joining to the detail codes by effective date in other views to determine actual accounting for reconciliation.One row per detail code per effective date.DETAIL_CODE
A_CHART_OF_ACCOUNTS, A_FUND, A_ACCOUNT
B_CHART_OF_ACCOUNTS, B_FUND, B_ACCOUNT
RECEIVABLE_ACCOUNT_DETAIL
Contains account transaction detail for all payments and charges including academic period, detail code, category, priority, entry date, transaction amount, balance, bill date, due date, post cashier, and posting document.One row per account per transaction number.ENTITY_UID
ACCOUNT_UID, TRANSACTION_NUMBER
DETAIL_CODE
ACADEMIC_PERIOD
RECEIVABLE_SUMMARY
Contains summarized totals for amount and balance by term, category and detail code.One row per academic period per category per detail code.DETAIL_CODE
ACADEMIC_PERIOD

Source Reports:

TBBACCT
TBBCONT
TBBCPRF
TBBCSHR
TBBCSTU
TBBDEPC
TBBDETC
TBBEACT
TBBESTU
TBBEXPT
TBBMISC
TBRACCD
TBRACCT
TBRAPPL
TBRCOLC
TBRDEPO
TBRISTL
TBRMEMO
TBRMISD
TRRACCD
TRRAPPL
TTVDCAT
TTVDELI
TTVDTYP
TTVSRCE


Ver: 8.0