Go To View:  RETURN TO COMPOSITE VIEW 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.

Target Column Business Definition Database Data Type Source Name Source Column
AUTOMATED_CLEARING_HOUSE_IND Indicates if the 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(2)

FABCHKS

FABCHKS_BANK_CODE

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

GXVBANK

GXVBANK_ACCT_NAME

CANCEL_DATE Check cancellation date. DATE

FABCHKS

FABCHKS_CANCEL_DATE

CANCEL_IND Indicates if the check was cancelled. VARCHAR2(1)

FABCHKS

FABCHKS_CANCEL_IND

CHECK_AMOUNT Check amount. NUMBER(17,2)

FABCHKS

FABCHKS_CHECK_AMT

CHECK_DATE Check issue date. DATE

FABCHKS

FABCHKS_CHECK_DATE

CHECK_NUMBER Printed check number. VARCHAR2(8)

FABCHKS

FABCHKS_CHECK_NUM

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

FABCHKS

FABCHKS_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

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

RECONCILIATION_IND Indicates if a check has been reconciled against the bank. VARCHAR2(1)

FABCHKS

FABCHKS_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