AP test report Copy link

Description

Categories

SQL 10 lines

select
aps.vendor_name,
aps.segment1 vendor_number,
aia.*
from
ap_suppliers aps,
ap_invoices_all aia
where
1=1 and
aps.vendor_id=aia.vendor_id

Parameters 3

ParameterTypeList of values SQL
SupplierLOV
aps.vendor_name=:vendor_name
Invoice Date FromDate
aia.invoice_date>=:invoice_date_from
Invoice Date ToDate
aia.invoice_date<:invoice_date_to+1