Interchange Table

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

The translator creates a record in the Interchange Table each time an interchange is introduced to the system. A record in the Interchange Table is updated when an interchange acknowledgement is received or generated. The translator deletes a record from the Interchange Table when the corresponding interchange is deleted.

Table 1. Interchange Table field information
Field Name Type Size Use
InterchangeKEY number (long) 4 Unique identifier for an interchange that is allocated by the system.
PartnerKEY string 25 Unique identifier for the partner to which the interchange belongs.
ControlNumber string 255 Value from the partner relationship used to generate the next interchange control number.
InterchangeControl KEY string 40 Interchange control record in Partner Editor that refers to this table.
SessionKEY number (long) 4 Not currently used.
TimeCreated number (long) 4 Time the interchange was created by the system.
TimeSent number (long) 4 Time the interchange was sent.
ProcessedStatus number (integer) 2 Processing status of the interchange:
  • 1 = Received
  • 2 = Sent
  • 3 = Ready to Send
  • 4 = Queued
  • 6 = Held
  • 7 = Send Failed
  • 8 = Processing
Direction number (integer) 2 Direction of the interchange:
  • 0 = Inbound
  • 1 = Outbound
Agency number (integer) 2 EDI standard used for the interchange.
Version string 13 Version of the interchange from the interchange control record in the partner relationship.
TestMode number (integer) 2 Indicates the partner relationship mode:
  • 0 = Production
  • 1 = Test
ExpectOrGenerate Ack number (integer) 2 Indicates whether the system sends an acknowledgement to this trading partner when you receive the interchange defined in this relationship (inbound) or receives an acknowledgement from this trading partner as a result of your partner receiving the interchange defined in this relationship (outbound):
  • 0 = Do not expect or generate acknowledgements
  • 1 = Expect or generate acknowledgements
AckHoursOverdue number (integer) 2 Number of hours that must elapse before the acknowledgement is considered overdue.
AckStatus (inbound) number (integer) 2 Status of the acknowledgement (inbound):
  • 0 = Acknowledgement not required
  • 1 = Waiting
  • 2 = OK
  • 3 = Acknowledged with errors
  • 4 = Partially acknowledged
  • 5 = Rejected
  • 6 = Deferred acknowledgement generation
  • 7 = Immediate acknowledgement generation
  • 8 = Deferred reconciliation (for acknowledgement documents only)
  • 9 = Immediate reconciliation (for acknowledgement documents only)
  • 10 = Reconciliation complete (for acknowledgement documents only)
AckStatus (outbound) number (integer) 2 Status of the acknowledgement (outbound):
  • 0 = Reconciliation not required
  • 1 = Waiting
  • 2 = OK
  • 3 = Reconciled with errors
  • 4 = Partially reconciled
  • 5 = Rejected
  • 6 = Reconciliation overdue
AckTime number (long) 4 Time of the acknowledgement.
AckTransaction SetID string 150 System-generated transaction set identifier for the acknowledgement.
NetworkStatus number (integer) 2 Network processing status:
  • 0 = Not sent
  • 1 = Received OK
  • 2 = Network Warning
  • 3 = Network Error
  • 4 = Picked Up
  • 5 = Transmitted to third-party network
NetworkTime number (long) 4 Time the network received the interchange.
NoGroupsAccepted number (integer) 2 Number of groups that were accepted (inbound).
NoGroupsRejected number (integer) 2 Number of groups that were rejected (inbound).
NoTransactions Accepted number (integer) 4 Number of transaction sets that were accepted (inbound).
NoTransactions Rejected number (integer) 4 Number of transaction sets that were rejected (inbound).
Filename string 255 Name of the file that contains the interchange data.
Translation ReportFile string 255 File name of the interchange translator report.
AppField1 string 40 First application field in this interchange that was updated in the Application Integration subsystem.
AppField2 string 40 Second application field in this interchange that was updated in the Application Integration subsystem.
AppField3 string 40 Third application field in this interchange that was updated in the Application Integration subsystem.
AppField4 string 40 Fourth application field in this interchange that was updated in the Application Integration subsystem.
AppField5 string 40 Fifth application field in this interchange that was updated in the Application Integration subsystem.
AppField6 string 40 Sixth application field in this interchange that was updated in the Application Integration subsystem.
Element Separator number (integer) 2 Value from the partner relationship used to separate elements in an outbound data segment.
SubElement Separator number (integer) 2 Value from the partner relationship used to separate component elements in an outbound composite data element.
SegmentTerminator number (integer) 2 Value from the partner relationship used to identify the end of an outbound data segment.
ReleaseCharacter number (integer) 2 Value from the partner relationship used to restore any character used as a syntactical separator to its original meaning.
SegmentTag number (integer) 2 Value from the partner relationship used to identify the end of each segment tag (identifier).
DecimalIndicator number (integer) 2 Value from the partner relationship used to indicate a decimal point in a numeric field.
MessageId number (long) 4 Message identifier used to send the interchange data.
Restored number (integer) 2 Indicates whether the data is original or restored:
  • 0 = Original
  • 1 = Restored
NbrBytes number (long) 4 Provides a counter of the number of bytes in the Interchange EDI data.
NbrRecords number (long) 4 Provides a counter of the number of records in the document EDI data.
RepeatingElement Separator number (integer) 2 Location of the repeating element separator in the interchange, if the standard you are using employs composite fields containing repeating data elements.