| Database Definitions / Transfer database fields | |
When logging tracking data to a database, summary data is also stored in the VLTracked table. This table contains data for all tracking types: EDI, XML, and Text.
| Column/Field Name | Data Type | Length | Source |
|---|---|---|---|
| TransferID | VARCHAR | 30 | VLEDIInterchange.TransferID VLXMLExtractedData.TransferID VLTextExtractedData.TransferID |
| VLSerial | VARCHAR | 6 | VLEDIInterchange.VLSerial VLXMLExtractedData.VLSerial VLTextExtractedData.VLSerial |
| Interchange | INTEGER | VLEDIInterchange.Interchange 0 (for XML and Text) |
|
| FunctionalGroup | INTEGER | VLEDIFunctionalGroup.FunctionalGroup 0 (for XML and Text) |
|
| SetID | INTEGER | VLEDITransactionSet.TransactionSet VLXMLExtractedData.SetID VLTextExtractedData.SetID |
|
| TradingPartnerAlias | VARCHAR | 255 | VLEDIInterchange.TradingPartnerAlias VLXMLExtractedData.TradingPartnerAlias VLTextExtractedData.TradingPartnerAlias |
| Type | VARCHAR | 255 | VLEDITransactionSet.TransactionType
(X12/Edifact) VLEDITransactionSet.MessageType (Tradacoms) VLXMLExtractedData.DocumentType VLTextExtractedData.DocumentType |
| Description | VARCHAR | 255 | VLEDITransactionSet.TransactionDesc Description from XML Description from Text |
| DocumentID | VARCHAR | 255 | VLEDIInterchange.ControlNum VLXMLExtractedData.DocumentID VLTextExtractedData.DocumentID |
| Ref1 | VARCHAR | 500 | VLEDITransactionSet.Ref1 VLXMLExtractedData.Ref1 VLTextExtractedData.Ref1 |
| Ref2 | VARCHAR | 500 | VLEDITransactionSet.Ref2 VLXMLExtractedData.Ref2 VLTextExtractedData.Ref2 |
| SenderID | VARCHAR | 255 | VLEDIInterchange.Sender
[+ “:” +
VLEDIInterchange.SenderQualifier] VLXMLExtractedData.SenderID VLTextExtractedData.SenderID |
| ReceiverID | VARCHAR | 255 | VLEDIInterchange.Receiver
[+ “:” +
VLEDIInterchange.ReceiverQualifier] VLXMLExtractedData.ReceiverID VLTextExtractedData.ReceiverID |
| DocumentDateTime | VARCHAR | 255 | VLEDIInterchange.InterchangeDT (formatted as
yyyy/MM/dd HH:mm:ss)
VLXMLExtractedData.DocumentDateTime VLTextExtractedData.DocumentDateTime |
| SetControlNum | VARCHAR | 14 | VLEDITransactionSet.ControlNum NULL (for XML and Text) |
| DataSegmentCount | INTEGER | VLEDITransactionSet.DataSegmentCount NULL (for XML and Text) |
|
| AckStatus | VARCHAR | 3 | VLEDITransactionSet.AckStatus NULL (for XML and Text) |
| AckIControlNum | VARCHAR | 14 | VLEDITransactionSet.AckIControlNum NULL (for XML and Text) |
| isX12 | BIT | VLEDIInterchange.isX12 NULL (for XML and Text) |
|
| isEDIFACT | BIT | VLEDIInterchange.isEDIFACT NULL (for XML and Text) |
|
| isTRADACOMS | BIT | VLEDIInterchange.
isTRADACOMS NULL (for XML and Text) |