Container reconciliation is a tool designed to provide self-service access to container information to enable shipping lines to investigate and correct discrepancies between their vessel load information and the ports load information. The comparison and reconciliation results are based on a load list from the shipping lines (load list - COPRAR) and the container information managed by the Port (in their terminal management system).
Currently only available for the Port of Tauranga.
Select a Port (currently defaults to Tauranga).
Select the display date range for vessel visits, 'arrival date from' and 'arrival date to'.
Filter by Vessel, click on the vessel icon and start typing the vessel name.
Filter by Vessels with or without Load Lists - Toggle on or off.
Search - click the search button to apply or reapply the search criteria and filters.
Shows the vessel name, voyage, load list cut off, arrival and departure.
The arrival time may update from expected arrival to actual arrival time.
The dashboard will display the most recent 3 files submitted by the Shipping Lines.
If a Load List is received after the file cut-off period, the text will be displayed in red.
If the Load List is a final version (flagged as final in the EDI file), a document icon with a tick will be displayed in front of the date.
Provides an easy to read summary of the data found in the Exemptions Reports.
Hovering over icons communicates their meanings.
Export CEDO missing.
Tranship CEDO missing.
Stop.
Not in list/yard.
Container data mismatch.
Added into the final load list.
Removed in the final load list.
Empty container count.
Full container count.
The Exceptions report is a detailed container listing of the comparison between the latest load list and the data from the port.
Clicking the document icon downloads the detailed Exemption Report.
Fields in the report that are in red text indicate the mismatches.
This screen is used by Line Operators to upload details of containers to load on a vessel. This is an alternative to submitting COPRAR EDI.
To upload, select partner port and select the vessel icon to select a vessel. Click ‘Choose File’ to upload.
The upload file must have the following data:
Label | Notes |
---|---|
Vessel Name | |
Voyage Number | |
Container Number | |
Booking nbr | |
Status | ‘Full’ or ‘Empty’ |
ISO Type | |
Discharge | Must be a valid UN Location Code |
Final Destination | Must be a valid UN Location Code |
Commodity | HS code or short description |
Temp | |
Vent | |
Vent Type | ‘FlowM3PerHour’ or ‘PercentageOpen’ |
Humidity | Percentage |
o2 | Percentage |
co2 | Percentage |
Example:
Error | What to do |
---|---|
Selected Vessel visit has a vessel name that does not match the vessel name in the file | Make sure the vessel names match and upload the file again |
Failed to successfully parse the file | One or more column names in the file are not correct. Check the column names and upload the file again. |
This screen is used by Empty Depots to upload details of containers linked to a release that has been received from a shipping line.
To upload, select partner port then click the vessel icon to select a vessel visit. Click ‘Choose File’ to upload.
The upload file must have the following data:
Label | Notes |
---|---|
Vessel Name | |
Pack Point | |
Container | |
Line Operator | |
Booking | |
Container Type | ISO Type code |
Freight Kind | MTY |
Example:
Error | What to do |
---|---|
Selected Vessel visit has a vessel name that does not match the vessel name in the file | Make sure the vessel names match and upload the file again |
Failed to successfully parse the file | One or more column names in the file are not correct. Check the column names and upload the file again. |
An acknowledgment email is sent to the COPRAR sender. The email will contain an exceptions summary.
For example:
If the Vessel is not found when the file is processed, the email context will not show reconciliation results. Instead an error message is displayed acknowledging receipt of the file, but reconciliation is not available until the TOS data feed contains the vessel.
Some line operators are flagged as a Nil Reconciliation operator. Nil Reconciliation operators do not send load lists but have access to view the dashboard.
The Reconciliation section for a Nil Reconciliation operator does not show Mismatches but only Stops.
The Port can see all Line Operators associated to a vessel. Line operators with the document symbol indicate nil reconciliation (they don’t send load lists).
When will I see an update?
The dashboard reconciliation results are updated when:
A new Load List is received.
Port system data refresh is received (i.e., every 10 minutes).
What format files can be uploaded?
CSV or Excel are supported.
Why are there so many mismatches?
Container mismatch indicates the number of fields that are mismatched in the exceptions report rather than the number of containers.