Monday, April 22, 2019

Retrieve System Notes of any transaction record

This sample query demonstrates how to retrieve the System Notes of a Sales Order record. In ODBC, System Notes are stored in the Notes_System view. To connect any transaction record with the Notes_System table, use Transaction_id of both Transactions and Notes_System. The Time_Entered column from the Notes_System is the US Pacific Time (PST) equivalent of what you see on the Date column on the System Notes tab from the record. The Date column is based on the user's timezone preference.

SELECT NS.* FROM NOTES_SYSTEM NS
JOIN TRANSACTIONS T
   ON T.TRANSACTION_ID = NS.TRANSACTION_ID
WHERE T.TRANSACTION_ID = 9319
ORDER BY NS.TIME_ENTERED DESC

No comments:

Post a Comment