none
EDI - X12 - 855 INBOUND RRS feed

  • Question

  • Hi ,

     

    I am facing problem for EDI - X12 - 855 INBOUND interface.

    I m having Following structure X12_00401_855 is root having PO1 Loop which contains PO1 Record and N1 Loop which contains N1 and N2 and N3 records.

     

    Here the Need is  for Each PO1 N1Loop shd be excuted .

     

    e.g Po1 has PL1 and PL2 lines and N1 has SF1 and SF2 .

    For PL1 SF1 Needs to be executed  and same way for PL2.

     

    What needs to be done for Each PO1 N1Loop shd be excuted .

     

    Thanks ,

    Rajesh

    Thursday, September 11, 2008 12:59 PM

All replies

  • I am confused about what you are asking. Are you saying how to ensure if PO1 has PL1 and PL2 then N1 should have SF1 and SF2? If so, here is a way to do this:

     

    I would run a map that converts from a BizTalk 855 schema to the trading partner's 855 schema. I have used .NET methods in a BizTalk map with 2 or more parameters for this kind of conditional output. You would send the SF1, PL1, and PL2 into a .NET method that outputs to SF1 and then SF2, PL1, and PL2 inputs to a .NET method that outputs to SF2. This would be a way to check for existence of PL1 and PL2 to determine whether to output a value for SF1 and SF2.

     

    Thanks,

    Thursday, September 11, 2008 5:18 PM
    Moderator
  • Hi Ben,

     

    Thanks for  reply , Let me explain you Problem .

     

     e.g in following file i wants for each PO1 segment  N1 -SF will be executed but it is not happening

     it is inserting all  PO1 in table A at one time then insert N1 - SF in table B at a time

    so that i can store unique id of poline i.e of table A  as a transid  in table B .

    It puts max of that POline id of table A puts it in table b for all entries .

     

    ISA*00*          *00*          *ZZ*42252          *ZZ*MYCOMPANY*041225*1551*U*00401*000000636*0*T*:~
    GS*GP*42252*MYCOMPANY*20080708*1551*000000637*X*004010~
    ST*855*000000638~
    BAK*00*AT*RS4500*20080708~
    REF*VN*PU4500~
    PER*BD*uyu*TE*3109446333~
    FOB*CC~
    DTM*067*20080708~
    DTM*068*20080708~
    N1*ST*llin - 23 - DC1*9*0219900490000~
    N3*Address~
    N4*ABCCity*WA*98000-850*USA~
    N1*BY*up*9*1234567890000~
    N1*VN*e *9*1605581100000~
    PO1*1*300*CA*20*FX*PI*RF3*VN*RF3~
    PID*F****Gerera~
    N1*SF*.sld*9*3831883505502~
    PO1*2*450*CA*20*FX*PI*RF4*VN*RF4~
    PID*F****Rose~
    N1*SF*prield*9*3831883505502~
    PO1*3*500*CA*20*FX*PI*RF1*VN*RF1~
    PID*F****Orcs~
    N1*SF*ringd*9*3831883505502~
    PO1*4*800*CA*20*FX*PI*RF2*VN*RF2~
    PID*F****Lily~
    N1*SF*ringfi*9*3831883505502~
    CTT*4*18~
    AMT*TT*1~
    SE*27*000000638~
    GE*1*000000637~
    IEA*1*000000636~

     

    Thanks

    Rajesh

    Friday, September 12, 2008 1:27 PM
  • Rajesh,
    Could you pubish here what you've got after transformation and what you need?
     
    Thursday, October 9, 2008 10:35 PM