ASN flat file schema design

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › ASN flat file schema design

Viewing 1 reply thread
  • Author
    Posts
    • #23448

      I am wanting to design a custom schema from an ERP system to translate to an X12 4010 856.

      I do not have schema design experience, and was wondering if anyone had an example to follow and maybe even a map too…  I can design this schema anyway I like, but my hang up is how to create the schema to output separate date segments for each of the ship, est ship and manf dates…  should I just create each of these as separate output segments or is there a way to map all three of these into 3 separate segments from one header record.  So ultimately, I guess I need some map help to figure out how the functoids would work to get this mapped EDI from out flatfile record…

      thank you in advance.

    • #23749

      Biztalk already has a ASN schema – you just need to unpack them from the Biztalk folder.

      • #23753

        Biztalk has a flat file ASN schema? 

        • #23756

          Hi Frank,

           

             Are you referring to the mapping problems related to the HL Loop in the X12 856 Advanced Ship Notice (ASN)? If yes, you might want to read up on this book “Pro Mapping in BizTalk Server 2009” by Jim Dawson and John Wainwright. Here’s a link to an extract of a chapter in that book “Taming the Dreaded 856 ASN HL Loop”:

          http://www.springerlink.com/content/tw88798145234125/

           

             I hope this leads to what you are looking for…

           

             Daniel.

           

          • #23759

            I actually did buy that book.  The source schema they use is extremely basic.  My scenario involves using Crystal reports to extract the data from the ERP and create a flat file output.  I am simply trying to correctly design this source schema so that it is structurally correct to map to the X12 equivalent.  And not give me any hangups when implementing the book’s logic for the HL segment. 

            I dont have a lot of experience with creating schemas and was looking for some guidance in the contruction it and was just wondering if anyone else had created a source flat file that I could borrow ideas from…

            Thanks

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.