Database Definitions / Transfer database fields
Parent topic: Transfer database fields

Text tracking fields

Optionally, when logging to a database, Text files can be detected and supplementary information can be logged along with the transfer. You can configure which data is logged. See Transfers and File tracking. Data can be extracted based on column number or field numbers. The following table is used to store the extracted text strings.

VLXMLExtractedData database table

Column Name Data Type Length Description
TransferID VARCHAR 30 TransferID in VLTransfers table
VLSerial VARCHAR 6 VLSerial in VLTransfers table
SetID INTEGER   Index used for multiple sets of extracted data for the same TransferID
SenderID VARCHAR 255 Extracted sender identifier
ReceiverID VARCHAR 255 Extracted receiver identifier
DocumentID VARCHAR 255 Extracted document identifier
DocumentType VARCHAR 255 Extracted document type
DocumentDateTime VARCHAR 255 Extracted document date/time string
Ref1 VARCHAR 500 Custom reference information
Ref2 VARCHAR 500 Additional custom reference information
TradingPartnerAlias VARCHAR 255 Alias of trading partner associated to the ID.
Parent topic: Transfer database fields
© 2018 Cleo. All rights reserved.