TABLE NAME FOR PAID VENDORS 1

[villica]

Hello everyone, what is the name of the table that I would use in a query for vendors that we issued cheques to since last year or this year/?

villica

 

[RobertC22]

The table that holds the historical payables transaction in PM30200.
For payments only, limit to Control Type = 1

select disctin VENDORID
from PM30200 
where CNTRLTYP = 1
and DOCDATE >= '2008.01.01'

------
Robert

 

[villica]

thank you

villica