Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Accounts Receivable Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: DEPOSIT

Description Contains accounts receivable deposits including account ID, detail code, academic period, transaction number, original amount, balance amount, payment detail code, post cashier, deposit entry date, deposit receipt number, minimum remaining deposit amount, and posting document.
Key & Frequency One row per account per transaction number.
Recommended Search Columns ACCOUNT_UID, TRANSACTION_NUMBER
ACCOUNT_UID, DETAIL_CODE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period associated with the transaction. VARCHAR2(63)

TBRDEPO

TBRDEPO_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACCOUNT_POSTED_AMOUNT Amount that has been posted. NUMBER

CALCULATION

DECODE(TBRDEPO_FEED_DATE, NULL, NULL, TBRDEPO_AMOUNT)

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)

TBRDEPO

TBRDEPO_ACCT_FEED_IND

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

TBRDEPO

TBRDEPO_PIDM

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

NA

NA

AUTO_RELEASE_IND Indicates whether the deposit should be automatically released on the account after the release date. Valid values are: Y - automatically release, N - release manually on the account detail form. VARCHAR2(1)

TBRDEPO

TBRDEPO_AUTO_RELEASE_IND

BALANCE_AMOUNT Remaining balance of all deposit available and pending release to the receivable account. NUMBER

CALCULATION

NVL(TBRDEPO_AMOUNT-F_ACCD_AMOUNT(TBRDEPO_PIDM,TBRDEPO_TRAN_NUMBER),0)

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

TBRDEPO

TBRDEPO_CSHR_END_DATE

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

TBBCSHR

TBBCSHR_ACTIVITY_DATE

CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRDEPO

TBRDEPO_SESSION_NUMBER

DEPOSIT_ACTIVITY_DATE Most current date record was created or updated. DATE

TBRDEPO

TBRDEPO_ACTIVITY_DATE

DEPOSIT_EFFECTIVE_DATE Effective date of the deposit. This date defaults to the date the deposit was entered. DATE

TBRDEPO

TBRDEPO_EFFECTIVE_DATE

DEPOSIT_ENTRY_DATE Date the deposit was entered as a deposit on the account. DATE

TBRDEPO

TBRDEPO_ENTRY_DATE

DEPOSIT_EXPIRATION_DATE Expiration date of the deposit. DATE

TBRDEPO

TBRDEPO_EXPIRATION_DATE

DEPOSIT_RECEIPT_NUMBER Receipt number associated with the deposit if a receipt number was system-generated when the deposit was entered. NUMBER

TBRDEPO

TBRDEPO_RECEIPT_NUMBER

DEPOSIT_RELEASE_DATE Date the deposit may be released. Deposit may not be released automatically or manually before this date. If this field is blank the deposit may be released at any time. DATE

TBRDEPO

TBRDEPO_RELEASE_DATE

DEPOSIT_TRANS_DATE Date used by the finance system to control posting to the ledgers. DATE

TBRDEPO

TBRDEPO_TRANS_DATE

DEPOSIT_TYPE Type or classification of this deposit. VARCHAR2(63)

TBBDEPC

TBBDEPC_DTYP_CODE

DEPOSIT_TYPE_DESC Description of the type or classification of this deposit. VARCHAR2(255)

TTVDTYP

TTVDTYP_DESC

DETAIL_CODE Detail Code defining this deposit transaction. VARCHAR2(63)

TBRDEPO

TBRDEPO_DETAIL_CODE_DEPOSIT

DETAIL_CODE_DESC Deposit detail code description. VARCHAR2(255)

TBRDEPO

TBRDEPO_DESC

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

TBRDEPO

TBRDEPO_CURR_CODE

FOREIGN_CURRENCY_AMOUNT Amount of the transaction as stated in foreign currency. NUMBER

TBRDEPO

TBRDEPO_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC Currency code description or title. VARCHAR2(255)

GTVCURR

GTVCURR_TITLE

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

LEDGER_DESIGNATOR Academic period-based designator to be used for general ledger reconciliation. VARCHAR2(63)

FUNCTION

F_TERM_CODE_TBDS

MIN_REMAIN_DEPOSIT_AMT Minimum amount that must remain as a deposit and not be released until the expiration date of the deposit. NUMBER

TBRDEPO

TBRDEPO_MIN_AMOUNT

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

OPERATING_DATE Date used for initial feed of transactions to finance. For additional information, see the note preceding t11.11. DATE

CALCULATION

NVL(TBRDEPO_TRANS_DATE,TBRDEPO_EFFECTIVE_DATE)-NVL(TBRDEPO_FEED_DATE,SYSDATE)

OPERATING_DESIGNATOR Academic period-based designator to be used for initial transactions. For additional information, see the note preceding t11.11. VARCHAR2(63)

FUNCTION

F_TERM_CODE_TBDS

ORIGINAL_AMOUNT Initial amount of the deposit. NUMBER

TBRDEPO

TBRDEPO_AMOUNT

PAYMENT_DETAIL_CODE Detail code associated with the method of how the deposit was paid - check, cash, etc. VARCHAR2(63)

TBRDEPO

TBRDEPO_DETAIL_CODE_PAYMENT

PAYMENT_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

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

TBRDEPO

TBRDEPO_FEED_DATE

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

TBRDEPO

TBRDEPO_FEED_DOC_CODE

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

TBRDEPO

TBRDEPO_USER

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

NA

NA

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC A session, portion or part of the academic period. VARCHAR2(255)

NA

NA

TRANSACTION_NUMBER Transaction number associated with the deposit. NUMBER

TBRDEPO

TBRDEPO_TRAN_NUMBER



Ver: 8.0