Order Line Record (OL)
Add OL records in the order in which you want them to display in the transaction field. The total number of order lines following an OH record is verified against the number of lines specified in the header.
| Record # | Field Name | Data Type | Comments |
|---|---|---|---|
| 1 | Record Type | OL | Required: Always OL |
| 2 | Product Code | Char (31) | Optional: If not used, the Description becomes a required field. If specified, must exist in the Product table. |
| 3 | Product Description | Char (225) | Required if product code is left blank. Optional if product code is used. Used to override the product description for this order. |
| 4 | Quantity Ordered | Numeric | Optional |
| 5 | Unit Price | Money | Optional: Used to override the unit price in the Product table. - In a VAT Exclusive system, the supplied price should exclude the VAT. If the order is eligible for tax, and the product is taxable, then tax will be automatically added. - In a VAT Inclusive system, the price is saved as supplied. If the order is eligible for tax, and the product is taxable, the supplied price should include the VAT otherwise it should exclude it. |
| 6 | Taxable | Boolean | Optional: Used to override the product taxation status. - In a VAT system, the Data Type is Char(20) and is used to override the Tax Code for the product. The supplied value should be a valid Tax Code or a – (minus) symbol. Supplying a Tax Code overrides the existing Tax Code associated with the product, and makes a tax exempt product taxable. Supplying a – (minus) symbol makes a taxable product tax exempt. In a VAT Inclusive system, if the Unit Price is not supplied in the import file then the system defined Unit Price will be manipulated to reflect the new tax rate. This is achieved by removing the existing tax component of the system defined Unit Price then adding on tax at the supplied rate. |
| 7 | Commission Rate | Numeric | Optional: Used to override the commission rate contained in the Product table. (Do not express the commission rate percentage as a decimal or fraction. Use a whole number.) |
| 8 | Discount | Numeric | Optional: Used to enter product-level discounts. Product-level discounts override order-level discounts for product line-items. |
| 9 | Location | Char (10) | Optional: Used to enter a warehouse location when using multiple warehouses. |
| 10 | Bin | Char (10) | Optional: Used to enter a storage bin within a warehouse. |
| 11 | UF\_1 | Char (30) | Optional: Used to enter and define specific order information for products. |
| 12 | UF\_2 | ||
| 13 | UF\_3 | ||
| 14 | UF\_4 |