Home > Technical > Table Definitions > POREVIEWREPDTL

POREVIEWREPDTL

This is part of the purchase order review process which uses the table POREVIEWORIG, POREVIEWITEM, POREVIEWREPDTL, POREVIEWOTHER and POREVIEWTFR. This table stores details used to print the reviewed purchase orders.

Column

Type

Description

LINTPOCODE

INT(4)

A unique purchase order number assigned by the system.

CTRCODE

INT(4)

A unique number assigned by the system.

LINTPONUMBER

INT(4)

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

PODETAIL.lintPONumber

LINTLINENUMBER

INT(4)

The line number of the item within the original purchase order.

PODETAIL.lintLineNumber

LINTITEMNUMBER

INT(4)

IPN of the item.

ITEM.lintItemNumber

STRSUPPLIERCODE

VARCHAR(10)

The code of the supplier this item is being ordered from.

SUPPLIER.strSupplierCode

STRMANUFACTURER

VARCHAR(10)

The code of the manufacturer this item is being ordered from.

SUPPLIER.strSupplierCode

DBLQUANTITY

DECIMAL(9)19,4

The number of units to order.

DBLCARTONS

DECIMAL(9)19,4

The number of cartons to order.

CURCOST

DECIMAL(9)19,4

The carton cost of the item.

CURLINECOST

DECIMAL(9)19,4

The line cost (total cost) of the item.

CURUNITCOST

DECIMAL(9)19,4

Cost of a single unit.

STRDESCRIPTION

VARCHAR(100)

Description of the item.

INTCARTONSIZE

DECIMAL(5)9,3

The carton size of the item.

DBLBONUS

DECIMAL(9)19,4

The number of bonus units expected.

MEMCOMMENT

VARCHAR(2000)

The comment from the original purchase order.

STRORDERCODE

VARCHAR(20)

The supplier's order code for this item.

 

Primary Key: LINTPOCODE + LINTITEMNUMBER + LINTPONUMBER + LINTLINENUMBER

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