Home > Technical > Table Definitions > TRADALTSTOCK

TRADALTSTOCK

Normally when stock is sold at a location, it is decremented from the stock on hand of that location. This table allows redirections to be set up. For example, you have two bar locations but they share the same beer kegs. You can set up records so that when items are sold from the beer kegs it will decrement the stock one location only.

Column

Type

Description

STRTRADECODE

VARCHAR(10)

The trading unit this rule is for.
TRADUNIT.strTradeCode

STRGUID

VARCHAR(38)

A unique code assigned by the system.

STRDEPTCODE

VARCHAR(10)

Items in this department will have their stock decremented from strAltTradeCode
DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

Items in this category will have their stock decremented from strAltTradeCode
CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

Items in this group will have their stock decremented from strAltTradeCode
GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

Items in this subgroup will have their stock decremented from strAltTradeCode
SUBGROUP.strSubGroupCode

STRCLASSCODE

VARCHAR(10)

Items in this classification will have their stock decremented from strAltTradeCode
CLASS.strClassCode

LINTITEMNUMBER

INT

Items with this item number will have their stock decremented from strAltTradeCode
ITEM.lintItemNumber

STRALTTRADECODE

VARCHAR(10)

The location from which stock will actually be decremented.

TRADUNIT.strTradeCode

 

Primary Key: STRTRADECODE + STRGUID

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