Home > Technical > Table Definitions > POREVIEWOTHER

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.

ITEM.lintItemNumber

STRSTORECODE

VARCHAR(10)

The location the item was ordered for.

TRADUNIT.strTradeCode

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)