Facturi furnizori — Pro
Factură → sold și scadență → plăți repartizate → NIR și produse; achiziții anterioare pe produs și furnizor.
Facturi furnizori read-only, cu antet și linii legate exclusiv prin id_document — relație verificată live pe schema AccesEx. Numărul și data NIR sunt afișate numai din câmpurile reale ale facturii/liniilor; pachetul nu inventează o legătură de document când Nexus nu o expune.
Varianta Starter include factura, furnizorul, data, valoarea cu TVA și liniile de produse/servicii. Varianta Pro adaugă câmpurile contabile și de recepție în layout, două indicatoare exacte pentru luna curentă, sold/rulaje pe furnizor și istoricul facturilor/plăților în „Relația comercială”.
Configurare:
1. Creează un login SQL dedicat Cifru cu SELECT numai pe obiectele enumerate.
2. În Cifru adaugă o sursă SQL Server cu TLS, apoi testează structura.
3. Importă pachetul, mapează slotul și rulează testul local înainte de aplicare.
În Pro, „Sold contabil de plată” provine din funcția urmarire_parteneri. Raportul Nexus de scadențe exacte este o procedură separată și lentă, pe care Cifru nu o execută; de aceea pachetul nu prezintă soldul drept listă exactă de facturi scadente. Pachet neoficial, fără afiliere NexusERP.
DOSAR ACHIZIȚIE: factura are scadență și sub-butoane pentru soldul propriu, plăți repartizate și NIR-urile asociate prin liniile documentelor. NIR-ul deschide produsele recepționate. Dintr-o linie a facturii vezi achizițiile aceluiași produs de la același furnizor, în cele 12 luni până la data documentului, cu UM, monedă, cantitate, preț și rabat. Nu se ghicesc legături după numărul imprimat. Soldul facturii folosește câmpurile native Nexus în moneda documentului, fără conversii Cifru. Repartizările financiare nu sunt echivalente cu numerar decontat și nu se forțează egalitatea lor cu soldul. NIR-urile sunt numai cele legate efectiv în Nexus, nu orice recepție cu același furnizor/produs. Documentele anulate/nevalidate rămân identificabile prin starea lor. Politicile cache, listele și câmpurile utile existente sunt păstrate; noile desfășurătoare se citesc la cerere. Istoricul de produs are maximum 1.000 rânduri. Manuale: https://www.docs.nexuserp.ro/articol/citire-facturi-furnizori/4342 ; https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie/4350 .
Screenshots
What this package creates
1 Home8 Details10 lists1 sources to map
- Home: Facturi furnizori
- Details: Linii factură
- Details: Sold furnizor
- Details: Relație comercială
- Details: Sold și scadență factură
- Details: Plăți repartizate
- Details: Recepțiile facturii
- Details: Produsele recepției
- Details: Achiziții de la același furnizor
- Sub-button: Linii factură furnizor
- Sub-button: Sold și rulaje furnizor
- Sub-button: Relația comercială cu furnizorul
- Sub-button: Sumar facturi furnizori
- Sub-button: Soldul facturii din Nexus
- Sub-button: Plăți repartizate facturii
- Sub-button: Recepțiile facturii
- Sub-button: Produsele recepției asociate
- Sub-button: Achizițiile produsului de la furnizor
Sources are mapped locally and verified before applying.
Custom queriesPRO10 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT h.id_document,h.id_furnizor,h.serie_document,h.numar_document,h.data_document,h.den_furnizor,h.cif_furnizor,h.den_gestiune,h.valoare,h.valoare_cu_tva,h.moneda,h.numar_nir,h.data_nir,h.tip_document,h.den_clasificare,h.observatii,h.taxare_inversa,h.tva_la_incasare,h.validare,h.anulare,h.data_cr,h.data_md,b.data_lim FROM dbo.accesex_facturi_furnizori h JOIN dbo.fur b ON h.id_document=CONCAT(b.anluna,'_',CONVERT(varchar(10),b.pct_lcr),'_',CONVERT(varchar(30),b.id))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT l.id_linie_document,l.id_document,l.id_produs,l.cod_produs,l.den_produs,l.denumire_sup,l.cantitate,l.pret_achizitie,l.cota_tva_int,l.cont_produs,l.nr_nir,l.data_nir,l.data_intrare,l.data_expirare,l.procent_rabat,l.serie_cmd_furnizor,l.numar_cmd_furnizor,l.data_cmd_furnizor,l.gestiune_cmd_furnizor,h.id_furnizor,h.data_document,h.moneda FROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT
CONCAT(CAST(id AS varchar(30)), '(', CAST(pct_lcr AS varchar(10)), ')') AS id_partener,
LTRIM(RTRIM(nume)) AS furnizor,
LTRIM(RTRIM(cod_fiscal)) AS cif,
CAST(SdFnCrt401 AS decimal(19, 2)) AS sold_contabil,
CAST(sold_cu_efecte_401 AS decimal(19, 2)) AS sold_cu_efecte,
CAST(TotCumpAn AS decimal(19, 2)) AS cumparari_an,
CAST(TotPlAn AS decimal(19, 2)) AS plati_an,
CAST(pr_pl AS decimal(19, 2)) AS termen_mediu_plata
FROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()), 'F', NULL, NULL, NULL, 1)static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQueryWITH miscari AS (
SELECT
CONCAT('F|', LTRIM(RTRIM(f.id_document))) AS row_id,
f.id_furnizor AS id_partener,
CAST('Factură' AS nvarchar(20)) AS tip_miscare,
f.data_document,
CONCAT(LTRIM(RTRIM(f.serie_document)), ' ', LTRIM(RTRIM(f.numar_document))) AS document,
CAST(f.valoare_cu_tva AS decimal(19, 2)) AS valoare,
LTRIM(RTRIM(f.moneda)) AS moneda,
LTRIM(RTRIM(f.den_gestiune)) AS gestiune,
LTRIM(RTRIM(f.observatii)) AS explicatii
FROM dbo.accesex_facturi_furnizori f WITH (NOLOCK)
WHERE ISNULL(f.anulare, 0) = 0
UNION ALL
SELECT
CONCAT(
'P|', LTRIM(RTRIM(v.id_document)), '|',
ROW_NUMBER() OVER (
PARTITION BY v.id_document
ORDER BY v.data_document, v.suma, v.cont, v.cont_coresp, v.id_coresp
)
) AS row_id,
v.id_coresp AS id_partener,
CAST('Plată' AS nvarchar(20)) AS tip_miscare,
CAST(v.data_document AS date) AS data_document,
CONCAT(LTRIM(RTRIM(v.serie_document)), ' ', LTRIM(RTRIM(v.numar_document))) AS document,
CAST(v.suma AS decimal(19, 2)) AS valoare,
LTRIM(RTRIM(v.moneda)) AS moneda,
CAST('' AS nvarchar(200)) AS gestiune,
LTRIM(RTRIM(v.explicatii)) AS explicatii
FROM dbo.accesex_incasari_plati_view v WITH (NOLOCK)
WHERE v.plata = 1
AND LTRIM(RTRIM(v.tip_coresp)) = 'P'
AND v.cont_coresp LIKE '401%'
)
SELECT row_id, id_partener, tip_miscare, data_document, document,
valoare, moneda, gestiune, explicatii
FROM miscaristatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT
CAST('luna_curenta' AS varchar(30)) AS row_id,
COUNT_BIG(*) AS nr_facturi,
COUNT(DISTINCT id_furnizor) AS nr_furnizori,
CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS total_fara_tva,
CAST(SUM(ISNULL(valoare_cu_tva, 0)) AS decimal(19, 2)) AS total_cu_tva
FROM dbo.accesex_facturi_furnizori 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.5.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 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 h.id_document=:invoice_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.6.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.7.sqlQuerySELECT n.id_document,:invoice_id AS invoice_id,n.den_furnizor,n.numar_document,n.data_document, n.den_gestiune,n.valoare,n.numar_factura,n.data_factura,n.observatii,n.validare,n.anulare FROM dbo.accesex_note_de_intrare_receptie n 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 n.id_document=CONCAT(r.anluna,'_',r.pl_nir,'_',r.id_nir) AND :invoice_id=CONCAT(l.anluna,'_',l.pl_fct,'_',l.id_fct))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.8.sqlQuerySELECT l.id_intern AS row_id,l.id_document,l.id_produs,l.den_produs,l.cod_produs,l.cantitate,l.cantitate_2, l.pret_achizitie,l.pret_vanzare,l.pret_vanzare_tva,l.cota_tva_int,l.serie_produs,l.data_expirare,l.denumire_sup FROM dbo.accesex_note_de_intrare_receptie_lin l WHERE l.id_document=:receipt_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.9.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": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_facturi_furnizori",
"dbo.accesex_facturi_furnizori_lin",
"dbo.accesex_incasari_plati_view",
"dbo.urmarire_parteneri",
"dbo.fur_view",
"dbo.accesex_incasari_plati_lin_view",
"dbo.accesex_note_de_intrare_receptie_lin",
"dbo.liniinir",
"dbo.linfactfurnizori",
"dbo.accesex_note_de_intrare_receptie",
"dbo.linfactfurnizori_view",
"dbo.fur"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"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": "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 factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data facturii",
"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 fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_nir",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_nir",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_nir",
"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": 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": "taxare_inversa",
"label": "Taxare inversă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "taxare_inversa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tva_la_incasare",
"label": "TVA la încasare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tva_la_incasare",
"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
},
{
"commonFieldKey": "",
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_lim",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 3000,
"name": "Facturi furnizori",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"serie_document",
"numar_document",
"data_document",
"den_furnizor",
"cif_furnizor",
"den_gestiune",
"moneda",
"numar_nir",
"tip_document",
"den_clasificare",
"observatii",
"taxare_inversa",
"tva_la_incasare",
"validare",
"anulare",
"data_lim"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT h.id_document,h.id_furnizor,h.serie_document,h.numar_document,h.data_document,h.den_furnizor,h.cif_furnizor,h.den_gestiune,h.valoare,h.valoare_cu_tva,h.moneda,h.numar_nir,h.data_nir,h.tip_document,h.den_clasificare,h.observatii,h.taxare_inversa,h.tva_la_incasare,h.validare,h.anulare,h.data_cr,h.data_md,b.data_lim FROM dbo.accesex_facturi_furnizori h JOIN dbo.fur b ON h.id_document=CONCAT(b.anluna,'_',CONVERT(varchar(10),b.pct_lcr),'_',CONVERT(varchar(30),b.id))",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"mappings": [
{
"commonFieldKey": "",
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_linie_document",
"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": "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 / serviciu",
"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": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"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 contabil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_nir",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_nir",
"label": "Data NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_nir",
"type": "date",
"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": "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": "serie_cmd_furnizor",
"label": "Serie comandă furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_cmd_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_cmd_furnizor",
"label": "Număr comandă furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_cmd_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_cmd_furnizor",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_cmd_furnizor",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "gestiune_cmd_furnizor",
"label": "Gestiune comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "gestiune_cmd_furnizor",
"type": "text",
"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 facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Linii facturi furnizori",
"primaryKey": "id_linie_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"cod_produs",
"den_produs",
"denumire_sup",
"cont_produs",
"serie_cmd_furnizor",
"numar_cmd_furnizor",
"gestiune_cmd_furnizor",
"data_document",
"moneda"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT l.id_linie_document,l.id_document,l.id_produs,l.cod_produs,l.den_produs,l.denumire_sup,l.cantitate,l.pret_achizitie,l.cota_tva_int,l.cont_produs,l.nr_nir,l.data_nir,l.data_intrare,l.data_expirare,l.procent_rabat,l.serie_cmd_furnizor,l.numar_cmd_furnizor,l.data_cmd_furnizor,l.gestiune_cmd_furnizor,h.id_furnizor,h.data_document,h.moneda FROM dbo.accesex_facturi_furnizori_lin l JOIN dbo.accesex_facturi_furnizori h ON h.id_document=l.id_document",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "49058E55-D72C-55CA-A84A-59569528CDB1",
"mappings": [
{
"commonFieldKey": "",
"key": "id_partener",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_partener",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cif",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold_contabil",
"label": "Sold contabil de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_contabil",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sold_cu_efecte",
"label": "Sold cu efecte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold_cu_efecte",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cumparari_an",
"label": "Cumpărări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cumparari_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "plati_an",
"label": "Plăți în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "plati_an",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "termen_mediu_plata",
"label": "Termen mediu de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "termen_mediu_plata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Situație furnizori",
"primaryKey": "id_partener",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"furnizor",
"cif",
"sold_contabil",
"sold_cu_efecte"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT\n CONCAT(CAST(id AS varchar(30)), '(', CAST(pct_lcr AS varchar(10)), ')') AS id_partener,\n LTRIM(RTRIM(nume)) AS furnizor,\n LTRIM(RTRIM(cod_fiscal)) AS cif,\n CAST(SdFnCrt401 AS decimal(19, 2)) AS sold_contabil,\n CAST(sold_cu_efecte_401 AS decimal(19, 2)) AS sold_cu_efecte,\n CAST(TotCumpAn AS decimal(19, 2)) AS cumparari_an,\n CAST(TotPlAn AS decimal(19, 2)) AS plati_an,\n CAST(pr_pl AS decimal(19, 2)) AS termen_mediu_plata\nFROM dbo.urmarire_parteneri(dbo.anluna(GETDATE()), 'F', NULL, NULL, NULL, 1)",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "6534709C-C58F-5A30-83F3-3F4DEB18A991",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_partener",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_partener",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_miscare",
"label": "Tip",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_miscare",
"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": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Relație comercială furnizor",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"tip_miscare",
"data_document",
"document",
"moneda",
"gestiune",
"explicatii"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "WITH miscari AS (\n SELECT\n CONCAT('F|', LTRIM(RTRIM(f.id_document))) AS row_id,\n f.id_furnizor AS id_partener,\n CAST('Factură' AS nvarchar(20)) AS tip_miscare,\n f.data_document,\n CONCAT(LTRIM(RTRIM(f.serie_document)), ' ', LTRIM(RTRIM(f.numar_document))) AS document,\n CAST(f.valoare_cu_tva AS decimal(19, 2)) AS valoare,\n LTRIM(RTRIM(f.moneda)) AS moneda,\n LTRIM(RTRIM(f.den_gestiune)) AS gestiune,\n LTRIM(RTRIM(f.observatii)) AS explicatii\n FROM dbo.accesex_facturi_furnizori f WITH (NOLOCK)\n WHERE ISNULL(f.anulare, 0) = 0\n\n UNION ALL\n\n SELECT\n CONCAT(\n 'P|', LTRIM(RTRIM(v.id_document)), '|',\n ROW_NUMBER() OVER (\n PARTITION BY v.id_document\n ORDER BY v.data_document, v.suma, v.cont, v.cont_coresp, v.id_coresp\n )\n ) AS row_id,\n v.id_coresp AS id_partener,\n CAST('Plată' AS nvarchar(20)) AS tip_miscare,\n CAST(v.data_document AS date) AS data_document,\n CONCAT(LTRIM(RTRIM(v.serie_document)), ' ', LTRIM(RTRIM(v.numar_document))) AS document,\n CAST(v.suma AS decimal(19, 2)) AS valoare,\n LTRIM(RTRIM(v.moneda)) AS moneda,\n CAST('' AS nvarchar(200)) AS gestiune,\n LTRIM(RTRIM(v.explicatii)) AS explicatii\n FROM dbo.accesex_incasari_plati_view v WITH (NOLOCK)\n WHERE v.plata = 1\n AND LTRIM(RTRIM(v.tip_coresp)) = 'P'\n AND v.cont_coresp LIKE '401%'\n)\nSELECT row_id, id_partener, tip_miscare, data_document, document,\n valoare, moneda, gestiune, explicatii\nFROM miscari",
"tableName": ""
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [],
"id": "B8D7A9BE-65C3-58F6-B721-E68590BBCFDD",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "Perioadă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_facturi",
"label": "Facturi în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_facturi",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_furnizori",
"label": "Furnizori în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_furnizori",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "total_fara_tva",
"label": "Total fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_fara_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "total_cu_tva",
"label": "Total cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "total_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 1,
"name": "Sumar facturi furnizori",
"primaryKey": "row_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"row_id",
"nr_facturi",
"nr_furnizori",
"total_fara_tva",
"total_cu_tva"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT\n CAST('luna_curenta' AS varchar(30)) AS row_id,\n COUNT_BIG(*) AS nr_facturi,\n COUNT(DISTINCT id_furnizor) AS nr_furnizori,\n CAST(SUM(ISNULL(valoare, 0)) AS decimal(19, 2)) AS total_fara_tva,\n CAST(SUM(ISNULL(valoare_cu_tva, 0)) AS decimal(19, 2)) AS total_cu_tva\nFROM dbo.accesex_facturi_furnizori 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": "B2E7FEDE-129B-53D1-A6B9-7BA8F447207C",
"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
}
],
"maxRows": 5000,
"name": "Soldul facturii din Nexus",
"primaryKey": "id_document",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "F8437A1A-1A56-573A-A982-C6C40CD72553",
"name": "invoice_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": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"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 \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 h.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": "D5BFB788-111E-5A43-B96F-6336F3D22BA7",
"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": "F8437A1A-1A56-573A-A982-C6C40CD72553",
"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": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"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": "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": "CC584FC9-513B-5916-85EE-27E31404B6BA",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "id_document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"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": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "NIR nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data NIR",
"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": "valoare",
"label": "Valoare recepție din Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_factura",
"label": "Factura înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_factura",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"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
}
],
"maxRows": 5000,
"name": "Recepțiile facturii",
"primaryKey": "id_document",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "F8437A1A-1A56-573A-A982-C6C40CD72553",
"name": "invoice_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_furnizor",
"numar_document",
"data_document",
"den_gestiune",
"valoare",
"numar_factura",
"data_factura",
"observatii",
"validare",
"anulare"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT n.id_document,:invoice_id AS invoice_id,n.den_furnizor,n.numar_document,n.data_document,\n n.den_gestiune,n.valoare,n.numar_factura,n.data_factura,n.observatii,n.validare,n.anulare\nFROM dbo.accesex_note_de_intrare_receptie n\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 n.id_document=CONCAT(r.anluna,'_',r.pl_nir,'_',r.id_nir)\n AND :invoice_id=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": "09C4134C-9427-5F98-8969-99695B46A351",
"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": "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 recepționată",
"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 în NIR",
"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": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire_sup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Produsele recepției asociate",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_document",
"id": "31073980-7857-50CD-9909-4A9C58326DBC",
"name": "receipt_id",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"cantitate",
"cantitate_2",
"pret_achizitie",
"pret_vanzare",
"pret_vanzare_tva",
"cota_tva_int",
"serie_produs",
"data_expirare",
"denumire_sup"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_document,l.id_produs,l.den_produs,l.cod_produs,l.cantitate,l.cantitate_2,\n l.pret_achizitie,l.pret_vanzare,l.pret_vanzare_tva,l.cota_tva_int,l.serie_produs,l.data_expirare,l.denumire_sup\nFROM dbo.accesex_note_de_intrare_receptie_lin l WHERE l.id_document=:receipt_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": "9634CE2E-7603-5760-83E3-6D114B072AA5",
"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": "494F5334-B231-5644-B47C-FED9FFE866DA",
"name": "product_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "id_furnizor",
"id": "547E37EF-40A1-5197-A1B2-6825D5901FCB",
"name": "supplier_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "data_document",
"id": "498DC8C4-AD84-5D8A-A512-9D378A202218",
"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": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"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": "4D6502F7-CE85-5AB7-B34B-982A47743734",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "D13B5C8E-57BF-53C0-9BDC-ECBC8429B7CD",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"title": "Linii factură",
"urlKey": ""
},
{
"id": "BED1B6EA-7F4A-514C-9935-FA8F48504EF7",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "04271218-951E-5DBF-9B91-AA647018941F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6534709C-C58F-5A30-83F3-3F4DEB18A991",
"title": "Relația comercială cu furnizorul",
"urlKey": ""
},
{
"id": "57697E26-40DD-58F0-97C4-F8C5AD26FC1E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "89ED2CC6-25B5-5F9A-B8F8-4BFC6477EDD6",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "49058E55-D72C-55CA-A84A-59569528CDB1",
"title": "Sold și rulaje furnizor",
"urlKey": ""
},
{
"id": "562E3721-B45F-5545-A46B-ABE36EDE58BD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "77F87FED-C7C3-5B89-897A-DC8304ACD2D2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "B2E7FEDE-129B-53D1-A6B9-7BA8F447207C",
"title": "Sold și scadență factură",
"urlKey": ""
},
{
"id": "DF4CA86C-F603-5A35-A2BE-BBD8434A55F6",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "8C57586E-3D65-55F7-B6AA-68C859AE7776",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "D5BFB788-111E-5A43-B96F-6336F3D22BA7",
"title": "Plăți repartizate",
"urlKey": ""
},
{
"id": "F71A61CC-DAD3-53E6-85C2-E6CE88352C0F",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1308F8AE-B43A-565B-885F-B6298080F339",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CC584FC9-513B-5916-85EE-27E31404B6BA",
"title": "Recepțiile facturii",
"urlKey": ""
}
],
"badgeKey": "valoare_cu_tva",
"cardEnrichments": [
{
"fields": [
{
"childKey": "sold_contabil",
"id": "117788D2-B05D-5975-AA33-5F5DA4174385",
"label": "Sold de plată",
"presentation": "text"
}
],
"id": "85A95A8D-8CF0-524E-95F7-9AF013BD33E2",
"relationID": "89ED2CC6-25B5-5F9A-B8F8-4BFC6477EDD6",
"title": "Situație furnizor"
}
],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr factură",
"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 facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Plată",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_document",
"label": "ID document",
"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 factură",
"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_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": "Valori",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Valori",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recepție",
"detailRole": "highlight",
"isVisible": true,
"key": "numar_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recepție",
"detailRole": "information",
"isVisible": true,
"key": "data_nir",
"label": "Data NIR",
"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": "den_clasificare",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "observatii",
"label": "Observații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "taxare_inversa",
"label": "Taxare inversă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tva_la_incasare",
"label": "TVA la încasare",
"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"
},
{
"detailGroup": "Plată",
"detailRole": "information",
"isVisible": true,
"key": "data_lim",
"label": "Scadență",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "823AB397-CCC5-5A50-80F1-7DE6DE77E00F",
"openFilters": [
{
"id": "35EB1D9B-BCAC-58EC-B53A-1C2AE05876F4",
"includeAllOption": true,
"key": "den_gestiune",
"title": "Gestiune",
"type": "text"
},
{
"id": "43E88CE2-90BC-53B6-BAB8-9635C325B22C",
"includeAllOption": true,
"key": "den_furnizor",
"title": "Furnizor",
"type": "text"
}
],
"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": "doc.text",
"title": "Facturi furnizori",
"titleKey": "den_furnizor"
},
{
"actions": [
{
"id": "6E4BD659-5BA0-5E3F-AED5-6D269EEDD78E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "53A89C31-49CB-51D9-A7D3-CE65C6D25A36",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9634CE2E-7603-5760-83E3-6D114B072AA5",
"title": "Achiziții de la același furnizor",
"urlKey": ""
}
],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs / serviciu",
"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 contabil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context achiziție",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_document",
"label": "ID document",
"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 / serviciu",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"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": "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": "cota_tva_int",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Încadrare contabilă",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont contabil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recepție",
"detailRole": "information",
"isVisible": true,
"key": "nr_nir",
"label": "Număr NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Recepție",
"detailRole": "information",
"isVisible": true,
"key": "data_nir",
"label": "Data NIR",
"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": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "procent_rabat",
"label": "Rabat (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_cmd_furnizor",
"label": "Serie comandă furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_cmd_furnizor",
"label": "Număr comandă furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_cmd_furnizor",
"label": "Data comenzii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "gestiune_cmd_furnizor",
"label": "Gestiune comandă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context achiziție",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Context achiziție",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Moneda facturii",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3D1A09A8-30C2-562E-9AD5-CCEE83225EA7",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "list.bullet.rectangle",
"title": "Linii factură furnizor",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "sold_contabil",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_contabil",
"label": "Sold contabil de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cumparari_an",
"label": "Cumpărări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "plati_an",
"label": "Plăți în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "49058E55-D72C-55CA-A84A-59569528CDB1",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_partener",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cif",
"label": "CIF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "sold_contabil",
"label": "Sold contabil de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold_cu_efecte",
"label": "Sold cu efecte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cumparari_an",
"label": "Cumpărări în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "plati_an",
"label": "Plăți în anul curent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "termen_mediu_plata",
"label": "Termen mediu de plată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "2BE004B4-87AD-5EBC-9DCA-0D8913C7102A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "",
"systemImage": "creditcard",
"title": "Sold și rulaje furnizor",
"titleKey": "furnizor"
},
{
"actions": [],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_miscare",
"label": "Tip",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6534709C-C58F-5A30-83F3-3F4DEB18A991",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "row_id",
"label": "ID mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": false,
"key": "id_partener",
"label": "ID furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_miscare",
"label": "Tip",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "45BB9010-9796-5416-81FC-421E102887BE",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "tip_miscare",
"systemImage": "arrow.left.arrow.right",
"title": "Relația comercială cu furnizorul",
"titleKey": "document"
},
{
"actions": [],
"badgeKey": "total_cu_tva",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_facturi",
"label": "Facturi în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_cu_tva",
"label": "Total cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "B8D7A9BE-65C3-58F6-B721-E68590BBCFDD",
"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_facturi",
"label": "Facturi în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_furnizori",
"label": "Furnizori în luna curentă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "total_fara_tva",
"label": "Total fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "total_cu_tva",
"label": "Total cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "B72BF0E1-CB35-514E-B497-F6EACAE0F998",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "",
"systemImage": "chart.bar",
"title": "Sumar facturi furnizori",
"titleKey": "row_id"
},
{
"actions": [],
"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": "B2E7FEDE-129B-53D1-A6B9-7BA8F447207C",
"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": "55AEF09C-814D-5578-B598-C8AB4A244C71",
"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": "Soldul facturii din Nexus",
"titleKey": "den_furnizor"
},
{
"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": "D5BFB788-111E-5A43-B96F-6336F3D22BA7",
"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": "C64CBEE1-C4DB-52DD-977E-971EC29BAA3A",
"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": [
{
"id": "CBB44AAF-B23E-520B-BB1D-0BEABE9EB96C",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "1EF1DF5E-B49E-5E5C-AEFC-F11B949F541C",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "09C4134C-9427-5F98-8969-99695B46A351",
"title": "Produsele recepției",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"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"
}
],
"datasetID": "CC584FC9-513B-5916-85EE-27E31404B6BA",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"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": "numar_factura",
"label": "Factura înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii",
"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": "0BBCE5E8-9389-556F-8C90-C207A738EA98",
"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": "den_furnizor",
"systemImage": "doc.text",
"title": "Recepțiile facturii",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "09C4134C-9427-5F98-8969-99695B46A351",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate_2",
"label": "Cantitate secundară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție în NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"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": "serie_produs",
"label": "Lot / serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "E6DF3A36-CB4B-5C29-B1FE-827B98DD1FAE",
"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 recepției asociate",
"titleKey": "den_produs"
},
{
"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": "9634CE2E-7603-5760-83E3-6D114B072AA5",
"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": "80C0BE3F-3A8B-5505-8A47-AF1BAA857CC4",
"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": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"childKey": "id_document",
"id": "D13B5C8E-57BF-53C0-9BDC-ECBC8429B7CD",
"name": "Linii factură",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_document"
},
{
"childDatasetID": "49058E55-D72C-55CA-A84A-59569528CDB1",
"childKey": "id_partener",
"id": "89ED2CC6-25B5-5F9A-B8F8-4BFC6477EDD6",
"name": "Sold furnizor",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_furnizor"
},
{
"childDatasetID": "6534709C-C58F-5A30-83F3-3F4DEB18A991",
"childKey": "id_partener",
"id": "04271218-951E-5DBF-9B91-AA647018941F",
"name": "Relație comercială",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_furnizor"
},
{
"childDatasetID": "B2E7FEDE-129B-53D1-A6B9-7BA8F447207C",
"childKey": "id_document",
"id": "77F87FED-C7C3-5B89-897A-DC8304ACD2D2",
"name": "Sold și scadență factură",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_document"
},
{
"childDatasetID": "D5BFB788-111E-5A43-B96F-6336F3D22BA7",
"childKey": "invoice_id",
"id": "8C57586E-3D65-55F7-B6AA-68C859AE7776",
"name": "Plăți repartizate",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_document"
},
{
"childDatasetID": "CC584FC9-513B-5916-85EE-27E31404B6BA",
"childKey": "invoice_id",
"id": "1308F8AE-B43A-565B-885F-B6298080F339",
"name": "Recepțiile facturii",
"parentDatasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"parentKey": "id_document"
},
{
"childDatasetID": "09C4134C-9427-5F98-8969-99695B46A351",
"childKey": "id_document",
"id": "1EF1DF5E-B49E-5E5C-AEFC-F11B949F541C",
"name": "Produsele recepției",
"parentDatasetID": "CC584FC9-513B-5916-85EE-27E31404B6BA",
"parentKey": "id_document"
},
{
"childDatasetID": "9634CE2E-7603-5760-83E3-6D114B072AA5",
"childKey": "id_produs",
"id": "53A89C31-49CB-51D9-A7D3-CE65C6D25A36",
"name": "Achiziții de la același furnizor",
"parentDatasetID": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"parentKey": "id_produs"
}
],
"widgets": [
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "B8D7A9BE-65C3-58F6-B721-E68590BBCFDD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "70A76768-D432-5F2C-94B2-532AF63BF01C",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Facturi furnizori luna curentă",
"titleKey": "",
"valueKey": "nr_facturi"
},
{
"cacheMode": "cached",
"chartAggregation": "count",
"chartStyle": "line",
"chartXAxisKey": "",
"datasetID": "B8D7A9BE-65C3-58F6-B721-E68590BBCFDD",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"filterSourceMode": "custom",
"filters": [],
"id": "D4C40628-3FF7-5CBD-8820-7DCC222A74FB",
"kind": "currentValue",
"limit": 10,
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"showInExternalWidgets": false,
"sortRules": [],
"subtitleKey": "",
"title": "Total facturi furnizori cu TVA",
"titleKey": "",
"valueKey": "total_cu_tva"
}
]
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-28T06:20:14Z",
"description": "Facturi furnizori read-only, cu antet și linii legate exclusiv prin id_document — relație verificată live pe schema AccesEx. Numărul și data NIR sunt afișate numai din câmpurile reale ale facturii/liniilor; pachetul nu inventează o legătură de document când Nexus nu o expune.\n\nVarianta Starter include factura, furnizorul, data, valoarea cu TVA și liniile de produse/servicii. Varianta Pro adaugă câmpurile contabile și de recepție în layout, două indicatoare exacte pentru luna curentă, sold/rulaje pe furnizor și istoricul facturilor/plăților în „Relația comercială”.\n\nConfigurare:\n1. Creează un login SQL dedicat Cifru cu SELECT numai pe obiectele enumerate.\n2. În Cifru adaugă o sursă SQL Server cu TLS, apoi testează structura.\n3. Importă pachetul, mapează slotul și rulează testul local înainte de aplicare.\n\nÎn Pro, „Sold contabil de plată” provine din funcția urmarire_parteneri. Raportul Nexus de scadențe exacte este o procedură separată și lentă, pe care Cifru nu o execută; de aceea pachetul nu prezintă soldul drept listă exactă de facturi scadente. Pachet neoficial, fără afiliere NexusERP.\n\nDOSAR ACHIZIȚIE: factura are scadență și sub-butoane pentru soldul propriu, plăți repartizate și NIR-urile asociate prin liniile documentelor. NIR-ul deschide produsele recepționate. Dintr-o linie a facturii vezi achizițiile aceluiași produs de la același furnizor, în cele 12 luni până la data documentului, cu UM, monedă, cantitate, preț și rabat. Nu se ghicesc legături după numărul imprimat. Soldul facturii folosește câmpurile native Nexus în moneda documentului, fără conversii Cifru. Repartizările financiare nu sunt echivalente cu numerar decontat și nu se forțează egalitatea lor cu soldul. NIR-urile sunt numai cele legate efectiv în Nexus, nu orice recepție cu același furnizor/produs. Documentele anulate/nevalidate rămân identificabile prin starea lor. Politicile cache, listele și câmpurile utile existente sunt păstrate; noile desfășurătoare se citesc la cerere. Istoricul de produs are maximum 1.000 rânduri. Manuale: https://www.docs.nexuserp.ro/articol/citire-facturi-furnizori/4342 ; https://www.docs.nexuserp.ro/articol/citire-note-de-intrare-receptie/4350 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "651F3BFE-EDAF-5637-9B1B-ED59C69AEEB9",
"rootButtonCount": 1,
"summary": "Factură → sold și scadență → plăți repartizate → NIR și produse; achiziții anterioare pe produs și furnizor.",
"tags": [
"NexusERP",
"facturi furnizori",
"NIR",
"plăți",
"read-only"
],
"title": "Facturi furnizori — Pro"
}
}