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

SGHE Banner Operational Data Store
Reporting View Target: INVOICE_CHECK

Description Contains check payment information for each invoice including bank information, check type, check date, check net amount, cancel indicator, cancel date, and reconciliation date.
Key & Frequency One row for invoice per check number per bank.
Recommended Search Columns CHECK_NUMBER, BANK
INVOICE, CHECK_NUMBER, BANK

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

AUTOMATED_CLEARING_HOUSE_IND Automated Clearing House Indicator Indicates whether payment was made via direct deposit. VARCHAR2(1)  

FABCHKS

FABCHKS_ACH_IND

BANK Bank Code used to identify the bank account on all cash transactions. VARCHAR2(63)  

FABINCK

FABINCK_BANK_CODE

BANK_CHECK_AMOUNT Bank Check Amount Bank check amount. NUMBER  

FABBKTP

FABBKTP_AMT

BANK_DESC Bank Description Name of the bank where the institution has accounts. VARCHAR2(255)  

GXVBANK

GXVBANK_ACCT_NAME

BANK_ID Bank ID ID of the bank where the Institution has accounts. VARCHAR2(63)  

SPRIDEN

SPRIDEN_ID

BANK_NAME Bank Name Official banking institution name. VARCHAR2(63)  

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

BANK_RECONCILIATION_IND Bank Reconciliation Indicator Indicates whether a check has been reconciled against the bank in the check transaction table. (R)econciled or (F)inal reconciliation. VARCHAR2(63)  

FABBKTP

FABBKTP_RECON_IND

BANK_RECONCILIATION_IND_DESC Bank Reconciliation Indicator Description Reconciliation indicator description. VARCHAR2(255)  

CALCULATION

CASE WHEN FABBKTP_RECON_IND

BANK_TRANSACTION_COMMENT Bank Transaction Comment Bank transaction comment. VARCHAR2(255)  

FABBKTP

FABBKTP_DESC

BANK_TRANSACTION_DATE Bank Transaction Date Date the bank processed the check. DATE  

FABBKTP

FABBKTP_TRANS_DATE

BANK_UID Bank UID Internal identification number of the bank where the institution has accounts. NUMBER  

GXVBANK

GXVBANK_BANK_CODE_PIDM

CANCEL_DATE Cancel Date Date the check was cancelled. DATE  

FABINCK

FABINCK_CANCEL_DATE

CANCEL_IND Cancel Indicator Indicates if the check was canceled. VARCHAR2(63)  

FABINCK

FABINCK_CANCEL_IND

CHECK_ACTIVITY_DATE Check Activity Date Date that information for this record in the table was entered or last updated. DATE  

FABCHKS

FABHCKS_ACTIVITY_DATE

CHECK_DATE Check Date Date of issue for a check. DATE  

FABINCK

FABINCK_CHECK_DATE

CHECK_NUMBER Check Number Printed check number. VARCHAR2(63)  

FABINCK

FABINCK_CHECK_NUM

CHECK_TYPE Check Type Indicates how the check was produced. VARCHAR2(63)  

FABINCK

FABINCK_CHECK_TYPE_IND

CHECK_TYPE_DESC Check Type Description Check type description. VARCHAR2(255)  

CALCULATION

CASE WHEN FABCHKS_CHECK_TYPE_IND

CHECK_USER_ID Check User ID Unique identification code of the user who entered or last touched the record. VARCHAR2(63)  

FABCHKS

FABCHKS_USER_ID

INVOICE Invoice Invoice document number. VARCHAR2(63)  

FABINCK

FABINCK_INVH_CODE

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

NET_AMOUNT Net Amount Net amount of an invoice. NUMBER  

FABINCK

FABINCK_NET_AMT

PAY_TYPE Pay Type Payment type descriptor used for payments initiated in Banner Finance as checks and sent for disbursement from PayNetExchange. VARCHAR2(63)  

FABCHKS

FABCHKS_PAY_TYPE

PAY_TYPE_DESC Pay Type Description Payment type description. VARCHAR2(255)  

CALCULATION

CASE WHEN FABCHKS_PAY_TYPE

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

NA

NA

RECONCILIATION_IND Reconciliation Indicator Indicates whether a check has been reconciled against the bank in the check transaction table. (R)econciled or (F)inal reconciliation. VARCHAR2(63)  

FABCHKS

FABCHKS_RECON_IND

RECONCILIATION_IND_DESC Reconciliation Indicator Description Reconciliation indicator description. VARCHAR2(255)  

CALCULATION

CASE WHEN FABCHKS_RECON_IND



Ver: 9.0