Container Reconciliation User-Guide
- Dana Folau
- Chris Boxall
- Christina Mackay
Container Reconciliation Summary
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).
Partner Ports
Currently only available for the Port of Tauranga.
Functionality
Search and Filter:
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.
Vessel Visit
Shows the vessel name, voyage, load list cut off, arrival and departure.
The arrival time may update from expected arrival to actual arrival time.
Load Lists Received
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.
Reconciliation Results
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.
Exemptions Report
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.
Line Operator Load List Upload process
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.
Upload File Format
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:
Upload errors
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. |
Empty Depot Load List Upload process
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.
Upload File Format
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:
Upload errors
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. |
Acknowledgment email
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.
NIL Reconciliation Users
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.
Port View:
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).
FAQS
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.
© PortConnect 2023