< Using POSper < Developer guide < Stable

The two tables that store the sales are:

TICKETS (TICKETID, DATENEW, HOST, PERSON, PAYMENT, MONEY INTEGER)

PRODUCTSOUT (TICKETID, TICKETLINE, PRODUCT, UNITS, PRICE)

One sale is one record in the table TICKETS and one or more records in the table PRODUCTSOUT.

This article is issued from Wikibooks. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.