Giacenze per taglia: magazzini, articoli e barcode — Pro
Ditta e magazzino: 24 posizioni taglia, quantità originali, dossier articolo e barcode con verifica di etichetta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per negozi, magazzino, acquisti e responsabili: scegli ditta e magazzino, cerca l’articolo e consulta marca, stagione, scala e conteggi delle posizioni. Apri Taglie per esistenza, ordinato fornitori, impegnato clienti e prenotato spedizioni di ciascuna posizione; poi Barcode taglia. Articolo mostra descrizioni, classificazioni, varianti, confezioni e fornitore abituale. Percorsi a richiesta, non un elenco di nomi.
Perché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.
REQUISITO: 14 VISTE READ del database di transito e-commerce già installate e autorizzate, inclusi ARTPROTC e TABTAGL in colonna. Non tabelle native, buffer scrivibili, qualsiasi database Business o cloud. Cifru non crea viste né esegue script vendor. Verificare modulo Taglie/Colori, licenze, SQL Server 2016+, proprietario, schema, unicità/non nullità delle chiavi e permessi.
Pro reale: una fonte, una Home, quattro liste, tre sotto-pulsanti lazy. Ditta e magazzino obbligatori, massimo 1.000 righe per lettura, nessun refresh periodico. Le 24 colonne documentate 01–24 sono trasformate in 24 posizioni per l’articolo/magazzino selezionato: ordinali derivati, NON colonne ERP nuove. Nessuna aggregazione per etichetta, deduplicazione, nascondimento automatico di zero/NULL o somma tra unità. Conteggi positivi/negativi/zero/NULL si riferiscono alle 24 posizioni, non al numero di taglie attive o a quantità totali.
Quantità Float originali, 17 cifre significative con virgola italiana: zero, negative e NULL restano distinte. U.M. principale dell’anagrafica attuale è soltanto contesto: verificare l’unità dei progressivi nella vista e nella configurazione TCO installata. Nessuna conversione o disponibilità calcolata, promessa di consegna, costo, valorizzazione, movimenti o situazione storica a una data. Timestamp completo proviene da ARTPROTC, non da un campo inventato di ARTPROTCR.
Scala/etichette e anagrafiche sono attuali, non uno snapshot atomico delle letture. Articolo, magazzino o scala mancanti non cancellano il progressivo; avviso esplicito, nessun nome/U.M./taglia inventati. Tutte le 24 posizioni restano leggibili, anche non definite. Barcode taglia richiede etichetta non vuota e univoca nella scala, ditta e articolo esatti; etichetta duplicata/NULL/vuota blocca il lookup anziché scegliere un barcode arbitrario. Ordine della scala non inferito da bc_tagl; barcode senza match non inventato. U.M./taglia del barcode originali, nessuna garanzia EAN o equivalenza con unità stock. Magazzino e posizione nel dossier barcode sono contesto padre, non campi fisici BARCODE.
Visibilità esterna del modulo e-commerce, non tutto l’ERP; ARTICO standard esclude lotto/matricola/commessa/ubicazione/fase/gift card. Progressivi taglie non suddivisi per lotto/commessa/ubicazione/fase. Dossier articolo: fornitore abituale, non controparte documento; IVA/classificazioni sono codici, non aliquote o descrizioni indovinate. Note primi 500 caratteri, nessun audit/file privato/password.
Filtro ditta non è ACL. Account dedicato solo SELECT e ambito minimo approvato; validare viste installate, chiavi, collation, indici, timeout e letture limitate. Lazy e limiti non garantiscono performance. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e prove sintetiche non certificano installazione NTS o SQL Server reale. Immagini native DEMO interamente inventate; massimo otto in galleria, percorsi e Dettagli completi conservati privatamente.
Schema tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm
Scala taglie: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024sr1/html/ambstco02.htm
Inventario: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsmgstrl.htm
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Giacenze articoli per taglia
- Details: Taglie
- Details: Articolo
- Details: Barcode taglia
- Sub-button: Taglie del magazzino
- Sub-button: Dossier articolo taglie
- Sub-button: Barcode della taglia
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), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS StockKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|') AS ProductKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, (CASE WHEN p.apt_esist01>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24>0 THEN 1 ELSE 0 END) AS PositivePositions, (CASE WHEN p.apt_esist01<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24<0 THEN 1 ELSE 0 END) AS NegativePositions, (CASE WHEN p.apt_esist01=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24=0 THEN 1 ELSE 0 END) AS ZeroPositions, (CASE WHEN p.apt_esist01 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24 IS NULL THEN 1 ELSE 0 END) AS UnknownPositions FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',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')
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQueryWITH StockSource AS (SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS ParentStockKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, p.apt_esist01 AS apt_esist01, p.apt_esist02 AS apt_esist02, p.apt_esist03 AS apt_esist03, p.apt_esist04 AS apt_esist04, p.apt_esist05 AS apt_esist05, p.apt_esist06 AS apt_esist06, p.apt_esist07 AS apt_esist07, p.apt_esist08 AS apt_esist08, p.apt_esist09 AS apt_esist09, p.apt_esist10 AS apt_esist10, p.apt_esist11 AS apt_esist11, p.apt_esist12 AS apt_esist12, p.apt_esist13 AS apt_esist13, p.apt_esist14 AS apt_esist14, p.apt_esist15 AS apt_esist15, p.apt_esist16 AS apt_esist16, p.apt_esist17 AS apt_esist17, p.apt_esist18 AS apt_esist18, p.apt_esist19 AS apt_esist19, p.apt_esist20 AS apt_esist20, p.apt_esist21 AS apt_esist21, p.apt_esist22 AS apt_esist22, p.apt_esist23 AS apt_esist23, p.apt_esist24 AS apt_esist24, p.apt_ordin01 AS apt_ordin01, p.apt_ordin02 AS apt_ordin02, p.apt_ordin03 AS apt_ordin03, p.apt_ordin04 AS apt_ordin04, p.apt_ordin05 AS apt_ordin05, p.apt_ordin06 AS apt_ordin06, p.apt_ordin07 AS apt_ordin07, p.apt_ordin08 AS apt_ordin08, p.apt_ordin09 AS apt_ordin09, p.apt_ordin10 AS apt_ordin10, p.apt_ordin11 AS apt_ordin11, p.apt_ordin12 AS apt_ordin12, p.apt_ordin13 AS apt_ordin13, p.apt_ordin14 AS apt_ordin14, p.apt_ordin15 AS apt_ordin15, p.apt_ordin16 AS apt_ordin16, p.apt_ordin17 AS apt_ordin17, p.apt_ordin18 AS apt_ordin18, p.apt_ordin19 AS apt_ordin19, p.apt_ordin20 AS apt_ordin20, p.apt_ordin21 AS apt_ordin21, p.apt_ordin22 AS apt_ordin22, p.apt_ordin23 AS apt_ordin23, p.apt_ordin24 AS apt_ordin24, p.apt_impeg01 AS apt_impeg01, p.apt_impeg02 AS apt_impeg02, p.apt_impeg03 AS apt_impeg03, p.apt_impeg04 AS apt_impeg04, p.apt_impeg05 AS apt_impeg05, p.apt_impeg06 AS apt_impeg06, p.apt_impeg07 AS apt_impeg07, p.apt_impeg08 AS apt_impeg08, p.apt_impeg09 AS apt_impeg09, p.apt_impeg10 AS apt_impeg10, p.apt_impeg11 AS apt_impeg11, p.apt_impeg12 AS apt_impeg12, p.apt_impeg13 AS apt_impeg13, p.apt_impeg14 AS apt_impeg14, p.apt_impeg15 AS apt_impeg15, p.apt_impeg16 AS apt_impeg16, p.apt_impeg17 AS apt_impeg17, p.apt_impeg18 AS apt_impeg18, p.apt_impeg19 AS apt_impeg19, p.apt_impeg20 AS apt_impeg20, p.apt_impeg21 AS apt_impeg21, p.apt_impeg22 AS apt_impeg22, p.apt_impeg23 AS apt_impeg23, p.apt_impeg24 AS apt_impeg24, p.apt_prenot01 AS apt_prenot01, p.apt_prenot02 AS apt_prenot02, p.apt_prenot03 AS apt_prenot03, p.apt_prenot04 AS apt_prenot04, p.apt_prenot05 AS apt_prenot05, p.apt_prenot06 AS apt_prenot06, p.apt_prenot07 AS apt_prenot07, p.apt_prenot08 AS apt_prenot08, p.apt_prenot09 AS apt_prenot09, p.apt_prenot10 AS apt_prenot10, p.apt_prenot11 AS apt_prenot11, p.apt_prenot12 AS apt_prenot12, p.apt_prenot13 AS apt_prenot13, p.apt_prenot14 AS apt_prenot14, p.apt_prenot15 AS apt_prenot15, p.apt_prenot16 AS apt_prenot16, p.apt_prenot17 AS apt_prenot17, p.apt_prenot18 AS apt_prenot18, p.apt_prenot19 AS apt_prenot19, p.apt_prenot20 AS apt_prenot20, p.apt_prenot21 AS apt_prenot21, p.apt_prenot22 AS apt_prenot22, p.apt_prenot23 AS apt_prenot23, p.apt_prenot24 AS apt_prenot24, s.tb_dest01 AS tb_dest01, s.tb_dest02 AS tb_dest02, s.tb_dest03 AS tb_dest03, s.tb_dest04 AS tb_dest04, s.tb_dest05 AS tb_dest05, s.tb_dest06 AS tb_dest06, s.tb_dest07 AS tb_dest07, s.tb_dest08 AS tb_dest08, s.tb_dest09 AS tb_dest09, s.tb_dest10 AS tb_dest10, s.tb_dest11 AS tb_dest11, s.tb_dest12 AS tb_dest12, s.tb_dest13 AS tb_dest13, s.tb_dest14 AS tb_dest14, s.tb_dest15 AS tb_dest15, s.tb_dest16 AS tb_dest16, s.tb_dest17 AS tb_dest17, s.tb_dest18 AS tb_dest18, s.tb_dest19 AS tb_dest19, s.tb_dest20 AS tb_dest20, s.tb_dest21 AS tb_dest21, s.tb_dest22 AS tb_dest22, s.tb_dest23 AS tb_dest23, s.tb_dest24 AS tb_dest24 FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), 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.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article))) AND p.apt_magaz=:warehouse), SizeRows AS (SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 1 AS SlotPosition, r.tb_dest01 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',1,N'|') AS SizeKey, r.apt_esist01 AS PhysicalStock, r.apt_ordin01 AS SupplierOrdered, r.apt_impeg01 AS CustomerCommitted, r.apt_prenot01 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 2 AS SlotPosition, r.tb_dest02 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',2,N'|') AS SizeKey, r.apt_esist02 AS PhysicalStock, r.apt_ordin02 AS SupplierOrdered, r.apt_impeg02 AS CustomerCommitted, r.apt_prenot02 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 3 AS SlotPosition, r.tb_dest03 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',3,N'|') AS SizeKey, r.apt_esist03 AS PhysicalStock, r.apt_ordin03 AS SupplierOrdered, r.apt_impeg03 AS CustomerCommitted, r.apt_prenot03 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 4 AS SlotPosition, r.tb_dest04 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',4,N'|') AS SizeKey, r.apt_esist04 AS PhysicalStock, r.apt_ordin04 AS SupplierOrdered, r.apt_impeg04 AS CustomerCommitted, r.apt_prenot04 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 5 AS SlotPosition, r.tb_dest05 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',5,N'|') AS SizeKey, r.apt_esist05 AS PhysicalStock, r.apt_ordin05 AS SupplierOrdered, r.apt_impeg05 AS CustomerCommitted, r.apt_prenot05 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 6 AS SlotPosition, r.tb_dest06 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',6,N'|') AS SizeKey, r.apt_esist06 AS PhysicalStock, r.apt_ordin06 AS SupplierOrdered, r.apt_impeg06 AS CustomerCommitted, r.apt_prenot06 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 7 AS SlotPosition, r.tb_dest07 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',7,N'|') AS SizeKey, r.apt_esist07 AS PhysicalStock, r.apt_ordin07 AS SupplierOrdered, r.apt_impeg07 AS CustomerCommitted, r.apt_prenot07 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 8 AS SlotPosition, r.tb_dest08 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',8,N'|') AS SizeKey, r.apt_esist08 AS PhysicalStock, r.apt_ordin08 AS SupplierOrdered, r.apt_impeg08 AS CustomerCommitted, r.apt_prenot08 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 9 AS SlotPosition, r.tb_dest09 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',9,N'|') AS SizeKey, r.apt_esist09 AS PhysicalStock, r.apt_ordin09 AS SupplierOrdered, r.apt_impeg09 AS CustomerCommitted, r.apt_prenot09 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 10 AS SlotPosition, r.tb_dest10 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',10,N'|') AS SizeKey, r.apt_esist10 AS PhysicalStock, r.apt_ordin10 AS SupplierOrdered, r.apt_impeg10 AS CustomerCommitted, r.apt_prenot10 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 11 AS SlotPosition, r.tb_dest11 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',11,N'|') AS SizeKey, r.apt_esist11 AS PhysicalStock, r.apt_ordin11 AS SupplierOrdered, r.apt_impeg11 AS CustomerCommitted, r.apt_prenot11 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 12 AS SlotPosition, r.tb_dest12 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',12,N'|') AS SizeKey, r.apt_esist12 AS PhysicalStock, r.apt_ordin12 AS SupplierOrdered, r.apt_impeg12 AS CustomerCommitted, r.apt_prenot12 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 13 AS SlotPosition, r.tb_dest13 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',13,N'|') AS SizeKey, r.apt_esist13 AS PhysicalStock, r.apt_ordin13 AS SupplierOrdered, r.apt_impeg13 AS CustomerCommitted, r.apt_prenot13 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 14 AS SlotPosition, r.tb_dest14 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',14,N'|') AS SizeKey, r.apt_esist14 AS PhysicalStock, r.apt_ordin14 AS SupplierOrdered, r.apt_impeg14 AS CustomerCommitted, r.apt_prenot14 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 15 AS SlotPosition, r.tb_dest15 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',15,N'|') AS SizeKey, r.apt_esist15 AS PhysicalStock, r.apt_ordin15 AS SupplierOrdered, r.apt_impeg15 AS CustomerCommitted, r.apt_prenot15 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 16 AS SlotPosition, r.tb_dest16 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',16,N'|') AS SizeKey, r.apt_esist16 AS PhysicalStock, r.apt_ordin16 AS SupplierOrdered, r.apt_impeg16 AS CustomerCommitted, r.apt_prenot16 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 17 AS SlotPosition, r.tb_dest17 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',17,N'|') AS SizeKey, r.apt_esist17 AS PhysicalStock, r.apt_ordin17 AS SupplierOrdered, r.apt_impeg17 AS CustomerCommitted, r.apt_prenot17 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 18 AS SlotPosition, r.tb_dest18 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',18,N'|') AS SizeKey, r.apt_esist18 AS PhysicalStock, r.apt_ordin18 AS SupplierOrdered, r.apt_impeg18 AS CustomerCommitted, r.apt_prenot18 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 19 AS SlotPosition, r.tb_dest19 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',19,N'|') AS SizeKey, r.apt_esist19 AS PhysicalStock, r.apt_ordin19 AS SupplierOrdered, r.apt_impeg19 AS CustomerCommitted, r.apt_prenot19 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 20 AS SlotPosition, r.tb_dest20 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',20,N'|') AS SizeKey, r.apt_esist20 AS PhysicalStock, r.apt_ordin20 AS SupplierOrdered, r.apt_impeg20 AS CustomerCommitted, r.apt_prenot20 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 21 AS SlotPosition, r.tb_dest21 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',21,N'|') AS SizeKey, r.apt_esist21 AS PhysicalStock, r.apt_ordin21 AS SupplierOrdered, r.apt_impeg21 AS CustomerCommitted, r.apt_prenot21 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 22 AS SlotPosition, r.tb_dest22 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',22,N'|') AS SizeKey, r.apt_esist22 AS PhysicalStock, r.apt_ordin22 AS SupplierOrdered, r.apt_impeg22 AS CustomerCommitted, r.apt_prenot22 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 23 AS SlotPosition, r.tb_dest23 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',23,N'|') AS SizeKey, r.apt_esist23 AS PhysicalStock, r.apt_ordin23 AS SupplierOrdered, r.apt_impeg23 AS CustomerCommitted, r.apt_prenot23 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 24 AS SlotPosition, r.tb_dest24 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',24,N'|') AS SizeKey, r.apt_esist24 AS PhysicalStock, r.apt_ordin24 AS SupplierOrdered, r.apt_impeg24 AS CustomerCommitted, r.apt_prenot24 AS ShipmentReserved FROM StockSource r), CheckedSizes AS (SELECT k.*, CASE WHEN k.SizeLabel IS NOT NULL AND DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))>0 AND (SELECT COUNT(*) FROM SizeRows z WHERE (CONVERT(nvarchar(4000), z.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))))=1 THEN 1 ELSE 0 END AS SizeLookupAllowed FROM SizeRows k) SELECT k.SizeKey AS SizeKey, k.ParentStockKey AS ParentStockKey, k.codditt AS codditt, k.apt_codart AS apt_codart, k.apt_magaz AS apt_magaz, k.ProductName AS ProductName, k.WarehouseName AS WarehouseName, k.CurrentPrimaryUnit AS CurrentPrimaryUnit, k.BrandName AS BrandName, k.SeasonName AS SeasonName, k.ScaleCode AS ScaleCode, k.ScaleName AS ScaleName, k.ProductAvailability AS ProductAvailability, k.WarehouseAvailability AS WarehouseAvailability, k.ScaleAvailability AS ScaleAvailability, k.StockUpdatedAt AS StockUpdatedAt, k.UnitNotice AS UnitNotice, k.SlotPosition AS SlotPosition, k.SizeLabel AS SizeLabel, k.SizeLookupAllowed AS SizeLookupAllowed, CONCAT(k.ProductName,N' · taglia ',CASE WHEN k.SizeLabel IS NULL OR DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))=0 THEN N'non definita' ELSE k.SizeLabel END,N' · posizione ',k.SlotPosition) AS SizeTitle, CASE WHEN k.SizeLabel IS NULL THEN N'NULL: barcode escluso' WHEN DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))=0 THEN N'Vuota: barcode escluso' WHEN k.SizeLookupAllowed=0 THEN N'Duplicata: barcode escluso' ELSE N'Univoca' END AS SizeLabelState, REPLACE(CONVERT(nvarchar(4000), k.PhysicalStock, 3),N'.',N',') AS PhysicalStock, REPLACE(CONVERT(nvarchar(4000), k.SupplierOrdered, 3),N'.',N',') AS SupplierOrdered, REPLACE(CONVERT(nvarchar(4000), k.CustomerCommitted, 3),N'.',N',') AS CustomerCommitted, REPLACE(CONVERT(nvarchar(4000), k.ShipmentReserved, 3),N'.',N',') AS ShipmentReserved FROM CheckedSizes k
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, 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'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQueryWITH StockSource AS (SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS ParentStockKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, p.apt_esist01 AS apt_esist01, p.apt_esist02 AS apt_esist02, p.apt_esist03 AS apt_esist03, p.apt_esist04 AS apt_esist04, p.apt_esist05 AS apt_esist05, p.apt_esist06 AS apt_esist06, p.apt_esist07 AS apt_esist07, p.apt_esist08 AS apt_esist08, p.apt_esist09 AS apt_esist09, p.apt_esist10 AS apt_esist10, p.apt_esist11 AS apt_esist11, p.apt_esist12 AS apt_esist12, p.apt_esist13 AS apt_esist13, p.apt_esist14 AS apt_esist14, p.apt_esist15 AS apt_esist15, p.apt_esist16 AS apt_esist16, p.apt_esist17 AS apt_esist17, p.apt_esist18 AS apt_esist18, p.apt_esist19 AS apt_esist19, p.apt_esist20 AS apt_esist20, p.apt_esist21 AS apt_esist21, p.apt_esist22 AS apt_esist22, p.apt_esist23 AS apt_esist23, p.apt_esist24 AS apt_esist24, p.apt_ordin01 AS apt_ordin01, p.apt_ordin02 AS apt_ordin02, p.apt_ordin03 AS apt_ordin03, p.apt_ordin04 AS apt_ordin04, p.apt_ordin05 AS apt_ordin05, p.apt_ordin06 AS apt_ordin06, p.apt_ordin07 AS apt_ordin07, p.apt_ordin08 AS apt_ordin08, p.apt_ordin09 AS apt_ordin09, p.apt_ordin10 AS apt_ordin10, p.apt_ordin11 AS apt_ordin11, p.apt_ordin12 AS apt_ordin12, p.apt_ordin13 AS apt_ordin13, p.apt_ordin14 AS apt_ordin14, p.apt_ordin15 AS apt_ordin15, p.apt_ordin16 AS apt_ordin16, p.apt_ordin17 AS apt_ordin17, p.apt_ordin18 AS apt_ordin18, p.apt_ordin19 AS apt_ordin19, p.apt_ordin20 AS apt_ordin20, p.apt_ordin21 AS apt_ordin21, p.apt_ordin22 AS apt_ordin22, p.apt_ordin23 AS apt_ordin23, p.apt_ordin24 AS apt_ordin24, p.apt_impeg01 AS apt_impeg01, p.apt_impeg02 AS apt_impeg02, p.apt_impeg03 AS apt_impeg03, p.apt_impeg04 AS apt_impeg04, p.apt_impeg05 AS apt_impeg05, p.apt_impeg06 AS apt_impeg06, p.apt_impeg07 AS apt_impeg07, p.apt_impeg08 AS apt_impeg08, p.apt_impeg09 AS apt_impeg09, p.apt_impeg10 AS apt_impeg10, p.apt_impeg11 AS apt_impeg11, p.apt_impeg12 AS apt_impeg12, p.apt_impeg13 AS apt_impeg13, p.apt_impeg14 AS apt_impeg14, p.apt_impeg15 AS apt_impeg15, p.apt_impeg16 AS apt_impeg16, p.apt_impeg17 AS apt_impeg17, p.apt_impeg18 AS apt_impeg18, p.apt_impeg19 AS apt_impeg19, p.apt_impeg20 AS apt_impeg20, p.apt_impeg21 AS apt_impeg21, p.apt_impeg22 AS apt_impeg22, p.apt_impeg23 AS apt_impeg23, p.apt_impeg24 AS apt_impeg24, p.apt_prenot01 AS apt_prenot01, p.apt_prenot02 AS apt_prenot02, p.apt_prenot03 AS apt_prenot03, p.apt_prenot04 AS apt_prenot04, p.apt_prenot05 AS apt_prenot05, p.apt_prenot06 AS apt_prenot06, p.apt_prenot07 AS apt_prenot07, p.apt_prenot08 AS apt_prenot08, p.apt_prenot09 AS apt_prenot09, p.apt_prenot10 AS apt_prenot10, p.apt_prenot11 AS apt_prenot11, p.apt_prenot12 AS apt_prenot12, p.apt_prenot13 AS apt_prenot13, p.apt_prenot14 AS apt_prenot14, p.apt_prenot15 AS apt_prenot15, p.apt_prenot16 AS apt_prenot16, p.apt_prenot17 AS apt_prenot17, p.apt_prenot18 AS apt_prenot18, p.apt_prenot19 AS apt_prenot19, p.apt_prenot20 AS apt_prenot20, p.apt_prenot21 AS apt_prenot21, p.apt_prenot22 AS apt_prenot22, p.apt_prenot23 AS apt_prenot23, p.apt_prenot24 AS apt_prenot24, s.tb_dest01 AS tb_dest01, s.tb_dest02 AS tb_dest02, s.tb_dest03 AS tb_dest03, s.tb_dest04 AS tb_dest04, s.tb_dest05 AS tb_dest05, s.tb_dest06 AS tb_dest06, s.tb_dest07 AS tb_dest07, s.tb_dest08 AS tb_dest08, s.tb_dest09 AS tb_dest09, s.tb_dest10 AS tb_dest10, s.tb_dest11 AS tb_dest11, s.tb_dest12 AS tb_dest12, s.tb_dest13 AS tb_dest13, s.tb_dest14 AS tb_dest14, s.tb_dest15 AS tb_dest15, s.tb_dest16 AS tb_dest16, s.tb_dest17 AS tb_dest17, s.tb_dest18 AS tb_dest18, s.tb_dest19 AS tb_dest19, s.tb_dest20 AS tb_dest20, s.tb_dest21 AS tb_dest21, s.tb_dest22 AS tb_dest22, s.tb_dest23 AS tb_dest23, s.tb_dest24 AS tb_dest24 FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), 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.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article))) AND p.apt_magaz=:warehouse), SizeRows AS (SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 1 AS SlotPosition, r.tb_dest01 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',1,N'|') AS SizeKey, r.apt_esist01 AS PhysicalStock, r.apt_ordin01 AS SupplierOrdered, r.apt_impeg01 AS CustomerCommitted, r.apt_prenot01 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 2 AS SlotPosition, r.tb_dest02 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',2,N'|') AS SizeKey, r.apt_esist02 AS PhysicalStock, r.apt_ordin02 AS SupplierOrdered, r.apt_impeg02 AS CustomerCommitted, r.apt_prenot02 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 3 AS SlotPosition, r.tb_dest03 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',3,N'|') AS SizeKey, r.apt_esist03 AS PhysicalStock, r.apt_ordin03 AS SupplierOrdered, r.apt_impeg03 AS CustomerCommitted, r.apt_prenot03 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 4 AS SlotPosition, r.tb_dest04 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',4,N'|') AS SizeKey, r.apt_esist04 AS PhysicalStock, r.apt_ordin04 AS SupplierOrdered, r.apt_impeg04 AS CustomerCommitted, r.apt_prenot04 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 5 AS SlotPosition, r.tb_dest05 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',5,N'|') AS SizeKey, r.apt_esist05 AS PhysicalStock, r.apt_ordin05 AS SupplierOrdered, r.apt_impeg05 AS CustomerCommitted, r.apt_prenot05 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 6 AS SlotPosition, r.tb_dest06 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',6,N'|') AS SizeKey, r.apt_esist06 AS PhysicalStock, r.apt_ordin06 AS SupplierOrdered, r.apt_impeg06 AS CustomerCommitted, r.apt_prenot06 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 7 AS SlotPosition, r.tb_dest07 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',7,N'|') AS SizeKey, r.apt_esist07 AS PhysicalStock, r.apt_ordin07 AS SupplierOrdered, r.apt_impeg07 AS CustomerCommitted, r.apt_prenot07 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 8 AS SlotPosition, r.tb_dest08 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',8,N'|') AS SizeKey, r.apt_esist08 AS PhysicalStock, r.apt_ordin08 AS SupplierOrdered, r.apt_impeg08 AS CustomerCommitted, r.apt_prenot08 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 9 AS SlotPosition, r.tb_dest09 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',9,N'|') AS SizeKey, r.apt_esist09 AS PhysicalStock, r.apt_ordin09 AS SupplierOrdered, r.apt_impeg09 AS CustomerCommitted, r.apt_prenot09 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 10 AS SlotPosition, r.tb_dest10 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',10,N'|') AS SizeKey, r.apt_esist10 AS PhysicalStock, r.apt_ordin10 AS SupplierOrdered, r.apt_impeg10 AS CustomerCommitted, r.apt_prenot10 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 11 AS SlotPosition, r.tb_dest11 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',11,N'|') AS SizeKey, r.apt_esist11 AS PhysicalStock, r.apt_ordin11 AS SupplierOrdered, r.apt_impeg11 AS CustomerCommitted, r.apt_prenot11 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 12 AS SlotPosition, r.tb_dest12 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',12,N'|') AS SizeKey, r.apt_esist12 AS PhysicalStock, r.apt_ordin12 AS SupplierOrdered, r.apt_impeg12 AS CustomerCommitted, r.apt_prenot12 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 13 AS SlotPosition, r.tb_dest13 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',13,N'|') AS SizeKey, r.apt_esist13 AS PhysicalStock, r.apt_ordin13 AS SupplierOrdered, r.apt_impeg13 AS CustomerCommitted, r.apt_prenot13 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 14 AS SlotPosition, r.tb_dest14 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',14,N'|') AS SizeKey, r.apt_esist14 AS PhysicalStock, r.apt_ordin14 AS SupplierOrdered, r.apt_impeg14 AS CustomerCommitted, r.apt_prenot14 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 15 AS SlotPosition, r.tb_dest15 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',15,N'|') AS SizeKey, r.apt_esist15 AS PhysicalStock, r.apt_ordin15 AS SupplierOrdered, r.apt_impeg15 AS CustomerCommitted, r.apt_prenot15 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 16 AS SlotPosition, r.tb_dest16 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',16,N'|') AS SizeKey, r.apt_esist16 AS PhysicalStock, r.apt_ordin16 AS SupplierOrdered, r.apt_impeg16 AS CustomerCommitted, r.apt_prenot16 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 17 AS SlotPosition, r.tb_dest17 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',17,N'|') AS SizeKey, r.apt_esist17 AS PhysicalStock, r.apt_ordin17 AS SupplierOrdered, r.apt_impeg17 AS CustomerCommitted, r.apt_prenot17 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 18 AS SlotPosition, r.tb_dest18 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',18,N'|') AS SizeKey, r.apt_esist18 AS PhysicalStock, r.apt_ordin18 AS SupplierOrdered, r.apt_impeg18 AS CustomerCommitted, r.apt_prenot18 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 19 AS SlotPosition, r.tb_dest19 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',19,N'|') AS SizeKey, r.apt_esist19 AS PhysicalStock, r.apt_ordin19 AS SupplierOrdered, r.apt_impeg19 AS CustomerCommitted, r.apt_prenot19 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 20 AS SlotPosition, r.tb_dest20 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',20,N'|') AS SizeKey, r.apt_esist20 AS PhysicalStock, r.apt_ordin20 AS SupplierOrdered, r.apt_impeg20 AS CustomerCommitted, r.apt_prenot20 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 21 AS SlotPosition, r.tb_dest21 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',21,N'|') AS SizeKey, r.apt_esist21 AS PhysicalStock, r.apt_ordin21 AS SupplierOrdered, r.apt_impeg21 AS CustomerCommitted, r.apt_prenot21 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 22 AS SlotPosition, r.tb_dest22 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',22,N'|') AS SizeKey, r.apt_esist22 AS PhysicalStock, r.apt_ordin22 AS SupplierOrdered, r.apt_impeg22 AS CustomerCommitted, r.apt_prenot22 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 23 AS SlotPosition, r.tb_dest23 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',23,N'|') AS SizeKey, r.apt_esist23 AS PhysicalStock, r.apt_ordin23 AS SupplierOrdered, r.apt_impeg23 AS CustomerCommitted, r.apt_prenot23 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 24 AS SlotPosition, r.tb_dest24 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',24,N'|') AS SizeKey, r.apt_esist24 AS PhysicalStock, r.apt_ordin24 AS SupplierOrdered, r.apt_impeg24 AS CustomerCommitted, r.apt_prenot24 AS ShipmentReserved FROM StockSource r), CheckedSizes AS (SELECT k.*, CASE WHEN k.SizeLabel IS NOT NULL AND DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))>0 AND (SELECT COUNT(*) FROM SizeRows z WHERE (CONVERT(nvarchar(4000), z.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))))=1 THEN 1 ELSE 0 END AS SizeLookupAllowed FROM SizeRows k) SELECT CONCAT(DATALENGTH(k.SizeKey),N':',k.SizeKey,N'|',CONCAT(DATALENGTH(CONVERT(nvarchar(4000), b.codditt)),N':',CONVERT(nvarchar(4000), b.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), b.bc_code)),N':',CONVERT(nvarchar(4000), b.bc_code),N'|')) AS SizeBarcodeKey, k.SizeKey AS ParentSizeKey, k.codditt AS codditt, k.apt_codart AS apt_codart, k.apt_magaz AS apt_magaz, k.SlotPosition AS SlotPosition, k.ProductName AS ProductName, k.WarehouseName AS WarehouseName, k.SizeLabel AS SizeLabel, b.bc_code AS bc_code, b.bc_unmis AS bc_unmis, b.bc_tagl AS bc_tagl, N'Codice/U.M./taglia dalla vista BARCODE; magazzino e posizione sono contesto padre, non attributi del barcode' AS BarcodeNotice FROM CheckedSizes k INNER JOIN BARCODE b ON (CONVERT(nvarchar(4000), k.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND (CONVERT(nvarchar(4000), k.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.bc_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), b.bc_codart))) AND (CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.bc_tagl) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), b.bc_tagl))) WHERE b.codditt IS NOT NULL AND b.bc_code IS NOT NULL AND k.SizeLookupAllowed=1 AND k.SlotPosition=:slot
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NTS Business — transito e-commerce autorizzato",
"id": "5500F563-48A4-5050-9A4C-7151A43EB806",
"kind": "sqlServer",
"requiredObjects": [
"ARTPROTC",
"TABTAGL",
"ARTICO",
"TABMAGA",
"BARCODE",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "019E52DE-9E39-546C-A09D-48747EDD5A70",
"key": "ProductName",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"id": "48CAF73C-8228-53C2-9D18-FE2F5B0277A6",
"mappings": [
{
"commonFieldKey": "",
"key": "StockKey",
"label": "Identità interna della giacenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_magaz",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentPrimaryUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SeasonName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ScaleCode",
"label": "Codice scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleCode",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScaleName",
"label": "Scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScaleAvailability",
"label": "Anagrafica scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockUpdatedAt",
"label": "Aggiornamento del progressivo (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockUpdatedAt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitNotice",
"label": "Unità dei progressivi: verificare localmente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitNotice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "PositivePositions",
"label": "Posizioni positive (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PositivePositions",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "NegativePositions",
"label": "Posizioni negative (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "NegativePositions",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ZeroPositions",
"label": "Posizioni zero (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ZeroPositions",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnknownPositions",
"label": "Posizioni NULL (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnknownPositions",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Giacenze articoli per taglia",
"primaryKey": "StockKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"apt_codart",
"ProductName",
"WarehouseName",
"CurrentPrimaryUnit",
"BrandName",
"SeasonName",
"ScaleName",
"ProductAvailability",
"WarehouseAvailability",
"ScaleAvailability",
"StockUpdatedAt",
"UnitNotice"
],
"sourceID": "5500F563-48A4-5050-9A4C-7151A43EB806",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS StockKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|') AS ProductKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, (CASE WHEN p.apt_esist01>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23>0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24>0 THEN 1 ELSE 0 END) AS PositivePositions, (CASE WHEN p.apt_esist01<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23<0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24<0 THEN 1 ELSE 0 END) AS NegativePositions, (CASE WHEN p.apt_esist01=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23=0 THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24=0 THEN 1 ELSE 0 END) AS ZeroPositions, (CASE WHEN p.apt_esist01 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist02 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist03 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist04 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist05 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist06 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist07 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist08 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist09 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist10 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist11 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist12 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist13 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist14 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist15 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist16 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist17 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist18 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist19 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist20 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist21 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist22 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist23 IS NULL THEN 1 ELSE 0 END)+(CASE WHEN p.apt_esist24 IS NULL THEN 1 ELSE 0 END) AS UnknownPositions FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',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')",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "30A7D567-7BEB-5394-A13C-B4A538E74A54",
"key": "SlotPosition",
"type": "number"
},
{
"direction": "ascending",
"id": "50A2ABB6-4348-5200-BF49-61DDA0CAFFFF",
"key": "SizeKey",
"type": "text"
}
],
"id": "8462E4AE-73E8-5880-9024-1726BAC2DEBD",
"mappings": [
{
"commonFieldKey": "",
"key": "SizeKey",
"label": "Identità interna ditta/articolo/magazzino/posizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentStockKey",
"label": "Identità interna padre giacenza",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentStockKey",
"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": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_magaz",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CurrentPrimaryUnit",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"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": "ScaleCode",
"label": "Codice scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleCode",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScaleName",
"label": "Scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ScaleAvailability",
"label": "Anagrafica scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ScaleAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "StockUpdatedAt",
"label": "Aggiornamento del progressivo (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "StockUpdatedAt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UnitNotice",
"label": "Unità dei progressivi: verificare localmente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UnitNotice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SlotPosition",
"label": "Posizione nella scala (1–24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SlotPosition",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SizeLabel",
"label": "Etichetta taglia originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeLabel",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SizeLookupAllowed",
"label": "Controllo interno lookup taglia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeLookupAllowed",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SizeTitle",
"label": "Taglia e posizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeTitle",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SizeLabelState",
"label": "Etichetta per barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeLabelState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "PhysicalStock",
"label": "Esistenza fisica (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "PhysicalStock",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SupplierOrdered",
"label": "Ordinato fornitori (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierOrdered",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "CustomerCommitted",
"label": "Impegnato clienti (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CustomerCommitted",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ShipmentReserved",
"label": "Prenotato spedizioni (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ShipmentReserved",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1000,
"name": "Taglie del magazzino",
"primaryKey": "SizeKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F758A296-2C64-5A5F-8D12-34B964313372",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "apt_codart",
"id": "519E5730-8E5A-5D20-AFFE-D85F9F7E2611",
"name": "article",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "apt_magaz",
"id": "D3568D43-0632-50A9-92A2-BC3168121183",
"name": "warehouse",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"apt_codart",
"ProductName",
"WarehouseName",
"CurrentPrimaryUnit",
"BrandName",
"SeasonName",
"ScaleName",
"ProductAvailability",
"WarehouseAvailability",
"ScaleAvailability",
"StockUpdatedAt",
"UnitNotice",
"SizeLabel",
"SizeTitle",
"SizeLabelState",
"PhysicalStock",
"SupplierOrdered",
"CustomerCommitted",
"ShipmentReserved"
],
"sourceID": "5500F563-48A4-5050-9A4C-7151A43EB806",
"sqlQuery": "WITH StockSource AS (SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS ParentStockKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, p.apt_esist01 AS apt_esist01, p.apt_esist02 AS apt_esist02, p.apt_esist03 AS apt_esist03, p.apt_esist04 AS apt_esist04, p.apt_esist05 AS apt_esist05, p.apt_esist06 AS apt_esist06, p.apt_esist07 AS apt_esist07, p.apt_esist08 AS apt_esist08, p.apt_esist09 AS apt_esist09, p.apt_esist10 AS apt_esist10, p.apt_esist11 AS apt_esist11, p.apt_esist12 AS apt_esist12, p.apt_esist13 AS apt_esist13, p.apt_esist14 AS apt_esist14, p.apt_esist15 AS apt_esist15, p.apt_esist16 AS apt_esist16, p.apt_esist17 AS apt_esist17, p.apt_esist18 AS apt_esist18, p.apt_esist19 AS apt_esist19, p.apt_esist20 AS apt_esist20, p.apt_esist21 AS apt_esist21, p.apt_esist22 AS apt_esist22, p.apt_esist23 AS apt_esist23, p.apt_esist24 AS apt_esist24, p.apt_ordin01 AS apt_ordin01, p.apt_ordin02 AS apt_ordin02, p.apt_ordin03 AS apt_ordin03, p.apt_ordin04 AS apt_ordin04, p.apt_ordin05 AS apt_ordin05, p.apt_ordin06 AS apt_ordin06, p.apt_ordin07 AS apt_ordin07, p.apt_ordin08 AS apt_ordin08, p.apt_ordin09 AS apt_ordin09, p.apt_ordin10 AS apt_ordin10, p.apt_ordin11 AS apt_ordin11, p.apt_ordin12 AS apt_ordin12, p.apt_ordin13 AS apt_ordin13, p.apt_ordin14 AS apt_ordin14, p.apt_ordin15 AS apt_ordin15, p.apt_ordin16 AS apt_ordin16, p.apt_ordin17 AS apt_ordin17, p.apt_ordin18 AS apt_ordin18, p.apt_ordin19 AS apt_ordin19, p.apt_ordin20 AS apt_ordin20, p.apt_ordin21 AS apt_ordin21, p.apt_ordin22 AS apt_ordin22, p.apt_ordin23 AS apt_ordin23, p.apt_ordin24 AS apt_ordin24, p.apt_impeg01 AS apt_impeg01, p.apt_impeg02 AS apt_impeg02, p.apt_impeg03 AS apt_impeg03, p.apt_impeg04 AS apt_impeg04, p.apt_impeg05 AS apt_impeg05, p.apt_impeg06 AS apt_impeg06, p.apt_impeg07 AS apt_impeg07, p.apt_impeg08 AS apt_impeg08, p.apt_impeg09 AS apt_impeg09, p.apt_impeg10 AS apt_impeg10, p.apt_impeg11 AS apt_impeg11, p.apt_impeg12 AS apt_impeg12, p.apt_impeg13 AS apt_impeg13, p.apt_impeg14 AS apt_impeg14, p.apt_impeg15 AS apt_impeg15, p.apt_impeg16 AS apt_impeg16, p.apt_impeg17 AS apt_impeg17, p.apt_impeg18 AS apt_impeg18, p.apt_impeg19 AS apt_impeg19, p.apt_impeg20 AS apt_impeg20, p.apt_impeg21 AS apt_impeg21, p.apt_impeg22 AS apt_impeg22, p.apt_impeg23 AS apt_impeg23, p.apt_impeg24 AS apt_impeg24, p.apt_prenot01 AS apt_prenot01, p.apt_prenot02 AS apt_prenot02, p.apt_prenot03 AS apt_prenot03, p.apt_prenot04 AS apt_prenot04, p.apt_prenot05 AS apt_prenot05, p.apt_prenot06 AS apt_prenot06, p.apt_prenot07 AS apt_prenot07, p.apt_prenot08 AS apt_prenot08, p.apt_prenot09 AS apt_prenot09, p.apt_prenot10 AS apt_prenot10, p.apt_prenot11 AS apt_prenot11, p.apt_prenot12 AS apt_prenot12, p.apt_prenot13 AS apt_prenot13, p.apt_prenot14 AS apt_prenot14, p.apt_prenot15 AS apt_prenot15, p.apt_prenot16 AS apt_prenot16, p.apt_prenot17 AS apt_prenot17, p.apt_prenot18 AS apt_prenot18, p.apt_prenot19 AS apt_prenot19, p.apt_prenot20 AS apt_prenot20, p.apt_prenot21 AS apt_prenot21, p.apt_prenot22 AS apt_prenot22, p.apt_prenot23 AS apt_prenot23, p.apt_prenot24 AS apt_prenot24, s.tb_dest01 AS tb_dest01, s.tb_dest02 AS tb_dest02, s.tb_dest03 AS tb_dest03, s.tb_dest04 AS tb_dest04, s.tb_dest05 AS tb_dest05, s.tb_dest06 AS tb_dest06, s.tb_dest07 AS tb_dest07, s.tb_dest08 AS tb_dest08, s.tb_dest09 AS tb_dest09, s.tb_dest10 AS tb_dest10, s.tb_dest11 AS tb_dest11, s.tb_dest12 AS tb_dest12, s.tb_dest13 AS tb_dest13, s.tb_dest14 AS tb_dest14, s.tb_dest15 AS tb_dest15, s.tb_dest16 AS tb_dest16, s.tb_dest17 AS tb_dest17, s.tb_dest18 AS tb_dest18, s.tb_dest19 AS tb_dest19, s.tb_dest20 AS tb_dest20, s.tb_dest21 AS tb_dest21, s.tb_dest22 AS tb_dest22, s.tb_dest23 AS tb_dest23, s.tb_dest24 AS tb_dest24 FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), 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.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article))) AND p.apt_magaz=:warehouse), SizeRows AS (SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 1 AS SlotPosition, r.tb_dest01 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',1,N'|') AS SizeKey, r.apt_esist01 AS PhysicalStock, r.apt_ordin01 AS SupplierOrdered, r.apt_impeg01 AS CustomerCommitted, r.apt_prenot01 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 2 AS SlotPosition, r.tb_dest02 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',2,N'|') AS SizeKey, r.apt_esist02 AS PhysicalStock, r.apt_ordin02 AS SupplierOrdered, r.apt_impeg02 AS CustomerCommitted, r.apt_prenot02 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 3 AS SlotPosition, r.tb_dest03 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',3,N'|') AS SizeKey, r.apt_esist03 AS PhysicalStock, r.apt_ordin03 AS SupplierOrdered, r.apt_impeg03 AS CustomerCommitted, r.apt_prenot03 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 4 AS SlotPosition, r.tb_dest04 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',4,N'|') AS SizeKey, r.apt_esist04 AS PhysicalStock, r.apt_ordin04 AS SupplierOrdered, r.apt_impeg04 AS CustomerCommitted, r.apt_prenot04 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 5 AS SlotPosition, r.tb_dest05 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',5,N'|') AS SizeKey, r.apt_esist05 AS PhysicalStock, r.apt_ordin05 AS SupplierOrdered, r.apt_impeg05 AS CustomerCommitted, r.apt_prenot05 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 6 AS SlotPosition, r.tb_dest06 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',6,N'|') AS SizeKey, r.apt_esist06 AS PhysicalStock, r.apt_ordin06 AS SupplierOrdered, r.apt_impeg06 AS CustomerCommitted, r.apt_prenot06 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 7 AS SlotPosition, r.tb_dest07 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',7,N'|') AS SizeKey, r.apt_esist07 AS PhysicalStock, r.apt_ordin07 AS SupplierOrdered, r.apt_impeg07 AS CustomerCommitted, r.apt_prenot07 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 8 AS SlotPosition, r.tb_dest08 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',8,N'|') AS SizeKey, r.apt_esist08 AS PhysicalStock, r.apt_ordin08 AS SupplierOrdered, r.apt_impeg08 AS CustomerCommitted, r.apt_prenot08 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 9 AS SlotPosition, r.tb_dest09 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',9,N'|') AS SizeKey, r.apt_esist09 AS PhysicalStock, r.apt_ordin09 AS SupplierOrdered, r.apt_impeg09 AS CustomerCommitted, r.apt_prenot09 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 10 AS SlotPosition, r.tb_dest10 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',10,N'|') AS SizeKey, r.apt_esist10 AS PhysicalStock, r.apt_ordin10 AS SupplierOrdered, r.apt_impeg10 AS CustomerCommitted, r.apt_prenot10 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 11 AS SlotPosition, r.tb_dest11 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',11,N'|') AS SizeKey, r.apt_esist11 AS PhysicalStock, r.apt_ordin11 AS SupplierOrdered, r.apt_impeg11 AS CustomerCommitted, r.apt_prenot11 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 12 AS SlotPosition, r.tb_dest12 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',12,N'|') AS SizeKey, r.apt_esist12 AS PhysicalStock, r.apt_ordin12 AS SupplierOrdered, r.apt_impeg12 AS CustomerCommitted, r.apt_prenot12 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 13 AS SlotPosition, r.tb_dest13 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',13,N'|') AS SizeKey, r.apt_esist13 AS PhysicalStock, r.apt_ordin13 AS SupplierOrdered, r.apt_impeg13 AS CustomerCommitted, r.apt_prenot13 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 14 AS SlotPosition, r.tb_dest14 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',14,N'|') AS SizeKey, r.apt_esist14 AS PhysicalStock, r.apt_ordin14 AS SupplierOrdered, r.apt_impeg14 AS CustomerCommitted, r.apt_prenot14 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 15 AS SlotPosition, r.tb_dest15 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',15,N'|') AS SizeKey, r.apt_esist15 AS PhysicalStock, r.apt_ordin15 AS SupplierOrdered, r.apt_impeg15 AS CustomerCommitted, r.apt_prenot15 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 16 AS SlotPosition, r.tb_dest16 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',16,N'|') AS SizeKey, r.apt_esist16 AS PhysicalStock, r.apt_ordin16 AS SupplierOrdered, r.apt_impeg16 AS CustomerCommitted, r.apt_prenot16 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 17 AS SlotPosition, r.tb_dest17 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',17,N'|') AS SizeKey, r.apt_esist17 AS PhysicalStock, r.apt_ordin17 AS SupplierOrdered, r.apt_impeg17 AS CustomerCommitted, r.apt_prenot17 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 18 AS SlotPosition, r.tb_dest18 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',18,N'|') AS SizeKey, r.apt_esist18 AS PhysicalStock, r.apt_ordin18 AS SupplierOrdered, r.apt_impeg18 AS CustomerCommitted, r.apt_prenot18 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 19 AS SlotPosition, r.tb_dest19 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',19,N'|') AS SizeKey, r.apt_esist19 AS PhysicalStock, r.apt_ordin19 AS SupplierOrdered, r.apt_impeg19 AS CustomerCommitted, r.apt_prenot19 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 20 AS SlotPosition, r.tb_dest20 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',20,N'|') AS SizeKey, r.apt_esist20 AS PhysicalStock, r.apt_ordin20 AS SupplierOrdered, r.apt_impeg20 AS CustomerCommitted, r.apt_prenot20 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 21 AS SlotPosition, r.tb_dest21 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',21,N'|') AS SizeKey, r.apt_esist21 AS PhysicalStock, r.apt_ordin21 AS SupplierOrdered, r.apt_impeg21 AS CustomerCommitted, r.apt_prenot21 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 22 AS SlotPosition, r.tb_dest22 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',22,N'|') AS SizeKey, r.apt_esist22 AS PhysicalStock, r.apt_ordin22 AS SupplierOrdered, r.apt_impeg22 AS CustomerCommitted, r.apt_prenot22 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 23 AS SlotPosition, r.tb_dest23 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',23,N'|') AS SizeKey, r.apt_esist23 AS PhysicalStock, r.apt_ordin23 AS SupplierOrdered, r.apt_impeg23 AS CustomerCommitted, r.apt_prenot23 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 24 AS SlotPosition, r.tb_dest24 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',24,N'|') AS SizeKey, r.apt_esist24 AS PhysicalStock, r.apt_ordin24 AS SupplierOrdered, r.apt_impeg24 AS CustomerCommitted, r.apt_prenot24 AS ShipmentReserved FROM StockSource r), CheckedSizes AS (SELECT k.*, CASE WHEN k.SizeLabel IS NOT NULL AND DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))>0 AND (SELECT COUNT(*) FROM SizeRows z WHERE (CONVERT(nvarchar(4000), z.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))))=1 THEN 1 ELSE 0 END AS SizeLookupAllowed FROM SizeRows k) SELECT k.SizeKey AS SizeKey, k.ParentStockKey AS ParentStockKey, k.codditt AS codditt, k.apt_codart AS apt_codart, k.apt_magaz AS apt_magaz, k.ProductName AS ProductName, k.WarehouseName AS WarehouseName, k.CurrentPrimaryUnit AS CurrentPrimaryUnit, k.BrandName AS BrandName, k.SeasonName AS SeasonName, k.ScaleCode AS ScaleCode, k.ScaleName AS ScaleName, k.ProductAvailability AS ProductAvailability, k.WarehouseAvailability AS WarehouseAvailability, k.ScaleAvailability AS ScaleAvailability, k.StockUpdatedAt AS StockUpdatedAt, k.UnitNotice AS UnitNotice, k.SlotPosition AS SlotPosition, k.SizeLabel AS SizeLabel, k.SizeLookupAllowed AS SizeLookupAllowed, CONCAT(k.ProductName,N' · taglia ',CASE WHEN k.SizeLabel IS NULL OR DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))=0 THEN N'non definita' ELSE k.SizeLabel END,N' · posizione ',k.SlotPosition) AS SizeTitle, CASE WHEN k.SizeLabel IS NULL THEN N'NULL: barcode escluso' WHEN DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))=0 THEN N'Vuota: barcode escluso' WHEN k.SizeLookupAllowed=0 THEN N'Duplicata: barcode escluso' ELSE N'Univoca' END AS SizeLabelState, REPLACE(CONVERT(nvarchar(4000), k.PhysicalStock, 3),N'.',N',') AS PhysicalStock, REPLACE(CONVERT(nvarchar(4000), k.SupplierOrdered, 3),N'.',N',') AS SupplierOrdered, REPLACE(CONVERT(nvarchar(4000), k.CustomerCommitted, 3),N'.',N',') AS CustomerCommitted, REPLACE(CONVERT(nvarchar(4000), k.ShipmentReserved, 3),N'.',N',') AS ShipmentReserved FROM CheckedSizes k",
"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": "CB231733-504A-5887-B006-2697D5C8E97A",
"mappings": [
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codalt",
"label": "Codice alternativo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codalt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_descr",
"label": "Descrizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_descr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_desint",
"label": "Descrizione estesa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_desint",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ar_confez2",
"label": "U.M. confezione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_confez2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_qtacon2",
"label": "Rapporto confezione/principale — moltiplicatore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_qtacon2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_unmis2",
"label": "U.M. secondaria",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_unmis2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_conver",
"label": "Rapporto principale/secondaria — divisore",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_conver",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codiva",
"label": "Codice IVA, non aliquota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codiva",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesonet",
"label": "Peso netto nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesonet",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_pesolor",
"label": "Peso lordo nativo — verificare unità",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_pesolor",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_forn",
"label": "Codice fornitore abituale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_forn",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codroot",
"label": "Codice radice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codroot",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar1",
"label": "Variante 1",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar2",
"label": "Variante 2",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codvar3",
"label": "Variante 3",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codvar3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codtagl",
"label": "Codice scala taglie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codtagl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_anno",
"label": "Anno taglie/colori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla1",
"label": "Classificazione 1 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla1",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla2",
"label": "Classificazione 2 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla3",
"label": "Classificazione 3 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla3",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla4",
"label": "Classificazione 4 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla4",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_codcla5",
"label": "Classificazione 5 (codice)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_codcla5",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ar_clascon",
"label": "Classe sconto, non percentuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ar_clascon",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BrandName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "GroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupName",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FamilyName",
"label": "Famiglia attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FamilyName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SeasonName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SetName",
"label": "Set attributi attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SetName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FormName",
"label": "Forma attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FormName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "CompositionName",
"label": "Direttiva / composizione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "CompositionName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierExtendedName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SupplierAvailability",
"label": "Anagrafica fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SupplierAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SubgroupAvailability",
"label": "Coerenza sottogruppo/gruppo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SubgroupAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "UsedState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SaleState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ProductNotes",
"label": "Note articolo (primi 500 caratteri)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductNotes",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Dossier articolo taglie",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F758A296-2C64-5A5F-8D12-34B964313372",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "apt_codart",
"id": "519E5730-8E5A-5D20-AFFE-D85F9F7E2611",
"name": "article",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"ar_codart",
"ar_codalt",
"ar_descr",
"ar_desint",
"ar_unmis",
"ar_confez2",
"ar_unmis2",
"ar_codiva",
"ar_forn",
"ar_codroot",
"ar_codvar1",
"ar_codvar2",
"ar_codvar3",
"ar_codtagl",
"ar_anno",
"ar_codcla1",
"ar_codcla2",
"ar_codcla3",
"ar_codcla4",
"ar_codcla5",
"ar_clascon",
"BrandName",
"GroupName",
"SubgroupName",
"FamilyName",
"SeasonName",
"SetName",
"FormName",
"CompositionName",
"SupplierName",
"SupplierExtendedName",
"SupplierAvailability",
"SubgroupAvailability",
"UsedState",
"SaleState",
"ProductNotes"
],
"sourceID": "5500F563-48A4-5050-9A4C-7151A43EB806",
"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'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "87C0FA4A-F521-59BC-935E-0C9722CCC2FA",
"key": "bc_code",
"type": "text"
},
{
"direction": "ascending",
"id": "31367E82-B4CD-5446-8ADC-2CA4A0D65430",
"key": "SizeBarcodeKey",
"type": "text"
}
],
"id": "93C36486-DBDF-5D54-9204-07E4803E3811",
"mappings": [
{
"commonFieldKey": "",
"key": "SizeBarcodeKey",
"label": "Identità interna barcode e contesto taglia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeBarcodeKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentSizeKey",
"label": "Identità interna padre taglia",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentSizeKey",
"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": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "apt_magaz",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SlotPosition",
"label": "Posizione nella scala (1–24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SlotPosition",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "SizeLabel",
"label": "Etichetta taglia originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "SizeLabel",
"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
},
{
"commonFieldKey": "",
"key": "BarcodeNotice",
"label": "Barcode anagrafico — non stock o EAN certificato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "BarcodeNotice",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Barcode della taglia",
"primaryKey": "SizeBarcodeKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "F758A296-2C64-5A5F-8D12-34B964313372",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "apt_codart",
"id": "519E5730-8E5A-5D20-AFFE-D85F9F7E2611",
"name": "article",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "apt_magaz",
"id": "D3568D43-0632-50A9-92A2-BC3168121183",
"name": "warehouse",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "SlotPosition",
"id": "8231D6B8-8BF8-5D5A-B623-58850DEE6217",
"name": "slot",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"apt_codart",
"ProductName",
"WarehouseName",
"SizeLabel",
"bc_code",
"bc_unmis",
"bc_tagl",
"BarcodeNotice"
],
"sourceID": "5500F563-48A4-5050-9A4C-7151A43EB806",
"sqlQuery": "WITH StockSource AS (SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), p.codditt)),N':',CONVERT(nvarchar(4000), p.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart)),N':',CONVERT(nvarchar(4000), p.apt_codart),N'|',DATALENGTH(CONVERT(nvarchar(4000), p.apt_magaz)),N':',CONVERT(nvarchar(4000), p.apt_magaz),N'|') AS ParentStockKey, p.codditt AS codditt, p.apt_codart AS apt_codart, p.apt_magaz AS apt_magaz, COALESCE(NULLIF(a.ar_descr,N''),p.apt_codart) AS ProductName, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',p.apt_magaz)) AS WarehouseName, a.ar_unmis AS CurrentPrimaryUnit, b.tb_desmarc AS BrandName, t.tb_desstag AS SeasonName, a.ar_codtagl AS ScaleCode, s.tb_destagl AS ScaleName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability, CASE WHEN s.tb_codtagl IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ScaleAvailability, REPLACE(CONVERT(nvarchar(4000), p.apt_ultagg, 126),N'T',CHAR(10)) AS StockUpdatedAt, N'Quantità native; U.M. principale attuale solo contesto: verificare vista e configurazione TCO' AS UnitNotice, p.apt_esist01 AS apt_esist01, p.apt_esist02 AS apt_esist02, p.apt_esist03 AS apt_esist03, p.apt_esist04 AS apt_esist04, p.apt_esist05 AS apt_esist05, p.apt_esist06 AS apt_esist06, p.apt_esist07 AS apt_esist07, p.apt_esist08 AS apt_esist08, p.apt_esist09 AS apt_esist09, p.apt_esist10 AS apt_esist10, p.apt_esist11 AS apt_esist11, p.apt_esist12 AS apt_esist12, p.apt_esist13 AS apt_esist13, p.apt_esist14 AS apt_esist14, p.apt_esist15 AS apt_esist15, p.apt_esist16 AS apt_esist16, p.apt_esist17 AS apt_esist17, p.apt_esist18 AS apt_esist18, p.apt_esist19 AS apt_esist19, p.apt_esist20 AS apt_esist20, p.apt_esist21 AS apt_esist21, p.apt_esist22 AS apt_esist22, p.apt_esist23 AS apt_esist23, p.apt_esist24 AS apt_esist24, p.apt_ordin01 AS apt_ordin01, p.apt_ordin02 AS apt_ordin02, p.apt_ordin03 AS apt_ordin03, p.apt_ordin04 AS apt_ordin04, p.apt_ordin05 AS apt_ordin05, p.apt_ordin06 AS apt_ordin06, p.apt_ordin07 AS apt_ordin07, p.apt_ordin08 AS apt_ordin08, p.apt_ordin09 AS apt_ordin09, p.apt_ordin10 AS apt_ordin10, p.apt_ordin11 AS apt_ordin11, p.apt_ordin12 AS apt_ordin12, p.apt_ordin13 AS apt_ordin13, p.apt_ordin14 AS apt_ordin14, p.apt_ordin15 AS apt_ordin15, p.apt_ordin16 AS apt_ordin16, p.apt_ordin17 AS apt_ordin17, p.apt_ordin18 AS apt_ordin18, p.apt_ordin19 AS apt_ordin19, p.apt_ordin20 AS apt_ordin20, p.apt_ordin21 AS apt_ordin21, p.apt_ordin22 AS apt_ordin22, p.apt_ordin23 AS apt_ordin23, p.apt_ordin24 AS apt_ordin24, p.apt_impeg01 AS apt_impeg01, p.apt_impeg02 AS apt_impeg02, p.apt_impeg03 AS apt_impeg03, p.apt_impeg04 AS apt_impeg04, p.apt_impeg05 AS apt_impeg05, p.apt_impeg06 AS apt_impeg06, p.apt_impeg07 AS apt_impeg07, p.apt_impeg08 AS apt_impeg08, p.apt_impeg09 AS apt_impeg09, p.apt_impeg10 AS apt_impeg10, p.apt_impeg11 AS apt_impeg11, p.apt_impeg12 AS apt_impeg12, p.apt_impeg13 AS apt_impeg13, p.apt_impeg14 AS apt_impeg14, p.apt_impeg15 AS apt_impeg15, p.apt_impeg16 AS apt_impeg16, p.apt_impeg17 AS apt_impeg17, p.apt_impeg18 AS apt_impeg18, p.apt_impeg19 AS apt_impeg19, p.apt_impeg20 AS apt_impeg20, p.apt_impeg21 AS apt_impeg21, p.apt_impeg22 AS apt_impeg22, p.apt_impeg23 AS apt_impeg23, p.apt_impeg24 AS apt_impeg24, p.apt_prenot01 AS apt_prenot01, p.apt_prenot02 AS apt_prenot02, p.apt_prenot03 AS apt_prenot03, p.apt_prenot04 AS apt_prenot04, p.apt_prenot05 AS apt_prenot05, p.apt_prenot06 AS apt_prenot06, p.apt_prenot07 AS apt_prenot07, p.apt_prenot08 AS apt_prenot08, p.apt_prenot09 AS apt_prenot09, p.apt_prenot10 AS apt_prenot10, p.apt_prenot11 AS apt_prenot11, p.apt_prenot12 AS apt_prenot12, p.apt_prenot13 AS apt_prenot13, p.apt_prenot14 AS apt_prenot14, p.apt_prenot15 AS apt_prenot15, p.apt_prenot16 AS apt_prenot16, p.apt_prenot17 AS apt_prenot17, p.apt_prenot18 AS apt_prenot18, p.apt_prenot19 AS apt_prenot19, p.apt_prenot20 AS apt_prenot20, p.apt_prenot21 AS apt_prenot21, p.apt_prenot22 AS apt_prenot22, p.apt_prenot23 AS apt_prenot23, p.apt_prenot24 AS apt_prenot24, s.tb_dest01 AS tb_dest01, s.tb_dest02 AS tb_dest02, s.tb_dest03 AS tb_dest03, s.tb_dest04 AS tb_dest04, s.tb_dest05 AS tb_dest05, s.tb_dest06 AS tb_dest06, s.tb_dest07 AS tb_dest07, s.tb_dest08 AS tb_dest08, s.tb_dest09 AS tb_dest09, s.tb_dest10 AS tb_dest10, s.tb_dest11 AS tb_dest11, s.tb_dest12 AS tb_dest12, s.tb_dest13 AS tb_dest13, s.tb_dest14 AS tb_dest14, s.tb_dest15 AS tb_dest15, s.tb_dest16 AS tb_dest16, s.tb_dest17 AS tb_dest17, s.tb_dest18 AS tb_dest18, s.tb_dest19 AS tb_dest19, s.tb_dest20 AS tb_dest20, s.tb_dest21 AS tb_dest21, s.tb_dest22 AS tb_dest22, s.tb_dest23 AS tb_dest23, s.tb_dest24 AS tb_dest24 FROM ARTPROTC p LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), p.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), p.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND p.apt_magaz=w.tb_codmaga LEFT JOIN TABTAGL 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_codtagl=s.tb_codtagl 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 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 WHERE p.codditt IS NOT NULL AND p.apt_codart IS NOT NULL AND p.apt_magaz IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ARTPROTC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTPROTC',N'V') AND OBJECT_ID(N'TABTAGL',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABTAGL',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'BARCODE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.BARCODE',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), 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.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), p.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article))) AND p.apt_magaz=:warehouse), SizeRows AS (SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 1 AS SlotPosition, r.tb_dest01 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',1,N'|') AS SizeKey, r.apt_esist01 AS PhysicalStock, r.apt_ordin01 AS SupplierOrdered, r.apt_impeg01 AS CustomerCommitted, r.apt_prenot01 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 2 AS SlotPosition, r.tb_dest02 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',2,N'|') AS SizeKey, r.apt_esist02 AS PhysicalStock, r.apt_ordin02 AS SupplierOrdered, r.apt_impeg02 AS CustomerCommitted, r.apt_prenot02 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 3 AS SlotPosition, r.tb_dest03 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',3,N'|') AS SizeKey, r.apt_esist03 AS PhysicalStock, r.apt_ordin03 AS SupplierOrdered, r.apt_impeg03 AS CustomerCommitted, r.apt_prenot03 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 4 AS SlotPosition, r.tb_dest04 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',4,N'|') AS SizeKey, r.apt_esist04 AS PhysicalStock, r.apt_ordin04 AS SupplierOrdered, r.apt_impeg04 AS CustomerCommitted, r.apt_prenot04 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 5 AS SlotPosition, r.tb_dest05 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',5,N'|') AS SizeKey, r.apt_esist05 AS PhysicalStock, r.apt_ordin05 AS SupplierOrdered, r.apt_impeg05 AS CustomerCommitted, r.apt_prenot05 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 6 AS SlotPosition, r.tb_dest06 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',6,N'|') AS SizeKey, r.apt_esist06 AS PhysicalStock, r.apt_ordin06 AS SupplierOrdered, r.apt_impeg06 AS CustomerCommitted, r.apt_prenot06 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 7 AS SlotPosition, r.tb_dest07 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',7,N'|') AS SizeKey, r.apt_esist07 AS PhysicalStock, r.apt_ordin07 AS SupplierOrdered, r.apt_impeg07 AS CustomerCommitted, r.apt_prenot07 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 8 AS SlotPosition, r.tb_dest08 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',8,N'|') AS SizeKey, r.apt_esist08 AS PhysicalStock, r.apt_ordin08 AS SupplierOrdered, r.apt_impeg08 AS CustomerCommitted, r.apt_prenot08 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 9 AS SlotPosition, r.tb_dest09 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',9,N'|') AS SizeKey, r.apt_esist09 AS PhysicalStock, r.apt_ordin09 AS SupplierOrdered, r.apt_impeg09 AS CustomerCommitted, r.apt_prenot09 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 10 AS SlotPosition, r.tb_dest10 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',10,N'|') AS SizeKey, r.apt_esist10 AS PhysicalStock, r.apt_ordin10 AS SupplierOrdered, r.apt_impeg10 AS CustomerCommitted, r.apt_prenot10 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 11 AS SlotPosition, r.tb_dest11 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',11,N'|') AS SizeKey, r.apt_esist11 AS PhysicalStock, r.apt_ordin11 AS SupplierOrdered, r.apt_impeg11 AS CustomerCommitted, r.apt_prenot11 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 12 AS SlotPosition, r.tb_dest12 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',12,N'|') AS SizeKey, r.apt_esist12 AS PhysicalStock, r.apt_ordin12 AS SupplierOrdered, r.apt_impeg12 AS CustomerCommitted, r.apt_prenot12 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 13 AS SlotPosition, r.tb_dest13 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',13,N'|') AS SizeKey, r.apt_esist13 AS PhysicalStock, r.apt_ordin13 AS SupplierOrdered, r.apt_impeg13 AS CustomerCommitted, r.apt_prenot13 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 14 AS SlotPosition, r.tb_dest14 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',14,N'|') AS SizeKey, r.apt_esist14 AS PhysicalStock, r.apt_ordin14 AS SupplierOrdered, r.apt_impeg14 AS CustomerCommitted, r.apt_prenot14 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 15 AS SlotPosition, r.tb_dest15 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',15,N'|') AS SizeKey, r.apt_esist15 AS PhysicalStock, r.apt_ordin15 AS SupplierOrdered, r.apt_impeg15 AS CustomerCommitted, r.apt_prenot15 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 16 AS SlotPosition, r.tb_dest16 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',16,N'|') AS SizeKey, r.apt_esist16 AS PhysicalStock, r.apt_ordin16 AS SupplierOrdered, r.apt_impeg16 AS CustomerCommitted, r.apt_prenot16 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 17 AS SlotPosition, r.tb_dest17 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',17,N'|') AS SizeKey, r.apt_esist17 AS PhysicalStock, r.apt_ordin17 AS SupplierOrdered, r.apt_impeg17 AS CustomerCommitted, r.apt_prenot17 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 18 AS SlotPosition, r.tb_dest18 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',18,N'|') AS SizeKey, r.apt_esist18 AS PhysicalStock, r.apt_ordin18 AS SupplierOrdered, r.apt_impeg18 AS CustomerCommitted, r.apt_prenot18 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 19 AS SlotPosition, r.tb_dest19 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',19,N'|') AS SizeKey, r.apt_esist19 AS PhysicalStock, r.apt_ordin19 AS SupplierOrdered, r.apt_impeg19 AS CustomerCommitted, r.apt_prenot19 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 20 AS SlotPosition, r.tb_dest20 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',20,N'|') AS SizeKey, r.apt_esist20 AS PhysicalStock, r.apt_ordin20 AS SupplierOrdered, r.apt_impeg20 AS CustomerCommitted, r.apt_prenot20 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 21 AS SlotPosition, r.tb_dest21 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',21,N'|') AS SizeKey, r.apt_esist21 AS PhysicalStock, r.apt_ordin21 AS SupplierOrdered, r.apt_impeg21 AS CustomerCommitted, r.apt_prenot21 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 22 AS SlotPosition, r.tb_dest22 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',22,N'|') AS SizeKey, r.apt_esist22 AS PhysicalStock, r.apt_ordin22 AS SupplierOrdered, r.apt_impeg22 AS CustomerCommitted, r.apt_prenot22 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 23 AS SlotPosition, r.tb_dest23 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',23,N'|') AS SizeKey, r.apt_esist23 AS PhysicalStock, r.apt_ordin23 AS SupplierOrdered, r.apt_impeg23 AS CustomerCommitted, r.apt_prenot23 AS ShipmentReserved FROM StockSource r UNION ALL SELECT r.ParentStockKey AS ParentStockKey, r.codditt AS codditt, r.apt_codart AS apt_codart, r.apt_magaz AS apt_magaz, r.ProductName AS ProductName, r.WarehouseName AS WarehouseName, r.CurrentPrimaryUnit AS CurrentPrimaryUnit, r.BrandName AS BrandName, r.SeasonName AS SeasonName, r.ScaleCode AS ScaleCode, r.ScaleName AS ScaleName, r.ProductAvailability AS ProductAvailability, r.WarehouseAvailability AS WarehouseAvailability, r.ScaleAvailability AS ScaleAvailability, r.StockUpdatedAt AS StockUpdatedAt, r.UnitNotice AS UnitNotice, 24 AS SlotPosition, r.tb_dest24 AS SizeLabel, CONCAT(r.ParentStockKey,N'pos:',24,N'|') AS SizeKey, r.apt_esist24 AS PhysicalStock, r.apt_ordin24 AS SupplierOrdered, r.apt_impeg24 AS CustomerCommitted, r.apt_prenot24 AS ShipmentReserved FROM StockSource r), CheckedSizes AS (SELECT k.*, CASE WHEN k.SizeLabel IS NOT NULL AND DATALENGTH(LTRIM(RTRIM(k.SizeLabel)))>0 AND (SELECT COUNT(*) FROM SizeRows z WHERE (CONVERT(nvarchar(4000), z.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), z.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))))=1 THEN 1 ELSE 0 END AS SizeLookupAllowed FROM SizeRows k) SELECT CONCAT(DATALENGTH(k.SizeKey),N':',k.SizeKey,N'|',CONCAT(DATALENGTH(CONVERT(nvarchar(4000), b.codditt)),N':',CONVERT(nvarchar(4000), b.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), b.bc_code)),N':',CONVERT(nvarchar(4000), b.bc_code),N'|')) AS SizeBarcodeKey, k.SizeKey AS ParentSizeKey, k.codditt AS codditt, k.apt_codart AS apt_codart, k.apt_magaz AS apt_magaz, k.SlotPosition AS SlotPosition, k.ProductName AS ProductName, k.WarehouseName AS WarehouseName, k.SizeLabel AS SizeLabel, b.bc_code AS bc_code, b.bc_unmis AS bc_unmis, b.bc_tagl AS bc_tagl, N'Codice/U.M./taglia dalla vista BARCODE; magazzino e posizione sono contesto padre, non attributi del barcode' AS BarcodeNotice FROM CheckedSizes k INNER JOIN BARCODE b ON (CONVERT(nvarchar(4000), k.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND (CONVERT(nvarchar(4000), k.apt_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.bc_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.apt_codart))=DATALENGTH(CONVERT(nvarchar(4000), b.bc_codart))) AND (CONVERT(nvarchar(4000), k.SizeLabel) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.bc_tagl) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), k.SizeLabel))=DATALENGTH(CONVERT(nvarchar(4000), b.bc_tagl))) WHERE b.codditt IS NOT NULL AND b.bc_code IS NOT NULL AND k.SizeLookupAllowed=1 AND k.SlotPosition=:slot",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "0BF6FC7B-96AB-5FCF-83EE-613F2CC81463",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "7CCF3F68-6D6B-52DD-BBB7-202F5BA0A0F4",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "8462E4AE-73E8-5880-9024-1726BAC2DEBD",
"title": "Taglie",
"urlKey": ""
},
{
"id": "7D0BD925-2B53-5114-A0EC-E47AFD3755C0",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "034D2143-E0E3-5D15-BC2C-ADB86DD5AEB4",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CB231733-504A-5887-B006-2697D5C8E97A",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "WarehouseName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ScaleName",
"label": "Scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PositivePositions",
"label": "Posizioni positive (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "NegativePositions",
"label": "Posizioni negative (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "48CAF73C-8228-53C2-9D18-FE2F5B0277A6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleCode",
"label": "Codice scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleName",
"label": "Scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleAvailability",
"label": "Anagrafica scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "StockUpdatedAt",
"label": "Aggiornamento del progressivo (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "UnitNotice",
"label": "Unità dei progressivi: verificare localmente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Conteggi di posizioni, non somme di quantità",
"detailRole": "information",
"isVisible": true,
"key": "PositivePositions",
"label": "Posizioni positive (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Conteggi di posizioni, non somme di quantità",
"detailRole": "information",
"isVisible": true,
"key": "NegativePositions",
"label": "Posizioni negative (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Conteggi di posizioni, non somme di quantità",
"detailRole": "information",
"isVisible": true,
"key": "ZeroPositions",
"label": "Posizioni zero (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Conteggi di posizioni, non somme di quantità",
"detailRole": "information",
"isVisible": true,
"key": "UnknownPositions",
"label": "Posizioni NULL (su 24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3F05D9D3-1EF2-55AC-8838-37F332C39ED1",
"openFilters": [
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
},
{
"id": "E396844C-142A-5DA9-9F92-FB0508D58910",
"includeAllOption": false,
"key": "apt_magaz",
"title": "Magazzino",
"type": "number"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "019E52DE-9E39-546C-A09D-48747EDD5A70",
"key": "ProductName",
"type": "text"
},
{
"direction": "ascending",
"id": "6739E124-ABBF-5653-8180-FDC9DCBA0082",
"key": "StockKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "apt_codart",
"systemImage": "doc.text",
"title": "Giacenze articoli per taglia",
"titleKey": "ProductName"
},
{
"actions": [
{
"id": "8714EC5C-872F-513D-83BF-20F7192327C4",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "ACBC72B0-0ADA-5CC5-8B42-67DCFAD1D262",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "93C36486-DBDF-5D54-9204-07E4803E3811",
"title": "Barcode taglia",
"urlKey": ""
}
],
"badgeKey": "WarehouseName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SizeLabelState",
"label": "Etichetta per barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "PhysicalStock",
"label": "Esistenza fisica (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SupplierOrdered",
"label": "Ordinato fornitori (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "CustomerCommitted",
"label": "Impegnato clienti (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ShipmentReserved",
"label": "Prenotato spedizioni (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "8462E4AE-73E8-5880-9024-1726BAC2DEBD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "CurrentPrimaryUnit",
"label": "U.M. attuale (contesto)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "SeasonName",
"label": "Stagione attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleCode",
"label": "Codice scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleName",
"label": "Scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ScaleAvailability",
"label": "Anagrafica scala taglie attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "StockUpdatedAt",
"label": "Aggiornamento del progressivo (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "UnitNotice",
"label": "Unità dei progressivi: verificare localmente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "SlotPosition",
"label": "Posizione nella scala (1–24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "SizeLabel",
"label": "Etichetta taglia originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "SizeTitle",
"label": "Taglia e posizione",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "SizeLabelState",
"label": "Etichetta per barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "PhysicalStock",
"label": "Esistenza fisica (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "SupplierOrdered",
"label": "Ordinato fornitori (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "CustomerCommitted",
"label": "Impegnato clienti (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Progressivi originali della posizione — non disponibilità promessa",
"detailRole": "information",
"isVisible": true,
"key": "ShipmentReserved",
"label": "Prenotato spedizioni (originale)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6F60140C-7FF4-52C9-B895-F03F08A60A4C",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "30A7D567-7BEB-5394-A13C-B4A538E74A54",
"key": "SlotPosition",
"type": "number"
},
{
"direction": "ascending",
"id": "50A2ABB6-4348-5200-BF49-61DDA0CAFFFF",
"key": "SizeKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ProductName",
"systemImage": "doc.text",
"title": "Taglie del magazzino",
"titleKey": "SizeTitle"
},
{
"actions": [],
"badgeKey": "codditt",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CB231733-504A-5887-B006-2697D5C8E97A",
"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": "20AE7A78-5DB4-5011-98BC-C2ECA2C67F85",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ar_codart",
"systemImage": "doc.text",
"title": "Dossier articolo taglie",
"titleKey": "ar_descr"
},
{
"actions": [],
"badgeKey": "SizeLabel",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bc_unmis",
"label": "U.M. barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "93C36486-DBDF-5D54-9204-07E4803E3811",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "apt_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "SlotPosition",
"label": "Posizione nella scala (1–24)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Descrizione articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Contesto articolo, magazzino e scala attuali",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "SizeLabel",
"label": "Etichetta taglia originale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "bc_code",
"label": "Barcode documentato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "bc_unmis",
"label": "U.M. barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "bc_tagl",
"label": "Taglia barcode",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Taglia e barcode: nessuna corrispondenza presunta",
"detailRole": "information",
"isVisible": true,
"key": "BarcodeNotice",
"label": "Barcode anagrafico — non stock o EAN certificato",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "062F997F-359C-5019-8390-90D6B8C78A78",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "87C0FA4A-F521-59BC-935E-0C9722CCC2FA",
"key": "bc_code",
"type": "text"
},
{
"direction": "ascending",
"id": "31367E82-B4CD-5446-8ADC-2CA4A0D65430",
"key": "SizeBarcodeKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ProductName",
"systemImage": "doc.text",
"title": "Barcode della taglia",
"titleKey": "bc_code"
}
],
"relations": [
{
"childDatasetID": "8462E4AE-73E8-5880-9024-1726BAC2DEBD",
"childKey": "ParentStockKey",
"id": "7CCF3F68-6D6B-52DD-BBB7-202F5BA0A0F4",
"name": "Taglie",
"parentDatasetID": "48CAF73C-8228-53C2-9D18-FE2F5B0277A6",
"parentKey": "StockKey"
},
{
"childDatasetID": "CB231733-504A-5887-B006-2697D5C8E97A",
"childKey": "ProductKey",
"id": "034D2143-E0E3-5D15-BC2C-ADB86DD5AEB4",
"name": "Articolo",
"parentDatasetID": "48CAF73C-8228-53C2-9D18-FE2F5B0277A6",
"parentKey": "ProductKey"
},
{
"childDatasetID": "93C36486-DBDF-5D54-9204-07E4803E3811",
"childKey": "ParentSizeKey",
"id": "ACBC72B0-0ADA-5CC5-8B42-67DCFAD1D262",
"name": "Barcode taglia",
"parentDatasetID": "8462E4AE-73E8-5880-9024-1726BAC2DEBD",
"parentKey": "SizeKey"
}
],
"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 negozi, magazzino, acquisti e responsabili: scegli ditta e magazzino, cerca l’articolo e consulta marca, stagione, scala e conteggi delle posizioni. Apri Taglie per esistenza, ordinato fornitori, impegnato clienti e prenotato spedizioni di ciascuna posizione; poi Barcode taglia. Articolo mostra descrizioni, classificazioni, varianti, confezioni e fornitore abituale. Percorsi a richiesta, non un elenco di nomi.\n\nPerché Cifru? Adatta le configurazioni al tuo modo di lavorare. Scegli i campi, i filtri e i dettagli che ti servono e porta sul telefono informazioni che potrebbero non essere disponibili nell’app mobile del tuo gestionale. Le possibilità dipendono dai dati accessibili nella fonte autorizzata e dal tuo piano Cifru.\n\nREQUISITO: 14 VISTE READ del database di transito e-commerce già installate e autorizzate, inclusi ARTPROTC e TABTAGL in colonna. Non tabelle native, buffer scrivibili, qualsiasi database Business o cloud. Cifru non crea viste né esegue script vendor. Verificare modulo Taglie/Colori, licenze, SQL Server 2016+, proprietario, schema, unicità/non nullità delle chiavi e permessi.\n\nPro reale: una fonte, una Home, quattro liste, tre sotto-pulsanti lazy. Ditta e magazzino obbligatori, massimo 1.000 righe per lettura, nessun refresh periodico. Le 24 colonne documentate 01–24 sono trasformate in 24 posizioni per l’articolo/magazzino selezionato: ordinali derivati, NON colonne ERP nuove. Nessuna aggregazione per etichetta, deduplicazione, nascondimento automatico di zero/NULL o somma tra unità. Conteggi positivi/negativi/zero/NULL si riferiscono alle 24 posizioni, non al numero di taglie attive o a quantità totali.\n\nQuantità Float originali, 17 cifre significative con virgola italiana: zero, negative e NULL restano distinte. U.M. principale dell’anagrafica attuale è soltanto contesto: verificare l’unità dei progressivi nella vista e nella configurazione TCO installata. Nessuna conversione o disponibilità calcolata, promessa di consegna, costo, valorizzazione, movimenti o situazione storica a una data. Timestamp completo proviene da ARTPROTC, non da un campo inventato di ARTPROTCR.\n\nScala/etichette e anagrafiche sono attuali, non uno snapshot atomico delle letture. Articolo, magazzino o scala mancanti non cancellano il progressivo; avviso esplicito, nessun nome/U.M./taglia inventati. Tutte le 24 posizioni restano leggibili, anche non definite. Barcode taglia richiede etichetta non vuota e univoca nella scala, ditta e articolo esatti; etichetta duplicata/NULL/vuota blocca il lookup anziché scegliere un barcode arbitrario. Ordine della scala non inferito da bc_tagl; barcode senza match non inventato. U.M./taglia del barcode originali, nessuna garanzia EAN o equivalenza con unità stock. Magazzino e posizione nel dossier barcode sono contesto padre, non campi fisici BARCODE.\n\nVisibilità esterna del modulo e-commerce, non tutto l’ERP; ARTICO standard esclude lotto/matricola/commessa/ubicazione/fase/gift card. Progressivi taglie non suddivisi per lotto/commessa/ubicazione/fase. Dossier articolo: fornitore abituale, non controparte documento; IVA/classificazioni sono codici, non aliquote o descrizioni indovinate. Note primi 500 caratteri, nessun audit/file privato/password.\n\nFiltro ditta non è ACL. Account dedicato solo SELECT e ambito minimo approvato; validare viste installate, chiavi, collation, indici, timeout e letture limitate. Lazy e limiti non garantiscono performance. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione e prove sintetiche non certificano installazione NTS o SQL Server reale. Immagini native DEMO interamente inventate; massimo otto in galleria, percorsi e Dettagli completi conservati privatamente.\n\nSchema tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm\nScala taglie: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024sr1/html/ambstco02.htm\nInventario: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsmgstrl.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "079EA1C1-69AB-5EF5-ABC7-98DAD326418E",
"rootButtonCount": 1,
"summary": "Ditta e magazzino: 24 posizioni taglia, quantità originali, dossier articolo e barcode con verifica di etichetta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Magazzino",
"Taglie",
"Retail",
"Barcode",
"Pro"
],
"title": "Giacenze per taglia: magazzini, articoli e barcode — Pro"
}
}