Track Table

The Track Table (Track_tb) contains a record for every document in the Sterling Gentran:Server® system.

The records contain all the necessary information to allow the system to track the document, including the link between the document, group, and interchange. The translator creates a record for every document in an interchange in the Tracking Table each time an interchange is built. A record in the Tracking Table is updated when an acknowledgement is received or generated. The translator deletes a record from the Tracking Table when the corresponding document is deleted.

Table 1. Track Table field information
Field Name Type Size Use
DocumentKEY number (long) 4 Unique identifier for a document (message) that is allocated by the system.
GroupKEY number (long) 4 Unique identifier for a functional group that is allocated by the system.
InterchangeKEY number (long) 4 Unique identifier for an interchange that is allocated by the system.
AckDocumentKEY number (long) 4 Unique identifier for the document acknowledgement (the link from the document to the acknowledgement).
TimeLastModified number (long) 4 Time the document was last modified.
TimePosted number (long) 4 Time the document was posted to the Out Documents.
ExpectOrGenerate Ack number (integer) 2 Indicates whether the system sends an acknowledgement to this trading partner when you receive the document defined in this relationship (inbound) or receives an acknowledgement from this trading partner as a result of your partner receiving the document defined in this relationship (outbound).
GenerateAckDetails number (integer) 2 Indicates whether the acknowledgement is generated with error detail:
  • 0 = No Error Detail
  • 1 = With Error Detail
AckHoursOverdue number (integer) 2 Number of hours that must elapse before the acknowledgement is considered overdue.
AckTransactionSet ID string 150 System-generated transaction set identifier for the acknowledgement.
Direction number (integer) 2 Direction of the document:
  • 0 = Inbound
  • 1 = Outbound
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.
PartnerKEY string 25 Unique identifier for the partner to which the interchange belongs.
DocumentControl Number string 255 Value from the partner relationship used to generate the next document control number or message reference.
GroupControl Number string 255 Value from the partner relationship used to generate the next group control number.
InterchangeControl Number string 255 Value from the partner relationship used to generate the next interchange control number.
FunctionalGroupID string 6 Functional group identifier established in the partner relationship.
TransactionSetID string 150 Transaction set (message) identifier established in the partner relationship or in the document.
Restored number (integer) 2 Indicates whether the data is original or restored:
  • 0 = Original
  • 1 = Restored