- This topic has 0 replies, 1 voice, and was last updated 9 years, 3 months ago by
.
-
Posts
-
-
Hello,
I hop you can help me.
We have an application that transforms an inbound IDOC INVOIC02 into a Purchase Invoice file in XML for processing by MS Dynamics NAV.
I want to pass some information about the Sell-To Customer from the inbound file into the Ship-TO section of the outbound file. And this will be different depending on the Order Reference Number in the inbound document.
The inbound file is complicated to me it looks like this.
EDI_DC40 1000000000002605035700 3012 INVOIC02 INVOIC SAPEQ3 LS EQ3CLNT100 EDI KUREIC1139 20090327094130 20090327094128
E2EDK01005 100000000000260503500000100000001 EUREUR1.00000 CINC GB827900029 NL004098705B01 INVO9120086519 0.064 0.064 KGMLR IC1139 L
E2EDKA1003 100000000000260503500000200000002RS IC1139 ThermoElectron BV Takkebijsters 1 BREDA 4817 NL N MLEEGGANGERS 1200
E2EDKA1003 100000000000260503500000300000002AG IC1139 Thermo Fisher Scientific Stafford House Boundary Way Hemel Hempstead HP2 7GE GB 01923 635039 01442 233667 E EN
E2EDKA1003 100000000000260503500000400000002RE IC1139 Thermo Fisher Scientific Stafford House Boundary Way Hemel Hempstead HP2 7GE GB 01923 635039 01442 233667 E EN
E2EDKA1003 100000000000260503500000500000002RG IC1139 Thermo Fisher Scientific Stafford House Boundary Way Hemel Hempstead HP2 7GE GB 01923 635039 01442 233667 E EN
E2EDKA1003 100000000000260503500000600000002BK 1200 Thermo Fisher Scientific BV Takkebijsters 1 Breda 4817 BL NL 76 5717311 76 5714958
E2EDK02 1000000000002605035000007000000020099120086519 20090325
E2EDK02 100000000000260503500000800000002001UKHEM090006 20090325
E2EDK02 1000000000002605035000009000000020020180008718 20090325
E2EDK02 1000000000002605035000010000000020120081172501 20090331
E2EDK02 1000000000002605035000011000000020179120086519
E2EDK03 10000000000026050350000120000000202620090325
E2EDK03 10000000000026050350000130000000200120090331
E2EDK03 10000000000026050350000140000000202220090325
E2EDK03 10000000000026050350000150000000201220090327
E2EDK03 10000000000026050350000160000000201120090327
E2EDK03 10000000000026050350000170000000202420090325
E2EDK03 10000000000026050350000180000000202820090325
E2EDK04001 100000000000260503500001900000002A6 0 0
E2EDK17 100000000000260503500002000000002001DDPDelivered duty paid
E2EDK18 1000000000002605035000021000000020010 0 Up to 25.03.2009 without deduction
E2EDK28 100000000000260503500002200000002NL ABNANL2A ABN-AMRO Rotterdam 0441221157 ThermoElectron BV
E2EDK29003 1000000000002605035000023000000020014362390NL 4 EUR GB United Kingdom GB X Netherlands NL GB 900 Air
E2EDK14 1000000000002605035000024000000020081200
E2EDK14 10000000000026050350000250000000200750
E2EDK14 10000000000026050350000260000000200600
E2EDK14 100000000000260503500002700000002015F2
E2EDK14 1000000000002605035000028000000020031200
E2EDP01007 100000000000260503500002900000002000010 2.000 EA 0.010 KGM 0.010 TAN 1210
E2EDP02001 100000000000260503500003000002903001UKHEM090006 00001020090325
E2EDP02001 1000000000002605035000031000029030020180008718 00001020090325
E2EDP02001 1000000000002605035000032000029030160081172501 00001020090331
E2EDP03 10000000000026050350000330000290302920090325
E2EDP03 10000000000026050350000340000290300120090331
E2EDP03 10000000000026050350000350000290301120090327
E2EDP03 10000000000026050350000360000290302520090327
E2EDP03 10000000000026050350000370000290302720090325
E2EDP03 10000000000026050350000380000290302320090325
E2EDP03 10000000000026050350000390000290302220090325
E2EDP19002 10000000000026050350000400000290300100006-07608
E2EDP19002 10000000000026050350000410000290300200006-07608 FUSE,IEC,0.5A,250V,FAST-ACT,5x20mm,RoHS
E2EDP19002 10000000000026050350000420000290300785361010
E2EDP19002 100000000000260503500004300002903011US
E2EDP26 1000000000002605035000044000029030041.60
E2EDP26 1000000000002605035000045000029030031.60
E2EDP26 1000000000002605035000046000029030091.60
E2EDP26 1000000000002605035000047000029030101.60
E2EDP26 1000000000002605035000048000029030010.80
E2EDP26 1000000000002605035000049000029030021.60
E2EDPA1003 100000000000260503500005000002903WE IC1139 Southend Hospital Prittlewell Chase Westcliff On Sea Hemel Hempstead SS0 0RY GB 01923 635039 01442 233667 E 000000 EN
E2EDP05002 100000000000260503500005100002903+ Gross Value 1.60 0.80 1 EA EUR 2
E2EDP04001 100000000000260503500005200002903A6 0 0
E2EDP28003 100000000000260503500005300002903001436239000001085361010 1 US US USA 6215779684,6215779684 0.010 0.010 KGM NL 003 Netherlands Sale & Purchase
E2EDPT1001 1000000000002605035000054000029030002E ENIF the Order reference number (in Bold in segment E2EDK02 type 001) begins with J I want to transfer the Name and Address from E2EDKA003 Type AG into the XML. If that is not the case I wnat to transfer the Name and Address from the segmnet E2EDPA1003 tyep WE.
I can transfer the E2EDK02 data or the E2EDPA1003 data but not with the condition.
The E2EDK segments occur once in each file and the E2EDP segmnents may occur one or more times and defined as Sequence.
Can you please suggest how to make this mapping work.
Thanks in advance…..
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.