To Check import/ export code you would first need the tracking numbers of the shipments.

First log into the server on IEDE production.

There are two way you can check this

1st method:

• Use this SQL Script below to get data from Type3detail table using the tracking number

Select Type3detailID, * from Type3Detail where Trackingnumber = ‘xxxxxxxxxxxxx’

Open

We need the type 3 detail ID from Type3detail then we need to use this in Type3items table .

Copy the Type3detailID for the next query

• Use this SQL script to get the import/export hs codes:

Select Importhscode, Exporthscode, * from Type3items where Type3detailID = ‘xxxxxxxx’

Paste the Type3detailId from first query into this second one and you will get the import/exporthscodes

Open

2nd Method :

Use this Inner Join SQl sript below : You only need to include the tracking number here

SELECT
i.ImportHSCode,
i.ExportHSCode,
d.,
i.
FROM Type3Detail d
INNER JOIN Type3Items i
ON d.Type3DetailId = i.Type3DetailId
WHERE d.TrackingNumber = 'xxxxxxxxxxx';

Open

Checking if file has been manifested

To check this you would need the tracking number and use the above script for type 3 detail table.

If there is data present in Type3detail for the tracking number it means it has been manifested. This may take few minutes to show up on the DB.

Script to use :

Select * from Type3Detail where Trackingnumber = ‘xxxxxxxxxxxxx’

Open