Stock Movement Types in EEE

From EnablerWiki

Jump to: navigation, search

Created: 17 November 2008. Last Reviewed: 13 July 2009


Stock Movement Types in EEE

The EEE table (view) StockMovementTbl (StockMovement) holds line item detail records for all stock movements. StockMovementTbl.Type is an integer column which identifies the type of each transaction.


Type Description
0 Sale or Return (Use the sign of the quantity to determine)
1 Alternative Sale or Return (Use the sign of the quantity to determine)
2 Goods Receipt
3 Return to Supplier
4 Stock Transfer In/Out (Use the sign of the quantity to determine)
5 Stock Adjustment
6 Stock take*
7 Internal Bin Trnsfer
8 Concept Sports Head Office Inter-store Transfer (Reserved)
9 Stock quantity adjustment (via SC record import)
10 Staff Uniform Sale

* Note: Enabler stock takes posted to EEE by means of incremental adjustments will appear in the the StockMovementTbl table as type 5 with a StockAdjustmentReasonCode of 'STAKE'.


Note that a positive quantity in StockMovementTbl represents an inwards movement / increase of stock on hand. A negative movement represents an outward movement or decrease of stock on hand. Thus a sale, for example, will have a negative quantity in StockMovement.Quantity as it is an outward movement of stock.