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)