Facturi furnizori — Pro
Facturi și linii, NIR, situație furnizor, istoric comercial și sumar lunar.
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 Free 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.
What this package creates
1 Home3 Details5 lists1 sources to map
- Home: Facturi furnizori
- Details: Linii factură
- Details: Sold furnizor
- Details: Relație comercială
- Sub-button: Linii factură furnizor
- Sub-button: Sold și rulaje furnizor
- Sub-button: Relația comercială cu furnizorul
- Sub-button: Sumar facturi furnizori
Sources are mapped locally and verified before applying.
Custom queriesPRO3 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.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
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"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "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": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_md",
"label": "Modificată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_md",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 3000,
"name": "Facturi furnizori",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"id_furnizor",
"serie_document",
"numar_document",
"data_document"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_furnizori"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"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
}
],
"maxRows": 5000,
"name": "Linii facturi furnizori",
"primaryKey": "id_linie_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_linie_document",
"id_document",
"id_produs",
"cod_produs",
"den_produs"
],
"sourceID": "783257FF-B4B6-5A9B-B895-AE88EC761A02",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_furnizori_lin"
},
{
"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": [
"id_partener",
"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": [
"row_id",
"id_partener",
"tip_miscare",
"data_document",
"document"
],
"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": ""
}
],
"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": ""
}
],
"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"
}
],
"datasetID": "DCBD4D9F-47C1-500A-B571-6D3293F9F4E6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"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": true,
"key": "data_cr",
"label": "Creată la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_md",
"label": "Modificată la",
"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": "den_furnizor",
"systemImage": "doc.text",
"title": "Facturi furnizori",
"titleKey": "numar_document"
},
{
"actions": [],
"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"
}
],
"datasetID": "32EB2C7C-F58A-5FF5-9CCD-F46A42E6EA84",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"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"
}
],
"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": true,
"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": true,
"key": "row_id",
"label": "ID mișcare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"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"
}
],
"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"
}
],
"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 Free 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.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "651F3BFE-EDAF-5637-9B1B-ED59C69AEEB9",
"rootButtonCount": 1,
"summary": "Facturi și linii, NIR, situație furnizor, istoric comercial și sumar lunar.",
"tags": [
"NexusERP",
"facturi furnizori",
"NIR",
"plăți",
"read-only"
],
"title": "Facturi furnizori — Pro"
}
}