Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

File Specification
(Fields in blue are contained on the CSV output)

XML Segment

XML FILE Element

XML API Element
(Future Change)

Length

Notes

<HD>

<CustomerCode>

<Cust>

8

Your customer code with the warehouse

<SiteCode>

<Site>

6

Stock holding customer site code.

<ProductCode>

<Code>

50

<Description>

<Desc>

50

</HD>

<LD>


<Rotation>

<Rotn>

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>

<Recd>

10

<SPC>

<SPC>

5


<PC>

<PC>

6

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


<PS>

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

<TS>

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>

<FzC>

6

Whole numbers only, no decimal places

<FB>

<FzS>

6

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

<TotalFS>

<TFzS>

6

A total amount in single items.

<ExciseDP>

<DP>

3

Yes or No indicator whether the items have duty paid.

<Reserve>

<Rsrv>

8

Only completed is the stock has a reserve customer code allocated

<BBD>

<BBD>

10

Best Before Date

<Year>

<YR>

4

Alternatively ‘vintage’

<Batch>

<Bth>

30

Your batch number (if known)

<CustomsDP>

<FC>

3

Free Circulation - Yes / No  - is customs duty paid

<OWC>

<OWC>

3

Original Wooden Case – Yes / No

<DStamp>

<DS>

3

Duty Stamped - Yes / No

<PackageType>

<PT>

6

Check with warehouse for codes in use.

</LD>





...