Partner Table

The Partner Table (Partner_tb) contains a record for every partner profile in the Sterling Gentran:Server® system.

Partner Editor creates a record in the Partner Table each time a partner profile definition is created. Each time a partner profile is changed, Partner Editor updates the corresponding record in the Partner Table. Partner Editor deletes a record from the Partner Table when the corresponding partner profile definition is deleted.

Table 1. Partner Table field information
Field Name Type Size Use
PartnerKEY string 25 Unique identifier for this partner.
EDICode string 255 EDI identifier used during inbound processing to select the correct partner.
ApplicationPartner KEY string 255 Application identifier for this partner used during outbound import processing to select the correct partner.
IsSystem number (integer) 2 Indicates whether this partner is the <Internal System User> partner:
  • 0 = Not the <Internal System User> partner
  • 1 = <Internal System User> partner
PartnerName string 40 Unique name identifying this partner.
Mailbox string 125 Predefined communications setup used for inbound and outbound processing.
EMailAddress string 125 Used to identify the message address if the selected Mailbox is an exchange gateway.
Editing number (integer) 2 A specific partner relationship is in the process of being edited:
  • 0= Not edited
  • 1= Currently being edited