Home > Technical > Table Definitions > POREVIEWTFR

POREVIEWTFR

This is part of the purchase order review process which uses the table POREVIEWORIG, POREVIEWITEM, POREVIEWREPDTL, POREVIEWOTHER and POREVIEWTFR. This table stores details about how items will be transferred from one location to another.

Column

Type

Description

LINTITEMNUMBER

INT(4)

IPN of the item being transferred.

POREVIEWORIG.lintItemNumber

STRSTORECODE

VARCHAR(10)

The location the item was ordered from and is being transferred to.

POREVIEWORIG.strStoreCode

LINTPONUMBER

INT(4)

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

POREVIEWORIG.lintPONumber

LINTLINENUMBER

INT(4)

The line number of the item within the purchase order.

POREVIEWORIG.lintLineNumber

STRFROMSTORE

VARCHAR(5)

The location from which the stock is being transferred.

POREVIEWOTHER.strStoreCode

DBLQTY

DECIMAL(9)19,4

The number of units to be transferred.

 

Primary Key: LINTITEMNUMBER + LINTPONUMBER + LINTLINENUMBER + STRSTORECODE + STRFROMSTORE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)