Home > Technical > Table Definitions > CUSTOMERSUMMARY
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 CUSTOMERSUMMARY summarises data to the customer.
Column |
Type |
Description |
STRYEARWEEK |
VARCHAR(7) |
The period the statistics belong to. |
LINTCUSTOMERNUM |
INT(4) |
The customer these statistics belong to. |
STRHOMELOCATION |
VARCHAR(10) |
The location the customer was originally created at. |
STRACTIVITYLOCATION |
VARCHAR(10) |
The location the sales actually occurred. |
INTQUINTILE |
INT(4) |
A customer can be assigned to one of five quintiles. Quintile 1 contains the customers with the highest sales over the last thirteen weeks. Quintile 5 contains the customers with the lowest sales over the last thirteen weeks. |
INTDECILE |
INT(4) |
A customer can be assigned to one of ten deciles. Decile 1 contains the customers with the highest sales over the last thirteen weeks. Decile 10 contains the customers with the lowest sales over the last thirteen weeks. |
STRCATEGORY1 |
VARCHAR(10) |
The strCategory1 code assigned to the customer. |
STRCATEGORY2 |
VARCHAR(10) |
The strCategory2 code assigned to the customer. |
STRCATEGORY3 |
VARCHAR(10) |
The strCategory3 code assigned to the customer. |
STRCATEGORY4 |
VARCHAR(10) |
The strCategory4 code assigned to the customer. |
STRCATEGORY5 |
VARCHAR(10) |
The strCategory5 code assigned to the customer. |
STRACTIVEFLAG |
VARCHAR(1) |
I = InactiveA= Active |
INTTRANS |
INT(4) |
The number of sales made to this customer for the period. |
DBLQTY |
DECIMAL9(19,4) |
The quantity of items sold to the customer. |
CURSALES |
DECIMAL9(19,4) |
The value of sales to the customer. |
CURCOGS |
DECIMAL9(19,4) |
The COGS to the customer. |
INTVISITS |
INT(4) |
The number of visits made by customer. There are two methods that can be used: 1.Every sale made to one customer counts as a visit. 2.Any number of sales to one customer on one trading day counts as a visit. |
INTTRANS1 |
INT(4) |
The number of sales made to this customer on Day 1 of the week. |
DBLQTY1 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 1 of the week. |
CURSALES1 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 1 of the week. |
CURCOGS1 |
DECIMAL9(19,4) |
The COGS to the customer on Day 1 of the week. |
INTVISITS1 |
INT(4) |
The number of visits made by customer on Day 1 of the week. |
INTTRANS2 |
INT(4) |
The number of sales made to this customer on Day 2 of the week. |
DBLQTY2 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 2 of the week. |
CURSALES2 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 2 of the week. |
CURCOGS2 |
DECIMAL9(19,4) |
The COGS to the customer on Day 2 of the week. |
INTVISITS2 |
INT(4) |
The number of visits made by customer on Day 2 of the week. |
INTTRANS3 |
INT(4) |
The number of sales made to this customer on Day 3 of the week. |
DBLQTY3 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 3 of the week. |
CURSALES3 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 3 of the week. |
CURCOGS3 |
DECIMAL9(19,4 |
The COGS to the customer on Day 3 of the week. |
INTVISITS3 |
INT(4) |
The number of visits made by customer on Day 3 of the week. |
INTTRANS4 |
INT(4) |
The number of sales made to this customer on Day 4 of the week. |
DBLQTY4 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 4 of the week. |
CURSALES4 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 4 of the week. |
CURCOGS4 |
DECIMAL9(19,4) |
The COGS to the customer on Day 4 of the week. |
INTVISITS4 |
INT(4) |
The number of visits made by customer on Day 4 of the week. |
INTTRANS5 |
INT(4) |
The number of sales made to this customer on Day 5 of the week. |
DBLQTY5 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 5 of the week. |
CURSALES5 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 5 of the week. |
CURCOGS5 |
DECIMAL9(19,4) |
The COGS to the customer on Day 5 of the week. |
INTVISITS5 |
INT(4) |
The number of visits made by customer on Day 5 of the week. |
INTTRANS6 |
INT(4) |
The number of sales made to this customer on Day 6 of the week. |
DBLQTY6 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 6 of the week. |
CURSALES6 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 6 of the week. |
CURCOGS6 |
DECIMAL9(19,4) |
The COGS to the customer on Day 6 of the week. |
INTVISITS6 |
INT(4) |
The number of visits made by customer on Day 6 of the week. |
INTTRANS7 |
INT(4) |
The number of sales made to this customer on Day 5 of the week. |
DBLQTY7 |
DECIMAL9(19,4) |
The quantity of items sold to the customer on Day 7 of the week. |
CURSALES7 |
DECIMAL9(19,4) |
The value of sales to the customer on Day 7 of the week. |
CURCOGS7 |
DECIMAL9(19,4) |
The COGS to the customer on Day 7 of the week. |
INTVISITS7 |
INT(4) |
The number of visits made by customer on Day 7 of the week. |
INTQUARTERTRANS |
INT(4) |
The number of sales made to this customer during the last thirteen weeks. |
DBLQUARTERQTY |
DECIMAL9(19,4) |
The quantity of items sold to the customer during the last thirteen weeks. |
CURQUARTERSALES |
DECIMAL9(19,4) |
The value of sales to the customer during the last thirteen weeks. |
CURQUARTERCOGS |
DECIMAL9(19,4) |
The COGS to the customer during the last thirteen weeks. |
INTQUARTERVISITS |
INT(4) |
The number of visits made by customer during the last thirteen weeks. |
Primary Key: STRYEARWEEK + LINTCUSTOMERNUM
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |