Layout solds file(s)

These csv files contain the sold item information: when sold and by who, how much and how payed, how much tax per tax class, retail and wholesale price.
Through preferences.txt you have selected, with yes or no, which files are produced:
sales_per_year , sales_per_month , sales_per_day and/or sales_per_employe .
Through etc_lingua.txt you may have adapted the prefix name of the files:
overall_solds_year , overall_solds_month , solds_day and/or solds_ .

1. Each file has the same layout. Each file starts with a header line which contains the name of each column. Columns are seperated by the csv_seperator (see etc_lingua.txt).
   The following column names (and thus columns) are used, if not adapted :
   

   Date
   Employe
   BillNbr
   Item
   Quantity
   Retail
   RetailSubTotal
   PercentageTax
   VAT High
   VAT Middle
   VAT Low
   Not Used
   Not Used
   Wholesale
   WholesaleSubTotal
   RetailTotal
   Cash
   Credit card
   Check
   Change
   

2. Most of these header line words are in file etc_lingua.txt and can be adapted there.
   The tax column headersVAT High , VAT Middle , VAT Low , Not Used and Not Used are from taxclasses.txt and can be adapted there.

3. Date
   This column contains the date hour of the receipt closing.
   The format is "year-month-day hour:minutes:seconds" . Note that some spreadsheets will automatically convert it into the their format.

4. Employe
   This column contains the employe/table name. This name the employe/table has is defined in menu_lingua.txt.

5. BillNbr
   This column contains the number of the receipt (bill). The number is composed from receipt_prefix and actual_receipt_number (the number is formatted according to receipt_nbr_digits). See also preferences.txt.

6. Item
   This column contains the sold item description. See the pricelist.txt.

7. Quantity
   This column contains the quantity of the sold item.

8. Retail
   This column contains the retail price. Normally it is from the pricelist.txt but it may have been changed via through menu Discount on .. or Edit price item or Free item.

9. RetailSubTotal
   This column contains the subtotal of the retail price multiplied by quantity.

10. PercentageTax
    This column contains the tax percentage included in the retail price.

11. VAT High
    This column contains the amount of tax included in the retail price if tax class TAX1 is applicable.
    The name is the name of the tax claas as specified in taxclasses.txt .

12. VAT Middle
    This column contains the amount of tax included in the retail price if tax class TAX2 is applicable.
    The name is the name of the tax claas as specified in taxclasses.txt

13. VAT Low
    This column contains the amount of tax included in the retail price if tax class TAX3 is applicable.
    The name is the name of the tax claas as specified in taxclasses.txt

14. Not Used
    This column contains the amount of tax included in the retail price if tax class TAX4 is applicable.
    The name is the name of the tax claas as specified in taxclasses.txt

15. Not Used
    This column contains the amount of tax included in the retail price if tax class TAX5 is applicable.
    The name is the name of the tax claas as specified in taxclasses.txt

16. Wholesale
    This column contains the wholesale price of the item. It is from the pricelist.txt

17. WholesaleSubTotal
    This column contains subtotal of the wholesale price of the item multiplied by quantity.

18. RetailTotal
    This column contains the sum of all RetailSubTotal's per receipt.

19. Cash
    This column contains the amount payed cash per receipt. Only 1 of 3 payment methods is possible.

20. Credit card
    This column contains the amount charged to the credit card per receipt. Only 1 of 3 payment methods is possible.

21. Check
    This column contains the amount writen on the check per receipt. Only 1 of 3 payment methods is possible.

22. Change
    This column contains the amount of change money per receipt.