[EDI-L Mailing List Archive Home] [Message List] [Reply To This Message]

RE: 856 help

From: "david hayden" <dhayden238@...>
Date: Wed Mar 23, 2005  5:46 pm
Subject: RE: [EDI-L] 856 help

If you could send me your .map and the full input file. I may be able to
help you out.

>From: "monzon_car" < >To: >Subject: [EDI-L] 856 help
>Date: Wed, 23 Mar 2005 17:06:02 -0000
>
>
>Hello group, I was wondering if some of you had a good solution or
>advice for me. I am working on a inbound 856. For the most part it
>has been working with SOPI.
>
>Every time I had a new P loop it will break and will begin to write
>my info from here as my header portion of my file - then it will take
>the I loop information and will write it as my detail info for my
>file.
>
>The problem that I have now is that I have a customer that it is
>sending me info in this format too which I didnt know.
>
>S
>O
>P
>I
>
>O
>T tare for a full skid of the same product
>I
>
>O
>T
>I
>
>When I initially did my map I didnt include this in my map but now I
>have too some how. I am using Gentran 3.2.2 - Now within the same
>loop of the P group I trying to write my rules that if my Hl03 equal
>a "P " to perfornm X rules then if the HL03 equal "T" to perform X
>rules.
>
>The only way that i was able to some how acomplish this was to
>promote my HL Segmenet at the same level - So how I have two of them
>for the HL Pack group.
>
>them in each HL Segment under propertie in one I a key files to put
>a "T" on the HL03 and then a "P" of the HL03 for the other Hl
>Segment. I dont know why - but it was the only way that i could get
>gentran to see what it is being pass in the HL03. {even though the
>customer files has the right information here}.
>
>below its an eaxmple of my X12 and what it is producing. If you see
>the SN1 info it never get populated it on my output file ONLY the
>second SN1 of the second T loop.
>
>Any thoughs or help will be wonderfully welcome and let me thak you
>all in advance.
>
>Carlos
> >
>
>Example X12 Input data
>TD1*CTST*856*0003~
>BSN*00*0089177275*20050316*1617*0001~
>HL*1**S~
>TD1*CTN25*1****G*0.6459375*LB~
>TD5*B*2*BTGA*M*:B&T GEORGIA~
>REF*BM*0089177275~
>REF*CN*TQS050315072094~
>PER*CR*0127910000*TE*0127910000~
>DTM*011*20050324~
>N1*ST**15*1691503~
>N1*SF*RANDOM HOUSE~
>HL*2*1*O~
>PRF*COM0720469~
>N25*1~
>N1*BY**15*1691503~
>HL*3*2*P~
>MAN*GM*00000798084086854748~
>HL*4*3*I~
>LIN**IB*034547998X***PO*COM0720469~
>SN1**24*EA~
>SLN*1**O***10.95*PE~
>CTT*4*24~
>SE*23*0003~
>ST*856*0004~
>BSN*00*0089168854*20050316*1618*0001~
>HL*1**S~
>TD1*CTN25*989****G*1164.359062*LB~
>TD5*B*2*BTNJ*M*:B&T NEW JERSEY~
>REF*BM*0089168854~
>REF*CN*TQS050315072091~
>PER*CR*0127910000*TE*0127910000~
>DTM*011*20050321~
>N1*ST**15*1694901~
>N1*SF*RANDOM HOUSE~
>HL*2*1*O~
>PRF*SOM0855435~
>TD1*CTN25*989~
>N1*BY**15*1694901~
>HL*3*2*T~
>MAN*GM*00100798087103133908~
>HL*4*3*I~
>LIN**IB*0345457609***PO*SOM0855435~
>SN1**1260*EA~
>SLN*1**O***21.95*PE~
>HL*5*2*T~
>MAN*GM*00100798087103133915~
>HL*6*5*I~
>LIN**IB*0345456092***PO*SOM0855435~
>SN1**1080*EA~
>SLN*1**O***23.95*PE~
>HL*7*1*O~
>PRF*SOM0856672~
>TD1*CTN25*989~
>N1*BY**15*1694901~
>HL*8*7*P~
>MAN*GM*00000798083116988941~
>HL*9*8*I~
>LIN**IB*0375434798***PO*SOM0856672~
>SN1**12*EA~
>SLN*1**O***23.95*PE~
>HL*10*1*O~
>PRF*SOM0858357~
>TD1*CTN25*989~
>N1*BY**15*1694901~
>HL*11*10*P~
>MAN*GM*00000798083116988941~
>HL*12*11*I~
>
>
>Example Output Data
>LINE SOM0873811 0345475755 1395 24
>HDR 2013975 00000798084087005507
>LINE SOM0873811 0345475755 1395 24
>HDR 2013975 00000798084086854748
>LINE COM0720469 034547998X 1095 24
>HDR 2013975 00100798087103133908
>LINE SOM0855435 0345456092 2395 1080
>HDR 2013975 00100798087103133915
>LINE SOM0855435 0345456092 2395 1080
>HDR 2013975 00000798083116988941
>LINE SOM0856672 0375434798 2395 12
>HDR 2013975 00000798083116988941
>LINE SOM0858357 2080304720 4000 4
>HDR 2013975 00000798083116988934
>LINE SOM0856672 0375434798 2395 12
>HDR 2013975 00000798083116988927
>LINE SOM0856672 0375434798 2395 12
>HDR 2013975 00000798083116988910
>LINE SOM0856672 0375434798 2395 12
>HDR 2013975 00000798083116988903
>LINE SOM0856672 0375434798 2395 12
>
>
>
>
>


David V. Hayden








 
EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools Simplify EDI Data Integration with Stylus Studio XML Enterprise Suite - Free Download!
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.