Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Accounts Receivable Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AT_ACCOUNT_DETAIL

Description Source composite view contains accounts receivable transaction detail information.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Transaction academic period code. VARCHAR2(6)

TBRACCD

TBRACCD_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

ACCOUNT_POSTED_AMOUNT Amount that has been posted. NUMBER

CALCULATION

DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_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(1)

TBRACCD

TBRACCD_ACCT_FEED_IND

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

TBRACCD

TBRACCD_PIDM

AMOUNT Amount of the transaction. NUMBER(12, 2)

TBRACCD

TBRACCD_AMOUNT

BALANCE Remaining balance of the amount on the transaction. NUMBER(12, 2)

TBRACCD

TBRACCD_BALANCE

BILL_AMOUNT Calculated amount of all the charges and payments on the receivable account that have been billed to the account holder. NUMBER

CALCULATION

DECODE(TBRACCD_BILL_DATE, NULL, NULL, TBRACCD_AMOUNT)

BILL_DATE Date that the transaction was billed. DATE

TBRACCD

TBRACCD_BILL_DATE

BILL_SEQUENCE Bill sequence. NUMBER

NA

NA

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

TBRACCD

TBRACCD_CSHR_END_DATE

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

TBRACCD

TBRACCD_CSHR_END_DATE

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

TBRACCD

TBRACCD_SESSION_NUMBER

CATEGORY Identities category for a receivable transaction type. Examples are registration, housing, meal, contract. VARCHAR2(3)

TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC Receivable category description. VARCHAR2(30)

TTVDCAT

TTVDCAT_DESC

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

TBRACCD

TBRACCD_PAYMENT_ID

CROSSREF_CATEGORY Category code that was the basis for a contract or exemption credit. VARCHAR2(3)

TBRACCD

TBRACCD_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC Specifies the category. VARCHAR2(30)

TTVDCAT

TTVDCAT_DESC

CROSSREF_DETAIL_CODE Detail code of the charge that is offset by a third party or exemption credit. VARCHAR2(4)

TBRACCD

TBRACCD_CROSSREF_DETAIL_CODE

CROSSREF_DETAIL_CODE_DESC Detail code description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

CROSSREF_ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER(8)

TBRACCD

TBRACCD_CROSSREF_PIDM

CROSSREF_NUMBER Number of the deposit, contract, or exemption associated with the transaction. NUMBER(8)

TBRACCD

TBRACCD_CROSSREF_NUMBER

CROSSREF_SOURCE Source code that was the basis for a contract or exemption credit. VARCHAR2(1)

TBRACCD

TBRACCD_CROSSREF_SRCE_CODE

CROSSREF_SOURCE_DESC Specifies the charge/payment detail source associated with the source code. VARCHAR2(30)

TTVSRCE

TTVSRCE_DESC

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

NA

SYSDATE

DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(4)

TBRACCD

TBRACCD_DETAIL_CODE

DETAIL_CODE_DESC Transaction type description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

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

TBRACCD

TBRACCD_DOCUMENT_NUMBER

DOCUMENT_NUMBER Document number which identifies a specific charge or payment. VARCHAR2(8)

TBRACCD

TBRACCD_DUE_DATE

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

NA

NA

DUE_DATE Payment due date. DATE

TBRACCD

TBRACCD_EFFECTIVE_DATE

EFFECTIVE_DATE Date the transaction becomes effective. As of this date, the transaction is calculated into amount due and is eligible to be fed to accounting. DATE

TBRACCD

TBRACCD_ENTRY_DATE

ENTRY_DATE Date this transaction was entered on the account. DATE

TRRACCD

TRRACCD_ENTRY_DATE

EXTERNAL_IND External indicator. VARCHAR2(0)

NA

NA

FINANCIAL_AID_UPLOAD_FIELD Links the financial aid fund to the AR transaction. VARCHAR2(0)

NA

NA

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

TBRACCD

TBRACCD_CURR_CODE

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

TBRACCD

TBRACCD_FOREIGN_AMOUNT

FOREIGN_CURRENCY_DESC Currency code description or title. VARCHAR2(35)

GTVCURR

GTVCURR_TITLE

INVOICE_NUMBER Invoice number assigned to the transaction. VARCHAR2(8)

TBRACCD

TBRACCD_INVOICE_NUMBER

JOURNAL_ENTRY Journal entry. VARCHAR2(0)

NA

NA

JOURNAL_SOURCE Journal source. VARCHAR2(0)

NA

NA

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

FUNCTION

F_TERM_CODE_TBDS

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

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

CALCULATION

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

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

FUNCTION

F_TERM_CODE_TBDS

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

TBRACCD

TBRACCD_FEED_DATE

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

TBRACCD

TBRACCD_FEED_DOC_CODE

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

TBRACCD

TBRACCD_USER

PRE_BILL_FLAG Pre bill flag. VARCHAR2(0)

NA

NA

PRIORITY Priority of the detail code for use in the application of payments process. VARCHAR2(3)

TBBDETC

TBBDETC_PRIORITY

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

TBRACCD

TBRACCD_RECEIPT_NUMBER

RETURNED_CHECK_IND Determines if the detail code has been identified as the code to use for returned checks. VARCHAR2(1)

CALCULATION

DECODE(TBBRETC_DETAIL_CODE,NULL,'N','Y')

SOURCE Identifies the source of how the transaction was entered on the account. VARCHAR2(1)

TBRACCD

TBRACCD_SRCE_CODE

SOURCE_DESC Source code extracted description. VARCHAR2(30)

TTVSRCE

TTVSRCE_DESC

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

NA

NA

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

NA

NA

TAX_AMOUNT Amount of the transaction reported for 1098-t purposes. NUMBER(12, 2)

TBRACCD

TBRACCD_TAX_AMOUNT

TAX_DOCUMENT Tax document. VARCHAR2(0)

NA

NA

TAX_DOCUMENT_BOX_NUMBER Box in which amounts are reported for 1098-t purposes. VARCHAR2(2)

TBRACCD

TBRACCD_TAX_REPT_BOX

TAX_FUTURE_ITEM Specifies if the transaction is reported as a academic period beginning in a future tax year. VARCHAR2(1)

TBRACCD

TBRACCD_TAX_FUTURE_IND

TAX_YEAR Tax year the transaction is reported for 1098-t purposes. NUMBER(4)

TBRACCD

TBRACCD_TAX_REPT_YEAR

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

TBRACCD

TBRACCD_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(30)

TBRACCD

TBRACCD_DESC

TRANSACTION_NUMBER Transaction number. NUMBER(8)

TBRACCD

TBRACCD_TRAN_NUMBER

TRAN_NUMBER_PAID Transaction number of a specific application of payment. This transaction was used to directly apply to the transaction number specified here. NUMBER(8)

TBRACCD

TBRACCD_TRAN_NUMBER_PAID

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

NA

NA



Ver: 8.0