Home > Technical > Table Definitions > 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. |
STRGUID |
VARCHAR(38) |
A unique code assigned by the system. |
STRDEPTCODE |
VARCHAR(10) |
Items in this department will have their stock decremented from
strAltTradeCode |
STRCATCODE |
VARCHAR(10) |
Items in this category will have their stock decremented from
strAltTradeCode |
STRGROUPCODE |
VARCHAR(10) |
Items in this group will have their stock decremented from
strAltTradeCode |
STRSUBGROUPCODE |
VARCHAR(10) |
Items in this subgroup will have their stock decremented from
strAltTradeCode |
STRCLASSCODE |
VARCHAR(10) |
Items in this classification will have their stock decremented
from strAltTradeCode |
LINTITEMNUMBER |
INT |
Items with this item number will have their stock decremented
from strAltTradeCode |
VARCHAR(10) |
The location from which stock will actually be decremented. |
Primary Key: STRTRADECODE + STRGUID
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |