Invoices File Structure

The exported TXT file with the Invoices data contains the list of invoices with the detailed information by categories of the purchased items. Each invoice is described by several rows:

One row contains the data about the invoice itself.
Next rows contain the data about each category of the invoice item.

Invoices File Name

The Invoices TXT file name has the following structure:

<GLOutput>-<YYYYMMDD>_Invoices.<Num>.TXT

GLOutput: Default file prefix, a fixed value.
YYYYMMD: The date of the data export.
Invoices: Indicates the type of downloaded data—invoices.
Num: The sequential number of the exported file.

The example of the downloaded TXT file with the invoices data is displayed in the image below:

Invoices File Data Structure

Invoices data in the TXT file is grouped in columns. Detailed description of each column is provided in the table below.

Column name	Column description
DocType	The DocType column value is always equal to 1.
VendorID	The general ledger number which is configured at the vendor level. For more information, see Setting Up Merchandise Vendors.
Description	The invoice description. This value has the following structure: <VendorID>-<InvoiceID>-<StationGL#> , where: VendorID: The general ledger number which is configured at the vendor level. For more information, see Setting Up Merchandise Vendors. InvoiceID: The invoice number in CStoreOffice®. StationGL#: The general ledger number which is configured at the station level. For more information, Advanced Location Options.
InvoiceNumber	The invoice number in CStoreOffice®.
InvoiceDate	The date of the invoice.
InvoiceAmt	The invoice total value.
AccountNo	The number of the customer's account. Possible values: <2000><StationGL#>: Such value is exported for the row which contains the data about the invoice itself. 2000: A fixed default value. StationGL#: The general ledger number which is configured at the station level. For more information, Advanced Location Options. <1><CategoryGL#><StationGL#>: Such value is exported for the rows which contain the data about the categories of the invoice items. 1: A fixed default value. CategoryGL#: The general ledger number which is configured at the category level. For more information, see Adding a New Category. StationGL#: The general ledger number which is configured at the station level. For more information, Advanced Location Options. <AccountGL#><LocationGL2>: This data types are used for the fuel purchases by grade data. AccountGL#: Possible values: 2000: Is exported for invoice totals, when the Credit data is exported. The MAS GL# column's value from the Export Settings form > MAS 90 section > Fuel subsection is taken for , when the Debit data is exported. LocationGL2: The general ledger number which is configured at the station level. For more information, Advanced Location Options.
Debit, Credit	Possible values: Invoice Total: This value is exported for the row which contains the data about the invoice itself. Category Total: This value is displayed for the rows which contain the data about the categories of the invoice items. Fuel Total: In case of fuel invoice, the Amount value from the Fuel Invoice form is displayed. For more information, see Fuel Invoices. Each row in the file contains either Debit or Credit value.

The example of the TXT file with the Invoices data is displayed in the image below: