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 Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AUTOMATED_CLEARING_HOUSE_IND Indicates whether payment was made via direct deposit. VARCHAR2(1)

FABCHKS

FABCHKS_ACH_IND

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

FABINCK

FABINCK_BANK_CODE

BANK_CHECK_AMOUNT Bank check amount. NUMBER

FABBKTP

FABBKTP_AMT

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

GXVBANK

GXVBANK_ACCT_NAME

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

SPRIDEN

SPRIDEN_ID

BANK_NAME Official banking institution name. VARCHAR2(63)

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

BANK_RECONCILIATION_IND 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 Reconciliation indicator description. VARCHAR2(255)

CALCULATION

CASE WHEN FABBKTP_RECON_IND

BANK_TRANSACTION_COMMENT Bank transaction comment. VARCHAR2(255)

FABBKTP

FABBKTP_DESC

BANK_TRANSACTION_DATE Date the bank processed the check. DATE

FABBKTP

FABBKTP_TRANS_DATE

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

GXVBANK

GXVBANK_BANK_CODE_PIDM

CANCEL_DATE Date the check was cancelled. DATE

FABINCK

FABINCK_CANCEL_DATE

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

FABINCK

FABINCK_CANCEL_IND

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

FABCHKS

FABHCKS_ACTIVITY_DATE

CHECK_DATE Date of issue for a check. DATE

FABINCK

FABINCK_CHECK_DATE

CHECK_NUMBER Printed check number. VARCHAR2(63)

FABINCK

FABINCK_CHECK_NUM

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

FABINCK

FABINCK_CHECK_TYPE_IND

CHECK_TYPE_DESC Check type description. VARCHAR2(255)

CALCULATION

CASE WHEN FABCHKS_CHECK_TYPE_IND

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

FABCHKS

FABCHKS_USER_ID

INVOICE Invoice document number. VARCHAR2(63)

FABINCK

FABINCK_INVH_CODE

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

NET_AMOUNT Net amount of an invoice. NUMBER

FABINCK

FABINCK_NET_AMT

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

CALCULATION

CASE WHEN FABCHKS_PAY_TYPE

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

NA

NA

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

CALCULATION

CASE WHEN FABCHKS_RECON_IND



Ver: 8.5