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

SGHE Banner Operational Data Store
Composite View Target: AT_GRANT_ACCOUNT_DETAIL

Description Source composite view contains research accounting receivable account transaction detail information.

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_ACTUAL_COST_AMOUNT Actual cost amount of the transaction. NUMBER(17, 2)

TRRACCD

TRRACCD_ACTUAL_COST_AMT

ACCOUNT_AMOUNT Amount of the transaction. NUMBER(17, 2)

TRRACCD

TRRACCD_AMOUNT

ACCOUNT_BALANCE Remaining balance of the charge amount on the transaction. NUMBER(17, 2)

TRRACCD

TRRACCD_BALANCE

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

TRRACCD

TRRACCD_COAS_CODE

ACCOUNT_CHART_OF_ACCOUNTS_DESC Retrieved description or title of the associated chart of accounts. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

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

TRRACCD

TRRACCD_FUND_CODE

ACCOUNT_FUND_DESC Retrieved description or title of the associated fund. VARCHAR2(35)

FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_FUND_STATUS Extracted current status of the associated fund. VARCHAR2(1)

FUNCTION

F_GET_FINANCE_STATUS

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)

TRRACCD

TRRACCD_ACCT_FEED_IND

ACCOUNT_TRANSACTION_NUMBER A unique one up number assigned to each transaction within the grants account. NUMBER(8)

TRRACCD

TRRACCD_TRAN_NUMBER

ADJUSTED_BILLED_INVOICE_NUMBER Billed invoice number adjusted on the charge. NUMBER(5)

TRRACCD

TRRACCD_BILL_INV_ADJ_NO

ADJUSTED_PAID_INVOICE_NUMBER Adjusted invoice number paid with the payment. NUMBER(5)

TRRACCD

TRRACCD_PAID_INV_ADJ_NO

BILLED_INVOICE_NUMBER Invoice number billed on the charge. NUMBER(5)

TRRACCD

TRRACCD_BILL_INV_SEQ_NO

BILL_DATE Date that the transaction was billed. DATE

TRRACCD

TRRACCD_BILL_DATE

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

TRRACCD

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

TRRACCD

TRRACCD_SESSION_NUMBER

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)

TRRACCD

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

TBBDETC

TBBDETC_TYPE_IND

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

NA

NA

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

TRRACCD

TRRACCD_EFFECTIVE_DATE

ENTRY_DATE Date the transaction was entered on the account. DATE

TRRACCD

TRRACCD_ENTRY_DATE

GRANT_ID Unique user defined or system generated one-up number for this grant. VARCHAR2(9)

TRRACCD

TRRACCD_GRNT_CODE

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

PAID_INVOICE_NUMBER Invoice number paid with the payment. NUMBER(5)

TRRACCD

TRRACCD_PAID_INV_SEQ_NO

PAYMENT_REFERENCE_NUMBER External reference number of item used to make payment. Can be credit card, wire payment, check number, etc. VARCHAR2(20)

TRRACCD

TRRACCD_PAYMENT_ID

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

TRRACCD

TRRACCD_FEED_DATE

POSTING_DOCUMENT Document number used to post the accounting transaction into the ledgers. VARCHAR2(8)

TRRACCD

TRRACCD_FEED_DOC_CODE

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

TRRACCD

TRRACCD_USER_ID

REBILL_IND Used to trigger payment rebill on the account. VARCHAR2(1)

TRRACCD

TRRACCD_REBILL_IND

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

TRRACCD

TRRACCD_SRCE_CODE

SOURCE_DESC Extracted source code description. VARCHAR2(35)

FUNCTION

GOKODSF.F_GET_DESC

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

TRRACCD

TRRACCD_TRANS_DATE

TRANSACTION_DESC Accounting transaction description. VARCHAR2(30)

TRRACCD

TRRACCD_DESC

TRANSACTION_NUMBER_PAID Specified transaction number used to apply a payment directly against with this transaction. NUMBER(8)

TRRACCD

TRRACCD_TRAN_NUMBER_PAID

WITHHOLDING_AMOUNT Amount to withhold from the billed agency. NUMBER(17, 2)

TRRACCD

TRRACCD_WITHHOLDING_AMT

WITHHOLDING_IND Determines if withholding an amount to the billed agency. VARCHAR2(1)

TRRACCD

TRRACCD_WITHHOLDING_IND

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