Skip to main content

I need to get a list of Suppliers with the following Columns

  1. Supplier ID
  2. Supplier Name
  3. Del Terms
  4. Del Terms Location

 

If I go with the query builder, can you help with the SQL Query I should write? 

Or is there a IFS window I can get the excel output directly? I couldn’t find one. 

Hi @EnzoFerrari ,

 

Try something like below. 


SELECT s.supplier_id,
       s.NAME,e. address_id,e.delivery_terms,e.del_terms_location
FROM   ifsapp.supplier_info_general s,ifsapp.supplier_address_ent e
WHERE  s.supplier_id=e.supplier_id
ORDER BY s.supplier_id

Terms & ConditionsCookie settings