Home > Technical > Table Definitions > CUSTOMERLOCATIONSUMMARY
Detail information about customer sales are stored in MEMBERSALES. However, this can quickly build up into a large amount of data that becomes difficult to analyse. A weekly process can be run that summaries the data into CUSTOMERLOCATIONSUMMARY and CUSTOMERSUMMARY. The CUSTOMERLOCATIONSUMMARY summarises data to the location.
Column |
Type |
Description |
STRYEARWEEK |
VARCHAR(7) |
The period the statistics belong to. |
STRSTORECODE |
VARCHAR(10) |
The location the statistics belong to. |
INTNEWMEMBERS |
INT(4) |
The number of new members. |
INTACTIVE |
INT(4) |
The number of members who are considered active (purchased something in the last thirteen periods). |
INTINACTIVE |
INT(4) |
The number of members who are considered inactive (did not purchase something in the last thirteen periods). |
INTREACTIVE |
INT(4) |
The number of members who were inactive last week, but purchased something this week. |
INTMEMBERTRANS |
INT(4) |
The number of sales to members. |
DBLMEMBERQTY |
DECIMAL9(19,4) |
The quantity of items sold to members. |
CURMEMBERSALES |
DECIMAL9(19,4) |
The value of sales to members. |
CURMEMBERCOGS |
DECIMAL9(19,4) |
The value of COGS to members. |
INTMEMBERVISITS |
INT(4) |
The number of visits made by members. There are two methods that can be used: 1. Every sale made to one member counts as a visit. 2. Any number of sales to one member on one trading day counts as a visit. |
INTMEMBERTRANS1 |
INT(4) |
The number of sales to members on Day 1 of the week. |
DBLMEMBERQTY1 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 1 of the week. |
CURMEMBERSALES1 |
DECIMAL9(19,4) |
The value of sales to members on Day 1 of the week. |
CURMEMBERCOGS1 |
DECIMAL9(19,4) |
The value of COGS to members on Day 1 of the week. |
INTMEMBERVISITS1 |
INT(4) |
The number of visits made by members on Day 1 of the week. |
INTMEMBERTRANS2 |
INT(4) |
The number of sales to members on Day 2 of the week. |
DBLMEMBERQTY2 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 2 of the week. |
CURMEMBERSALES2 |
DECIMAL9(19,4) |
The value of sales to members on Day 2 of the week. |
CURMEMBERCOGS2 |
DECIMAL9(19,4) |
The value of COGS to members on Day 2 of the week. |
INTMEMBERVISITS2 |
INT(4) |
The number of visits made by members on Day 2 of the week. |
INTMEMBERTRANS3 |
INT(4) |
The number of sales to members on Day 3 of the week. |
DBLMEMBERQTY3 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 3 of the week. |
CURMEMBERSALES3 |
DECIMAL9(19,4) |
The value of sales to members on Day 3 of the week. |
CURMEMBERCOGS3 |
DECIMAL9(19,4) |
The value of COGS to members on Day 3 of the week. |
INTMEMBERVISITS3 |
INT(4) |
The number of visits made by members on Day 3 of the week. |
INTMEMBERTRANS4 |
INT(4) |
The number of sales to members on Day 4 of the week. |
DBLMEMBERQTY4 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 4 of the week. |
CURMEMBERSALES4 |
DECIMAL9(19,4) |
The value of sales to members on Day 4 of the week. |
CURMEMBERCOGS4 |
DECIMAL9(19,4) |
The value of COGS to members on Day 4 of the week. |
INTMEMBERVISITS4 |
INT(4) |
The number of visits made by members on Day 4 of the week. |
INTMEMBERTRANS5 |
INT(4) |
The number of sales to members on Day 5 of the week. |
DBLMEMBERQTY5 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 5 of the week. |
CURMEMBERSALES5 |
DECIMAL9(19,4) |
The value of sales to members on Day 5 of the week. |
CURMEMBERCOGS5 |
DECIMAL9(19,4) |
The value of COGS to members on Day 5 of the week. |
INTMEMBERVISITS5 |
INT(4) |
The number of visits made by members on Day 5 of the week. |
INTMEMBERTRANS6 |
INT(4) |
The number of sales to members on Day 6 of the week. |
DBLMEMBERQTY6 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 6 of the week. |
CURMEMBERSALES6 |
DECIMAL9(19,4) |
The value of sales to members on Day 6 of the week. |
CURMEMBERCOGS6 |
DECIMAL9(19,4) |
The value of COGS to members on Day 6 of the week. |
INTMEMBERVISITS6 |
INT(4) |
The number of visits made by members on Day 6 of the week. |
INTMEMBERTRANS7 |
INT(4) |
The number of sales to members on Day 7 of the week. |
DBLMEMBERQTY7 |
DECIMAL9(19,4) |
The quantity of items sold to members on Day 7 of the week. |
CURMEMBERSALES7 |
DECIMAL9(19,4) |
The value of sales to members on Day 7 of the week. |
CURMEMBERCOGS7 |
DECIMAL9(19,4) |
The value of COGS to members on Day 7 of the week. |
INTMEMBERVISITS7 |
INT(4) |
The number of visits made by members on Day 7 of the week. |
INTNONMEMBERTRANS |
INT(4) |
The number of sales to non-members. |
DBLNONMEMBERQTY |
DECIMAL9(19,4) |
The quantity of items sold to non-members. |
CURNONMEMBERSALES |
DECIMAL9(19,4) |
The value of sales to non-members. |
CURNONMEMBERCOGS |
DECIMAL9(19,4) |
The value of COGS to non-members. |
INTNONMEMBERVISITS |
INT(4) |
The number of visits made by non-members. |
INTNONMEMBERTRANS1 |
INT(4) |
The number of sales to non-members on Day 1 of the week. |
DBLNONMEMBERQTY1 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 1 of the week. |
CURNONMEMBERSALES1 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 1 of the week. |
CURNONMEMBERCOGS1 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 1 of the week. |
INTNONMEMBERVISITS1 |
INT(4) |
The number of visits made by non-members on Day 1 of the week. |
INTNONMEMBERTRANS2 |
INT(4) |
The number of sales to non-members on Day 2 of the week. |
DBLNONMEMBERQTY2 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 2 of the week. |
CURNONMEMBERSALES2 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 2 of the week. |
CURNONMEMBERCOGS2 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 2 of the week. |
INTNONMEMBERVISITS2 |
INT(4) |
The number of visits made by non-members on Day 2 of the week. |
INTNONMEMBERTRANS3 |
INT(4) |
The number of sales to non-members on Day 3 of the week. |
DBLNONMEMBERQTY3 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 3 of the week. |
CURNONMEMBERSALES3 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 3 of the week. |
CURNONMEMBERCOGS3 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 3 of the week. |
INTNONMEMBERVISITS3 |
INT(4) |
The number of visits made by non-members on Day 3 of the week. |
INTNONMEMBERTRANS4 |
INT(4) |
The number of sales to non-members on Day 4 of the week. |
DBLNONMEMBERQTY4 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 4 of the week. |
CURNONMEMBERSALES4 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 4 of the week. |
CURNONMEMBERCOGS4 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 4 of the week. |
INTNONMEMBERVISITS4 |
INT(4) |
The number of visits made by non-members on Day 4 of the week. |
INTNONMEMBERTRANS5 |
INT(4) |
The number of sales to non-members on Day 5 of the week. |
DBLNONMEMBERQTY5 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 5 of the week. |
CURNONMEMBERSALES5 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 5 of the week. |
CURNONMEMBERCOGS5 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 5 of the week. |
INTNONMEMBERVISITS5 |
INT(4) |
The number of visits made by non-members on Day 5 of the week. |
INTNONMEMBERTRANS6 |
INT(4) |
The number of sales to non-members on Day 6 of the week. |
DBLNONMEMBERQTY6 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 6 of the week. |
CURNONMEMBERSALES6 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 6 of the week. |
CURNONMEMBERCOGS6 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 6 of the week. |
INTNONMEMBERVISITS6 |
INT(4) |
The number of visits made by non-members on Day 6 of the week. |
INTNONMEMBERTRANS7 |
INT(4) |
The number of sales to non-members on Day 7 of the week. |
DBLNONMEMBERQTY7 |
DECIMAL9(19,4) |
The quantity of items sold to non-members on Day 7 of the week. |
CURNONMEMBERSALES7 |
DECIMAL9(19,4) |
The value of sales to non-members on Day 7 of the week. |
CURNONMEMBERCOGS7 |
DECIMAL9(19,4) |
The value of COGS to non-members on Day 7 of the week. |
INTNONMEMBERVISITS7 |
INT(4) |
The number of visits made by non-members on Day 7 of the week. |
Primary Key: STRYEARWEEK + STRSTORECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |