Re: File for Customer Order Notes in Notes Maintenance ORD140D2-01

On 10/17/2012 12:13 AM, ANTONISSE, David wrote:

Can someone tell me which file I need to use to download 'Customer Order Notes' in ORD140D2-01 Notes maintenance?

I need to modify a query which uses the files SIH, SIL, RCM, IIM and SSM.
I need to add customer order notes in the output.

David,

As others have told you, it's the ESN file. Now, you're likely to run into a problem adding it to your query that I had to educate many users about. What if there's more than one note per order? Let's say there's 3 lines of notes for this order, that will triple the records returned for this order's information.

Is this query an iSeries Query object, or are you doing something else and just using the generic query term? If you are downloading direct to a spreadsheet using MSQuery, I can give you a couple of ideas as to how to address the problem.

Bill