Trading Partner Cross-Reference, Location, and Lookup Table Conversion from Sterling Gentran:Server for Windows

To enable successful conversion, trading partner cross-reference, location, and lookup table data is mapped differently in Sterling B2B Integrator than in Sterling Gentran:Server for Windows.

The following table shows the new data locations for your reference.

Sterling B2B Integrator Table Mapping

Sterling Gentran:Server for Windows Location Table Mapping

Sterling Gentran:Server for Windows Lookup Table Mapping

Sterling Gentran:Server for Windows Cross-Reference Table Mapping

LIST_NAME

NAME

TABLE NAME

TABLE NAME

SENDER_ID

TPEDI_CODE

RECEIVER_ID

<Internal System User EDI code>

<Internal System User EDI code>

<Internal System User EDI code>

LIST_VERSION

SENDER_ITEM

PRIMARY REFERENCE CODE

LOOKUP ITEM

PARTNER ITEM

RECEIVER_ITEM

SECONDARY REFERENCE CODE

MY ITEM

TEXT1

ADDRESS1

TEXT1

TEXT1

TEXT2

ADDRESS2

TEXT2

TEXT2

TEXT3

ADDRESS3

TEXT3

TEXT3

TEXT4

CITY

TEXT4

TEXT4

DESCRIPTION

CONTACT NAME

DESCRIPTION

DESCRIPTION

TEXT5

STATE

TEXT6

ZIP

TEXT7

COUNTRY

TEXT8

TELEPHONE

TEXT9

FAX