PC XML Structure

<PC>

Mandatory

Each Product code, section can be repeated

<HD> </HD>

Mandatory

One time for each product

<HO> </HO>

Optional

One time for each product

<MX> </MX>

Optional

One time for each product

</PC>

Mandatory

End of Product Code, next product can be added

</PRODUCTS>

Mandatory

End of the XML

<HD>1

CustomerCode

AN

8

Y

Will specify the customer code not the PKID, and a lookup will have to be performed

Mandatory – Will specify the customer code (Alphanumeric) which should be unique and refer to one single site, otherwise see site code field

<HD>2

SiteCode

AN

2

Y

Conditional – When the warehouse keeper has multiple sites then this field is MANDATORY for all files

<HD>3

CountryOfOrigin

A

3

Y

See standard ISO-3166-2 (Alpha 2 codes)

 ISO 3166-1 alpha-2 code

Mandatory – Must be filled in, if UK then use GB

<HD>4

ProductCode

AN

20

Y

Any product code for the goods up to length of 20 alphanumeric characters. Please check with your warehouse regarding paperwork as many report outputs for delivery notes are limited to 20 characters as it is rare to have a code beyond this.

Note : The ultimate limit<Gro on this is 50 characters

Mandatory

<HD>5

ProductDescription

AN

50

Y

Maximum length 50 characters

Mandatory

<HD>6

SinglesPerUnit

I

5

Y

No of singles within a case
Whole numbers only also known as [Singles per CASE]

Mandatory

<HD>7

SingleSize

D

8.4

Y

Format to 2 decimal places minimum - e.g 0.75 for a 75cl bottle

Quantity is litres if liquid / kg if weight

Mandatory – if not applicable use 1.00

<HD>8

NetWeightKG

D

8.4

Y

Format to 2 decimal places minimum - e.g 4.50   Can never be 0.00
This is the weight of the product in the case in Kg

Mandatory

<HD>9

GrossWeightKG

D

8.4

Y

Format to 2 decimal places minimum - e.g. 7.62 Can never be 0.00
This is the weight of the case in KG, Generally if not known it is about x1.7 or x1.8 the net weight.

Mandatory

<HO>1

ProductGroupCode

AN

8

Optional

<HO>2

VATCode

A

1

Use S for everything, unless food then use Z

Optional – Will default to the system standard.

<HO>3

CommodityCode

A

20

This field is only sometimes known by the customer.

For UK format is 10 character - eg 2204217900 

Optional

<HO>4

CountryWhenceConsigned

A

3

Use standard ISO-3166-2 (Alpha 2 codes)

Optional – Will default to COO if left blank

<HO>5

TaxCode

I

3

Most customers never know this code.

The format is per HMRC e.g. 425 or 413

Optional

<HO>6

UnitToChargeBy

Not Used

<HO>7

ProductType

A

1

Y

Code

Type

BBeerCCigarettesIIntermediate GoodsPPromotional ItemsSSpirits (wet goods)TTobaccoWWineZGoods outside the scope of HMRC
e.g. Innocent 

Conditional – If a excise or customs warehouse the mandatory.

This is the initial letter of the category that the commodity code is within.

e.g 22042179 commodity is within category W100 which then is in Product Type "W"

Each warehouse and customer is approved for storage based on the categories of the goods.

<HO>8

PackageDescription

Maximum length 50 characters
As vintage, brand, single size and singles per unit are stored separately then this field is recommended to store other information.

Not Used

<HO>9

AlternativeCode

AN

8

Should you be obtaining the product from another customer then this is the customer code for the supplying customer.

Please check if your warehouse offer this facility

<HO>10

AlternativeDescription

AN

30

Should you be obtaining the product from another customer then this is the product  code for the supplying customer.

Please check if your warehouse offer this facility

<HO>11

KilogramsPerUnit

D

8.4

Conditional – for product type T (Tobacco)

<HO>12

UnitsPerPallet

I

5

Known as Cases per pallet

Conditional – if bringing in palletised goods and expecting pallet pricing then MANDATORY

<HO>13

UnitsPerLayer

I

5

Known as Cases per layer

Optional

<HO>14

Height

D

8.3

Height of the pallet

Conditional – if bringing pallets into the warehouse

