ap_payment_schedules_all join ap_terms

ap_payment_schedules_all join ap_terms

In this post , we will be discuss about ap_payment_schedules_all join ap_terms. I will try to share the sql join between the  ap_payment_schedules_all and ap_terms. ap_payment_schedules_all stores the Information about due amount and due date. It help to store the AP Invoice information about when the payment will be due and due amount for the invoice. ap_terms is the master tables of Payment terms. We know that , Payment due date calculate based on the payment term. If the payment term is 30 days , then the due date will be invoice_date+30 days which will be store as a due date in  ap_payment_schedules_all . Here below is the detail explanation about ap_payment_schedules_all join ap_terms.

SQL Query using SQL Join Between ap_payment_schedules_all and ap_terms

select a2.invoice_num,a1.due_date,a3.name
from apps.ap_payment_schedules_all a1,
apps.ap_invoices_all a2,apps.ap_terms a3
where a1.invoice_id=a2.invoice_id
and a2.terms_id=a3.term_id