Dosar produs — Pro
Produs → informații complete → oferte de preț → recepții și vânzări facturate în perioada aleasă.
Dosar produs Pro separat de Catalog Free: denumire/cod/EAN, clasă, subclasă, brand, descriere, coduri alternative, unități, ambalare, caracteristici fizice, garanție în luni, origine și observații. La deschidere alegi perioada documentelor și opțional clasa/subclasa. Sub-butoane: oferte/liste de preț cu gestiune, client/grup și monedă; recepții NIR cu furnizor, cantitate, preț, lot și expirare; vânzările facturate cu client, agent, gestiune și document. Nu sunt toate vânzările retail. Nomenclatorul include produsele tip N. Furnizorul din nomenclator nu este automat ultimul furnizor. Ofertele rămân separate după context, monedă și preț; nu sunt prezentate ca un preț unic garantat aplicabil oricărui client. Data documentului de preț nu este o dată de expirare; nu se interpretează un flag cu sens necunoscut ca ofertă expirată. Prețurile sunt valorile înregistrate în Nexus, etichetate separat; Cifru nu face conversii și nu calculează marje din monede diferite. Istoricele sunt restrânse la produsul și perioada aleasă, ordonate înainte de plafonul de 10.000 rânduri. Nomenclator maximum 100.000 produse; pentru colecții mai mari restrânge clasa/subclasa și căutarea. Loturile arătate sunt cele ale documentelor, nu o promisiune de stoc curent pe lot. Căutarea după cod/EAN permite și utilizarea scannerului Cifru. Pro, live, read-only, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-produse/4354 ; https://www.docs.nexuserp.ro/articol/citire-preturi/4293 .
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Produse — dosar complet
- Details: Oferte și liste de preț
- Details: Recepții în perioada aleasă
- Details: Vânzări facturate în perioadă
- Sub-button: Oferte și liste de preț
- Sub-button: Recepțiile produsului
- Sub-button: Vânzările facturate ale produsului
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT h.id_intern AS row_id,h.id_intern AS product_key,
h.denumire,h.cod_extern,h.um,h.den_clasa,h.den_subclasa,h.den_brand,h.descriere,h.cod_selectie_produs,h.lista_coduri,h.status,h.den_grupa,h.den_furnizor,h.um2,h.conv_um2,h.ambalare,h.masa_neta,h.greutate,h.volum,h.lungime,h.latime,h.inaltime,h.culoare,h.cota_tva_ies,h.garantie,h.nume_tara_origine,h.locatie,h.observatii,CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la
FROM dbo.accesex_produse_view h WHERE h.tip='N'static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONVERT(varchar(64),HASHBYTES('SHA2_256',CONCAT(LEN(COALESCE(CONVERT(nvarchar(4000),g.id_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.numar_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.numar_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.data_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.data_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.tip_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.tip_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_gestiune),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_gestiune),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_gestiune),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_gestiune),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_produs),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_produs),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_client),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_client),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_client),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_client),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_grup_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_grup_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_grup_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_grup_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.tip_produs),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.tip_produs),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.cod_pr),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.cod_pr),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare_tva),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare_tva),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.moneda),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.moneda),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.cota_tva_ies),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.cota_tva_ies),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.promotii_permise),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.promotii_permise),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.procent_discount_bonus),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.procent_discount_bonus),N'<NULL>'))),2) AS row_id,
g.id_produs AS product_key,g.numar_document,g.data_document,g.tip_oferta,g.den_gestiune,g.den_client,g.den_grup_oferta,
g.pret_vanzare,g.pret_vanzare_tva,g.moneda,g.cota_tva_ies,g.promotii_permise,g.procent_discount_bonus,g.inregistrari_identice
FROM (SELECT id_document,numar_document,data_document,tip_oferta,id_gestiune,den_gestiune,id_produs,id_client,den_client,id_grup_oferta,den_grup_oferta,tip_produs,cod_pr,pret_vanzare,pret_vanzare_tva,moneda,cota_tva_ies,promotii_permise,procent_discount_bonus,COUNT_BIG(*) AS inregistrari_identice FROM dbo.accesex_preturi_lista_view
WHERE id_produs=:product_key GROUP BY id_document,numar_document,data_document,tip_oferta,id_gestiune,den_gestiune,id_produs,id_client,den_client,id_grup_oferta,den_grup_oferta,tip_produs,cod_pr,pret_vanzare,pret_vanzare_tva,moneda,cota_tva_ies,promotii_permise,procent_discount_bonus) gstatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT l.id_intern AS row_id,l.id_produs AS product_key, CONCAT(h.serie_document,' ',h.numar_document) AS document,h.data_document,h.den_gestiune,h.den_furnizor AS partener, l.cantitate,l.serie_produs,l.data_expirare,l.pret_achizitie,l.pret_vanzare_tva,h.numar_factura,h.data_factura FROM dbo.accesex_note_de_intrare_receptie_lin l JOIN dbo.accesex_note_de_intrare_receptie h ON h.id_document=l.id_document WHERE l.id_produs=:product_key AND h.validare=1 AND h.anulare=0 AND h.data_document>=:period_from AND h.data_document<:period_until
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT l.id_intern AS row_id,l.id_produs AS product_key, CONCAT(h.serie_document,' ',h.numar_document) AS document,h.data_document,h.den_gestiune,h.den_client AS partener, l.cantitate,l.serie_produs,l.data_expirare,h.moneda,h.den_agent,l.pret_vanzare,l.pret_vanzare_tva,l.pret_vanzare_valuta FROM dbo.accesex_facturi_clienti_lin l JOIN dbo.accesex_facturi_clienti h ON h.id_document=l.id_document WHERE l.id_produs=:product_key AND h.validare=1 AND h.anulare=0 AND h.data_document>=:period_from AND h.data_document<:period_until
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "9555E29A-04F2-5255-859E-2EB3FA68D070",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_produse_view",
"dbo.accesex_preturi_lista_view",
"dbo.accesex_note_de_intrare_receptie",
"dbo.accesex_note_de_intrare_receptie_lin",
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "B2550D86-EAEA-57CE-BECF-43806C317197",
"key": "denumire",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "78E4F73E-E672-5B2E-964D-4F28CC2CBC88",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "product_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "denumire",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_extern",
"label": "Cod produs / EAN",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_extern",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_clasa",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_subclasa",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_subclasa",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_brand",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "descriere",
"label": "Descriere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "descriere",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cod_selectie_produs",
"label": "Cod comercial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_selectie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lista_coduri",
"label": "Coduri alternative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lista_coduri",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "status",
"label": "Stare nomenclator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "status",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_grupa",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_grupa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_furnizor",
"label": "Furnizor din nomenclator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "um2",
"label": "UM secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um2",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "conv_um2",
"label": "Conversie UM înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "conv_um2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ambalare",
"label": "Ambalare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ambalare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "masa_neta",
"label": "Masă netă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "masa_neta",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "greutate",
"label": "Greutate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "greutate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "volum",
"label": "Volum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "volum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "lungime",
"label": "Lungime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "lungime",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "latime",
"label": "Lățime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "latime",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inaltime",
"label": "Înălțime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "inaltime",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "culoare",
"label": "Culoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "culoare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "TVA ieșire (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "garantie",
"label": "Garanție — luni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "garantie",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_tara_origine",
"label": "Țara de origine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_tara_origine",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "locatie",
"label": "Locație înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "locatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "observatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Interval ales — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 100000,
"name": "Produse — dosar complet",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "F52311DA-BB94-54FF-AB60-5F6DF2596BFA",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "684F8F6A-D608-5946-8B1D-95201F7D6246",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"denumire",
"cod_extern",
"um",
"den_clasa",
"den_subclasa",
"den_brand",
"descriere",
"cod_selectie_produs",
"lista_coduri",
"status",
"den_grupa",
"den_furnizor",
"um2",
"conv_um2",
"ambalare",
"masa_neta",
"greutate",
"volum",
"lungime",
"latime",
"inaltime",
"culoare",
"cota_tva_ies",
"garantie",
"nume_tara_origine",
"locatie",
"observatii",
"data_de_la",
"data_pana_la"
],
"sourceID": "9555E29A-04F2-5255-859E-2EB3FA68D070",
"sqlQuery": "SELECT h.id_intern AS row_id,h.id_intern AS product_key,\n h.denumire,h.cod_extern,h.um,h.den_clasa,h.den_subclasa,h.den_brand,h.descriere,h.cod_selectie_produs,h.lista_coduri,h.status,h.den_grupa,h.den_furnizor,h.um2,h.conv_um2,h.ambalare,h.masa_neta,h.greutate,h.volum,h.lungime,h.latime,h.inaltime,h.culoare,h.cota_tva_ies,h.garantie,h.nume_tara_origine,h.locatie,h.observatii,CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la\nFROM dbo.accesex_produse_view h WHERE h.tip='N'",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "84F6FE4C-A721-568E-B771-9ACCF0426E89",
"key": "den_gestiune",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "3DF20BC0-D4A4-5E41-AB0E-1FAA35C77FF3",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "product_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Listă / document preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_oferta",
"label": "Tip ofertă în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_oferta",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_client",
"label": "Clientul ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_grup_oferta",
"label": "Grupul ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_grup_oferta",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Moneda ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "promotii_permise",
"label": "Promoții permise",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "promotii_permise",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "procent_discount_bonus",
"label": "Discount bonus (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_discount_bonus",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inregistrari_identice",
"label": "Înregistrări identice în sursă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "inregistrari_identice",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Oferte și liste de preț",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_key",
"id": "9E24112C-F0E2-50F8-9DCE-4DEBA70463D6",
"name": "product_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"numar_document",
"data_document",
"tip_oferta",
"den_gestiune",
"den_client",
"den_grup_oferta",
"pret_vanzare",
"pret_vanzare_tva",
"moneda",
"cota_tva_ies",
"promotii_permise",
"procent_discount_bonus",
"inregistrari_identice"
],
"sourceID": "9555E29A-04F2-5255-859E-2EB3FA68D070",
"sqlQuery": "SELECT CONVERT(varchar(64),HASHBYTES('SHA2_256',CONCAT(LEN(COALESCE(CONVERT(nvarchar(4000),g.id_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.numar_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.numar_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.data_document),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.data_document),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.tip_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.tip_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_gestiune),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_gestiune),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_gestiune),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_gestiune),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_produs),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_produs),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_client),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_client),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_client),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_client),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.id_grup_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.id_grup_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.den_grup_oferta),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.den_grup_oferta),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.tip_produs),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.tip_produs),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.cod_pr),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.cod_pr),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare_tva),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.pret_vanzare_tva),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.moneda),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.moneda),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.cota_tva_ies),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.cota_tva_ies),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.promotii_permise),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.promotii_permise),N'<NULL>'),LEN(COALESCE(CONVERT(nvarchar(4000),g.procent_discount_bonus),N'<NULL>')),N':',COALESCE(CONVERT(nvarchar(4000),g.procent_discount_bonus),N'<NULL>'))),2) AS row_id,\n g.id_produs AS product_key,g.numar_document,g.data_document,g.tip_oferta,g.den_gestiune,g.den_client,g.den_grup_oferta,\n g.pret_vanzare,g.pret_vanzare_tva,g.moneda,g.cota_tva_ies,g.promotii_permise,g.procent_discount_bonus,g.inregistrari_identice\nFROM (SELECT id_document,numar_document,data_document,tip_oferta,id_gestiune,den_gestiune,id_produs,id_client,den_client,id_grup_oferta,den_grup_oferta,tip_produs,cod_pr,pret_vanzare,pret_vanzare_tva,moneda,cota_tva_ies,promotii_permise,procent_discount_bonus,COUNT_BIG(*) AS inregistrari_identice FROM dbo.accesex_preturi_lista_view\n WHERE id_produs=:product_key GROUP BY id_document,numar_document,data_document,tip_oferta,id_gestiune,den_gestiune,id_produs,id_client,den_client,id_grup_oferta,den_grup_oferta,tip_produs,cod_pr,pret_vanzare,pret_vanzare_tva,moneda,cota_tva_ies,promotii_permise,procent_discount_bonus) g",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "06FD35D1-864B-5AF8-8833-4091CDC8A1FA",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "product_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "partener",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_factura",
"label": "Factura furnizorului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Recepțiile produsului",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "F8FFD657-14D6-5B0F-B018-7B3DF39D74A8",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "34E1BBCD-E2B7-5B2C-AC0B-7D1552B69225",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_key",
"id": "9E24112C-F0E2-50F8-9DCE-4DEBA70463D6",
"name": "product_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"document",
"data_document",
"den_gestiune",
"partener",
"cantitate",
"serie_produs",
"data_expirare",
"pret_achizitie",
"pret_vanzare_tva",
"numar_factura",
"data_factura"
],
"sourceID": "9555E29A-04F2-5255-859E-2EB3FA68D070",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_produs AS product_key,\n CONCAT(h.serie_document,' ',h.numar_document) AS document,h.data_document,h.den_gestiune,h.den_furnizor AS partener,\n l.cantitate,l.serie_produs,l.data_expirare,l.pret_achizitie,l.pret_vanzare_tva,h.numar_factura,h.data_factura\nFROM dbo.accesex_note_de_intrare_receptie_lin l JOIN dbo.accesex_note_de_intrare_receptie h ON h.id_document=l.id_document\nWHERE l.id_produs=:product_key AND h.validare=1 AND h.anulare=0 AND h.data_document>=:period_from AND h.data_document<:period_until",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "9C01B785-3B96-51CD-9871-3B0A99CF2CC2",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_key",
"label": "product_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "partener",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț fără TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_valuta",
"label": "Preț fără TVA în moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_valuta",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Vânzările facturate ale produsului",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "F8FFD657-14D6-5B0F-B018-7B3DF39D74A8",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "34E1BBCD-E2B7-5B2C-AC0B-7D1552B69225",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_key",
"id": "9E24112C-F0E2-50F8-9DCE-4DEBA70463D6",
"name": "product_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"document",
"data_document",
"den_gestiune",
"partener",
"cantitate",
"serie_produs",
"data_expirare",
"moneda",
"den_agent",
"pret_vanzare",
"pret_vanzare_tva",
"pret_vanzare_valuta"
],
"sourceID": "9555E29A-04F2-5255-859E-2EB3FA68D070",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_produs AS product_key,\n CONCAT(h.serie_document,' ',h.numar_document) AS document,h.data_document,h.den_gestiune,h.den_client AS partener,\n l.cantitate,l.serie_produs,l.data_expirare,h.moneda,h.den_agent,l.pret_vanzare,l.pret_vanzare_tva,l.pret_vanzare_valuta\nFROM dbo.accesex_facturi_clienti_lin l JOIN dbo.accesex_facturi_clienti h ON h.id_document=l.id_document\nWHERE l.id_produs=:product_key AND h.validare=1 AND h.anulare=0 AND h.data_document>=:period_from AND h.data_document<:period_until",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "362AB9EF-418B-55D5-9C81-4DCBCDDF3B18",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A6DA1116-E699-51F8-94A2-DABF5BDB9235",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "3DF20BC0-D4A4-5E41-AB0E-1FAA35C77FF3",
"title": "Oferte și liste de preț",
"urlKey": ""
},
{
"id": "D3367A8C-5F8F-5C20-8ADB-D7AE997858BD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A9DC4C0B-832E-5ABF-AC37-1F1EEDC407A0",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "06FD35D1-864B-5AF8-8833-4091CDC8A1FA",
"title": "Recepții în perioada aleasă",
"urlKey": ""
},
{
"id": "618D29D3-8C73-5766-9A51-65DCE06D5168",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C72DB156-DAB8-538A-AF08-75E46C8F1BD2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9C01B785-3B96-51CD-9871-3B0A99CF2CC2",
"title": "Vânzări facturate în perioadă",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_subclasa",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "78E4F73E-E672-5B2E-964D-4F28CC2CBC88",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_subclasa",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_brand",
"label": "Brand",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "descriere",
"label": "Descriere",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_selectie_produs",
"label": "Cod comercial",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lista_coduri",
"label": "Coduri alternative",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Stare nomenclator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_grupa",
"label": "Grupă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor din nomenclator",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um2",
"label": "UM secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "conv_um2",
"label": "Conversie UM înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ambalare",
"label": "Ambalare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "masa_neta",
"label": "Masă netă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "greutate",
"label": "Greutate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "volum",
"label": "Volum",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "lungime",
"label": "Lungime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "latime",
"label": "Lățime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "inaltime",
"label": "Înălțime",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "culoare",
"label": "Culoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "TVA ieșire (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "garantie",
"label": "Garanție — luni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_tara_origine",
"label": "Țara de origine",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "locatie",
"label": "Locație înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Interval ales — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "17A15CCC-F8AB-5343-98E1-36E5692F898A",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "B09ECA06-B930-5170-BEA7-3DD508E1FBBA",
"includeAllOption": false,
"key": "period_date",
"title": "Perioada documentelor",
"type": "date"
},
{
"id": "B268B58D-2FB5-578D-A2C6-193A591A507E",
"includeAllOption": true,
"key": "den_clasa",
"title": "Clasă",
"type": "text"
},
{
"id": "48A95F03-7676-5CE1-B891-7C6355C7CE5E",
"includeAllOption": true,
"key": "den_subclasa",
"title": "Subclasă",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "B2550D86-EAEA-57CE-BECF-43806C317197",
"key": "denumire",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_extern",
"systemImage": "person.2",
"title": "Produse — dosar complet",
"titleKey": "denumire"
},
{
"actions": [],
"badgeKey": "pret_vanzare_tva",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_oferta",
"label": "Tip ofertă în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "3DF20BC0-D4A4-5E41-AB0E-1FAA35C77FF3",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_oferta",
"label": "Tip ofertă în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Clientul ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_grup_oferta",
"label": "Grupul ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda ofertei",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "promotii_permise",
"label": "Promoții permise",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_discount_bonus",
"label": "Discount bonus (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "inregistrari_identice",
"label": "Înregistrări identice în sursă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2A84942B-72C4-5DBC-97C6-091B0D16CB46",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "84F6FE4C-A721-568E-B771-9ACCF0426E89",
"key": "den_gestiune",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "doc.text",
"title": "Oferte și liste de preț",
"titleKey": "den_gestiune"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "06FD35D1-864B-5AF8-8833-4091CDC8A1FA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_factura",
"label": "Factura furnizorului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "027FFC97-FFD2-55E8-8648-08E0789EBC72",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "document",
"systemImage": "doc.text",
"title": "Recepțiile produsului",
"titleKey": "partener"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "9C01B785-3B96-51CD-9871-3B0A99CF2CC2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA (RON)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_valuta",
"label": "Preț fără TVA în moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "EF7B0739-D8C0-50DE-B7DE-1720B6947EDD",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "document",
"systemImage": "doc.text",
"title": "Vânzările facturate ale produsului",
"titleKey": "partener"
}
],
"relations": [
{
"childDatasetID": "3DF20BC0-D4A4-5E41-AB0E-1FAA35C77FF3",
"childKey": "product_key",
"id": "A6DA1116-E699-51F8-94A2-DABF5BDB9235",
"name": "Oferte și liste de preț",
"parentDatasetID": "78E4F73E-E672-5B2E-964D-4F28CC2CBC88",
"parentKey": "product_key"
},
{
"childDatasetID": "06FD35D1-864B-5AF8-8833-4091CDC8A1FA",
"childKey": "product_key",
"id": "A9DC4C0B-832E-5ABF-AC37-1F1EEDC407A0",
"name": "Recepții în perioada aleasă",
"parentDatasetID": "78E4F73E-E672-5B2E-964D-4F28CC2CBC88",
"parentKey": "product_key"
},
{
"childDatasetID": "9C01B785-3B96-51CD-9871-3B0A99CF2CC2",
"childKey": "product_key",
"id": "C72DB156-DAB8-538A-AF08-75E46C8F1BD2",
"name": "Vânzări facturate în perioadă",
"parentDatasetID": "78E4F73E-E672-5B2E-964D-4F28CC2CBC88",
"parentKey": "product_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T10:27:45Z",
"description": "Dosar produs Pro separat de Catalog Free: denumire/cod/EAN, clasă, subclasă, brand, descriere, coduri alternative, unități, ambalare, caracteristici fizice, garanție în luni, origine și observații. La deschidere alegi perioada documentelor și opțional clasa/subclasa. Sub-butoane: oferte/liste de preț cu gestiune, client/grup și monedă; recepții NIR cu furnizor, cantitate, preț, lot și expirare; vânzările facturate cu client, agent, gestiune și document. Nu sunt toate vânzările retail. Nomenclatorul include produsele tip N. Furnizorul din nomenclator nu este automat ultimul furnizor. Ofertele rămân separate după context, monedă și preț; nu sunt prezentate ca un preț unic garantat aplicabil oricărui client. Data documentului de preț nu este o dată de expirare; nu se interpretează un flag cu sens necunoscut ca ofertă expirată. Prețurile sunt valorile înregistrate în Nexus, etichetate separat; Cifru nu face conversii și nu calculează marje din monede diferite. Istoricele sunt restrânse la produsul și perioada aleasă, ordonate înainte de plafonul de 10.000 rânduri. Nomenclator maximum 100.000 produse; pentru colecții mai mari restrânge clasa/subclasa și căutarea. Loturile arătate sunt cele ale documentelor, nu o promisiune de stoc curent pe lot. Căutarea după cod/EAN permite și utilizarea scannerului Cifru. Pro, live, read-only, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-produse/4354 ; https://www.docs.nexuserp.ro/articol/citire-preturi/4293 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "755C4185-6657-5ED5-9FDC-F679DEFCD98E",
"rootButtonCount": 1,
"summary": "Produs → informații complete → oferte de preț → recepții și vânzări facturate în perioada aleasă.",
"tags": [
"NexusERP",
"Pro"
],
"title": "Dosar produs — Pro"
}
}