2101 CSV Output

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 despatched 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