Solved

Supplier List with Incoterm

  • 20 April 2021
  • 1 reply
  • 279 views
Asela Munasinghe
Rank
Userlevel 7
Badge +19

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. 

icon

Best answer by Dumeesha Wanigarathna 20 April 2021, 07:46

View original
Let's connect on LinkedIn: https://www.linkedin.com/in/asela61/
This topic has been closed for comments

1 reply

Dumeesha Wanigarathna
Rank
Userlevel 7
Badge +16

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

- Dumeesha -
Terms & ConditionsCookie settings