Reporting View Target: APPLICATION_OF

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

SGHE 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
ACCOUNT_UID, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

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(63)
TBRAPPL

TBRAPPL_ACCT_FEED_IND

ACCOUNT_POSTING_STATUS_DESC Account Posting Status Description 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

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

TBRAPPL_PIDM

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

NA

APPLIED_AMOUNT Applied Amount Amount of the payment that paid off the charge. NUMBER
TBRAPPL

TBRAPPL_AMOUNT

APPLIED_DATE Applied Date Date the payment transaction was applied to the charge transaction. DATE
CALCULATION

NVL(PAY.TRANSACTION_DATE,CHG.TRANSACTION_DATE)

APPL_OF_PAYMENT_ACTIVITY_DATE Applicant Of Payment Activity Date Date that information for this record in the table was entered or last updated. DATE
TBRAPPL

TBRAPPL_ACTIVITY_DATE

APPL_OF_PAYMENT_USER_ID Applicant Of Payment User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)
TBRAPPL

TBRAPPL_USER

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)
TBBCSHR

TBBCSHR_ACTIVITY_DATE

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

TBRACCD_SESSION_NUMBER

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

NA

CHARGE_DETAIL_CODE Charge Detail Code Code defining type of transaction in accounts receivable. VARCHAR2(63)
TBRACCD

TBRACCD_DETAIL_CODE

CHARGE_DETAIL_CODE_DESC Charge Detail Code Description Transaction type description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

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

TBBDETC_TYPE_IND

CHARGE_OPERATING_DESIGNATOR Charge Operating Designator Extracted academic period-based designator to be used for initial transactions. VARCHAR2(63)
CALCULATION

CASE WHEN TBBEACT_TBDC_IND

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

TBBDETC_PRIORITY

CHARGE_TRAN_NUMBER Charge Tran Number Transaction number of the detail code used as the charge transaction in application of payments. NUMBER
TBRAPPL

TBRAPPL_CHG_TRAN_NUMBER

CONTRACT_PAYMENT_TRANSACTION 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

DIRECT_PAYMENT_TYPE 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

DIRECT_PAYMENT_TYPE_DESC Direct Payment Type Description 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

DIRECT_PAY_IND Direct Pay Indicator 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

EXTERNAL_IND External Indicator External indicator. VARCHAR2(255)
NA

NA

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

NA

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INVOICE_NUMBER_PAID Invoice Number Paid Identification number of the invoice paid by the application of payment. VARCHAR2(63)
TBRAPPL

TBRAPPL_INV_NUMBER_PAID

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

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

TBBDETC_PRIORITY

PAY_DETAIL_CODE Payment Detail Code Code defining type of transaction in accounts receivable. VARCHAR2(63)
TBRACCD

TBRACCD_DETAIL_CODE

PAY_DETAIL_CODE_DESC Pay Detail Code Description Transaction type description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

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

TBBDETC_TYPE_IND

PAY_OPERATING_DESIGNATOR Pay Operating Designator Extracted academic period-based designator to be used for initial transactions. VARCHAR2(63)
CALCULATION

CASE WHEN TBBEACT_TBDC_IND

PAY_TRAN_NUMBER Pay Tran Number Transaction number of the detail code used as the payment transaction in application of payments. NUMBER
TBRAPPL

TBRAPPL_PAY_TRAN_NUMBER

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

TBRAPPL_FEED_DATE

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

TBRAPPL_FEED_DOC_CODE

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

TBRACCD_USER

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

NA

REAPPLICATION_IND Reapplication Indicator 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

