Hello,
Can any one help me if IFS have template to write SQL in IFS to set up Demand Plan Base Flows? I want to set up the flow for internal, external and specially for customer specific demand for multiple site.
This topic has been closed for comments
Userlevel 7
+17
Hi Ravi,
You can use the base flow assistant window to configure the base flows.
Best Regards,
Rasika
Thank you very much, but how can we write SQL statement specifically to extract customer specific data or specifically for internal customers? Do you have SQL templates that we can look to understand what background data gets linked to the flows?
Userlevel 7
+17
SELECT contract, part_no, date_issued, qty_issued FROM internal_invent_part_issue_pub where customer_no = ‘xxx’
Userlevel 5
+7
Hi Ravi,
This document contains some explanation as how the flows needs to be defined. Hope you’ll find it useful.
/Sangeetha.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.