Home > Technical > Table Definitions > POREVIEWORIG
This is part of the purchase order review process which uses the table POREVIEWORIG, POREVIEWITEM, POREVIEWREPDTL, POREVIEWOTHER and POREVIEWTFR. This table stores details about each specific instance of the item being ordered on a purchase order. If an item appears on three purchase orders, there will be three records in this table.
Column |
Type |
Description |
INT(4) |
IPN of the item being ordered. |
|
VARCHAR(10) |
The location the item was ordered for. |
|
INT(4) |
The number of the purchase order this item was ordered on. |
|
INT(4) |
The line number of the item within the purchase order. |
|
STRSUPPLIERCODE |
VARCHAR(10) |
The code of the supplier, this item was ordered from. |
STRMANUFACTURER |
VARCHAR(10) |
The code of the manufacturer, this item was ordered from. |
DBLORIGQTY |
DECIMAL(9)19,4 |
The original quantity ordered on the purchase order. |
DBLNEWQTY |
DECIMAL(9)19,4 |
The new quantity that should be ordered. |
DBLFRQTY |
DECIMAL(9)19,4 |
The number of units that will be transferred to the location ordering this item. |
YSNCHANGED |
VARCHAR(1) |
'T' if the record has been changed. |
DBLRATEOFSALE |
DECIMAL(9)19,4 |
The rate of sale of the item at the location making the order. |
Primary Key: LINTITEMNUMBER + STRSTORECODE + LINTPONUMBER + LINTLINENUMBER
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |