The standard carrier format supports loading carrier level manifest data by uploading a CSV or Excel (.xlsx) file.
CSV Delimiters
CSV fields must be separated by either a comma (CSV) or a tab (text).
CSV rows must be separated by carriage return and line feed characters (CRLF)
Excel files
Must be .xlsx files. The older .xls format is not supported.
Only the first worksheet of the spreadsheet is used (
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.
As a starting point you may download the Excel template at the bottom of this page.
Shipment / border transport | |
| ManifestReference | The reference for the manifest/shipment |
| Conveyance or Vessel | The name of vessel for sea freight or flight number for air freight |
| Voyage | The voyage number for sea freight |
| LloydsNumber | The lloyds/IMO number for the vessel |
| DeparturePort | The departure port. A full UN/LOCODE is required such as NZTRG |
| DepartureDate | The departure date and time |
| ArrivalPort | The arrival port. A full UN/LOCODE is required such as AUSYD |
| ArrivalDate | The arrival date and time |
Reference numbers | |
| BillNumber | The booking or bill of lading number. This is a Required field. |
| ClearanceNumber | The TSW reference for export clearance |
| PrepaidOrCollect | For freight prepaid enter 'PREPAID' or 'P' otherwise freight collect will be assumed |
| ClientReference | The customers reference for the consignment (e.g. an order number) |
Ports / Locations | |
| OriginPort or Origin | The origin location. A full UN/LOCODE is required such as NZTRG |
| LoadPort or Load | Port of loading. A full UN/LOCODE is required such as NZTRG |
| DischargePort or Discharge | Port of discharge. A full UN/LOCODE is required such as AUSYD |
| DischargePremisesCode or DischargePremises | The premises code for discharge. For NZ this should be a CCA code e.g. 8590B |
| DeliveryPort | Port of delivery - final domestic port of discharge where applicable. A full UN/LOCODE is required such as NZAKL. |
| DeliveryPremisesCode | Premises code for delivery. For NZ, this should be a CCA code. |
| DeliveryPremisesName | Premises name for delivery. For NZ, this should the name of the CCA. This can optionally be included along with the premises code. |
| DestinationPort or Destination | The destination location. A full UN/LOCODE is required such as AUSYD |
Shipper | |
| ShipperName | The shippers name |
| ShipperAddress1 | The shippers address (line 1) |
| ShipperAddress2 | The shippers address (line 2) |
| ShipperCity | The shippers city |
| ShipperRegion | The shippers region/state |
| ShipperPostCode | The shippers postal code |
| ShipperContactName | The shippers contact person |
| ShipperContactPhone | The shippers contact phone number |
| ShipperContactEmail | The shippers contact email address |
Consignee | |
| ConsigneeName | The consignees name |
| ConsigneeAddress1 | The consignees address (line 1) |
| ConsigneeAddress2 | The consignees address (line 2) |
| ConsigneeCity | The consignees city |
| ConsigneeRegion | The consignees region/state |
| ConsigneePostCode | The consignees postal code |
| ConsigneeContactName | The consignees contact person |
| ConsigneeContactPhone | The consignees contact phone number |
| ConsigneeContactEmail | The consignees contact email address |
| ConsigneeAccountNumber | Quarantine account number where the consignee's account is to be charged. For NZ this is the MPI account number and may apply to ICR for empty containers or import declarations. |
Notify Party | |
| NotifyPartyName | The notify party name |
| NotifyPartyAddress1 | The notify party address (line 1) |
| NotifyPartyAddress2 | The notify party address (line 2) |
| NotifyPartyCity | The notify party city |
| NotifyPartyRegion | The notify party region/state |
| NotifyPartyPostCode | The notify party postal code |
| NotifyPartyContactName | The notify party contact person |
| NotifyPartyContactPhone | The notify party contact phone number |
| NotifyPartyContactEmail | The notify party contact email address |
Container details | |
| ContainerNumber | Sea freight container number |
| ContainerStatus | F = FCL, L = LCL, E = Empty |
| ContainerIsoCode or IsoCode | The container ISO code |
| Seal | A container seal number |
| QuarantinePremisesName | Name of the quarantine premises. E.g. container yard for empty containers |
| QuarantinePremisesCode | Quarantine premises code |
| CleaningFacilityName | Name of the container cleaning facility |
| CleaningFacilityCode | Container cleaning facility code |
Goods / Packaging | |
| GoodsDescription | A description of the goods |
| PackageQuantity or PackageCount | The quantity/number of packages |
| PackageType | A UN code for the package type. E.g. PK, CT, PX |
| GrossWeight | The gross weight of the goods |
| GrossWeightUnits | The weight units - if not provided then kgs will be assumed |
| Volume or Cubic | The volume of the goods in metres cubed |
| NewOrUsed | State USED for used goods, otherwise new will be assumed |
| GoodsIdType | Goods identification type Supported codes are: VIN - Vehicle identification number SRN - Serial number CHN - Chassis number LVN - Live animals number |
| GoodsIdNumber | Goods identification number for one of the types above |
Dangerous / Hazardous goods | |
| UndgCode | UN dangerous goods code (where applicable) |
| FlashpointTemp | The flashpoint temperature of the goods (where applicable) |
Transhipment | |
| TsMoveBy | The method by which the goods are moving domestically for a transhipment. Supported values are: SEAC - Sea / Coastal vessel SEAO - Sea / International vessel AIR - Air freight ROAD - Road transport RAIL - Rail transport MULTI - Multi-modal |
| TsConveyance or TsVessel | The vessel or flight number for the other leg involved in a transhipment |
| TsVoyage | The voyage number for the other leg involved in a transhipment |
| TsLoadingDate | The loading date for the other leg involved in a transhipment (as applies to an inbound shipment) |
| TsArrivalDate | The arrival date for the other leg involved in a transhipment (as applies to an outbound shipment) |