Create an ETSF Consignment
Overview
An External Temporary Storage Facility (ETSF) is a place situated outside the appointed area of a port or airport where chargeable goods may be held until they are processed by customs or re-rexported. If goods are being sent to an ETSF, a Consignment record can be created by an ETSF Operator or by a customs Agent. The instructions below describe how ETSF Operators can create ETSF Consignment records.
How to Create an ETSF Consignment Record
There are 2 ways to start creating an ETSF Consignment record:
Either
1) Select File from the main Sequoia toolbar at the top left hand side of the screen. A context menu will appear. Click on New followed by ETSF, followed by Consignment in the context menu.
or
2) Click on the ETSF module at the bottom left hand side of the screen. Next, right click on the List Panel area of the screen and a context menu will appear. Click on New followed by Consignment in the context menu.
A Basic ETSF Consignment editor will appear:
Enter Master/ Basic Air Waybill Information
PLEASE NOTE: You must enter the information that is declared on the Basic/ Master Air Waybill into the Basic ETSF Consignment editor before you can enter any House Air Waybill information.
You must familiarise yourself with the requirements of Customs Notice 216: customs procedures at CCS-UK locations before creating and updating ETSF Inventory Consignments
Next, type the Basic/ Master Air Waybill information described in the table below into the boxes of the Basic ETSF Consignment editor.
| Box | Information |
|---|---|
| Shed | The Shed Code followed by the Airport Code You can click on the  to the right of this box to display a list of codes and click on one to select it. If you only have access to one ETSF facility then Sequoia will automatically enter the code for that facility into this box |
| Master | The Master Air Waybill prefix and number, for example 125-12345670 |
| Origin (AOO) | The 3 character IATA Airport Code of the origin airport shown on the Air Waybill You can search for this code by typing a ? into this box or by clicking on the ellipsis (the 3 dots) to the right of this box which will display the Origin Lookup Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| Destination (AOD) | The 3 character IATA Airport Code of the destination airport shown on the Air Waybill Sequoia will automatically enter the IATA Airport Code of your ETSF but this can be changed if it is different. You can search for this code by typing a ? into this box or by clicking on the ellipsis (the 3 dots) to the right of this box which will display the Destination Lookup Dialog box. Next, click on the binoculars icon to display a list of codes and select the correct code by double clicking on it |
| Pieces Expected (NPX) | The number of packages declared on the Master Air Waybill |
| Gross Weight (GWT) | The gross weight declared on the Master Air Waybill |
| SDC | The SDC (Shipment Description Code) You should refer to Customs Notice 216 to gain an understanding of these codes. You can search for this code by typing a ? into this box or by clicking on the ellipsis (the 3 dots) to the right of this box which will display the Shipment Description (SDC) Lookup Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| Carrier | The Carrier Code You can search for this code by typing a ? into this box or by clicking on the ellipsis (the 3 dots) to the right of this box which will display the Carrier Lookup Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| Flight Number | The number of the flight (not including the Carrier Code) on which the goods arrived |
| Flight Date | The date on which the flight arrived |
| Goods Description | The description of the goods. This is limited to a maximum of 15 characters |
| Nominated Agent | The badge code of the Agent nominated to clear the goods You can search for this code by typing a ? into this box or by clicking on the ellipsis (the 3 dots) to the right of this box which will display the Agent Lookup Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| Status 2 | The Status 2 code indicates that you are happy for the Consignment to be released once the goods are cleared by customs Click on the in the right hand corner of this box and select either 'Yes' or 'No' |
| Transport Mode | The Transport Mode Code This code will not be transmitted as part of the Consignment information. Click on the in the right hand corner of this box to display a list of codes. Click on the correct one to select it and it will be added to the box. |
| Pieces Received (NPR) | The number of packages physically received You are not able to enter anything into this box. This box will automatically update when you record 'goods in' for this Consignment in the Goods in section of the Basic ETSF Consignment editor |
| Pieces Delivered (NPD) | The number of packages delivered You are not able to enter anything into this box. This box will automatically update when you record 'goods out' for this Consignment in the Goods out section of the Basic ETSF Consignment editor |
| Status 1 | The Status 1 code indicates that the number of packages physically received equal the number expected You are not able to enter anything into this box. This box will automatically update with the date that you physically receive all your packages and record this in the Goods in section of the Basic ETSF Consignment editor |
| End of Temp Storage | You are not able to enter anything into this box. A Consignnment of goods is only legally allowed to remain in temporay storage for a maximum of 90 days. This box will automatically update to display the number of days that you have left to declare the Consignment to customs |
| Agent Reference | You are not able to enter anything into this box. Once a customs Declaration has been made against this Inventory Consignment then the last 8 characters of the Agent Reference (as was inputted into box 7 of the customs Declaration) will be automatically added to this box |
| Consol Reference | You can enter your own Consolidation Reference if you would like to Please note that you cannot enter a Consolidation Reference here until you have entered any House Air Waybill information |
| External Reference | You can enter your own External Reference if you would like to Please note that if you enter your own External Reference here and this Inventory record is linked to a Job in Sequoia then the same External Reference will be automatically added to that Job |
| Transit MRN | The Transit MRN number If the creation of this Inventory record is as a result of discharging a transit movement into temporary storage then you can enter the Transit MRN number here. It will not be transmitted as part of the Consignment information but is available as part of the Find ETSF Inventory Records as a search option |
| Release Note Comments | You can enter any general notes you may have about the Consignment here Any text entered into this box will be printed on the release notes generated for this Consignment |
| Community Handling Codes | Any Community Handling Codes that were added to the airline record will be displayed here automatically |
If this Consignment only has Basic/ Master Air Waybills (i.e. there is no manifest with House Air Waybills attached) click on Send on the toolbar at the top left hand side of the Basic ETSF Consignment editor. This will close the editor and send the Consignment record will be sent to CCS-UK.
You can locate this Consignment record in Sequoia by clicking on the ETSF module at the bottom left hand side of the screen. Next, click on the ETSF Consignments folder at the top left hand side of the screen. All of your ETSF Consignment records will appear in the List Panel to the right of the ETSF Consignments folders.
If, however, this Consignment also has House Air Waybills then follow the instructions below.
Enter House Air Waybill Information
PLEASE NOTE: You must first enter any Basic/ Master Air Waybill information into the Basic ETSF Consignment editor before you can enter any House Air Waybill information. See the 'Enter Master/ Basic Airway Information' section above for instructions on how to do this. Adding a House Consignment record to the Basic ETSF Consignment editor turns this record into a Consolidation record (i.e. a consolidation of Consignments). You will see that the description in the top right hand corner of the editor has changed to 'Consolidation'.
Click on New House at the bottom of the Basic ETSF Consignment editor.
Enter the information described in the table below into the row that represents the House Consignment record in the Basic ETSF Consignment editor. You can type in the information by clicking in each corresponding column in the row.
| Box | Information |
|---|---|
| House | The House Air Waybill number (HAWB) This must be 8 characters only (upper case letters and numbers). If the House Air Waybill number has less that 8 characters then add zeros to the beginning of it to make it 8 characters. If it has more that 8 characters then only enter the last 8 characters |
| AOO | The 3 character IATA Airport Code of the origin airport shown on the House Air Waybill You can search for this code by typing a ? into this box which will display the Airport of Origin Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| AOD | The 3 character IATA Airport Code of the destination airport shown on the House Air Waybill Sequoia will automatically enter the IATA Airport Code of your ETSF but this can be changed manually if it is different. You can search for this code by typing a ? into this box which will display the Airport of Destination Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| NPX | The number of packages declared on the House Air Waybill |
| NPR | The number of packages physically received You are not able to enter anything into this box. This box will automatically update when you record 'goods in' for this Consignment in the Goods in section of the Basic ETSF Consignment editor |
| NPD | The number of packages delivered You are not able to enter anything into this box. This box will automatically update when you record 'goods out' for this Consignment in the Goods out section of the Basic ETSF Consignment editor. |
| GWT | The gross weight declared on the House Air Waybill |
| Goods Description | The description of the goods. This is limited to a maximum of 15 characters |
| SDC | The SDC (Shipment Description Code) You should refer to Customs Notice 216 to gain an understanding of these codes. Please note that if the SDC code of the Master is declared as M then at least one of the House Consignments must be declared as M. You can search for this code by typing a ? into this box which will display the Shipment Description (SDC) Lookup dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| Agent | The badge code of the Agent nominated to clear the goods You can search for this code by typing a ? into this box which will display the Agent Lookup Dialog box. Next, click on the binoculars icon to bring up a list of codes and select the correct code by double clicking on it |
| St2 | The Status 2 code indicates that you are happy for the Consignment to be released once the goods are cleared by customs Click on the in the right hand corner of this box and select either 'Yes' or 'No' |
| Status Description | The status of the Consignment You are unable to enter anything into this box. Sequoia will automatically add 'Awaiting Creation' into this box. It will automatically change and update as the Consignment progresses |
| Release Note Comments | You can enter any general notes you may have about the Consignment here Any text entered into this box will be printed on the release notes generated for this Consignment |
| External Reference | You can enter your own External Reference if you would like to Please note that if you enter your own External Reference here and this Inventory record is linked to a Job in Sequoia then the same External Reference will automatically be added to that Job |
| Status 1 | The Status 1 code indicates that the number of packages physically received equal the number expected You are not able to enter anything into this box. This box will automatically update with the date that you physically receive all your packages and record this in the Goods in section of the Basic ETSF Consignment editor |
| Customs Status | The status of this Consignment You cannot enter anything into this box. This box will automatically be updated once the Consignment information is sent to CCS-UK. Once a Declaration or Removal is submitted against this Consignment record the Customs Status will update |
If you need to add another House Consignment record to this Consolidation record click on the on New House button again at the bottom of the Basic ETSF Consignment editor. You can also do this by pressing on the down arrow key on your keyboard. Another House Consignment record row will be added to the editor which you can complete. Each row represents one House Consignment record.
When you have finished adding all your House Consignment records to this Consolidation click on the Send button on the toolbar in the top left hand side of the Basic ETSF Consignment editor. This will close the editor and the Consolidation record will be sent to CCS-UK.
You can locate this Consignment record in Sequoia by clicking on the ETSF module at the bottom left hand side of the screen. Next, click on the ETSF Consignments folder at the top left hand side of the screen. All of your ETSF Pre-Arrival Consignment/ Consolidation records will appear in the List Panel to the right of the ETSF Consignments folders showing as 'Consignment Created' in the 'Status' column.
Recording Goods In and Goods Out
To record 'Goods In', click on the Goods In Tab in the ETSF Consignment editor.
Next, click on the Goods In button with the green plus sign next to it.
A Goods In dialog box will appear.
Receive goods from a single AWB into one or more locations.
| Box | Information |
|---|---|
| Shed | The Shed reference will be automatically entered here |
| Master | The Master reference will be automatically entered here |
| House | The House reference will be automatically entered here |
| Expected (NPX) | The number of packages expected |
| Received (NPR) | The number of packages received |
| Reference Number | What is this? |
| Add button | |
| Remove button | |
| Pieces | The number of pieces/ packages |
| Location | The Location. You can search for this location by typing a ? into this box which will diplay the Warehouse Location Lookup Dialog box. Next, click on the binoculoars icon to bring up a lost of codes and select the correct code by double clicking on it. |
| Warehouse Location Reference | The Warehouse Location Reference |
Click on OK to save this information.
Now when you click on the Goods On Hand tab you will see the goods you have recorded in.
