Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Accounts Receivable Reporting View Reports

Banner Operational Data Store
Reporting View Target: RECEIVABLE_ACCOUNT_DETAIL

Description 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.
Key & Frequency One row per account per transaction number.
Recommended Search Columns ACCOUNT_UID,TRANSACTION_NUMBER
DETAIL_CODE
ACADEMIC_PERIOD
AID_YEAR

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic Period Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

TBRACCD

TBRACCD_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic Year Academic year associated with the academic period on this record. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

ACCOUNT_DETAIL_ACTIVITY_DATE Account Detail Activity Date Date that information for this record in the table was entered or last updated. DATE

TBRACCD

TBRACCD_ACTIVITY_DATE

ACCOUNT_DETAIL_DATA_ORIGIN Account Detail Data Origin Source system that last created or updated the data. VARCHAR2(63)

TBRACCD

TBRACCD_DATA_ORIGIN

ACCOUNT_DETAIL_USER_ID Account Detail User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

TBRACCD

TBRACCD_USER

ACCOUNT_POSTED_AMOUNT Account Posted Amount Amount that has been posted. NUMBER

CALCULATION

DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)

ACCOUNT_POSTING_STATUS Account Posting Status Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed. VARCHAR2(1)

TBRACCD

TBRACCD_ACCT_FEED_IND

ACCOUNT_UID Account UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

TBRACCD

TBRACCD_PIDM

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AID_ENROLLMENT_PERIOD Aid Enrollment Period Aid enrollment period associated with the financial aid disbursement. This period can span multiple student terms. VARCHAR2(15)

TBRACCD

TBRACCD_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid Enrollment Period Description Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

AID_YEAR Aid Year Aid year associated with financial aid disbursement. VARCHAR2(4)

TBRACCD

TBRACCD_AIDY_CODE

AID_YEAR_DESC Aid Year Description Aid year description. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

AMOUNT Amount Sum of the amount of each account detail for this receivable account. NUMBER

TBRACCD

TBRACCD_AMOUNT

BALANCE Balance Remaining balance for all account detail amounts after application of payments. NUMBER

TBRACCD

TBRACCD_BALANCE

BILL_AMOUNT Bill Amount Calculated amount of all the charges and payments on the receivable account that have been billed to the account holder. NUMBER

CALCULATION

DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT)

BILL_DATE Bill Date Date that the transaction was billed. DATE

TBRACCD

TBRACCD_BILL_DATE

BILL_SEQUENCE Bill Sequence Bill sequence. NUMBER

NA

NA

CASHIER_END_DATE Cashier End Date Ending date of the cashiering session for the transaction. DATE

TBRACCD

TBRACCD_CSHR_END_DATE

CASHIER_END_TIME Cashier End Time Ending time of the cashiering session for the transaction. VARCHAR2(255)

CALCULATION

TO_CHAR(TBRACCD_CSHR_END_DATE,'HH24:MM:SS')

CASHIER_SESSION_NUMBER Cashier Session Number Session number assigned to each cashier session. NUMBER

TBRACCD

TBRACCD_SESSION_NUMBER

CATEGORY Category Identities category for a receivable transaction type. Examples are registration, housing, meal, contract. VARCHAR2(63)

TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC Category Description Receivable category description. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

CONTRACT_PYMT_TRANSACTION_IND Contract Pymt Transaction Indicator Indicates that contract payment detail is used for application of a payment to contract charges. Valid values are Y = Used or N = Not used. VARCHAR2(1)

TBRACCD

TBRACCD_CPDT_IND

COURSE_REFERENCE_NUMBER Course Reference Number Course reference number of the course that generated the charge. Tracking by course reference number is used in Fee Assessment. VARCHAR2(63)

TBRACCD

TBRACCD_CRN

CREDIT_CARD_NUMBER Credit Card Number Credit card number or payment identification. VARCHAR2(63)

TBRACCD

TBRACCD_PAYMENT_ID

CROSSREF_CATEGORY Crossref Category Category code that was the basis for a contract or exemption credit. VARCHAR2(63)

TBRACCD

TBRACCD_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC Crossref Category Description Specifies the category. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

CROSSREF_DETAIL_CODE Crossref Detail Code Detail code of the charge that is offset by a third party or exemption credit. VARCHAR2(63)

TBRACCD

TBRACCD_CROSSREF_DETAIL_CODE

CROSSREF_DETAIL_CODE_DESC Crossref Detail Code Description Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

CROSSREF_ENTITY_UID Crossref Entity UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

TBRACCD

TBRACCD_CROSSREF_PIDM

CROSSREF_NUMBER Crossref Number Number of the deposit, contract, or exemption associated with the transaction. NUMBER

TBRACCD

TBRACCD_CROSSREF_NUMBER

