Home > Technical > Table Definitions > TRADSTOR

TRADSTOR

All locations recorded in TRADUNIT (except competition stores) have stores associated with them. A store group will have multiple stores, whereas a single store will have only one, itself. This table contains the stores within a trading unit.

Column	Type	Description
STRTRADEGROUP	VARCHAR(10)	The trading unit this store is for. TRADUNIT.strTradeCode
STRTRADEUNIT	VARCHAR(10)	The store which belongs in strTradeGroup. TRADUNIT.strTradeCode
STRSTATSTYPE	VARCHAR(15)	This can be used to indicate that the group/unit is of a certain type, for example a Region or a State. This can be used to group statistics by the statistics type instead of specific stores. TRADCODE.strText (where strType='S')

Primary Key: STRTRADEGROUP + STRTRADEUNIT

Example:

The location QLD has two stores BRIS and GOLDC. These would be set up as :

strTradeGroup	strTradeUnit
QLD	BRIS
QLD	GOLDC

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