Field Name | Length | Comments |
W5No | 10 | The W5 number submitted to HMRC for the unique transaction, this would normally appear on your statement which is send from HMRC. The payment of duties is split between acquisition VAT and deferred VAT so each will be allocated a separate W5 number. |
CustomerCode | 8 | |
DefermentCustomer | 8 | |
SiteCode | 2 | This is the warehouse keepers site code to identify the site, and approval number which is being used for the generation of the duty and vat submission. A separate submission will be made for each site approval. |
TaxCode | 3 | The 3 digit tax code for the goods, see HMRC lists for further details and descriptions about tax codes. |
Date | 10 | The date of the transaction, and will be the date the picking has been confirmed. |
ProductCode | 30 | |
ProductDescription | 50 | |
RotationNumber | 10 | Will be 10 digits the standard length |
RotationLineNo | 4 | Is the line number for the rotation, and will only be completed if there is a line number associated with the movement of the stocks |
SinglesPerCase | 10 | Number of singles in each unit |
SingleSize | 10 | The single size, when this is bottles of wine for example the standard size would be 0.75 litres |
DocRef | 30 | Your unique reference for this movement. |
OrderType | 5 | There are various movement types recorded for all movements, these are unique and assist in the correlation of why payments have been made, please see the section below detailing different stock movement types. |
Cases | 6 | The number of cases within the calculation |
Singles | 6 | The number of single items over and above the cases within the calculation |
Qty | 10 | The quantity on which excise duty is paid, this could be weight, litres of alcohol, value, litres of liquid and is dependent on the tax code requirements |
ExciseRate | 20 | The value of which has been used for the calculation of duty |
ExciseDuty | 20 | This is the qty field X rate of duty |
CustomsRate | 20 | The value of which has been used for the calculation of duty (rate is per hectolitre) |
CustomsDuty | 20 | This is the qty field X rate of duty / 100 |
InbondValue | 20 | Product Cost + Insurance + Freight + Vat Val Adjustment This is not the value for vat however it is used in the calculation which is as follows : InbondValue + If customs duty has been paid prior to the excise transaction but during the stay at the warehouse then the value will be increased by this amount. If you pay customs duty at port then it is included in the vat value adjustment. |
VATAmount | 20 | VAT Amount Based on value for vat x vat rate at the time of the excise movement. |
General
Content
Integrations