Home > Technical > Table Definitions > ALLOCPOITEM

ALLOCPOITEM

Not currently used.

See ALLOCPOSUPP for an explanation about this table.

Column

Type

Description

LINTALLOCCODE

INT

The code of the allocation this record belongs to.

ALLOCPOSUPP.lintAllocCode

STRSUPPLIERCODE

VARCHAR(10)

The supplier that this record is for.

ALLOCPOSUPP.strSupplierCode

CTRCODE

INT

A unique number to identify the record. Assigned by the system.

STRORDERCODE

VARCHAR(20)

The supplier’s order code for the item.

LINTITEMNUMBER

INT

The number of the item to be purchased.

ITEM.lintItemNumber

DBLQUANTITY

DECIMAL(19,4)

The total quantity to be ordered.

 

Primary Key: LINTALLOCCODE+STRSUPPLIERCODE+CTRCODE

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