TsCommClienti
| Name |
Type |
Length |
Is Key |
Nullable |
Description |
Values |
| customer_ID |
int |
|
K |
No |
customer_ID |
|
| customerid |
nvarchar |
50 |
K |
No |
customerid |
|
| isaddress |
bit |
|
|
No |
isaddress |
|
| addressid |
nvarchar |
50 |
|
Si |
addressid |
|
| fullname |
nvarchar |
255 |
|
No |
fullname |
|
| address |
nvarchar |
255 |
|
No |
address |
|
| zipcode |
nvarchar |
50 |
|
No |
zipcode |
|
| city |
nvarchar |
255 |
|
No |
city |
|
| district |
nvarchar |
50 |
|
No |
district |
|
| country |
nvarchar |
50 |
|
No |
country |
|
| phone |
nvarchar |
50 |
|
Si |
phone |
|
| vatnumber |
nvarchar |
50 |
|
Si |
vatnumber |
|
| fiscalcode |
nvarchar |
50 |
|
Si |
fiscalcode |
|
| sdi |
nvarchar |
50 |
|
Si |
sdi |
|
| pec |
nvarchar |
255 |
|
Si |
pec |
|
| email |
nvarchar |
255 |
|
No |
email |
|
| group |
nvarchar |
50 |
|
Si |
group |
|
| payment |
nvarchar |
255 |
|
Si |
payment |
|
| marketing |
bit |
|
|
Si |
marketing |
|
| tags |
nvarchar |
-1 |
|
Si |
tags |
|
| agentid |
nvarchar |
50 |
|
Si |
agentid |
|
| ts_update |
timestamp |
|
|
No |
ts_update |
|
| flg_isdeleted |
bit |
|
|
No |
flg_isdeleted |
|
| dat_ultvar |
datetime2 |
|
|
Si |
dat_ultvar |
|
| Id |
int |
|
|
No |
Id |
|