Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_INVOICE_CHECK

Description Source composite view contains check information for invoices.

Target Column Business Definition Database Data Type Source Name Source Column
BANK Code used to identify the bank account on all cash transactions. VARCHAR2(2)

FABINCK

FABINCK_BANK_CODE

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

GXVBANK

GXVBANK_ACCT_NAME

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

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

FABINCK

FABINCK_CANCEL_IND

CHECK_DATE Date of issue for a check. DATE

FABINCK

FABINCK_CHECK_DATE

CHECK_NUMBER Printed check number. VARCHAR2(8)

FABINCK

FABINCK_CHECK_NUM

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

FABINCK

FABINCK_CHECK_TYPE_IND

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

INVOICE Invoice document number. VARCHAR2(8)

FABINCK

FABINCK_INVH_CODE

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NET_AMOUNT Net amount of an invoice. NUMBER(17,2)

FABINCK

FABINCK_NET_AMT

RECONCILIATION_IND Indicates whether a check has been reconciled for that invoice. VARCHAR2(1)

FABINCK

FABINCK_RECON_IND

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

NA

NA



Ver: 8.0