• Looking for description data for Payment Terms, Carrier, Delivery Mode

    Hello community, I am trying to add some description data to a customer facing crystal report and noticed I am only pulling the ID/ Code of the certain fields but need to show the full description of what that id/code is. Trying to add the descriptions…
  • Querying the SEI database directly

    What I am trying to do is write a query that will list all SEI processes and the Folders they are located in. I can't seem to find any table in the SEI database that contains the folder structure. Is what I'm trying to do possible? My organization is…
  • How to do a select distinct in Query tool

    I'm trying to create a new query so that my user can have a list of new prep lists on their landing page. using table STOPRELIS, I was able to create a query but there is a line per product, when I only want the prep list, pick ticket, and so number.…