...
Overview | This file extracts all goods received |
...
SiteCode_CustomerCode_GdsRcvd_Datetime.
SiteCode_CustomerCode_GdsRcvdE_Datetime.
...
CSV Output File
...
Field Name
...
Length
...
CustomerCode
...
8
...
RotationNumber
...
10 or 15
...
ProductCode
...
20
...
ProductDescription
...
50
...
PackageDescription
...
50
...
PurchaseOrderNo
...
30
...
Your purchase order number, each po number is usually dealt with on a single receipt.
...
Details
...
90
...
General Notes on the receipt.
...
SupplierName
...
30
...
This information is held, and can be the supplier or yourself, it is used in declarations to HMRC for payment of duties should that be required.
...
DateReceived
...
10
...
The date in which the goods arrived on site, and the rental start date.
...
DeliveryType
...
6
...
See code list A - this is used to signify the type of receipt and potentially the agreed warehouse charges for the receipt.
...
SinglesPerCase
...
6
...
Cases
...
6
...
6
...
Singles
...
6
...
6
...
TotalInSingles
...
6
...
DutyPaid
...
3
...
Is the stock arriving Duty Paid status.
...
ProductCodeperCase
...
10.2
...
ProductCostCurrency
...
3
...
Uses ISO currency code.
...
FreeCirculation
...
3
...
Is the stock in Free Circulation within the EC, this means is “Customs Duty “ paid
...
ReserveCustomer
...
8
...
If the stock goes into a reserve customer code account then the code is shown here.
...
BestBeforeDate
...
8
...
If the stock has a best before date then this is shown in the field here, the format is normally dd/mm/yy
...
OriginalWoodenCase
...
3
...
A Yes or No field, and is used when the case containing the stock is the original wooden case
...
NoOfPallets
...
6
...
If the stock is received in pallets then the number of pallets is shown in this field, normally used when pallet space charging is in use, a part pallet will show as one more pallet received.
...
CasesPerPallet
...
6
...
The number of cases on the pallet for this rotation number.
...
RotationNotes
...
30
...
Any general notes made by the warehouse on the receipt of the goods for this rotation, can include damage or notification of issues with the goods received.
...
EMCSInfo
...
30
...
This will be introduced in 2010 and is a EU system to control the movement of goods in the EU and the UK. The EMCS reference is the sending warehouse unique identifier for these goods, and can show you that the receipt of the goods has discharged the sender of their HMRC obligation for receipt.
Enhanced Goods Received File
...
XML Output File
Segment
...
Segment
L1
...
Segment
L2
...
Note : Any lines shown in RED are coming in a future version.
...
CSV Field Name
(FYI only)
...
XML Segment
...
XML
Element
...
Length
...
<HD>
...
CustomerCode
...
<CustCode>
...
8
...
Stock Holding Customer Code
...
PurchaseOrderNo
...
<PurOrdNo>
...
30
...
Your purchase order number, each po number is usually dealt with on a single receipt.
...
Details
...
<Notes>
...
90
...
General Notes on the receipt.
...
SupplierName
...
<Supplier>
...
30
...
This information is held, and can be the supplier or yourself, it is used in declarations to HMRC for payment of duties should that be required.
...
DateReceived
...
<DteRcd>
...
dd/mm/yyyy
...
The date in which the goods arrived on site Dd/mm/yyyy
...
DeliveryType
...
<RcptType>
...
6
...
See code list A below, this is used to signify the type of receipt and potentially the agreed warehouse charges for the receipt.
...
</HD>
...
<LD>
...
RotationNumber
...
<Rotation>
...
10 or 15
...
ProductCode
...
<PCode>
...
20
...
ProductDescription
...
<PDesc>
...
50
...
SinglesPerCase
...
<SglCase>
...
6
...
Cases
...
<Cases>
...
6
...
6
...
Singles
...
<Singles>
...
6
...
6
...
TotalInSingles
...
<TSingles>
...
6
...
DutyPaid
...
<ExciseDP>
...
3
...
Is the stock arriving Duty Paid status.
...
ProductCostPerCase
...
<IBV>
...
10.2
...
ProductValueCurrency
...
into the warehouse for specific days and can be used to replace the automated goods received report. |
...
The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis.
It is up to the customers whether this is scheduled.
The file will normally be emailed to your email address as an attachment to an existing message, and is accompanied with a pdf text document which can also be used for visual confirmation.
Filename Convention | SiteCode_CustomerCode_GdsRcvdE_Datetime. |
Limitations | This file can only be exported in one Goods Received format, once exported it will not be available on one of the alternatives. |
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Example Output
PDF
| View file |
|---|
| name | LW_LAYW_GdsRcvdE_1562022152041.pdf |
|---|
|
CSV
| View file |
|---|
| name | LW_LAYW_GdsRcvdE_1562022152041.csv |
|---|
|
| Expand |
|---|
| title | XSD - downloadable and raw - 12/07/2022 |
|---|
|
| Code Block |
|---|
<xsd:schema targetNamespace="2202_GdsRcvdE" xmlns:schema="2202_GdsRcvdE" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sqltypes="http://schemas.microsoft.com/sqlserver/2004/sqltypes" elementFormDefault="qualified">
<xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/sqltypes" schemaLocation="http://schemas.microsoft.com/sqlserver/2004/sqltypes/sqltypes.xsd" />
<xsd:element name="vw_VEDI_ReportData_FKReport_17">
<xsd:complexType>
<xsd:attribute name="CustomerCode" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CustomerContact">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CustomerName" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="RotationNumber">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="25" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ProductCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ProductDescription" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:nvarchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="101" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PackageDescription">
<xsd:simpleType sqltypes:sqlTypeAlias="[VisionWarehousing_R].[dbo].[TextProductDescription]">
<xsd:restriction base="sqltypes:nvarchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PackagingTypeDescription">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="60" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PurchaseOrder">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="WarrantDetails">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="OtherDetails">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="DateReceived" type="sqltypes:datetime" use="required" />
<xsd:attribute name="ReceiptType">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="BottlesPerCase" type="sqltypes:smallint" use="required" />
<xsd:attribute name="Cases" type="sqltypes:int" />
<xsd:attribute name="Bottles" type="sqltypes:int" />
<xsd:attribute name="TotalBottles" type="sqltypes:int" use="required" />
<xsd:attribute name="IsDutyPaid" type="sqltypes:bit" use="required" />
<xsd:attribute name="InBondValue" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="18" />
<xsd:fractionDigits value="5" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="IBVCurrency">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="IsFreeCirculation" type="sqltypes:bit" use="required" />
<xsd:attribute name="BestBeforeDate" type="sqltypes:datetime" />
<xsd:attribute name="IsOriginalWoodCase" type="sqltypes:bit" use="required" />
<xsd:attribute name="Pallets" type="sqltypes:int" />
<xsd:attribute name="CasesPerPallet" type="sqltypes:smallint" use="required" />
<xsd:attribute name="RotationNotes">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="256" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ReserveCustomer">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="12" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyName">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyAddress1">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyAddress2">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyAddress3">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyAddress4">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CompanyPostcode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SiteCode" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="2" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SiteDescription" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PostCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="HasOwnerChangedInUK" type="sqltypes:bit" use="required" />
<xsd:attribute name="CustomerPODate" type="sqltypes:datetime" use="required" />
<xsd:attribute name="CustomerPONumber" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="20" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CustomerBatchNo">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="HMRCReceiptType">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SupplierName">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SingleSize">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="Package">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="48" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="Vintage">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="4" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CWCCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="2" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CWCName">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="25" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FKPOStatus" type="sqltypes:int" />
<xsd:attribute name="PKStockInwardsHeader" type="sqltypes:bigint" use="required" />
<xsd:attribute name="SystemReceiptDate" type="sqltypes:datetime" />
<xsd:attribute name="ProductCostPerUnit" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="18" />
<xsd:fractionDigits value="5" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="InsuranceCostPerUnit" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="18" />
<xsd:fractionDigits value="5" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FreightCostPerUnit" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="18" />
<xsd:fractionDigits value="5" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ProductCostCurrency">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="InsuranceCostCurrency">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="FreightCostCurrency">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="EMCSRefNo">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PALineNo" type="sqltypes:int" />
<xsd:attribute name="PKStockInwardsDetail" type="sqltypes:bigint" use="required" />
<xsd:attribute name="EDIGoodsReceivedReportSent" type="sqltypes:bit" use="required" />
<xsd:attribute name="FreezeUponReceipt" type="sqltypes:bit" use="required" />
<xsd:attribute name="ReserveCustomerName">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="RotationLineNo">
<xsd:simpleType sqltypes:sqlTypeAlias="[VisionWarehousing_R].[dbo].[RotationLineNo]">
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="4" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="BrandName" use="required">
<xsd:simpleType sqltypes:sqlTypeAlias="[VisionWarehousing_R].[dbo].[TextBrandName]">
<xsd:restriction base="sqltypes:nvarchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="50" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="PackagingTypeCode">
<xsd:simpleType sqltypes:sqlTypeAlias="[VisionWarehousing_R].[dbo].[TextPackagingTypeCode]">
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="6" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="CommodityCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="20" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="ItemWeight" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="18" />
<xsd:fractionDigits value="5" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SupplierAccountCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="8" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SupplierAccountSite">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="2" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="HMRCTypeCode">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="2" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SupplierDocRef">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="SupplierCustomerDP">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="30" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="StockDate">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="RentDate">
<xsd:simpleType>
<xsd:restriction base="sqltypes:varchar" sqltypes:localeId="1033" sqltypes:sqlCompareOptions="IgnoreCase IgnoreKanaType IgnoreWidth">
<xsd:maxLength value="10" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
<xsd:attribute name="DutyStampsApplied" type="sqltypes:bit" />
<xsd:attribute name="StrengthABV" use="required">
<xsd:simpleType>
<xsd:restriction base="sqltypes:decimal">
<xsd:totalDigits value="5" />
<xsd:fractionDigits value="2" />
</xsd:restriction>
</xsd:simpleType>
</xsd:attribute>
</xsd:complexType>
</xsd:element>
</xsd:schema> |
|
XML Specification
Segment | Element | Field | Length | Comments / Notes
|
<HD> | | | | |
| <CustCode> | CustomerCode | 8 | Stock Holding Customer Code |
| <PurOrdNo> | PurchaseOrderNo | 30 | Your purchase order number, each po number is usually dealt with on a single receipt. |
| <Notes> | Details | 90 | General Notes on the receipt. |
| <Supplier> | SupplierName | 30 | This information is held, and can be the supplier or yourself, it is used in declarations to HMRC for payment of duties should that be required. |
| <DteRcd> | DateReceived | dd/mm/yyyy | The date in which the goods arrived on site Dd/mm/yyyy |
| <RcptType> | DeliveryType | 6 | See code list linked below, this is used to signify the type of receipt and potentially the agreed warehouse charges for the receipt. https://visionsoftware.atlassian.net/wiki/spaces/VEDI/pages/2572320769/Code+Lists#B---Delivery-Type |
| <HMRCType> | | 6 | HMRC Movement Type Code, see code list https://visionsoftware.atlassian.net/wiki/spaces/VEDI/pages/2572320769/Code+Lists#A---Order-Type |
| <Site> | | 6 | Stock Holding Customer Site |
| <SAC> | | 8 | Supplier Account Code |
| <SAS> | | 6 | Supplier Account Customer Site (only when delivery type is TRA) |
| <SDocRef> | | 20 | This is auto filled into the Other details field on the receipt. (only when delivery type is TRA) |
| <SDPRef> | | 20 | Prefixed with DPREF: this is autofilled in the Purchase Order details for a transfer(only when delivery type is TRA) |
| <HOCF1> | Custom Field | | Will only output if there is data |
| <HOCF2> | Custom Field | | Will only output if there is data |
| <HOCF3> | Custom Field | | Will only output if there is data |
| <HOCF4> | Custom Field | | Will only output if there is data |
| <HOCF5 | Custom Field | | Will only output if there is data |
| <HOCF6> | Custom Field | | Will only output if there is data |
| <HOCF7> | Custom Field | | Will only output if there is data |
| <HOCF8> | Custom Field | | Will only output if there is data |
| <HOCF9> | Custom Field | | Will only output if there is data |
</HD> | | | | |
<LD> | | | | |
| <Rotation> | RotationNumber | 10 or 15 | |
| <PCode> | ProductCode | 20 | |
| <PDesc> | ProductDescription | 50 | |
| <SglCase> | SinglesPerCase | 6 | |
| <Cases> | Cases | 6 | |
| <Singles> | Singles | 6 | |
| <TSingles> | TotalInSingles | 6 | |
| <ExciseDP> | DutyPaid | 3 | Is the stock arriving Duty Paid status. |
| <IBV> | ProductCostPerCase | 10.2 | |
| <IBVCurr> | ProductValueCurrency | 3 | Uses ISO currency code. |
| | FreightCostPerCase | 10.2 | |
| | FreightCostCurrency | 3 | |
| | InsuranceCostperCase | 10.2 | |
| | InsuranceCostCurrency | 3 | |
| <CustomsDP> | FreeCirculation |
...
<CustomsDP>
3 | Is the stock in Free Circulation within the EC, this means is “Customs Duty “ paid |
| <ResCust> | Reserve Customer |
...
<ResCust>
8 | If the stock goes into a reserve customer code account then the code is shown here. |
| <ResName> | Reserve Name |
...
...
...
<BBD>
8 | If the stock has a best before date then this is shown in the field here, the format is normally dd/mm/yy |
| <OWC> | OriginalWoodenCase |
...
| 3 | A Yes or No field, and is used when the case containing the stock is the original wooden case |
| <Pallets> | NoOfPallets |
...
<Pallets>
6 | If the stock is received in pallets then the number of pallets is shown in this field, normally used when pallet space charging is in use, a part pallet will show as one more pallet received. |
| <CsperPall> | CasesPerPallet |
...
<CsperPall>
6 | The number of cases on the pallet for this rotation number. |
| <RotnNotes> | RotationNotes |
...
| 256 | Any general notes made by the warehouse on the receipt of the goods for this rotation, can include damage or notification of issues with the goods received. |
| <EMCS> | EMCSInfo |
...
<EMCS>
6 | EMCS for incoming goods |
| <PALineNo> | PALineNo |
...
...
5
The line number provided in the Pre Advice file from the customers system. If the warehouse have manually added any item lines then this number will be blank to signify that it was not sent from your system in the first place and that you need to manually review this line. |
| <StockDate> | | dd/mm/yyyy | Date the stock was available in the warehouse |
| <RentDate> | | dd/mm/yyyy | Date the stock rent period starts from (even if there is then a free period this will be at the start of the period) |
...
...
...
...
...
...
...
...
<Year>
4 | Year or Vintage could be NA or NV |
| <Brand> | Brand |
...
| 50 | For Wine customers the producer, otherwise brand |
| <PackCD> | Packaging Code |
...
...
|
| <PackDesc> | Packaging Description |
...
...
...
Code Lists
A - Delivery Type
...
1
...
PUR
...
PUR - Purchased Goods
...
2
...
RET
...
RET - Return from Delivery
...
3
...
RWW
...
RWW - ReWarehouse by Whse
...
4
...
RWC
...
RWC - ReWarehouse by Customer
...
5
...
RFC
...
RFC - Collection from Customer
...
6
...
TRA
...
TRA - Transfer Internal
...
7
...
UNS
...
UNS - Unsure / Unknown
...
8
...
WKO
...
WKO - Works Order
...
9
...
XTR
...
XTR - External Transfer
...
10
...
CTO
...
| 8.5 | |
| <NWghtCs> | Net Weight per Case | 8.5 | |
| <ABV> | Strength ABV | 5.2 | |
| <LOCF1> | Custom Field | | Will only output if there is data |
| <LOCF2> | Custom Field | | Will only output if there is data |
| <LOCF3> | Custom Field | | Will only output if there is data |
| <LOCF4> | Custom Field | | Will only output if there is data |
| <LOCF5> | Custom Field | | Will only output if there is data |
| <LOCF6> | Custom Field | | Will only output if there is data |
| <LOCF7> | Custom Field | | Will only output if there is data |
| <LOCF8> | Custom Field | | Will only output if there is data |
| <LOCF9> | Custom Field | | Will only output if there is data |
</LD> | | | | |
<BN> | | | | Segment only appears if the Batch Number contains “MULTI” |
| <MBatchNo> | Multi Batch Number | 30 | If multi batch numbers are scanned at goods inwards they will be in this section |
</BN> | | | | |
</HD> | | | | |