Show TOC

Component documentationTLOG Data Capture File Formats

 

This section contains a comprehensive listing of the transaction log (TLOG) data capture record formats, file types, and additional information type formats.

The CVTLOG utility is used to create the ASCII version of the Transaction File or TLOG File from the *.TXN files. These ASCII files (bothTXN and TOTALS) can now (with Version 3.2.16B or higher) be created directly on the fly by using the appropriate configuration options for real time trickle.

POS data records are terminated by a carriage return/line feed. Each record is started with a header (See Appendix A). All numeric fields are left zero-filled and all alpha and alpha/numeric fields are right blank-filled.

Positive Flag: Positive Flag fields contain the sign for a numeric field; either ‘-‘ for negative or ‘ ‘ for positive. If the record is a post void, the sign will be the sign of the original sale.

Extended Length for Amount Fields: Most amount fields (prices) exist in the TLOG ASCII in a 6.2 format. This is usually (but not always) 8 digit characters with no decimal point in the ASCII. For clients that need a larger number of digits options can be set to produce longer amount fields. The largest length that amount fields can be increased by is 2. When longer amount fields are required, different TLOG record types are created. To create larger amount fields and their corresponding TLOG records, set the following options:

  1. Use CVTLOG using the –W# switch specifying the number (#) of extra digits to output.

  2. POS.INI:

    • USELARGERAMOUNTFIELDS= (set to 0, 1, or 2 for the extended length)

    • CVTLOG_INCREASELENGTHBY= (set to 0, 1, or 2 for the extended length).