Interchange Control Table

The Interchange Control Table (InterchangeControl_tb) contains a record for every interchange in the Sterling Gentran:Server® system.

Partner Editor creates a record in the Interchange Control Table each time an interchange definition is created. Each time a control number is received or generated for an interchange, the translator updates the corresponding record in the Interchange Control Table. Partner Editor deletes a record from the Interchange Control Table when the corresponding interchange definition is deleted.

Table 1. Interchange Control Table field information
Field Name Type Size Use
PartnerKEY string 25 Unique identifier for the partner to which the interchange belongs.
Direction number (integer) 2 Direction of the interchange:
  • 0 = Inbound
  • 1 = Outbound
InterchangeControl KEY string 40 Name of the interchange.
Agency number (integer) 2 EDI standard used for this interchange.
Version string 13 Standard version used for this interchange.
TemplateKEY string 40 Partner-specific group build or break translation object used for this interchange.
SegmentID string 10 Segment identification of the controlling segment of the interchange (such as ISA, UNB, or STX).
AckExpected number (integer) 2 Indicates that the system expects an acknowledgement to be received from this trading partner as a result of your partner receiving the interchange defined in the relationship (outbound).
HoursOverdue number (integer) 2 Number of hours that must elapse before the acknowledgement is considered overdue.
AckTemplateKEY string 40 Acknowledgement build or break translation object used for this interchange.
AckTransactionSet ID string 150 Acknowledgement generated for the interchange (inbound).
ControlNumber string 255 Value from the partner relationship used to generate the next interchange control number.
SequenceCheck Type number (integer) 2 Type of sequence checking used for this interchange:
  • 0 = None
  • 1 = Incremental
  • 2 = Chronological
  • 3 = Duplicate
MsgContentType string 125 Used to format the Content Type field when creating a message containing interchange data. Initialized to Application.
MsgContentSub Type string 125 Used to format the Content Sub Type field when creating a message containing interchange data. Initialized to EDI.
MaxDocsperint number (long) 4 Used by the translator to determine how many documents should be included in an interchange. Initialized to 0 (unlimited documents per interchange).
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.