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

Banner Operational Data Store
Reporting View Target: APPLICATION_OF_PAYMENT

Description 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.
Key & Frequency Multiple rows per account per payment transaction.
Recommended Search Columns ACCOUNT_UID, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER
DETAIL_CODE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ACCOUNT_POSTING_STATUS Indicates the status of the transaction in the accounting feed process as ready to feed or transaction has been fed. VARCHAR2(63)

TBRAPPL

TBRAPPL_ACCT_FEED_IND

NO

NO
ACCOUNT_POSTING_STATUS_DESC Accounting posting status description. VARCHAR2(255)

FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'ACCOUNT_POSTING_STATUS' AND VALUE = AP.ACCOUNT_POSTING_STATUS

NO

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

TBRAPPL

TBRAPPL_PIDM

NO

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

NA

NA

NO

NO
APPLIED_AMOUNT Amount of the payment that paid off the charge. NUMBER

TBRAPPL

TBRAPPL_AMOUNT

NO

NO
APPLIED_DATE Date the payment transaction was applied to the charge transaction. DATE

CALCULATION

NVL(PAY.TRANSACTION_DATE,CHG.TRANSACTION_DATE)

NO

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

TBRAPPL

TBRAPPL_ACTIVITY_DATE

NO

NO
APPL_OF_PAYMENT_USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

TBRAPPL

TBRAPPL_USER

NO

NO
CASHIER_END_DATE Ending date of the cashiering session for the transaction. DATE

TBRACCD

TBRACCD_CSHR_END_DATE

NO

NO
CASHIER_END_TIME Ending time of the cashiering session for the transaction. VARCHAR2(255)

CALCULATION

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

NO

NO
CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRACCD

TBRACCD_SESSION_NUMBER

NO

NO
CHARGE_CATEGORY Charge Category VARCHAR2(63)

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
CHARGE_CATEGORY_DESC Charge Category Desc VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

NO
CHARGE_CLASS Class of the detail code for use in the application of payments process. VARCHAR2(63)

NA

NA

NO

NO
CHARGE_DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(63)

TBRACCD

TBRACCD_DETAIL_CODE

NO

NO
CHARGE_DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

NO

NO
CHARGE_DETAIL_CODE_TYPE Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)

TBBDETC

TBBDETC_TYPE_IND

NO

NO
CHARGE_OPERATING_DESIGNATOR Extracted academic period-based designator to be used for initial transactions. VARCHAR2(63)

CALCULATION

CASE WHEN TBBEACT_TBDC_IND

NO

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

TBBDETC

TBBDETC_PRIORITY

NO

NO
CHARGE_TRAN_NUMBER Transaction number of the detail code used as the charge transaction in application of payments. NUMBER

TBRAPPL

TBRAPPL_CHG_TRAN_NUMBER

NO

NO
CONTRACT_PAYMENT_TRANSACTION Contract payment transaction number, which together with the pay transaction number identifies the receivable account detail record on which the application of payment is based. NUMBER

TBRAPPL

TBRAPPL_CPDT_TRAN_NUMBER

NO

NO
DIRECT_PAYMENT_TYPE Indicates the direct application of payment type specified when the transaction was entered on the account. Valid values are: T = Direct Transaction Paid, I = Direct Invoice Paid, B = Both Direct Transaction Paid and Invoice Paid, Null = neither Direct Transaction Paid and Invoice Paid. VARCHAR2(63)

TBRAPPL

TBRAPPL_DIRECT_PAY_TYPE

NO

NO
DIRECT_PAYMENT_TYPE_DESC Direct payment type description VARCHAR2(255)

FUNCTION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'DIRECT_PAYMENT_TYPE' AND VALUE = AP.DIRECT_PAYMENT_TYPE

NO

NO
DIRECT_PAY_IND Indicates that the transaction was a direct application of payment specified when the transaction was entered on the account. VARCHAR2(1)

TBRAPPL

TBRAPPL_DIRECT_PAY_IND

NO

NO
EXTERNAL_IND External indicator. VARCHAR2(255)

NA

NA

NO

NO
FUTURE_ITEM Future or next year's budget item. VARCHAR2(255)

NA

NA

NO

NO
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

NO

NO
INVOICE_NUMBER_PAID Identification number of the invoice paid by the application of payment. VARCHAR2(63)

TBRAPPL

TBRAPPL_INV_NUMBER_PAID

NO

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

NA

NA

NO

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

NA

NA

NO

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

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

TBBDETC

TBBDETC_PRIORITY

NO

NO
PAY_CATEGORY Pay Category VARCHAR2(63)

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
PAY_CATEGORY_DESC Pay Category Desc VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

NO
PAY_DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(63)

TBRACCD

TBRACCD_DETAIL_CODE

NO

NO
PAY_DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

NO

NO
PAY_DETAIL_CODE_TYPE Determines if the detail code is being used as a charge or a payment. VARCHAR2(1)

TBBDETC

TBBDETC_TYPE_IND

NO

NO
PAY_OPERATING_DESIGNATOR Extracted academic period-based designator to be used for initial transactions. VARCHAR2(63)

CALCULATION

CASE WHEN TBBEACT_TBDC_IND

NO

NO
PAY_TRAN_NUMBER Transaction number of the detail code used as the payment transaction in application of payments. NUMBER

TBRAPPL

TBRAPPL_PAY_TRAN_NUMBER

NO

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

TBRAPPL

TBRAPPL_FEED_DATE

NO

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

TBRAPPL

TBRAPPL_FEED_DOC_CODE

NO

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

TBRACCD

TBRACCD_USER

NO

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

NA

NA

NO

NO
REAPPLICATION_IND Indicates that this application of payment record was created because the un-application of payment process had been run for this account. Valid value is: Y - the record was created due to an un-application of payment being processed, or was an original record that was unapplied. VARCHAR2(1)

TBRAPPL

TBRAPPL_REAPPL_IND

NO

NO


Ver: 9.2