Page Comparison

Overview

This file extracts all goods received

information

into the warehouse for specific days and can be used to replace the automated goods received report.
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

Date	Change

Example Output

PDF

View file

name	LW_LAYW_GdsRcvdE_1562022152041.pdf

CSV

View file

name	LW_LAYW_GdsRcvdE_1562022152041.csv

XML

View file

name	17.xml

Expand

title	XSD - downloadable and raw - 12/07/2022

View file

name	2202_20220712.xsd

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

RotationNumber

10 or 15

<PCode>

ProductCode

20

<PDesc>

ProductDescription

50

SinglesPerCase

6

<Cases>

Cases

6

Singles

6

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)

</HD>

<LD>

<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	3	Is the stock in Free Circulation within the EC, this means is “Customs Duty “ paid
	<ResCust>	Reserve Customer	8	If the stock goes into a reserve customer code account then the code is shown here.
	<ResName>	Reserve Name	30
	<BBD>	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
	<OWC>	OriginalWoodenCase	3	A Yes or No field, and is used when the case containing the stock is the original wooden case
	<Pallets>	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.
	<CsperPall>	CasesPerPallet	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	6	EMCS for incoming goods
	<PALineNo>	PALineNo	8	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)
	<BatchNo>	Batch Number

20

30
	<CommCd>	Commodity Code	20
	<UID>	UID	12
	<Year>	Year or Vintage	4	Year or Vintage could be NA or NV
	<Brand>	Brand	50	For Wine customers the producer, otherwise brand
	<PackCD>	Packaging Code	8
	<PackDesc>	Packaging Description	30
	<SS>	Single Size	8.5
	<NWghtCs>	Net Weight per Case	8.5
	<ABV>	Strength ABV	5.2

</LD>


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

Version	Old Version 15	New Version Current
Changes made by	Alan Gilchrist	Alan Gilchrist
Saved on	Jul 12, 2022	Oct 07, 2024

Versions Compared

Key

Last Updates

Example Output

XML Specification