Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Accounts Receivable Composite View Reports

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 Local Source Local Target
ACADEMIC_PERIOD Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(6)

TBRACCD

TBRACCD_TERM_CODE

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
ACCOUNT_DETAIL_ACTIVITY_DATE The last date this row was created or updated. DATE

TBRACCD

TBRACCD_ACTIVITY_DATE

NO

NO
ACCOUNT_DETAIL_DATA_ORIGIN   VARCHAR2(30)       NO
ACCOUNT_DETAIL_USER_ID   VARCHAR2(30)       NO
ACCOUNT_POSTED_AMOUNT Amount that has been posted. NUMBER

CALCULATION

DECODE(TBRACCD_FEED_DATE, NULL, NULL, TBRACCD_AMOUNT)

NO

NO
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

NO

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

TBRACCD

TBRACCD_PIDM

NO

NO
AID YEAR Aid year associated with financial aid disbursement. VARCHAR2(4)

TBRACCD

TBRACCD_AIDY_CODE

NO

NO
AID_ENROLLMENT_PERIOD Aid enrollment period associated with the financial aid disbursement. This period can span multiple student terms. VARCHAR2(15)

TBRACCD

TBRACCD_PERIOD

NO

NO
AID_YEAR   VARCHAR2(4)       NO
AMOUNT Sum of the amount of each account detail for this receivable account. NUMBER

TBRACCD

TBRACCD_AMOUNT

NO

NO
BALANCE Remaining balance for all account detail amounts after application of payments. NUMBER

TBRACCD

TBRACCD_BALANCE

NO

NO
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)

NO

NO
BILL_DATE Date that the transaction was billed. DATE

TBRACCD

TBRACCD_BILL_DATE

NO

NO
BILL_SEQUENCE Bill sequence. NUMBER

NA

NA

NO

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

TBRACCD

TBRACCD_CSHR_END_DATE

NO

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

TBRACCD

TBRACCD_CSHR_END_DATE

NO

NO
CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRACCD

TBRACCD_SESSION_NUMBER

NO

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

TBBDETC

TBBDETC_DCAT_CODE

NO

NO
CATEGORY_DESC Receivable category description. VARCHAR2(30)

TTVDCAT

TTVDCAT_DESC

NO

NO
CONTRACT_PYMT_TRANSACTION_IND   VARCHAR2(1)       NO
COURSE_REFERENCE_NUMBER Course Reference Number of the course which generated the charge, when Track by CRN is used in Fee Assessment. VARCHAR2(5)

TBRACCD

TBRACCD_CRN

NO

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

TBRACCD

TBRACCD_PAYMENT_ID

NO

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

TBRACCD

TBRACCD_CROSSREF_DCAT_CODE

NO

NO
CROSSREF_CATEGORY_DESC Specifies the category. VARCHAR2(30)

TTVDCAT

TTVDCAT_DESC

NO

NO
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

NO

NO
CROSSREF_DETAIL_CODE_DESC Detail code description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

NO

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

TBRACCD

TBRACCD_CROSSREF_PIDM

NO

NO
CROSSREF_NUMBER Number of the deposit, contract, or exemption associated with the transaction. NUMBER

TBRACCD

TBRACCD_CROSSREF_NUMBER

NO

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

TBRACCD

TBRACCD_CROSSREF_SRCE_CODE

NO

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

TTVSRCE

TTVSRCE_DESC

NO

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

NA

SYSDATE

NO

NO
DESIGNATOR_TYPE Indicates if the designator used to extract the finance accounting line was an academic period-based designator or a financial aid year-based designator. CHAR(1)       NO
DESIGNATOR_TYPE_DESC Designator type description. VARCHAR2(21)       NO
DETAIL_CODE Code defining type of transaction in accounts receivable. VARCHAR2(4)

TBRACCD

TBRACCD_DETAIL_CODE

NO

NO
DETAIL_CODE_DESC Transaction type description. VARCHAR2(30)

TBBDETC

TBBDETC_DESC

NO

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

TBRACCD

TBRACCD_DOCUMENT_NUMBER

NO

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

TBRACCD

TBRACCD_DUE_DATE

NO

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

NA

NA

NO

NO
DUE_DATE Payment due date. DATE

TBRACCD

TBRACCD_EFFECTIVE_DATE

NO

NO
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

NO

NO
ENTRY_DATE Date this transaction was entered on the account. DATE

TRRACCD

TRRACCD_ENTRY_DATE

NO

NO
EXTERNAL_IND External indicator. VARCHAR2(0)

NA

NA

NO

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

NA

NA

NO

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

TBRACCD

TBRACCD_CURR_CODE

NO

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

