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

SGHE Banner Operational Data Store
Reporting View Target: APPL_OF_PAY_DETAIL_ACCOUNTING

Description Contains accounting information sent to Finance for each payment applied to a charge on a receivable account. .
Key & Frequency Multiple rows per account_id per pay_tran_number per charge_tran_number.
Recommended Search Columns DETAIL_CODE
ACCOUNT_UID, CHARGE_TRAN_NUMBER
ACCOUNT_UID, PAY_TRAN_NUMBER, CHARGE_TRAN_NUMBER

Target Column Business Definition Database Data Type Source Name Source Column
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_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER

TBRAPPL

TBRAPPL_PIDM

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

NA

NA

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

CALCULATION

(APPLIED_AMOUNT * (CLGR.PERCENT/100) * (PLGR.PERCENT/100))

APPLIED_DATE Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here. DATE

CALCULATION

NVL(PAY.TRANSACTION_DATE,CHG.TRANSACTION_DATE)

APPL_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 Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

TBRAPPL

TBRAPPL_USER

CHARGE_ACCOUNT Banner finance account used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ACCT_CODE

TBRACCT_B_ACCT_CODE

CHARGE_ACCOUNT_DESC Account description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_ACCOUNT_EXTERNAL Actual account number from a finance system associated with the pay transaction. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_ACCOUNT_A

TBRACCT_ACCOUNT_B

CHARGE_ACTIVITY Banner finance activity used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ACTV_CODE

TBRACCT_B_ACTV_CODE

CHARGE_ACTIVITY_DESC Activity description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_CHART_OF_ACCOUNTS Banner finance chart of accounts code used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_COAS_CODE

TBRACCT_B_COAS_CODE

CHARGE_CHART_OF_ACCOUNTS_DESC Chart of accounts description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_DETAIL_CODE

CHARGE_DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

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_FUND Banner finance fund used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_FUND_CODE

TBRACCT_B_FUND_CODE

CHARGE_FUND_DESC Fund description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_LOCATION Banner finance location used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_LOCN_CODE

TBRACCT_B_LOCN_CODE

CHARGE_LOCATION_DESC Location description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

TOKODSF.F_TERM_CODE_TBDS

CHARGE_ORGANIZATION Banner finance organization used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ORGN_CODE

TBRACCT_B_ORGN_CODE

CHARGE_ORGANIZATION_DESC Organization description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_PERCENT Percentage of the amount associated with the detail applied to the charge transaction. NUMBER

TBRACCT

TBRACCT_PERCENT

CHARGE_PROGRAM Banner finance program used for the charge. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_PROG_CODE

TBRACCT_B_PROG_CODE

CHARGE_PROGRAM_DESC Program description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_RULE_CLASS Accounting transaction code defining rules used to control charge transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT

TBRACCT

TBRACCT_A_RUCL_CODE2

TBRACCT_A_RUCL_CODE3

TBRACCT_B_RUCL_CODE2

TBRACCT_B_RUCL_CODE3

CHARGE_RULE_CLASS_DESC Rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 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_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

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

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAY_ACCOUNT Banner finance account used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ACCT_CODE

TBRACCT_B_ACCT_CODE

PAY_ACCOUNT_DESC Account description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAY_ACCOUNT_EXTERNAL Actual account number from a finance system associated with the pay transaction. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_ACCOUNT_A

TBRACCT_ACCOUNT_B

PAY_ACTIVITY Banner finance activity used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ACTV_CODE

TBRACCT_B_ACTV_CODE

PAY_ACTIVITY_DESC Activity description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAY_CHART_OF_ACCOUNTS Banner finance chart of accounts code used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_COAS_CODE

TBRACCT_B_COAS_CODE

PAY_CHART_OF_ACCOUNTS_DESC Chart of accounts description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_DETAIL_CODE

PAY_DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

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_FUND Banner finance fund used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_FUND_CODE

TBRACCT_B_FUND_CODE

PAY_FUND_DESC Fund description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAY_LOCATION Banner finance location used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_LOCN_CODE

TBRACCT_B_LOCN_CODE

PAY_LOCATION_DESC Location description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

TOKODSF.F_TERM_CODE_TBDS

PAY_ORGANIZATION Banner finance organization used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_ORGN_CODE

TBRACCT_B_ORGN_CODE

PAY_ORGANIZATION_DESC Organization description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAY_PERCENT Percentage of the amount associated with the detail applied to the pay transaction. NUMBER

TBRACCT

TBRACCT_PERCENT

PAY_PROGRAM Banner finance program used for payment. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT_A_PROG_CODE

TBRACCT_B_PROG_CODE

PAY_PROGRAM_DESC Program description for pay transaction. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAY_RULE_CLASS Accounting transaction code defining rules used to control payment transaction updates to the ledgers. VARCHAR2(63)

TBRACCT

TBRACCT

TBRACCT

TBRACCT

TBRACCT_A_RUCL_CODE2

TBRACCT_A_RUCL_CODE3

TBRACCT_B_RUCL_CODE2

TBRACCT_B_RUCL_CODE3

PAY_RULE_CLASS_DESC Rule class description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 Date the accounting transaction was interfaced to the financial ledgers. DATE

TBRAPPL

TBRAPPL_FEED_DATE

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

TBRAPPL

TBRAPPL_FEED_DOC_CODE

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

NA

NA

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



Ver: 8.5