Home > Technical > Table Definitions > CUSTOMERLOCATIONSUMMARY

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.

STATSPER.strYearWeek

STRSTORECODE

VARCHAR(10)

The location the statistics belong to.

TRADUNIT.strTradeCode

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)