SELECT * FROM ap_invoices_all WHERE invoice_num='54235243'; -- invoice_id : 10160
SELECT * FROM ap_invoice_payments_all WHERE invoice_id=10160; --check_id : 63272
SELECT * FROM ap_checks_all WHERE check_id=63272; --payment_id=33191
SELECT * FROM iby_payments_all WHERE payment_id=33191; --payment_process_request_name='Quick Payment: ID=63272' payment_instruction_id='10763' payment_service_request_id='971'
SELECT *
FROM iby_pay_service_requests
WHERE call_app_pay_service_req_code='Quick Payment: ID=63272'
AND payment_service_request_id ='971';
SELECT * FROM iby_pay_instructions_all WHERE payment_instruction_id='10763';
SELECT *
FROM ap_inv_selection_criteria_all
WHERE checkrun_name= <<call_app_pay_service_req_code>>; --No Entries for Quick Payments
SELECT * FROM ap_invoice_payments_all WHERE invoice_id=10160; --check_id : 63272
SELECT * FROM ap_checks_all WHERE check_id=63272; --payment_id=33191
SELECT * FROM iby_payments_all WHERE payment_id=33191; --payment_process_request_name='Quick Payment: ID=63272' payment_instruction_id='10763' payment_service_request_id='971'
SELECT *
FROM iby_pay_service_requests
WHERE call_app_pay_service_req_code='Quick Payment: ID=63272'
AND payment_service_request_id ='971';
SELECT * FROM iby_pay_instructions_all WHERE payment_instruction_id='10763';
SELECT *
FROM ap_inv_selection_criteria_all
WHERE checkrun_name= <<call_app_pay_service_req_code>>; --No Entries for Quick Payments
thanks a lot !!
ReplyDelete