Ver: 9.0

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 ACCOUNT_UID, CHARGE_TRAN_NUMBER ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
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(63)	TBRAPPL	TBRAPPL_ACCT_FEED_IND
ACCOUNT_POSTING_STATUS_DESC	Account Posting Status Description	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
ACCOUNT_UID	Account UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	TBRAPPL	TBRAPPL_PIDM
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPLIED_AMOUNT	Applied Amount	Amount of the payment that paid off the charge.	NUMBER	TBRAPPL	TBRAPPL_AMOUNT
APPLIED_DATE	Applied Date	Date the payment transaction was applied to the charge transaction.	DATE	CALCULATION	NVL(PAY.TRANSACTION_DATE,CHG.TRANSACTION_DATE)
APPL_OF_PAYMENT_ACTIVITY_DATE	Applicant Of Payment Activity Date	Date that information for this record in the table was entered or last updated.	DATE	TBRAPPL	TBRAPPL_ACTIVITY_DATE
APPL_OF_PAYMENT_USER_ID	Applicant Of Payment User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	TBRAPPL	TBRAPPL_USER
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)	TBBCSHR	TBBCSHR_ACTIVITY_DATE
CASHIER_SESSION_NUMBER	Cashier Session Number	Session number assigned to each cashier session.	NUMBER	TBRACCD	TBRACCD_SESSION_NUMBER
CHARGE_CLASS	Charge Class	Class of the detail code for use in the application of payments process.	VARCHAR2(63)	NA	NA
CHARGE_DETAIL_CODE	Charge Detail Code	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
CHARGE_DETAIL_CODE_DESC	Charge Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
CHARGE_DETAIL_CODE_TYPE	Charge Detail Code Type	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND
CHARGE_OPERATING_DESIGNATOR	Charge Operating Designator	Extracted academic period-based designator to be used for initial transactions.	VARCHAR2(63)	CALCULATION	CASE WHEN TBBEACT_TBDC_IND
CHARGE_PRIORITY	Charge Priority	Priority of the detail code for use in the application of payments process.	VARCHAR2(63)	TBBDETC	TBBDETC_PRIORITY
CHARGE_TRAN_NUMBER	Charge Tran Number	Transaction number of the detail code used as the charge transaction in application of payments.	NUMBER	TBRAPPL	TBRAPPL_CHG_TRAN_NUMBER
CONTRACT_PAYMENT_TRANSACTION	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
DIRECT_PAYMENT_TYPE	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
DIRECT_PAYMENT_TYPE_DESC	Direct Payment Type Description	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
DIRECT_PAY_IND	Direct Pay Indicator	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
EXTERNAL_IND	External Indicator	External indicator.	VARCHAR2(255)	NA	NA
FUTURE_ITEM	Future Item	Future or next year's budget item.	VARCHAR2(255)	NA	NA
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INVOICE_NUMBER_PAID	Invoice Number Paid	Identification number of the invoice paid by the application of payment.	VARCHAR2(63)	TBRAPPL	TBRAPPL_INV_NUMBER_PAID
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
PAYMENT_PRIORITY	Payment Priority	Priority of the detail code for use in the application of payments process.	VARCHAR2(63)	TBBDETC	TBBDETC_PRIORITY
PAY_DETAIL_CODE	Payment Detail Code	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TBRACCD	TBRACCD_DETAIL_CODE
PAY_DETAIL_CODE_DESC	Pay Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
PAY_DETAIL_CODE_TYPE	Pay Detail Code Type	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(1)	TBBDETC	TBBDETC_TYPE_IND
PAY_OPERATING_DESIGNATOR	Pay Operating Designator	Extracted academic period-based designator to be used for initial transactions.	VARCHAR2(63)	CALCULATION	CASE WHEN TBBEACT_TBDC_IND
PAY_TRAN_NUMBER	Pay Tran Number	Transaction number of the detail code used as the payment transaction in application of payments.	NUMBER	TBRAPPL	TBRAPPL_PAY_TRAN_NUMBER
POSTING_DATE	Posting Date	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TBRAPPL	TBRAPPL_FEED_DATE
POSTING_DOCUMENT	Posting Document	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TBRAPPL	TBRAPPL_FEED_DOC_CODE
POST_CASHIER	Post Cashier	Identification code of the cashier who entered the transaction.	VARCHAR2(63)	TBRACCD	TBRACCD_USER
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REAPPLICATION_IND	Reapplication Indicator	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