2104 Rotation Stock Enhanced

A stock snapshot can be created to provide customers with stock information at the time of day it has been run.  This data can be used to run stock comparisons and reconciliations or just as a general stock sheet.

This will list all rotations, so product codes will be shown multiple times, one time for each rotation

<SiteCode>_<CustomerCode>_StkRotnE_<datetime>     

Products with ZERO stocks will not be included in this export, this was introduced from April 2017 onwards

As orders are only issued with final rotation at the picking stage it is not possible to show an allocated stock for a rotation as prior to picking only the product is known.

Stock is considered as stock in warehouse and is not “available to order” quantities

As Vision Warehousing can store Rotations with varying levels of singles per case, at rotation level you get the information stored for each rotation.

XML Segment

XML Element

XML Element
(future change)

Length

Notes

<HD>

<CustomerCode>

<Cust>

8

Your customer code with the warehouse

<Site>

<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

Singles per case

<PC>

<PC>

6

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

<PS>

<PS>

6

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

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

<FzC>

<FzC>

6

Frozen Cases
Whole numbers only, no decimal places

<FzS>

<FzS>

6

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

<TotalFzS>

<TFzS>

6

Total Frozen in singles
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>

<Pck>

6

Package Type Code – as per ISO listings [not in CSV export]

<SS>

<SS>

8.5

Single Size

<CPP>

<CPP>

6

Cases per Pallet

<PPackCd>

<PkCd>

8

Packaging Code

<PPAckDesc>

<PkDe>

50

Will be made up from database fields

<Singles per case>   X   <Single Size>
<Year> [where the product is Wine this is the vintage or NA or NV]
Per Pallet <cases per pallet>

e.g.     6 x 0.75   2007  Per Pallet : 112

<TotalSUB>

<TSUB>

8

Total Singles Underbond

<TotalSDP>

<TSDP>

8

Total Single Duty Paid

<PBrand>

<Brd>

50

Product Brand

<PONo>

<PO>

15

<RotnNotes>

<RNote>

50

<PValue>

<Value>

8.5

Product Value in currency entered

<PValueCurr>

<VCurr>

3

ISO Code

<GoodsInUID>

<GIUID>

15

the pre-advice header number for this receipt.

<NWt>

<NWt>

8.5

<GWt>

<GWt>

8.5

<ABV>

<ABV>

3.2

Strength ABV in % of the item (available from v4.5.0)

</LD>