Reporting View Target: GRANT_RECEIVABLE_ACCT

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Finance Reporting View Reports

Banner Operational Data Store
Reporting View Target: GRANT_RECEIVABLE_ACCT_DETAIL

Description Contains detail receivable account transaction information for all grant charges and payments. .
Key & Frequency One row per grant ID per transaction number.
Recommended Search Columns GRANT_ID, ACCOUNT_TRANSACTION_NUMBER
CHART_OF_ACCOUNTS, FUND

Target Column Business Name Business Definition Database Data Type Source Name Source Column

ACCOUNT_ACTUAL_COST_AMOUNT Account Actual Cost Amount Actual cost amount of the transaction. NUMBER
TRRACCD

TRRACCD_ACTUAL_COST_AMT

ACCOUNT_AMOUNT Account Amount Amount of the transaction. NUMBER
TRRACCD

TRRACCD_AMOUNT

ACCOUNT_BALANCE Account Balance Remaining balance of the charge amount on the transaction. NUMBER
TRRACCD

TRRACCD_BALANCE

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

TRRACCD_COAS_CODE

ACCOUNT_CHART_OF_ACCOUNTS_DESC Account Chart Of Accounts Description Retrieved description or title of the associated chart of accounts. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_FUND Account Fund Funding source code used with this accounting transaction. VARCHAR2(63)
TRRACCD

TRRACCD_FUND_CODE

ACCOUNT_FUND_DESC Account Fund Description Retrieved description or title of the associated fund. VARCHAR2(255)
FUNCTION

F_GET_FINANCE_DESC

ACCOUNT_FUND_STATUS Account Fund Status Extracted current status of the associated fund. VARCHAR2(63)
FUNCTION

F_GET_FINANCE_STATUS

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

TRRACCD_ACCT_FEED_IND

ACCOUNT_TRANSACTION_NUMBER Account Transaction Number A unique one up number assigned to each transaction within the grants account. NUMBER
TRRACCD

TRRACCD_TRAN_NUMBER

ACCT_CHART_OF_ACCOUNTS_STATUS Account Chart Of Accounts Status Status of the account chart of accounts. VARCHAR2(63)
FTVCOAS

FTVCOAS_STATUS_IND

ADJUSTED_BILLED_INVOICE_NUMBER Adjusted Billed Invoice Number Billed invoice number adjusted on the charge. NUMBER
TRRACCD

TRRACCD_BILL_INV_ADJ_NO

ADJUSTED_PAID_INVOICE_NUMBER Adjusted Paid Invoice Number Adjusted invoice number paid with the payment. NUMBER
TRRACCD

TRRACCD_PAID_INV_ADJ_NO

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

NA

BILLED_INVOICE_NUMBER Billed Invoice Number Invoice number billed on the charge. NUMBER
TRRACCD

TRRACCD_BILL_INV_SEQ_NO

BILL_DATE Bill Date Date that the transaction was billed. DATE
TRRACCD

TRRACCD_BILL_DATE

CASHIER_END_DATE Cashier End Date Ending date of the cashiering session for the transaction. DATE
TRRACCD

TRRACCD_CSHR_END_DATE

CASHIER_END_TIME Cashier End Time Ending time of the cashiering session for the transaction. VARCHAR2(63)
CALCULATION

TO_CHAR(TRRACCD_CSHR_END_DATE,'HH24:MM:SS')

CASHIER_SESSION_NUMBER Cashier Session Number Session number assigned to each cashier session. NUMBER
TRRACCD

TRRACCD_SESSION_NUMBER

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

TRRACCD_DETAIL_CODE

DETAIL_CODE_DESC Detail Code Description Transaction type description. VARCHAR2(255)
TBBDETC

TBBDETC_DESC

DETAIL_CODE_TYPE Detail Code Type Determines if the detail code is being used as a charge or a payment. VARCHAR2(63)
TBBDETC

TBBDETC_TYPE_IND

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
TRRACCD

TRRACCD_EFFECTIVE_DATE

ENTRY_DATE Entry Date Date the transaction was entered on the account. DATE
TRRACCD

TRRACCD_ENTRY_DATE

GRANT_ID Grant ID Unique user defined or system generated one-up number for this grant. VARCHAR2(63)
TRRACCD

TRRACCD_GRNT_CODE

LETTER_OF_CREDIT_NUMBER Letter Of Credit Number Actual letter of credit number associated to the payment management system code. VARCHAR2(63)
FRVPMSC

FRVPMSC_LOC_NO

LONG_TITLE Long Title Grant long title or description. VARCHAR2(256)
FRBGRNT

