...
| Segment | Segment L1 | Segment L2 | Notes | ||
|---|---|---|---|---|---|
| <MStkProd> | |||||
| <ST><LD> | This repeats many times within the StockProd | ||||
| <PRD> | </ | PRD></ST>LD> | |||
| </MStkProd> |
XML Segment Name | XML Element Name | Length | Description | Notes |
<LD> | ||||
<CustomerCode> | 8 | Customer Code | Your customer code with the warehouse | |
| <Site> | 6 | Site Code | Stock holding customer site code | |
<ProductCode> | 50 | Product Code | ||
<Description> | 50 | Product Description | Description from the Product table and could be different to the stock level description | |
<FirstDate> | 10 | Earliest Date Received | Date Received of Earliest Stock | |
<LastDate> | 10 | Last Date Received | The last date stock was received for this product | |
<SPC> | 5 | Singles Per Case | This will use the Product Singles per case as the product default. | |
<PC> | 6 | Available Cases | The available stocks figures are the total available stock holdings at the time of the extract and do NOT include items which are frozen. NOTE : To find your total stock in bond you need to add the Present and Frozen case figures together. | |
<PS> | 6 | Available Singles | ||
<TotalS> | 6 | Total Available Singles | ||
<FC> | 6 | Frozen Cases | Frozen stocks are those where an amount of stock is being held or blocked from being used. Frozen Stocks which are NOT included in the Present Cases figures. | |
<FB> | 6 | Frozen Singles | ||
<TotalFS> | 6 | Total Frozen Singles | ||
<AC> | 6 | Allocated Cases | Allocated Stocks - ( this figure is included within the available stock figure - to find free stock then Available - Allocated) Generated from Orders Received but not picked yet including items which are on hold with the warehousing system | |
<AS> | 6 | Allocated Singles | ||
<TotalAS> | 6 | Total Allocated Singles | ||
| <PSS> | 8.5 | Product Single Size | ||
| <PCPP> | 5 | Product Cases per Pallet | ||
| <PYear> | 4 | Product Year | ||
| <PPackCd> | 8 | Product Packaging Code | ||
| <PPAckDesc> | 50 | Product Packaging Description | ||
| <TotalSUBAv> | 8 | TSingles UB Available | Total in Singles of the available singles which are underbond | |
| <TotalSDPAv> | 8 | TSingles DP Available | Total in singles of the available singles which are duty paid. | |
| <TotalSUBFz> | 8 | TSingles UB Frozen | Total in Singles of the frozen singles which are underbond | |
| <TotalSDPFz> | 8 | TSingle DP Frozen | Total in singles of the frozen singles which are duty paid. | |
| <PBrand> | 50 | Product Brand | ||
</LD> |
...