Ordini fornitori e produzione, righe e articolo e-commerce — Pro
Periodo, ditta e tipo: stato, date consegna note, quantità native e dossier articolo su richiesta.
NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.
Per approvvigionamento, magazzino, pianificazione operativa della produzione e responsabili: seleziona periodo, ditta e tipo. Consulta stato testata, numero righe e intervallo delle date di consegna note. Apri Righe per quantità ordinate/evase, U.M., data consegna e magazzino; Articolo per classificazioni, confezioni, varianti e ragioni sociali del fornitore abituale attuale. È un dossier operativo, non un ordine finanziario completo o un piano di produzione con costi.
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: 12 VISTE READ documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle native, buffer scrivibili o qualsiasi database NTS. Cifru non crea viste o installa moduli. Verificare licenze, SQL delle viste, proprietario, colonne e unicità/non nullità delle chiavi logiche: grassetto nel manuale non certifica PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.
Pro reale: una fonte, una Home, tre liste e due sotto-pulsanti caricati solo quando aperti. Periodo data ordine, ditta e tipo obbligatori. Massimo 1.000 righe per richiesta, nessun refresh periodico. O=ordine fornitore, H=ordine di produzione; tipo sconosciuto conservato senza riclassificazione. Identità completa ditta/TIPO/anno/serie/numero, più numero riga nelle posizioni. Numeri uguali di tipi o ditte diversi non sono un unico ordine.
Coerenza testata verificata su TUTTE le righe disponibili prima del filtro periodo; data e stato discordanti restano vuoti con avviso, mai scelti arbitrariamente. La data minima disponibile serve SOLO al filtro quando discordante, non è data ordine certa. Righe apre tutte le righe dell’identità, non soltanto quelle del periodo. Non storico/as-of o snapshot atomico. Date prima/ultima consegna sono MIN/MAX delle date NOTE di riga, non promesse o date della testata: il conteggio delle righe con data segnala la copertura. Nessuna data nota significa campi vuoti, non una data inventata. Righe con chiave incompleta escluse; il conteggio non certifica la completezza della vista.
Quantità ordinate ed evase nella U.M. nativa principale or_ump; nessuna conversione, sostituzione con U.M. master o somma tra unità. Differenza=or_quant−or_quaeva è aritmetica, NON quantità certa da ricevere/produrre. NULL non diventa zero; negativi non azzerati. or_flevas S/N della testata conserva anche codici sconosciuti/NULL. or_flevasr S/C resta codice grezzo: non si deduce il significato di C o una conferma di ricevimento/pagamento.
ORDINI NON espone il conto del fornitore reale della commessa. Il fornitore abituale dell’articolo, mostrato con le due ragioni sociali attuali, NON è il fornitore dell’ordine. Niente prezzo, valuta, IVA, sconti, totale, pagamento, conferma/rilascio produzione, distinta base o fasi inventati dal manuale funzionale. Non listini generici sostitutivi. Master articoli/magazzini/fornitore sono ATTUALI, non storici; master mancante non cancella ordine o riga. Articolo conserva 41 valori utili attuali; codice IVA non aliquota, classe sconto non percentuale, classificazioni 1–5 codici. Note primi 500 caratteri. Dettagli conserva ora/millisecondi; codici commerciali testo, ordinamento riga numerico. Identità tecniche nascoste, nessun audit/operatore o percorso immagine privato.
Filtro ditta non ACL: account solo SELECT con ambito minimo approvato. Limiti/lazy non garantiscono query economiche; verificare indici, piano e timeout, restringere la selezione al limite. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione/test sintetici/catture DEMO NON certificano ERP o SQL Server reale. Verificare metadati, collation, chiavi, permessi e lettura limitata prima dell’importazione.
Manuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm
Flusso funzionale ordini: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsorgsor.htm
Screenshots
What this package creates
1 Home2 Details3 lists1 sources to map
- Home: Ordini fornitori e produzione
- Details: Righe
- Details: Articolo
- Sub-button: Righe ordine
- Sub-button: Articolo della riga
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQueryWITH h AS (SELECT i.codditt COLLATE Latin1_General_100_BIN2 AS codditt, i.or_tipork COLLATE Latin1_General_100_BIN2 AS or_tipork, i.or_anno, i.or_serie COLLATE Latin1_General_100_BIN2 AS or_serie, i.or_numord, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.or_datord) AS PeriodDate, COUNT(i.or_datcons) AS DeliveryDateCount, MIN(i.or_datcons) AS first_delivery, MAX(i.or_datcons) AS last_delivery, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.or_datord) ELSE NULL END AS or_datord, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.or_flevas) ELSE NULL END AS or_flevas FROM ORDINI i WHERE i.codditt IS NOT NULL AND i.or_tipork IS NOT NULL AND i.or_anno IS NOT NULL AND i.or_serie IS NOT NULL AND i.or_numord IS NOT NULL AND i.or_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') GROUP BY i.codditt COLLATE Latin1_General_100_BIN2, i.or_tipork COLLATE Latin1_General_100_BIN2, i.or_anno, i.or_serie COLLATE Latin1_General_100_BIN2, i.or_numord, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.or_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_tipork)),N':',CONVERT(nvarchar(4000), h.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_anno)),N':',CONVERT(nvarchar(4000), h.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_serie)),N':',CONVERT(nvarchar(4000), h.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_numord)),N':',CONVERT(nvarchar(4000), h.or_numord),N'|') AS OrderKey, h.PeriodDate AS OrderDate, h.codditt, h.or_tipork, h.or_anno, h.or_serie, h.or_numord, h.LineCount, h.HeaderVariants, h.DeliveryDateCount, CASE h.or_tipork COLLATE Latin1_General_100_BIN2 WHEN N'O' THEN N'Ordine fornitore (O)' WHEN N'H' THEN N'Ordine di produzione (H)' ELSE CONCAT(N'Tipo non documentato: ',h.or_tipork) END AS OrderType, CONCAT(h.codditt,N' · ',h.or_tipork,N' ',h.or_anno,N' / ',h.or_serie,N' / ',h.or_numord) AS OrderNumber, CASE h.or_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE h.or_flevas END AS HeaderState, CASE WHEN h.HeaderVariants=1 THEN N'Coerente nelle righe presenti' ELSE N'Dati testata discordanti: verificare Righe e vista' END AS HeaderConsistency, SUBSTRING(CONVERT(nvarchar(4000), h.or_datord, 126),1,10) AS OrderDateDay, REPLACE(CONVERT(nvarchar(4000), h.or_datord, 126),N'T',CHAR(10)) AS OrderDateTime, SUBSTRING(CONVERT(nvarchar(4000), h.first_delivery, 126),1,10) AS FirstDeliveryDay, SUBSTRING(CONVERT(nvarchar(4000), h.last_delivery, 126),1,10) AS LastDeliveryDay, REPLACE(CONVERT(nvarchar(4000), h.first_delivery, 126),N'T',CHAR(10)) AS FirstDeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), h.last_delivery, 126),N'T',CHAR(10)) AS LastDeliveryDateTime FROM h WHERE h.PeriodDate IS NOT NULL
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)),N':',CONVERT(nvarchar(4000), i.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_anno)),N':',CONVERT(nvarchar(4000), i.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_serie)),N':',CONVERT(nvarchar(4000), i.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_numord)),N':',CONVERT(nvarchar(4000), i.or_numord),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_riga)),N':',CONVERT(nvarchar(4000), i.or_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)),N':',CONVERT(nvarchar(4000), i.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_anno)),N':',CONVERT(nvarchar(4000), i.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_serie)),N':',CONVERT(nvarchar(4000), i.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_numord)),N':',CONVERT(nvarchar(4000), i.or_numord),N'|') AS ParentOrderKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_codart)),N':',CONVERT(nvarchar(4000), i.or_codart),N'|') AS ProductKey, i.codditt, i.or_tipork, i.or_anno, i.or_serie, i.or_numord, i.or_riga, i.or_codart, i.or_ump, i.or_quant, i.or_quaeva, i.or_magaz, COALESCE(NULLIF(a.ar_descr,N''),i.or_codart) AS ProductName, CASE i.or_tipork COLLATE Latin1_General_100_BIN2 WHEN N'O' THEN N'Ordine fornitore (O)' WHEN N'H' THEN N'Ordine di produzione (H)' ELSE CONCAT(N'Tipo non documentato: ',i.or_tipork) END AS OrderType, i.or_quant-i.or_quaeva AS ArithmeticDifference, i.or_flevasr AS LineState, CASE i.or_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE i.or_flevas END AS HeaderState, SUBSTRING(CONVERT(nvarchar(4000), i.or_datcons, 126),1,10) AS DeliveryDay, REPLACE(CONVERT(nvarchar(4000), i.or_datcons, 126),N'T',CHAR(10)) AS DeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), i.or_datord, 126),N'T',CHAR(10)) AS OrderDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.or_magaz)) AS WarehouseName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability FROM ORDINI i LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), i.or_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND i.or_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.or_tipork IS NOT NULL AND i.or_anno IS NOT NULL AND i.or_serie IS NOT NULL AND i.or_numord IS NOT NULL AND i.or_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), i.or_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.or_anno=:document_year AND (CONVERT(nvarchar(4000), i.or_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.or_numord=:document_number
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), a.codditt)),N':',CONVERT(nvarchar(4000), a.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart)),N':',CONVERT(nvarchar(4000), a.ar_codart),N'|') AS ProductKey, a.codditt, a.ar_codart, a.ar_codalt, a.ar_descr, a.ar_desint, a.ar_unmis, a.ar_confez2, a.ar_qtacon2, a.ar_unmis2, a.ar_conver, a.ar_codiva, a.ar_pesonet, a.ar_pesolor, a.ar_forn, a.ar_codroot, a.ar_codvar1, a.ar_codvar2, a.ar_codvar3, a.ar_codtagl, a.ar_anno, a.ar_codcla1, a.ar_codcla2, a.ar_codcla3, a.ar_codcla4, a.ar_codcla5, a.ar_clascon, b.tb_desmarc AS BrandName, g.tb_desgmer AS GroupName, s.tb_desgme AS SubgroupName, f.tb_descfam AS FamilyName, t.tb_desstag AS SeasonName, u.tb_desseat AS SetName, v.tb_desform AS FormName, x.tb_desdire AS CompositionName, r.an_descr1 AS SupplierName, 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 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NTS Business — transito e-commerce autorizzato",
"id": "9520B1C9-B384-5027-B40E-F8143BD6009F",
"kind": "sqlServer",
"requiredObjects": [
"ORDINI",
"ARTICO",
"TABMAGA",
"TABMARC",
"TABGMER",
"TABSGME",
"TABCFAM",
"TABSTAG",
"TABSEAT",
"TABFORM",
"TABDIRE",
"FORNITORI"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"id": "91AAB3DD-3BE1-5429-9D9C-E82930E24111",
"mappings": [
{
"commonFieldKey": "",
"key": "OrderKey",
"label": "Identità interna ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDate",
"label": "Data tecnica selezione periodo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDate",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_tipork",
"label": "Codice tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_tipork",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_numord",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LineCount",
"label": "Righe presenti nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderVariants",
"label": "Varianti interne testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderVariants",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDateCount",
"label": "Righe con data consegna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryDateCount",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderNumber",
"label": "Ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderNumber",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderConsistency",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "OrderDateTime",
"label": "Ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "FirstDeliveryDay",
"label": "Prima data consegna nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FirstDeliveryDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LastDeliveryDay",
"label": "Ultima data consegna nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LastDeliveryDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "FirstDeliveryDateTime",
"label": "Prima consegna nota (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "FirstDeliveryDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "LastDeliveryDateTime",
"label": "Ultima consegna nota (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LastDeliveryDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Ordini fornitori e produzione",
"primaryKey": "OrderKey",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"or_tipork",
"or_anno",
"or_serie",
"or_numord",
"OrderType",
"OrderNumber",
"HeaderState",
"HeaderConsistency",
"OrderDateDay",
"OrderDateTime",
"FirstDeliveryDay",
"LastDeliveryDay",
"FirstDeliveryDateTime",
"LastDeliveryDateTime"
],
"sourceID": "9520B1C9-B384-5027-B40E-F8143BD6009F",
"sqlQuery": "WITH h AS (SELECT i.codditt COLLATE Latin1_General_100_BIN2 AS codditt, i.or_tipork COLLATE Latin1_General_100_BIN2 AS or_tipork, i.or_anno, i.or_serie COLLATE Latin1_General_100_BIN2 AS or_serie, i.or_numord, COUNT(*) AS LineCount, COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2) AS HeaderVariants, MIN(i.or_datord) AS PeriodDate, COUNT(i.or_datcons) AS DeliveryDateCount, MIN(i.or_datcons) AS first_delivery, MAX(i.or_datcons) AS last_delivery, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.or_datord) ELSE NULL END AS or_datord, CASE WHEN COUNT(DISTINCT CONCAT(CASE WHEN i.or_datord IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_datord, 126)),N':',CONVERT(nvarchar(4000), i.or_datord, 126),N'|') END,CASE WHEN i.or_flevas IS NULL THEN N'N|' ELSE CONCAT(N'V',DATALENGTH(CONVERT(nvarchar(4000), i.or_flevas)),N':',CONVERT(nvarchar(4000), i.or_flevas),N'|') END) COLLATE Latin1_General_100_BIN2)=1 THEN MIN(i.or_flevas) ELSE NULL END AS or_flevas FROM ORDINI i WHERE i.codditt IS NOT NULL AND i.or_tipork IS NOT NULL AND i.or_anno IS NOT NULL AND i.or_serie IS NOT NULL AND i.or_numord IS NOT NULL AND i.or_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') GROUP BY i.codditt COLLATE Latin1_General_100_BIN2, i.or_tipork COLLATE Latin1_General_100_BIN2, i.or_anno, i.or_serie COLLATE Latin1_General_100_BIN2, i.or_numord, DATALENGTH(CONVERT(nvarchar(4000), i.codditt)), DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)), DATALENGTH(CONVERT(nvarchar(4000), i.or_serie))) SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), h.codditt)),N':',CONVERT(nvarchar(4000), h.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_tipork)),N':',CONVERT(nvarchar(4000), h.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_anno)),N':',CONVERT(nvarchar(4000), h.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_serie)),N':',CONVERT(nvarchar(4000), h.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), h.or_numord)),N':',CONVERT(nvarchar(4000), h.or_numord),N'|') AS OrderKey, h.PeriodDate AS OrderDate, h.codditt, h.or_tipork, h.or_anno, h.or_serie, h.or_numord, h.LineCount, h.HeaderVariants, h.DeliveryDateCount, CASE h.or_tipork COLLATE Latin1_General_100_BIN2 WHEN N'O' THEN N'Ordine fornitore (O)' WHEN N'H' THEN N'Ordine di produzione (H)' ELSE CONCAT(N'Tipo non documentato: ',h.or_tipork) END AS OrderType, CONCAT(h.codditt,N' · ',h.or_tipork,N' ',h.or_anno,N' / ',h.or_serie,N' / ',h.or_numord) AS OrderNumber, CASE h.or_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE h.or_flevas END AS HeaderState, CASE WHEN h.HeaderVariants=1 THEN N'Coerente nelle righe presenti' ELSE N'Dati testata discordanti: verificare Righe e vista' END AS HeaderConsistency, SUBSTRING(CONVERT(nvarchar(4000), h.or_datord, 126),1,10) AS OrderDateDay, REPLACE(CONVERT(nvarchar(4000), h.or_datord, 126),N'T',CHAR(10)) AS OrderDateTime, SUBSTRING(CONVERT(nvarchar(4000), h.first_delivery, 126),1,10) AS FirstDeliveryDay, SUBSTRING(CONVERT(nvarchar(4000), h.last_delivery, 126),1,10) AS LastDeliveryDay, REPLACE(CONVERT(nvarchar(4000), h.first_delivery, 126),N'T',CHAR(10)) AS FirstDeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), h.last_delivery, 126),N'T',CHAR(10)) AS LastDeliveryDateTime FROM h WHERE h.PeriodDate IS NOT NULL",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "31515AE1-F149-5615-8DF5-CB041CBC2B1E",
"key": "or_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"id": "D1EA5851-FD57-54C0-AFAD-A05C20684479",
"mappings": [
{
"commonFieldKey": "",
"key": "LineKey",
"label": "Identità interna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ParentOrderKey",
"label": "Identità ordine padre",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ParentOrderKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductKey",
"label": "Identità interna articolo/ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductKey",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "codditt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_tipork",
"label": "Codice tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_tipork",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_anno",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_serie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_numord",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_riga",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_codart",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "or_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_ump",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "or_quant",
"label": "Quantità ordinata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_quant",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "or_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_quaeva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "or_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "or_magaz",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderType",
"label": "Tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderType",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ArithmeticDifference",
"label": "Differenza quantità calcolata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ArithmeticDifference",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "LineState",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "HeaderState",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryDay",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "DeliveryDateTime",
"label": "Consegna riga (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "DeliveryDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "OrderDateTime",
"label": "Ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "OrderDateTime",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseName",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ProductAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "WarehouseAvailability",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Righe ordine",
"primaryKey": "LineKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "600298DA-DFCC-5B75-BCE4-11E5F8878C54",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "or_tipork",
"id": "F447B3DD-5B18-5035-9F2F-CB66110E35C7",
"name": "document_type",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "or_anno",
"id": "FB185F2C-A7AF-50C4-9355-8FC7A1507F0B",
"name": "document_year",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "or_serie",
"id": "5876E1CD-4A12-59A2-B143-1C4EB11C495C",
"name": "document_series",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "or_numord",
"id": "DDD3DA36-35C0-510D-8F6C-46CC7E098E82",
"name": "document_number",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"codditt",
"or_tipork",
"or_anno",
"or_serie",
"or_numord",
"or_riga",
"or_codart",
"or_ump",
"or_magaz",
"ProductName",
"OrderType",
"LineState",
"HeaderState",
"DeliveryDay",
"DeliveryDateTime",
"OrderDateTime",
"WarehouseName",
"ProductAvailability",
"WarehouseAvailability"
],
"sourceID": "9520B1C9-B384-5027-B40E-F8143BD6009F",
"sqlQuery": "SELECT CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)),N':',CONVERT(nvarchar(4000), i.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_anno)),N':',CONVERT(nvarchar(4000), i.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_serie)),N':',CONVERT(nvarchar(4000), i.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_numord)),N':',CONVERT(nvarchar(4000), i.or_numord),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_riga)),N':',CONVERT(nvarchar(4000), i.or_riga),N'|') AS LineKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork)),N':',CONVERT(nvarchar(4000), i.or_tipork),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_anno)),N':',CONVERT(nvarchar(4000), i.or_anno),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_serie)),N':',CONVERT(nvarchar(4000), i.or_serie),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_numord)),N':',CONVERT(nvarchar(4000), i.or_numord),N'|') AS ParentOrderKey, CONCAT(DATALENGTH(CONVERT(nvarchar(4000), i.codditt)),N':',CONVERT(nvarchar(4000), i.codditt),N'|',DATALENGTH(CONVERT(nvarchar(4000), i.or_codart)),N':',CONVERT(nvarchar(4000), i.or_codart),N'|') AS ProductKey, i.codditt, i.or_tipork, i.or_anno, i.or_serie, i.or_numord, i.or_riga, i.or_codart, i.or_ump, i.or_quant, i.or_quaeva, i.or_magaz, COALESCE(NULLIF(a.ar_descr,N''),i.or_codart) AS ProductName, CASE i.or_tipork COLLATE Latin1_General_100_BIN2 WHEN N'O' THEN N'Ordine fornitore (O)' WHEN N'H' THEN N'Ordine di produzione (H)' ELSE CONCAT(N'Tipo non documentato: ',i.or_tipork) END AS OrderType, i.or_quant-i.or_quaeva AS ArithmeticDifference, i.or_flevasr AS LineState, CASE i.or_flevas COLLATE Latin1_General_100_BIN2 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE i.or_flevas END AS HeaderState, SUBSTRING(CONVERT(nvarchar(4000), i.or_datcons, 126),1,10) AS DeliveryDay, REPLACE(CONVERT(nvarchar(4000), i.or_datcons, 126),N'T',CHAR(10)) AS DeliveryDateTime, REPLACE(CONVERT(nvarchar(4000), i.or_datord, 126),N'T',CHAR(10)) AS OrderDateTime, COALESCE(NULLIF(w.tb_desmaga,N''),CONCAT(N'Magazzino ',i.or_magaz)) AS WarehouseName, CASE WHEN a.ar_codart IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS ProductAvailability, CASE WHEN w.tb_codmaga IS NULL THEN N'Non disponibile: verificare la vista' ELSE N'Disponibile' END AS WarehouseAvailability FROM ORDINI i LEFT JOIN ARTICO a ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), a.codditt))) AND (CONVERT(nvarchar(4000), i.or_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_codart))=DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))) LEFT JOIN TABMAGA w ON (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), w.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), w.codditt))) AND i.or_magaz=w.tb_codmaga WHERE i.codditt IS NOT NULL AND i.or_tipork IS NOT NULL AND i.or_anno IS NOT NULL AND i.or_serie IS NOT NULL AND i.or_numord IS NOT NULL AND i.or_riga IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), i.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), i.or_tipork) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_type) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_tipork))=DATALENGTH(CONVERT(nvarchar(4000), :document_type))) AND i.or_anno=:document_year AND (CONVERT(nvarchar(4000), i.or_serie) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :document_series) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), i.or_serie))=DATALENGTH(CONVERT(nvarchar(4000), :document_series))) AND i.or_numord=:document_number",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NTS Business Experience",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"id": "E881DC80-178C-591F-B367-04ACB1B9613A",
"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": "Articolo della riga",
"primaryKey": "ProductKey",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "codditt",
"id": "600298DA-DFCC-5B75-BCE4-11E5F8878C54",
"name": "company",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "or_codart",
"id": "52CEE9C9-7241-588D-9E7E-856CB91F17D2",
"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": "9520B1C9-B384-5027-B40E-F8143BD6009F",
"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 WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webusat END AS UsedState, CASE a.ar_webvend WHEN N'S' THEN N'Sì' WHEN N'N' THEN N'No' ELSE a.ar_webvend END AS SaleState, LEFT(CAST(a.ar_note AS nvarchar(MAX)),500) AS ProductNotes FROM ARTICO a LEFT JOIN TABMARC b ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), b.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), b.codditt))) AND a.ar_codmarc=b.tb_codmarc LEFT JOIN TABGMER g ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), g.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), g.codditt))) AND a.ar_gruppo=g.tb_codgmer LEFT JOIN TABSGME s ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), s.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), s.codditt))) AND a.ar_sotgru=s.tb_codsgme AND a.ar_gruppo=s.tb_codgrupm LEFT JOIN TABCFAM f ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), f.codditt))) AND (CONVERT(nvarchar(4000), a.ar_famprod) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), f.tb_codcfam) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_famprod))=DATALENGTH(CONVERT(nvarchar(4000), f.tb_codcfam))) LEFT JOIN TABSTAG t ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), t.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), t.codditt))) AND a.ar_codstag=t.tb_codstag LEFT JOIN TABSEAT u ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), u.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), u.codditt))) AND a.ar_codseat=u.tb_codseat LEFT JOIN TABFORM v ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), v.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), v.codditt))) AND a.ar_codform=v.tb_codform LEFT JOIN TABDIRE x ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), x.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), x.codditt))) AND a.ar_coddire=x.tb_coddire LEFT JOIN FORNITORI r ON (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), r.codditt) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), r.codditt))) AND a.ar_forn=r.an_conto WHERE a.codditt IS NOT NULL AND a.ar_codart IS NOT NULL AND SCHEMA_NAME() NOT IN (N'guest',N'sys',N'INFORMATION_SCHEMA') AND OBJECT_ID(N'ORDINI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ORDINI',N'V') AND OBJECT_ID(N'ARTICO',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.ARTICO',N'V') AND OBJECT_ID(N'TABMAGA',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMAGA',N'V') AND OBJECT_ID(N'TABMARC',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABMARC',N'V') AND OBJECT_ID(N'TABGMER',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABGMER',N'V') AND OBJECT_ID(N'TABSGME',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSGME',N'V') AND OBJECT_ID(N'TABCFAM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABCFAM',N'V') AND OBJECT_ID(N'TABSTAG',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSTAG',N'V') AND OBJECT_ID(N'TABSEAT',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABSEAT',N'V') AND OBJECT_ID(N'TABFORM',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABFORM',N'V') AND OBJECT_ID(N'TABDIRE',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.TABDIRE',N'V') AND OBJECT_ID(N'FORNITORI',N'V')=OBJECT_ID(QUOTENAME(SCHEMA_NAME())+N'.FORNITORI',N'V') AND (CONVERT(nvarchar(4000), a.codditt) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :company) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.codditt))=DATALENGTH(CONVERT(nvarchar(4000), :company))) AND (CONVERT(nvarchar(4000), a.ar_codart) COLLATE Latin1_General_100_BIN2=CONVERT(nvarchar(4000), :article) COLLATE Latin1_General_100_BIN2 AND DATALENGTH(CONVERT(nvarchar(4000), a.ar_codart))=DATALENGTH(CONVERT(nvarchar(4000), :article)))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "93F7B942-7E49-5C17-A827-6D383A89D918",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "D500CE37-6350-5430-9445-B386B1D67C2A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D1EA5851-FD57-54C0-AFAD-A05C20684479",
"title": "Righe",
"urlKey": ""
}
],
"badgeKey": "HeaderConsistency",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDateCount",
"label": "Righe con data consegna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "FirstDeliveryDay",
"label": "Prima data nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LastDeliveryDay",
"label": "Ultima data nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "91AAB3DD-3BE1-5429-9D9C-E82930E24111",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "or_tipork",
"label": "Codice tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "or_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "or_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "or_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "LineCount",
"label": "Righe presenti nella vista",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegne delle righe — date note",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDateCount",
"label": "Righe con data consegna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderNumber",
"label": "Ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "HeaderConsistency",
"label": "Coerenza della testata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateDay",
"label": "Data ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Ordine e coerenza testata",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateTime",
"label": "Ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegne delle righe — date note",
"detailRole": "information",
"isVisible": true,
"key": "FirstDeliveryDay",
"label": "Prima data consegna nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegne delle righe — date note",
"detailRole": "information",
"isVisible": true,
"key": "LastDeliveryDay",
"label": "Ultima data consegna nota",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegne delle righe — date note",
"detailRole": "information",
"isVisible": true,
"key": "FirstDeliveryDateTime",
"label": "Prima consegna nota (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegne delle righe — date note",
"detailRole": "information",
"isVisible": true,
"key": "LastDeliveryDateTime",
"label": "Ultima consegna nota (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4FF9560F-F4A7-52B4-A5CA-F1C252777498",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "189A97AD-6683-579F-AE71-92C28445FD77",
"includeAllOption": false,
"key": "OrderDate",
"title": "Periodo data ordine",
"type": "date"
},
{
"id": "3663A50F-C644-5EFD-8AE3-FB5090494810",
"includeAllOption": false,
"key": "codditt",
"title": "Ditta",
"type": "text"
},
{
"id": "92BEE055-32A8-5ED9-9F3D-DDD66146277F",
"includeAllOption": false,
"key": "OrderType",
"title": "Tipo ordine",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "06F66C5F-BEE4-553C-95FB-23A18095B576",
"key": "OrderDate",
"type": "date"
},
{
"direction": "ascending",
"id": "E6DC6CBA-8DAF-5077-A998-3D2DE4004901",
"key": "OrderKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "OrderType",
"systemImage": "doc.text",
"title": "Ordini fornitori e produzione",
"titleKey": "OrderNumber"
},
{
"actions": [
{
"id": "23EFA324-6C38-53B2-9F55-F71E52C16ECA",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "B9444A20-6A1E-5BF0-AE16-C62BCB31F7AD",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E881DC80-178C-591F-B367-04ACB1B9613A",
"title": "Articolo",
"urlKey": ""
}
],
"badgeKey": "WarehouseName",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "or_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "or_quant",
"label": "Quantità ordinata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "or_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ArithmeticDifference",
"label": "Differenza ordinata−evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "D1EA5851-FD57-54C0-AFAD-A05C20684479",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "codditt",
"label": "Ditta",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_tipork",
"label": "Codice tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_anno",
"label": "Anno ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_serie",
"label": "Serie ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_numord",
"label": "Numero ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_riga",
"label": "Numero riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_codart",
"label": "Codice articolo",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native — non ricevimento certo",
"detailRole": "information",
"isVisible": true,
"key": "or_ump",
"label": "U.M. principale riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native — non ricevimento certo",
"detailRole": "information",
"isVisible": true,
"key": "or_quant",
"label": "Quantità ordinata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native — non ricevimento certo",
"detailRole": "information",
"isVisible": true,
"key": "or_quaeva",
"label": "Quantità evasa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "or_magaz",
"label": "Codice magazzino",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ProductName",
"label": "Articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "OrderType",
"label": "Tipo ordine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native — non ricevimento certo",
"detailRole": "information",
"isVisible": true,
"key": "ArithmeticDifference",
"label": "Differenza quantità calcolata",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Quantità native — non ricevimento certo",
"detailRole": "information",
"isVisible": true,
"key": "LineState",
"label": "Riga evasa: codice S/C",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "HeaderState",
"label": "Evaso testata (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegna della riga",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDay",
"label": "Data consegna riga",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Consegna della riga",
"detailRole": "information",
"isVisible": true,
"key": "DeliveryDateTime",
"label": "Consegna riga (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "OrderDateTime",
"label": "Ordine (data/ora)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseName",
"label": "Magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "ProductAvailability",
"label": "Anagrafica articolo attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Riga e contesto della fonte",
"detailRole": "information",
"isVisible": true,
"key": "WarehouseAvailability",
"label": "Anagrafica magazzino attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "6A6F441A-7316-5EF4-BEAD-CB403F1D3796",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "31515AE1-F149-5615-8DF5-CB041CBC2B1E",
"key": "or_riga",
"type": "number"
},
{
"direction": "ascending",
"id": "38F61D5E-BAB6-5BA0-9081-0A7F02099C14",
"key": "LineKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "or_codart",
"systemImage": "doc.text",
"title": "Righe ordine",
"titleKey": "ProductName"
},
{
"actions": [],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ar_unmis",
"label": "U.M. principale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "BrandName",
"label": "Marca attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "GroupName",
"label": "Gruppo merceologico",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SubgroupName",
"label": "Sottogruppo coerente",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "UsedState",
"label": "Articolo usato (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "SaleState",
"label": "Vendibile esterno (S/N)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E881DC80-178C-591F-B367-04ACB1B9613A",
"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 — non fornitore ordine",
"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 — non fornitore ordine",
"detailRole": "information",
"isVisible": true,
"key": "SupplierName",
"label": "Fornitore abituale attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale — non fornitore ordine",
"detailRole": "information",
"isVisible": true,
"key": "SupplierExtendedName",
"label": "Fornitore abituale: ragione sociale estesa attuale",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Fornitore abituale attuale — non fornitore ordine",
"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": "C936B4B2-BB24-5506-898D-CA72358ED988",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "6DCA9023-BC8F-5EA2-A774-CA6ED06C3E76",
"key": "ar_descr",
"type": "text"
},
{
"direction": "ascending",
"id": "D548628C-5C21-5B03-B3A8-C42AD3D04106",
"key": "ProductKey",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "ar_codart",
"systemImage": "doc.text",
"title": "Articolo della riga",
"titleKey": "ar_descr"
}
],
"relations": [
{
"childDatasetID": "D1EA5851-FD57-54C0-AFAD-A05C20684479",
"childKey": "ParentOrderKey",
"id": "D500CE37-6350-5430-9445-B386B1D67C2A",
"name": "Righe",
"parentDatasetID": "91AAB3DD-3BE1-5429-9D9C-E82930E24111",
"parentKey": "OrderKey"
},
{
"childDatasetID": "E881DC80-178C-591F-B367-04ACB1B9613A",
"childKey": "ProductKey",
"id": "B9444A20-6A1E-5BF0-AE16-C62BCB31F7AD",
"name": "Articolo",
"parentDatasetID": "D1EA5851-FD57-54C0-AFAD-A05C20684479",
"parentKey": "ProductKey"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NTS Business Experience",
"configurationLanguages": [
"it"
],
"countries": [
"IT"
],
"createdAt": "2026-10-09T00:00:00Z",
"description": "NON UFFICIALE — NON VALIDATA SU UNA INSTALLAZIONE ERP REALE.\n\nPer approvvigionamento, magazzino, pianificazione operativa della produzione e responsabili: seleziona periodo, ditta e tipo. Consulta stato testata, numero righe e intervallo delle date di consegna note. Apri Righe per quantità ordinate/evase, U.M., data consegna e magazzino; Articolo per classificazioni, confezioni, varianti e ragioni sociali del fornitore abituale attuale. È un dossier operativo, non un ordine finanziario completo o un piano di produzione con costi.\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: 12 VISTE READ documentate del DATABASE DI TRANSITO del modulo Collegamento a sistema eCommerce, già installate e autorizzate. Non tabelle native, buffer scrivibili o qualsiasi database NTS. Cifru non crea viste o installa moduli. Verificare licenze, SQL delle viste, proprietario, colonne e unicità/non nullità delle chiavi logiche: grassetto nel manuale non certifica PK SQL. SQL Server 2016+; nessuna connessione Cloud presunta.\n\nPro reale: una fonte, una Home, tre liste e due sotto-pulsanti caricati solo quando aperti. Periodo data ordine, ditta e tipo obbligatori. Massimo 1.000 righe per richiesta, nessun refresh periodico. O=ordine fornitore, H=ordine di produzione; tipo sconosciuto conservato senza riclassificazione. Identità completa ditta/TIPO/anno/serie/numero, più numero riga nelle posizioni. Numeri uguali di tipi o ditte diversi non sono un unico ordine.\n\nCoerenza testata verificata su TUTTE le righe disponibili prima del filtro periodo; data e stato discordanti restano vuoti con avviso, mai scelti arbitrariamente. La data minima disponibile serve SOLO al filtro quando discordante, non è data ordine certa. Righe apre tutte le righe dell’identità, non soltanto quelle del periodo. Non storico/as-of o snapshot atomico. Date prima/ultima consegna sono MIN/MAX delle date NOTE di riga, non promesse o date della testata: il conteggio delle righe con data segnala la copertura. Nessuna data nota significa campi vuoti, non una data inventata. Righe con chiave incompleta escluse; il conteggio non certifica la completezza della vista.\n\nQuantità ordinate ed evase nella U.M. nativa principale or_ump; nessuna conversione, sostituzione con U.M. master o somma tra unità. Differenza=or_quant−or_quaeva è aritmetica, NON quantità certa da ricevere/produrre. NULL non diventa zero; negativi non azzerati. or_flevas S/N della testata conserva anche codici sconosciuti/NULL. or_flevasr S/C resta codice grezzo: non si deduce il significato di C o una conferma di ricevimento/pagamento.\n\nORDINI NON espone il conto del fornitore reale della commessa. Il fornitore abituale dell’articolo, mostrato con le due ragioni sociali attuali, NON è il fornitore dell’ordine. Niente prezzo, valuta, IVA, sconti, totale, pagamento, conferma/rilascio produzione, distinta base o fasi inventati dal manuale funzionale. Non listini generici sostitutivi. Master articoli/magazzini/fornitore sono ATTUALI, non storici; master mancante non cancella ordine o riga. Articolo conserva 41 valori utili attuali; codice IVA non aliquota, classe sconto non percentuale, classificazioni 1–5 codici. Note primi 500 caratteri. Dettagli conserva ora/millisecondi; codici commerciali testo, ordinamento riga numerico. Identità tecniche nascoste, nessun audit/operatore o percorso immagine privato.\n\nFiltro ditta non ACL: account solo SELECT con ambito minimo approvato. Limiti/lazy non garantiscono query economiche; verificare indici, piano e timeout, restringere la selezione al limite. Pacchetto senza server, credenziali, cache o righe aziendali. Documentazione/test sintetici/catture DEMO NON certificano ERP o SQL Server reale. Verificare metadati, collation, chiavi, permessi e lettura limitata prima dell’importazione.\n\nManuale tecnico: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/ambsecinst.htm\nFlusso funzionale ordini: https://servizi.ntsinformatica.it/BusHelpWs/helpnet2024/html/bsorgsor.htm",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "05875F38-CEF9-56C2-BF67-9E9F779C3A19",
"rootButtonCount": 1,
"summary": "Periodo, ditta e tipo: stato, date consegna note, quantità native e dossier articolo su richiesta.",
"tags": [
"NTS Business Experience",
"Business Cube",
"SQL Server",
"Ordini fornitori",
"Produzione",
"Approvvigionamento",
"Magazzino",
"Pro"
],
"title": "Ordini fornitori e produzione, righe e articolo e-commerce — Pro"
}
}