Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Finance Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AF_CHECKS

Description Source composite view contains information about a processed check from accounts payable.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
AUTOMATED_CLEARING_HOUSE_IND Indicates if the payment was made via direct deposit.    

FABCHKS

FABCHKS_ACH_IND

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

FABCHKS

FABCHKS_BANK_CODE

 
BANK_DESC Name of the bank where the institution has accounts.    

GXVBANK

GXVBANK_ACCT_NAME

 
CANCEL_DATE Check cancellation date.    

FABCHKS

FABCHKS_CANCEL_DATE

 
CANCEL_IND Indicates if the check was cancelled.    

FABCHKS

FABCHKS_CANCEL_IND

 
CHECK_AMOUNT Check amount.    

FABCHKS

FABCHKS_CHECK_AMT

 
CHECK_DATE Check issue date.    

FABCHKS

FABCHKS_CHECK_DATE

 
CHECK_NUMBER Printed check number.    

FABCHKS

FABCHKS_CHECK_NUM

 
CHECK_TYPE Indicates how the check was produced. Either via a manual process, batch process ,or online process.    

FABCHKS

FABCHKS_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

 
MIF_DESC Institution description for the record 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

 
RECONCILIATION_IND Indicates if a check has been reconciled against the bank.    

FABCHKS

FABCHKS_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