Jump to content

Using POSper/Developer guide/Database-Miscellaneous Details

Add links
From Wikibooks, open books for an open world
< Using POSper | Developer guide
This page may need to be reviewed for quality.

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.

Retrieved from "https://en.wikibooks.org/wiki/Using_POSper/Developer_guide/Database-Miscellaneous_Details"