Home > Technical > Table Definitions > POREVIEWOTHER
This is part of the purchase order review process which uses the table POREVIEWORIG, POREVIEWITEM, POREVIEWREPDTL, POREVIEWOTHER and POREVIEWTFR. This table stores details about all locations which are NOT ordering the item (as stored in POREVIEWORIG). This allows the reviewer to transfer stock from one location to another.
Column |
Type |
Description |
LINTITEMNUMBER |
INT(4) |
IPN of the item being ordered. |
VARCHAR(10) |
The location the item was ordered for. |
|
DBLSTOCKONHAND |
DECIMAL(9)19,4 |
When initially reviewed, this will be the stock on hand at this location. As stock is transferred to other locations, this number will be changed. |
DBLRATEOFSALE |
DECIMAL(9)19,4 |
The rate of sale for this location. As dblStockOnHand is changed, this number will NOT change. |
DBLSTOCKCOVER |
DECIMAL(9)19,4 |
The stock cover (stock on hand/rate of sale) for this location. As dblStockOnHand is changed, this number will NOT change. |
Primary Key: LINTITEMNUMBER + STRSTORECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |