Event table

[new_otm]

Hi,

I have created an event for a shipment. Using a query i want to take the values ‘Event date ’ and ‘Location’ but i can’t find in which table are stored.
Does anyone know the name of the table?
I can get the event on ss_shipment_event_group table but i can't get the detail of it.


Thanks.

[cunninghamg]

Re: Event table

Hi

You need the ie_shipmentstatus table - though you will need to join in the i_transaction table to relate it to your shipment..

select t.object_gid, s.*
from ie_shipmentstatus s, i_transaction t
where s.I_TRANSACTION_NO=t.I_TRANSACTION_NO
and t.object_gid = <SHIPMENT_GID>

Gary

[new_otm]

Re: Event table

Hi,

Thank you very much. I have solved my problem.

Thanks.