RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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

Target Column Business Definition Database Data Type Source Name Source Column
ACCOUNT_ACTUAL_COST_AMOUNT Actual cost amount of the transaction. NUMBER

TRRACCD

TRRACCD_ACTUAL_COST_AMT

ACCOUNT_AMOUNT Amount of the transaction. NUMBER

TRRACCD

TRRACCD_AMOUNT

ACCOUNT_BALANCE Remaining balance of the charge amount on the transaction. NUMBER

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

TRRACCD

TRRACCD_COAS_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

TRRACCD

TRRACCD_FUND_CODE

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

FUNCTION

F_GET_FINANCE_DESC

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

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

TRRACCD

TRRACCD_ACCT_FEED_IND

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

TRRACCD

TRRACCD_TRAN_NUMBER

ADJUSTED_BILLED_INVOICE_NUMBER Billed invoice number adjusted on the charge. NUMBER

TRRACCD

TRRACCD_BILL_INV_ADJ_NO

ADJUSTED_PAID_INVOICE_NUMBER Adjusted invoice number paid with the payment. NUMBER

TRRACCD

TRRACCD_PAID_INV_ADJ_NO

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

NA

NA

BILLED_INVOICE_NUMBER Invoice number billed on the charge. NUMBER

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

CALCULATION

TO_CHAR(TBRACCD_CSHR_END_DATE)

CASHIER_SESSION_NUMBER Session number assigned to each cashier session. NUMBER

TRRACCD

TRRACCD_SESSION_NUMBER

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

TRRACCD

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

TBBDETC

TBBDETC_TYPE_IND

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

TRRACCD

TRRACCD_GRNT_CODE

LETTER_OF_CREDIT_NUMBER Actual letter of credit number associated to the payment management system code. VARCHAR2(63)

FRVPMSC

FRVPMSC_LOC_NO

LONG_TITLE Grant long title or description. VARCHAR2(256)

FRBGRNT

FRBGRNT_LONG_TITLE

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

PAID_INVOICE_NUMBER Invoice number paid with the payment. NUMBER

TRRACCD

TRRACCD_PAID_INV_SEQ_NO

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 system description. VARCHAR2(255)

FRVPMSC

FRVPMSC_DESC

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 Date the accounting transaction was interfaced to the financial ledgers. DATE

TRRACCD

TRRACCD_FEED_DATE

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

TRRACCD

TRRACCD_FEED_DOC_CODE

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

TRRACCD

TRRACCD_USER_ID

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

NA

NA

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

TRRACCD

TRRACCD_REBILL_IND

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

FRBGRNT

FRBGRNT_TITLE

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

TRRACCD

TRRACCD_SRCE_CODE

SOURCE_DESC Source code extracted description. VARCHAR2(255)

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

TRRACCD

TRRACCD_DESC

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

TRRACCD

TRRACCD_TRAN_NUMBER_PAID

WITHHOLDING_AMOUNT Amount to withhold from the billed agency. NUMBER

TRRACCD

TRRACCD_WITHHOLDING_AMT

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

TRRACCD

TRRACCD_WITHHOLDING_IND



Ver: 3.1