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

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 Local Source Local Target
AUTOMATED_CLEARING_HOUSE_IND Indicates if the payment was made via direct deposit. VARCHAR2(1)

FABCHKS

FABCHKS_ACH_IND

NO

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

FABCHKS

FABCHKS_BANK_CODE

NO

NO
BANK_CHECK_AMOUNT Bank check amount. NUMBER(17,2)

FABBKTP

FABBKTP_AMT

NO

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

GXVBANK

GXVBANK_ACCT_NAME

NO

NO
BANK_RECONCILIATION_IND Indicates whether a check has been reconciled against the bank in the bank transaction table. (R)econciled or (F)inal reconciliation. VARCHAR2(1)

FABBKTP

FABBKTP_RECON_IND

NO

NO
BANK_RECONCILIATION_IND_DESC Bank reconciliation indicator description. VARCHAR2(14)

CALCULATION

CASE WHEN FABBKTP_RECON_IND

NO

NO
BANK_TRANSACTION_COMMENT Bank transaction comment. VARCHAR2(35)

FABBKTP

FABBKTP_DESC

NO

NO
BANK_TRANSACTION_DATE Date the bank processed the check. DATE

FABBKTP

FABBKTP_TRANS_DATE

NO

NO
CANCEL_DATE Check cancellation date. DATE

FABCHKS

FABCHKS_CANCEL_DATE

NO

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

FABCHKS

FABCHKS_CANCEL_IND

NO

NO
CHECK_AMOUNT Check amount. NUMBER

FABCHKS

FABCHKS_CHECK_AMT

NO

NO
CHECK_DATE Check issue date. DATE

FABCHKS

FABCHKS_CHECK_DATE

NO

NO
CHECK_NUMBER Printed check number. VARCHAR2(8)

FABCHKS

FABCHKS_CHECK_NUM

NO

NO
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

NO

NO
CHECK_TYPE_DESC Check type description. VARCHAR2(16)

CALCULATION

CASE WHEN FABCHKS_CHECK_TYPE_IND

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

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

FABCHKS

FABCHKS_RECON_IND

NO

NO
RECONCILIATION_IND_DESC Reconciliation indicator description. VARCHAR2(14)

CALCULATION

CASE WHEN FABCHKS_RECON_IND

NO

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

NA

NA

NO

NO


Ver: