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.
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.
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.
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.
850 MTX Segment Format :: Before
Before we realized the MTX02 element was greater than 60 positions, we used the Write Action of 'W'
850 MTX Segment Format :: After
After we realized the MTX02 element was greater than 60 positions, we used the Write Action of 'M'
By: Sean Hoppe on
