<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<Order>

<OType>

varchar(2)

M

Options 

SO  - Standard Order (defaut)

EP - EP Order

FKSalesOrderType

<Warehouse>

varchar(6)

M

the warehouse code of the warehouse to be used for the order otherwise it will default to the warehouse set in the API admin options

WareHouseCode

<UnderBondType>

varchar(2)

M

Options

DP : Duty Paid (default)

Other options - Underbond (will place order on hold awaiting all UB details)

U : UK Under Bond
X : Export
E : Other EC Warehouse
D : Duty Free
V : Visiting Forces
O : Other Duty Free use
T  : Transfer of Stock within Warehouse
R  : Customer Paid Reserves

Under Bond Type

<Customer>

varchar(8)

O

Either field can be provided, if you provide nothing here then the system will use the default customer account code held in the API defaults setting

Customer

<CustID>

bigint

O

<OrderDate>

date

M

format   YYYY-MM-dd

Order Date

<ReleaseDate>

datetime

O

YYYY-MM-dd HH:mm:ss format

Web site completed date/time 

Release Date

<Address1>

nvarchar(50)

M

Delivery Address1

<Address2>

nvarchar(50)

O

Delivery Address2

<Address3>

nvarchar(50)

O

Delivery Address3

<Town>

nvarchar(50)

M

Delivery Town

<Postcode>

varchar(15)

M

Postcode

<Country>

varchar(2)

M

Country code

<Contact>

nvarchar(30)

O

Delivery Contact

<DelContactNo>

varchar(50)

O

Delivery Contact No (Telephone)

<Instructions>

varchar(120)

O

Will use customers default instructions unless this has something different when this will over write.

Delivery Instructions

<CustomerRef>

varchar(30)

O

The customer’s reference for the order

Customer Ref

<AccountManager>

varchar(8)

O

Sales Order Analysis 1

Used to override the default option for the primary customer analysis code on a sales order

Account Manager

<Type>

varchar(8)

O

Sales Order Analysis2

Used to override the default option for the secondary customer analysis code on a sales order

Type

<OrderLines>

    <Item>

M

Section can be repeated with the <Item>, repeat for each individual order line

tblVisionSalesOrderDetail

<ProductCode>

varchar(30)

M

Product Code

<RotationNo>

varchar(15)

O

RotationNumber

<Units>

int

M

No of Cases

<Singles>

int

C

Number of Singles

<UnitPrice>

decimal(9,2)

C

After discounts and excluding VAT

PricePerUnit

<SinglePrice>

decimal(9,2)

C

After discounts and excluding VAT

PricePerSingle

<LineTotal>

decimal(9,4)

O

After discounts and excluding VAT

Total Price for the line, EX VAT

<LineTax>

decimal(9,4)

O

VAT for this line

VAT total for the line

    </Item>

</OrderLines>

<SMsgDocNo>

int

O

Special message document

SM Document ID

<SMsgDocument>

varchar(80)

O

Special message document type

SM Document Type

<SMsgQuantity>

int

O

Special message quantity

SM Quantity

<SMsgHeader>

varchar(120)

O

Special message Header

Special Message Text 3

<SMsgTo>

varchar(80)

O

Special message recipient (to)

Special Message Text 5

<SMsg1>

varchar(4096)

O

Saved in the order "warehouse options" – please check availability with the warehouse.

Used by customers who wish to put a card inside the delivery for the receiver.  Can be used for “Happy Birthday” “Merry Christmas” messages or similar.

Can be HTML formatted or plain text.

SpecialMessageText1

<SMsg2>

varchar(4096)

O

This is line 2 of the message text and is predominantly used as a marketing message for the receiver of the goods.

Can be HTML formatted or plain text.

SpecialMessageText2

<SMsgFrom>

varchar(80)

O

Special message sender (from)

Special Message Text 6

<SMsgFooter>

varchar(120)

O

Special message footer

Special Message Text 4

<SMsgEmail>

email

O

Special Message Email address

Not currently in use

<CartDiscount>

decimal(9,4)

O

Total Discount Amount

<LineTotal>

decimal(9,4)

O

Not including VAT

Line total

<LineTaxTotal>