Impegni clienti, righe, articolo e cliente e-commerce — Pro
Periodo e ditta: ordini, destinazione attuale, quantità, consegna e dossier articolo/cliente su richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per vendite, assistenza clienti, magazzino e responsabili: scegli periodo e ditta, consulta gli impegni clienti, la destinazione e lo stato della testata. Apri Righe per quantità impegnata ed evasa, U.M., data di consegna e magazzino; poi Articolo per classificazioni, confezioni, varianti e fornitore abituale. Il pulsante Cliente apre anagrafica, dati fiscali, sede, contatti, blocco e note attuali.
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 SPECIFICO: 14 VISTE documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce già installate e autorizzate. Non tabelle native, ANAGRAX/DESTDIVX/TESTORDX/MOVORDX o qualsiasi database NTS. Cifru non crea viste, installa moduli o esegue script vendor. Verificare licenze, SQL delle viste, proprietario, colonne, chiavi logiche uniche/non nulle e autorizzazioni. Le chiavi in grassetto non certificano PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.
Pro reale: una fonte, quattro liste, tre sotto-pulsanti caricati solo quando aperti. Una Home; periodo data ordine e ditta obbligatori. Massimo 1.000 righe per richiesta, nessun refresh periodico. Il filtro nativo di periodo si applica dopo il raggruppamento completo, prima del limite. Usa la data minima disponibile delle righe di ciascun ordine: normalmente coincide con la data unica della testata. Se le date sono discordanti, tale data serve SOLO alla selezione del periodo, non viene presentata come data ordine certa. Coerenza e conteggio includono TUTTE le righe disponibili della stessa identità. Righe apre tutte le righe di quell’ordine, non soltanto quelle del periodo. Non storico contabile o snapshot atomico. Dati testata discordanti sono segnalati: nessuna scelta arbitraria di cliente, destinazione, riferimento, data o stato; questi valori restano vuoti e le righe sono ispezionabili.
DOMINIO: soltanto IMPEGNI tipo R (impegni clienti) e dati esposti dalle viste esterne. Non ordini fornitori, preventivi, fatture o intero ERP. Destinazione, cliente, descrizioni articolo e magazzino sono ATTUALI, non quelli storicizzati sul documento. Master assente non cancella l’ordine o la riga; nessun indirizzo sostitutivo o U.M. inventata. Codici tecnici composti sono nascosti.
Quantità nella U.M. principale della riga im_ump: nessuna conversione o somma tra unità. Differenza calcolata=im_quant−im_quaeva, NON quantità certamente da consegnare: la riga può essere evasa a saldo. im_flevas della testata conserva S/N, valori sconosciuti o NULL; im_flevasr è mostrato come codice nativo S/C, senza indovinare il significato di C. NULL non diventa zero; differenze negative non sono azzerate. Il conteggio riguarda le righe presenti nella vista, non una certificazione di completezza. Dettagli conserva ora/millisecondi.
La vista IMPEGNI non documenta prezzi, valuta, IVA, sconti o totali monetari: non li inventiamo né sostituiamo con listini generici. Articolo mantiene 40 valori utili attuali; codice IVA non è aliquota, classe sconto non è percentuale, classificazioni 1–5 sono codici. Confezioni e U.M. secondaria conservano rapporti moltiplicatore/divisore. Note limitate a 500 caratteri. Nessun audit/operatore, password web, file immagine privato o credenziale esposto.
Il filtro ditta non è ACL. Usare account solo SELECT con ambito aziendale minimo approvato. Limite risultati e query lazy non garantiscono query economiche: verificare indici, timeout e piano di esecuzione. Restringere selezione quando si raggiunge il limite. Pacchetto senza server, credenziali, cache o righe aziendali. Test sintetici e schermate DEMO non provano compatibilità con ERP o SQL Server reale. Verificare metadati, collation, chiavi e lettura limitata prima dell’importazione.
Manuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm
Flusso funzionale ordini: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsorgsor.htm
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Impegni clienti
- Details: Righe
- Details: Articolo
- Details: Cliente
- Sub-button: Righe impegno
- Sub-button: Articolo della riga
- Sub-button: Cliente dell’impegno
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.sqlQueryWITH h AS (SELECT i.codditt COLLATE Latin1_General_100_BIN2 AS codditt, i.im_tipork COLLATE Latin1_General_100_BIN2 AS im_tipork, i.im_anno, i.im_serie COLLATE Latin1_General_100_BIN2 AS im_serie, i.im_numord, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.im_datord) AS PeriodDate, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_conto) ELSE NULL END AS im_conto, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_coddest) ELSE NULL END AS im_coddest, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_riferim) ELSE NULL END AS im_riferim, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_datord) ELSE NULL END AS im_datord, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_flevas) ELSE NULL END AS im_flevas FROM IMPEGNI i WHERE i.codditt IS NOT NULL AND i.im_tipork IS NOT NULL AND i.im_anno IS NOT NULL AND i.im_serie IS NOT NULL AND i.im_numord IS NOT NULL AND i.im_riga IS NOT NULL AND i.im_tipork COLLATE Latin1_General_100_BIN2=N'R' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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') GROUP BY i.codditt COLLATE Latin1_General_100_BIN2, i.im_tipork COLLATE Latin1_General_100_BIN2, i.im_anno, i.im_serie COLLATE Latin1_General_100_BIN2, i.im_numord, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.im_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_tipork)),N':',CONVERT(nvarchar(4000), h.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_anno)),N':',CONVERT(nvarchar(4000), h.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_serie)),N':',CONVERT(nvarchar(4000), h.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_numord)),N':',CONVERT(nvarchar(4000), h.im_numord),N'|') AS OrderKey, CASE WHEN h.im_conto IS NULL THEN NULL ELSE CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_conto)),N':',CONVERT(nvarchar(4000), h.im_conto),N'|') END AS CustomerKey, h.PeriodDate AS OrderDate, h.codditt, h.im_tipork, h.im_anno, h.im_serie, h.im_numord, h.im_conto, h.im_coddest, h.im_riferim, h.LineCount, h.HeaderVariants, CONCAT(N'Ordine ',h.im_anno,N' / ',h.im_serie,N' / ',h.im_numord) AS OrderNumber, COALESCE(NULLIF(m.an_descr1,N''),CASE WHEN h.im_conto IS NOT NULL THEN CONCAT(N'Cliente ',h.im_conto) ELSE N'Testata discordante: aprire Righe' END) AS CustomerName, CASE h.im_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE h.im_flevas END AS HeaderState, CASE WHEN h.HeaderVariants=1 THEN N'Coerente nelle righe presenti' ELSE N'Dati testata discordanti: verificare Righe e vista' END AS HeaderConsistency, SUBSTRING(CONVERT(nvarchar(4000), h.im_datord, 126),1,10) AS OrderDateDay, REPLACE(CONVERT(nvarchar(4000), h.im_datord, 126),N'T',CHAR(10)) AS OrderDateTime, CASE WHEN h.HeaderVariants<>1 THEN N'Testata discordante: cliente non selezionato' WHEN m.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS CustomerAvailability, CASE WHEN h.HeaderVariants<>1 THEN N'Testata discordante: destinazione non selezionata' WHEN d.dd_coddest IS NULL THEN N'Non disponibile: nessun indirizzo sostitutivo' ELSE N'Disponibile — anagrafica attuale' END AS DestinationAvailability, d.dd_nomdest AS dd_nomdest, d.dd_coddest AS dd_coddest, d.dd_nomdest2 AS dd_nomdest2, d.dd_inddest AS dd_inddest, d.dd_capdest AS dd_capdest, d.dd_locdest AS dd_locdest, d.dd_prodest AS dd_prodest, d.dd_stato AS dd_stato, d.dd_telef AS dd_telef, d.dd_faxtlx AS dd_faxtlx, d.dd_email AS dd_email, LEFT(CAST(d.dd_note AS nvarchar(MAX)),500) AS DestinationNotes FROM h LEFT JOIN CLIENTI m ON (CONVERT(nvarchar(4000), h.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), h.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND h.im_conto=m.an_conto LEFT JOIN DESTDIV d ON (CONVERT(nvarchar(4000), h.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), d.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), h.codditt))=DATALENGTH(CONVERT(nvarchar(4000), d.codditt))) AND h.im_conto=d.dd_conto AND h.im_coddest=d.dd_coddest WHERE h.PeriodDate IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)),N':',CONVERT(nvarchar(4000), i.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_anno)),N':',CONVERT(nvarchar(4000), i.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_serie)),N':',CONVERT(nvarchar(4000), i.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_numord)),N':',CONVERT(nvarchar(4000), i.im_numord),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_riga)),N':',CONVERT(nvarchar(4000), i.im_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)),N':',CONVERT(nvarchar(4000), i.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_anno)),N':',CONVERT(nvarchar(4000), i.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_serie)),N':',CONVERT(nvarchar(4000), i.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_numord)),N':',CONVERT(nvarchar(4000), i.im_numord),N'|') AS ParentOrderKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_codart)),N':',CONVERT(nvarchar(4000), i.im_codart),N'|') AS ProductKey, i.codditt, i.im_tipork, i.im_anno, i.im_serie, i.im_numord, i.im_conto, i.im_coddest, i.im_riferim, i.im_riga, i.im_codart, i.im_ump, i.im_quant, i.im_quaeva, i.im_magaz, COALESCE(NULLIF(a.ar_descr,N''),i.im_codart) AS ProductName, i.im_quant-i.im_quaeva AS ArithmeticDifference, i.im_flevasr AS LineState, CASE i.im_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE i.im_flevas END AS HeaderState, SUBSTRING(CONVERT(nvarchar(4000), i.im_datcons, 126),1,10) AS DeliveryDay, REPLACE(CONVERT(nvarchar(4000), i.im_datcons, 126),N'T',CHAR(10)) AS DeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), i.im_datord, 126),N'T',CHAR(10)) AS OrderDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.im_magaz)) AS WarehouseName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability FROM IMPEGNI i LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), i.im_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND i.im_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.im_tipork IS NOT NULL AND i.im_anno IS NOT NULL AND i.im_serie IS NOT NULL AND i.im_numord IS NOT NULL AND i.im_riga IS NOT NULL AND i.im_tipork COLLATE Latin1_General_100_BIN2=N'R' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), i.im_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.im_anno=:document_year AND (CONVERT(nvarchar(4000), i.im_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.im_numord=:document_number
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.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, 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 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend 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'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (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
Statically verified read-only
$.components.workspaceSelection.datasets.3.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 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 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 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'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND m.an_conto=:customer
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NTS Business — transito e-commerce autorizzato",
"id": "C6DFA0BB-14D5-5C35-B552-E6D5E3A15536",
"kind": "sqlServer",
"requiredObjects": [
"IMPEGNI",
"CLIENTI",
"DESTDIV",
"ARTICO",
"TABMAGA",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "5AC10FAA-1AE3-5D46-9CE1-EBAFB34B2D5A",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Identità interna completa ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Identità interna cliente/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDate",
"label": "Data tecnica selezione periodo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_tipork",
"label": "Tipo interno R",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_tipork",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_numord",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_coddest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_riferim",
"label": "Riferimento app esterna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_riferim",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Righe presenti nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderVariants",
"label": "Varianti interne della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderVariants",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNumber",
"label": "Ordine cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNumber",
"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": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderConsistency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderDateTime",
"label": "Data ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerAvailability",
"label": "Anagrafica cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DestinationAvailability",
"label": "Destinazione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DestinationAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_nomdest",
"label": "Destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_nomdest",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dd_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_coddest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_nomdest2",
"label": "Destinazione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_nomdest2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_inddest",
"label": "Indirizzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_inddest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_capdest",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_capdest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_locdest",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_locdest",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dd_prodest",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_prodest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_stato",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_telef",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_faxtlx",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dd_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dd_email",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DestinationNotes",
"label": "Note destinazione (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DestinationNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Impegni clienti",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"im_anno",
"im_serie",
"im_numord",
"im_conto",
"im_coddest",
"im_riferim",
"OrderNumber",
"CustomerName",
"HeaderState",
"HeaderConsistency",
"OrderDateDay",
"OrderDateTime",
"CustomerAvailability",
"DestinationAvailability",
"dd_nomdest",
"dd_coddest",
"dd_nomdest2",
"dd_inddest",
"dd_capdest",
"dd_locdest",
"dd_prodest",
"dd_stato",
"dd_telef",
"dd_faxtlx",
"dd_email",
"DestinationNotes"
],
"sourceID": "C6DFA0BB-14D5-5C35-B552-E6D5E3A15536",
"sqlQuery": "WITH h AS (SELECT i.codditt COLLATE Latin1_General_100_BIN2 AS codditt, i.im_tipork COLLATE Latin1_General_100_BIN2 AS im_tipork, i.im_anno, i.im_serie COLLATE Latin1_General_100_BIN2 AS im_serie, i.im_numord, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.im_datord) AS PeriodDate, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_conto) ELSE NULL END AS im_conto, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_coddest) ELSE NULL END AS im_coddest, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_riferim) ELSE NULL END AS im_riferim, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_datord) ELSE NULL END AS im_datord, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.im_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_conto)),N':',CONVERT(nvarchar(4000), i.im_conto),N'|') END,CASE WHEN i.im_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_coddest)),N':',CONVERT(nvarchar(4000), i.im_coddest),N'|') END,CASE WHEN i.im_riferim IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_riferim)),N':',CONVERT(nvarchar(4000), i.im_riferim),N'|') END,CASE WHEN i.im_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_datord, 126)),N':',CONVERT(nvarchar(4000), i.im_datord, 126),N'|') END,CASE WHEN i.im_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.im_flevas)),N':',CONVERT(nvarchar(4000), i.im_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.im_flevas) ELSE NULL END AS im_flevas FROM IMPEGNI i WHERE i.codditt IS NOT NULL AND i.im_tipork IS NOT NULL AND i.im_anno IS NOT NULL AND i.im_serie IS NOT NULL AND i.im_numord IS NOT NULL AND i.im_riga IS NOT NULL AND i.im_tipork COLLATE Latin1_General_100_BIN2=N'R' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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') GROUP BY i.codditt COLLATE Latin1_General_100_BIN2, i.im_tipork COLLATE Latin1_General_100_BIN2, i.im_anno, i.im_serie COLLATE Latin1_General_100_BIN2, i.im_numord, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.im_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_tipork)),N':',CONVERT(nvarchar(4000), h.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_anno)),N':',CONVERT(nvarchar(4000), h.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_serie)),N':',CONVERT(nvarchar(4000), h.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_numord)),N':',CONVERT(nvarchar(4000), h.im_numord),N'|') AS OrderKey, CASE WHEN h.im_conto IS NULL THEN NULL ELSE CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.im_conto)),N':',CONVERT(nvarchar(4000), h.im_conto),N'|') END AS CustomerKey, h.PeriodDate AS OrderDate, h.codditt, h.im_tipork, h.im_anno, h.im_serie, h.im_numord, h.im_conto, h.im_coddest, h.im_riferim, h.LineCount, h.HeaderVariants, CONCAT(N'Ordine ',h.im_anno,N' / ',h.im_serie,N' / ',h.im_numord) AS OrderNumber, COALESCE(NULLIF(m.an_descr1,N''),CASE WHEN h.im_conto IS NOT NULL THEN CONCAT(N'Cliente ',h.im_conto) ELSE N'Testata discordante: aprire Righe' END) AS CustomerName, CASE h.im_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE h.im_flevas END AS HeaderState, CASE WHEN h.HeaderVariants=1 THEN N'Coerente nelle righe presenti' ELSE N'Dati testata discordanti: verificare Righe e vista' END AS HeaderConsistency, SUBSTRING(CONVERT(nvarchar(4000), h.im_datord, 126),1,10) AS OrderDateDay, REPLACE(CONVERT(nvarchar(4000), h.im_datord, 126),N'T',CHAR(10)) AS OrderDateTime, CASE WHEN h.HeaderVariants<>1 THEN N'Testata discordante: cliente non selezionato' WHEN m.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS CustomerAvailability, CASE WHEN h.HeaderVariants<>1 THEN N'Testata discordante: destinazione non selezionata' WHEN d.dd_coddest IS NULL THEN N'Non disponibile: nessun indirizzo sostitutivo' ELSE N'Disponibile — anagrafica attuale' END AS DestinationAvailability, d.dd_nomdest AS dd_nomdest, d.dd_coddest AS dd_coddest, d.dd_nomdest2 AS dd_nomdest2, d.dd_inddest AS dd_inddest, d.dd_capdest AS dd_capdest, d.dd_locdest AS dd_locdest, d.dd_prodest AS dd_prodest, d.dd_stato AS dd_stato, d.dd_telef AS dd_telef, d.dd_faxtlx AS dd_faxtlx, d.dd_email AS dd_email, LEFT(CAST(d.dd_note AS nvarchar(MAX)),500) AS DestinationNotes FROM h LEFT JOIN CLIENTI m ON (CONVERT(nvarchar(4000), h.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), h.codditt))=DATALENGTH(CONVERT(nvarchar(4000), m.codditt))) AND h.im_conto=m.an_conto LEFT JOIN DESTDIV d ON (CONVERT(nvarchar(4000), h.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), d.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), h.codditt))=DATALENGTH(CONVERT(nvarchar(4000), d.codditt))) AND h.im_conto=d.dd_conto AND h.im_coddest=d.dd_coddest WHERE h.PeriodDate IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "57F6276E-EEBD-5F58-8F2F-A7B96B348974",
"key": "im_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "24D3317D-E802-5A9E-89E1-296717FFFE6C",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Identità interna completa riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Identità ordine padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentOrderKey",
"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": "im_tipork",
"label": "Tipo interno R",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_tipork",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_numord",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_coddest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_riferim",
"label": "Riferimento app esterna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_riferim",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_riga",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "im_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_ump",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "im_quant",
"label": "Quantità impegnata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_quant",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "im_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_quaeva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "im_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "im_magaz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArithmeticDifference",
"label": "Differenza quantità calcolata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArithmeticDifference",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DeliveryDateTime",
"label": "Consegna riga (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateTime",
"label": "Data ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseName",
"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": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Righe impegno",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F1F51CA0-550B-5715-8E12-973EC5B5B44A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_tipork",
"id": "5CF07203-95D3-52AE-9281-5FBDBA104C34",
"name": "document_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_anno",
"id": "5B6BD444-490C-5C6C-8C51-9B7C79A4546B",
"name": "document_year",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_serie",
"id": "202C9C3A-80EC-50CF-B894-2130C4550D47",
"name": "document_series",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_numord",
"id": "04CEF101-DC18-5C3D-9CED-204A572064DC",
"name": "document_number",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"im_anno",
"im_serie",
"im_numord",
"im_conto",
"im_coddest",
"im_riferim",
"im_riga",
"im_codart",
"im_ump",
"im_magaz",
"ProductName",
"LineState",
"HeaderState",
"DeliveryDay",
"DeliveryDateTime",
"OrderDateTime",
"WarehouseName",
"ProductAvailability",
"WarehouseAvailability"
],
"sourceID": "C6DFA0BB-14D5-5C35-B552-E6D5E3A15536",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)),N':',CONVERT(nvarchar(4000), i.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_anno)),N':',CONVERT(nvarchar(4000), i.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_serie)),N':',CONVERT(nvarchar(4000), i.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_numord)),N':',CONVERT(nvarchar(4000), i.im_numord),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_riga)),N':',CONVERT(nvarchar(4000), i.im_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork)),N':',CONVERT(nvarchar(4000), i.im_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_anno)),N':',CONVERT(nvarchar(4000), i.im_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_serie)),N':',CONVERT(nvarchar(4000), i.im_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_numord)),N':',CONVERT(nvarchar(4000), i.im_numord),N'|') AS ParentOrderKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.im_codart)),N':',CONVERT(nvarchar(4000), i.im_codart),N'|') AS ProductKey, i.codditt, i.im_tipork, i.im_anno, i.im_serie, i.im_numord, i.im_conto, i.im_coddest, i.im_riferim, i.im_riga, i.im_codart, i.im_ump, i.im_quant, i.im_quaeva, i.im_magaz, COALESCE(NULLIF(a.ar_descr,N''),i.im_codart) AS ProductName, i.im_quant-i.im_quaeva AS ArithmeticDifference, i.im_flevasr AS LineState, CASE i.im_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE i.im_flevas END AS HeaderState, SUBSTRING(CONVERT(nvarchar(4000), i.im_datcons, 126),1,10) AS DeliveryDay, REPLACE(CONVERT(nvarchar(4000), i.im_datcons, 126),N'T',CHAR(10)) AS DeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), i.im_datord, 126),N'T',CHAR(10)) AS OrderDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.im_magaz)) AS WarehouseName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability FROM IMPEGNI i LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), i.im_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND i.im_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.im_tipork IS NOT NULL AND i.im_anno IS NOT NULL AND i.im_serie IS NOT NULL AND i.im_numord IS NOT NULL AND i.im_riga IS NOT NULL AND i.im_tipork COLLATE Latin1_General_100_BIN2=N'R' AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), i.im_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.im_anno=:document_year AND (CONVERT(nvarchar(4000), i.im_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.im_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.im_numord=:document_number",
"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": "7CBAAA03-9520-5625-9FB3-63A3BC5D37AA",
"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": "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": "Articolo della riga",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F1F51CA0-550B-5715-8E12-973EC5B5B44A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_codart",
"id": "6E3FF387-74EC-55DD-8C39-D43EC2945C33",
"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",
"SupplierAvailability",
"SubgroupAvailability",
"UsedState",
"SaleState",
"ProductNotes"
],
"sourceID": "C6DFA0BB-14D5-5C35-B552-E6D5E3A15536",
"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, 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 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend 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'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (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": ""
},
{
"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": "58D5C28F-CC72-53F6-950E-E4D9DA4A509E",
"mappings": [
{
"commonFieldKey": "",
"key": "CustomerKey",
"label": "Interno CustomerKey",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_descr1",
"label": "Ragione sociale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_descr1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_descr2",
"label": "Ragione sociale estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_descr2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubjectType",
"label": "Tipo soggetto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "SubjectType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_pariva",
"label": "Partita IVA Italia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_pariva",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_codfis",
"label": "Codice fiscale / P.IVA estera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_codfis",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_indir",
"label": "Indirizzo sede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_indir",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_cap",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_cap",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_citta",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_prov",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_prov",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_stato",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_telef",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "an_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_faxtlx",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "an_email",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "AccountBlock",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerNotes",
"label": "Note cliente (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text",
"sourceColumn": "CustomerNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Cliente dell’impegno",
"primaryKey": "CustomerKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F1F51CA0-550B-5715-8E12-973EC5B5B44A",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "im_conto",
"id": "7098192F-7559-56F6-886B-F310F911BACA",
"name": "customer",
"source": "parentField",
"type": "number"
}
],
"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"
],
"sourceID": "C6DFA0BB-14D5-5C35-B552-E6D5E3A15536",
"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 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 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 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'IMPEGNI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.IMPEGNI',N'V') AND OBJECT_ID(N'CLIENTI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.CLIENTI',N'V') AND OBJECT_ID(N'DESTDIV',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.DESTDIV',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',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 (CONVERT(nvarchar(4000), m.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), m.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND m.an_conto=:customer",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "DF5A127E-0A76-5FBF-A0F2-063FCA914AF3",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F9F6F23E-2124-53CA-BBD3-B82EB307D8FB",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "24D3317D-E802-5A9E-89E1-296717FFFE6C",
"title": "Righe",
"urlKey": ""
},
{
"id": "AF6798C1-644B-559B-9252-14198988DEF4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D7541239-2ECF-59B8-A579-EDBCB90AE035",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "58D5C28F-CC72-53F6-950E-E4D9DA4A509E",
"title": "Cliente",
"urlKey": ""
}
],
"badgeKey": "im_riferim",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HeaderConsistency",
"label": "Coerenza testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dd_nomdest",
"label": "Destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dd_locdest",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "5AC10FAA-1AE3-5D46-9CE1-EBAFB34B2D5A",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "im_riferim",
"label": "Riferimento app esterna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe presenti nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderNumber",
"label": "Ordine cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateTime",
"label": "Data ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "CustomerAvailability",
"label": "Anagrafica cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "DestinationAvailability",
"label": "Destinazione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_nomdest",
"label": "Destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_nomdest2",
"label": "Destinazione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_inddest",
"label": "Indirizzo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_capdest",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_locdest",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_prodest",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "dd_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Destinazione attuale — non storico",
"detailRole": "information",
"isVisible": true,
"key": "DestinationNotes",
"label": "Note destinazione (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2F89B34D-4B4D-5930-82CD-D1741A00F0A3",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "189A97AD-6683-579F-AE71-92C28445FD77",
"includeAllOption": false,
"key": "OrderDate",
"title": "Periodo data ordine",
"type": "date"
},
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CustomerName",
"systemImage": "doc.text",
"title": "Impegni clienti",
"titleKey": "OrderNumber"
},
{
"actions": [
{
"id": "0AC5A395-57CC-5C03-A5E4-906A5EDE5D12",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "5D1EF739-CCC7-5276-85A8-D067E91D3AF7",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "7CBAAA03-9520-5625-9FB3-63A3BC5D37AA",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "WarehouseName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "im_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "im_quant",
"label": "Quantità impegnata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "im_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ArithmeticDifference",
"label": "Differenza impegnata−evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "24D3317D-E802-5A9E-89E1-296717FFFE6C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_riferim",
"label": "Riferimento app esterna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native e stato",
"detailRole": "information",
"isVisible": true,
"key": "im_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native e stato",
"detailRole": "information",
"isVisible": true,
"key": "im_quant",
"label": "Quantità impegnata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native e stato",
"detailRole": "information",
"isVisible": true,
"key": "im_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "im_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native e stato",
"detailRole": "information",
"isVisible": true,
"key": "ArithmeticDifference",
"label": "Differenza quantità calcolata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native e stato",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Scadenza di consegna",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Scadenza di consegna",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDateTime",
"label": "Consegna riga (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateTime",
"label": "Data ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A74A3479-1E7F-5A29-9012-0BBA1DBBC96E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "57F6276E-EEBD-5F58-8F2F-A7B96B348974",
"key": "im_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "im_codart",
"systemImage": "doc.text",
"title": "Righe impegno",
"titleKey": "ProductName"
},
{
"actions": [],
"badgeKey": "",
"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": "7CBAAA03-9520-5625-9FB3-63A3BC5D37AA",
"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": "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": "E8EAD744-0989-5D62-AAB1-0DF1F06CEB82",
"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": "Articolo della riga",
"titleKey": "ar_descr"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_pariva",
"label": "Partita IVA Italia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_prov",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"datasetID": "58D5C28F-CC72-53F6-950E-E4D9DA4A509E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Anagrafica cliente",
"detailRole": "information",
"isVisible": true,
"key": "an_descr1",
"label": "Ragione sociale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Anagrafica cliente",
"detailRole": "information",
"isVisible": true,
"key": "an_descr2",
"label": "Ragione sociale estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Anagrafica cliente",
"detailRole": "information",
"isVisible": true,
"key": "an_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Anagrafica cliente",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Anagrafica cliente",
"detailRole": "information",
"isVisible": true,
"key": "SubjectType",
"label": "Tipo soggetto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dati fiscali",
"detailRole": "information",
"isVisible": true,
"key": "an_pariva",
"label": "Partita IVA Italia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Dati fiscali",
"detailRole": "information",
"isVisible": true,
"key": "an_codfis",
"label": "Codice fiscale / P.IVA estera",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Sede attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_indir",
"label": "Indirizzo sede",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Sede attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_cap",
"label": "CAP",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Sede attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_citta",
"label": "Città",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Sede attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_prov",
"label": "Provincia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Sede attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_stato",
"label": "Stato (codice gestionale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contatti",
"detailRole": "information",
"isVisible": true,
"key": "an_telef",
"label": "Telefono",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contatti",
"detailRole": "information",
"isVisible": true,
"key": "an_faxtlx",
"label": "Fax",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contatti",
"detailRole": "information",
"isVisible": true,
"key": "an_email",
"label": "E-mail",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contesto operativo",
"detailRole": "information",
"isVisible": true,
"key": "AccountBlock",
"label": "Blocco conto",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
},
{
"detailGroup": "Contesto operativo",
"detailRole": "information",
"isVisible": true,
"key": "CustomerNotes",
"label": "Note cliente (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "text"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "011E5F7E-CEA0-5538-A5BD-DC35C15C98B5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"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": "Cliente dell’impegno",
"titleKey": "an_descr1"
}
],
"relations": [
{
"childDatasetID": "24D3317D-E802-5A9E-89E1-296717FFFE6C",
"childKey": "ParentOrderKey",
"id": "F9F6F23E-2124-53CA-BBD3-B82EB307D8FB",
"name": "Righe",
"parentDatasetID": "5AC10FAA-1AE3-5D46-9CE1-EBAFB34B2D5A",
"parentKey": "OrderKey"
},
{
"childDatasetID": "7CBAAA03-9520-5625-9FB3-63A3BC5D37AA",
"childKey": "ProductKey",
"id": "5D1EF739-CCC7-5276-85A8-D067E91D3AF7",
"name": "Articolo",
"parentDatasetID": "24D3317D-E802-5A9E-89E1-296717FFFE6C",
"parentKey": "ProductKey"
},
{
"childDatasetID": "58D5C28F-CC72-53F6-950E-E4D9DA4A509E",
"childKey": "CustomerKey",
"id": "D7541239-2ECF-59B8-A579-EDBCB90AE035",
"name": "Cliente",
"parentDatasetID": "5AC10FAA-1AE3-5D46-9CE1-EBAFB34B2D5A",
"parentKey": "CustomerKey"
}
],
"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, assistenza clienti, magazzino e responsabili: scegli periodo e ditta, consulta gli impegni clienti, la destinazione e lo stato della testata. Apri Righe per quantità impegnata ed evasa, U.M., data di consegna e magazzino; poi Articolo per classificazioni, confezioni, varianti e fornitore abituale. Il pulsante Cliente apre anagrafica, dati fiscali, sede, contatti, blocco e note attuali.\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 SPECIFICO: 14 VISTE documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce già installate e autorizzate. Non tabelle native, ANAGRAX/DESTDIVX/TESTORDX/MOVORDX o qualsiasi database NTS. Cifru non crea viste, installa moduli o esegue script vendor. Verificare licenze, SQL delle viste, proprietario, colonne, chiavi logiche uniche/non nulle e autorizzazioni. Le chiavi in grassetto non certificano PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.\n\nPro reale: una fonte, quattro liste, tre sotto-pulsanti caricati solo quando aperti. Una Home; periodo data ordine e ditta obbligatori. Massimo 1.000 righe per richiesta, nessun refresh periodico. Il filtro nativo di periodo si applica dopo il raggruppamento completo, prima del limite. Usa la data minima disponibile delle righe di ciascun ordine: normalmente coincide con la data unica della testata. Se le date sono discordanti, tale data serve SOLO alla selezione del periodo, non viene presentata come data ordine certa. Coerenza e conteggio includono TUTTE le righe disponibili della stessa identità. Righe apre tutte le righe di quell’ordine, non soltanto quelle del periodo. Non storico contabile o snapshot atomico. Dati testata discordanti sono segnalati: nessuna scelta arbitraria di cliente, destinazione, riferimento, data o stato; questi valori restano vuoti e le righe sono ispezionabili.\n\nDOMINIO: soltanto IMPEGNI tipo R (impegni clienti) e dati esposti dalle viste esterne. Non ordini fornitori, preventivi, fatture o intero ERP. Destinazione, cliente, descrizioni articolo e magazzino sono ATTUALI, non quelli storicizzati sul documento. Master assente non cancella l’ordine o la riga; nessun indirizzo sostitutivo o U.M. inventata. Codici tecnici composti sono nascosti.\n\nQuantità nella U.M. principale della riga im_ump: nessuna conversione o somma tra unità. Differenza calcolata=im_quant−im_quaeva, NON quantità certamente da consegnare: la riga può essere evasa a saldo. im_flevas della testata conserva S/N, valori sconosciuti o NULL; im_flevasr è mostrato come codice nativo S/C, senza indovinare il significato di C. NULL non diventa zero; differenze negative non sono azzerate. Il conteggio riguarda le righe presenti nella vista, non una certificazione di completezza. Dettagli conserva ora/millisecondi.\n\nLa vista IMPEGNI non documenta prezzi, valuta, IVA, sconti o totali monetari: non li inventiamo né sostituiamo con listini generici. Articolo mantiene 40 valori utili attuali; codice IVA non è aliquota, classe sconto non è percentuale, classificazioni 1–5 sono codici. Confezioni e U.M. secondaria conservano rapporti moltiplicatore/divisore. Note limitate a 500 caratteri. Nessun audit/operatore, password web, file immagine privato o credenziale esposto.\n\nIl filtro ditta non è ACL. Usare account solo SELECT con ambito aziendale minimo approvato. Limite risultati e query lazy non garantiscono query economiche: verificare indici, timeout e piano di esecuzione. Restringere selezione quando si raggiunge il limite. Pacchetto senza server, credenziali, cache o righe aziendali. Test sintetici e schermate DEMO non provano compatibilità con ERP o SQL Server reale. Verificare metadati, collation, chiavi e lettura limitata prima dell’importazione.\n\nManuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm\nFlusso funzionale ordini: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsorgsor.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "C9226890-823E-5C98-BF93-1A79AE0C9938",
"rootButtonCount": 1,
"summary": "Periodo e ditta: ordini, destinazione attuale, quantità, consegna e dossier articolo/cliente su richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Ordini clienti",
"Impegni",
"Vendite",
"Magazzino",
"Pro"
],
"title": "Impegni clienti, righe, articolo e cliente e-commerce — Pro"
}
}