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