Home > Technical > Table Definitions > CUSTOMERSUMMARY

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.

STATSPER.strYearWeek

LINTCUSTOMERNUM

INT(4)

The customer these statistics belong to.

CUSTOMER.lintCustomerNum

STRHOMELOCATION

VARCHAR(10)

The location the customer was originally created at.

TRADUNIT.strTradeCode

STRACTIVITYLOCATION

VARCHAR(10)

The location the sales actually occurred.

TRADUNIT.strTradeCode

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)