...
In the Select Statement, you can choose to leave it blank, thus selecting ALL Vendors. OROr, you can choose to select a single Vendor or a subset of Vendors based on Vendor setup APVNM.ACV.
...
Each IRW report in AMS has a feature to help you build the report, showing you a list of available codes and descriptions. More documentation can be found here: Integrated Report Writer Documentation.
To use the wizard place your cursor in the SELECT statement and click on the drop-down arrow that appears at the end of the field.
...
<> Not Equal to
> Greater Than
< Ledd Less Than
~ Containes
| Does Not Contain
...