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) |
