...
Overview | 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. | |
Format
The report is in pdf, csv and xml format. In csv format it can be read into your system or can be opened in excel.
The data in the file shows each unique rotation and the stock holding for that rotation
Delivery & Scheduling
The report can be scheduled to run automatically on a daily, weekly or monthly basis or it can be requested via the web site on an ad-hoc real time basis.
It is up to the customers whether this is scheduled.
The stock file will normally be emailed to your email address as an attachment to an existing message.
File Name Convention
The filename is dependant on which option the customer select but it will be either
SiteCode_CustomerCode_StkPrdt_datetime [.csv] [.xml] OR
SiteCode_CustomerCode_StkRotn_datetime [.csv] [.xml]
Enhanced Versions :
SiteCode_CustomerCode_StkPrdtE_datetime [.csv] [.xml] OR
SiteCode_CustomerCode_StkRotnE_datetime [.csv] [.xml]
Limitations
There are no limitations to note
Field Names & Content for Product Level CSV File
Field Name | Length | Notes |
Customer Code | 8 | Your customer code with the warehouse |
Product Code | 50 |
|
Product Description | 50 | Description from the Product table and could be different to the stock level description |
Earliest Date Received | 10 | Date Received of Earliest Stock |
Last Date Received | 10 | The last date stock was received for this product |
Singles Per Case | 5 | This will use the Product Singles per case as the product default. |
Present Cases | 6 | 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. |
Present Singles | 6 | |
Total Present Singles | 6 | |
Frozen Cases | 6 | Frozen Stocks which are NOT included in the Present Cases figures. |
Frozen Singles | 6 | |
Total Frozen Singles | 6 | |
Allocated Cases | 6 | From Orders Received but not picked yet including items which are on hold with the warehousing system but will not include EDI orders where order has been held due to EDI format error |
Allocated Singles | 6 | |
Total Allocated Singles | 6 |
If you select the CSV Stock Snapshot by Product ENHANCED version the following additional fields will be exported :
| Field Name | Length | Notes |
|---|---|---|
| Product Single Size | 8.5 | |
| Product Cases per pallet | 5 | |
| Product Year | 4 | |
| Product Packaging Code | 8 | |
| Product Packaging Description | 50 | |
| Present Total Singles Underbond | 8 | |
| Present Total Singles Duty Paid | 8 | |
| Product Brand | 50 |
Separate lines can be generated for a product where key elements of the Product summary record are different.
Field Names & Content for Product Level XML File
File Identifier <StockProd>
CSV Field Name | XML Segment Name | XML Element Name | Length | Notes |
| <LD> |
|
|
|
Customer Code |
| <CustomerCode> | 8 | Your customer code with the warehouse |
Product Code |
| <ProductCode> | 50 |
|
Product Description |
| <Description> | 50 | Description from the Product table and could be different to the stock level description |
Earliest Date Received |
| <FirstDate> | 10 | Date Received of Earliest Stock |
Last Date Received |
| <LastDate> | 10 | The last date stock was received for this product |
Singles Per Case |
| <SPC> | 5 | This will use the Product Singles per case as the product default. |
Present Cases |
| <PC> | 6 | 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. |
Present Singles |
| <PS> | 6 | |
Total Present Singles |
| <TotalS> | 6 | |
Frozen Cases |
| <FC> | 6 | Frozen Stocks which are NOT included in the Present Cases figures. |
Frozen Singles |
| <FB> | 6 | |
Total Frozen Singles |
| <TotalFS> | 6 | |
Allocated Cases |
| <AC> | 6 | From Orders Received but not picked yet including items which are on hold with the warehousing system but will not include EDI orders where order has been held due to EDI format error |
Allocated Singles |
| <AS> | 6 | |
Total Allocated Singles |
| <TotalAS> | 6 | |
| Product Single Size | <PSS> | 8.5 | ||
| Product Cases per Pallet | <PCPP> | 6 | ||
| Product Year | <PYear> | 4 | ||
| Product Packaging Code | <PPackCd> | 8 | ||
| Product Packaging Description | <PPAckDesc> | 50 | ||
| Total Singles Presently in stock which are underbond | <TotalSUB> | 8 | ||
| Total singles currently in stock which are duty paid. | <TotalSDP> | 8 | ||
| Product Brand | <PBrand> | 50 | ||
| </LD> |
|
|
|
Example
<StockProd>
<LD>
<CustomerCode>SAMPLE
<ProductCode>123456
…………………………………. Other field ………………….
</LD>
</StockProd>
Rotation Level
This will list all rotations, so product codes will be shown multiple times, one time for each rotation | ||
File Name Convention | SiteCode_CustomerCode_StkRotn_datetime | |
Limitations | Products with ZERO stocks will not be included in this export, this will be 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 | |
...
|
Field Names for CSV files Rotation Level File
Field Name | Length | Notes |
Customer Code | 8 | Your customer code with the warehouse |
Rotation Number | 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. |
Product Code | 50 |
|
Product Description | 50 |
|
Package Description | 25 | Will be made up from database fields
<Singles per case> X <Single Size>
e.g. 6 x 0.75 2007 Per Pallet : 112 |
Date Received | 10 |
|
Singles Per Case | 5 |
|
Present Cases | 6 | Whole numbers only, no decimal places |
Present Singles | 6 | The remainder of stock which is in addition to the number of cases in stock |
Total Present Singles | 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.
|
Frozen Cases | 6 | Whole numbers only, no decimal places |
Frozen Bottles | 6 | The remainder of stock which is in addition to the number of cases in stock |
Total Frozen Bottles | 6 | A total amount in single items. |
Duty Paid | 3 | Yes or No indicator whether the items have duty paid. |
Reserve Customer Code | 8 | Only completed if the stock has a reserve customer code allocated |
BBD | 10 | Best Before Date |
Year | 4 | Alternatively ‘vintage’ |
Batch | 30 | Your batch number (if known) |
Free Circulation | 3 | Free Circulation - Yes / No - is customs duty paid |
OWC | 3 | Original Wooden Case – Yes / No |
DS | 3 | Duty Stamped - Yes / No |
If you select the CSV Stock Snapshot by Product ENHANCED version the following additional fields will be exported :
| Field Name | Length | Notes |
|---|---|---|
| Single Size | 8.5 | |
| Cases per pallet | 5 | |
| Packaging Code | 8 | |
| Packaging Description | 50 | |
| Present Total Singles Underbond | 8 | |
| Present Total Singles Duty Paid | 8 | |
| Reserve Customer Name | 50 | |
| Brand | 50 |
Field Names for XML Rotation Level File
File Identifier - <StockRotn>
Example:-
<StockRotn>
<PRODUCT>
<HD>
</HD>
<LD>
</LD>
<PRODUCT>
…repeat…
</StockRotn>
...
CSV Field Name
(Reference Only)
...
XML Segment
...
XML Element
...
XML Element
(Future Change)
...
Length
...
Notes
...
...
<HD>
...
...
...
...
Customer Code
...
...
Last Updates
We will only show entries highlighting changes which are less than 2 years old
Date | Change |
|---|---|
|
|
|
|
Example Output
| View file | ||
|---|---|---|
|
CSV
| View file | ||
|---|---|---|
|
XML
| View file | ||
|---|---|---|
|
2102 XML Specifications
XML Segment | XML FILE Element | XML API Element | Length | Notes |
<HD> | ||||
<CustomerCode> | <Cust> | 8 | Your customer code with the warehouse |
...
Product Code
<SiteCode> | <Site> | 6 | Stock holding customer site code. |
<ProductCode> | <Code> | 50 |
...
...
Product Description
...
<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. |
...
Date Received
...
<DateReceived> | <Recd> | 10 |
...
...
Singles Per Case
...
<SPC> | <SPC> | 5 |
...
...
Present Cases
...
<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 |
...
Total Present Singles
...
<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. |
...
Frozen Cases
...
...
<FC> | <FzC> | 6 | Whole numbers only, no decimal places |
...
Frozen Bottles
...
<FB> | <FzS> | 6 | The remainder of stock which is in addition to the number of cases in stock |
...
Total Frozen Bottles
...
...
<TotalFzS>
<TotalFS> | <TFzS> | 6 | A total amount in single items. |
...
...
<ExciseDP> | <DP> | 3 | Yes or No indicator whether the items have duty paid. |
...
Reserve Customer Code
...
<Reserve> | <Rsrv> | 8 | Only completed is the stock has a reserve customer code allocated |
...
...
<BBD> | <BBD> | 10 | Best Before Date |
...
Year
...
<Year> | <YR> | 4 | Alternatively ‘vintage’ |
...
Batch
...
<Batch> | <Bth> | 30 | Your batch number (if known) |
...
Free Circulation
...
<CustomsDP> | <FC> | 3 | Free Circulation - Yes / No - is customs duty paid |
...
...
<OWC> | <OWC> | 3 | Original Wooden Case – Yes / No |
...
DS
...
<DStamp> | <DS> | 3 | Duty Stamped - Yes / No |
...
...
<PackageType> |
...
...
</LD>
...
...
<PT> | 6 |
...
Package Type Code – as per ISO listings [not in CSV export]
Check with warehouse for codes in use. | ||||
<ABV> | <ABV> | 3.2 | Strength ABV in % of the item | |
</LD> |