Go To View:  RETURN TO BANNER COMP META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
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_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

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

NA

SYSDATE

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

NA

NA

 
INVOICE Invoice document number.    

FABINCK

FABINCK_INVH_CODE

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

NA

NA

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

NA

NA

 
NET_AMOUNT Net amount of an invoice.    

FABINCK

FABINCK_NET_AMT

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

FABINCK

FABINCK_RECON_IND

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

NA

NA

 


Ver: 8.3