2202 CSV Output

CSV Field Name

Length

CustomerCode

8

Stock Holding Customer Code

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

dd/mm/yyyy

The date in which the goods arrived on site  Dd/mm/yyyy

DeliveryType

6

See code list A below, this is used to signify the type of receipt and potentially the agreed warehouse charges for the receipt.

RotationNumber

10 or 15

ProductCode

20

ProductDescription

50

SinglesPerCase

6

Cases

6

6

Singles

6

6

TotalInSingles

6

DutyPaid

3

Is the stock arriving Duty Paid status.

ProductCostPerCase

10.2

ProductValueCurrency

3

Uses ISO currency code.

FreightCostPerCase

10.2

FreightCostCurrency

3

InsuranceCostperCase

10.2

InsuranceCostCurrency

3

FreeCirculation

3

Is the stock in Free Circulation within the EC, this means is “Customs Duty “ paid

Reserve Customer

8

If the stock goes into a reserve customer code account then the code is shown here.

Reserve Name

30

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

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.

EMCSInfo

6

EMCS for incoming goods

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.

Batch Number

20

Commodity Code

20

UID

12

Year or Vintage

4

Year or Vintage could be NA or NV

Brand

50

For Wine customers the producer, otherwise brand

Packaging Code

8

Packaging Description

30

Single Size

8.5

Net Weight per Case

8.5