This is a description of the template for excel file order creation for multi customer orders. This template is called "Multikundorder - orderspec 2.0".
| Parameters | Namn | Description | Example | Mandatory |
| ClientId | Client name. | Yes | ||
| Orderno | Order number | It is not possible to enter the same order number again, the registrant must check for available order numbers and prefix in XTND Backend. | Yes | |
| OrderDate | Orderdate | ÅÅÅÅ-MM-DD hh:mm | No | |
| Orderreference | Order reference. Printed as "Your Reference" on order header. | |||
| CustomerNo | Customer number. If entering a customer number that don not exists, the customer will be created. (Duplicates are not allowed). Do not mix and create new customers with existing ones. | Yes | ||
| DeliveryMethod | Agreed available mode of transport for the client. If you want to specify another delivery method, the abbreviation for the delivery method must be specified, it must be a valid way for the client. If you do not specify anything, default delivery method will be set for the order. | No | ||
| DeliveryName1 | Name for delivery adress, row 1. | Yes | ||
| DeliveryName2 | Name for delivery adress, row 2. | No | ||
| DeliveryAddress1 | Adress for delivery adress, row 1. | Yes | ||
| DeliveryAddress2 | Adress for delivery adress, row 2. | No | ||
| DeliveryAddress3 | Adress for delivery adress, row 3. | No | ||
| DeliveryPostalCode | Postal code for delivery adress. Postal code must be without spaces. | Yes | ||
| DeliveryCity | City, for delivery adress. | Yes | ||
| DeliveryState | Delivery state. | No | ||
| DeliveryCountry | County for delivery adress. | Yes | ||
| PhoneNumber | Telephone number of recipient or notification service if such is included with the mode of transport. Telephone numbers are also saved on the customer for new customer arrangements. On orders, they are saved by telephone and printed on orders under your reference. | No | ||
| InvoiceName | Name for invoice adress. | Yes | ||
| InvoiceAddress1 | Adress for invoice adress, row 1. | Yes | ||
| InvoiceAddress2 | Adress for invoice adress, row 2. | No | ||
| InvoiceAddress3 | Adress for invoice adress, row 3. | No | ||
| InvoicePostalCode | Postal code for invoice adress. | Yes | ||
| InvoiceCity | City for invoice adress. | Yes | ||
| InvoiceState | State for invocie adress. | No | ||
| InvoiceCountry | Country for invoice adress. | Yes | ||
| AskedDeliverydate | Desired delivery date (ÅÅÅÅ-MM-DD tt:mm). | Yes | ||
| VATno | VAT number. Only to be filled in for new layouts by a new customer. | No | ||
| OrgNo | Organisation number. Only to be filled in for new layouts by a new customer. | No | ||
| GoodsNotification | Goods notification. Printed as Freight Marking on orders. (In ConsumerOrder as MKS on head) | No | ||
| PaymentType | Type of payment. Entered as: INV: BILLING AUTO: AUTOGIRO ADV: ADVANCEPAYMENT FAC: FACTORING CAS: CASHPAYMENT LAS: LASTSCHRIFT CC: CREDITCARD MOH: MANUALONHOLD FAM: INVOICEME | Yes | ||
| FreightFree | Freight free or not. 0: Freight 1: Freight free | Yes | ||
| RowCounter | Number of rows in the order. If there are 3 lines with the same order number, a 3 is written on each line for the order. | Yes | ||
| Orderposition | Order line position. Fill in if you want a special order on the rows. | No | ||
| Item | Product numer. Product must be stored in XTND Backend and linked to price list, warehouse and supplier agreement. | Yes | ||
| ItemName | Product name. This will overwrite existing description. | No | ||
| Quantity | Ordered quantity. Always written in integers. | Yes | ||
| Unit | Sales unit. The unit must be set in XTND Backend and connected to the product and a price list. | Yes | ||
| PriceexVAT | Price ex VAT per unit. If price is indicated on a row, all rows in the column must be registered with price. | No | ||
| VATPercentRow | VAT in percent. If VAT is entered on a row, all rows in the column must be registered with VAT. | No | ||
| Currency | Currency as in ex. SE, DKK or NOK. The currency must be on an active price list for the customer. | Yes | ||
| Notes | Notes for order. Written as order line listing on order document. (In ConsumerOrder as MKS) | No | ||
| OrderEmail | Email for order confirmation. | No | ||
| InvoiceEmail | Email for invoice. | No | ||
| Warehouse | Warehouse that's connected to the product. | No | ||
| OrderReviewReasonNotes | No |