Using EDI Qualifier Location/Value Pair to Determine the Custom Field Value

Working with Accounts : Custom Field Definition Examples : Using EDI Qualifier Location/Value Pair to Determine the Custom Field Value

Using EDI Qualifier Location/Value Pair to Determine the Custom Field Value

This example shows how to use EDI Location to provide the custom field value based on the values in the EDI Qual. Loc. and EDI Qual. Value fields.

Define a custom field with the specifications shown, and name it DE7973.

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.

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 example, Catalogue finds the value STNP22Y in the G3903 element. Catalogue stores STNP22Y in this custom field (DE7973) for the retailer that is specified in the N1 header segment (GROCRET, 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*GROCRET*91*125106201800

Note: The N1 segment at the header level, immediately following the ST segment, is the segment that is used to determine the retailer to whom the custom field applies (N1*ST*GROCRET*91*125106201800).

If there is another retailer account specified in the 03/04 positions in the N1 segment within the G39 loop, it is ignored (N1*ST*RETAILER*91*125106201811). Refer to the sample code below.

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF