Relationship Table

The Relationship Table (Relationship_tb) contains a record for every inbound or outbound relationship in the Sterling Gentran:Server® system.

Partner Editor creates a record in the Relationship Table each time an inbound or outbound relationship definition is created. Each time an inbound or outbound relationship definition is changed, Partner Editor updates the corresponding record in the Relationship Table. Partner Editor deletes a record from the Relationship Table when the corresponding inbound or outbound relationship definition is deleted.

Table 1. Relationship Table field information
Field Name Type Size Use
PartnerKEY string 25 Unique identifier for the partner to which the relationship belongs.
Direction number (integer) 2 Direction of the relationship:
  • 0 = Inbound
  • 1 = Outbound
Agency number (integer) 2 EDI standard used for this relationship.
Version string 13 Standard version for this relationship.
TransactionSetID string 150 Transaction set (message) used for this relationship.
Release number (integer) 2 Message version release number used for this relationship.
TestMode number (integer) 2 Indicates the partner relationship mode:
  • 0 = Production
  • 1 = Test
Description string 40 Name of the relationship.
ImportTemplate KEY string 40 Import translation object used with this relationship.
DataEntryTemplate KEY string 40 Screen entry translation object used with this relationship.
TurnAround TemplateKEY string 40 Turnaround translation object used with this relationship.
PrintTemplateKEY string 40 Print translation object used with this relationship.
Relationship TemplateKEY string 40 Relation translation object used in this relationship. This allows you to alter the system behavior at the transaction and document level. You can use partner-specific translation objects and/or perform as many functions as required.
ExportTemplate KEY string 40 Export translation object used with this relationship.
ComplianceCheck TemplateKEY string 40 Translation object that is performing compliance checking.
ExportFileName string 130 File name to be created or appended to as result of the export operation.
ExportToFlatFile Now number (integer) 2 Indicates whether you want the export file created automatically upon receipt of the document defined in this relationship:
  • 0 = Do not export automatically
  • 1 = Export automatically
TurnAroundNow number (integer) 2 Indicates whether you want the defined turnaround process to be executed automatically upon receipt of the document defined in this relationship:
  • 0 = Do not export automatically
  • 1 = Turnaround automatically
SequenceCheck Type number (integer) 2 Type of sequence checking used for the transaction set (message) defined in this relationship:
  • 0 = None
  • 1 = Sequence Checking - Incremental
  • 2 = Sequence Checking - Chronological
  • 3 = Sequence Checking - Duplicate
  • 256 = Duplicate Documents Checking Only
  • 257 = Sequence Checking - Incremental + Duplicate Documents
  • 258 = Sequence Checking - Chronological + Duplicate Documents
  • 259 = Sequence Checking - Duplicate + Duplicate Documents
SkipCompliance Check number (integer) 2 Indicates whether compliance checking is performed:
  • 0 = Do not compliance check
  • 1 = Compliance check
AckErrors number (integer) 2 Indicates whether the acknowledgement is generated with error detail:
  • 0 = No Error Detail
  • 1 = With Error Detail
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 transaction set (message) defined in this 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 relationship.
AckTransactionSet ID string 150 Acknowledgement generated for the transaction set (inbound).
ApplicationKEY string 150 Application identifier that indicates the destination of the document defined in this relationship.
Alias string 150 Criteria that aids the system in distinguishing this relationship from other relationships.
FunctionalGroup ControlKEY string 20 Group control record in Partner Editor referring to this relationship.
InterchangeControl KEY string 40 Interchange control record in Partner Editor referring to this relationship.
ControlNumber string 255 Value from the partner relationship used to generate the next transaction set control number.
ImmediateAck Processing number (integer) 2 Indicates whether acknowledgement reconciliation will occur during the inbound break session or during its scheduled interval.
IsAcknowledgement number (integer) 2 Indicates whether the transaction defined in this partner relationship is an acknowledgement.
ExportToMailbox number (integer) 2 Indicates whether the Export to Mailbox function is invoked, allowing the output of an inbound translation to be delivered back to the Mailbox Server Manager.
RecipientMailbox string 125 Mailbox to which the output of an inbound translation will be delivered.
RecipientEMail Address string 125 E-mail address to which the output of an inbound translation will be delivered.
ContentType string 255 Content type of the message containing the output of the inbound translation.
ContentSubType string 255 Content sub type of the message containing the output of the inbound translation.