FRBGRNT_LONG_TITLE

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

PAID_INVOICE_NUMBER Paid Invoice Number Invoice number paid with the payment. NUMBER
TRRACCD

TRRACCD_PAID_INV_SEQ_NO

PAYMENT_MANAGEMENT_SYS_CODE Payment Management Sys Code Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit. VARCHAR2(63)
FRBGBIL

FRBGBIL_PMSC_CODE

PAYMENT_MANAGEMENT_SYS_DESC Payment Management Sys Description Payment management system description. VARCHAR2(255)
FRVPMSC

FRVPMSC_DESC

PAYMENT_REFERENCE_NUMBER Payment Reference Number External reference number of item used to make payment. Can be credit card, wire payment, check number, etc. VARCHAR2(63)
TRRACCD

TRRACCD_PAYMENT_ID

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

TRRACCD_FEED_DATE

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

TRRACCD_FEED_DOC_CODE

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

TRRACCD_USER_ID

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

NA

REBILL_IND Rebill Indicator Used to trigger payment rebill on the account. VARCHAR2(63)
TRRACCD

TRRACCD_REBILL_IND

SHORT_TITLE Short Title Short name or title for the grant. VARCHAR2(255)
FRBGRNT

FRBGRNT_TITLE

SOURCE Source Identifies the source of how the transaction was entered on the account. VARCHAR2(63)
TRRACCD

TRRACCD_SRCE_CODE

SOURCE_DESC Source Description Source code extracted description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

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

TRRACCD_TRANS_DATE

TRANSACTION_DESC Transaction Description Accounting transaction description. VARCHAR2(255)
TRRACCD

TRRACCD_DESC

TRANSACTION_NUMBER_PAID Transaction Number Paid Specified transaction number used to apply a payment directly against with this transaction. NUMBER
TRRACCD

TRRACCD_TRAN_NUMBER_PAID

WITHHOLDING_AMOUNT Withholding Amount Amount to withhold from the billed agency. NUMBER
TRRACCD

TRRACCD_WITHHOLDING_AMT

WITHHOLDING_IND Withholding Indicator Determines if withholding an amount to the billed agency. VARCHAR2(63)
TRRACCD

TRRACCD_WITHHOLDING_IND

Ver: 9.2

