Order Line Log For Free

Order: The ?shopping basket? full of items you've just purchased. Lines: The different products within your order, recognized by warehouses as each individual Stock Keeping Unit (SKU) or Universal Product Code (UPC) number. Units: The quantity of each line.

Order ? An order is a list of products with a status. In our case, a shopping cart is simply an order with a status of "Shopping Cart." Line Item ? Every product on the order is referenced by a record that includes quantity and a reference to which order it belongs. This record is known as a line item.

The ORDERS table contains information for customer orders, including order number, customer ID, and salesman.

The order line generally contains information about what was ordered, this is done because a single order can have multiple items in it. So the order line would specify the item ordered, the quantity ordered and the price charged, and there would be one line for each different item ordered.

Each Order has zero or more OrderLines, which identify the quantity of each item in the order. The key for the OrderLine is a compound key that consists of the Order that owns the OrderLine and an integer that assigns the order line a number.

A sales order line item is an individual transaction listed on a sales order. For example, one case of product X and two cases of product Y on the same sales order would count as two line items.

An order line is a line on the order containing information relative to a specific item being ordered. For example, a Buyer creates an order for three computer monitors, three keyboards, and three printers. When looking at the entire order you are at the order header level.