Page Comparison

<HO>1

SiteCode

Y

A

2

Mandatory -  this field is MANDATORY for all files

<HO>2

DeliveryType

Y

A

6

A code which defines the purpose of the purchase order / pre-advice.
See the code list for a list of codes which are used here PA Code List

Mandatory -  this field is MANDATORY for all files

<HO>3

SupplierCode

A

8

If you know the supplier code which is stored on the warehouse keeper system then this can be filled in, instead of having to complete the full supplier details below.

Some warehouses this is still required, please check with the warehouse

Optional - Do not filll this in if you do not know the correct code the system will reject the entire pre-advice if this is an invalid code.

<HO>5

ExpectedDeliveryDate

Y

D

Format dd/mm/yyyy or dd/mm/yy

Mandatory

<HO>6

Container

B

Either Y or N

Optional – Default is NO

<HO>7

ContainerNumber

A

20

Conditional – Should be supplied if this is arriving in container, but can be left blank

<HO>8

SlipSheetsInUse

B

Either Y or N

Optional – Default is NO

<HO>9

OnPallets

B

Either Y or N

Optional – Default is NO

<HO>10

SupplierName

Y

A

50

If this is being used for Delivery Type = COLL (e.g. You are asking the warehouse to pick the goods up and return to the warehouse) then supply the collection name and address in the fields HO10-HO26

MANDATORY

<HO>11

SupplierContactName

Y

A

50

MANDATORY

<HO>12

SupplierAccountCode

A

20

MANDATORY

<HO>13

SupplierAddressLine1

Y

A

50

MANDATORY

<HO>14

SupplierAddressLine2

Y

A

50

<HO>15

SupplierAddressLine3

Y

A

50

<HO>16

SupplierTown

Y

A

50

MANDATORY

<HO>17

SupplierPostcode

Y

A

15

MANDATORY

<HO>18

SupplierCountry

Y

A

2

ISO-3166 – 2 digit country codes
If UK then GB needs to be entered !! 

MANDATORY

<HO>19

SupplierTelephone

A

20

<HO>20

SupplierFax

A

20

<HO>21

SupplierEmail

A

50

single email address

<HO>22

ShipperName

Y

A

50

<HO>23

ShipperContactName

A

50

<HO>24

ShipperContactTelephone

A

20

<HO>25

ShipperContactFax

A

20

<HO>26

ShipperContactEmail

A

50

single email address

<HO>27

ExpectedNoOfLines

Y

I

Total number of product lines due

Mandatory

<HO>28

ExpectedNoOfCases

Y

I

Total number of cases due

<HO>29

ArrangeCollection

Y

B

1

Y or N

CONDITIONAL

When DeliveryType = RFC then this line is mandatory

If not required it defaults to “N”

<LO>1

ProductCode

Y

A

20

Mandatory

<LO>2

DescriptionOfGoods

Y

A

50

Mandatory

<LO>3

CountryWhenceConsigned

A

20

Unless supplied will default from the country code of the supplier

<LO>4

ReserveCustomerDetail

A

8

Enter the reserve customer code. In the event of a EnPrimeur shipment the same line could be repeated many times for different reserver customer codes, each customer for example receiving a single case.

<LO>8

UnitsPerPallet

I

Only supply if different to the product master table

Conditional - Must be supplied in case the product does not exist, mandatory when HO29 Arrange Collection to be TRUE

<LO>9

SinglesPerUnit

Y

I

Also known as SPC - Can never be zero (0)

e.g. How many items are there per unit / case

Mandatory

<LO>10

SingleSize

Y

N

8.5

Also known as SS - If liquid then the single item number of litres; otherwise could be the single weight otherwise if the product is not measurable then use 1.00

Mandatory

<LO>11

ExpectedPallets

I

Enter a value if left blank will deflt to 0

Conditional – Either <LO>10 or 11 or 12 must be greater than 0

<LO>12

ExpectedUnits

Y

I

Enter a value if left blank will deflt to 0

Conditional – Either <LO>10 or 11 or 12 must be greater than 0

<LO>13

ExpectedSingles

Y

I

Enter a value if left blank will deflt to 0

Conditional – Either <LO>10 or 11 or 12 must be greater than 0

<LO>14

ProductCostPerUnit

Y

N

18.5

Money field so MUST contain 2 decimals e.g. 13.00 or 143.12

MANDATORY

<LO>15

InsuranceCostPerUnit

N

18.5

Money field so MUST contain 2 decimals e.g. 13.00

Highly Recommended to complete

<LO>16

FreightCostPerUnit

N

18.5

Money field so MUST contain 2 decimals e.g. 13.00

Highly Recommended to complete

<LO>19

IsOriginalWoodCase

B

Y or N

<LO>23

ProductCostCurrency

Y

A

3

ISO 4127 Currency Code – if LO<13> provided then required

<LO>24

InsuranceCostCurrency

A

3

ISO 4127 Currency Code – if LO<14> provided then required

<LO>25

FreightCostCurrency

A

3

ISO 4127 Currency Code – if LO<15> provided then required

<LO>29

SiteCode

A

2

Optional  - Should a customer send a single PO and require it to be landed into two sites then this field should be filled in otherwise left blank. If the po has lines with differing site codes on each line then a separate unique PO will be added to the system, one for each site.

<LO>30

PALineNo

Y

I

4

The line number from your system, we will send this back to you when we send the receipt.

MANDATORY

<LO> 31

Vintage

Y

A

4

Either use a 4 digit year or NA or NV in this field.

If you do not know do not send this, if it is the same as the product then it is not needed.

<LO>32

DutyPaid

B

Either Y or N or will assume N if left blank

This can only be set to Y for items receipted from the same country the warehouse is located, if this is not the case then N must always be used (or left blank)

If you are storing with a third party warehouse do not send this element as the warehouse are required to check the goods on arrival. Only where the goods are a return from a duty paid delivery should you set this flag where there is no doubt that ALL duties have been paid.

<LO>33

CRR

B

Condition Report Required - defaults to N (No)

Options are Y or N

<LO>35

Brand

Y

A

50

Brand Name field please provide either the

Brand OR Producer OR Manufacturer

Very Important for UK New Duty Regime 2023 - small producer discounts on duty

Mandatory 

<LO>36

Strength

Y

N

4.2

ABV Strength

Mandatory for excise warehouses and alcoholic products

<LO>40

LOCF1

These are custom fields, their data type and use will depend on each warehouse to define.

Not all warehouses will use these fields but where they are in use you will be able to obtain this from the code list table and it will be linked from here.

<LO>41

LOCF2

<LO>42

LOCF3

<LO>43

LOCF4

<LO>44

LOCF5

<LO>46

LOCF6

<LO>47

LOCF7

<LO>48

LOCF8

<LO>49

LOCF9