Difference between AP_CHECKS_ALL & IBY_PAYMENTS_ALL

AP_CHECKS_ALL

Column name	Description
CHECK_ID	This is a system generated unique number and primary key for AP_CHECKS_ALL table. This is only internal identifier of a payment record and does not have any business significance.
CHECK_NUMBER	This is payment number. Following is stored for printed and electronic payments: Printed Payments: Payment document number i.e. check number from IBY_PAYMENTS_ALL. PAPER_DOCUMENT_NUMBER Electronic Payments (if payment document number is generated): Same as printed payments Electronic Payments: Payment reference number from IBY_PAYMENTS_ALL.PAYMENT_REFERENCE_NUMBER
CHECKRUN_NAME	Following data is stored in this column: For single payments: System generated quick payment ID For batch payments: User given payment process request ID
PAYMENT_ID	Foreign key to IBY_PAYMENTS_ALL
PAYMENT_DOCUMENT_ID	Foreign key to CE_PAYMENT_DOCUMENTS

IBY_PAYMENTS_ALL

Column name	Description
PAYMENT_ID	This is a system-generated unique number and primary key for IBY_PAYMENTS_ALL table. This is only an internal identifier of a payment record and does not have any business significance.
PAYMENT_REFERENCE_NUMBER	This is a system-generated unique number as explained earlier. This number is very important for external representation of a payment, especially for electronic payments where the payment document number is not available.
PAPER_DOCUMENT_NUMBER	This is the payment document number ("check number"). For electronic payments, the value in this column will be null if the payment document is not configured.
PAYMENT_PROCESS_REQUEST_NAME	This has the same information as AP_CHECKS_ALL. CHECKRUN_NAME: For single payments: System-generated Quick Payment ID For batch payments: User-given Payment Process Request ID