RETURN TO REPORTING VIEW REPORTS LIST
Finance Reporting View Reports

SGHE 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 INVOICE, CHECK_NUMBER, BANK
CHECK_NUMBER, BANK

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

NA

NA

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

FABINCK

FABINCK_BANK_CODE

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

SPRIDEN

SPRIDEN_ID

BANK_NAME Official banking institution name. VARCHAR2(63)

GXVBANK

SPRIDEN

GXVBANK_ACCT_NAME

SPRIDEN_LAST_NAME

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_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 Identifies whether the check was a manual, batch, direct deposit or online type. VARCHAR2(63)

FABINCK

FABINCK_CHECK_TYPE_IND

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

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 for that invoice. VARCHAR2(63)

FABINCK

FABINCK_RECON_IND



Ver: 3.1