Trading Partner Code List (Select Standard Rule)

A trading partner code list is a list of codes that are dynamic, related to trading partners, and stored in the Sterling B2B Integrator database. The codes contained in the trading partner code list consist of two code values that cross-reference an item between two trading partners, a description field, and four optional fields.

Trading partner code lists are created and managed in the Sterling B2B Integrator Trading Partner interface.

Trading partner code lists differ from the code lists used in the Use Code standard rule. Those code lists are created and maintained in the Sterling B2B Integrator Map Editor and stored in the map file.

The Select standard rule enables you to create one map that can be used with many trading partners, even if they use different code lists. It also enables you to change the content of a field according to a reference in the code list. For example, if a company trades the same item with several companies, and some reference the item by different names, the company can use one map, using the Select standard rule, for each transaction. This correctly names the item according to each company's preference.

The following list describes the fields on the Standard Rule tab with the Select standard rule selected and Trading Partner Code (List by Receiver Code or List by Sender Code) selected from the Table and key (or group) list:

Field

Description

Table and key (or group)

Trading Partner Code List (by Receiver Code or by Sender Code). The table and key from which the translator selects data. Valid values are:

• Trading Partner Code List by Receiver Code – the translator selects the receiver code in the trading partner code list specified in the following field.
• Trading Partner Code List by Sender Code – the translator selects the sender code in the trading partner code list specified in the following field.

Code List

Type (exactly) the name of the trading partner code list to use (the name of the one you created in the Sterling B2B Integrator Map Editor interface).

Raise compliance error

For compliance reasons, the field must contain one of the codes from the specified trading partner code list (nothing else is valid for that field).

For example, if a field is defined as containing only YES or NO, you can create a trading partner code list that contains only YES and NO. Then if you receive a MAYBE in that field, the translator flags it as an error.

Map from

The code list entry from the specified code list from which you want to map the contents.

Note: Items are displayed in the map-from list only after you make a selection from the table and key list.

Map to

The field to which you want to map the trading partner code list entries.

Note: If you are working in the input side of the map, you can access all the fields in the current group. If you are working in the output side, you can access all the fields in the current record. A total of eight fields can be mapped using one Select standard rule. Entries are displayed in the map-to list after you select a table and key. These entries are activated after you select an entry in the map-from box.