NIR — Pro
NIR → produse → comandă și istoric achiziții; factura asociată cu produse, scadență, sold și plăți.
Note de intrare-recepție read-only, cu antet și linii separate și legate prin id_document. Cheile au fost verificate live: antetele și liniile au identificatori unici, iar toate liniile testate au antet corespondent.
Varianta Starter conține datele necesare recepției: număr, dată, furnizor, gestiune, valoare și produse. Varianta Pro organizează suplimentar factura furnizorului, trasabilitatea, conturile și adaugă două indicatoare exacte pentru luna curentă. Nu presupune că NIR și factura sunt același document și nu construiește join după numărul liber al facturii.
Configurare:
1. Creează un login SQL read-only cu SELECT pe cele două obiecte AccesEx.
2. Adaugă sursa SQL Server în Cifru cu TLS și testează structura.
3. Importă pachetul, mapează slotul și rulează testul local.
Pachet neoficial, fără afiliere NexusERP.
CONTROL RECEPȚIE: NIR → facturile asociate prin liniile Nexus → produsele facturii și plățile repartizate. Din produsul NIR deschizi comanda sa de aprovizionare, când există referința nativă, și istoricul achizițiilor aceluiași produs/furnizor pe 12 luni până la NIR. Comanda arată cantitatea inițială și curentă, recepționat, onorat, diferența algebrică, UM, termen și stare. Diferențele negative nu sunt ascunse. Nu se deduc relații după numărul facturii sau numele produsului. O legătură neînregistrată produce o listă asociată goală, nu un document ghicit. Prețurile din surse și monedele sunt păstrate fără conversii. Loturile, expirările, prețurile, câmpurile utile și cache-ul original NIR sunt păstrate. Noile sub-butoane citesc numai contextul selectat. Nu modifică Performanță creare NIR. Manuale: https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie/4350 ; https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie-linii/4351 .
Screenshots
What this package creates
1 Home6 Details8 lists1 sources to map
- Home: Note de intrare-recepție
- Details: Linii NIR
- Details: Facturile recepției
- Details: Produsele facturii
- Details: Plăți repartizate
- Details: Comanda acestui produs
- Details: Achiziții de la același furnizor
- Sub-button: Linii recepție
- Sub-button: Sumar NIR
- Sub-button: Facturile recepției
- Sub-button: Produsele facturii asociate
- Sub-button: Plăți repartizate facturii
- Sub-button: Comanda produsului recepționat
- Sub-button: Achizițiile produsului de la furnizor
Sources are mapped locally and verified before applying.
Custom queriesPRO7 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.1.sqlQuerySELECT l.id_intern,l.id_document,l.id_produs,l.cod_produs,l.den_produs,l.denumire_sup,l.serie_produs,l.cantitate,l.cantitate_2,l.pret_achizitie,l.pret_vanzare,l.pret_vanzare_tva,l.cota_tva_int,l.cota_tva_ies,l.cont_produs,l.data_intrare,l.data_expirare,l.procent_rabat,h.id_furnizor,h.data_document FROM dbo.accesex_note_de_intrare_receptie_lin l JOIN dbo.accesex_note_de_intrare_receptie h ON h.id_document=l.id_document
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT
CAST('luna_curenta' AS varchar(30)) AS row_id,
COUNT_BIG(*) AS nr_nir,
COUNT(DISTINCT id_furnizor) AS nr_furnizori,
COUNT(DISTINCT id_gestiune) AS nr_gestiuni,
CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS valoare_receptionata
FROM dbo.accesex_note_de_intrare_receptie WITH (NOLOCK)
WHERE data_document >= DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1)
AND data_document < DATEADD(month, 1, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1))
AND ISNULL(anulare, 0) = 0static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT h.id_document,h.id_furnizor,h.den_furnizor,h.serie_document,h.numar_document,h.data_document, h.den_gestiune,h.moneda,h.valoare,h.valoare_cu_tva,b.data_lim,b.platitval,b.neplt_val,h.observatii,h.validare,h.anulare ,:receipt_id AS parent_key FROM dbo.accesex_facturi_furnizori h JOIN dbo.fur_view b ON h.id_document=CONCAT(b.anluna,'_',CONVERT(varchar(10),b.pct_lcr),'_',CONVERT(varchar(30),b.id)) WHERE EXISTS(SELECT 1 FROM dbo.liniinir r JOIN dbo.linfactfurnizori l ON l.pct_lcr=r.pl_lff AND l.id=r.id_lff WHERE :receipt_id=CONCAT(r.anluna,'_',r.pl_nir,'_',r.id_nir) AND h.id_document=CONCAT(l.anluna,'_',l.pl_fct,'_',l.id_fct))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT l.id_intern AS row_id,l.id_document,l.id_produs,h.id_furnizor,h.moneda, l.den_produs,l.cod_produs,l.cantitate,l.pret_achizitie,l.cota_tva_int,l.cont_produs,l.denumire_sup, l.data_intrare,l.data_expirare,l.procent_rabat,l.nr_nir,l.data_nir FROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document WHERE l.id_document=:invoice_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.5.sqlQuerySELECT CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document)) AS row_id, RTRIM(l.id_factura) AS invoice_id,RTRIM(l.tip_financiar) AS tip_financiar, MAX(h.document) AS document,MAX(h.data_document) AS data_document,MAX(h.data_decont) AS data_decont, MAX(h.tip_document) AS tip_document,MAX(h.moneda) AS moneda,MAX(h.cont) AS cont_banca, MAX(h.explicatii) AS explicatii,SUM(l.suma_repartizata) AS suma_repartizata,COUNT_BIG(*) AS nr_repartizari FROM dbo.accesex_incasari_plati_lin_view l JOIN (SELECT tip_financiar,id_document,MAX(CONCAT(RTRIM(serie_document),' ',RTRIM(numar_document))) AS document, MAX(data_document) AS data_document,MAX(data_decont) AS data_decont,MAX(tip_document) AS tip_document, CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(moneda),''))=1 AND COUNT(NULLIF(RTRIM(moneda),''))=COUNT(*) THEN MAX(RTRIM(moneda)) ELSE N'Monedă de verificat' END AS moneda, MAX(RTRIM(cont)) AS cont,MAX(explicatii) AS explicatii FROM dbo.accesex_incasari_plati_view WHERE validare=1 GROUP BY tip_financiar,id_document) h ON h.tip_financiar=l.tip_financiar AND h.id_document=l.id_document WHERE l.tip_factura='FUR' AND l.id_factura=:invoice_id GROUP BY l.tip_financiar,l.id_document,l.id_factura
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.6.sqlQuerySELECT CONCAT(o.anluna,'_',o.pct_lcr,'_',o.id) AS row_id,:receipt_line AS receipt_line, h.den_furnizor,h.numar_document,h.data_document,h.data_livrare,h.den_gestiune,h.status, o.denpr,o.cod_ext,o.um,o.cant_com,o.cantitate,o.receptionat,o.onorat, o.cantitate-o.receptionat AS diferenta_de_primit,o.pu,o.presc, N'Diferența este algebrică: comandat minus recepționat conform Nexus. Valoarea negativă indică depășire, nu este ascunsă.' AS explicatie FROM dbo.liniinir r JOIN dbo.lincomnzfurnizori_view o ON o.pct_lcr=r.pl_cmdf AND o.id=r.id_cmdf JOIN dbo.accesex_comenzi_furnizori h ON h.id_document=CONCAT(o.anluna,'_',o.pl_cmd,'_',o.id_cmd) WHERE :receipt_line=CONCAT(r.anluna,'_',r.pct_lcr,'_',r.id)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.7.sqlQuerySELECT l.id_intern AS row_id,l.id_produs,l.den_produs,l.cod_produs,h.id_furnizor,h.den_furnizor, h.numar_document,h.data_document,h.moneda,h.den_gestiune,l.cantitate,l.pret_achizitie,l.procent_rabat, v.um AS unitate,N'Ultimele 12 luni până la documentul selectat. Prețurile nu se convertesc și se compară numai în aceeași UM și monedă.' AS explicatie FROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document JOIN dbo.linfactfurnizori_view v ON v.anluna=l._anluna AND v.pct_lcr=l._pct_lcr AND v.id=l._id WHERE l.id_produs=:product_id AND h.id_furnizor=:supplier_id AND h.validare=1 AND h.anulare=0 AND h.data_document>=DATEADD(month,-12,CAST(:document_date AS date)) AND h.data_document<DATEADD(day,1,CAST(:document_date AS date))
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_note_de_intrare_receptie",
"dbo.accesex_note_de_intrare_receptie_lin",
"dbo.accesex_facturi_furnizori",
"dbo.fur_view",
"dbo.accesex_facturi_furnizori_lin",
"dbo.accesex_incasari_plati_view",
"dbo.accesex_incasari_plati_lin_view",
"dbo.linfactfurnizori_view",
"dbo.liniinir",
"dbo.linfactfurnizori",
"dbo.lincomnzfurnizori_view",
"dbo.accesex_comenzi_furnizori"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_number",
"key": "numar_document",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "supplier_name",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif_furnizor",
"label": "CIF furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nir_amanunt",
"label": "NIR cu amănunt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nir_amanunt",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_clasificare",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_clasificare",
"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": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_cr",
"label": "Creată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_cr",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_md",
"label": "Modificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_md",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 3000,
"name": "Note de intrare-recepție",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"serie_document",
"numar_document",
"data_document",
"den_furnizor",
"cif_furnizor",
"den_gestiune",
"numar_factura",
"tip_document",
"nir_amanunt",
"den_clasificare",
"observatii",
"validare",
"anulare"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "",
"tableName": "dbo.accesex_note_de_intrare_receptie"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"mappings": [
{
"commonFieldKey": "",
"key": "id_intern",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire_sup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate_2",
"label": "Cantitate secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate_2",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_int",
"label": "Cotă TVA intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_int",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_intrare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_rabat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "id_furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Linii NIR",
"primaryKey": "id_intern",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cod_produs",
"den_produs",
"denumire_sup",
"serie_produs",
"cont_produs",
"data_document"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT l.id_intern,l.id_document,l.id_produs,l.cod_produs,l.den_produs,l.denumire_sup,l.serie_produs,l.cantitate,l.cantitate_2,l.pret_achizitie,l.pret_vanzare,l.pret_vanzare_tva,l.cota_tva_int,l.cota_tva_ies,l.cont_produs,l.data_intrare,l.data_expirare,l.procent_rabat,h.id_furnizor,h.data_document FROM dbo.accesex_note_de_intrare_receptie_lin l JOIN dbo.accesex_note_de_intrare_receptie h ON h.id_document=l.id_document",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_nir",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_furnizori",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_gestiuni",
"label": "Gestiuni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_gestiuni",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_receptionata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1,
"name": "Sumar NIR",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"nr_nir",
"nr_furnizori",
"nr_gestiuni",
"valoare_receptionata"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT\n CAST('luna_curenta' AS varchar(30)) AS row_id,\n COUNT_BIG(*) AS nr_nir,\n COUNT(DISTINCT id_furnizor) AS nr_furnizori,\n COUNT(DISTINCT id_gestiune) AS nr_gestiuni,\n CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS valoare_receptionata\nFROM dbo.accesex_note_de_intrare_receptie WITH (NOLOCK)\nWHERE data_document >= DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1)\n AND data_document < DATEADD(month, 1, DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1))\n AND ISNULL(anulare, 0) = 0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "EDFD78D4-A02D-5EBF-8C7C-D5B8D0EC457D",
"key": "id_document",
"type": "text"
}
],
"id": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "id_document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "id_furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data facturii",
"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": "moneda",
"label": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare fără TVA — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "platitval",
"label": "Plătit în Nexus — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "platitval",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "neplt_val",
"label": "Rest în Nexus — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "neplt_val",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "observatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "parent_key",
"label": "parent_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "parent_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Facturile recepției",
"primaryKey": "id_document",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "BD3EA2D0-1192-5E5A-953E-9A77B9BD53EE",
"name": "receipt_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_furnizor",
"serie_document",
"numar_document",
"data_document",
"den_gestiune",
"moneda",
"valoare",
"valoare_cu_tva",
"data_lim",
"platitval",
"neplt_val",
"observatii",
"validare",
"anulare"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT h.id_document,h.id_furnizor,h.den_furnizor,h.serie_document,h.numar_document,h.data_document,\n h.den_gestiune,h.moneda,h.valoare,h.valoare_cu_tva,b.data_lim,b.platitval,b.neplt_val,h.observatii,h.validare,h.anulare\n ,:receipt_id AS parent_key\nFROM dbo.accesex_facturi_furnizori h JOIN dbo.fur_view b ON h.id_document=CONCAT(b.anluna,'_',CONVERT(varchar(10),b.pct_lcr),'_',CONVERT(varchar(30),b.id))\nWHERE EXISTS(SELECT 1 FROM dbo.liniinir r JOIN dbo.linfactfurnizori l ON l.pct_lcr=r.pl_lff AND l.id=r.id_lff\n WHERE :receipt_id=CONCAT(r.anluna,'_',r.pl_nir,'_',r.id_nir)\n AND h.id_document=CONCAT(l.anluna,'_',l.pl_fct,'_',l.id_fct))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "3D4F6170-0D04-54A1-8BC0-DD406D63A711",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "id_document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "id_produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "id_furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"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": "pret_achizitie",
"label": "Preț achiziție fără TVA — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cota_tva_int",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_int",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire_sup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_intrare",
"type": "date",
"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": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_rabat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_nir",
"label": "NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_nir",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_nir",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_nir",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Produsele facturii asociate",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "FFCF905B-2289-5F05-8A95-05AD56FBEEC2",
"name": "invoice_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"cantitate",
"pret_achizitie",
"moneda",
"cota_tva_int",
"cont_produs",
"denumire_sup",
"data_intrare",
"data_expirare",
"procent_rabat",
"nr_nir",
"data_nir"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_document,l.id_produs,h.id_furnizor,h.moneda,\n l.den_produs,l.cod_produs,l.cantitate,l.pret_achizitie,l.cota_tva_int,l.cont_produs,l.denumire_sup,\n l.data_intrare,l.data_expirare,l.procent_rabat,l.nr_nir,l.data_nir\nFROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document\nWHERE l.id_document=:invoice_id",
"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": "E01A9F58-00B4-52B4-B2D6-62FFF65DEA5E",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "invoice_id",
"label": "invoice_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_financiar",
"label": "Tip financiar Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_financiar",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "document",
"label": "Document financiar repartizat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "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": true
},
{
"commonFieldKey": "",
"key": "data_decont",
"label": "Data decontului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_decont",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Moneda documentului financiar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cont_banca",
"label": "Cont financiar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_banca",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "suma_repartizata",
"label": "Sumă repartizată din Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma_repartizata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_repartizari",
"label": "Înregistrări de repartizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_repartizari",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Plăți repartizate facturii",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "FFCF905B-2289-5F05-8A95-05AD56FBEEC2",
"name": "invoice_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"tip_financiar",
"document",
"data_document",
"data_decont",
"tip_document",
"moneda",
"cont_banca",
"explicatii",
"suma_repartizata",
"nr_repartizari"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document)) AS row_id,\n RTRIM(l.id_factura) AS invoice_id,RTRIM(l.tip_financiar) AS tip_financiar,\n MAX(h.document) AS document,MAX(h.data_document) AS data_document,MAX(h.data_decont) AS data_decont,\n MAX(h.tip_document) AS tip_document,MAX(h.moneda) AS moneda,MAX(h.cont) AS cont_banca,\n MAX(h.explicatii) AS explicatii,SUM(l.suma_repartizata) AS suma_repartizata,COUNT_BIG(*) AS nr_repartizari\nFROM dbo.accesex_incasari_plati_lin_view l\nJOIN (SELECT tip_financiar,id_document,MAX(CONCAT(RTRIM(serie_document),' ',RTRIM(numar_document))) AS document,\n MAX(data_document) AS data_document,MAX(data_decont) AS data_decont,MAX(tip_document) AS tip_document,\n CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(moneda),''))=1 AND COUNT(NULLIF(RTRIM(moneda),''))=COUNT(*) THEN MAX(RTRIM(moneda)) ELSE N'Monedă de verificat' END AS moneda,\n MAX(RTRIM(cont)) AS cont,MAX(explicatii) AS explicatii\n FROM dbo.accesex_incasari_plati_view WHERE validare=1 GROUP BY tip_financiar,id_document) h\n ON h.tip_financiar=l.tip_financiar AND h.id_document=l.id_document\nWHERE l.tip_factura='FUR' AND l.id_factura=:invoice_id\nGROUP BY l.tip_financiar,l.id_document,l.id_factura",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
"key": "denpr",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "74C139F2-F982-5EBB-95A3-818616B8CBCF",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "receipt_line",
"label": "receipt_line",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "receipt_line",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Comandă nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_livrare",
"label": "Livrare prevăzută",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_livrare",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "status",
"label": "Starea comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "status",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "denpr",
"label": "Produs comandat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denpr",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_ext",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_ext",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cant_com",
"label": "Cantitate inițială comandată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cant_com",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate comandată curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "receptionat",
"label": "Recepționat conform Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "receptionat",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "onorat",
"label": "Onorat conform Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "onorat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "diferenta_de_primit",
"label": "Comandat minus recepționat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "diferenta_de_primit",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pu",
"label": "Preț comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "presc",
"label": "Monedă preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "presc",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "explicatie",
"label": "Interpretarea diferenței",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Comanda produsului recepționat",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_intern",
"id": "74EAC6B2-2F52-5D84-903A-B5968715BC3A",
"name": "receipt_line",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_furnizor",
"numar_document",
"data_document",
"data_livrare",
"den_gestiune",
"status",
"denpr",
"cod_ext",
"um",
"cant_com",
"cantitate",
"receptionat",
"onorat",
"diferenta_de_primit",
"pu",
"presc",
"explicatie"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT CONCAT(o.anluna,'_',o.pct_lcr,'_',o.id) AS row_id,:receipt_line AS receipt_line,\n h.den_furnizor,h.numar_document,h.data_document,h.data_livrare,h.den_gestiune,h.status,\n o.denpr,o.cod_ext,o.um,o.cant_com,o.cantitate,o.receptionat,o.onorat,\n o.cantitate-o.receptionat AS diferenta_de_primit,o.pu,o.presc,\n N'Diferența este algebrică: comandat minus recepționat conform Nexus. Valoarea negativă indică depășire, nu este ascunsă.' AS explicatie\nFROM dbo.liniinir r JOIN dbo.lincomnzfurnizori_view o ON o.pct_lcr=r.pl_cmdf AND o.id=r.id_cmdf\nJOIN dbo.accesex_comenzi_furnizori h ON h.id_document=CONCAT(o.anluna,'_',o.pl_cmd,'_',o.id_cmd)\nWHERE :receipt_line=CONCAT(r.anluna,'_',r.pct_lcr,'_',r.id)",
"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": "E0E4F3A0-7A41-5F56-BAA5-BB472CAC69BE",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "id_produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_furnizor",
"label": "id_furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_furnizor",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_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": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție fără TVA — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "procent_rabat",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "unitate",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "unitate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "explicatie",
"label": "Cum compari prețurile",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatie",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 1000,
"name": "Achizițiile produsului de la furnizor",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_produs",
"id": "8BC79BB5-596A-55A9-A83A-610D63D32A6D",
"name": "product_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_furnizor",
"id": "B51188EE-BC13-51E3-B377-2A56DBBAA9B6",
"name": "supplier_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "data_document",
"id": "3389725F-2232-59C3-B859-A9F27CE475D0",
"name": "document_date",
"source": "parentField",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"den_furnizor",
"numar_document",
"data_document",
"moneda",
"den_gestiune",
"cantitate",
"pret_achizitie",
"procent_rabat",
"unitate",
"explicatie"
],
"sourceID": "13585AF3-1175-5312-8798-9ADDDB7F38C5",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_produs,l.den_produs,l.cod_produs,h.id_furnizor,h.den_furnizor,\n h.numar_document,h.data_document,h.moneda,h.den_gestiune,l.cantitate,l.pret_achizitie,l.procent_rabat,\n v.um AS unitate,N'Ultimele 12 luni până la documentul selectat. Prețurile nu se convertesc și se compară numai în aceeași UM și monedă.' AS explicatie\nFROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document\nJOIN dbo.linfactfurnizori_view v ON v.anluna=l._anluna AND v.pct_lcr=l._pct_lcr AND v.id=l._id\nWHERE l.id_produs=:product_id AND h.id_furnizor=:supplier_id AND h.validare=1 AND h.anulare=0\n AND h.data_document>=DATEADD(month,-12,CAST(:document_date AS date)) AND h.data_document<DATEADD(day,1,CAST(:document_date AS date))",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "4E8CA39E-A759-5017-8DD3-21E61399B689",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "07503C26-3FAA-5868-A89D-25C7B093344B",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"title": "Linii recepție",
"urlKey": ""
},
{
"id": "85DA73C5-704B-588F-A91F-9499F0A1BC27",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "23E3C481-BB83-56C2-8B9C-E59837A493FA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"title": "Facturile recepției",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_furnizor",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif_furnizor",
"label": "CIF furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare",
"label": "Valoare recepție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Factura furnizorului",
"detailRole": "highlight",
"isVisible": true,
"key": "numar_factura",
"label": "Număr factură furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Factura furnizorului",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nir_amanunt",
"label": "NIR cu amănunt",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_clasificare",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Control document",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Control document",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "data_cr",
"label": "Creată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "data_md",
"label": "Modificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9905A91D-169B-5E47-BC15-6FD46A435F92",
"openFilters": [
{
"id": "35EB1D9B-BCAC-58EC-B53A-1C2AE05876F4",
"includeAllOption": true,
"key": "den_gestiune",
"title": "Gestiune",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "723E8DB4-9D57-5F9E-A5AC-8C76D8CF30AE",
"includeAllOption": false,
"key": "data_document",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "shippingbox",
"title": "Note de intrare-recepție",
"titleKey": "den_furnizor"
},
{
"actions": [
{
"id": "1E05627D-7558-557F-83CA-699206079BD1",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "CF433E70-911B-5AD2-A140-16AE84EF7914",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "74C139F2-F982-5EBB-95A3-818616B8CBCF",
"title": "Comanda acestui produs",
"urlKey": ""
},
{
"id": "14560EEF-DCE9-58B6-97B3-B04050C587A9",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C3BF021B-D4B7-5EA1-947F-A519EAD92E0F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E0E4F3A0-7A41-5F56-BAA5-BB472CAC69BE",
"title": "Achiziții de la același furnizor",
"urlKey": ""
}
],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_intern",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_document",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Serie produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "cantitate_2",
"label": "Cantitate secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "highlight",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Cantități și prețuri",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_int",
"label": "Cotă TVA intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA ieșire",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Trasabilitate",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context recepție",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "D92C86DB-0C1B-52BE-A440-C123C12B1D41",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "list.bullet.rectangle",
"title": "Linii recepție",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "valoare_receptionata",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "row_id",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "NIR în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_gestiuni",
"label": "Gestiuni",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_receptionata",
"label": "Valoare recepționată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B70EB616-F728-50F4-94B4-391F14A6D087",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "",
"systemImage": "chart.bar",
"title": "Sumar NIR",
"titleKey": "row_id"
},
{
"actions": [
{
"id": "11F2ADD5-D7E5-5F54-BCF8-9865223DD96C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "809B8916-533A-50EF-B2F3-730494874E19",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "3D4F6170-0D04-54A1-8BC0-DD406D63A711",
"title": "Produsele facturii",
"urlKey": ""
},
{
"id": "5ED26B5A-3B95-5612-9A5B-9A3030661DE9",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "350DAFCE-2963-5775-AF35-6E29D8843935",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E01A9F58-00B4-52B4-B2D6-62FFF65DEA5E",
"title": "Plăți repartizate",
"urlKey": ""
}
],
"badgeKey": "neplt_val",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data facturii",
"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": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data facturii",
"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": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare fără TVA — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "platitval",
"label": "Plătit în Nexus — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "66E970C3-2D7B-529F-B64B-44B2A4A726D4",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "EDFD78D4-A02D-5EBF-8C7C-D5B8D0EC457D",
"key": "id_document",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "doc.text",
"title": "Facturile recepției",
"titleKey": "den_furnizor"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție fără TVA — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "3D4F6170-0D04-54A1-8BC0-DD406D63A711",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție fără TVA — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_int",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_nir",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "989AE7E1-EB6A-5196-827C-ED99E6BAF9A5",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "doc.text",
"title": "Produsele facturii asociate",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "suma_repartizata",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda documentului financiar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E01A9F58-00B4-52B4-B2D6-62FFF65DEA5E",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_financiar",
"label": "Tip financiar Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_decont",
"label": "Data decontului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda documentului financiar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_banca",
"label": "Cont financiar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_repartizari",
"label": "Înregistrări de repartizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E91A6369-36E8-522E-B2A4-714EC66F64BD",
"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": "tip_document",
"systemImage": "doc.text",
"title": "Plăți repartizate facturii",
"titleKey": "document"
},
{
"actions": [],
"badgeKey": "diferenta_de_primit",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_livrare",
"label": "Livrare prevăzută",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Starea comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate comandată curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "receptionat",
"label": "Recepționat conform Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "74C139F2-F982-5EBB-95A3-818616B8CBCF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_livrare",
"label": "Livrare prevăzută",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status",
"label": "Starea comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_ext",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cant_com",
"label": "Cantitate inițială comandată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate comandată curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "receptionat",
"label": "Recepționat conform Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "onorat",
"label": "Onorat conform Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu",
"label": "Preț comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "presc",
"label": "Monedă preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatie",
"label": "Interpretarea diferenței",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C066DCC7-422D-5057-9702-13049050C9A6",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
"key": "denpr",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "numar_document",
"systemImage": "doc.text",
"title": "Comanda produsului recepționat",
"titleKey": "denpr"
},
{
"actions": [],
"badgeKey": "pret_achizitie",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unitate",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E0E4F3A0-7A41-5F56-BAA5-BB472CAC69BE",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"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_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "unitate",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatie",
"label": "Cum compari prețurile",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "666DA40E-AD19-5098-8744-6667E8559D5C",
"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": "numar_document",
"systemImage": "doc.text",
"title": "Achizițiile produsului de la furnizor",
"titleKey": "den_produs"
}
],
"relations": [
{
"childDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"childKey": "id_document",
"id": "07503C26-3FAA-5868-A89D-25C7B093344B",
"name": "Linii NIR",
"parentDatasetID": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"parentKey": "id_document"
},
{
"childDatasetID": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"childKey": "parent_key",
"id": "23E3C481-BB83-56C2-8B9C-E59837A493FA",
"name": "Facturile recepției",
"parentDatasetID": "53031BAF-CFAD-5398-BCD1-A90B0FC51FE5",
"parentKey": "id_document"
},
{
"childDatasetID": "3D4F6170-0D04-54A1-8BC0-DD406D63A711",
"childKey": "id_document",
"id": "809B8916-533A-50EF-B2F3-730494874E19",
"name": "Produsele facturii",
"parentDatasetID": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"parentKey": "id_document"
},
{
"childDatasetID": "E01A9F58-00B4-52B4-B2D6-62FFF65DEA5E",
"childKey": "invoice_id",
"id": "350DAFCE-2963-5775-AF35-6E29D8843935",
"name": "Plăți repartizate",
"parentDatasetID": "A523D6F1-7E56-5A0C-8CFA-E823591124C4",
"parentKey": "id_document"
},
{
"childDatasetID": "74C139F2-F982-5EBB-95A3-818616B8CBCF",
"childKey": "receipt_line",
"id": "CF433E70-911B-5AD2-A140-16AE84EF7914",
"name": "Comanda acestui produs",
"parentDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"parentKey": "id_intern"
},
{
"childDatasetID": "E0E4F3A0-7A41-5F56-BAA5-BB472CAC69BE",
"childKey": "id_produs",
"id": "C3BF021B-D4B7-5EA1-947F-A519EAD92E0F",
"name": "Achiziții de la același furnizor",
"parentDatasetID": "21C6C760-01AA-593A-BB27-1BD71BED12CC",
"parentKey": "id_produs"
}
],
"widgets": [
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "910E10C9-268A-51A5-9DFB-A4C02B1D2C1A",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "NIR luna curentă",
"titleKey": "",
"valueKey": "nr_nir"
},
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "02C27544-F7D7-5D29-9D89-74979667D8C1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "1729C3F6-9B69-58EC-A477-81A58DD254A7",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Valoare recepționată luna curentă",
"titleKey": "",
"valueKey": "valoare_receptionata"
}
]
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-28T06:20:15Z",
"description": "Note de intrare-recepție read-only, cu antet și linii separate și legate prin id_document. Cheile au fost verificate live: antetele și liniile au identificatori unici, iar toate liniile testate au antet corespondent.\n\nVarianta Starter conține datele necesare recepției: număr, dată, furnizor, gestiune, valoare și produse. Varianta Pro organizează suplimentar factura furnizorului, trasabilitatea, conturile și adaugă două indicatoare exacte pentru luna curentă. Nu presupune că NIR și factura sunt același document și nu construiește join după numărul liber al facturii.\n\nConfigurare:\n1. Creează un login SQL read-only cu SELECT pe cele două obiecte AccesEx.\n2. Adaugă sursa SQL Server în Cifru cu TLS și testează structura.\n3. Importă pachetul, mapează slotul și rulează testul local.\n\nPachet neoficial, fără afiliere NexusERP.\n\nCONTROL RECEPȚIE: NIR → facturile asociate prin liniile Nexus → produsele facturii și plățile repartizate. Din produsul NIR deschizi comanda sa de aprovizionare, când există referința nativă, și istoricul achizițiilor aceluiași produs/furnizor pe 12 luni până la NIR. Comanda arată cantitatea inițială și curentă, recepționat, onorat, diferența algebrică, UM, termen și stare. Diferențele negative nu sunt ascunse. Nu se deduc relații după numărul facturii sau numele produsului. O legătură neînregistrată produce o listă asociată goală, nu un document ghicit. Prețurile din surse și monedele sunt păstrate fără conversii. Loturile, expirările, prețurile, câmpurile utile și cache-ul original NIR sunt păstrate. Noile sub-butoane citesc numai contextul selectat. Nu modifică Performanță creare NIR. Manuale: https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie/4350 ; https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie-linii/4351 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "BB3E3BA1-167C-5AF3-97E4-5BD34D3017D3",
"rootButtonCount": 1,
"summary": "NIR → produse → comandă și istoric achiziții; factura asociată cu produse, scadență, sold și plăți.",
"tags": [
"NexusERP",
"NIR",
"recepții",
"stoc",
"read-only"
],
"title": "NIR — Pro"
}
}