Query to get pay group from ap invoice installments page
Summary:
Hello, I am trying to get the pay group on the payables--> manage invoice --> invoice actions --> manage installment --> paygroup
On the table ap_payment_schedules_all , I found all the other information DUE_DATE, gross_amount, unpaid amount etc.
Also if the installment is on-hold or not.
But I cannot find the information in the installment header except for "Payment Reason Comment" that is itself in the payment_schedules table.
Where are the other information such as Unique Remittance Identifier, Paygroup, Check digits ...?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):