Catalogo articoli, accessori, alternative, lingue e barcode — Pro
Ditta e articolo: dossier completo, accessori/alternative, descrizioni in lingua e barcode a richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per vendite, customer service, retail/e-commerce e responsabili del catalogo: scegli la ditta, cerca un articolo e apri il dossier completo di descrizioni, classificazioni, unità, confezioni, varianti e fornitore abituale. Accessori mostra articoli associati e alternative con il loro dossier attuale; Lingue mostra le descrizioni commerciali; Barcode conserva codici, unità e taglie. Tre percorsi caricati solo quando servono, non un semplice elenco di nomi.
Perché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.
REQUISITO: legge solo le 14 VISTE READ documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle ERP native, buffer scrivibili o qualsiasi database NTS. Modulo, licenze, SQL delle viste, proprietario, colonne, unicità/non nullità delle chiavi logiche e permessi verificati dall’amministratore. Cifru non crea viste, installa moduli o esegue script vendor. SQL Server 2016+; nessun accesso Cloud presunto.
Pro reale: una fonte, una Home, quattro liste e tre sotto-pulsanti lazy. Ditta obbligatoria; fino a 1.000 righe per richiesta, senza refresh periodico. Ricerca/filtri locali sulle righe già caricate; restringere la selezione al limite. Identità tecniche nascoste e complete di ditta e articolo; mai unione di codici uguali in aziende diverse. Letture non snapshot atomico.
Ambito standard: articoli visibili all’applicazione esterna. ARTICO esclude gestioni lotto, matricola, commessa, ubicazione, fase e gift card. ARTACCE mostra accessori/alternative visibili collegati ad articoli visibili; nota T&C/varianti senza codici root. Non tutto il catalogo ERP. Nessuna associazione nella vista non prova che non esista nel gestionale. Due tabelle ARTACCE consecutive nel manuale: quattro campi business comuni usati, non audit apa_ultagg né schema completa certificata. Verificare vista installata e chiavi logiche, non PK SQL garantite.
A=Accessorio, S=Alternativo; codici sconosciuti/NULL restano originali, non riclassificati. Tipo non incluso nella chiave logica documentata: duplicati della stessa coppia richiedono verifica locale, non deduplicazione arbitraria. Alternativo NON certifica equivalenza tecnica, compatibilità, sostituibilità, prezzo o disponibilità. Articolo associato mancante non elimina la relazione: resta il codice originale con avviso. Nessuna navigazione ciclica.
ARTVAL.ax_codvalu è codice LINGUA, non valuta; TABLING ha solo codice e descrizione, senza ditta. Codice non ISO o locale presunto, lingua mancante indicata senza inventare un nome. Descrizioni tradotte dalla fonte, non traduzioni generate da Cifru né garanzia di tutte le lingue. Barcode resta testo con zeri iniziali/U.M./taglia originali. La dicitura EAN del manuale non certifica checksum o ogni valore reale. Nessun audit, immagine/percorso privato o credenziale.
Master e classificazioni ATTUALI, non storico. Fornitore abituale con due ragioni sociali attuali, non fornitore di un ordine. Codice IVA non aliquota, classe sconto non percentuale; pesi nativi con unità da verificare, rapporti confezione/secondaria non quantità disponibili. Note primi 500 caratteri; non prezzi/listini, movimenti, totale magazzino o inventario inventati.
Filtro ditta non ACL: contatto amministratore per account solo SELECT con ambito minimo autorizzato. Verificare indici/timeout/SQL/collation/chiavi/permessi con lettura limitata prima dell’importazione. Lazy/limiti non garantiscono performance. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e test sintetici/DEMO non certificano ERP o SQL Server reale. Catture con valori interamente inventati; galleria rappresentativa, non tutti i campi in otto immagini.
Manuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Catalogo articoli
- Details: Accessori
- Details: Lingue
- Details: Barcode
- Sub-button: Accessori e alternative
- Sub-button: Descrizioni in lingua
- Sub-button: Barcode articolo catalogo
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), z.codditt)),N':',CONVERT(nvarchar(4000), z.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), z.apa_codart)),N':',CONVERT(nvarchar(4000), z.apa_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), z.apa_codartas)),N':',CONVERT(nvarchar(4000), z.apa_codartas),N'|') AS RelatedKey, z.codditt, z.apa_codartas AS ar_codart, a.ar_codalt, COALESCE(NULLIF(a.ar_descr,N''),z.apa_codartas) AS ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, z.apa_codart AS SourceArticle, p.ar_descr AS SourceArticleName, z.apa_tipo AS AssociationCode, CASE z.apa_tipo COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Accessorio (A)' WHEN N'S' THEN N'Alternativo (S)' ELSE z.apa_tipo END AS AssociationName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability FROM ARTACCE z INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), z.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), z.apa_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.apa_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), z.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), z.apa_codartas) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.apa_codartas))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc 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 z.codditt IS NOT NULL AND z.apa_codart IS NOT NULL AND z.apa_codartas IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.ax_codart)),N':',CONVERT(nvarchar(4000), v.ax_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.ax_codvalu)),N':',CONVERT(nvarchar(4000), v.ax_codvalu),N'|') AS TranslationKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, v.codditt AS codditt, v.ax_codart AS SourceArticle, p.ar_descr AS SourceArticleName, v.ax_codvalu AS LanguageCode, COALESCE(NULLIF(l.tb_desling,N''),CONCAT(N'Codice lingua ',v.ax_codvalu)) AS LanguageName, CASE WHEN l.tb_codling IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS LanguageAvailability, v.ax_descr AS TranslatedDescription, v.ax_desint AS TranslatedExtendedDescription FROM ARTVAL v INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), v.ax_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.ax_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) LEFT JOIN TABLING l ON v.ax_codvalu=l.tb_codling WHERE v.codditt IS NOT NULL AND v.ax_codart IS NOT NULL AND v.ax_codvalu IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.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), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.bc_code)),N':',CONVERT(nvarchar(4000), v.bc_code),N'|') AS BarcodeKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, v.codditt AS codditt, v.bc_codart AS BarcodeArticle, p.ar_descr AS SourceArticleName, v.bc_code AS bc_code, v.bc_unmis AS bc_unmis, v.bc_tagl AS bc_tagl FROM BARCODE v INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), v.bc_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.bc_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) WHERE v.codditt IS NOT NULL AND v.bc_code IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NTS Business — transito e-commerce autorizzato",
"id": "F98DE380-FFCA-5094-A6F3-B671B68890C0",
"kind": "sqlServer",
"requiredObjects": [
"ARTICO",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI",
"ARTACCE",
"ARTVAL",
"TABLING",
"BARCODE"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"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": "B8E51598-6C11-50FA-A7BB-A9316DEFEBE3",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codalt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_descr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_desint",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_confez2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_qtacon2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_conver",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codiva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesonet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesolor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_forn",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codroot",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codtagl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FamilyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SeasonName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SetName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FormName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompositionName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierExtendedName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UsedState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Catalogo articoli",
"primaryKey": "ProductKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ar_codart",
"ar_codalt",
"ar_descr",
"ar_desint",
"ar_unmis",
"ar_confez2",
"ar_unmis2",
"ar_codiva",
"ar_forn",
"ar_codroot",
"ar_codvar1",
"ar_codvar2",
"ar_codvar3",
"ar_codtagl",
"ar_anno",
"ar_codcla1",
"ar_codcla2",
"ar_codcla3",
"ar_codcla4",
"ar_codcla5",
"ar_clascon",
"BrandName",
"GroupName",
"SubgroupName",
"FamilyName",
"SeasonName",
"SetName",
"FormName",
"CompositionName",
"SupplierName",
"SupplierExtendedName",
"SupplierAvailability",
"SubgroupAvailability",
"UsedState",
"SaleState",
"ProductNotes"
],
"sourceID": "F98DE380-FFCA-5094-A6F3-B671B68890C0",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V')",
"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": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"id": "8E603832-7C09-541E-BE45-9D99A332219E",
"mappings": [
{
"commonFieldKey": "",
"key": "RelatedKey",
"label": "Identità interna associazione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "RelatedKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codalt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_descr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_desint",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_confez2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_qtacon2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_conver",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codiva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesonet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesolor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_forn",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codroot",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codtagl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FamilyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SeasonName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SetName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FormName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompositionName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierExtendedName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UsedState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentProductKey",
"label": "Identità interna del padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceArticle",
"label": "Articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceArticle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceArticleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AssociationCode",
"label": "Tipo associazione: codice originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AssociationCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AssociationName",
"label": "Associazione documentata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AssociationName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo associato attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Accessori e alternative",
"primaryKey": "RelatedKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "A02A1709-F34F-5DF9-A011-F63CF517A8B3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ar_codart",
"id": "8B6CCC93-1534-55A5-A826-1FD5D562B1EB",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ar_codart",
"ar_codalt",
"ar_descr",
"ar_desint",
"ar_unmis",
"ar_confez2",
"ar_unmis2",
"ar_codiva",
"ar_forn",
"ar_codroot",
"ar_codvar1",
"ar_codvar2",
"ar_codvar3",
"ar_codtagl",
"ar_anno",
"ar_codcla1",
"ar_codcla2",
"ar_codcla3",
"ar_codcla4",
"ar_codcla5",
"ar_clascon",
"BrandName",
"GroupName",
"SubgroupName",
"FamilyName",
"SeasonName",
"SetName",
"FormName",
"CompositionName",
"SupplierName",
"SupplierExtendedName",
"SupplierAvailability",
"SubgroupAvailability",
"UsedState",
"SaleState",
"ProductNotes",
"SourceArticle",
"SourceArticleName",
"AssociationCode",
"AssociationName",
"ProductAvailability"
],
"sourceID": "F98DE380-FFCA-5094-A6F3-B671B68890C0",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), z.codditt)),N':',CONVERT(nvarchar(4000), z.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), z.apa_codart)),N':',CONVERT(nvarchar(4000), z.apa_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), z.apa_codartas)),N':',CONVERT(nvarchar(4000), z.apa_codartas),N'|') AS RelatedKey, z.codditt, z.apa_codartas AS ar_codart, a.ar_codalt, COALESCE(NULLIF(a.ar_descr,N''),z.apa_codartas) AS ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, r.an_descr2 AS SupplierExtendedName, CASE WHEN r.an_conto IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SupplierAvailability, CASE WHEN s.tb_codsgme IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS SubgroupAvailability, CASE a.ar_webusat COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, z.apa_codart AS SourceArticle, p.ar_descr AS SourceArticleName, z.apa_tipo AS AssociationCode, CASE z.apa_tipo COLLATE Latin1_General_100_BIN2 WHEN N'A' THEN N'Accessorio (A)' WHEN N'S' THEN N'Alternativo (S)' ELSE z.apa_tipo END AS AssociationName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability FROM ARTACCE z INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), z.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), z.apa_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.apa_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), z.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), z.apa_codartas) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.apa_codartas))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc 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 z.codditt IS NOT NULL AND z.apa_codart IS NOT NULL AND z.apa_codartas IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "79879C11-B2E3-5782-9E5F-A30AC7423AE7",
"key": "LanguageCode",
"type": "number"
},
{
"direction": "ascending",
"id": "79B9201B-1178-5FC1-8789-8B1187A78963",
"key": "TranslationKey",
"type": "text"
}
],
"id": "8EDB3A9B-E381-5CA5-8428-9050F6D528D6",
"mappings": [
{
"commonFieldKey": "",
"key": "TranslationKey",
"label": "Identità interna descrizione in lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TranslationKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentProductKey",
"label": "Identità interna del padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentProductKey",
"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": "SourceArticle",
"label": "Articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceArticle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceArticleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LanguageCode",
"label": "Codice lingua, non valuta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LanguageCode",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LanguageName",
"label": "Lingua secondo la vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LanguageName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LanguageAvailability",
"label": "Anagrafica lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LanguageAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "TranslatedDescription",
"label": "Descrizione nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TranslatedDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "TranslatedExtendedDescription",
"label": "Descrizione estesa nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "TranslatedExtendedDescription",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Descrizioni in lingua",
"primaryKey": "TranslationKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "A02A1709-F34F-5DF9-A011-F63CF517A8B3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ar_codart",
"id": "8B6CCC93-1534-55A5-A826-1FD5D562B1EB",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"SourceArticle",
"SourceArticleName",
"LanguageCode",
"LanguageName",
"LanguageAvailability",
"TranslatedDescription",
"TranslatedExtendedDescription"
],
"sourceID": "F98DE380-FFCA-5094-A6F3-B671B68890C0",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.ax_codart)),N':',CONVERT(nvarchar(4000), v.ax_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.ax_codvalu)),N':',CONVERT(nvarchar(4000), v.ax_codvalu),N'|') AS TranslationKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, v.codditt AS codditt, v.ax_codart AS SourceArticle, p.ar_descr AS SourceArticleName, v.ax_codvalu AS LanguageCode, COALESCE(NULLIF(l.tb_desling,N''),CONCAT(N'Codice lingua ',v.ax_codvalu)) AS LanguageName, CASE WHEN l.tb_codling IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS LanguageAvailability, v.ax_descr AS TranslatedDescription, v.ax_desint AS TranslatedExtendedDescription FROM ARTVAL v INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), v.ax_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.ax_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) LEFT JOIN TABLING l ON v.ax_codvalu=l.tb_codling WHERE v.codditt IS NOT NULL AND v.ax_codart IS NOT NULL AND v.ax_codvalu IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "87C0FA4A-F521-59BC-935E-0C9722CCC2FA",
"key": "bc_code",
"type": "text"
},
{
"direction": "ascending",
"id": "91726984-03FA-5806-902B-37705420F9BD",
"key": "BarcodeKey",
"type": "text"
}
],
"id": "A496B8CE-3BEC-5BFA-BC7F-2DE17B303235",
"mappings": [
{
"commonFieldKey": "",
"key": "BarcodeKey",
"label": "Identità interna barcode/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BarcodeKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentProductKey",
"label": "Identità interna del padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentProductKey",
"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": "BarcodeArticle",
"label": "Articolo del barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BarcodeArticle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SourceArticleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "bc_code",
"label": "Barcode documentato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bc_code",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "bc_unmis",
"label": "U.M. barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bc_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bc_tagl",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Barcode articolo catalogo",
"primaryKey": "BarcodeKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "A02A1709-F34F-5DF9-A011-F63CF517A8B3",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ar_codart",
"id": "8B6CCC93-1534-55A5-A826-1FD5D562B1EB",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"BarcodeArticle",
"SourceArticleName",
"bc_code",
"bc_unmis",
"bc_tagl"
],
"sourceID": "F98DE380-FFCA-5094-A6F3-B671B68890C0",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.bc_code)),N':',CONVERT(nvarchar(4000), v.bc_code),N'|') AS BarcodeKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart)),N':',CONVERT(nvarchar(4000), p.ar_codart),N'|') AS ParentProductKey, v.codditt AS codditt, v.bc_codart AS BarcodeArticle, p.ar_descr AS SourceArticleName, v.bc_code AS bc_code, v.bc_unmis AS bc_unmis, v.bc_tagl AS bc_tagl FROM BARCODE v INNER JOIN ARTICO p ON (CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.codditt))=DATALENGTH(CONVERT(nvarchar(4000), p.codditt))) AND (CONVERT(nvarchar(4000), v.bc_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), v.bc_codart))=DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))) WHERE v.codditt IS NOT NULL AND v.bc_code IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'ARTACCE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTACCE',N'V') AND OBJECT_ID(N'ARTVAL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTVAL',N'V') AND OBJECT_ID(N'TABLING',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABLING',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), p.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "8258218A-8135-5293-9DE6-92BA629FC9B4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "09FADC7C-B3AE-5256-B72A-8C7DCF036897",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8E603832-7C09-541E-BE45-9D99A332219E",
"title": "Accessori",
"urlKey": ""
},
{
"id": "CBD131AC-FCCD-5C98-A651-50E27FFF97DD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "F366ADA4-F00B-53B7-B350-165C1F9364DE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8EDB3A9B-E381-5CA5-8428-9050F6D528D6",
"title": "Lingue",
"urlKey": ""
},
{
"id": "1D92AB50-E476-516F-87C4-37DB55C07699",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "20367EFD-DFCE-514E-B689-65676BAF6109",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A496B8CE-3BEC-5BFA-BC7F-2DE17B303235",
"title": "Barcode",
"urlKey": ""
}
],
"badgeKey": "codditt",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B8E51598-6C11-50FA-A7BB-A9316DEFEBE3",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "85DA5E81-B992-52D1-A37E-F4F917EA09B8",
"openFilters": [
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "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": "Catalogo articoli",
"titleKey": "ar_descr"
},
{
"actions": [],
"badgeKey": "AssociationName",
"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": "8E603832-7C09-541E-BE45-9D99A332219E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Unità, confezioni e pesi",
"detailRole": "information",
"isVisible": true,
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Articolo e varianti attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Classificazioni attuali",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Vendibilità e note",
"detailRole": "information",
"isVisible": true,
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Associazione e contesto attuali",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticle",
"label": "Articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Associazione e contesto attuali",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Associazione e contesto attuali",
"detailRole": "information",
"isVisible": true,
"key": "AssociationCode",
"label": "Tipo associazione: codice originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Associazione e contesto attuali",
"detailRole": "information",
"isVisible": true,
"key": "AssociationName",
"label": "Associazione documentata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Associazione e contesto attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo associato attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "95551006-91FA-58C6-9A94-E40C3407FBD0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "093216C6-BE60-55DF-A117-99E4B19E7D16",
"key": "RelatedKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ar_codart",
"systemImage": "doc.text",
"title": "Accessori e alternative",
"titleKey": "ar_descr"
},
{
"actions": [],
"badgeKey": "LanguageCode",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TranslatedDescription",
"label": "Descrizione nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "TranslatedExtendedDescription",
"label": "Descrizione estesa nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8EDB3A9B-E381-5CA5-8428-9050F6D528D6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticle",
"label": "Articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "LanguageCode",
"label": "Codice lingua, non valuta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "LanguageName",
"label": "Lingua secondo la vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "LanguageAvailability",
"label": "Anagrafica lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "TranslatedDescription",
"label": "Descrizione nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Descrizioni commerciali in lingua — non valuta",
"detailRole": "information",
"isVisible": true,
"key": "TranslatedExtendedDescription",
"label": "Descrizione estesa nella lingua",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D6165FAB-000E-5BB3-9A3F-1E59192153CA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "79879C11-B2E3-5782-9E5F-A30AC7423AE7",
"key": "LanguageCode",
"type": "number"
},
{
"direction": "ascending",
"id": "79B9201B-1178-5FC1-8789-8B1187A78963",
"key": "TranslationKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SourceArticleName",
"systemImage": "doc.text",
"title": "Descrizioni in lingua",
"titleKey": "LanguageName"
},
{
"actions": [],
"badgeKey": "bc_unmis",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A496B8CE-3BEC-5BFA-BC7F-2DE17B303235",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "BarcodeArticle",
"label": "Articolo del barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "bc_code",
"label": "Barcode documentato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "bc_unmis",
"label": "U.M. barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità documentati",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "13C1FE47-B8AB-59CF-96CB-97C1D59213E2",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "87C0FA4A-F521-59BC-935E-0C9722CCC2FA",
"key": "bc_code",
"type": "text"
},
{
"direction": "ascending",
"id": "91726984-03FA-5806-902B-37705420F9BD",
"key": "BarcodeKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SourceArticleName",
"systemImage": "doc.text",
"title": "Barcode articolo catalogo",
"titleKey": "bc_code"
}
],
"relations": [
{
"childDatasetID": "8E603832-7C09-541E-BE45-9D99A332219E",
"childKey": "ParentProductKey",
"id": "09FADC7C-B3AE-5256-B72A-8C7DCF036897",
"name": "Accessori",
"parentDatasetID": "B8E51598-6C11-50FA-A7BB-A9316DEFEBE3",
"parentKey": "ProductKey"
},
{
"childDatasetID": "8EDB3A9B-E381-5CA5-8428-9050F6D528D6",
"childKey": "ParentProductKey",
"id": "F366ADA4-F00B-53B7-B350-165C1F9364DE",
"name": "Lingue",
"parentDatasetID": "B8E51598-6C11-50FA-A7BB-A9316DEFEBE3",
"parentKey": "ProductKey"
},
{
"childDatasetID": "A496B8CE-3BEC-5BFA-BC7F-2DE17B303235",
"childKey": "ParentProductKey",
"id": "20367EFD-DFCE-514E-B689-65676BAF6109",
"name": "Barcode",
"parentDatasetID": "B8E51598-6C11-50FA-A7BB-A9316DEFEBE3",
"parentKey": "ProductKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NTS Business Experience",
"configurationLanguages": [
"it"
],
"countries": [
"IT"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.\n\nPer vendite, customer service, retail/e-commerce e responsabili del catalogo: scegli la ditta, cerca un articolo e apri il dossier completo di descrizioni, classificazioni, unità, confezioni, varianti e fornitore abituale. Accessori mostra articoli associati e alternative con il loro dossier attuale; Lingue mostra le descrizioni commerciali; Barcode conserva codici, unità e taglie. Tre percorsi caricati solo quando servono, non un semplice elenco di nomi.\n\nPerché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.\n\nREQUISITO: legge solo le 14 VISTE READ documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle ERP native, buffer scrivibili o qualsiasi database NTS. Modulo, licenze, SQL delle viste, proprietario, colonne, unicità/non nullità delle chiavi logiche e permessi verificati dall’amministratore. Cifru non crea viste, installa moduli o esegue script vendor. SQL Server 2016+; nessun accesso Cloud presunto.\n\nPro reale: una fonte, una Home, quattro liste e tre sotto-pulsanti lazy. Ditta obbligatoria; fino a 1.000 righe per richiesta, senza refresh periodico. Ricerca/filtri locali sulle righe già caricate; restringere la selezione al limite. Identità tecniche nascoste e complete di ditta e articolo; mai unione di codici uguali in aziende diverse. Letture non snapshot atomico.\n\nAmbito standard: articoli visibili all’applicazione esterna. ARTICO esclude gestioni lotto, matricola, commessa, ubicazione, fase e gift card. ARTACCE mostra accessori/alternative visibili collegati ad articoli visibili; nota T&C/varianti senza codici root. Non tutto il catalogo ERP. Nessuna associazione nella vista non prova che non esista nel gestionale. Due tabelle ARTACCE consecutive nel manuale: quattro campi business comuni usati, non audit apa_ultagg né schema completa certificata. Verificare vista installata e chiavi logiche, non PK SQL garantite.\n\nA=Accessorio, S=Alternativo; codici sconosciuti/NULL restano originali, non riclassificati. Tipo non incluso nella chiave logica documentata: duplicati della stessa coppia richiedono verifica locale, non deduplicazione arbitraria. Alternativo NON certifica equivalenza tecnica, compatibilità, sostituibilità, prezzo o disponibilità. Articolo associato mancante non elimina la relazione: resta il codice originale con avviso. Nessuna navigazione ciclica.\n\nARTVAL.ax_codvalu è codice LINGUA, non valuta; TABLING ha solo codice e descrizione, senza ditta. Codice non ISO o locale presunto, lingua mancante indicata senza inventare un nome. Descrizioni tradotte dalla fonte, non traduzioni generate da Cifru né garanzia di tutte le lingue. Barcode resta testo con zeri iniziali/U.M./taglia originali. La dicitura EAN del manuale non certifica checksum o ogni valore reale. Nessun audit, immagine/percorso privato o credenziale.\n\nMaster e classificazioni ATTUALI, non storico. Fornitore abituale con due ragioni sociali attuali, non fornitore di un ordine. Codice IVA non aliquota, classe sconto non percentuale; pesi nativi con unità da verificare, rapporti confezione/secondaria non quantità disponibili. Note primi 500 caratteri; non prezzi/listini, movimenti, totale magazzino o inventario inventati.\n\nFiltro ditta non ACL: contatto amministratore per account solo SELECT con ambito minimo autorizzato. Verificare indici/timeout/SQL/collation/chiavi/permessi con lettura limitata prima dell’importazione. Lazy/limiti non garantiscono performance. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e test sintetici/DEMO non certificano ERP o SQL Server reale. Catture con valori interamente inventati; galleria rappresentativa, non tutti i campi in otto immagini.\n\nManuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "C7C9F351-EFFB-53EF-A8CE-E0936F73E77C",
"rootButtonCount": 1,
"summary": "Ditta e articolo: dossier completo, accessori/alternative, descrizioni in lingua e barcode a richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Catalogo articoli",
"Accessori",
"Retail",
"Pro"
],
"title": "Catalogo articoli, accessori, alternative, lingue e barcode — Pro"
}
}