Home > Technical > Table Definitions > ALLOCITEM

ALLOCITEM

Not currently used.

An allocation consists of a header record to group the allocation details together (ALLOCHEADER), at least one record for each item to be allocated (ALLOCITEM) and at least one record showing how an item is allocated to various locations (ALLOCDETAIL).

Column

Type

Description

LINTALLOCCODE

INT

The code of the allocation this item belongs to.

ALLOCHEADER.ctrCode

CTRCODE

INT

A unique code identifying the allocation. Assigned by the system.

LINTITEMNUMBER

INT

The number of the item to be allocated.

ITEM.lintItemNumber

STRTRADECODE

VARCHAR(10)

The location the item is to be allocated. This can be a group code. When the system generates allocation details for this item, an ALLOCDETAIL record will be created for each store/warehouse in this location.

TRADUNIT.strTradeCode

STRREVIEWFROMPERIOD

VARCHAR(7)

When performing an allocation, the system checks sales within a nominated period range. This is the first period of the range.

STATSPER.strYearWeek

STRREVIEWTOPERIOD

VARCHAR(7)

When performing an allocation, the system checks sales within a nominated period range. This is the last period of the range.

STATSPER.strYearWeek

INTREVIEWWEEKS

INT

The number of periods between strReviewToPeriod and strReviewFromPeriod.

STRSTOCKTRADECODE

VARCHAR(10)

The location stock is to be allocated from. When the allocation is for an order, the stock will be delivered to this location. When the allocation is for distribution purposes, the stock will be sourced from this location.

TRADUNIT.strTradeCode

DBLMAXIMUMSTOCKCOVER

DECIMAL(19,4)

Stockcover is the amount of stock required to cover x number of weeks based on the current sales rate. We know the rate of sale, this number is x, so we can calculate the amount of stock required.

YSNNEEDREFRESH

VARCHAR(1)

An internal flag which is set to ‘T’ when any of the above fields are changed. The system then knows that the allocation details need to be refreshed. If there are no changes the flag is ‘F’.

DBLSTOCKONHAND

DECIMAL(19,4)

The stock on hand for strStockTradeCode.

DBLORDEREDQTY

DECIMAL(19,4)

The units on order for strStockTradeCode.

YSNREFRESHMAXCOVER

VARCHAR(1)

'T' if the user has changed the dblMaximumStockCover. The flag is used to optimise recalculation of details.

YSNREFRESHOTHER

VARCHAR(1)

'T' if the user has changed any other details about the item. This is used to determine whether details need to be recalculated.

YSNDISTRIBUTEOK

VARCHAR(1)

If this is a Distribution allocation then the user cannot distribute more stock than is available. If the distribution is OK this flag will be 'T'. If the user tries to distribute more stock than is available it will be 'F'.

DBLORIGALLOCATEDUNITS

DECIMAL(19,4)

No longer used.

DBLDISTSTOCKONHAND

DECIMAL(19,4)

The stock on hand at the location from which stock is being distributed.

 

Primary Key: LINTALLOCCODE+CTRCODE

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