Fornitori abituali, assortimento e dossier articoli — Pro
Ditta e fornitore: conteggi vendibilità, articoli con classificazioni e varianti, barcode a richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per acquisti, retail, amministrazione del catalogo e responsabili: scegli la ditta e consulta i fornitori abituali, le due denominazioni e il numero di articoli associati. Le voci S/N e non definite distinguono la vendibilità documentata. Articoli apre il dossier completo di descrizioni, classificazioni, unità, confezioni, pesi, varianti e note; Barcode apre codici, unità e taglie. Due percorsi caricati quando servono: dal fornitore al suo assortimento attuale, non una copia del catalogo generale o un rapporto di fatture.
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: 11 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. Verificare modulo, licenze, SQL delle viste, proprietario, colonne e unicità/non nullità delle chiavi logiche; non PK SQL certificate. Cifru non crea viste, installa moduli o esegue script vendor. SQL Server 2016+; nessun accesso Cloud presunto.
Pro reale: una fonte, una Home, tre liste, due sotto-pulsanti lazy. Ditta obbligatoria; fino a 1.000 righe per richiesta, nessun refresh periodico o periodo storico fittizio. Ricerca e filtri locali sulle righe già caricate; restringere la selezione al limite. Identità tecniche nascoste, complete di ditta/fornitore o ditta/articolo/barcode. Non snapshot atomico.
FORNITORI espone solo ditta, codice, due denominazioni e timestamp; audit non visualizzato. Nessun contatto, indirizzo, codice fiscale/IVA, banca, termini di pagamento o saldo inventato. ar_forn è il FORNITORE ABITUALE ATTUALE, non il fornitore reale di un ordine o di una fattura. Non storico acquisti, prezzi di acquisto, scadenze, debiti o performance del fornitore.
Conteggi delle identità articolo distinte nelle associazioni attuali della vista, prima dei join a classificazioni e barcode: nessun fanout. S e N sono codici esatti documentati di vendibilità, non quantità disponibili o garanzia di acquisto. Codici sconosciuti, NULL e stati discordanti sono non definiti; la discordanza è segnalata separatamente. Duplicati identici non moltiplicano il conteggio, ma una chiave duplicata resta un problema della vista da correggere prima dell’importazione: le righe articolo non sono deduplicate arbitrariamente. Fornitore senza articoli associati resta con zero, non sparisce. Zero nella vista non prova assenza di articoli nel gestionale. Associazioni senza fornitore master non creano fornitori inventati. Le letture successive possono cambiare; conteggio non certifica completezza.
Ambito standard: articoli visibili all’applicazione esterna. Escluse gestioni lotto, matricola, commessa, ubicazione, fase e gift card; non tutto il catalogo ERP. Articolo conserva 41 valori utili ATTUALI, non storici. Codice IVA non aliquota, classe sconto non percentuale; rapporti U.M./confezione non disponibilità. Pesi con unità da verificare. Note primi 500 caratteri. Master/classificazioni mancanti non eliminano l’articolo: gli avvisi conservano il codice. Barcode resta testo con zeri iniziali, U.M. e taglia originali; nessun checksum EAN certificato. Nessun audit, percorso immagine privato, stock o listino sostitutivo.
Ditta non ACL ERP: usare account solo SELECT con ambito minimo autorizzato. Verificare collation, chiavi, indici, query, timeout, permessi e lettura limitata prima dell’importazione. Lazy/limiti non garantiscono prestazioni. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e test sintetici/DEMO non certificano ERP o SQL Server reale. 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 Home2 Details3 lists1 sources to map
- Home: Fornitori e assortimento
- Details: Articoli
- Details: Barcode
- Sub-button: Articoli del fornitore
- Sub-button: Barcode del fornitore
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQueryWITH af AS (SELECT a.codditt COLLATE Latin1_General_100_BIN2 AS codditt, a.ar_forn, 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'|') COLLATE Latin1_General_100_BIN2 AS ProductKey, COUNT(DISTINCT CASE WHEN a.ar_webvend IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(a.ar_webvend),N':',a.ar_webvend,N'|') END COLLATE Latin1_General_100_BIN2) AS StateVariants, MIN(a.ar_webvend COLLATE Latin1_General_100_BIN2) AS NativeSaleState FROM ARTICO a WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND a.ar_forn 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'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') GROUP BY a.codditt COLLATE Latin1_General_100_BIN2,DATALENGTH(a.codditt),a.ar_forn,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'|') COLLATE Latin1_General_100_BIN2) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.an_conto)),N':',CONVERT(nvarchar(4000), v.an_conto),N'|') AS SupplierKey, v.codditt, v.an_conto, COALESCE(NULLIF(v.an_descr1,N''),CONCAT(N'Fornitore ',v.an_conto)) AS SupplierName, v.an_descr2 AS SupplierExtendedName, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto) AS ArticleCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants=1 AND f.NativeSaleState COLLATE Latin1_General_100_BIN2=N'S') AS SaleYesCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants=1 AND f.NativeSaleState COLLATE Latin1_General_100_BIN2=N'N') AS SaleNoCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND (f.StateVariants<>1 OR f.NativeSaleState IS NULL OR f.NativeSaleState COLLATE Latin1_General_100_BIN2 NOT IN (N'S',N'N'))) AS SaleUnknownCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants>1) AS SaleConflictCount, N'Solo associazioni attuali nella vista e-commerce' AS AssortmentState FROM FORNITORI v WHERE v.codditt IS NOT NULL AND v.an_conto IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'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), 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, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_forn)),N':',CONVERT(nvarchar(4000), a.ar_forn),N'|') AS ParentSupplierKey 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'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND a.ar_forn=:supplier
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.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'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": "6B1ACBB4-C180-5A88-AA72-AC87881FD4D2",
"kind": "sqlServer",
"requiredObjects": [
"ARTICO",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI",
"BARCODE"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "D2911870-ACA8-5360-9485-2FB2F11827AC",
"key": "SupplierName",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"id": "AED5AE23-2603-5BFC-A32E-71DA5505CAE7",
"mappings": [
{
"commonFieldKey": "",
"key": "SupplierKey",
"label": "Identità interna fornitore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierKey",
"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": "an_conto",
"label": "Codice commerciale fornitore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "an_conto",
"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": "Denominazione estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierExtendedName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArticleCount",
"label": "Articoli associati nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArticleCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleYesCount",
"label": "Articoli vendibili: S",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleYesCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleNoCount",
"label": "Articoli non vendibili: N",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleNoCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleUnknownCount",
"label": "Vendibilità non definita",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleUnknownCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleConflictCount",
"label": "Articoli con vendibilità discordante",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleConflictCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "AssortmentState",
"label": "Ambito dell’assortimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "AssortmentState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Fornitori e assortimento",
"primaryKey": "SupplierKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"an_conto",
"SupplierName",
"SupplierExtendedName",
"AssortmentState"
],
"sourceID": "6B1ACBB4-C180-5A88-AA72-AC87881FD4D2",
"sqlQuery": "WITH af AS (SELECT a.codditt COLLATE Latin1_General_100_BIN2 AS codditt, a.ar_forn, 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'|') COLLATE Latin1_General_100_BIN2 AS ProductKey, COUNT(DISTINCT CASE WHEN a.ar_webvend IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(a.ar_webvend),N':',a.ar_webvend,N'|') END COLLATE Latin1_General_100_BIN2) AS StateVariants, MIN(a.ar_webvend COLLATE Latin1_General_100_BIN2) AS NativeSaleState FROM ARTICO a WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND a.ar_forn 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'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') GROUP BY a.codditt COLLATE Latin1_General_100_BIN2,DATALENGTH(a.codditt),a.ar_forn,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'|') COLLATE Latin1_General_100_BIN2) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), v.codditt)),N':',CONVERT(nvarchar(4000), v.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), v.an_conto)),N':',CONVERT(nvarchar(4000), v.an_conto),N'|') AS SupplierKey, v.codditt, v.an_conto, COALESCE(NULLIF(v.an_descr1,N''),CONCAT(N'Fornitore ',v.an_conto)) AS SupplierName, v.an_descr2 AS SupplierExtendedName, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto) AS ArticleCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants=1 AND f.NativeSaleState COLLATE Latin1_General_100_BIN2=N'S') AS SaleYesCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants=1 AND f.NativeSaleState COLLATE Latin1_General_100_BIN2=N'N') AS SaleNoCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND (f.StateVariants<>1 OR f.NativeSaleState IS NULL OR f.NativeSaleState COLLATE Latin1_General_100_BIN2 NOT IN (N'S',N'N'))) AS SaleUnknownCount, (SELECT COUNT(*) FROM af f WHERE (CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), f.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND f.ar_forn=v.an_conto AND f.StateVariants>1) AS SaleConflictCount, N'Solo associazioni attuali nella vista e-commerce' AS AssortmentState FROM FORNITORI v WHERE v.codditt IS NOT NULL AND v.an_conto IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND OBJECT_ID(N'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": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"id": "AC7D702B-DAE6-5DA2-900A-CB4BB6C8B324",
"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
},
{
"commonFieldKey": "",
"key": "ParentSupplierKey",
"label": "Identità interna fornitore padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentSupplierKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Articoli del fornitore",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "9AFE73AC-FAB0-5FF7-A815-19BE9C5A50E4",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "an_conto",
"id": "406D63FD-1530-5079-9D5C-11545A0A1F78",
"name": "supplier",
"source": "parentField",
"type": "number"
}
],
"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": "6B1ACBB4-C180-5A88-AA72-AC87881FD4D2",
"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, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_forn)),N':',CONVERT(nvarchar(4000), a.ar_forn),N'|') AS ParentSupplierKey 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'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND a.ar_forn=:supplier",
"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": "E1ACC4C8-6A76-5A9A-B7E3-6E9C73DEE83C",
"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 del fornitore",
"primaryKey": "BarcodeKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "9AFE73AC-FAB0-5FF7-A815-19BE9C5A50E4",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "ar_codart",
"id": "742CF12C-A525-5836-B581-3B51379C257B",
"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": "6B1ACBB4-C180-5A88-AA72-AC87881FD4D2",
"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'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": "59111FB5-F2BD-5588-BBDD-91961C00A006",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "9D7E3542-2A48-5C7C-B5C9-FC68327FA7A3",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "AC7D702B-DAE6-5DA2-900A-CB4BB6C8B324",
"title": "Articoli",
"urlKey": ""
}
],
"badgeKey": "codditt",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ArticleCount",
"label": "Articoli associati nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleYesCount",
"label": "Articoli vendibili: S",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleNoCount",
"label": "Articoli non vendibili: N",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleUnknownCount",
"label": "Vendibilità non definita",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "AED5AE23-2603-5BFC-A32E-71DA5505CAE7",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale",
"detailRole": "information",
"isVisible": true,
"key": "an_conto",
"label": "Codice commerciale fornitore",
"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": "Denominazione estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "ArticleCount",
"label": "Articoli associati nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "SaleYesCount",
"label": "Articoli vendibili: S",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "SaleNoCount",
"label": "Articoli non vendibili: N",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "SaleUnknownCount",
"label": "Vendibilità non definita",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "SaleConflictCount",
"label": "Articoli con vendibilità discordante",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Assortimento attuale — non disponibilità",
"detailRole": "information",
"isVisible": true,
"key": "AssortmentState",
"label": "Ambito dell’assortimento",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "60DA3267-0225-5CC5-B18F-8F3870413B80",
"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": "D2911870-ACA8-5360-9485-2FB2F11827AC",
"key": "SupplierName",
"type": "text"
},
{
"direction": "ascending",
"id": "ED8350F2-8ACE-5D71-BFE9-E224C8EE103B",
"key": "SupplierKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "SupplierExtendedName",
"systemImage": "doc.text",
"title": "Fornitori e assortimento",
"titleKey": "SupplierName"
},
{
"actions": [
{
"id": "E5A25386-AC1B-5D48-811C-36BD07CD5A49",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "445E4461-1750-5BE9-A55B-80946A4CD23F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E1ACC4C8-6A76-5A9A-B7E3-6E9C73DEE83C",
"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": "AC7D702B-DAE6-5DA2-900A-CB4BB6C8B324",
"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": "38B2E3A7-1F43-5940-96B7-9CBD8E948A89",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ar_codart",
"systemImage": "doc.text",
"title": "Articoli del fornitore",
"titleKey": "ar_descr"
},
{
"actions": [],
"badgeKey": "bc_unmis",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E1ACC4C8-6A76-5A9A-B7E3-6E9C73DEE83C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "BarcodeArticle",
"label": "Articolo del barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "SourceArticleName",
"label": "Descrizione articolo di partenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "bc_code",
"label": "Barcode documentato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "bc_unmis",
"label": "U.M. barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Barcode e unità originali",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "86A89ACD-D42E-5203-9D5D-7383D1CF8C45",
"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 del fornitore",
"titleKey": "bc_code"
}
],
"relations": [
{
"childDatasetID": "AC7D702B-DAE6-5DA2-900A-CB4BB6C8B324",
"childKey": "ParentSupplierKey",
"id": "9D7E3542-2A48-5C7C-B5C9-FC68327FA7A3",
"name": "Articoli",
"parentDatasetID": "AED5AE23-2603-5BFC-A32E-71DA5505CAE7",
"parentKey": "SupplierKey"
},
{
"childDatasetID": "E1ACC4C8-6A76-5A9A-B7E3-6E9C73DEE83C",
"childKey": "ParentProductKey",
"id": "445E4461-1750-5BE9-A55B-80946A4CD23F",
"name": "Barcode",
"parentDatasetID": "AC7D702B-DAE6-5DA2-900A-CB4BB6C8B324",
"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 acquisti, retail, amministrazione del catalogo e responsabili: scegli la ditta e consulta i fornitori abituali, le due denominazioni e il numero di articoli associati. Le voci S/N e non definite distinguono la vendibilità documentata. Articoli apre il dossier completo di descrizioni, classificazioni, unità, confezioni, pesi, varianti e note; Barcode apre codici, unità e taglie. Due percorsi caricati quando servono: dal fornitore al suo assortimento attuale, non una copia del catalogo generale o un rapporto di fatture.\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: 11 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. Verificare modulo, licenze, SQL delle viste, proprietario, colonne e unicità/non nullità delle chiavi logiche; non PK SQL certificate. Cifru non crea viste, installa moduli o esegue script vendor. SQL Server 2016+; nessun accesso Cloud presunto.\n\nPro reale: una fonte, una Home, tre liste, due sotto-pulsanti lazy. Ditta obbligatoria; fino a 1.000 righe per richiesta, nessun refresh periodico o periodo storico fittizio. Ricerca e filtri locali sulle righe già caricate; restringere la selezione al limite. Identità tecniche nascoste, complete di ditta/fornitore o ditta/articolo/barcode. Non snapshot atomico.\n\nFORNITORI espone solo ditta, codice, due denominazioni e timestamp; audit non visualizzato. Nessun contatto, indirizzo, codice fiscale/IVA, banca, termini di pagamento o saldo inventato. ar_forn è il FORNITORE ABITUALE ATTUALE, non il fornitore reale di un ordine o di una fattura. Non storico acquisti, prezzi di acquisto, scadenze, debiti o performance del fornitore.\n\nConteggi delle identità articolo distinte nelle associazioni attuali della vista, prima dei join a classificazioni e barcode: nessun fanout. S e N sono codici esatti documentati di vendibilità, non quantità disponibili o garanzia di acquisto. Codici sconosciuti, NULL e stati discordanti sono non definiti; la discordanza è segnalata separatamente. Duplicati identici non moltiplicano il conteggio, ma una chiave duplicata resta un problema della vista da correggere prima dell’importazione: le righe articolo non sono deduplicate arbitrariamente. Fornitore senza articoli associati resta con zero, non sparisce. Zero nella vista non prova assenza di articoli nel gestionale. Associazioni senza fornitore master non creano fornitori inventati. Le letture successive possono cambiare; conteggio non certifica completezza.\n\nAmbito standard: articoli visibili all’applicazione esterna. Escluse gestioni lotto, matricola, commessa, ubicazione, fase e gift card; non tutto il catalogo ERP. Articolo conserva 41 valori utili ATTUALI, non storici. Codice IVA non aliquota, classe sconto non percentuale; rapporti U.M./confezione non disponibilità. Pesi con unità da verificare. Note primi 500 caratteri. Master/classificazioni mancanti non eliminano l’articolo: gli avvisi conservano il codice. Barcode resta testo con zeri iniziali, U.M. e taglia originali; nessun checksum EAN certificato. Nessun audit, percorso immagine privato, stock o listino sostitutivo.\n\nDitta non ACL ERP: usare account solo SELECT con ambito minimo autorizzato. Verificare collation, chiavi, indici, query, timeout, permessi e lettura limitata prima dell’importazione. Lazy/limiti non garantiscono prestazioni. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e test sintetici/DEMO non certificano ERP o SQL Server reale. 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": "9F3EAEC5-8D71-51A8-8376-B33FC9A596B0",
"rootButtonCount": 1,
"summary": "Ditta e fornitore: conteggi vendibilità, articoli con classificazioni e varianti, barcode a richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Fornitori",
"Acquisti",
"Retail",
"Pro"
],
"title": "Fornitori abituali, assortimento e dossier articoli — Pro"
}
}