What table is this in sql?

(0) Share

Report

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

I have the same question (0)

All responses (11)

Answers (2)

sueconrod 337 on at

Like (0)

Report

RE: What table is this in sql?

Jeffrey: Your picture didn't show up, what section of the sales order are you looking at:

Customer Master

Customer Address Master

Sales Order Header

Sales Order Line

Sales Order Distribution

Comment Fields

Totals

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

RE: What table is this in sql?

Nothing is showing Jeff.

Was this reply helpful? Yes No
Jeffrey A 210 on at

Like (0)

Report

RE: What table is this in sql?

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

Was this reply helpful? Yes No
Jeffrey A 210 on at

Like (0)

Report

RE: What table is this in sql?

Just added it to the post, thank you!

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Jeffrey A 210 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

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!!!

Was this reply helpful? Yes No
Verified answer

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
soma 24,410 on at

Like (0)

Report

RE: What table is this in sql?

Also refer the SOP30200.NOTEINDX for historical sales documents.

Hope this helps!!!

Was this reply helpful? Yes No
Jeffrey A 210 on at

Like (0)

Report

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!

Was this reply helpful? Yes No