Versions Compared

Key

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

Products with ZERO stocks will not be included in this export

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

Overview

A simple and compact warehouse stock snapshot by product.

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 products only , so no rotations will be shownProvides product information for the specified account

Name Convention

WhStkPd

Limitations

API Only

Limitations

Last Updates

We will only show entries highlighting changes which are less than 2 years old

Date

Change

 

 

 

 

Example Output

PDF

CSV

XML

2131

2610 XML Specifications

Singles per case

XML Segment

XML API Element

Length

Notes

<WhStkPd>

<P>

<PC>

50

Product Code

<TS>

6

Total Singles in stock

A total amount in single items, including stocks which are currently frozen.

For available stock consider using https://visionsoftware.atlassian.net/wiki/pages/resumedraft.action?draftId=2787377153 instead.

<SC>

5

Notes

<T>

<R>

CCO

Customer code - Your warehouse account reference

SCO

Site code - The site code where your account is based at the warehouse

PCO

Product code

PDN

Product description

PDN2

Sub description - usually reserved for translations of the product description

BNA

Brand name

YEA

Year

COO

Country of Origin

PTY

Product type (Beer, Wine, Spirits, Intermediate, Tobacco, Cigarettes, Promotional, Innocent)

UOM

Unit of Measure (1 = Pallets / Cases / Singles, 2 = Litres / Centilitres, 3 = Inner / Outer / Packet)

SPC

Singles per case

CPP

Cases per pallet

SS

Single size (litres)

ABV

Alcoholic strength / ABV

WKG

Net weight (KG) per case

GRS

Gross weight (KG) per case

M3

Cubic metres per case

TCO

Tax code (excise duty)

PLI

Product life (days), 0 if unknown

SLI

Shelf life (days), 0 if unknown

AN1

Analysis information field, for wine usually 'Classification'

AN2

Analysis information field, for wine usually 'Colour'

AN3

Analysis information field, for wine usually 'Designation'

AN4

Analysis information field, for wine usually 'Region'

AN5

Analysis information field, for wine usually 'Sub Region'

AN6

Analysis information field, for wine usually 'Type'

</P>

</WhStkPd>