Skip to Content
0

EDI Mapping Issue

Jan 18, 2017 at 07:13 PM

37

avatar image
Former Member

Hi Experts

Can anybody help me in fixing the EDI MAPPING?

Source we have EDI 856 and target side is JDBC.

In below mapping as you can see the Item number MV0658SGXXX which has 4 serial numbers

0176000017642, 0176000017536, 0176000017598 and 0176000017567 and the same values are mapped at target side for<ATTRIBUTE4> and <SERIAL_NUMBER> respectively.

<D_234> ----àATTRIBUTE4

<D_87>--à SERIAL_NUMBER

Let assume have 4 item numbers and each item number has 4 serial numbers.

When I executed the mapping only first two item numbers are populating in < ATTRIBUTE4> field and remaining are getting suppress whereas all Serial Numbers are populating correctly. In above example we have only 4 Item Numbers and 16 serial numbers so it is the reason why the item numbers are getting suppress. My requirement is I want all item numbers should be appear which their corresponding serial numbers at the target side.

<G_SHL>

<S_HL>

<D_628>3</D_628>

<D_734>2</D_734>

<D_735>P</D_735>

<S_LIN>

<D_350>5</D_350>

<D_235>VP</D_235>

<D_234>MV0658SGXXX</D_234>

</S_LIN>

<S_SN1>

<D_382>4</D_382>

<D_355>EA</D_355>

</S_SN1>

<S_REF>

<D_128>CN</D_128>

<D_127>667962241954</D_127>

</S_REF>

<S_MAN>

<D_88>GM</D_88>

<D_87>00007633570000174403</D_87>

</S_MAN>

</S_HL>

</G_SHL>

<G_SHL>

<S_HL>

<D_628>4</D_628>

<D_734>3</D_734>

<D_735>I</D_735>

<S_MAN>

<D_88>R</D_88>

<D_87>0176000017642</D_87>

</S_MAN>

</S_HL>

</G_SHL>

<G_SHL>

<S_HL>

<D_628>5</D_628>

<D_734>3</D_734>

<D_735>I</D_735>

<S_MAN>

<D_88>R</D_88>

<D_87>0176000017536</D_87>

</S_MAN>

</S_HL>

</G_SHL>

<G_SHL>

<S_HL>

<D_628>6</D_628>

<D_734>3</D_734>

<D_735>I</D_735>

<S_MAN>

<D_88>R</D_88>

<D_87>0176000017598</D_87>

</S_MAN>

</S_HL>

</G_SHL>

<G_SHL>

<S_HL>

<D_628>7</D_628>

<D_734>3</D_734>

<D_735>I</D_735>

<S_MAN>

<D_88>R</D_88>

<D_87>0176000017567</D_87>

</S_MAN>

</S_HL>

</G_SHL>

<ACCESS>

<SHIPMENT_NUMBER>6948885501ML</SHIPMENT_NUMBER>

<PACKAGE_NUMBER>00007633570000174403</PACKAGE_NUMBER>

<SERIAL_NUMBER>0176000017642</SERIAL_NUMBER>

<ATTRIBUTE1>5</ATTRIBUTE1>

<ATTRIBUTE4>MV0658SGXXX</ATTRIBUTE4>

</ACCESS>

<ACCESS>

<SHIPMENT_NUMBER>6948885501ML</SHIPMENT_NUMBER>

<PACKAGE_NUMBER>00007633570000174403</PACKAGE_NUMBER>

<SERIAL_NUMBER>0176000017536</SERIAL_NUMBER>

<ATTRIBUTE1>5</ATTRIBUTE1>

<ATTRIBUTE4>MV0658SGXXX</ATTRIBUTE4>

</ACCESS>

<ACCESS>

<SHIPMENT_NUMBER>6948885501ML</SHIPMENT_NUMBER>

<PACKAGE_NUMBER>00007633570000174403</PACKAGE_NUMBER>

<SERIAL_NUMBER>0176000017598</SERIAL_NUMBER>

<ATTRIBUTE1>5</ATTRIBUTE1>

<ATTRIBUTE4>MV0658SGXXX</ATTRIBUTE4>

</ACCESS>

<ACCESS>

<SHIPMENT_NUMBER>6948885501ML</SHIPMENT_NUMBER>

<PACKAGE_NUMBER>00007633570000174403</PACKAGE_NUMBER>

<SERIAL_NUMBER>0176000017567</SERIAL_NUMBER>

<ATTRIBUTE1>5</ATTRIBUTE1>

<ATTRIBUTE4>MV0658SGXXX</ATTRIBUTE4>

</ACCESS>

Thanks

Faisal

cgyks.png (45.1 kB)
zhjtp.jpeg (21.2 kB)
uiw2e.jpeg (21.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 18, 2017 at 07:29 PM
0

Item numbers are populating

Item numbers are not populating


gacad.jpeg (19.6 kB)
bl5rr.jpeg (20.5 kB)
Share
10 |10000 characters needed characters left characters exceeded