CROSSREF_SOURCE Crossref Source Source code that was the basis for a contract or exemption credit. VARCHAR2(63)

TBRACCD

TBRACCD_CROSSREF_SRCE_CODE

CROSSREF_SOURCE_DESC Crossref Source Description Specifies the charge/payment detail source associated with the source code. VARCHAR2(255)

TTVSRCE

TTVSRCE_DESC

DESIGNATOR_TYPE Designator Type Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator. VARCHAR2(1)

CALCULATION

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y' THEN DESIGNATOR_TYPE =

DESIGNATOR_TYPE_DESC Designator Type Description Designator type description. VARCHAR2(21)

CALCULATION

CASE WHEN NVL(TBBDETC_TBDC_IND,'N') = 'Y'' THEN DESIGNATOR_TYPE_DESC =

DETAIL_CODE Detail Code Code defining type of transaction in accounts receivable. VARCHAR2(63)

TBRACCD

TBRACCD_DETAIL_CODE

DETAIL_CODE_DESC Detail Code Description Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE Detail Code Type Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)

TBBDETC

TBBDETC_TYPE_IND

DOCUMENT_NUMBER Document Number Document number which identifies a specific charge or payment. VARCHAR2(63)

TBRACCD

TBRACCD_DOCUMENT_NUMBER

DUE_DATE Due Date Payment due date. DATE

TBRACCD

TBRACCD_DUE_DATE

EFFECTIVE_DATE Effective Date Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting. DATE

TBRACCD

TBRACCD_EFFECTIVE_DATE

ENTRY_DATE Entry Date Date this transaction was entered on the account. DATE

TBRACCD

TBRACCD_ENTRY_DATE

EXTERNAL_IND External Indicator External indicator. VARCHAR2(255)

NA

NA

FINANCIAL_AID_UPLOAD_FIELD Financial Aid Upload Field Links the financial aid fund to the AR transaction. VARCHAR2(255)

NA

NA

FOREIGN_CURRENCY Foreign Currency Contains the foreign currency code used when making a payment. VARCHAR2(63)

TBRDEPO

TBRDEPO_CURR_CODE

FOREIGN_CURRENCY_AMOUNT Foreign Currency Amount Amount of the transaction as stated in foreign currency. NUMBER

TBRDEPO

TBRDEPO_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC Foreign Currency Description Currency code description or title. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INVOICE_NUMBER Invoice Number Invoice number assigned to the transaction. VARCHAR2(63)

TBRACCD

TBRACCD_INVOICE_NUMBER

JOURNAL_ENTRY Journal Entry Journal entry. VARCHAR2(255)

NA

NA

JOURNAL_SOURCE Journal Source Journal source. VARCHAR2(255)

NA

NA

LEDGER_DESIGNATOR Ledger Designator Academic period-based or financial aid year-based designator used when using the current date (today) to reconcile balances in Accounts Receivable to the balances in the Finance general ledger for an account. VARCHAR2(63)

CALCULATION

CASE WHEN TBBDETC_TBDC_IND

LEDGER_DESIGNATOR_DESC Ledger Designator Description Term-based (Academic Period based) ledger designator description. VARCHAR2(255)

TTVABDS

TTVTBDS

TTVABDS_DESC

TTVTBDS_DESC

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OPERATING_DATE Operating Date Date used to extract the accounting line for the initial feed of this transaction to finance. DATE

CALCULATION

