Using EDI Qualifier Location/Value Pairs to Determine Multiple Custom Field Values

Working with Accounts : Custom Field Definition Examples : Using EDI Qualifier Location/Value Pairs to Determine Multiple Custom Field Values

Using EDI Qualifier Location/Value Pairs to Determine Multiple Custom Field Values

This example shows how you can obtain more than one custom field value from the same EDI Location, depending on the values in the EDI Qual. Loc. and EDI Qual. Value fields.

Define a custom field with the specifications shown, and name it Retailer-Specific-PID.

The EDI Qual. Loc. is the location of the qualifier. For this custom field, it is G3902.

The EDI Qual. Value is the value of the qualifier. For this custom field, it is CB.

Define another custom field with the specifications shown, and name it Ship-To-Number.

The EDI Qual. Loc. is the location of the qualifier. For this custom field, it is G3902.

The EDI Qual. Value is the value of the qualifier. For this custom field, it is ST.

Here is an example of a line from an EDI 888 document showing the G39 segment:

G39**CB*STNP22Y********************VN*220172TSITC

Catalogue looks in the G3902 element (position 02 of the G39 segment).

If the value is CB, Catalogue looks in the G3903 element (position 03 of the G39 segment) for the value to store in this custom field. In this case, the value corresponds to STNP22Y.

In this example, Catalogue finds the value STNP22Y in the G3903 element. Catalogue stores STNP22Y in this custom field (Retailer-Specific-PID) for the retailer that is specified in the N1 header segment (GROCRET1, account number 125106201800), as shown below.

ISA*00* *01*R7155D *01*0036051840 *12*5109654406 *101228*2304*^*00403*460000099*0*T*>

GS*QG*0036051840*5109654406*20101228*2304*6*X*004030

ST*888*1001

N1*ST*GROCRET1*91*125106201800

Here is an example of a line from a different EDI 888 document showing the G39 segment:

G39**ST*STNP35W********************VN*220172TSITC

Catalogue looks in the G3902 element (position 02 of the G39 segment).

If the value is ST, Catalogue looks in the G3903 element (position 03 of the G39 segment) for the value to store in this custom field. In this case, the value corresponds to STNP35W.

In this example, Catalogue finds the value STNP35W in the G3903 element. Catalogue stores STNP35W in this custom field (Ship-To-Number) for the retailer that is specified in the N1 header segment (GROCRET2, account number 135107204808), as shown below.

ISA*00* *01*R7155D *01*0036051841 *12*5109654407 *101228*2304*^*00403*460000099*0*T*>

GS*QG*0036051840*5109654407*20101228*2304*6*X*004030

ST*888*1001

N1*ST*GROCRET2*91*135107204808

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF