Friday, January 14, 2022

IBY_EXTERNAL_PAYEES_ALL

This table captures Payment related details of the Supplier. For Example: The Supplier's remittance advice, the default Payment method Code for this supplier or the bank charges in case of SWIFT payments, etc. This information can be setup at Supplier Level or  Supplier Site Level.

SELECT iepa.* 
  FROM iby_external_payees_all iepa 
 WHERE iepa.payee_party_id = 123456
at
Labels:

1 comment:

Subscribe to: Post Comments (Atom)

Query To Fetch AP Invoice Details From SO Number(Doc ID 2949013.1)

SELECT dh.source_order_number       ,df.source_line_number as so_line_number   ,df.fulfill_line_number    ,ddr.doc_user_key as po_number...