DECODE ( DECODE ( SIGN ( NVL (TBRACCD_TRANS_DATE, TBRACCD_EFFECTIVE_DATE)

OPERATING_DESIGNATOR Operating Designator Academic period-based or financial aid year-based designator used when using the finance feed date to find the accounting line fed to the Finance ledgers for a charge, payment or application of payments transaction. VARCHAR2(63)

CALCULATION

CASE WHEN TBBEACT_TBDC_IND = 'Y'

OPERATING_DESIGNATOR_DESC Operating Designator Description Term-based (Academic Period based) operating designator description. VARCHAR2(255)

TTVABDS

TTVTBDS

TTVABDS_DESC

TTVTBDS_DESC

POSTING_DATE Posting Date Date the accounting transaction was interfaced to the financial ledgers. DATE

TBRACCD

TBRACCD_FEED_DATE

POSTING_DOCUMENT Posting Document Document code generated to identify and feed this transaction to finance. VARCHAR2(63)

TBRACCD

TBRACCD_FEED_DOC_CODE

POST_CASHIER Post Cashier Identification code of the cashier who entered the transaction. VARCHAR2(63)

TBRACCD

TBRACCD_USER

PRE_BILL_FLAG Pre Bill Indicator Pre bill flag. VARCHAR2(255)

NA

NA

PRIORITY Priority Priority of the detail code for use in the application of payments process. VARCHAR2(63)

TBBDETC

TBBDETC_PRIORITY

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RECEIPT_NUMBER Receipt Number Receipt number associated with the transaction if a receipt number was generated when the transaction was entered. NUMBER

TBRACCD

TBRACCD_RECEIPT_NUMBER

REFUND Refund Indicates the type of refund if the transaction is determined as a refund. VARCHAR2(1)

TBBDETC

TBRACCD

TBBDETC_REFUND_IND

TBRACCD_REFUND_IND

REFUND_DESC Refund Description Refund description. VARCHAR2(255)

CALCULATION

CASE WHEN TBBDETC_REFUND_IND

RETURNED_CHECK_IND Returned Check Indicator Determines if the detail code has been identified as the code to use for returned checks. VARCHAR2(1)

CALCULATION

DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')

SOURCE Source Identifies the source of how the transaction was entered on the account. VARCHAR2(63)

TBRACCD

TBRACCD_SRCE_CODE

SOURCE_DESC Source Description Source code extracted description. VARCHAR2(255)

TTVSRCE

TTVSRCE_DESC

STATEMENT_DATE Statement Date Date the statement was generated. DATE

TBRACCD

TBRACCD_STATEMENT_DATE

STUDY_PATH Study Path Study path key sequence for the course registration. NUMBER

TBRACCD

TBRACCD_STSP_KEY_SEQUENCE

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description A session, portion or part of the academic period. VARCHAR2(255)

NA

NA

TAX_AMOUNT Tax Amount Amount of the transaction reported for 1098-t purposes. NUMBER

TBRACCD

TBRACCD_TAX_AMOUNT

TAX_DOCUMENT Tax Document Tax document. VARCHAR2(255)

NA

NA

TAX_DOCUMENT_BOX_NUMBER Tax Document Box Number Box in which amounts are reported for 1098-t purposes. VARCHAR2(63)

TBRACCD

TBRACCD_TAX_REPT_BOX

TAX_DOCUMENT_BOX_NUMBER_DESC Tax Document Box Number Description Box in which amounts are reported for 1098-t purposes. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN TAX_DOCUMENT_BOX

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER

TAX_DOCUMENT_BOX_NUMBER_PR Tax Document Box Number PR Tax Report Box in which the transaction was eligible for reporting on the form 1098T. Values (PR) Qualified Payments Received, (AP) Adjustments to Payments Received. VARCHAR2(63)

TBRACCD

TBRACCD_TAX_REPT_BOX_PR

TAX_DOCUMENT_BOX_NUMBER_PR_DESC Tax Document Box Number Desc PR Box in which amounts are reported for 1098-t purposes. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN TAX_DOCUMENT_BOX

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER_PR

TAX_DOCUMENT_BOX_NUMBER_SG Tax Document Box Number SG Tax Report Box in which the transaction was reported on the form 1098T. Values (SG) Scholarship or Grant, (AS) Adjustments to Scholarship or Grant. VARCHAR2(63)

TBRACCD

TBRACCD_TAX_REPT_BOX_SG

TAX_DOCUMENT_BOX_NUMBER_SG_DESC Tax Document Box Number Desc SG Box in which amounts are reported for 1098-t purposes. VARCHAR2(255)

CALCULATION

FUNCTION

CASE WHEN TAX_DOCUMENT_BOX

SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TAX_DOCUMENT_BOX' AND VALUE = TAX_DOCUMENT_BOX_NUMBER_SG

TAX_FUTURE_ITEM Tax Future Item Specifies if the transaction is reported as a academic period beginning in a future tax year. VARCHAR2(255)

TBRACCD

TBRACCD_TAX_FUTURE_IND

TAX_FUTURE_ITEM_PR Tax Future Item PR Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule PR, or null.. VARCHAR2(255)

TBRACCD

TBRACCD_TAX_FUTURE_IND_PR

TAX_FUTURE_ITEM_SG Tax Future Item SG Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule SG, or null. VARCHAR2(255)

TBRACCD

TBRACCD_TAX_FUTURE_IND_SG

TAX_YEAR Tax Year Tax year the transaction is reported for 1098-t purposes. NUMBER

TBRACCD

TBRACCD_TAX_REPT_YEAR

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

TBRACCD

TBRACCD_TRANS_DATE

TRANSACTION_DESC Transaction Description Accounting transaction description. VARCHAR2(255)

TBRACCD

TBRACCD_DESC

TRANSACTION_NUMBER Transaction Number Transaction number. NUMBER

TBRACCD

TBRACCD_TRAN_NUMBER

TRAN_NUMBER_PAID Tran Number Paid Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here. NUMBER

TBRACCD

TBRACCD_TRAN_NUMBER_PAID



Ver: 9.2