×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
