The standard CSV format allows manifest data to be loaded into SpeEDI Cargo from comma separated data.
To output from an Excel spreadsheet with the correct delimiters you would save the file as CSV or alternatively 'Text (Tab delimited)'.
The Excel template file attached contains the supported columns headers.
Limitations
Each line in the file is treated as a separate consignment. For inbound cargo, each row must have a unique bill number (duplicates will be skipped).
Given this, only singular package/containers can be provided per consignment, so it more suited to a simple consolidation rather than a carrier manifest where you may have multiple containers per freight bill.
Delimiters
Fields must be separated by either a comma (CSV) or a tab (text).
Rows must be separated by carriage return and line feed characters (CRLF)
Data
The first row of data must contain the column names.
The column names can be in any order but must match those below exactly.
Columns names that are not recognized are ignored.
A BillNumber column is required. All other data items are optional
BillNumber | This can be a booking number, bill or lading or housebill number. This is a Required field |
ClearanceNumber | A TSW clearance number. Can be provided where the goods have been cleared externally. |
ClearanceExemption | For NZ shipments enter the following:
|
TariffCode OR Tariff | The following formats are acceptable: 3926.20.62.02H 3926.20 |
ShipperName | The shipper's name |
ShipperAddress1 | The shipper's address (line 1) |
ShipperAddress2 | The shipper's address (line 2) |
ShipperCity | The shipper's city (address line 3) |
ShipperRegion | The shipper's region (address lne 4) |
ShipperTaxNumber OR ShipperTaxNo | The shipper's business/tax number For NZ this is the GST number for import taxes |
TaxPrepaid | Valid values are:
For values Y/N, a valid tax number should also be provided for the shipper. |
ConsigneeName | The consignee's name |
ConsigneeAddress1 | The consignee's address (line 1) |
ConsigneeAddress2 | The consignee's address (line 2) |
ConsigneeCity | The consignee's city (address line 3) |
ConsigneeRegion | The consignee's region (address line 4) |
ConsigneeContactName | The consignee contact persons name |
ConsigneeContactPhone | The consignee contact phone number |
ConsigneeContactEmail | The consignee contact email address |
NotifyPartyName | The notify party name |
NotifyPartyAddress1 | The notify party address (line 1) |
NotifyPartyAddress2 | The notify party address (line 2) |
NotifyPartyCity | The notify party city (address line 3) |
NotifyPartyRegion | The notify party region (address line 4) |
GoodsDescription | A description of the goods |
NewOrUsed | Enter USED to indicate used goods, otherwise new goods will be assumed |
PackageQuantity | The total package quantity |
GrossWeight | The total gross weight |
GrossWeightUnits | The total gross weight units. Supported units are KGM, LBR, TNE, GRM, |
Volume | The total volume |
GoodsCurrency | The goods currency. For example USD, EUR, GBP, AUD |
GoodsValue | The total goods value |
ManufactureCountry | The goods manufacture/origin country. For example US, CN, DE |
OriginPort | The origin location as a port code. A full UN/LOCODE is required such as USLAX |
DestinationPort | The destination location as a port code. A full UN/LOCODE is required such as NZAKL |
ClientReference | The clients reference number (e.g. an order number) |
ContainerNumber | A container number |
ContainerStatus | FCL - Full container load LCL - Part container load FAK - Full mixed container load |
ContainerISOCode | The ISO code for the container e.g. 20GP |