<?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>

decimal(9,4)

O

This should be <OrderLinesTotal> less <OrderCartDiscount> and the vat of the net amount

Line tax Totals

<Fee>

decimal(9,4)

O

Surcharge for Credit Card Payment

Surcharges > Price / Unit (SurchargePrice),
tblVisionSalesOrderHeaderAPI.FeeTotal

<FeeTax>

decimal(9,4)

O

Surcharge tax

tblVisionSalesOrderHeaderAPI.FeeTaxTotal

<Shipping>

decimal(9,4)

O

Not including VAT

Sundry Shipping Amount

<ShippingTax>

decimal(9,4)

O

VAT on Shipping Total

<TaxTotal>

decimal(9,4)

O

If declared this is the VAT element of the sale

If not declared we will assume VAT at prevailing rate against OrderTotal

tblVisionSalesOrderHeaderAPI.TaxTotal

<OrderTotal>

This should be

Order Lines Total - Order Discount + Shipping Total + SurchargeTotal

tblVisionSalesOrderHeaderAPI.OrderTotal

<Payments>
     <Payment>

O

Available from VC v2.10.0+, allows multiple payments to be posted per order, if empty then payment on account is assumed

API Payment Details
tblVisionSalesOrderPayment

<PaymentMethodID>

varchar(30)

C

Checks if valid and sets code

Mandatory if <Payments> segment submitted

FKPaymentMethod

<PaymentMethod>

varchar(30)

O

Description of Payment Method

Not currently in use

<Value>

decimal(9,2)

C

Mandatory if <Payments> segment submitted

Value

Optional Section -

only needed if linking to credit card payment gateway in Vision

<Name>

nvarchar(30)

C

Conditional depending on payment method ID

Payment Transaction ID returned from vision live payment gateway 

BillingName

<Company>

varchar(50)

C

BillingCompany

<Address1>

nvarchar(50)

C

BillingAddress1

<Address2>

nvarchar(50)

C

BillingAddress2

<City>

nvarchar(50)

C

BillingCity

<State>

nvarchar(50)

C

BillingState

<Postcode>

varchar(15)

C

BillingPostcode

<Country>

varchar(2)

C

Billingcountry

<Email>

varchar(50)

C

BillingEmail

<Phone>

varchar(20)

C

BillingPhone

<TID>

varchar(50)

C

BillingTID

<FirstName>

nvarchar(30)

C

Not currently in use

<LastName>

varchar(30)

C

    </Payment>
</Payments>

<ShippingMethodID>

varchar(30)

O

Checks if valid and sets code if not will use API defaults

Sets Carrier based on ShippingMethodID

<FKPaymentMethod>

int

O

Checks if valid and sets code if not will use API defaults

Sets Credit Card Order flag,

tblVisionsalesOrderheader.FKPaymentMethod

<WebOrderID>

bigint

M

We provide a VC Order number automatically, this should be the website's unique reference for the order

Stored in OtherInfo=> Notes field

<DName>

nvarchar(60)

M

Not currently in use

</Order>

200

Order saved

201

Order saved, however auto submission was failed

400

Something wrong with input or processing, 
Check the error response and re-post after correcting