Skip to main content

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.

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?

 

SELECT contract, part_no, date_issued, qty_issued FROM internal_invent_part_issue_pub where customer_no = ‘xxx’

Hi Ravi,

This document contains some explanation as how the flows needs to be defined. Hope you’ll find it useful.

/Sangeetha.

Terms & ConditionsCookie settings