2102 CSV Output

XML FILE Element

Length

Notes

CustomerCode

8

Your customer code with the warehouse

ProductCode

50

Description

50

Rotation

10 or 15

Rotation Number in the format  YY/Dnnnnnn and where rotation line number are in use then YY/Dnnnnnn/nnnn.  The 15 digit format is only used when necessary, normally only shows 10 digits unless a line number exists.

DateReceived

10

SPC

5

PC

6

Whole numbers only, no decimal places, this will be calculated using the rotation level record singles per case

PS

6

The remainder of stock which is in addition to the number of cases in stock, this will be calculated using the rotation level record singles per case

TotalS

6

A total amount in single items.

The present stocks figures are the total available stock holdings at the time of the extract and do NOT include items which are frozen.

To find your total stock in bond you need to add the Present and Frozen case figures together.

FC

6

Whole numbers only, no decimal places

FB

6

The remainder of stock which is in addition to the number of cases in stock

TotalFS

6

A total amount in single items.

ExciseDP

3

Yes or No indicator whether the items have duty paid.

Reserve

8

Only completed is the stock has a reserve customer code allocated

BBD

10

Best Before Date

Year

4

Alternatively ‘vintage’

Batch

30

Your batch number (if known)

CustomsDP

3

Free Circulation - Yes / No  - is customs duty paid

OWC

3

Original Wooden Case – Yes / No

DStamp

3

Duty Stamped - Yes / No

PackageType

6

Check with warehouse for codes in use.