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, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER
DETAIL_CODE
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.DETAIL_CODE
ACCOUNT_UID, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, 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 ID.One row per academic period per person per contract priority. PERSON_UID
ACADEMIC_PERIOD, THIRD_PARTY_UID, CONTRACT_NUMBER
ACADEMIC_PERIOD, PERSON_UID, CONTRACT_NUMBER
CONTRACT_PAYMENT_DETAIL
Contains the contract payment detail information identifying the student charges, academic period, contract number being paid by the third party contract payment transaction number.One record per third party per transaction number per contract payment transactionTHIRD_PARTY_UID, TRANSACTION_NUMBER, CONTRACT_PAYMENT_TRANSACTION
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 including 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, 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 including 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
ACADEMIC_PERIOD, INSTALLMENT_PLAN
MEMO
Contains Charge/Payment Detail Memo information.One row per pidm per transaction number.ENTITY_UID, 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 numberRECEIPT_NUMBER
ENTITY_UID
RECEIVABLE_ACCOUNT
Contains general account information for each person or organization including name, tax ID, entity category, 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.ACCOUNT_UID,TRANSACTION_NUMBER
DETAIL_CODE
ACADEMIC_PERIOD
AID_YEAR
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
STUDENT_TAX_NOTIFICATION
Contains student tax information to be reported for federal compliance regarding billed qualifed charges and scholarships or grants. Student name and demographic data sent to the federal government, tax year, person UID, tax ID, student notification status, federal notification status, qualified charges billed, qualified charges adjusted from prior years, scholarship or grant amounts, scholarship or grant amounts adjusted from prior years, and an indicator to denote the latest notification record in existance for a student's tax year.One record per person UID per tax year per ID per sequence numberTAX_YEAR, FEDERAL_REPORT_STATUS
TAX_YEAR, NOTIFICATION_STATUS
PERSON_UID, TAX_YEAR, ID,SEQUENCE_NUMBER

Source Reports:

FUNCTION
NA
STVNATN
STVSTAT
STVTERM
TBBACCT
TBBCONT
TBBCPRF
TBBCSTU
TBBDEPC
TBBDETC
TBBEACT
TBBESTU
TBBEXPT
TBBMISC
TBRACCD
TBRACCT
TBRAPPL
TBRCOLC
TBRCPDT
TBRDEPO
TBRISTL
TBRMEMO
TBRMISD
TRRACCD
TRRAPPL
TTBTAXN
TTVABDS
TTVBILL
TTVDCAT
TTVDELI
TTVDTYP
TTVECAT
TTVSRCE
TTVTBDS


Ver: 9.2