<HO>15

ContainerQuantity

I

5

<HO>16

MinStockLevel

I

5

<HO>17

MinPurchaseOrderQuantity

I

5

<HO>18

MinSalesOrderQuantity

I

5

<HO>19

TraderUnitCode

I

20

Case Bar Code (if known)

<HO>20

SubUnitCode

I

20

Single Bar Code (if known)

<HO>21

StrengthABV

D

8.2

Required for alcoholic goods and bonded warehouses

Conditional – This is for excise warehouses, and is used to check commodity code and tax code, your warehouse should have this option ON and therefore these are MANDATORY for all entries, If it is not switched on then it will be MANDATORY for if the goods are Product Type = S (Spirits) or B (Beer) 

<HO>22

UsePackageQuantity

Not Used

<HO>23

IsSerialNumberRequired

Not Used

<HO>24

LitresLiquidPerUnit

D

8.5

Y

Litres of liquid in a case

Mandatory for Product Types with liquid.
W (Wine) or S (Spirits) or B(Beer)

<HO>25

LitresAlcoholPerUnit

D

8.5

Y

Litres of alcohol in a case

Mandatory when  Product Type = S (spirits) or B(Beer)

<HO>26

CigarettesPerUnit

I

5

Mandatory when Product Type = C(Cigarettes)

<HO>27

CarriagePricePerUnit

D

8.2

currency field

This is the outbound carriage costs for the onward delivery of goods.

<HO>28

CIFPricePerUnit

D

8.2

currency field

<HO>29

SalesPricePerUnit

D

8.2

currency field

<HO>30

UnderBondSalesPricePerUnit

D

8.2

currency field

<HO>31

PurchaseCostPerUnit

D

8.2

Y

currency field

<HO>32

InsuranceCostPerUnit

D

8.2

currency field

<HO>33

FreightCostPerUnit

D

8.2

currency field

<HO>34

SubtituteProduct1

AN

30

If this product is not available then an alternative code can be entered into these fields which can be substituted for the original code.

Please check with your warehouse before using

<HO>35

SubtituteProduct2

AN

30

If this product is not available then an alternative code can be entered into these fields which can be substituted for the original code.

Field 42  is required before 43 can be used

Please check with your warehouse before using

<HO>36

SubtituteProduct3

AN

30

If this product is not available then an alternative code can be entered into these fields which can be substituted for the original code.

Field 42 and 43 must be completed before field 44 can be used

Please check with your warehouse before using

<HO>37

CigarettesSellingPricePerUnit

D

8.2

Mandatory for Product Type = C(Cigarettes) or T(Tobbaco)

<HO>38

ProductLife

I

5

<HO>39

ShelfLifeDays

I

5

Number of days shelf life the goods must have if they are to be despatched

<HO>40

ProductCostPerUnit

D

8.2

<HO>41

ProductCostCurrency

A

3

Y

The currency code is required.  E.g. GBP / USD / EUR

<HO>42

InsuranceCostCurrency

A

3

The currency code is required.  E.g. GBP / USD / EUR

<HO>43

FreightCostCurrency

A

3

The currency code is required.  E.g. GBP / USD / EUR

<HO>44

BrandName

AN

50

Y

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

If your warehouse is excise of customs approved then this field is mandatory

<HO>45

Vintage

AN

4

Y

Enter either -

a 4 digit  year
or NA or NV or MIX

Mandatory for product Type = W (Wine)

Can be used for other product types

MIX - relates to the <MIX> segment within the EDI and ability to store the actual contents of the case

<MX>1

MPC

AN

20

Product Code  (not validated)

<MX>2

MDesc

AN

50

English Description

<MX>3

MNEDesc

AN

50

Non english Description 

<MX>4

MBrand

AN

50

Brand / Producer / Manufacturer

<MX>5

MYr

AN

4

Either a 4 digit year 

or NA or NV

<MX>6

MSPU

I

5

No of singles within a case
Whole numbers only also known as [Singles per CASE]

<HD>7

MSS

D

8.4

Format to 2 decimal places minimum - e.g 0.75 for a 75cl bottle

Quantity is litres if liquid / kg if weight

<HD>8

MTSQ

I

5

The number of single items in this case for this product.

e.g.   2