Home > Technical > Table Definitions > CUSTOMEREXPORTFILTER

CUSTOMEREXPORTFILTER

CUSTOMEREXPORTFILTER is part of the customer export members functionality and is used to store details of export filters that have been defined for the system.

Column

Type

Description

STRCODE

VARCHAR(10)

The unique filter code.

STRDESCRIPTION

VARCHAR(50)

The description of the filter.

STRLASTNAMEFROM

VARCHAR(50)

The members last name 'from' range applied to the filter.

STRLASTNAMETO

VARCHAR(50)

The members last name 'to' range applied to the filter.

DBLPOINTSFROM

DECIMAL(19,4)

The members account points 'from' range applied to the filter.

DBLPOINTSTO

DECIMAL(19,4)

The members account points 'to' range applied to the filter.

DTMLASTVISITFROM

DATETIME

The members last visit date 'from' range applied to the filter.

DTMLASTVISITTO

DATETIME

The members last visit date 'to' range applied to the filter.

DTMVISITEDFROM

DATETIME

The members transaction sales trade date 'from' range applied to the filter
DAILYSALES.dtmTradeDate

DTMVISITEDTO

DATETIME

The members transaction sales trade date 'to' range applied to the filter
DAILYSALES.dtmTradeDate

DTMDOBFROM

DATETIME

The members date of birth 'from' range filtered by the database server.

DTMDOBTO

DATETIME

The members date of birth 'to' range filtered by the database server.

DTMBIRTHDAYFROM

DATETIME

The members date of birth 'from' range filtered programmatically.

DTMBIRTHDAYTO

DATETIME

The members date of birth 'to' range filtered programmatically.

STRPOSTCODEFROM

VARCHAR(15)

The members post code 'from' range applied to the filter.

STRPOSTCODETO

VARCHAR(15)

The members post code 'to' range applied to the filter.

DTMCREATEDFROM

DATETIME

The date the member was added 'from' range applied to the filter.

DTMCREATEDTO

DATETIME

The date the member was added 'to' range applied to the filter.

STRCARDNUMFROM

VARCHAR(38)

The members card number 'from' range applied to the filter.

STRCARDNUMTO

VARCHAR(38)

The members card number 'to' range applied to the filter.

DTMCARDEXPIRESFROM

DATETIME

The card expiry date 'from' range applied to the filter.

DTMCARDEXPIRESTO

DATETIME

The card expiry date 'to' range applied to the filter.

DBLTRANSACTIONVALUEFROM

DECIMAL(19,4)

Daily sales transaction value 'from' range applied to the filter.

DBLTRANSACTIONVALUETO

DECIMAL(19,4)

Daily sales transaction value 'to' range applied to the filter.

STRSALESFROM

VARCHAR(10)

Daily sales date 'from' range applied to the filter - expressed as YYYY.WW where YYYY is the year and WW is the week number for example 2009.42.

STRSALESTO

VARCHAR(10)

Daily sales date 'to' range applied to the filter - expressed as YYYY.WW where YYYY is the year and WW is the week number for example 2009.42.

STRTRADECODE

VARCHAR(10)

The location
TRADUNIT.strTradeCode

LINTFILTERORDER

INTEGER

The sort order to be applied to the export:
0 - Postcode, Name
1 - Postal Postcode, Name
2 - Name
3 - Sales (High to Low)
4 - Avg Sales (High to Low)
5 - Expired Date

LINTMAXIMUMMEMBERS

INTEGER

The maximum number of members to export.

STREXPORTFILE

VARCHAR(500)

The export file path and filename.

STRCATEGORY1

VARCHAR(10)

The customer type category. There are five categories that may be applied to a member.
CUSTOMERCATEGORY.strCode

STRCATEGORY2

VARCHAR(10)

 

STRCATEGORY3

VARCHAR(10)

 

STRCATEGORY4

VARCHAR(10)

 

STRCATEGORY5

VARCHAR(10)

 

STRDAYSOFWEEK

VARCHAR(7)

The day(s) of the week the member visited to be applied to the filter - expressed as a string consisting of Y or N, where Y indicates the day is checked. Starting day is Monday, therefore the string YNNNNNY indicates Monday and Sunday are checked.

STRDEPTCODE

VARCHAR(10)

The department code to be applied to the member item filter.
DEPT.strDeptCode

STRCATCODE

VARCHAR(10)

The category code to be applied to the member item filter.
CATEGORY.strCatCode

STRGROUPCODE

VARCHAR(10)

The group code to be applied to the member item filter.
GROUPS.strGroupCode

STRSUBGROUPCODE

VARCHAR(10)

The sub-group code to be applied to the member item filter.
SUBGROUP.strSubGroupCode

MEMITEM

TEXT

Comma delimited list of item IPN's to be applied to the member item filter.
ITEM.lintItemNumber

STRPRODUCTBRANDNAME

VARCHAR(30)

The product brand name to be applied to the member item filter.

STRORDERCATCODE

VARCHAR(10)

The order category code to be applied to the member item filter.
CATEGORY.strCatCode

STRFAMILYCODE

VARCHAR(10)

The family code to be applied to the member item filter.
FAMILY.strFamilyCode

STRSEASONCODE

VARCHAR(10)

The season code to be applied to the member item filter.
VALIDDESC.strDescription

STRYEARCODE

VARCHAR(4)

The season year to be applied to the member item filter.

STRCLASSCODE

VARCHAR(10)

The classification code to be applied to the member item filter.
CLASS.strClassCode

LINTPROMOCODE

INTEGER

The item promotion code to be applied to the member item filter.
PROMOITEM.lintPromoCode

 

Primary Key: STRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)