Cross-Reference Table

The Cross-Reference Table (CrossReference_tb) contains a record for every cross-reference table in the Sterling Gentran:Server® system.

Cross-reference tables in Sterling Gentran:Server enable you to convert data you enter before it is sent to your partner. Partner Editor creates a record in the Cross-Reference Table each time a cross-reference table is created in Partner Editor. Each time a cross-reference table is changed, Partner Editor updates the corresponding record in the Cross-Reference Table. Partner Editor deletes a record from the Cross-Reference Table when the corresponding cross-reference table is deleted in Partner Editor.

Table 1. Cross-Reference Table field information
Field Name	Type	Size	Use
PartnerKEY	string	25	Unique identifier for the partner to which the cross-reference table belongs.
TableName	string	8	Name of the table.
MyItem	string	255	Your data value that corresponds to your partner's data value.
PartnerItem	string	255	Your partner's data value that corresponds to your data value.
Description	string	255	Description of the MyItem and PartnerItem codes.
Text1 through Text4	string	255	Field that can be mapped when it is associated with a specific code value.