Using EDI Location to Determine the Custom Field Value

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

Using EDI Location to Determine the Custom Field Value

This example shows how to use EDI Location to provide the custom field value.

You define a custom field with the specifications shown and name it Retailer Info.

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

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

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 (Retailer Info) 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

21.2 release. Online Help last updated March 6, 2021

OpenText Active Catalogue Browser Interface User Guide for Vendors PDF