2103 CSV Output

 

Field Name

Length

Description

Notes

<CustomerCode>

8

Customer Code

Your customer code with the warehouse

<ProductCode>

50

Product Code

 

<Description>

50

Product Description

Description from the Product table and could be different to the stock level description

<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

<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

 

<PBrand>

50

Product Brand



Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.