RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Operational Data Store
Composite View Target: AT_MISCELLANEOUS_TRANSACTION

Description Source composite view contains miscellaneous transaction detail information for accounts receivable.

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

AMOUNT Transaction amount. NUMBER(12, 2)

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(8)

CALCULATION

TO_CHAR(TBRACCD_CSHR_END_DATE)

CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER(5)

TBRMISD

TBRMISD_SESSION_NUMBER

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

TBRMISD

TBRMISD_CHARGE_ACCT

CHARGE_ACCOUNT_DESC Account code description or title. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_CHARGE_ACCI

CHARGE_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_CHARGE_ACTV

CHARGE_ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

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(3)

TBBDETC

TBBDETC_DCAT_CODE

CHARGE_CATEGORY_DESC Receivable category description. VARCHAR2(30)

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(1)

TBRMISD

TBRMISD_CHARGE_COAS

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

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(4)

TBRMISD

TBRMISD_CHARGE_DETAIL_CODE

CHARGE_DETAIL_CODE_DESC Detail code description. VARCHAR2(30)

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_EXTERNAL_ACCOUNT Free form account number used to interface to finance systems when Banner Finance is not present. VARCHAR2(60)

TBRMISD

TBRMISD_CHARGE_ACCOUNT

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

TBRMISD

TBRMISD_CHARGE_FUND

CHARGE_FUND_DESC Associated fund description or title. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_CHARGE_LOCN

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

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(6)

TBRMISD

TBRMISD_CHARGE_ORGN

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

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(3)

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(6)

TBRMISD

TBRMISD_CHARGE_PROG

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

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(4)

TBRMISD

TBRMISD_CHARGE_RUCL_CODE

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

CITY City associated with the address. VARCHAR2(20)

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(20)

TBRMISD

TBRMISD_PAYMENT_ID

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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(8)

TBRMISD

TBRMISD_DOCUMENT_NUMBER

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

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

TBRMISD

TBRMISD_PIDM

FOREIGN_CURRENCY Foreign currency code description. VARCHAR2(4)

TBRMISD

TBRMISD_CURR_CODE

FOREIGN_CURRENCY_AMOUNT Amount of the transaction as stated in foreign currency. NUMBER(12, 2)

TBRMISD

TBRMISD_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC Transaction amount as stated in foreign currency. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

NA

NA

NAME Current name of the person or organization for this transaction. VARCHAR2(30)

TBBMISC

TBBMISC_NAME

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

TBBMISC

TBBMISC_NATN_CODE

NATION_DESC Address nation/country description. VARCHAR2(35)

FUNCTION

GOKODSF.F_DYNAMIC_GET_FNC

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

TBRMISD

TBRMISD_PAY_ACCT

PAYMENT_ACCOUNT_DESC Account code description or title. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_PAY_ACCI

PAYMENT_ACCOUNT_INDEX_DESC Account index description. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_PAY_ACTV

PAYMENT_ACTIVITY_DESC Activity code title or description. VARCHAR2(35)

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(3)

TBBDETC

TBBDETC_DCAT_CODE

PAYMENT_CATEGORY_DESC Receivable category description. VARCHAR2(30)

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(1)

TBRMISD

TBRMISD_PAY_COAS

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

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(4)

TBRMISD

TBRMISD_PAY_DETAIL_CODE

PAYMENT_DETAIL_CODE_DESC Detail code description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

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

TBBDETC

TBBDETC_TYPE_IND

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

TBRMISD

TBRMISD_PAY_ACCOUNT

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

TBRMISD

TBRMISD_PAY_FUND

PAYMENT_FUND_DESC Associated fund description or title. VARCHAR2(35)

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(6)

TBRMISD

TBRMISD_PAY_LOCN

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

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(6)

TBRMISD

TBRMISD_PAY_ORGN

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

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(3)

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(6)

TBRMISD

TBRMISD_PAY_PROG

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

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(4)

TBRMISD

TBRMISD_PAY_RUCL_CODE

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

POSTAL_CODE Address postal code. VARCHAR2(10)

TBBMISC

TBBMISC_ZIP

POSTING_DATE Date the transaction was posted into the ledgers. DATE

TBRMISD

TBRMISD_FEED_DATE

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

TBRMISD

TBRMISD_FEED_DOC_CODE

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

TBRMISD

TBRMISD_USER

RECEIPT_NUMBER Receipt number associated with the transaction if a receipt number was generated when the transaction was entered. NUMBER(8)

TBRMISD

TBRMISD_RECEIPT_NUMBER

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

TBBMISC

TBBMISC_STAT_CODE

STATE_PROVINCE_DESC State/Province name. VARCHAR2(35)

FUNCTION

GOKODSF.F_DYNAMIC_GET_FNC

STREET_LINE1 First line of the address. VARCHAR2(30)

TBBMISC

TBBMISC_STREET_LINE1

STREET_LINE2 Second line of the address. VARCHAR2(30)

TBBMISC

TBBMISC_STREET_LINE2

STREET_LINE3 Third line of the address. VARCHAR2(30)

TBBMISC

TBBMISC_STREET_LINE3

STREET_LINE4 Fourth line of the address. VARCHAR2(63)

NA

NA

TRANSACTION_ACTIVITY_DATE Date record was inserted or updated DATE

TBRMISD

TBRMISD_ACTIVITY_DATE

TRANSACTION_DATE The date the transaction was posted into the ledgers. DATE

TBRMISD

TBRMISD_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(30)

TBRMISD

TBRMISD_DESC

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

TBRMISD

TBRMISD_TRAN_NUMBER

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

NA

NA



Ver: 3.1