SeanHoppe.com > Cleo Best Practices > Write Multiple Records for Single NTE/MSG/MTX Segment

Write Multiple Records for Single NTE/MSG/MTX Segment


Scenario:

In CLEO EDI Integrator, we are mapping an inbound Wayfair.com 850 transaction into JDEdwards F47 (Z-tables). In the situation below we need to map the MTX02 element into F4714.TXLN.

The F4714.TXLN field is only 60 characters in length. Our EXTOL 850 mapping of the MTX segment will allow us to breakdown the MTX02 element into multiple occurrences of the F4714 record.

Sample Wayfair.com 850 Data:

ST*850*0004~
BEG*00*DS*TEST-20538-45153727**20150721~
REF*VR*20538*29340~
REF*2P*Wayfair~
PER*IC*Ply Gem*FX*816/426-8555 *TE*816/426-8235 ~
CTP**WHL~
ITD*01***********3% 10 Net 30~
DTM*010*20150723~
TD5**2*FDEG*ZZ*GR~
N9*TH*3359-4073-3~
MTX*COM*Please dropship blind and always include Wayfair packing slip from http://partners.wayfair.com. Please do not partial ship without prior autorization from Wayfair. Please include the PO# as the reference number on the label/BO. Please reply with delay notifications or questions~
N1*BT*Wayfair~
N3*4 Copley Place, Floor 7~
N4*Boston*MA*02116*US~
PER*BJ*BT*TE*6175326815*FX*6175027798*EM*servicesquad@wayfair.com~
N1*ST*Fake Order For Testing~
N2*Fake Company Inc~
N3*1405 Worldwide Blvd*Dock Doors 3-15~
N4*Hebron*KY*41048*US*ZN*R~
PER*DC*ST*TE*1234567890*FX*9087654321*EM*po@test.com~
N1*LW*Fake Order For Testing~
N3*1405 Worldwide Blvd*Dock Doors 3-15~
N4*Hebron*KY*41048*US~
PO1*1*1*EA*9.49*WH*VN*VINRP1547 PE~
PID*F****16 Piece Shutter Hook Set~
MTX*COM*Test-Comment~
CTT*1~
AMT*GV*9.49~
SE*29*0004~

Solution:


850 Element Mapping :: Before


In the example we have a single occurrence of the MTX02 element.

EXTOL Integrator Inbound Wayfair.com/JDE MTX element before

850 Element Mapping :: After


After realizing that the MTX02 element is much larger than 60 characters (max length of our text field), we add more occurrences of the MTX02 element.

EXTOL Integrator Inbound Wayfair.com/JDE MTX elements after

850 MTX Element :: Field Concatenation


For each occurrence of the MTX02 element, we will concatenate the field length from 1 for a length of 60.

EXTOL Integrator Inbound Wayfair.com/JDE MTX element field concatenation

850 MTX Element :: Element Concatenation


For each occurrence of the MTX02 element, we will concatenate the element length for a length of 60. For each successive occurrence, we will add 60.

EXTOL Integrator Inbound Wayfair.com/JDE MTX element concatenation

850 MTX Segment Format :: Before


Before we realized the MTX02 element was greater than 60 positions, we used the Write Action of 'W'

EXTOL Integrator Inbound Wayfair.com/JDE MTX segment format before

850 MTX Segment Format :: After


After we realized the MTX02 element was greater than 60 positions, we used the Write Action of 'M'

EXTOL Integrator Inbound Wayfair.com/JDE MTX segment format after









By: on
EXTOL Business Partner Logo

More CLEO Examples

We have over 300+ examples of how Cleo EDI Integrator (EEI) can be customized to meet your organization's needs

Each of our examples are free to review and use.