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

Banner 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 RECEIPT_NUMBER
ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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

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
AMOUNT Transaction amount. NUMBER

TBRMISD

TBRMISD_AMOUNT

NO

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

TBRMISD

TBRMISD_CSHR_END_DATE

NO

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

CALCULATION

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

NO

NO
CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRMISD

TBRMISD_SESSION_NUMBER

NO

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

TBRMISD

TBRMISD_CHARGE_ACCT

NO

NO
CHARGE_ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

NO
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

NO

NO
CHARGE_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

NO
CHARGE_ACTIVITY Identifies accounting data by activity. VARCHAR2(63)

TBRMISD

TBRMISD_CHARGE_ACTV

NO

NO
CHARGE_ACTIVITY_DESC Activity code title or description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
CHARGE_CATEGORY_DESC Receivable category description. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

NO
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

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_CHARGE_DETAIL_CODE

NO

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

TBBDETC

TBBDETC_TYPE_IND

NO

NO
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

NO

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

TBRMISD

TBRMISD_CHARGE_FUND

NO

NO
CHARGE_FUND_DESC Associated fund description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_CHARGE_LOCN

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_CHARGE_ORGN

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBBDETC

TBBDETC_PRIORITY

NO

NO
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

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_CHARGE_RUCL_CODE

NO

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

NO

NO
CITY City associated with the address. VARCHAR2(63)

TBBMISC

TBBMISC_CITY

NO

NO
COUNTY County associated with the address. VARCHAR2(63)

NA

NA

NO

NO
COUNTY_DESC County address name. VARCHAR2(255)

NA

NA

NO

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

TBRMISD

TBRMISD_PAYMENT_ID

NO

NO
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

NO

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

TBRMISD

TBRMISD_DOCUMENT_NUMBER

NO

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

TBRMISD

TBRMISD_PIDM

NO

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

CALCULATION

DECODE(TBRMISD_PIDM)

NO

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

TBRMISD

TBRMISD_CURR_CODE

NO

NO
FOREIGN_CURRENCY_AMOUNT Transaction amount as stated in foreign currency. NUMBER

TBRMISD

TBRMISD_FOREIGN_AMOUNT

NO

NO
FOREIGN_CURRENCY_DESC Foreign currency code description. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

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
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 Current name of the person or organization for this transaction. VARCHAR2(255)

TBBMISC

TBBMISC_NAME

NO

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

TBBMISC

TBBMISC_NATN_CODE

NO

NO
NATION_DESC Address nation/country description. VARCHAR2(255)

STVNATN

STVNATN_NATION

NO

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

TBRMISD

TBRMISD_PAY_ACCT

NO

NO
PAYMENT_ACCOUNT_DESC Account code description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

NO
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

NO

NO
PAYMENT_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

NO
PAYMENT_ACTIVITY Identifies accounting data by activity. VARCHAR2(63)

TBRMISD

TBRMISD_PAY_ACTV

NO

NO
PAYMENT_ACTIVITY_DESC Activity code title or description. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
PAYMENT_CATEGORY_DESC Receivable category description. VARCHAR2(255)

TTVDCAT

TTVDCAT_DESC

NO

NO
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

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_PAY_DETAIL_CODE

NO

NO
PAYMENT_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

NO

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

TBBDETC

TBBDETC_TYPE_IND

NO

NO
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

NO

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

TBRMISD

TBRMISD_PAY_FUND

NO

NO
PAYMENT_FUND_DESC Associated fund description or title. VARCHAR2(255)

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_PAY_LOCN

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_PAY_ORGN

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBBDETC

TBBDETC_PRIORITY

NO

NO
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

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_DESC

NO

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

FUNCTION

TOKODSF.F_BUILD_DYNAMIC_FINANCE_STATUS

NO

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

TBRMISD

TBRMISD_PAY_RUCL_CODE

NO

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

NO

NO
POSTAL_CODE Address postal code. VARCHAR2(63)

TBBMISC

TBBMISC_ZIP

NO

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

TBRMISD

TBRMISD_FEED_DATE

NO

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

TBRMISD

TBRMISD_FEED_DOC_CODE

NO

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

TBRMISD

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

TBRMISD

TBRMISD_RECEIPT_NUMBER

NO

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

TBBMISC

TBBMISC_STAT_CODE

NO

NO
STATE_PROVINCE_DESC State/Province name. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

NO

NO
STREET_LINE1 First line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE1

NO

NO
STREET_LINE2 Second line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE2

NO

NO
STREET_LINE3 Third line of the address. VARCHAR2(255)

TBBMISC

TBBMISC_STREET_LINE3

NO

NO
STREET_LINE4 Fourth line of the address. VARCHAR2(255)

NA

NA

NO

NO
TRANSACTION_ACTIVITY_DATE Date record was inserted or updated. DATE

TBRMISD

TBRMISD_ACTIVITY_DATE

NO

NO
TRANSACTION_DATE Date the transaction was posted into the ledgers. DATE

TBRMISD

TBRMISD_TRANS_DATE

NO

NO
TRANSACTION_DESC Accounting transaction description. VARCHAR2(255)

TBRMISD

TBRMISD_DESC

NO

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

TBRMISD

TBRMISD_TRAN_NUMBER

NO

NO


Ver: 9.2