TsCommArticoli
| Name |
Type |
Length |
Is Key |
Nullable |
Description |
Values |
| customer_ID |
int |
|
K |
No |
customer_ID |
|
| sku |
nvarchar |
50 |
K |
No |
sku |
|
| name |
nvarchar |
255 |
|
No |
name |
|
| description |
nvarchar |
255 |
|
Si |
description |
|
| price |
decimal |
|
|
No |
price |
|
| final_price |
decimal |
|
|
No |
final_price |
|
| stockcount |
decimal |
|
|
Si |
stockcount |
|
| unlimited |
bit |
|
|
Si |
unlimited |
|
| usevariants |
bit |
|
|
Si |
usevariants |
|
| variants |
nvarchar |
-1 |
|
Si |
variants |
|
| variantsvalue |
nvarchar |
-1 |
|
Si |
variantsvalue |
|
| categorytree |
nvarchar |
-1 |
|
Si |
categorytree |
|
| Socialcategoryid |
nvarchar |
50 |
|
Si |
Socialcategoryid |
|
| brand |
nvarchar |
100 |
|
Si |
brand |
|
| weight |
decimal |
|
|
Si |
weight |
|
| W |
decimal |
|
|
Si |
W |
|
| H |
decimal |
|
|
Si |
H |
|
| Z |
decimal |
|
|
Si |
Z |
|
| parameters |
nvarchar |
-1 |
|
Si |
parameters |
|
| images |
nvarchar |
-1 |
|
Si |
images |
|
| tags |
nvarchar |
-1 |
|
Si |
tags |
|
| Facebookenable |
bit |
|
|
Si |
Facebookenable |
|
| seotitle |
nvarchar |
255 |
|
Si |
seotitle |
|
| seodescription |
nvarchar |
-1 |
|
Si |
seodescription |
|
| seokeywords |
nvarchar |
-1 |
|
Si |
seokeywords |
|
| free_shipping |
bit |
|
|
Si |
free_shipping |
|
| ean13 |
nvarchar |
13 |
|
Si |
ean13 |
|
| mpn |
nvarchar |
50 |
|
Si |
mpn |
|
| path |
nvarchar |
500 |
|
Si |
path |
|
| visible |
bit |
|
|
Si |
visible |
|
| minQuantity |
decimal |
|
|
Si |
minQuantity |
|
| nextQuantity |
decimal |
|
|
Si |
nextQuantity |
|
| maxQuantity |
decimal |
|
|
Si |
maxQuantity |
|
| tax_percentage |
decimal |
|
|
Si |
tax_percentage |
|
| gruppo_fiscale |
nvarchar |
20 |
|
Si |
gruppo_fiscale |
|
| ProdID |
nvarchar |
50 |
|
Si |
ProdID |
|
| variante1 |
nvarchar |
4 |
|
Si |
variante1 |
|
| variante2 |
nvarchar |
4 |
|
Si |
variante2 |
|
| ts_update |
timestamp |
|
|
No |
ts_update |
|
| flg_isdeleted |
bit |
|
|
No |
flg_isdeleted |
|
| dat_ultvar |
datetime2 |
|
|
Si |
dat_ultvar |
|
| Id |
int |
|
|
No |
Id |
|