Home > Technical > Table Definitions > ALLOCCOMPARE

ALLOCCOMPARE

Not currently used.

This table is used within the allocation system. The user will nominate an item to be allocated. This is stored in ALLOCITEM. When the allocation details are generated by the system, it needs to extract the sales history for the item. However, the user may want to nominate a number of similar items that can be used for comparison purposes. This table contains those comparison items. The allocation program will automatically create one record in table corresponding to the item to be allocated. The user can add additional items as required.

Column

Type

Description

LINTALLOCCODE

INT

The code of the allocation this record belongs to.

ALLOCITEM.lintAllocCode

LINTALLOCITEMCODE

INT

The code of the item within the allocation that this record belongs to.

ALLOCITEM.ctrCode

LINTCOMPAREIPN

INT

The number of the comparison item to be used by the system when extracting sales history.

ITEM.lintItemNumber

DBLSTOCKONHAND

DECIMAL(19,4)

Not currently used.

CURLANDEDCOST

DECIMAL(19,4)

Not currently used.

INTCARTONSIZE

DECIMAL(9,3)

Not currently used.

DBLRATEOFSALE

DECIMAL(19,4)

Not currently used.

DBLSTOCKCOVER

DECIMAL(19,4)

Not currently used.

 

Primary Key: LINTALLOCCODE+LINTALLOCITEMCODE+LINTCOMPAREIPN

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