...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Introduction
TIC4.0 will provide the metadata from EDI to create Data Value. It offers an overview of how to translate and incorporate EDI data, from any source (EDI message, TOS, or whatever) to a TIC message, register or data lake (centralized data repository).
...
The EDIFACT data will be translated to the TIC4.0 Data standard/model via the provision of definitions, data formats, data models and examples to easily implement the standard.
Potential use cases
| Info |
|---|
Terminal Operators: TOS AUGMENTATIONVALUE PROPOSITION: Empower what the TOS does by adding different data sources to TOS capabilities using the same language to reduce complexity on integration and adoption. Enable Enrich the data before it has been processed into the TOS or validated to anticipate the actions.
Global Terminal OperatorsVALUE PROPOSITION: Reduce the integration efforts across terminals
AgenciesVALUE PROPOSITION: Be connected to different data sources from stakeholders (as terminals, central planners…) using the same standard. For instance: Send EDIs as converted to TIC to terminals and shipping line (COPRARs and Bookings) and receive validated load and discharge list in TIC (For which there are not currently EDI standard) Modernize interfacing EDIVALUE PROPOSITION: Intermediate step to modernize and reduce the complexity of the EDI. TIC4.0 global adoption will take time. In the meantime, a translator is needed between EDI and TIC to enable all terminals and systems integration using the same standard. In future it will be possible to exchange all data using the same integrated technology. |
EDI structure
The base of the Task Force review and conversion is the Ship Message Design Group (SMDG) Standard which is published by the SMDG group, see EDIFACT MIGs – SMDG e.V. .
...
As a starting point, the smaller EDI message COARRI was chosen to gain experience with the structure and find a good way to review and document the results.
Structure of the EDI File:
The EDI Files follow the same structure and definition of data.
...
UNH Service segment to start and uniquely identify a message |
BGM A segment to indicate the beginning of a message and to transmit an identifying number and the further specification of the message type. |
Message Body is separated in Segments and Groups dependent on the kind of message |
CNT A segment to specify the number of containers in the message, explicitly given by the sender. |
UNT A service segment ending a message, giving the total number of segments in the message (including the UNH & UNT) and the control reference number of the message. |
Segments
The way to read and translate the EDIFACT files is explained with the help of some examples.
...
+ is used as a separator between the elements
In the case of composite elements, “:” is used as a separator.
To read a segment we analyze from left to right the content between two “+”.
Example A:
| Panel | ||
|---|---|---|
| ||
DTM+132:202302221600:203' |
...
As you can find the extract below 2005 is the id of the list. 132, 133, 178 and 186 are the allowed values.
The next example in this line is the 203. This is an entry from the code list 2379. In this case only the value 203 is allowed.
Example B
| Panel | ||
|---|---|---|
| ||
EQD+CN+NYKU4116702+45G1:102:5++3+5' |
...
Extract from the SMDG Standard document related to this example line:
...
Translation Methodology
The review of the EDI messages and translation was done by going through the EDI standard segment-wise. For each segment we considered the possible values transferred and allowed in each TAG. These are either translated in existing TIC4.0 fields or new fields were defined.
...
In the following, a similar example like example A above is now used to explain how the translation is done and how to read the attached EXCEL Sheet.
Example 1:
| Panel | ||
|---|---|---|
| ||
DTM+133:200211131700:203' |
...
B | C | D | E | F | G |
C507 | DATA / TIME / PERIOD | ||||
132 - Arrival date/time, estimated | 2005 | Date or time or period function code qualifier | Date / Time Information of the Transport | tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|planned|timestamp: 2002-11-13T0917:00.000Z | |
2380 | Date or time or period value | Arrival/departure date/time | |||
203 - CCYYMMDDHHMM | 2379 | Date or time or period format code | COARRI is CCYYMMDDHHMM format ant TIC4.0 is always in ISO8601 format | ||
...
Allowed values | Translation TIC4.0 |
|---|---|
132 - Arrival date/time, estimated | tos|@|carriervisit|@|arrival|@mooring|@|firstline|time|planned|timestamp: 2380 if 2005=132 |
133 - Departure date/time, estimated | tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|planned|timestamp: 2380 if 2005=133 |
178 - Arrival date/time, actual | tos|@|carriervisit|@|arrival|@|mooring|@|firstline|time|actual|timestamp: 2380 if 2005=178 |
186 - Departure date/time, actual | tos|@|carriervisit|@|departure|@|mooring|@|firstline|time|actual|timestamp: 2380 if 2005=186 |
The component element 2380 holds the date and time: 200211131700.
The component element 2379 holds the format description of the component element 2308: CCYYMMDDHHMM.
Example 2
This example explains the use of the lists from smdg in the TIC4.0 database related to the EDI translation
...
Extract from the EXCEL Sheet with the translation of this example:
B | C | D | E | F | G |
CA Carrier | 3035 | PARTY FUNCTION CODE QUALIFIER | tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|partyfunctioncode : CF | ||
C082 | PARTY IDENTIFICATION DETAILS | ||||
3039 | Party Identifier | Company Code | tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|output|actual|value : MAE | ||
160 Party identification | 1131 | Code list identification code | Kind of Party | tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|codelistidentificationcode : 172 | |
20 BIC (Bureau International des Containeurs) | 3055 | Code list responsible agency code | tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|qualifier : 20 |
| Panel | ||
|---|---|---|
| ||
NAD+CF+MAE:172:20' |
...
CF is an entry of the smdg data element 3035 which has a fix list of allowed values:
CA Carrier
CF Container operator/lessee
HR Shipping line service
MR Message recipient
MSDocument/message issuer/sender
...
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055|partyfunctioncode : 3035
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055|partyfunctionname : 3035 (see list)
example: tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|partyfunctioncode : CF
MAE:172:20
This is the smdg data element C082 which holds the party identification details.
...
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|output|actual|value : MAE
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055|output|actual|value : 3039
172 is an entry of list 1131 and describes the kind of the party.
...
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|codelistidentificationcode : 172
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|codelistidentificationname : Carriers
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055codelistidentificationcode : 3039
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055codelistidentificationname : 172= Carriers/160 Party identification
20 is an entry of the list 3055 and describes the code list standards from which the data values were taken.
...
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#20|qualifier : 20
tos|@|cargo|@|responsibleparty|metadata|output.actual|#qualifier#20|codelistresponisbleagencyname : BIC
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055|qualifier : 3055
tos|@|cargo|@|responsibleparty|metadata|output|actual|#qualifier#3055#|codelistresponisbleagencyname : 3055 see list
DATABASE
The backend of this code is publicly available at
...