Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / What table is this in ...
Microsoft Dynamics GP (Archived)

What table is this in sql?

(0) ShareShare
ReportReport
Posted on by Jeffrey A 210

I am looking to find out where in SQL can I find the highlighted piece below on a sales order?

Thank you!

Jeff

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What table is this in sql?

    Joining forces as well as SQL joins are a good thing. Soma is always right and provides very sharp and clear answers.

  • Jeffrey A Profile Picture
    Jeffrey A 210 on at
    RE: What table is this in sql?

    Thank you a ton to both you guys! The join for the two tables was huge!

    Appreciate the help!

  • soma Profile Picture
    soma 24,406 on at
    RE: What table is this in sql?

    Also refer the SOP30200.NOTEINDX for historical sales documents.

    Hope this helps!!!

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: What table is this in sql?

    Try running a query on the SOP10100 table. You will see SOP10100.NOTEINDX. This will be the note for the order header. You can then do a join with the SY03900 on that value to actually see the note.

  • Verified answer
    soma Profile Picture
    soma 24,406 on at
    RE: What table is this in sql?

    The document level note texts are saved in SY03900 tables based on the SOP document note index from the header table.

    Hope this helps!!!

  • Jeffrey A Profile Picture
    Jeffrey A 210 on at
    RE: What table is this in sql?

    I am guessing a record level....basically, any user can add a note in that field to the order for another user to read the notes associated with that order number....At least that's how its being used by us today.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: What table is this in sql?

    Are you talking about a Record level note? OLE note? or the new document attach feature in GP 2013 R2?

  • Jeffrey A Profile Picture
    Jeffrey A 210 on at
    RE: What table is this in sql?

    Just added it to the post, thank you!

  • Jeffrey A Profile Picture
    Jeffrey A 210 on at
    RE: What table is this in sql?

    Sorry! It didn't like my copy and paste, had to insert the image instead.

  • Jonathan Fear Profile Picture
    Jonathan Fear on at
    RE: What table is this in sql?

    Nothing is showing Jeff.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans