Home > Technical > Table Definitions > 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. |
LINTALLOCITEMCODE |
INT |
The code of the item within the allocation that this record belongs to. |
LINTCOMPAREIPN |
INT |
The number of the comparison item to be used by the system when extracting sales history. |
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) |