Description	Contains detail receivable account transaction information for all grant charges and payments. .
Key & Frequency	One row per grant ID per transaction number.
Recommended Search Columns	GRANT_ID, ACCOUNT_TRANSACTION_NUMBER CHART_OF_ACCOUNTS, FUND

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACCOUNT_ACTUAL_COST_AMOUNT	Account Actual Cost Amount	Actual cost amount of the transaction.	NUMBER	TRRACCD	TRRACCD_ACTUAL_COST_AMT
ACCOUNT_AMOUNT	Account Amount	Amount of the transaction.	NUMBER	TRRACCD	TRRACCD_AMOUNT
ACCOUNT_BALANCE	Account Balance	Remaining balance of the charge amount on the transaction.	NUMBER	TRRACCD	TRRACCD_BALANCE
ACCOUNT_CHART_OF_ACCOUNTS	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(63)	TRRACCD	TRRACCD_COAS_CODE
ACCOUNT_CHART_OF_ACCOUNTS_DESC	Account Chart Of Accounts Description	Retrieved description or title of the associated chart of accounts.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_FUND	Account Fund	Funding source code used with this accounting transaction.	VARCHAR2(63)	TRRACCD	TRRACCD_FUND_CODE
ACCOUNT_FUND_DESC	Account Fund Description	Retrieved description or title of the associated fund.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ACCOUNT_FUND_STATUS	Account Fund Status	Extracted current status of the associated fund.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS
ACCOUNT_POSTING_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(63)	TRRACCD	TRRACCD_ACCT_FEED_IND
ACCOUNT_TRANSACTION_NUMBER	Account Transaction Number	A unique one up number assigned to each transaction within the grants account.	NUMBER	TRRACCD	TRRACCD_TRAN_NUMBER
ACCT_CHART_OF_ACCOUNTS_STATUS	Account Chart Of Accounts Status	Status of the account chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
ADJUSTED_BILLED_INVOICE_NUMBER	Adjusted Billed Invoice Number	Billed invoice number adjusted on the charge.	NUMBER	TRRACCD	TRRACCD_BILL_INV_ADJ_NO
ADJUSTED_PAID_INVOICE_NUMBER	Adjusted Paid Invoice Number	Adjusted invoice number paid with the payment.	NUMBER	TRRACCD	TRRACCD_PAID_INV_ADJ_NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
BILLED_INVOICE_NUMBER	Billed Invoice Number	Invoice number billed on the charge.	NUMBER	TRRACCD	TRRACCD_BILL_INV_SEQ_NO
BILL_DATE	Bill Date	Date that the transaction was billed.	DATE	TRRACCD	TRRACCD_BILL_DATE
CASHIER_END_DATE	Cashier End Date	Ending date of the cashiering session for the transaction.	DATE	TRRACCD	TRRACCD_CSHR_END_DATE
CASHIER_END_TIME	Cashier End Time	Ending time of the cashiering session for the transaction.	VARCHAR2(63)	CALCULATION	TO_CHAR(TRRACCD_CSHR_END_DATE,'HH24:MM:SS')
CASHIER_SESSION_NUMBER	Cashier Session Number	Session number assigned to each cashier session.	NUMBER	TRRACCD	TRRACCD_SESSION_NUMBER
DETAIL_CODE	Detail Code	Code defining type of transaction in accounts receivable.	VARCHAR2(63)	TRRACCD	TRRACCD_DETAIL_CODE
DETAIL_CODE_DESC	Detail Code Description	Transaction type description.	VARCHAR2(255)	TBBDETC	TBBDETC_DESC
DETAIL_CODE_TYPE	Detail Code Type	Determines if the detail code is being used as a charge or a payment.	VARCHAR2(63)	TBBDETC	TBBDETC_TYPE_IND
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	TRRACCD	TRRACCD_EFFECTIVE_DATE
ENTRY_DATE	Entry Date	Date the transaction was entered on the account.	DATE	TRRACCD	TRRACCD_ENTRY_DATE
GRANT_ID	Grant ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	TRRACCD	TRRACCD_GRNT_CODE
LETTER_OF_CREDIT_NUMBER	Letter Of Credit Number	Actual letter of credit number associated to the payment management system code.	VARCHAR2(63)	FRVPMSC	FRVPMSC_LOC_NO
LONG_TITLE	Long Title	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PAID_INVOICE_NUMBER	Paid Invoice Number	Invoice number paid with the payment.	NUMBER	TRRACCD	TRRACCD_PAID_INV_SEQ_NO
PAYMENT_MANAGEMENT_SYS_CODE	Payment Management Sys Code	Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit.	VARCHAR2(63)	FRBGBIL	FRBGBIL_PMSC_CODE
PAYMENT_MANAGEMENT_SYS_DESC	Payment Management Sys Description	Payment management system description.	VARCHAR2(255)	FRVPMSC	FRVPMSC_DESC
PAYMENT_REFERENCE_NUMBER	Payment Reference Number	External reference number of item used to make payment. Can be credit card, wire payment, check number, etc.	VARCHAR2(63)	TRRACCD	TRRACCD_PAYMENT_ID
POSTING_DATE	Posting Date	Date the accounting transaction was interfaced to the financial ledgers.	DATE	TRRACCD	TRRACCD_FEED_DATE
POSTING_DOCUMENT	Posting Document	Document code generated to identify and feed this transaction to finance.	VARCHAR2(63)	TRRACCD	TRRACCD_FEED_DOC_CODE
POST_CASHIER	Post Cashier	Identification code of the cashier who entered the transaction.	VARCHAR2(63)	TRRACCD	TRRACCD_USER_ID
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
REBILL_IND	Rebill Indicator	Used to trigger payment rebill on the account.	VARCHAR2(63)	TRRACCD	TRRACCD_REBILL_IND
SHORT_TITLE	Short Title	Short name or title for the grant.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE
SOURCE	Source	Identifies the source of how the transaction was entered on the account.	VARCHAR2(63)	TRRACCD	TRRACCD_SRCE_CODE
SOURCE_DESC	Source Description	Source code extracted description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TRANSACTION_DATE	Transaction Date	Date used by the finance system to control posting to the ledgers.	DATE	TRRACCD	TRRACCD_TRANS_DATE
TRANSACTION_DESC	Transaction Description	Accounting transaction description.	VARCHAR2(255)	TRRACCD	TRRACCD_DESC
TRANSACTION_NUMBER_PAID	Transaction Number Paid	Specified transaction number used to apply a payment directly against with this transaction.	NUMBER	TRRACCD	TRRACCD_TRAN_NUMBER_PAID
WITHHOLDING_AMOUNT	Withholding Amount	Amount to withhold from the billed agency.	NUMBER	TRRACCD	TRRACCD_WITHHOLDING_AMT
WITHHOLDING_IND	Withholding Indicator	Determines if withholding an amount to the billed agency.	VARCHAR2(63)	TRRACCD	TRRACCD_WITHHOLDING_IND