|
Column |
Format |
Unique value |
Contents |
|---|---|---|---|
|
Id |
Smallint |
|
Salesperson ID. |
|
Name |
Varchar(30) |
|
Salesperson name. |
|
ShortName |
Varchar(30) |
|
Salesperson short name (in the receipt). If empty, contains the salesperson’s full name. |
|
ExternalID |
Char(10) |
|
Salesperson Type field. |
|
Status |
Tinyint |
|
Salesperson status code. |
Example Data
Query
SQL
SELECT TOP 10 *
FROM dbo.SalesPersons
Result
|
Id |
Name |
ShortName |
ExternalId |
Status |
|---|---|---|---|---|
|
1 |
TESTAAJA TIINA |
TINTTI |
HE |
0 |
|
2 |
TESTAAJA TIMO |
TIMPPA |
NULL |
0 |
|
3 |
DEMOAJA DINO |
DINO |
NULL |
0 |
|
4 |
MYYJÄTÄR MINNA |
MINNA |
NULL |
0 |
|
5 |
MYYJÄ MIKKO |
MIKKO |
NULL |
0 |
|
6 |
RIPEÄ RIITTA |
RIITTA |
NULL |
0 |
|
7 |
REIPAS RISTO |
RIPA |
NULL |
0 |
|
8 |
SATUMAINEN SATU |
SATU |
NULL |
0 |
|
9 |
OSTAJA OSSI |
OSSI |
NULL |
0 |
|
10 |
HELINÄ HELENA |
HELLU |
NULL |
0 |