External Data Cross-Reference Table
The External Data Cross-Reference Table (ExtDataXref_tb) contains information on how each external data file relates with the Sterling Gentran:Server® data.
Each record is a cross-reference between external data and a related Sterling Gentran:Server document or interchange.
| Field Name | Type | Size | Use |
|---|---|---|---|
| ExtDataKEY | number (long) | 4 | A foreign key on the ExtData_tb, used to provide a link between the tables. |
| GentranType | number (long) | 4 | Type of Sterling Gentran:Server data
that is related to the external data reference:
|
| GentranKEY | number (long) | 4 | A foreign key on either the Interchange_tb or the Document_tb, depending on the value of the GentranType parameter. |
| RecordCount | number (long) | 4 | For import and export actions, the number of records in the external data file that were created from the document that was imported or exported. For process file actions, the number of segments in the interchange that were processed for the given inbound data. |
| ByteCount | number (long) | 4 | Total number of bytes in the external data. |
| StartingOffset | number (long) | 4 | The start offset in the external data that corresponds to the Sterling Gentran:Server data that the record created. |
| EndingOffset | number (long) | 4 | The end offset in the external data that corresponds to the Sterling Gentran:Server data that the record created. |
| TimeStamp | number (long) | 4 | Date/time when this external data reference is written. |
| Appfield1 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| Appfield2 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| Appfield3 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| Appfield4 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| Appfield5 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| Appfield6 | string | 40 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then Appfield 1–6 are copied from the Interchange_tb. |
| DocumentName | string | 255 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then DocumentName is ignored. |
| ReferenceData | string | 255 | Copied from the Document_tb according to the DocumentKEY. If the external data is associated with an interchange, then ReferenceData is ignored. |
| TranslationReport File | string | 255 | Name of the translator report file. |
| DocStatus | number (integer) | 2 | Indicates whether document processing succeeded:
|