Order Consolidation Mapping

EDI Order Consolidation Mapping Guides

In the previous post, we have described a practical scenario of an EDI Order Consolidation given by GS1. Find below some mapping guidelines.

1 ST*856*0001
2 BSN*00*GlobalShpmentIdNo*21080819*2120*0003
3 HL*1**S
4 TD1**1****G*20.00*LB
5 TD5**2*UPSN*U*UPS*CC
6 REF*BM*BOLIdNo
7 MAN*SM*ShpmentIdNo
8 DTM*011*20181114*2120
9 N1*BY*CompanyName*UL*GobalLocationNumber
10 N2*AltName1*AltName2
11 N3*Addess1*Address2
12 N4*CityName*ST*C*C****Postal-Code
13 N1*BY*CompanyName*UL*GobalLocationNumber
14 N2*AltName1*AltName2
15 N3*Addess1*Address2
16 N4*CityName*ST*C*C****Postal-Code
17 HL*2*1*P
18 MAN*GM*005061414199999999999
19 HL*3*2*O
20 PRF*8195447387***20180814
21 HL*4*3*I
22 LIN**UP*614141025664*UK*00614141026664
23 SN1**120*EA
24 PID*F****Product or Item Description
25 HL*5*2*O
26 PRF*8195447288***20180814
27 HL*6*5*I
28 LIN**UP*614141025657*UK*00614141025657
29 SN1**120*EA
30 PID*F****Product or Item Description
31 CTT*6
32 SE*32*0001

The BSN segment (Line 2)

The BSN segment (Line 2) is used to transmit identifying numbers, dates, and other basic data relating to the transaction set, a segment which is used today and is often overlooked in terms of the information it can provide.

The BSN02 indicates a unique control number assigned by the original shipper to identify a specific shipment, illustrated here as a Global Shipment Identification Number, or GSIN, which is typically automatically generated by specialized translation software that can be encoded.

The BSN05 is the Hierarchical Structure Code indicating the hierarchical application structure of a transaction set that utilizes the HL segment to define the structure of the transaction set. Here with qualifier 0003 indicating Shipment, Packaging, Order, and Item.

The HL segment (Line 3)

The HL03specifies the characteristic of a level in a hierarchical structure and uses a qualifier of ‘S’ indicating Shipment which identifies the data which follows the HL segment relates to the shipment.

The next HL segment (Line 17) Package

This HL segment (Line 17) is a ‘package’ because it is indicated by the qualifier in the HL03 with the letter ‘P.’ The HL segment (Line 17) is the second HL segment found within the transaction.

We can identify the position of this HL segment (Line 17) in the order of HL segments found within the transaction as it is indicated in HL01 by the digit 2. We can also identify the parent of this HL segment (Line 17) as being Line 3 because it is indicated in the HL02, the HL02 in Line 17 = 1, the HL01 in Line 3 = 1.

The next HL segment (Line 19) Order

The next HL segment (Line 19) is the third HL segment found within the transaction, we can see that clearly as it is indicated in HL01 by the digit 3.

The parent of this HL (Line 19) indicated in the HL02 is the HL segment found in Line 17, we know this as the number of the HL in Line 17 = 2, the HL02 in Line 19 = 2.

We know the third HL segment found within the transaction is an ‘Order’ because it is indicated by the qualifier in the HL03 with the letter ‘O.’

The next HL segment (Line 21)

The last HL segment in the stack is the HL segment found in Line 21 and this is the ‘Item’ HL segment. The Item HL segment completes the SPOI format initially identified in the BSN05 (Line 2) which uses the 0003 qualifier indicating Shipment, Packaging, Order, and Item.

We can also see that this is next HL to follow by comparing the HL01 with the previous HL01, in this case (Line 21) where the HL01 = 3, 4 naturally follows and is indicated in this HL segment where this HL01 = 4.

The parent of this HL (Line 21) indicated in the HL02 is the HL segment found in Line 19, we know this as the number of the HL in Line 19 = 3 and the HL02 in Line 21 = 3.

To learn more about EDI mapping and become a certified EDI Professional please visit our course schedule page.

Leave a Reply

Your email address will not be published.

Post Navigation