The Invoice Items List worksheet contains the following fields as detailed information of each invoice.
| Invoice Items Field | Description |
|---|---|
| Order_ID | The Invoice Number representing an order in the system. This number is assigned by the Invoice Tool sequentially as orders are added to the system, and is the invoice number that should be entered in the Order Form worksheet to load an existing invoice. |
| Product_ID | The unique Product Id assigned when a product is added to the system from the Product List worksheet. |
| Product_Name | The Product Name from the Order Form worksheet. |
| Product_Description | The Description from the Order Form worksheet. |
| Product_Price | The per unit Price from the Order Form worksheet. |
| Product_Quantity | The Quantity of a specific product from the Order Form worksheet. |
| Item_Total | The line item subtotal of Quantity times Price from the Order Form worksheet, before any Item Discounts are applied. |
| Item_Discount | The line Item Discount from the Order Form, and subtracted from the Subtotal to calculate the Grand Total. |
