RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Accounts Receivable Reporting View Reports

SGHE Operational Data Store
Reporting View Target: RECEIVABLE_ACCOUNT_DETAIL

Description Contains account transaction detail for all payments and charges including academic period, detail code, category, priority, entry date, transaction amount, balance, bill date, due date, post cashier, and posting document.
Key & Frequency One row per account per transaction number.
Recommended Search Columns ENTITY_UID
ACCOUNT_UID, TRANSACTION_NUMBER
DETAIL_CODE
ACADEMIC_PERIOD

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

TBRACCD

TBRACCD_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(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

TBRACCD

TBRACCD_PIDM

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

NA

NA

AMOUNT Amount of the transaction. NUMBER

TBRACCD

TBRACCD_AMOUNT

BALANCE Remaining balance of the amount on the transaction. NUMBER

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

TBBCSHR

TBBCSHR_ACTIVITY_DATE

CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TBRACCD

TBRACCD_SESSION_NUMBER

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

TBBDETC

TBBDETC_DCAT_CODE

CATEGORY_DESC Receivable category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_PAYMENT_ID

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

TBRACCD

TBRACCD_CROSSREF_DCAT_CODE

CROSSREF_CATEGORY_DESC Specifies the category. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_CROSSREF_DETAIL_CODE

CROSSREF_DETAIL_CODE_DESC Detail code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_CROSSREF_PIDM

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

TBRACCD

TBRACCD_CROSSREF_NUMBER

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

TBRACCD

TBRACCD_CROSSREF_SRCE_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

TBRACCD

TBRACCD_DETAIL_CODE

DETAIL_CODE_DESC Transaction type description. VARCHAR2(255)

TBBDETC

TBBDETC_DESC

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

TBBDETC

TBBDETC_TYPE_IND

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

TBRACCD

TBRACCD_DOCUMENT_NUMBER

DUE_DATE Payment due date. DATE

TBRACCD

TBRACCD_DUE_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_EFFECTIVE_DATE

ENTRY_DATE Date this transaction was entered on the account. DATE

TBRACCD

TBRACCD_ENTRY_DATE

EXTERNAL_IND External indicator. VARCHAR2(255)

NA

NA

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

NA

NA

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

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

TBRACCD

TBRACCD_INVOICE_NUMBER

JOURNAL_ENTRY Journal entry. VARCHAR2(255)

NA

NA

JOURNAL_SOURCE Journal source. VARCHAR2(255)

NA

NA

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

FUNCTION

F_TERM_CODE_TBDS

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

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

TBRACCD

TBRACCD_FEED_DOC_CODE

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

TBRACCD

TBRACCD_USER

PRE_BILL_FLAG Pre bill flag. VARCHAR2(255)

NA

NA

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

TBBDETC

TBBDETC_PRIORITY

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

NA

NA

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

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

TBRACCD

TBRACCD_SRCE_CODE

SOURCE_DESC Source code extracted description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

TBRACCD

TBRACCD_TAX_AMOUNT

TAX_DOCUMENT Tax document. VARCHAR2(255)

NA

NA

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

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

TBRACCD

TBRACCD_TAX_FUTURE_IND

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

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

TBRACCD

TBRACCD_DESC

TRANSACTION_NUMBER Transaction number. NUMBER

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

TBRACCD

TBRACCD_TRAN_NUMBER_PAID



Ver: 3.1