Partner Table Fields
The Table Export function allows you to export partner cross-reference and lookup tables to a sequential file. This allows you to define a table for one trading partner and copy that table to another partner profile.
Typically, you export and then import tables created for another partner profile. However, if necessary, you can build tables outside of Sterling Gentran:Server® by formatting your data in the export file layout.
The export file layout is a free-format ASCII text file. Each field must be delimited (separated) with Hex01 because the field lengths are variable.
The following table identifies the fields in lookup tables. Mandatory fields are designated with an asterisk (*).
| Field | Description |
|---|---|
| PartnerKEY* | Unique identifier for the partner |
| TableCode | For lookup, this value is “L”. |
| TableName* | Descriptive name for the table This value is displayed in the table selection list. |
| Item* | Value that is looked up in the data during inbound or outbound processing |
| Description | Brief comment about the item |
| Text1, Text2, Text3, Text4 | Additional reference information as required by the translation object using this table |
The following table identifies the fields in cross-reference tables. Mandatory fields are designated with an asterisk (*).
| Field | Description |
|---|---|
| PartnerKEY* | Unique identifier for the partner |
| TableCode | For cross-reference, this value is “C”. |
| TableName* | Descriptive name for the table This value is displayed in the table selection list. |
| MyItem* | Your data value that corresponds to your partner’s data value |
| PartnerItem* | Your partner’s data value that corresponds to your data value |
| Description | Brief comment about the item |
| Text1, Text2, Text3, Text4 | Additional reference information as required by the translation object using this table |