Both the consolidated and remote databases contain a table named ULOrder. While the consolidated database holds all orders (approved and those pending approval), the UltraLite remote only displays a subset of columns according to the user that has authenticated.
Columns in the table are displayed as fields in the client application. When you add an order, you must populate the Customer, Product, Quantity, Price, and Discount fields. You can also append other details such as Status or Notes. The timestamp column is used to identify whether or not the row needs to be synchronized.
Adding an order
Changing the status of an order