RETURN TO REPORTING VIEW REPORTS LIST
Accounts Receivable Reporting View Reports

SGHE Operational Data Store
Reporting View Target: MISCELLANEOUS_TRANSACTION

Description 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.
Key & Frequency One row per receipt number per user per transaction number
Recommended Search Columns ENTITY_UID
RECEIPT_NUMBER

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

TBRMISD

TBRMISD_ACCT_FEED_IND

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

NA

NA

AMOUNT Transaction amount. NUMBER

TBRMISD

TBRMISD_AMOUNT

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

TBRMISD

TBRMISD_CSHR_END_DATE

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

CALCULATION

TO_CHAR(TBRACCD_CSHR_END_DATE)

CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRMISD

TBRMISD_SESSION_NUMBER

CHARGE_ACCOUNT Code representing an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_ACCT

CHARGE_ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_ACCOUNT_INDEX Short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_ACCI

CHARGE_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_ACCOUNT_INDEX_STATUS Current status of the associated account index. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_ACCOUNT_STATUS Current status of the associated account. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_ACTIVITY Identifies accounting data by activity. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_ACTV

CHARGE_ACTIVITY_DESC Activity code title or description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_CATEGORY Identities category for a receivable transaction type. For example, registration, housing, meal, and contract. VARCHAR2(63)

TBBDETC

TBBDETC_DCAT_CODE

CHARGE_CATEGORY_DESC Receivable category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CHARGE_CHART_OF_ACCOUNTS Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_COAS

CHARGE_CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_CHART_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_DETAIL_CODE Detail code identifying type of charge used on this receipt. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_DETAIL_CODE

CHARGE_DETAIL_CODE_DESC Detail code 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(63)

TBBDETC

TBBDETC_TYPE_IND

CHARGE_EXTERNAL_ACCOUNT Free form account number used to interface to finance systems when Banner Finance is not present. VARCHAR2(255)

TBRMISD

TBRMISD_CHARGE_ACCOUNT

CHARGE_FUND The funding source code used with this accounting transaction. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_FUND

CHARGE_FUND_DESC Associated fund description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_FUND_STATUS Extracted current status of the associated fund. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_LOCATION Accounting identification code of a physical location. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_LOCN

CHARGE_LOCATION_DESC Extracted description or title of the associated location. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_LOCATION_STATUS Extracted current status of the associated location. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_ORGANIZATION Identification accounting code used for the department. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_ORGN

CHARGE_ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

CHARGE_PRIORITY Detail code priority for use in the application of payments process. VARCHAR2(63)

TBBDETC

TBBDETC_PRIORITY

CHARGE_PROGRAM Accounting identification code. Program classification structure, or a subset or that structure, as defined by the national council of higher education management systems. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_PROG

CHARGE_PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

CHARGE_PROGRAM_STATUS Extracted current status of the associated program. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

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

TBRMISD

TBRMISD_CHARGE_RUCL_CODE

CHARGE_RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

CITY City associated with the address. VARCHAR2(63)

TBBMISC

TBBMISC_CITY

COUNTY County associated with the address. VARCHAR2(63)

NA

NA

COUNTY_DESC County address name. VARCHAR2(255)

NA

NA

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

TBRMISD

TBRMISD_PAYMENT_ID

DEBIT_CREDIT_IND Determines a debit or credit effect on the ledgers; plus or minus, debit or credit. VARCHAR2(1)

TBRMISD

TBRMISD_DR_CR_IND

DOCUMENT_NUMBER Unique transaction id assigned from posting. VARCHAR2(63)

TBRMISD

TBRMISD_DOCUMENT_NUMBER

ENTITY_UID System internally generated ID to uniquely identify the person or oragnization for this transaction. NUMBER

TBRMISD

TBRMISD_PIDM

EXTERNAL_IND Indicates the transaction is for a person outside the institution system. VARCHAR2(1)

CALCULATION

DECODE(TBRMISD_PIDM)

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

TBRMISD

TBRMISD_CURR_CODE

FOREIGN_CURRENCY_AMOUNT Transaction amount as stated in foreign currency. NUMBER

TBRMISD

TBRMISD_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC Foreign currency code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID System generated, unique, internal identification number assigned to this person or organization entity. 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 Current name of the person or organization for this transaction. VARCHAR2(255)

TBBMISC

TBBMISC_NAME

