Group Table

The Group Table (Group_tb) contains a record for every functional group in the Sterling Gentran:Server® system.

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

Table 1. Group Table field information
Field Name Type Size Use
GroupKEY number (long) 4 Unique identifier for a group that is allocated by the system.
PartnerKEY string 25 Unique identifier for the partner to which the group belongs.
ControlNumber string 255 Value from the partner relationship used to generate the next group control number.
FunctionalGroupID string 6 Functional group identifier established in the partner relationship.
GroupControlKEY string 20 Group control record in Partner Editor that refers to this table.
Direction number (integer) 2 Direction of the group:
  • 0 = Inbound
  • 1 = Outbound
Agency number (integer) 2 EDI standard used for the group.
Version string 13 Version of the group from the group control record in the partner relationship.
ExpectOrGenerate Ack number (integer) 2 Indicates whether the system sends a functional acknowledgement to this trading partner when you receive the group defined in this relationship (inbound) or receives a functional acknowledgement from this trading partner as a result of your partner receiving the group 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.
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).
AppField1 string 40 First application field in this group that was updated in the Application Integration subsystem.
AppField2 string 40 Second application field in this group that was updated in the Application Integration subsystem.
AppField3 string 40 Third application field in this group that was updated in the Application Integration subsystem.
AppField4 string 40 Fourth application field in this group that was updated in the Application Integration subsystem.
AppField5 string 40 Fifth application field in this group that was updated in the Application Integration subsystem.
AppField6 string 40 Sixth application field in this group 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.
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 Group EDI data.
NbrRecords number (long) 4 Provides a counter of the number of records in the document EDI data.