E-CUBE Data Services WebAPI Platform

BorseriniTSCommClientiStd

Name Type Length Is Key Nullable Description Values
customer_ID int K No customer_ID
customerid nvarchar 20 K No Cod. cliente
isaddress int No Tipo indirizzo
addressid nvarchar 10 Si Cod. destinaz.
fullname nvarchar 60 Si Nome cliente
address nvarchar 255 Si Indirizzo
zipcode nvarchar 10 Si Cap
city nvarchar 1 Si Città
district nvarchar 3 Si Provincia
country nvarchar 3 Si Sigla nazione
phone nvarchar 18 Si Telefono
vatnumber nvarchar 50 Si Part. iva
fiscalcode nvarchar 50 Si Codice fiscale
sdi nvarchar 36 Si SDI
pec nvarchar 255 Si Email Pec
email nvarchar 255 Si Email
group nvarchar 10 Si Gruppo cliente
payment nvarchar 50 Si Pagamento
marketing int Si Opz. email marketing
tags nvarchar 1 Si tags
agentid decimal Si Cod. agente
ts_update timestamp No ts_update
flg_isdeleted bit No flg_isdeleted
dat_ultvar datetime2 Si dat_ultvar
Id int No Id