NATION Nation code associated with the address. VARCHAR2(63)

TBBMISC

TBBMISC_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(255)

FUNCTION

GOKODSF.F_DYNAMIC_GET_FNC

PAYMENT_ACCOUNT Represents an account, such as assets, liability, control, fund balance, revenue, labor, expenditure or transfer. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_ACCT

PAYMENT_ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_ACCOUNT_INDEX Account Index is used as a short cut method to the data entry of an accounting distribution. It may contain any or all of the account distribution columns. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_ACCI

PAYMENT_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_ACCOUNT_INDEX_STATUS Current status of the associated account index. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_ACCOUNT_STATUS Current status of the associated account. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_ACTIVITY Identifies accounting data by activity. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_ACTV

PAYMENT_ACTIVITY_DESC Activity code title or description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_ACTIVITY_STATUS Extracted current status of the associated activity. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_CATEGORY Identities category for a receivable transaction type. For example, registration, housing, meal, and contract. VARCHAR2(63)

TBBDETC

TBBDETC_DCAT_CODE

PAYMENT_CATEGORY_DESC Receivable category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PAYMENT_CHART_OF_ACCOUNTS Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_COAS

PAYMENT_CHART_OF_ACCOUNTS_DESC Chart of accounts code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_CHART_STATUS Extracted current status of the associated chart of accounts. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_DETAIL_CODE Detail code identifying type of payment used on this receipt. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_DETAIL_CODE

PAYMENT_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

PAYMENT_DETAIL_CODE_TYPE Determines if the detail code is being used as a charge or a payment. VARCHAR2(63)

TBBDETC

TBBDETC_TYPE_IND

PAYMENT_EXTERNAL_ACCOUNT Free form account number used to interface to finance systems when Banner Finance is not present. VARCHAR2(255)

TBRMISD

TBRMISD_PAY_ACCOUNT

PAYMENT_FUND Funding source code used with this accounting transaction. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_FUND

PAYMENT_FUND_DESC Associated fund description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_FUND_STATUS Extracted current status of the associated fund. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_LOCATION Accounting identification code of a physical location. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_LOCN

PAYMENT_LOCATION_DESC Extracted description or title of the associated location. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_LOCATION_STATUS Extracted current status of the associated location. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

PAYMENT_ORGANIZATION Identification accounting code used for the department. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_ORGN

PAYMENT_ORGANIZATION_DESC Extracted description or title associated with the organization code. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_ORGANIZATION_STATUS Extracted current status of the associated organization. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

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

TBBDETC

TBBDETC_PRIORITY

PAYMENT_PROGRAM Accounting identification code. Identifies the program classification structure, or a subset or that structure, as defined by the national council of higher education management systems. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_PROG

PAYMENT_PROGRAM_DESC Extracted description or title of the associated program. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

PAYMENT_PROGRAM_STATUS Extracted current status of the associated program. VARCHAR2(1)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

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

TBRMISD

TBRMISD_PAY_RUCL_CODE

PAYMENT_RULE_CLASS_DESC Unique title assigned to a rule class. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

POSTAL_CODE Address postal code. VARCHAR2(63)

TBBMISC

TBBMISC_ZIP

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

TBRMISD

TBRMISD_FEED_DATE

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

TBRMISD

TBRMISD_FEED_DOC_CODE

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

TBRMISD

TBRMISD_USER

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 associated with the transaction if a receipt number was generated when the transaction was entered. NUMBER

TBRMISD

TBRMISD_RECEIPT_NUMBER

STATE_PROVINCE State/Province code for the address. VARCHAR2(63)

TBBMISC

TBBMISC_STAT_CODE

STATE_PROVINCE_DESC State/Province name. VARCHAR2(255)

FUNCTION

GOKODSF.F_DYNAMIC_GET_FNC

STREET_LINE1 First line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

TRANSACTION_ACTIVITY_DATE Date record was inserted or updated DATE

TBRMISD

TBRMISD_ACTIVITY_DATE

TRANSACTION_DATE Date the transaction was posted into the ledgers. DATE

TBRMISD

TBRMISD_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(255)

TBRMISD

TBRMISD_DESC

TRANSACTION_NUMBER A unique one-up number assigned to each transaction on the receipt. NUMBER

TBRMISD

TBRMISD_TRAN_NUMBER



Ver: 3.1