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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
BANK Code used to identify the bank account on all cash transactions.    

FABINCK

FABINCK_BANK_CODE

 
BANK_DESC Name of the bank where the institution has accounts.    

GXVBANK

GXVBANK_ACCT_NAME

 
BANK_ID ID of the bank where the Institution has accounts.    

SPRIDEN

SPRIDEN_ID

 
BANK_NAME Official banking institution name.    

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

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

GXVBANK

GXVBANK_BANK_CODE_PIDM

 
CANCEL_DATE Date the check was cancelled.    

FABINCK

FABINCK_CANCEL_DATE

 
CANCEL_IND Indicates if the check was canceled.    

FABINCK

FABINCK_CANCEL_IND

 
CHECK_DATE Date of issue for a check.    

FABINCK

FABINCK_CHECK_DATE

 
CHECK_NUMBER Printed check number.    

FABINCK

FABINCK_CHECK_NUM

 
CHECK_TYPE Identifies whether the check was a manual, batch, direct deposit or online type.    

FABINCK

FABINCK_CHECK_TYPE_IND

 
INVOICE Invoice document number.    

FABINCK

FABINCK_INVH_CODE

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
NET_AMOUNT Net amount of an invoice.    

FABINCK

FABINCK_NET_AMT

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

NA

NA

 
RECONCILIATION_IND Indicates whether a check has been reconciled for that invoice.    

FABCHKS

FABCHKS_RECON_IND

 


Ver: 8.3