AP

Query for Supplier details with banks

SELECT                          aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier”                 ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”                 ,bank.party_name “bank_name”                 ,branch.bank_branch_name “Branch_Name”                 ,accts.country_code “account_country_code”                 ,accts.bank_account_name “Account_Name”                 ,accts.bank_account_num “Account_Number”…

Read More

Extract for Payments – Check and EFT

 SELECT     papf.employee_number  employee_number           , aps.vendor_name        payee_name           , ieba.bank_account_num  bank_account_number           ,…

Read More

AP Supplier Banks Payments Query

SELECT   pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code,          hou.NAME org_name, pv.vendor_id supplier_id,          pv.segment1 supplier_number, plc.description supplier_type,          pv.vendor_name supplier_name,    …

Read More