| Notes | |
|---|---|
| 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. The By Product version is great for customers not using rotation numbers for ordering or where they are looking to balance Product to Product |
| Format (including file extension) | CSV XML |
| Available | |
| Delivery & Scheduling | The report can be scheduled to run automatically on a daily, weekly or monthly basis or you can schedule this via the VCIS site. The stock file will normally be emailed to your email address(es) as an attachment to an existing message. |
| File Name Convention | SiteCode_CustomerCode_StkPrdt_datetime [.csv] [.xml] For the Enhanced Versions : SiteCode_CustomerCode_StkPrdtE_datetime [.csv] [.xml] |
| Limitations | This is a summary by product, there is no reference to individual rotations within this export. Products with ZERO stocks will not be included in this export. |
Field Names & Content for Product Level CSV and XML File
| Segment | Segment L1 | Segment L2 | Notes |
|---|---|---|---|
| <StockProd> | |||
| <LD> | This repeats many times within the StockProd | ||
| </LD> | |||
| </StockProd> |
CSV Field Name | In the CSV | XML Segment Name | XML Element Name | Length | Notes |
<LD> | |||||
Customer Code | Y | <CustomerCode> | 8 | Your customer code with the warehouse | |
| <Site> | 6 | Stock holding customer site code | |||
Product Code | Y | <ProductCode> | 50 | ||
Product Description | Y | <Description> | 50 | Description from the Product table and could be different to the stock level description | |
Earliest Date Received | Y | <FirstDate> | 10 | Date Received of Earliest Stock | |
Last Date Received | Y | <LastDate> | 10 | The last date stock was received for this product | |
Singles Per Case | Y | <SPC> | 5 | This will use the Product Singles per case as the product default. | |
Present Cases | Y | <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 | Y | <PS> | 6 | ||
Total Present Singles | Y | <TotalS> | 6 | ||
Frozen Cases | Y | <FC> | 6 | Frozen Stocks which are NOT included in the Present Cases figures. | |
Frozen Singles | Y | <FB> | 6 | ||
Total Frozen Singles | Y | <TotalFS> | 6 | ||
Allocated Cases | Y v3.2 | <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 | Y v3.2 | <AS> | 6 | ||
Total Allocated Singles | Y v3.2 | <TotalAS> | 6 | ||
| Product Single Size | Enhanced only | <PSS> | 8.5 | ||
| Product Cases per Pallet | Enhanced only | <PCPP> | 5 | ||
| Product Year | Enhanced only | <PYear> | 4 | ||
| Product Packaging Code | Enhanced only | <PPackCd> | 8 | ||
| Product Packaging Description | Enhanced only | <PPAckDesc> | 50 | ||
| Total Singles Presently in stock which are underbond | Enhanced only | <TotalSUB> | 8 | ||
| Total singles currently in stock which are duty paid. | Enhanced only | <TotalSDP> | 8 | ||
| Product Brand | Enhanced only | <PBrand> | 50 | ||
</LD> |