Shipment Event Table

shahidali12 · #1 (**permalink**) June 7th, 2007, 11:03

Hi Gurus,

I am new in OTM, I just want to know which table using "Add Event for Location". Please reply as soon as possible, any help would be highly appriciating.
Thnx

Ali

AlejandroBarba · #2 (**permalink**) June 7th, 2007, 17:54

Hi Shahidali

I am not sure I understand your question correctly but I guess you are searching for the table where the events are posted, if that is the case, please try the table:
SS_STATUS_HISTORY

Hope this is what you were looking for,

Alejandro Barba

bmj_23 · #3 (**permalink**) June 7th, 2007, 21:29

For these types of questions, if you turn on the UIC (I think that is the part of the log files which is UI related) and SQL components of a log file, and then do whatever it is you want to do via the UI, the log file will show you the specific SQL statements that are being issued between what you do in the UI and the DB.

At the lowest level, that will tell you exactly what database tables are being impacted by what you do in the UI.