AnsweredAssumed Answered

EDI Profile N3 Multiple Occurrences

Question asked by avanderpost413936 on Mar 15, 2016
Latest reply on Mar 31, 2016 by lois_hunsaker676927

X12 Version 5010 N1 ST Loop - N3 segment - Occurs twice - cannot capture values of second N301/N302 occurrence.

 

Received data from trading partner:

N1*VN*A BOTTLE IN THE MIRROR*9*1231231230000^

N3*4567 S PATH DR^

N4*SOME TOWN*CA*902120000^

N1*ST*AAAA TRANS SHIP LOCATION*92*998855^

N3*DISTRIBUTION CENTER*DOOR 1699^

N3*3656 SHIP TO ADDRESS*ABCDEFG^

N4*CITY HERE*DE*1986660000^

N1*Z7*MARK FOR INFO HERE*92*ABABABS^

 

Need to end up with N3 Data in Orders table as shown below:

DISTRIBUTION CENTER  ===>> Address1   This works N301

DOOR 1699                       ===>> Address2   This works N302

3656 SHIP TO ADDRESS ===>> Address3   Do not know how to get this value from map - not displayed

ABCDEFG                          ===>> Address4  Do not know how to get this value from map - not displayed

 

Any ideas/samples are greatly appreciated.

 

Thank you,

Anton

Outcomes