...
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 In Stock 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 in stock Singles | ||||||||
<TotalS> | 6 | Total Available Singles in stock | ||||||||
<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><FS> | 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. | |||||||
| <OC><PIPC> | 8 | Ordered Pick in Progress Cases | This is the total of all orders in the system where the stock has not been removed from the available stock. Will also include orders which are on hold (for whatever reason) If the order has been entered onto the warehouse system it will account for it here. The value of the figures here should also be deducted from the present available stock figures to calculate stock available for order Stock available for order is = TotalS - TotalFS - TotalOS | <OS> | 8 | Ordered Bottles | <TotalOS> | 8 | Orderedany orders which are in the progress of being picked, they are beyond the point of edit or cancellation. | |
| <PIPS> | 8 | Pick in Progress Bottles | ||||||||
| <TotalPIPS> | 8 | Pick in Progress Total Singles | ||||||||
| <PBrand> | 50 | Product Brand | ||||||||
| <TRAC> | 8 | Transfer In Cases | This is cases where a pre-advice is entered which is a "TRA" or Transfer from another site. It will only identify the product where the product code is known. The TRA is generated when the goods are confirmed picked in the sending warehouse, which means they will be removed from the sending warehouse. This stock has still not arrived in the warehouse but is expected, any order sent for stock which is in Transit will result in an insufficnet stock message until it has arrived and is landed in stock. | |||||||
| <TRAS> | 8 | Transfer In Singles | ||||||||
| <TotalTRAS> | 8 | Transfer In total in singles | ||||||||
</LD> |
...