Salespersons
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.SalesPersonsResult
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 |