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)