This field is a lookup field that gets its data from the Orders table. Since the Orders table has a large number of orders, AppGini automatically displays this lookup field as an
auto-complete. Type part of the order number to see a list of matching orders to choose from.

This is the price of the product as specified in the products table. You could use that in the unit price field or specify another price.

Units remaining in stock. You shouldn't exceed that amount in the quantity field unless you know an incoming shipment will cover the missing quantity before the order required date.

This field will appear formatted as US currency in the table view.

The table view displays the sum of all item quantities below the quantity column. Although meaningless, this just shows the sum feature provided by AppGini.

Enter a discount amount here rather than a percentage or ratio. This field will appear formatted as US currency in the table view.

This field is Automatically calculated.