Customers | Tekso käyttöohje

Column	Format	Contents
LUONTIPVM	Varchar(10) (yyyy-mm-dd)	Date created.
VIIMOSTOPVM	Varchar(10) (yyyy-mm-dd)	Last purchased.
ASI_BONUS_ALKU_1	Varchar(10) (yyyy-mm-dd)	Bonus program 1 start date.
ASI_BONUS_ALKU_2	Varchar(10) (yyyy-mm-dd)	Bonus program 2 start date.
ASI_BONUS_EXTRA_1	Decimal(9,2)	Bonus program 1 extra bonus amount field.
ASI_BONUS_KRT_1	Smallint	Bonus program 1 counter.
ASI_BONUS_KRT_2	Smallint	Bonus program 2 counter.
ASI_BONUS_OSTOT_1	Decimal(9,2)	Bonus program 1 bought amount.
ASI_BONUS_OSTOT_2	Decimal(9,2)	Bonus program 2 bought amount.
ASI_BONUS_VOIM_1	Varchar(10)	Bonus program 1 bonus valid date.
ASI_BONUS_VOIM_2	Varchar(10)	Bonus program 2 bonus valid date.
ASIAKASNIMI	Varchar(30)	Last name or whole name.
ASIAKASNUM	Int	Customer number (ID).
BASIAKASNUM	Int	If customer bonus is linked to another person.
EMAIL	Varchar(60)	Email address.
GSMNRO	Varchar(20)	Mobile phone number.
MAA	Varchar(20)	Customer country; if empty then “Suomi”.
POSTINRO	Varchar(10)	Post address postal code.
POSTIOSOITE	Varchar(30)	Post address.
POSTITOIMP	Varchar(30)	Post address city.
POSTITUS	Int	Values for POSTITUS field (Marketing permission): 0 = Post 1 = No permission 2 = Post, email 3 = Email 4 = Post, phone 5 = Phone 6 = Post, phone, email 7 = Phone, email
PUHELIN	Varchar(20)	Phone number.
RYHMA	Varchar(6)	Customer group.
SYNTYMAPVM	Varchar(10) (yyyy-mm-dd)	Birth date.
TOIMITUSOSOITE	Varchar(30)	Delivery address.
TOIMOS_POSTINRO	Varchar(10)	Delivery address postal code.
TOIMOS_POSTITOIMP	Varchar(30)	Delivery address city.
TYYPPI	Varchar(4)	Possible values: LA = Invoice customer LA0 = Invoice customer VAT 0 (no tax) LAT = Wholesale customer LA0T = Wholesale customer VAT 0 KA = Cash customer TA = Account customer TH = Staff VA = VIP OA = Part payment customer SA = Fitting customer MA = General customer
TYYPPI2	Varchar(2)	Possible values: N = Woman M = Man Y = Company X = Temporary customer S = Other gender
Modified	Datetime	Last modified date.
Token	Varchar(13)	Customer identifier token. Contains postal code + Mobile phone number + Phone number.
MYYMALA	Smallint	Store number.

Example Data

Query

SQL

SELECT TOP 5 *
  FROM dbo.Customers

Result

^LUONTIPVM	^VIIMOSTOPVM	^{ASI_BONUS_ALKU_1}	^{ASI_BONUS_ALKU_2}	^{ASI_BONUS_EXTRA_1}	^{ASI_BONUS_KRT_1}	^{ASI_BONUS_KRT_2}	^{ASI_BONUS_OSTOT_1}	^{ASI_BONUS_OSTOT_2}	^{ASI_BONUS_VOIM_1}	^{ASI_BONUS_VOIM_2}	^ASIAKASNIMI	^ASIAKASNUM	^BASIAKASNUM	^EMAIL	^GSMNRO	^MAA	^POSTINRO	^POSTIOSOITE	^POSTITOIMP	^POSTITUS	^PUHELIN	^RYHMA	^SYNTYMAPVM	^{TOIMITUSOSOITE}	^{TOIMOS_POSTINRO}	^{TOIMOS_POSTITOIMP}	^TYYPPI	^Modified	^Token	^MYYMALA
^2012-09-27	^2023-02-13	^2012-09-27	^NULL	^0.00	⁰	⁰	^0.00	^0.00	^2012-09-27	^NULL	^{SOVITUSASIAKAS}	¹⁰²⁷	^NULL	^NULL	^NULL	^Suomi	^NULL	^NULL	^NULL	⁰	^NULL	^NULL	^NULL	^NULL	^NULL	^NULL	^SA	^{2023-02-13 11:01:01.000}	^NULL	⁰
^2018-05-31	^NULL	^2018-05-31	^NULL	^0.00	⁰	⁰	^0.00	^0.00	^2018-05-31	^NULL	^TESTI	¹⁰³⁰	^NULL	^NULL	^NULL	^Suomi	¹²³⁴⁵	^{tttie 10}	^testi	⁰	^NULL	^NULL	^NULL	^NULL	^NULL	^NULL	^KA	^{2018-05-31 11:30:51.000}	^NULL	⁰
^2018-05-31	^NULL	^2018-05-31	^NULL	^0.00	⁰	⁰	^0.00	^0.00	^2018-05-31	^NULL	^TEST2	¹⁰³¹	^NULL	^NULL	^NULL	^Suomi	¹²³⁴⁵	^123TEST	^TEWT	⁰	^NULL	^NULL	^NULL	^NULL	^NULL	^NULL	^KA	^{2018-05-31 11:32:20.000}	^NULL	⁰
^2018-10-19	^NULL	^2018-10-19	^NULL	^0.00	⁰	⁰	^0.00	^0.00	^2018-10-19	^NULL	^TESTAAJA	¹⁰³²	^NULL	^NULL	^NULL	^Suomi	^NULL	^NULL	^NULL	²	^NULL	^NULL	^NULL	^NULL	^NULL	^NULL	^KA	^{2018-10-19 00:00:00.000}	^NULL	⁰
^2022-12-13	^2023-01-25	^2022-12-13	^NULL	^0.00	⁰	⁰	^0.00	^0.00	^2022-12-13	^NULL	^{LASKUTUSASIAKAS}	¹⁰³³	^NULL	^NULL	^NULL	^Suomi	^NULL	^NULL	^NULL	⁰	^NULL	^NULL	^NULL	^NULL	^NULL	^NULL	^LA0	^{2023-01-25 11:10:01.000}	^NULL	⁰