Home > Technical > Table Definitions > POREVIEWORIG

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

LINTITEMNUMBER

INT(4)

IPN of the item being ordered.

ITEM.lintItemNumber

STRSTORECODE

VARCHAR(10)

The location the item was ordered for.

TRADUNIT.strTradeCode

LINTPONUMBER

INT(4)

The number of the purchase order this item was ordered on.

PODETAIL.lintPONumber

LINTLINENUMBER

INT(4)

The line number of the item within the purchase order.

PODETAIL.lintLineNumber

STRSUPPLIERCODE

VARCHAR(10)

The code of the supplier, this item was ordered from.

SUPPLIER.strSupplierCode

STRMANUFACTURER

VARCHAR(10)

The code of the manufacturer, this item was ordered from.

SUPPLIER.strSupplierCode

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)