Condizioni commerciali clienti: prezzi speciali, sconti e articoli — Pro
Ditta e cliente: prezzi speciali, sei sconti originali, validità, soglie e dossier articolo a richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per vendite, customer service e responsabili commerciali: scegli la ditta, cerca il cliente e consulta i prezzi speciali e gli sconti registrati sul suo codice esatto. Apri ciascuna condizione per validità, soglie, promozione e flag originali, poi Articolo per 41 informazioni utili: descrizioni, classificazioni, unità, confezioni, varianti e fornitore abituale. Quattro percorsi a richiesta, non un elenco di nomi.
Perché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.
REQUISITO: le 13 VISTE READ del database di transito e-commerce, già installate e autorizzate; CLIENTI, LISTINIS, SCONTI, ARTICO e le classificazioni/fornitore abituale documentati. Non tabelle native NTS, buffer scrivibili o qualsiasi database Business. Cifru non crea viste, installa moduli o esegue script vendor. LISTINIG generico non è richiesto né copiato dal dossier Giacenze. SQL Server 2016+ per chiavi Float senza perdita; modulo, licenze, SQL, proprietario, colonne, unicità/non nullità delle chiavi e permessi da verificare localmente. Nessun accesso Business Cloud presunto.
Pro reale: una fonte, una Home, quattro liste e quattro sotto-pulsanti lazy. Ditta obbligatoria, massimo 1.000 righe per lettura, senza refresh periodico. Chiavi tecniche nascoste, complete di ditta/cliente/articolo/U.M./validità/quantità/promo e classi quando documentate. Filtri locali solo sulle righe caricate; restringere al limite. Letture separate non snapshot atomico.
Prezzi speciali e sconti sono SOLO le righe del codice cliente esatto: NON tutte le condizioni applicabili. Non si interpretano zero/codici vuoti come wildcard. Regole generiche, priorità/cumulo/sostituzione, promozioni attive, destinazioni specifiche e Gest. Avanzata Prezzi-Sconti non sono ricostruite. Business UP offre già Listini/Sconti: non affermiamo assenza di app mobile o di specifici campi nella sua app. Nessuna chiamata a procedure di calcolo ERP.
Prezzo in EURO secondo queste viste standard, non colonna valuta inventata o regola per altri moduli. lc_netto S vieta ulteriori sconti, NON significa IVA esclusa. Flag IVA separato; S documentato come default non garantisce ogni riga installata. Flag sconosciuti/minuscoli/NULL restano originali. Sei posizioni sconto sono valori nativi, non somma, percentuale certificata o applicazione in cascata. Nessun prezzo finale, miglior prezzo, preventivo o totale fiscale garantito.
Date/ora complete, soglie originali e sovrapposizioni restano visibili; nessuna scelta arbitraria del primo record o deduplicazione per articolo. Quantità/prezzo/sconti Float mostrati come testo senza arrotondamento monetario (17 cifre significative, virgola italiana). U.M. prezzo originale; SCONTI NON documenta una U.M.: la principale attuale è soltanto contesto, non unità certificata della regola. Classe della regola distinta dalla classe attuale cliente/articolo; nessuna verifica automatica di applicabilità.
Anagrafiche attuali, non storico fatture. ARTICO standard limita gli articoli visibili esterni ed esclude lotto/matricola/commessa/ubicazione/fase/gift card; CLIENTI standard limita i clienti visibili esterni. Articolo mancante non elimina la condizione: codice originale e avviso, Articolo può non avere righe. Fornitore abituale non controparte ordine; codice IVA non aliquota. Note primi 500 caratteri. Non audit, immagini/percorso privato, password, dati bancari o righe aziendali nel pacchetto.
Filtro ditta NON ACL: account dedicato solo SELECT con ambito minimo autorizzato. Verificare vista installata, chiavi duplicate/NULL, collation, indici, timeout, permessi e lettura limitata prima dell’importazione. Lazy/limiti non garantiscono performance. Manuali e test sintetici non certificano ERP/SQL Server reale. Immagini native DEMO interamente inventate, galleria rappresentativa; tutti i Dettagli e i quattro percorsi conservati privatamente.
Manuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm
Prezzi, sconti e provvigioni: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsmg11.htm
Promozioni: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsmg21.htm
Screenshots
What this package creates
1 Home4 Details4 lists1 sources to map
- Home: Condizioni commerciali clienti
- Details: Prezzi speciali
- Details: Sconti
- Details: Articolo
- Details: Articolo
- Sub-button: Prezzi speciali cliente
- Sub-button: Sconti registrati cliente
- Sub-button: Dossier articolo commerciale
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS CustomerKey, m.an_descr1 AS an_descr1, m.an_conto AS an_conto, m.codditt AS codditt, m.an_descr2 AS an_descr2, CASE m.an_persfg COLLATE Latin1_General_100_BIN2 WHEN N'F' THEN N'Persona fisica' WHEN N'G' THEN N'Persona giuridica' ELSE m.an_persfg END AS SubjectType, m.an_pariva AS an_pariva, m.an_codfis AS an_codfis, m.an_indir AS an_indir, m.an_cap AS an_cap, m.an_citta AS an_citta, m.an_prov AS an_prov, m.an_stato AS an_stato, m.an_telef AS an_telef, m.an_faxtlx AS an_faxtlx, m.an_email AS an_email, CASE m.an_blocco COLLATE Latin1_General_100_BIN2 WHEN N'F' THEN N'Fido' WHEN N'I' THEN N'Insoluti' WHEN N'N' THEN N'Nessun blocco' WHEN N'R' THEN N'Rimessa diretta scaduta' WHEN N'B' THEN N'Blocco fisso' ELSE m.an_blocco END AS AccountBlock, LEFT(CAST(m.an_note2 AS nvarchar(MAX)),500) AS CustomerNotes, m.an_listino, m.an_clascon FROM CLIENTI m WHERE m.codditt IS NOT NULL AND m.an_conto IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), l.codditt)),N':',CONVERT(nvarchar(4000), l.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart)),N':',CONVERT(nvarchar(4000), l.lc_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_conto)),N':',CONVERT(nvarchar(4000), l.lc_conto),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_unmis)),N':',CONVERT(nvarchar(4000), l.lc_unmis),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_datagg, 126)),N':',CONVERT(nvarchar(4000), l.lc_datagg, 126),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_daquant, 3)),N':',CONVERT(nvarchar(4000), l.lc_daquant, 3),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codtpro)),N':',CONVERT(nvarchar(4000), l.lc_codtpro),N'|') AS SpecialPriceKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS ParentCustomerKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), l.codditt)),N':',CONVERT(nvarchar(4000), l.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart)),N':',CONVERT(nvarchar(4000), l.lc_codart),N'|') AS ProductKey, l.codditt AS codditt, l.lc_conto AS CustomerCode, m.an_descr1 AS CustomerName, l.lc_codart AS ArticleCode, COALESCE(NULLIF(a.ar_descr,N''),l.lc_codart) AS ArticleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, l.lc_unmis AS lc_unmis, REPLACE(CONVERT(nvarchar(4000), l.lc_datagg, 126),N'T',CHAR(10)) AS PriceStart, REPLACE(CONVERT(nvarchar(4000), l.lc_datscad, 126),N'T',CHAR(10)) AS PriceEnd, REPLACE(CONVERT(nvarchar(4000), l.lc_daquant, 3),N'.',N',') AS lc_daquant, REPLACE(CONVERT(nvarchar(4000), l.lc_aquant, 3),N'.',N',') AS lc_aquant, REPLACE(CONVERT(nvarchar(4000), l.lc_prezzo, 3),N'.',N',') AS StoredPrice, CASE l.lc_netto COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Non applicare ulteriori sconti (S)' WHEN N'N' THEN N'Ulteriori condizioni da verificare (N)' ELSE l.lc_netto END AS NetPriceState, CASE l.lc_ivato COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Compresa (S)' WHEN N'N' THEN N'Non compresa (N)' ELSE l.lc_ivato END AS VatState, l.lc_codtpro AS lc_codtpro FROM LISTINIS l INNER JOIN CLIENTI m ON (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND l.lc_conto=m.an_conto LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), l.lc_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc WHERE l.codditt IS NOT NULL AND l.lc_codart IS NOT NULL AND l.lc_conto IS NOT NULL AND l.lc_unmis IS NOT NULL AND l.lc_datagg IS NOT NULL AND l.lc_daquant IS NOT NULL AND l.lc_codtpro IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND l.lc_conto=:customer
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), s.codditt)),N':',CONVERT(nvarchar(4000), s.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codart)),N':',CONVERT(nvarchar(4000), s.so_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_conto)),N':',CONVERT(nvarchar(4000), s.so_conto),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_clscar)),N':',CONVERT(nvarchar(4000), s.so_clscar),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_clscan)),N':',CONVERT(nvarchar(4000), s.so_clscan),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_datagg, 126)),N':',CONVERT(nvarchar(4000), s.so_datagg, 126),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_daquant, 3)),N':',CONVERT(nvarchar(4000), s.so_daquant, 3),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codtpro)),N':',CONVERT(nvarchar(4000), s.so_codtpro),N'|') AS DiscountKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS ParentCustomerKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), s.codditt)),N':',CONVERT(nvarchar(4000), s.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codart)),N':',CONVERT(nvarchar(4000), s.so_codart),N'|') AS ProductKey, s.codditt AS codditt, s.so_conto AS CustomerCode, m.an_descr1 AS CustomerName, s.so_codart AS ArticleCode, COALESCE(NULLIF(a.ar_descr,N''),s.so_codart) AS ArticleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, s.so_clscar AS so_clscar, s.so_clscan AS so_clscan, REPLACE(CONVERT(nvarchar(4000), s.so_datagg, 126),N'T',CHAR(10)) AS DiscountStart, REPLACE(CONVERT(nvarchar(4000), s.so_datscad, 126),N'T',CHAR(10)) AS DiscountEnd, REPLACE(CONVERT(nvarchar(4000), s.so_daquant, 3),N'.',N',') AS so_daquant, REPLACE(CONVERT(nvarchar(4000), s.so_aquant, 3),N'.',N',') AS so_aquant, REPLACE(CONVERT(nvarchar(4000), s.so_scont1, 3),N'.',N',') AS so_scont1, REPLACE(CONVERT(nvarchar(4000), s.so_scont2, 3),N'.',N',') AS so_scont2, REPLACE(CONVERT(nvarchar(4000), s.so_scont3, 3),N'.',N',') AS so_scont3, REPLACE(CONVERT(nvarchar(4000), s.so_scont4, 3),N'.',N',') AS so_scont4, REPLACE(CONVERT(nvarchar(4000), s.so_scont5, 3),N'.',N',') AS so_scont5, REPLACE(CONVERT(nvarchar(4000), s.so_scont6, 3),N'.',N',') AS so_scont6, s.so_codtpro AS so_codtpro, m.an_clascon AS an_clascon, a.ar_clascon AS ar_clascon, N'U.M. non documentata in SCONTI: verificare in ERP' AS DiscountUnitNotice FROM SCONTI s INNER JOIN CLIENTI m ON (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND s.so_conto=m.an_conto LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), s.so_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.so_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc WHERE s.codditt IS NOT NULL AND s.so_codart IS NOT NULL AND s.so_conto IS NOT NULL AND s.so_clscar IS NOT NULL AND s.so_clscan IS NOT NULL AND s.so_datagg IS NOT NULL AND s.so_daquant IS NOT NULL AND s.so_codtpro IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND s.so_conto=:customer
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NTS Business — transito e-commerce autorizzato",
"id": "98DB29ED-6FE1-5188-A4E6-BDC3793C3181",
"kind": "sqlServer",
"requiredObjects": [
"ARTICO",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI",
"CLIENTI",
"LISTINIS",
"SCONTI"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "CD8E1052-4E14-5E33-A5F1-5004D56D1C6D",
"key": "an_descr1",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"id": "9015815A-68CC-503F-BA29-0F3F25930861",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Identità interna cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_descr1",
"label": "Ragione sociale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_descr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_descr2",
"label": "Ragione sociale estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_descr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubjectType",
"label": "Tipo soggetto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubjectType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_pariva",
"label": "Partita IVA Italia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_pariva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_codfis",
"label": "Codice fiscale / P.IVA estera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_codfis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_indir",
"label": "Indirizzo sede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_indir",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_cap",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_cap",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_citta",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_prov",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_prov",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_stato",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_telef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_faxtlx",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_email",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AccountBlock",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerNotes",
"label": "Note cliente (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_listino",
"label": "Listino generico cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_listino",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_clascon",
"label": "Classe sconto cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Condizioni commerciali clienti",
"primaryKey": "CustomerKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"an_descr1",
"an_conto",
"codditt",
"an_descr2",
"SubjectType",
"an_pariva",
"an_codfis",
"an_indir",
"an_cap",
"an_citta",
"an_prov",
"an_stato",
"an_telef",
"an_faxtlx",
"an_email",
"AccountBlock",
"CustomerNotes",
"an_listino",
"an_clascon"
],
"sourceID": "98DB29ED-6FE1-5188-A4E6-BDC3793C3181",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS CustomerKey, m.an_descr1 AS an_descr1, m.an_conto AS an_conto, m.codditt AS codditt, m.an_descr2 AS an_descr2, CASE m.an_persfg COLLATE Latin1_General_100_BIN2 WHEN N'F' THEN N'Persona fisica' WHEN N'G' THEN N'Persona giuridica' ELSE m.an_persfg END AS SubjectType, m.an_pariva AS an_pariva, m.an_codfis AS an_codfis, m.an_indir AS an_indir, m.an_cap AS an_cap, m.an_citta AS an_citta, m.an_prov AS an_prov, m.an_stato AS an_stato, m.an_telef AS an_telef, m.an_faxtlx AS an_faxtlx, m.an_email AS an_email, CASE m.an_blocco COLLATE Latin1_General_100_BIN2 WHEN N'F' THEN N'Fido' WHEN N'I' THEN N'Insoluti' WHEN N'N' THEN N'Nessun blocco' WHEN N'R' THEN N'Rimessa diretta scaduta' WHEN N'B' THEN N'Blocco fisso' ELSE m.an_blocco END AS AccountBlock, LEFT(CAST(m.an_note2 AS nvarchar(MAX)),500) AS CustomerNotes, m.an_listino, m.an_clascon FROM CLIENTI m WHERE m.codditt IS NOT NULL AND m.an_conto IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "3AD58077-B71E-5F52-B4F4-DB6FD55D7A8A",
"key": "ArticleName",
"type": "text"
},
{
"direction": "ascending",
"id": "B3B3F747-6F09-5793-B1B0-51DA7E0237CB",
"key": "SpecialPriceKey",
"type": "text"
}
],
"id": "C1472080-7A6D-56AB-A45E-BE72B1D000C2",
"mappings": [
{
"commonFieldKey": "",
"key": "SpecialPriceKey",
"label": "Identità interna completa prezzo speciale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SpecialPriceKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCustomerKey",
"label": "Identità interna padre cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentCustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerCode",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArticleCode",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArticleCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArticleName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArticleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentPrimaryUnit",
"label": "U.M. principale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentPrimaryUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lc_unmis",
"label": "U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lc_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PriceStart",
"label": "Validità da (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceStart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PriceEnd",
"label": "Validità fino (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PriceEnd",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lc_daquant",
"label": "Da quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lc_daquant",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "lc_aquant",
"label": "A quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lc_aquant",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "StoredPrice",
"label": "Prezzo registrato — EURO",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StoredPrice",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NetPriceState",
"label": "Ulteriori sconti: flag originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NetPriceState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "VatState",
"label": "IVA compresa: flag originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "VatState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lc_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lc_codtpro",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Prezzi speciali cliente",
"primaryKey": "SpecialPriceKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "E5AD13D2-1891-5122-A691-D1764DBB061E",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "an_conto",
"id": "266EB7C7-2285-5547-84D2-FE14089C8DD4",
"name": "customer",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"CustomerCode",
"CustomerName",
"ArticleCode",
"ArticleName",
"ProductAvailability",
"CurrentPrimaryUnit",
"BrandName",
"lc_unmis",
"PriceStart",
"PriceEnd",
"lc_daquant",
"lc_aquant",
"StoredPrice",
"NetPriceState",
"VatState",
"lc_codtpro"
],
"sourceID": "98DB29ED-6FE1-5188-A4E6-BDC3793C3181",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), l.codditt)),N':',CONVERT(nvarchar(4000), l.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart)),N':',CONVERT(nvarchar(4000), l.lc_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_conto)),N':',CONVERT(nvarchar(4000), l.lc_conto),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_unmis)),N':',CONVERT(nvarchar(4000), l.lc_unmis),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_datagg, 126)),N':',CONVERT(nvarchar(4000), l.lc_datagg, 126),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_daquant, 3)),N':',CONVERT(nvarchar(4000), l.lc_daquant, 3),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codtpro)),N':',CONVERT(nvarchar(4000), l.lc_codtpro),N'|') AS SpecialPriceKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS ParentCustomerKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), l.codditt)),N':',CONVERT(nvarchar(4000), l.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart)),N':',CONVERT(nvarchar(4000), l.lc_codart),N'|') AS ProductKey, l.codditt AS codditt, l.lc_conto AS CustomerCode, m.an_descr1 AS CustomerName, l.lc_codart AS ArticleCode, COALESCE(NULLIF(a.ar_descr,N''),l.lc_codart) AS ArticleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, l.lc_unmis AS lc_unmis, REPLACE(CONVERT(nvarchar(4000), l.lc_datagg, 126),N'T',CHAR(10)) AS PriceStart, REPLACE(CONVERT(nvarchar(4000), l.lc_datscad, 126),N'T',CHAR(10)) AS PriceEnd, REPLACE(CONVERT(nvarchar(4000), l.lc_daquant, 3),N'.',N',') AS lc_daquant, REPLACE(CONVERT(nvarchar(4000), l.lc_aquant, 3),N'.',N',') AS lc_aquant, REPLACE(CONVERT(nvarchar(4000), l.lc_prezzo, 3),N'.',N',') AS StoredPrice, CASE l.lc_netto COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Non applicare ulteriori sconti (S)' WHEN N'N' THEN N'Ulteriori condizioni da verificare (N)' ELSE l.lc_netto END AS NetPriceState, CASE l.lc_ivato COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Compresa (S)' WHEN N'N' THEN N'Non compresa (N)' ELSE l.lc_ivato END AS VatState, l.lc_codtpro AS lc_codtpro FROM LISTINIS l INNER JOIN CLIENTI m ON (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND l.lc_conto=m.an_conto LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), l.lc_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.lc_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc WHERE l.codditt IS NOT NULL AND l.lc_codart IS NOT NULL AND l.lc_conto IS NOT NULL AND l.lc_unmis IS NOT NULL AND l.lc_datagg IS NOT NULL AND l.lc_daquant IS NOT NULL AND l.lc_codtpro IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), l.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), l.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND l.lc_conto=:customer",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "3AD58077-B71E-5F52-B4F4-DB6FD55D7A8A",
"key": "ArticleName",
"type": "text"
},
{
"direction": "ascending",
"id": "6295B177-ED3E-5124-8417-342F2B72CE69",
"key": "DiscountKey",
"type": "text"
}
],
"id": "A61BBCFA-A120-5498-9CBE-FF7A65D2D9DA",
"mappings": [
{
"commonFieldKey": "",
"key": "DiscountKey",
"label": "Identità interna completa sconto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentCustomerKey",
"label": "Identità interna padre cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentCustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerCode",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArticleCode",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArticleCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArticleName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArticleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentPrimaryUnit",
"label": "U.M. principale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentPrimaryUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_clscar",
"label": "Classe articolo della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_clscar",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "so_clscan",
"label": "Classe cliente della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_clscan",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DiscountStart",
"label": "Validità da (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountStart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountEnd",
"label": "Validità fino (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountEnd",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_daquant",
"label": "Da quantità originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_daquant",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_aquant",
"label": "A quantità originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_aquant",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_scont1",
"label": "Sconto 1 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont1",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "so_scont2",
"label": "Sconto 2 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont2",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "so_scont3",
"label": "Sconto 3 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_scont4",
"label": "Sconto 4 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_scont5",
"label": "Sconto 5 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_scont6",
"label": "Sconto 6 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_scont6",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "so_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "so_codtpro",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_clascon",
"label": "Classe sconto cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DiscountUnitNotice",
"label": "Unità della regola: da verificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DiscountUnitNotice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Sconti registrati cliente",
"primaryKey": "DiscountKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "E5AD13D2-1891-5122-A691-D1764DBB061E",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "an_conto",
"id": "266EB7C7-2285-5547-84D2-FE14089C8DD4",
"name": "customer",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"CustomerCode",
"CustomerName",
"ArticleCode",
"ArticleName",
"ProductAvailability",
"CurrentPrimaryUnit",
"BrandName",
"so_clscar",
"so_clscan",
"DiscountStart",
"DiscountEnd",
"so_daquant",
"so_aquant",
"so_scont1",
"so_scont2",
"so_scont3",
"so_scont4",
"so_scont5",
"so_scont6",
"so_codtpro",
"an_clascon",
"ar_clascon",
"DiscountUnitNotice"
],
"sourceID": "98DB29ED-6FE1-5188-A4E6-BDC3793C3181",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), s.codditt)),N':',CONVERT(nvarchar(4000), s.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codart)),N':',CONVERT(nvarchar(4000), s.so_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_conto)),N':',CONVERT(nvarchar(4000), s.so_conto),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_clscar)),N':',CONVERT(nvarchar(4000), s.so_clscar),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_clscan)),N':',CONVERT(nvarchar(4000), s.so_clscan),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_datagg, 126)),N':',CONVERT(nvarchar(4000), s.so_datagg, 126),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_daquant, 3)),N':',CONVERT(nvarchar(4000), s.so_daquant, 3),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codtpro)),N':',CONVERT(nvarchar(4000), s.so_codtpro),N'|') AS DiscountKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), m.codditt)),N':',CONVERT(nvarchar(4000), m.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), m.an_conto)),N':',CONVERT(nvarchar(4000), m.an_conto),N'|') AS ParentCustomerKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), s.codditt)),N':',CONVERT(nvarchar(4000), s.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), s.so_codart)),N':',CONVERT(nvarchar(4000), s.so_codart),N'|') AS ProductKey, s.codditt AS codditt, s.so_conto AS CustomerCode, m.an_descr1 AS CustomerName, s.so_codart AS ArticleCode, COALESCE(NULLIF(a.ar_descr,N''),s.so_codart) AS ArticleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, s.so_clscar AS so_clscar, s.so_clscan AS so_clscan, REPLACE(CONVERT(nvarchar(4000), s.so_datagg, 126),N'T',CHAR(10)) AS DiscountStart, REPLACE(CONVERT(nvarchar(4000), s.so_datscad, 126),N'T',CHAR(10)) AS DiscountEnd, REPLACE(CONVERT(nvarchar(4000), s.so_daquant, 3),N'.',N',') AS so_daquant, REPLACE(CONVERT(nvarchar(4000), s.so_aquant, 3),N'.',N',') AS so_aquant, REPLACE(CONVERT(nvarchar(4000), s.so_scont1, 3),N'.',N',') AS so_scont1, REPLACE(CONVERT(nvarchar(4000), s.so_scont2, 3),N'.',N',') AS so_scont2, REPLACE(CONVERT(nvarchar(4000), s.so_scont3, 3),N'.',N',') AS so_scont3, REPLACE(CONVERT(nvarchar(4000), s.so_scont4, 3),N'.',N',') AS so_scont4, REPLACE(CONVERT(nvarchar(4000), s.so_scont5, 3),N'.',N',') AS so_scont5, REPLACE(CONVERT(nvarchar(4000), s.so_scont6, 3),N'.',N',') AS so_scont6, s.so_codtpro AS so_codtpro, m.an_clascon AS an_clascon, a.ar_clascon AS ar_clascon, N'U.M. non documentata in SCONTI: verificare in ERP' AS DiscountUnitNotice FROM SCONTI s INNER JOIN CLIENTI m ON (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND s.so_conto=m.an_conto LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), s.so_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.so_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc WHERE s.codditt IS NOT NULL AND s.so_codart IS NOT NULL AND s.so_conto IS NOT NULL AND s.so_clscar IS NOT NULL AND s.so_clscan IS NOT NULL AND s.so_datagg IS NOT NULL AND s.so_daquant IS NOT NULL AND s.so_codtpro IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), s.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND s.so_conto=:customer",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"id": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codalt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_descr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_desint",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_confez2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_qtacon2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_conver",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codiva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesonet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesolor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_forn",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codroot",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codtagl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FamilyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SeasonName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SetName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FormName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompositionName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierExtendedName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UsedState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Dossier articolo commerciale",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "E5AD13D2-1891-5122-A691-D1764DBB061E",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ArticleCode",
"id": "B6351BD4-41CF-5B2C-BDFA-73FAC4341831",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ar_codart",
"ar_codalt",
"ar_descr",
"ar_desint",
"ar_unmis",
"ar_confez2",
"ar_unmis2",
"ar_codiva",
"ar_forn",
"ar_codroot",
"ar_codvar1",
"ar_codvar2",
"ar_codvar3",
"ar_codtagl",
"ar_anno",
"ar_codcla1",
"ar_codcla2",
"ar_codcla3",
"ar_codcla4",
"ar_codcla5",
"ar_clascon",
"BrandName",
"GroupName",
"SubgroupName",
"FamilyName",
"SeasonName",
"SetName",
"FormName",
"CompositionName",
"SupplierName",
"SupplierExtendedName",
"SupplierAvailability",
"SubgroupAvailability",
"UsedState",
"SaleState",
"ProductNotes"
],
"sourceID": "98DB29ED-6FE1-5188-A4E6-BDC3793C3181",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'LISTINIS',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.LISTINIS',N'V') AND OBJECT_ID(N'SCONTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.SCONTI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "32A74ACB-A61D-5CD3-ABC7-D12083F28E2A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "18456A25-D301-534D-9919-3ACA8C2B6FB9",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C1472080-7A6D-56AB-A45E-BE72B1D000C2",
"title": "Prezzi speciali",
"urlKey": ""
},
{
"id": "392B173B-4255-5DE8-B45A-BD603591E6D3",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "54A6DC5C-A120-586C-8234-3D8B4C678126",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A61BBCFA-A120-5498-9CBE-FF7A65D2D9DA",
"title": "Sconti",
"urlKey": ""
}
],
"badgeKey": "codditt",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_listino",
"label": "Listino generico cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_clascon",
"label": "Classe sconto cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "9015815A-68CC-503F-BA29-0F3F25930861",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_descr1",
"label": "Ragione sociale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_descr2",
"label": "Ragione sociale estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubjectType",
"label": "Tipo soggetto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_pariva",
"label": "Partita IVA Italia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_codfis",
"label": "Codice fiscale / P.IVA estera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_indir",
"label": "Indirizzo sede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_cap",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_prov",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Sede, contatti e anagrafica cliente attuali",
"detailRole": "information",
"isVisible": true,
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riferimenti commerciali attuali — non prezzo calcolato",
"detailRole": "information",
"isVisible": true,
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riferimenti commerciali attuali — non prezzo calcolato",
"detailRole": "information",
"isVisible": true,
"key": "CustomerNotes",
"label": "Note cliente (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riferimenti commerciali attuali — non prezzo calcolato",
"detailRole": "information",
"isVisible": true,
"key": "an_listino",
"label": "Listino generico cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riferimenti commerciali attuali — non prezzo calcolato",
"detailRole": "information",
"isVisible": true,
"key": "an_clascon",
"label": "Classe sconto cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "AB17E6DB-43DA-525D-96B9-4CB7DE41D665",
"openFilters": [
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "CD8E1052-4E14-5E33-A5F1-5004D56D1C6D",
"key": "an_descr1",
"type": "text"
},
{
"direction": "ascending",
"id": "D389B707-4A2F-5643-8EAA-D9F4FE890B9E",
"key": "CustomerKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "an_conto",
"systemImage": "doc.text",
"title": "Condizioni commerciali clienti",
"titleKey": "an_descr1"
},
{
"actions": [
{
"id": "3ED3261F-B0FC-5A76-B413-8D2B1763472E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "69839BC4-96EB-57CB-8056-D53A0231BF4E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "CustomerName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lc_unmis",
"label": "U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lc_daquant",
"label": "Da quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lc_aquant",
"label": "A quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "StoredPrice",
"label": "Prezzo registrato — EURO",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lc_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C1472080-7A6D-56AB-A45E-BE72B1D000C2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CustomerCode",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ArticleCode",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ArticleName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. principale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "lc_unmis",
"label": "U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "PriceStart",
"label": "Validità da (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "PriceEnd",
"label": "Validità fino (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "lc_daquant",
"label": "Da quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "lc_aquant",
"label": "A quantità — U.M. prezzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "StoredPrice",
"label": "Prezzo registrato — EURO",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "NetPriceState",
"label": "Ulteriori sconti: flag originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "VatState",
"label": "IVA compresa: flag originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "lc_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "F48CEE62-D259-5202-B942-2E4AB2A54CC5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "3AD58077-B71E-5F52-B4F4-DB6FD55D7A8A",
"key": "ArticleName",
"type": "text"
},
{
"direction": "ascending",
"id": "B3B3F747-6F09-5793-B1B0-51DA7E0237CB",
"key": "SpecialPriceKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ArticleCode",
"systemImage": "doc.text",
"title": "Prezzi speciali cliente",
"titleKey": "ArticleName"
},
{
"actions": [
{
"id": "425A8352-8BDB-534C-8A42-BD1100C4893B",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "5D208795-02AB-5E4F-95D8-70FCF49F3AF5",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "CustomerName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "so_clscar",
"label": "Classe articolo della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "so_clscan",
"label": "Classe cliente della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "so_scont1",
"label": "Sconto 1 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "so_scont2",
"label": "Sconto 2 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "so_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A61BBCFA-A120-5498-9CBE-FF7A65D2D9DA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CustomerCode",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ArticleCode",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ArticleName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. principale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_clscar",
"label": "Classe articolo della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_clscan",
"label": "Classe cliente della regola",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "DiscountStart",
"label": "Validità da (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "DiscountEnd",
"label": "Validità fino (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_daquant",
"label": "Da quantità originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_aquant",
"label": "A quantità originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont1",
"label": "Sconto 1 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont2",
"label": "Sconto 2 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont3",
"label": "Sconto 3 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont4",
"label": "Sconto 4 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont5",
"label": "Sconto 5 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_scont6",
"label": "Sconto 6 — valore originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "so_codtpro",
"label": "Codice promozione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_clascon",
"label": "Classe sconto cliente (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto cliente e articolo attuale",
"detailRole": "information",
"isVisible": true,
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori registrati — non preventivo né sconti calcolati",
"detailRole": "information",
"isVisible": true,
"key": "DiscountUnitNotice",
"label": "Unità della regola: da verificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4282A965-CC5E-50E2-B19A-F54918E35883",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "3AD58077-B71E-5F52-B4F4-DB6FD55D7A8A",
"key": "ArticleName",
"type": "text"
},
{
"direction": "ascending",
"id": "6295B177-ED3E-5124-8417-342F2B72CE69",
"key": "DiscountKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ArticleCode",
"systemImage": "doc.text",
"title": "Sconti registrati cliente",
"titleKey": "ArticleName"
},
{
"actions": [],
"badgeKey": "codditt",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "05912C1E-175A-56DB-94B6-90573193D5E8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ar_codart",
"systemImage": "doc.text",
"title": "Dossier articolo commerciale",
"titleKey": "ar_descr"
}
],
"relations": [
{
"childDatasetID": "C1472080-7A6D-56AB-A45E-BE72B1D000C2",
"childKey": "ParentCustomerKey",
"id": "18456A25-D301-534D-9919-3ACA8C2B6FB9",
"name": "Prezzi speciali",
"parentDatasetID": "9015815A-68CC-503F-BA29-0F3F25930861",
"parentKey": "CustomerKey"
},
{
"childDatasetID": "A61BBCFA-A120-5498-9CBE-FF7A65D2D9DA",
"childKey": "ParentCustomerKey",
"id": "54A6DC5C-A120-586C-8234-3D8B4C678126",
"name": "Sconti",
"parentDatasetID": "9015815A-68CC-503F-BA29-0F3F25930861",
"parentKey": "CustomerKey"
},
{
"childDatasetID": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"childKey": "ProductKey",
"id": "69839BC4-96EB-57CB-8056-D53A0231BF4E",
"name": "Articolo",
"parentDatasetID": "C1472080-7A6D-56AB-A45E-BE72B1D000C2",
"parentKey": "ProductKey"
},
{
"childDatasetID": "10CCEE27-FAC9-55A2-9091-8B08A105DEC4",
"childKey": "ProductKey",
"id": "5D208795-02AB-5E4F-95D8-70FCF49F3AF5",
"name": "Articolo",
"parentDatasetID": "A61BBCFA-A120-5498-9CBE-FF7A65D2D9DA",
"parentKey": "ProductKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NTS Business Experience",
"configurationLanguages": [
"it"
],
"countries": [
"IT"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.\n\nPer vendite, customer service e responsabili commerciali: scegli la ditta, cerca il cliente e consulta i prezzi speciali e gli sconti registrati sul suo codice esatto. Apri ciascuna condizione per validità, soglie, promozione e flag originali, poi Articolo per 41 informazioni utili: descrizioni, classificazioni, unità, confezioni, varianti e fornitore abituale. Quattro percorsi a richiesta, non un elenco di nomi.\n\nPerché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.\n\nREQUISITO: le 13 VISTE READ del database di transito e-commerce, già installate e autorizzate; CLIENTI, LISTINIS, SCONTI, ARTICO e le classificazioni/fornitore abituale documentati. Non tabelle native NTS, buffer scrivibili o qualsiasi database Business. Cifru non crea viste, installa moduli o esegue script vendor. LISTINIG generico non è richiesto né copiato dal dossier Giacenze. SQL Server 2016+ per chiavi Float senza perdita; modulo, licenze, SQL, proprietario, colonne, unicità/non nullità delle chiavi e permessi da verificare localmente. Nessun accesso Business Cloud presunto.\n\nPro reale: una fonte, una Home, quattro liste e quattro sotto-pulsanti lazy. Ditta obbligatoria, massimo 1.000 righe per lettura, senza refresh periodico. Chiavi tecniche nascoste, complete di ditta/cliente/articolo/U.M./validità/quantità/promo e classi quando documentate. Filtri locali solo sulle righe caricate; restringere al limite. Letture separate non snapshot atomico.\n\nPrezzi speciali e sconti sono SOLO le righe del codice cliente esatto: NON tutte le condizioni applicabili. Non si interpretano zero/codici vuoti come wildcard. Regole generiche, priorità/cumulo/sostituzione, promozioni attive, destinazioni specifiche e Gest. Avanzata Prezzi-Sconti non sono ricostruite. Business UP offre già Listini/Sconti: non affermiamo assenza di app mobile o di specifici campi nella sua app. Nessuna chiamata a procedure di calcolo ERP.\n\nPrezzo in EURO secondo queste viste standard, non colonna valuta inventata o regola per altri moduli. lc_netto S vieta ulteriori sconti, NON significa IVA esclusa. Flag IVA separato; S documentato come default non garantisce ogni riga installata. Flag sconosciuti/minuscoli/NULL restano originali. Sei posizioni sconto sono valori nativi, non somma, percentuale certificata o applicazione in cascata. Nessun prezzo finale, miglior prezzo, preventivo o totale fiscale garantito.\n\nDate/ora complete, soglie originali e sovrapposizioni restano visibili; nessuna scelta arbitraria del primo record o deduplicazione per articolo. Quantità/prezzo/sconti Float mostrati come testo senza arrotondamento monetario (17 cifre significative, virgola italiana). U.M. prezzo originale; SCONTI NON documenta una U.M.: la principale attuale è soltanto contesto, non unità certificata della regola. Classe della regola distinta dalla classe attuale cliente/articolo; nessuna verifica automatica di applicabilità.\n\nAnagrafiche attuali, non storico fatture. ARTICO standard limita gli articoli visibili esterni ed esclude lotto/matricola/commessa/ubicazione/fase/gift card; CLIENTI standard limita i clienti visibili esterni. Articolo mancante non elimina la condizione: codice originale e avviso, Articolo può non avere righe. Fornitore abituale non controparte ordine; codice IVA non aliquota. Note primi 500 caratteri. Non audit, immagini/percorso privato, password, dati bancari o righe aziendali nel pacchetto.\n\nFiltro ditta NON ACL: account dedicato solo SELECT con ambito minimo autorizzato. Verificare vista installata, chiavi duplicate/NULL, collation, indici, timeout, permessi e lettura limitata prima dell’importazione. Lazy/limiti non garantiscono performance. Manuali e test sintetici non certificano ERP/SQL Server reale. Immagini native DEMO interamente inventate, galleria rappresentativa; tutti i Dettagli e i quattro percorsi conservati privatamente.\n\nManuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm\nPrezzi, sconti e provvigioni: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsmg11.htm\nPromozioni: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsmg21.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "613F56F2-56AA-5441-8F78-E84864117258",
"rootButtonCount": 1,
"summary": "Ditta e cliente: prezzi speciali, sei sconti originali, validità, soglie e dossier articolo a richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Prezzi speciali",
"Sconti",
"Vendite",
"Pro"
],
"title": "Condizioni commerciali clienti: prezzi speciali, sconti e articoli — Pro"
}
}