TBRACCD

TBRACCD_FOREIGN_AMOUNT

NO

NO
FOREIGN_CURRENCY_DESC Currency code description or title. VARCHAR2(35)

GTVCURR

GTVCURR_TITLE

NO

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

TBRACCD

TBRACCD_INVOICE_NUMBER

NO

NO
JOURNAL_ENTRY Journal entry. VARCHAR2(0)

NA

NA

NO

NO
JOURNAL_SOURCE Journal source. VARCHAR2(0)

NA

NA

NO

NO
LEDGER_DESIGNATOR Academic period-based or financial aid year-based designator used when using the current date (today) to reconcile balances in Accounts Receivable to the balances in the Finance general ledger for an account. VARCHAR2(2)       NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
OPERATING_DATE Date used to extract the accounting line for the initial feed of this transaction to finance. DATE       NO
OPERATING_DESIGNATOR Academic period-based or financial aid year-based designator used when using the finance feed date to find the accounting line fed to the Finance ledgers for a charge, payment or application of payments transaction. VARCHAR2(2)       NO
POSTING_DATE Date the accounting transaction was interfaced to the financial ledgers. DATE

TBRACCD

TBRACCD_FEED_DATE

NO

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

TBRACCD

TBRACCD_FEED_DOC_CODE

NO

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

TBRACCD

TBRACCD_USER

NO

NO
PRE_BILL_FLAG Pre bill flag. VARCHAR2(0)

NA

NA

NO

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

TBBDETC

TBBDETC_PRIORITY

NO

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

TBRACCD

TBRACCD_RECEIPT_NUMBER

NO

NO
REFUND Indicates the type of refund if the transaction is determined as a refund. VARCHAR2(1)

TBBDETC

TBBDETC_REFUND_IND

NO

NO
REFUND_DESC Refund description. VARCHAR2(18)

CALCULATION

CASE WHEN TBBDETC_REFUND_IND

NO

NO
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')

NO

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

TBRACCD

TBRACCD_SRCE_CODE

NO

NO
SOURCE_DESC Source code extracted description. VARCHAR2(30)

TTVSRCE

TTVSRCE_DESC

NO

NO
STATEMENT_DATE The date a statement was generated. DATE

TBRACCD

TBRACCD_STATEMENT_DATE

NO

NO
STUDY_PATH Study path key sequence for the course registration. NUMBER

TBRACCD

TBRACCD_STSP_KEY_SEQUENCE

NO

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

NA

NA

NO

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

NA

NA

NO

NO
TAX_AMOUNT Amount of the transaction reported for 1098-t purposes. NUMBER

TBRACCD

TBRACCD_TAX_AMOUNT

NO

NO
TAX_DOCUMENT Tax document. VARCHAR2(0)

NA

NA

NO

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

TBRACCD

TBRACCD_TAX_REPT_BOX

NO

NO
TAX_DOCUMENT_BOX_NUMBER_PR Tax Report Box in which the transaction was eligible for reporting on the form 1098T. Values (PR) Qualified Payments Received, (AP) Adjustments to Payments Received. VARCHAR2(2)

TBRACCD

TBRACCD_TAX_REPT_BOX_PR

NO

NO
TAX_DOCUMENT_BOX_NUMBER_SG Tax Report Box in which the transaction was reported on the form 1098T. Values (SG) Scholarship or Grant, (AS) Adjustments to Scholarship or Grant. VARCHAR2(2)

TBRACCD

TBRACCD_TAX_REPT_BOX_SG

NO

NO
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

NO

NO
TAX_FUTURE_ITEM_PR Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule PR, or null. VARCHAR2(1)

TBRACCD

TBRACCD_TAX_FUTURE_IND_PR

NO

NO
TAX_FUTURE_ITEM_SG Tax Report Future Indicator is valued with Y if the transaction was reported on form 1098-T as a term beginning in a future tax year for rule SG, or null. VARCHAR2(1)

TBRACCD

TBRACCD_TAX_FUTURE_IND_SG

NO

NO
TAX_YEAR Tax year the transaction is reported for 1098-t purposes. NUMBER

TBRACCD

TBRACCD_TAX_REPT_YEAR

NO

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

TBRACCD

TBRACCD_TRANS_DATE

NO

NO
TRANSACTION_DESC Accounting transaction description. VARCHAR2(30)

TBRACCD

TBRACCD_DESC

NO

NO
TRANSACTION_NUMBER Transaction number. NUMBER

TBRACCD

TBRACCD_TRAN_NUMBER

NO

NO
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

TBRACCD

TBRACCD_TRAN_NUMBER_PAID

NO

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

NA

NA

NO

NO


Ver: