Documenti di vendita, righe, articolo e cliente e-commerce — Pro
Periodo, ditta e tipo: dossier operativo documenti, righe, quantità native e anagrafiche su richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per vendite, assistenza clienti, magazzino e responsabili: seleziona periodo, ditta e tipo documento. Consulta cliente e destinazione, apri Righe per articolo, quantità e U.M. native, magazzino e flag fatturazione della riga; Articolo per classificazioni, confezioni, varianti e fornitore abituale; Cliente per dati fiscali, sede, contatti, blocco e note. È un dossier operativo, non una fattura finanziaria completa o una statistica di vendite nette.
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: 14 VISTE documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle native né buffer di scrittura o qualsiasi database NTS. Cifru non crea viste o installa moduli. Verificare licenze, SQL delle viste, proprietario, colonne, unicità/non nullità delle chiavi logiche e autorizzazioni. Grassetto nel manuale non certifica PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.
Pro reale: una fonte, una Home, quattro liste e tre sotto-pulsanti caricati solo quando aperti. Periodo data documento, ditta e tipo obbligatori all’apertura. Massimo 1.000 righe per richiesta, nessun refresh periodico. L’identità include ditta, TIPO, anno, serie e numero; la riga include anche numero riga. Non si mescolano documenti con numerazione condivisa. Il tipo è mostrato con il codice nativo: A fattura immediata, B DDT, C corrispettivo, E nota addebito, N nota accredito, F ricevuta fiscale, I riemissione ricevuta fiscale, S fattura ricevuta fiscale. Tipi sconosciuti restano identificabili, non riclassificati automaticamente.
Il periodo nativo si applica DOPO il raggruppamento completo e prima del limite. Usa la data minima disponibile, normalmente unica: se le date discordano, è SOLO un selettore tecnico, non una data certa del documento. Coerenza e conteggio includono TUTTE le righe disponibili; Righe mostra tutte quelle del documento. Cliente, destinazione e data discordanti restano vuoti, con avviso; nessuna scelta arbitraria. Non snapshot atomico né storico contabile. Righe con chiave incompleta non sono rappresentabili: il conteggio non certifica completezza.
Quantità ve_quant è riportata SENZA trasformazioni nella U.M. nativa ve_ump. Il dizionario la chiama «Quantità ordinata»: non certifichiamo quantità venduta netta o segno delle note di credito. Nessuna negazione automatica, somma tra unità, conversione o sostituzione con U.M. dell’anagrafica. NULL non diventa zero; valori negativi restano tali. ve_flfatt conserva S/N, valori sconosciuti e NULL: indica DDT/Ricevuta Fiscale fatturata, NON pagamento, conferma finanziaria o stato della testata. Le righe possono avere flag diversi.
VENDITE non documenta prezzi, valuta, IVA, sconti, scadenze, pagamenti o totali monetari: non li inventiamo né li sostituiamo con listini generici. Non sommare DDT e fatture o calcolare vendite nette senza verificare causali e flusso ERP. Destinazione, cliente, descrizioni e magazzino sono ATTUALI, non storicizzati. Master assente non cancella documento o riga; nessun indirizzo sostitutivo. Articolo mantiene 40 valori utili attuali: codice IVA non aliquota, classe sconto non percentuale, classificazioni 1–5 sono codici. Note limitate a 500 caratteri; Dettagli conserva ora/millisecondi. Identità tecniche composte nascoste; nessun audit/operatore, password web, file immagine privato o credenziale.
Il filtro ditta non è ACL: usare account solo SELECT con ambito minimo approvato. Limite risultati e query lazy non garantiscono query economiche: verificare indici, timeout e piano. Restringere selezione al raggiungimento del limite. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione, test sintetici e schermate DEMO NON garantiscono 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 documenti di magazzino: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsveboll.htm
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Documenti di vendita
- Details: Righe
- Details: Articolo
- Details: Cliente
- Sub-button: Righe documento
- Sub-button: Articolo della riga
- Sub-button: Cliente del documento
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.ve_tipork COLLATE Latin1_General_100_BIN2 AS ve_tipork, i.ve_anno, i.ve_serie COLLATE Latin1_General_100_BIN2 AS ve_serie, i.ve_numdoc, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.ve_datdoc) AS PeriodDate, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_conto) ELSE NULL END AS ve_conto, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_coddest) ELSE NULL END AS ve_coddest, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_datdoc) ELSE NULL END AS ve_datdoc FROM VENDITE i WHERE i.codditt IS NOT NULL AND i.ve_tipork IS NOT NULL AND i.ve_anno IS NOT NULL AND i.ve_serie IS NOT NULL AND i.ve_numdoc IS NOT NULL AND i.ve_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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.ve_tipork COLLATE Latin1_General_100_BIN2, i.ve_anno, i.ve_serie COLLATE Latin1_General_100_BIN2, i.ve_numdoc, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_tipork)),N':',CONVERT(nvarchar(4000), h.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_anno)),N':',CONVERT(nvarchar(4000), h.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_serie)),N':',CONVERT(nvarchar(4000), h.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_numdoc)),N':',CONVERT(nvarchar(4000), h.ve_numdoc),N'|') AS DocumentKey, CASE WHEN h.ve_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.ve_conto)),N':',CONVERT(nvarchar(4000), h.ve_conto),N'|') END AS CustomerKey, h.PeriodDate AS DocumentDate, h.codditt, h.ve_tipork, h.ve_anno, h.ve_serie, h.ve_numdoc, h.ve_conto, h.ve_coddest, h.LineCount, h.HeaderVariants, CASE h.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',h.ve_tipork) END AS DocumentType, CONCAT(CASE h.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',h.ve_tipork) END,N' ',h.ve_anno,N' / ',h.ve_serie,N' / ',h.ve_numdoc) AS DocumentNumber, COALESCE(NULLIF(m.an_descr1,N''),CASE WHEN h.ve_conto IS NOT NULL THEN CONCAT(N'Cliente ',h.ve_conto) ELSE N'Testata discordante: aprire Righe' END) AS CustomerName, 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.ve_datdoc, 126),1,10) AS DocumentDateDay, REPLACE(CONVERT(nvarchar(4000), h.ve_datdoc, 126),N'T',CHAR(10)) AS DocumentDateTime, 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.ve_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.ve_conto=d.dd_conto AND h.ve_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.ve_tipork)),N':',CONVERT(nvarchar(4000), i.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_anno)),N':',CONVERT(nvarchar(4000), i.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie)),N':',CONVERT(nvarchar(4000), i.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_numdoc)),N':',CONVERT(nvarchar(4000), i.ve_numdoc),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_riga)),N':',CONVERT(nvarchar(4000), i.ve_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork)),N':',CONVERT(nvarchar(4000), i.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_anno)),N':',CONVERT(nvarchar(4000), i.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie)),N':',CONVERT(nvarchar(4000), i.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_numdoc)),N':',CONVERT(nvarchar(4000), i.ve_numdoc),N'|') AS ParentDocumentKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_codart)),N':',CONVERT(nvarchar(4000), i.ve_codart),N'|') AS ProductKey, i.codditt, i.ve_tipork, i.ve_anno, i.ve_serie, i.ve_numdoc, i.ve_conto, i.ve_coddest, i.ve_riga, i.ve_codart, i.ve_ump, i.ve_quant, i.ve_magaz, i.ve_flfatt, COALESCE(NULLIF(a.ar_descr,N''),i.ve_codart) AS ProductName, CASE i.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',i.ve_tipork) END AS DocumentType, SUBSTRING(CONVERT(nvarchar(4000), i.ve_datdoc, 126),1,10) AS DocumentDateDay, REPLACE(CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'T',CHAR(10)) AS DocumentDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.ve_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 VENDITE 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.ve_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_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.ve_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.ve_tipork IS NOT NULL AND i.ve_anno IS NOT NULL AND i.ve_serie IS NOT NULL AND i.ve_numdoc IS NOT NULL AND i.ve_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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.ve_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.ve_anno=:document_year AND (CONVERT(nvarchar(4000), i.ve_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.ve_numdoc=: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'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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": "AAC34C31-2351-5EA9-81C4-39397501B5B1",
"kind": "sqlServer",
"requiredObjects": [
"VENDITE",
"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": "EC6CD31E-FABB-5268-AD3A-FF52AD2D2F7E",
"key": "DocumentDate",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"id": "A63F9026-2FDD-5F4E-AEC8-863A1341E4E2",
"mappings": [
{
"commonFieldKey": "",
"key": "DocumentKey",
"label": "Identità interna documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentKey",
"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": "DocumentDate",
"label": "Data tecnica selezione periodo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDate",
"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": "ve_tipork",
"label": "Codice tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_tipork",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_anno",
"label": "Anno documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_serie",
"label": "Serie documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_numdoc",
"label": "Numero documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_numdoc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_coddest",
"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 testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderVariants",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentType",
"label": "Tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentNumber",
"label": "Documento di vendita",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentNumber",
"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": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderConsistency",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDateDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentDateTime",
"label": "Documento (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CustomerAvailability",
"label": "Anagrafica cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"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": "Documenti di vendita",
"primaryKey": "DocumentKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ve_tipork",
"ve_anno",
"ve_serie",
"ve_numdoc",
"ve_conto",
"ve_coddest",
"DocumentType",
"DocumentNumber",
"CustomerName",
"HeaderConsistency",
"DocumentDateDay",
"DocumentDateTime",
"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": "AAC34C31-2351-5EA9-81C4-39397501B5B1",
"sqlQuery": "WITH h AS (SELECT i.codditt COLLATE Latin1_General_100_BIN2 AS codditt, i.ve_tipork COLLATE Latin1_General_100_BIN2 AS ve_tipork, i.ve_anno, i.ve_serie COLLATE Latin1_General_100_BIN2 AS ve_serie, i.ve_numdoc, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.ve_datdoc) AS PeriodDate, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_conto) ELSE NULL END AS ve_conto, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_coddest) ELSE NULL END AS ve_coddest, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.ve_conto IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_conto)),N':',CONVERT(nvarchar(4000), i.ve_conto),N'|') END,CASE WHEN i.ve_coddest IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_coddest)),N':',CONVERT(nvarchar(4000), i.ve_coddest),N'|') END,CASE WHEN i.ve_datdoc IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.ve_datdoc, 126)),N':',CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.ve_datdoc) ELSE NULL END AS ve_datdoc FROM VENDITE i WHERE i.codditt IS NOT NULL AND i.ve_tipork IS NOT NULL AND i.ve_anno IS NOT NULL AND i.ve_serie IS NOT NULL AND i.ve_numdoc IS NOT NULL AND i.ve_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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.ve_tipork COLLATE Latin1_General_100_BIN2, i.ve_anno, i.ve_serie COLLATE Latin1_General_100_BIN2, i.ve_numdoc, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_tipork)),N':',CONVERT(nvarchar(4000), h.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_anno)),N':',CONVERT(nvarchar(4000), h.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_serie)),N':',CONVERT(nvarchar(4000), h.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.ve_numdoc)),N':',CONVERT(nvarchar(4000), h.ve_numdoc),N'|') AS DocumentKey, CASE WHEN h.ve_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.ve_conto)),N':',CONVERT(nvarchar(4000), h.ve_conto),N'|') END AS CustomerKey, h.PeriodDate AS DocumentDate, h.codditt, h.ve_tipork, h.ve_anno, h.ve_serie, h.ve_numdoc, h.ve_conto, h.ve_coddest, h.LineCount, h.HeaderVariants, CASE h.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',h.ve_tipork) END AS DocumentType, CONCAT(CASE h.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',h.ve_tipork) END,N' ',h.ve_anno,N' / ',h.ve_serie,N' / ',h.ve_numdoc) AS DocumentNumber, COALESCE(NULLIF(m.an_descr1,N''),CASE WHEN h.ve_conto IS NOT NULL THEN CONCAT(N'Cliente ',h.ve_conto) ELSE N'Testata discordante: aprire Righe' END) AS CustomerName, 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.ve_datdoc, 126),1,10) AS DocumentDateDay, REPLACE(CONVERT(nvarchar(4000), h.ve_datdoc, 126),N'T',CHAR(10)) AS DocumentDateTime, 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.ve_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.ve_conto=d.dd_conto AND h.ve_coddest=d.dd_coddest WHERE h.PeriodDate IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "6BD4F298-D79C-5FBC-8F7F-CA792B22CC2B",
"key": "ve_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "182A098F-3592-5655-B1C7-91E19AA994AA",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Identità interna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentDocumentKey",
"label": "Identità documento padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentDocumentKey",
"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": "ve_tipork",
"label": "Codice tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_tipork",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_anno",
"label": "Anno documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_serie",
"label": "Serie documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_numdoc",
"label": "Numero documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_numdoc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_conto",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_coddest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_riga",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_ump",
"label": "U.M. nativa riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_ump",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ve_quant",
"label": "Quantità nativa della vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_quant",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ve_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_magaz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ve_flfatt",
"label": "DDT/R.F. fatturata: codice S/N",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ve_flfatt",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentType",
"label": "Tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDateDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DocumentDateTime",
"label": "Documento (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DocumentDateTime",
"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": true
},
{
"commonFieldKey": "",
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Righe documento",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "09C4F720-9B23-5C53-B5AA-FC67D0CA4DB7",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_tipork",
"id": "F3F7A295-9E75-58A5-ABF8-C6F8FC83E3E0",
"name": "document_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_anno",
"id": "7183E50D-A547-5FFF-8E8E-5123776F3C51",
"name": "document_year",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_serie",
"id": "4F9E681C-BFB6-53F3-9D15-DC6B2CD53339",
"name": "document_series",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_numdoc",
"id": "6E33CFBD-EAC7-5B01-9554-B43C9C70A2C0",
"name": "document_number",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ve_tipork",
"ve_anno",
"ve_serie",
"ve_numdoc",
"ve_conto",
"ve_coddest",
"ve_riga",
"ve_codart",
"ve_ump",
"ve_magaz",
"ve_flfatt",
"ProductName",
"DocumentType",
"DocumentDateDay",
"DocumentDateTime",
"WarehouseName",
"ProductAvailability",
"WarehouseAvailability"
],
"sourceID": "AAC34C31-2351-5EA9-81C4-39397501B5B1",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork)),N':',CONVERT(nvarchar(4000), i.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_anno)),N':',CONVERT(nvarchar(4000), i.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie)),N':',CONVERT(nvarchar(4000), i.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_numdoc)),N':',CONVERT(nvarchar(4000), i.ve_numdoc),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_riga)),N':',CONVERT(nvarchar(4000), i.ve_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork)),N':',CONVERT(nvarchar(4000), i.ve_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_anno)),N':',CONVERT(nvarchar(4000), i.ve_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie)),N':',CONVERT(nvarchar(4000), i.ve_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_numdoc)),N':',CONVERT(nvarchar(4000), i.ve_numdoc),N'|') AS ParentDocumentKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.ve_codart)),N':',CONVERT(nvarchar(4000), i.ve_codart),N'|') AS ProductKey, i.codditt, i.ve_tipork, i.ve_anno, i.ve_serie, i.ve_numdoc, i.ve_conto, i.ve_coddest, i.ve_riga, i.ve_codart, i.ve_ump, i.ve_quant, i.ve_magaz, i.ve_flfatt, COALESCE(NULLIF(a.ar_descr,N''),i.ve_codart) AS ProductName, CASE i.ve_tipork COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Fatture immediate emesse' WHEN N'B' THEN N'DDT emessi' WHEN N'C' THEN N'Corrispettivi emessi' WHEN N'E' THEN N'Note di addebito emesse' WHEN N'N' THEN N'Note di accredito emesse' WHEN N'F' THEN N'Ricevute fiscali emesse' WHEN N'I' THEN N'Riemissioni ricevute fiscali emesse' WHEN N'S' THEN N'Fatture ricevuta fiscale emesse' ELSE CONCAT(N'Tipo non documentato: ',i.ve_tipork) END AS DocumentType, SUBSTRING(CONVERT(nvarchar(4000), i.ve_datdoc, 126),1,10) AS DocumentDateDay, REPLACE(CONVERT(nvarchar(4000), i.ve_datdoc, 126),N'T',CHAR(10)) AS DocumentDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.ve_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 VENDITE 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.ve_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_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.ve_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.ve_tipork IS NOT NULL AND i.ve_anno IS NOT NULL AND i.ve_serie IS NOT NULL AND i.ve_numdoc IS NOT NULL AND i.ve_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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.ve_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.ve_anno=:document_year AND (CONVERT(nvarchar(4000), i.ve_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.ve_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.ve_numdoc=: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": "249932DE-576B-5440-A1D3-710FE51108F9",
"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": "09C4F720-9B23-5C53-B5AA-FC67D0CA4DB7",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_codart",
"id": "68C5DA72-C52F-54A8-94A0-A591A29D34CE",
"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": "AAC34C31-2351-5EA9-81C4-39397501B5B1",
"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'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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": "51D534A9-BB66-50FE-A014-8F624FB808E7",
"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 del documento",
"primaryKey": "CustomerKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "09C4F720-9B23-5C53-B5AA-FC67D0CA4DB7",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ve_conto",
"id": "EB80B0B4-DE12-51A1-9F74-9CFAFD10E209",
"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": "AAC34C31-2351-5EA9-81C4-39397501B5B1",
"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'VENDITE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.VENDITE',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": "0E0AE084-6AA4-5F06-B1FA-78F1081AC793",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "32450372-5B7D-5574-8C44-2034B3645C95",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "182A098F-3592-5655-B1C7-91E19AA994AA",
"title": "Righe",
"urlKey": ""
},
{
"id": "D783ECCD-FF2F-5F11-BB04-B078BC67BDE8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "94AAEC6A-CDD8-5E9E-BE69-46192FBDF991",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "51D534A9-BB66-50FE-A014-8F624FB808E7",
"title": "Cliente",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HeaderConsistency",
"label": "Coerenza testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustomerAvailability",
"label": "Anagrafica cliente",
"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": "A63F9026-2FDD-5F4E-AEC8-863A1341E4E2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_tipork",
"label": "Codice tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_anno",
"label": "Anno documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_serie",
"label": "Serie documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_numdoc",
"label": "Numero documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "ve_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe presenti nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "DocumentType",
"label": "Tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "DocumentNumber",
"label": "Documento di vendita",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "CustomerName",
"label": "Cliente attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateTime",
"label": "Documento (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Documento 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": "F3568D3B-070C-5B30-B7C2-36C8B6F9B202",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "CDE594C4-F59A-5898-AB6A-84235D1A71AA",
"includeAllOption": false,
"key": "DocumentDate",
"title": "Periodo data documento",
"type": "date"
},
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
},
{
"id": "BEF94320-A545-51CB-A5BD-190AD51BD7B0",
"includeAllOption": false,
"key": "DocumentType",
"title": "Tipo documento",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "EC6CD31E-FABB-5268-AD3A-FF52AD2D2F7E",
"key": "DocumentDate",
"type": "date"
},
{
"direction": "ascending",
"id": "6C99D094-05D0-5681-9500-0CA5504BECC9",
"key": "DocumentKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "CustomerName",
"systemImage": "doc.text",
"title": "Documenti di vendita",
"titleKey": "DocumentNumber"
},
{
"actions": [
{
"id": "D5ECA32A-60AC-5AAB-99DA-5C3F699F6DF8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "FFEEC71E-294E-5AE8-8034-41580BE268ED",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "249932DE-576B-5440-A1D3-710FE51108F9",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "WarehouseName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ve_ump",
"label": "U.M. nativa riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ve_quant",
"label": "Quantità nativa vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ve_flfatt",
"label": "DDT/R.F. fatturata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "182A098F-3592-5655-B1C7-91E19AA994AA",
"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": "ve_tipork",
"label": "Codice tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_anno",
"label": "Anno documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_serie",
"label": "Serie documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_numdoc",
"label": "Numero documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_conto",
"label": "Codice cliente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_coddest",
"label": "Codice destinazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità e flag nativi — non stato pagamento",
"detailRole": "information",
"isVisible": true,
"key": "ve_ump",
"label": "U.M. nativa riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità e flag nativi — non stato pagamento",
"detailRole": "information",
"isVisible": true,
"key": "ve_quant",
"label": "Quantità nativa della vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ve_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità e flag nativi — non stato pagamento",
"detailRole": "information",
"isVisible": true,
"key": "ve_flfatt",
"label": "DDT/R.F. fatturata: codice S/N",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "DocumentType",
"label": "Tipo documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateDay",
"label": "Data documento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "DocumentDateTime",
"label": "Documento (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": "02008B8D-B5AA-57F8-89E1-638075178AF8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6BD4F298-D79C-5FBC-8F7F-CA792B22CC2B",
"key": "ve_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ve_codart",
"systemImage": "doc.text",
"title": "Righe documento",
"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": "249932DE-576B-5440-A1D3-710FE51108F9",
"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": "CCAF94B8-1AD8-5921-8F51-81477BB9F6A3",
"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": "51D534A9-BB66-50FE-A014-8F624FB808E7",
"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": "9AAEBD9C-4369-5DCC-984E-0438F8A26B3A",
"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 del documento",
"titleKey": "an_descr1"
}
],
"relations": [
{
"childDatasetID": "182A098F-3592-5655-B1C7-91E19AA994AA",
"childKey": "ParentDocumentKey",
"id": "32450372-5B7D-5574-8C44-2034B3645C95",
"name": "Righe",
"parentDatasetID": "A63F9026-2FDD-5F4E-AEC8-863A1341E4E2",
"parentKey": "DocumentKey"
},
{
"childDatasetID": "249932DE-576B-5440-A1D3-710FE51108F9",
"childKey": "ProductKey",
"id": "FFEEC71E-294E-5AE8-8034-41580BE268ED",
"name": "Articolo",
"parentDatasetID": "182A098F-3592-5655-B1C7-91E19AA994AA",
"parentKey": "ProductKey"
},
{
"childDatasetID": "51D534A9-BB66-50FE-A014-8F624FB808E7",
"childKey": "CustomerKey",
"id": "94AAEC6A-CDD8-5E9E-BE69-46192FBDF991",
"name": "Cliente",
"parentDatasetID": "A63F9026-2FDD-5F4E-AEC8-863A1341E4E2",
"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: seleziona periodo, ditta e tipo documento. Consulta cliente e destinazione, apri Righe per articolo, quantità e U.M. native, magazzino e flag fatturazione della riga; Articolo per classificazioni, confezioni, varianti e fornitore abituale; Cliente per dati fiscali, sede, contatti, blocco e note. È un dossier operativo, non una fattura finanziaria completa o una statistica di vendite nette.\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: 14 VISTE documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle native né buffer di scrittura o qualsiasi database NTS. Cifru non crea viste o installa moduli. Verificare licenze, SQL delle viste, proprietario, colonne, unicità/non nullità delle chiavi logiche e autorizzazioni. Grassetto nel manuale non certifica PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.\n\nPro reale: una fonte, una Home, quattro liste e tre sotto-pulsanti caricati solo quando aperti. Periodo data documento, ditta e tipo obbligatori all’apertura. Massimo 1.000 righe per richiesta, nessun refresh periodico. L’identità include ditta, TIPO, anno, serie e numero; la riga include anche numero riga. Non si mescolano documenti con numerazione condivisa. Il tipo è mostrato con il codice nativo: A fattura immediata, B DDT, C corrispettivo, E nota addebito, N nota accredito, F ricevuta fiscale, I riemissione ricevuta fiscale, S fattura ricevuta fiscale. Tipi sconosciuti restano identificabili, non riclassificati automaticamente.\n\nIl periodo nativo si applica DOPO il raggruppamento completo e prima del limite. Usa la data minima disponibile, normalmente unica: se le date discordano, è SOLO un selettore tecnico, non una data certa del documento. Coerenza e conteggio includono TUTTE le righe disponibili; Righe mostra tutte quelle del documento. Cliente, destinazione e data discordanti restano vuoti, con avviso; nessuna scelta arbitraria. Non snapshot atomico né storico contabile. Righe con chiave incompleta non sono rappresentabili: il conteggio non certifica completezza.\n\nQuantità ve_quant è riportata SENZA trasformazioni nella U.M. nativa ve_ump. Il dizionario la chiama «Quantità ordinata»: non certifichiamo quantità venduta netta o segno delle note di credito. Nessuna negazione automatica, somma tra unità, conversione o sostituzione con U.M. dell’anagrafica. NULL non diventa zero; valori negativi restano tali. ve_flfatt conserva S/N, valori sconosciuti e NULL: indica DDT/Ricevuta Fiscale fatturata, NON pagamento, conferma finanziaria o stato della testata. Le righe possono avere flag diversi.\n\nVENDITE non documenta prezzi, valuta, IVA, sconti, scadenze, pagamenti o totali monetari: non li inventiamo né li sostituiamo con listini generici. Non sommare DDT e fatture o calcolare vendite nette senza verificare causali e flusso ERP. Destinazione, cliente, descrizioni e magazzino sono ATTUALI, non storicizzati. Master assente non cancella documento o riga; nessun indirizzo sostitutivo. Articolo mantiene 40 valori utili attuali: codice IVA non aliquota, classe sconto non percentuale, classificazioni 1–5 sono codici. Note limitate a 500 caratteri; Dettagli conserva ora/millisecondi. Identità tecniche composte nascoste; nessun audit/operatore, password web, file immagine privato o credenziale.\n\nIl filtro ditta non è ACL: usare account solo SELECT con ambito minimo approvato. Limite risultati e query lazy non garantiscono query economiche: verificare indici, timeout e piano. Restringere selezione al raggiungimento del limite. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione, test sintetici e schermate DEMO NON garantiscono 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 documenti di magazzino: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsveboll.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "6F31E347-D19B-5E16-B85D-B79DD173AEC1",
"rootButtonCount": 1,
"summary": "Periodo, ditta e tipo: dossier operativo documenti, righe, quantità native e anagrafiche su richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Documenti di vendita",
"Fatture",
"DDT",
"Magazzino",
"Pro"
],
"title": "Documenti di vendita, righe, articolo e cliente e-commerce — Pro"
}
}