webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

EDI ID Qualifier for User Defined External Id Types

webMethods Community Member

webMethods Community MemberThu December 15, 2005 03:42 PM

  • 1.  EDI ID Qualifier for User Defined External Id Types

    Posted Wed December 14, 2005 02:04 PM

    Hi

    What is the EDI ID Qualifier for User Defined 1, User Defined 2, User Defined 1 (External ID Types in TN prfoiles)?

    For DUNS the Qualifier is 01 and for Mutually Defined IDs the qualifier is ZZ. Similarly I want to know the EDI ID Qualifiers for User Defined External ID Types.

    Regards
    Ravi.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed December 14, 2005 09:08 PM

    Ravi,

    Any qualifier greater than 20 or null value is considered as UserDefined…But there is no specific value as such for UserDefined in the EDI world.

    HTH,
    RMG


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu December 15, 2005 01:42 AM

    In 4.6, only the User Defined 1 is usable. Any qualifier that is not 01 nor ZZ is considered to be User Defined 1. For 6.x, additional qualifiers can be used and mapped to TN-aware ID types and User Defined 1 - 4 are not needed.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 4.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu December 15, 2005 01:32 PM

    Hi RMG

    The service “wm.b2b.editn:ediPartnerIDToTNPartnerID” is able to recognize the correct profile If i use the ID Qualifier as null for User Defined 1 ID.

    But when I try to give null as my id qualifier in EDITPA GSRouting/SenderQualifier, it is taking that qualifier as * and TN is not able to recgonize the sender. Eventhough null is there in the qualifier field of TPA, When I look into the output of tn.receive service it is taking the value as *.

    Pleasea let me know how to proceed.

    Regards
    Ravi.


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 5.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu December 15, 2005 02:41 PM

    Null is not a valid value to use for an ID qualifier.

    What qualifier is being used for the partner? If it is not 01 or ZZ (as you’ve indicated) then place that qualifier in the TPA. Place the corresponding ID in the User Defined 1 ID in the profile.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 6.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu December 15, 2005 02:43 PM

    Forgot to ask: what version of IS are you using?


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 7.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu December 15, 2005 03:42 PM


  • 8.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri December 16, 2005 09:19 AM

    Use the EDI for TN administration pages to add additional ID qualifier to TN external ID type mappings.


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 9.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri December 16, 2005 04:14 PM

    Ravi,

    For your UserDefined query,please follow my comments above,it should work.

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 10.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri December 16, 2005 06:08 PM

    I think you’re right RMG that any qualifier other than 01 or ZZ will map to User Defined 1 (again, User Defined 2, 3 and 4 are never used by the EDI modules) but I’m not sure cuz I’ve never tried it in 6.x. In my opinion, in 6.1 User Defined 1 should never be used for EDI since there is a way to define additional external ID types in TN that correspond to the EDI ID qualifiers. Relying on the default behavior of all non-01/ZZ qualifiers to map to User Defined 1 can make profile management more tedious unnecessarily.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 11.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue December 20, 2005 02:57 PM

    I agree with you Rob.Thank you for details as always you are very narrative,wmusers are learning lot from your posts…


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 12.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue October 31, 2006 07:35 AM

    We are using WM 6.0.1 and having problem recognizing the external ID in TN. What would be the External ID Type for Qualifier ‘02’. I have tried using User Defined 1 but it doesn’t work. Is there a way to add/relate an EDI Qualifier to an external ID type in TN?

    Thanks in advance


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 13.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue October 31, 2006 02:33 PM

    mmadusumilli,

    In EDI X12 for “02” qualifier you have to select SCAC in the ExternalID type section.

    If SCAC code not listed in the TNConsole profile externalid then login to ISAdminConsole/WmEDI page install the externalid types select SCAC in the list.Referesh your TN console and you should see the new externalID type.

    HTH,
    RMG


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 14.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue October 31, 2006 02:37 PM

    In X12 the 02 qualifier is associated with the SCAC (standard carrier alpha code). In TN 6.1 this external ID type can be added to TN from the EDI for TN administration page on your IS. You can find the exact steps to do this in the EDI Module Users guide.

    Tim


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 15.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue October 31, 2006 06:33 PM

    I followed the steps and its working now. Thanks much for the help.

    BTW - Can you please point me to the WM Docs where I can find the details about this topic? I was searching in WM EDI TN Docs and couldn’t any information about this.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 16.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Tue October 31, 2006 06:56 PM

    The process is detailed in the EDI Module User’s Guide for version 6.0.1 on page 101. If you don’t already have it, login to Advantage and go here: [url]http://advantagebv.webmethods.com/bookshelf/_webMethods_eStandards/webMethods_EDI_Module/EDI_6_0_1/webMethods_EDI_Module_Users_Guide_6.0.1.pdf[/url]

    Tim


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 17.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 01, 2006 03:54 AM

    Glad to hear it is working now…

    For a EDI quick reference here you go.

    ExternalID’s and Types:
    01 X12=Duns, EDIFACT=Duns
    02 X12=SCAC
    03 X12=FMC,
    04 X12=IATA, EDIFACT=IATA
    05 EDIFACT= INSEE
    07 X12=GLN,
    08 X12=UCC Comm ID, EDIFACT= UCC Id
    09 X12=X 121 CCITT, EDIFACT = Duns with 4 digit suffix
    10 X12=DoD Activity Address
    11 X12=DEA
    12 X12=Phone, EDIFACT=Telephone Number
    13 X12=UCS
    14 X12=Duns Plus Suffix, EDIFACT=EAN
    15 X12=PAS of Canada Code
    16 X12=Duns Number with 4-char suffix
    17 X12= ABA routing number
    18 X12=AAR Std Distribution Code, EDIFACT=AIAG
    19 X12=EDICA Comm Id
    20 X12=HIN
    21 X12=IPEDS
    22 X12=FICE, EDIFACT=INSEE
    23 X12= NCES
    24 X12=ATP
    25 X12=ACT, Inc. 4-digit Code postsecondary institutions
    26 X12=Statistics of Canada list of postsecondary institutions
    27 X12=HCFA carrier
    28 X12=HCFA Fiscal Intermediary
    29 X12=HCFA Medicare provider
    30 X12=US Federal Tax Id, EDIFACT=ISO 6523 id
    31 X12=IAIABC Jurisdiction id plus 4, EDIFACT=DIN
    32 X12=US Federal Employer Id (FEIN)
    33 X12=NAIC code, EDIFACT=BIA


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 18.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 08, 2006 08:25 AM

    [SIZE=1]Thanks RMG ,

    This list of External Ids & qualifiers really helps[/size]


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 19.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 22, 2006 04:11 PM

    Following on from here, I am using outbound Edifact 92.1 ORDRSP, INVOIC & TAXCON. In the UNB segment I need to use my partners mailbox id, plus a qualifier [ZZ] plus a routing id [A001]. I currently have the external ID defined in the Trading partner as Mutually defined to cover the ZZ qualifier. When I process the document, the Edifact Envelope recognises the sender and receiver correctly, but the actual document, eg: Edifact INVOIC reports the receiver as Unknown with the Error being “EDI Qualifier: ZZ, ID: A001 [EDIFTN.000010.000232]”. Please could someone advise how the external ID should be set to correct this ?

    Thanks,
    Janet


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 20.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 22, 2006 04:47 PM

    What is your current processing rule setup based either on INVOIC
    or Envelope or Group level?? In the TAnalysis for EDIFACT INVOIC the documenttype showing as “unknown” default rule getting selected?? I guess there might be some issue in your processing rule setup itself can you check it??

    HTH,
    RMG


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 21.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 22, 2006 05:08 PM

    The PR is based on the EDIFACT Envelope. This works perfectly for every other Trading Partner, just not for this one. The default rule is being selected because the receiver is unknown.


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 22.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 22, 2006 06:05 PM

    Is there any typo in the edi document for the receiverid (ZZ) and also is it matching accordingly with partner profile ExternalID (MutuallyDefined)?? So is the issue only with INVIOIC transaction set receiver not being recognized?


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 23.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri November 24, 2006 10:40 AM

    Hi,

    there is not a typo…here is what the UNB looks like…

    UNB+UNOA:1+<ourEDInumber>+<partnersEDInumber>:ZZ:A001+<date>:<time>+<transmissionRef>+<password>+ORDRSP++++1

    The PR sends to the TP via a VAN based on the EDIFACT envelope. This is happening ok, and the Receiver is correctly identified at the envelope level, but is set to unknown at the actual document level (in this case UNEDIFACT 921 ORDRSP, but also UNEDIFACT 921 INVOIC and UNEDIFACT 921 TAXCON). If I remove the A001 it translates correctly. Unfortunately I cannot do this though in the live environment as the partner requires it.

    I have tried lots of different combinations in the external Ids but nothing seems to work…please could anyone advise ?

    Thanks


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 24.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri November 24, 2006 06:04 PM

    ZZ isn’t standard EDIFACT qualifier, AFAIK. But it is often used because it is a qualifier in X12. ZZZ is the mutually defined identifier. Give ZZZ a try.

    If you need ZZ, you’ll need to update the dictionary being used to allow that value.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 25.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Wed November 29, 2006 08:28 PM

    I was checking the documentation for adding an External Id Type and here is what I found.

    1 Open the Server Administrator if it is not already open.
    2 In the Solutions menu of the navigation panel, click EDI. The Server Administrator opens a new browser window to display the EDI Module home page.
    3 From the EDI Module home page, in the Partner Set Up menu of the navigation panel, click Add External ID Types.
    4 From the External ID Type drop-down list, select the EDI ID qualifier for which you want to add an external ID type.
    5 Click Add External ID Type to Trading Networks. The EDI Module displays a message stating that the external ID type was installed.

    My question is what do I do if the Id type I want to add is not available in the drop down as indicated in point number 4.

    Shubhro


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 26.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 01:47 AM

    Hi all,

    Can someone tell me in which field of UNEDIFACT-SLSRPT document does the transaction codes come in for sales.

    The codes are generally : SD ( Ship and Debit ), SM (Sample), SS(Stock Sale), BP (Broken Price).

    The customer wants to send this codes, but they are not sure which field and segment of EDIFACT doc do they send.

    Thanks in Advance
    Stepheny


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 27.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 01:50 AM

    Hi,

    The codes i have given are the POS transaction codes in my previous question.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 28.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 02:55 AM

    This links might help you [URL=“UNTDID | UNECE”]http://www.unece.org/trade/untdid/welcome.htm[/URL] or
    [URL=“http://www.unece.org/trade/untdid/d01a/trmd/slsrpt_c.htm”]http://www.unece.org/trade/untdid/d01a/trmd/slsrpt_c.htm[/URL]
    and look in the Directories section depends on your edi version.

    BTW,which EDIFACT version are you using?

    HTH,
    RMG


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 29.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 05:17 PM

    Hi

    Thanks for your reply. But i couldnt find anything related to these codes in the link. The version iam using is 97A.

    Thanks
    Stepheny


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 30.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 05:21 PM

    Else you can use any external tool like EDIFECS specbuilder sort of… [URL=“http://www.edifecs.com/gi-specbuilder-overview.jsp”]http://www.edifecs.com/gi-specbuilder-overview.jsp[/URL] and check the specifications for the SLSRPT D97A and its codelists.

    HTH,
    RMG


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 31.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu June 14, 2007 11:52 PM

    RMG,
    In one your earlier posts in this thread, you have provided “ExternalID’s and Types”. Can you guide us to the website which provides this information.

    I was searching over Google, SW engineers best friend, for this information, and found it in this thread.

    Appreciate your help
    Jafar Khan


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 32.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Fri June 22, 2007 08:57 PM

    Thanks dude, i have been looking for this “external id types reference” for a while.


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 33.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu July 19, 2007 02:05 AM

    Ravi Wrote:
    Hi

    What is the EDI ID Qualifier for User Defined 1, User Defined 2, User Defined 1 (External ID Types in TN prfoiles)?

    For DUNS the Qualifier is 01 and for Mutually Defined IDs the qualifier is ZZ. Similarly I want to know the EDI ID Qualifiers for User Defined External ID Types.

    Hi Ravi,

    I picked from Advantage,

    Qualifier 01 (DUNS) with External ID DUNS - Sender recognize

    • Qualifier 02 (SCAC) with External ID SCAC - Sender recognize

    • Qualifier 03 (FMC) with External ID FMC - Sender recognize

    • Qualifier 09 (X.121) with External ID X.121 -Sender NOTrecognize - failed

    • Qualifier 14 (DUNS plus suffix) with External ID DUNS plus suffix - Sender
      NOT recognize - failed

    • Qualifier ZZ (Mutually Defined) with External ID Mutually Defined - Sender recognize

    As reamon suggested use
    Use the EDI for TN administration pages to add additional ID qualifier to TN external ID type mappings.

    	 Thanks,
    

    Jsree


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 34.  RE: EDI ID Qualifier for User Defined External Id Types

    Posted Thu July 19, 2007 05:52 PM

    Jsree,

    For userdefined qualifier you can use anything like 15,16,…20…etc define the User Defined 1 in the parter profile that matches the value in your EDI file.

    HTH,
    RMG


    #edi
    #webMethods
    #Integration-Server-and-ESB