| Reporting View | Description | Key & Frequency | Recommended 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 | | |