Încasări & plăți — bancă & card
Bancă → repartizări → factura reală → produse; conturi, decont, monedă și explicații, fără confuzii client/furnizor.
Document bancar validat → repartizări pe facturi → factura clientului/furnizorului → produse. Păstrează domeniul bancă în lei/devize (BAL/BAD), citirea live, limita și fereastra de 120 zile ale configurației existente, cu filtre native pe perioadă, sens și tip document. În Detalii vezi data decontului, conturile, partenerul, agentul, centrul de profit și explicațiile. Legăturile folosesc tipul financiar + identificatorul documentului și tipul CLI/FUR + identificatorul facturii; nu numele sau numărul imprimat. Repartizările multiple către aceeași factură sunt însumate explicit, fără multiplicarea sumei documentului bancar. O factură se deschide numai dacă este validată și neanulată. Produsele arată preț de vânzare pentru client, preț de achiziție pentru furnizor, cantitate, TVA, cont, denumire suplimentară și expirare. Nu sunt ID-uri pe carduri. Suma repartizată nu este valoarea totală a facturii și nici nu dovedește singură închiderea soldului. Documentele fără repartizări au în mod legitim listă copil goală. Nu este o situație completă de casă, compensări sau efecte. Moneda provine din Nexus, fără conversii Cifru; documentele cu monedă neclară nu afișează un total numeric presupus. Pro, citire la cerere; galeria conține exclusiv date DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-incasari-plati/4392 ; https://www.docs.nexuserp.ro/articol/citire-incasari-plati-linii/4393 .
Screenshots
What this package creates
1 Home3 Details4 lists1 sources to map
- Home: Bancă & card
- Details: Facturile documentului
- Details: Deschide factura
- Details: Produsele facturii
- Sub-button: Factură repartizată
- Sub-button: Factura repartizată
- Sub-button: Produsele facturii repartizate
Sources are mapped locally and verified before applying.
Custom queriesPRO4 SQL
Custom queries are a PRO feature. Cifru repeats read-only validation against the local source before execution.
Statically verified read-only
$.components.workspaceSelection.datasets.0.sqlQuerySELECT
CONCAT(RTRIM(v.tip_financiar),'|',LTRIM(RTRIM(v.id_document))) AS id_document,
LTRIM(RTRIM(v.id_document)) AS financial_id,RTRIM(v.tip_financiar) AS financial_type,
MAX(CAST(v.data_document AS date)) AS data,
DATEFROMPARTS(YEAR(MAX(v.data_document)), MONTH(MAX(v.data_document)), 1) AS luna,
MAX(LTRIM(RTRIM(ISNULL(v.tip_document, N'-')))) AS tip_document,
MAX(CASE WHEN v.plata = 1 THEN N'Plata' ELSE N'Incasare' END) AS sens,
MAX(LTRIM(RTRIM(ISNULL(v.serie_document, N''))) + N' ' + LTRIM(RTRIM(ISNULL(v.numar_document, N'')))) AS document,
MAX(NULLIF(LTRIM(RTRIM(ISNULL(v.den_coresp, N''))), N'')) AS partener,
CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN MAX(RTRIM(v.moneda)) ELSE N'Monedă de verificat' END AS moneda,
CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(ISNULL(v.suma, 0)) ELSE NULL END AS decimal(18, 2)) AS suma,
CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(CASE WHEN v.plata = 0 THEN ISNULL(v.suma, 0) ELSE 0 END) ELSE NULL END AS decimal(18, 2)) AS incasari,
CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(CASE WHEN v.plata = 1 THEN ISNULL(v.suma, 0) ELSE 0 END) ELSE NULL END AS decimal(18, 2)) AS plati,
MAX(v.data_decont) AS data_decont,MAX(RTRIM(v.cont)) AS cont_banca,MAX(RTRIM(v.cont_coresp)) AS cont_corespondent,
MAX(LTRIM(RTRIM(ISNULL(v.explicatii, N'')))) AS explicatii,
MAX(LTRIM(RTRIM(ISNULL(v.den_agent, N'')))) AS agent,
MAX(LTRIM(RTRIM(ISNULL(v.den_centru_profit, N'')))) AS centru_profit
FROM dbo.accesex_incasari_plati_view v
WHERE v.validare=1 AND v.tip_financiar IN ('BAL', 'BAD')
AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))
GROUP BY v.tip_financiar,LTRIM(RTRIM(v.id_document))static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document),'|',RTRIM(l.tip_factura),'|',RTRIM(l.id_factura)) AS row_id, CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document)) AS id_document, RTRIM(l.tip_factura) AS invoice_type,RTRIM(l.id_factura) AS invoice_id, CONCAT(RTRIM(l.tip_factura),'|',RTRIM(l.id_factura)) AS invoice_key, CASE WHEN l.tip_factura='CLI' THEN N'Factură client' WHEN l.tip_factura='FUR' THEN N'Factură furnizor' ELSE RTRIM(l.tip_factura) END AS tip_factura, MAX(CONCAT(RTRIM(l.serie_factura),' ',RTRIM(l.numar_factura))) AS factura,MAX(l.data_factura) AS data_factura, SUM(l.suma_repartizata) AS suma_achitata,COUNT_BIG(*) AS nr_repartizari FROM dbo.accesex_incasari_plati_lin_view l WHERE l.tip_financiar=:financial_type AND l.id_document=:financial_id GROUP BY l.tip_financiar,l.id_document,l.tip_factura,l.id_factura
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(N'CLI|',h.id_document) AS row_id,h.id_document AS invoice_id,N'CLI' AS invoice_type, CONCAT(N'CLI|',h.id_document) AS invoice_key,h.den_client AS partener,h.tip_document, h.serie_document,h.numar_document,h.data_document,h.den_gestiune,h.moneda,h.valoare_cu_tva, h.valoare AS valoare_fara_tva FROM dbo.accesex_facturi_clienti h WHERE :invoice_type=N'CLI' AND h.id_document=:invoice_id AND h.validare=1 AND h.anulare=0 UNION ALL SELECT CONCAT(N'FUR|',h.id_document) AS row_id,h.id_document AS invoice_id,N'FUR' AS invoice_type, CONCAT(N'FUR|',h.id_document) AS invoice_key,h.den_furnizor AS partener,h.tip_document, h.serie_document,h.numar_document,h.data_document,h.den_gestiune,h.moneda,h.valoare_cu_tva, h.valoare AS valoare_fara_tva FROM dbo.accesex_facturi_furnizori h WHERE :invoice_type=N'FUR' AND h.id_document=:invoice_id AND h.validare=1 AND h.anulare=0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT CONCAT(N'CLI|',l.id_intern) AS row_id,CONCAT(N'CLI|',l.id_document) AS invoice_key, l.den_produs,l.cod_produs,l.cantitate,l.pret_vanzare AS pret_fara_tva,l.cota_tva_ies AS cota_tva, N'Vânzare' AS tip_pret,l.cont_produs,l.denumire_sup,l.data_expirare FROM dbo.accesex_facturi_clienti_lin l WHERE :invoice_type=N'CLI' AND l.id_document=:invoice_id UNION ALL SELECT CONCAT(N'FUR|',l.id_intern) AS row_id,CONCAT(N'FUR|',l.id_document) AS invoice_key, l.den_produs,l.cod_produs,l.cantitate,l.pret_achizitie AS pret_fara_tva,l.cota_tva_int AS cota_tva, N'Achiziție' AS tip_pret,l.cont_produs,l.denumire_sup,l.data_expirare FROM dbo.accesex_facturi_furnizori_lin l WHERE :invoice_type=N'FUR' AND l.id_document=:invoice_id
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_incasari_plati_view",
"dbo.accesex_incasari_plati_lin_view",
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin",
"dbo.accesex_facturi_furnizori",
"dbo.accesex_facturi_furnizori_lin"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
}
],
"id": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "document_date",
"key": "data",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "luna",
"label": "Luna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "luna",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sens",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "document",
"label": "Serie / număr",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "partner_name",
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "partener",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "moneda",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "amount",
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "incasari",
"label": "Încasări — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "incasari",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "plati",
"label": "Plăți — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "plati",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "agent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "centru_profit",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "centru_profit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "financial_id",
"label": "financial_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "financial_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "financial_type",
"label": "financial_type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "financial_type",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_decont",
"label": "Data decontului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_decont",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont_banca",
"label": "Cont bancă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_banca",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cont_corespondent",
"label": "Cont corespondent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_corespondent",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 15000,
"name": "Documente bancă/card",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"partener",
"explicatii",
"tip_document",
"document"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT\n CONCAT(RTRIM(v.tip_financiar),'|',LTRIM(RTRIM(v.id_document))) AS id_document,\n LTRIM(RTRIM(v.id_document)) AS financial_id,RTRIM(v.tip_financiar) AS financial_type,\n MAX(CAST(v.data_document AS date)) AS data,\n DATEFROMPARTS(YEAR(MAX(v.data_document)), MONTH(MAX(v.data_document)), 1) AS luna,\n MAX(LTRIM(RTRIM(ISNULL(v.tip_document, N'-')))) AS tip_document,\n MAX(CASE WHEN v.plata = 1 THEN N'Plata' ELSE N'Incasare' END) AS sens,\n MAX(LTRIM(RTRIM(ISNULL(v.serie_document, N''))) + N' ' + LTRIM(RTRIM(ISNULL(v.numar_document, N'')))) AS document,\n MAX(NULLIF(LTRIM(RTRIM(ISNULL(v.den_coresp, N''))), N'')) AS partener,\n CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN MAX(RTRIM(v.moneda)) ELSE N'Monedă de verificat' END AS moneda,\n CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(ISNULL(v.suma, 0)) ELSE NULL END AS decimal(18, 2)) AS suma,\n CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(CASE WHEN v.plata = 0 THEN ISNULL(v.suma, 0) ELSE 0 END) ELSE NULL END AS decimal(18, 2)) AS incasari,\n CAST(CASE WHEN COUNT(DISTINCT NULLIF(RTRIM(v.moneda),''))=1 AND COUNT(NULLIF(RTRIM(v.moneda),''))=COUNT(*) THEN SUM(CASE WHEN v.plata = 1 THEN ISNULL(v.suma, 0) ELSE 0 END) ELSE NULL END AS decimal(18, 2)) AS plati,\n MAX(v.data_decont) AS data_decont,MAX(RTRIM(v.cont)) AS cont_banca,MAX(RTRIM(v.cont_coresp)) AS cont_corespondent,\n MAX(LTRIM(RTRIM(ISNULL(v.explicatii, N'')))) AS explicatii,\n MAX(LTRIM(RTRIM(ISNULL(v.den_agent, N'')))) AS agent,\n MAX(LTRIM(RTRIM(ISNULL(v.den_centru_profit, N'')))) AS centru_profit\nFROM dbo.accesex_incasari_plati_view v\nWHERE v.validare=1 AND v.tip_financiar IN ('BAL', 'BAD')\n AND v.data_document >= DATEADD(day, -120, CAST(GETDATE() AS date))\nGROUP BY v.tip_financiar,LTRIM(RTRIM(v.id_document))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D15BC29C-D4BA-57B6-8FE7-E0F2A088E620",
"key": "data_factura",
"type": "date"
}
],
"id": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "Document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_factura",
"label": "Tip factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_number",
"key": "factura",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_factura",
"label": "Data factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "amount",
"key": "suma_achitata",
"label": "Sumă repartizată din Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma_achitata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "invoice_type",
"label": "invoice_type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_type",
"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": "invoice_key",
"label": "invoice_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_repartizari",
"label": "Înregistrări de repartizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_repartizari",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Facturi achitate",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "financial_id",
"id": "1D609C86-E033-5D01-8C82-CD092D56A12A",
"name": "financial_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "financial_type",
"id": "C0E2F06A-111D-5928-91E1-BC4E1219D48A",
"name": "financial_type",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"factura",
"tip_factura"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document),'|',RTRIM(l.tip_factura),'|',RTRIM(l.id_factura)) AS row_id,\n CONCAT(RTRIM(l.tip_financiar),'|',RTRIM(l.id_document)) AS id_document,\n RTRIM(l.tip_factura) AS invoice_type,RTRIM(l.id_factura) AS invoice_id,\n CONCAT(RTRIM(l.tip_factura),'|',RTRIM(l.id_factura)) AS invoice_key,\n CASE WHEN l.tip_factura='CLI' THEN N'Factură client' WHEN l.tip_factura='FUR' THEN N'Factură furnizor' ELSE RTRIM(l.tip_factura) END AS tip_factura,\n MAX(CONCAT(RTRIM(l.serie_factura),' ',RTRIM(l.numar_factura))) AS factura,MAX(l.data_factura) AS data_factura,\n SUM(l.suma_repartizata) AS suma_achitata,COUNT_BIG(*) AS nr_repartizari\nFROM dbo.accesex_incasari_plati_lin_view l\nWHERE l.tip_financiar=:financial_type AND l.id_document=:financial_id\nGROUP BY l.tip_financiar,l.id_document,l.tip_factura,l.id_factura",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "ADCBE1E7-97C5-55A5-8864-AEA9260338B5",
"key": "numar_document",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "6ED5ECF3-B515-5257-A1C9-FFCD548DF585",
"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": "invoice_type",
"label": "invoice_type",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_type",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "invoice_key",
"label": "invoice_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "partener",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Factură nr.",
"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": "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_cu_tva",
"label": "Valoare cu TVA în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_fara_tva",
"label": "Valoare fără TVA în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_fara_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Factura repartizată",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "invoice_id",
"id": "9A8DC794-1D41-5885-BD68-4DC6ED24CD13",
"name": "invoice_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "invoice_type",
"id": "F7AC582E-B8F7-511A-B141-C9F9371E6606",
"name": "invoice_type",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"partener",
"tip_document",
"serie_document",
"numar_document",
"data_document",
"den_gestiune",
"moneda",
"valoare_cu_tva",
"valoare_fara_tva"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT CONCAT(N'CLI|',h.id_document) AS row_id,h.id_document AS invoice_id,N'CLI' AS invoice_type,\n CONCAT(N'CLI|',h.id_document) AS invoice_key,h.den_client AS partener,h.tip_document,\n h.serie_document,h.numar_document,h.data_document,h.den_gestiune,h.moneda,h.valoare_cu_tva,\n h.valoare AS valoare_fara_tva\nFROM dbo.accesex_facturi_clienti h\nWHERE :invoice_type=N'CLI' AND h.id_document=:invoice_id AND h.validare=1 AND h.anulare=0\nUNION ALL\nSELECT CONCAT(N'FUR|',h.id_document) AS row_id,h.id_document AS invoice_id,N'FUR' AS invoice_type,\n CONCAT(N'FUR|',h.id_document) AS invoice_key,h.den_furnizor AS partener,h.tip_document,\n h.serie_document,h.numar_document,h.data_document,h.den_gestiune,h.moneda,h.valoare_cu_tva,\n h.valoare AS valoare_fara_tva\nFROM dbo.accesex_facturi_furnizori h\nWHERE :invoice_type=N'FUR' AND h.id_document=:invoice_id AND h.validare=1 AND h.anulare=0",
"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": "C2882EB2-2FF6-512C-8CD2-3C3D09CFAEFF",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "invoice_key",
"label": "invoice_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "invoice_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_fara_tva",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_fara_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cota_tva",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_pret",
"label": "Tip preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_pret",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cont_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denumire_sup",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Produsele facturii repartizate",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "invoice_id",
"id": "9A8DC794-1D41-5885-BD68-4DC6ED24CD13",
"name": "invoice_id",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "invoice_type",
"id": "F7AC582E-B8F7-511A-B141-C9F9371E6606",
"name": "invoice_type",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"cantitate",
"pret_fara_tva",
"cota_tva",
"tip_pret",
"cont_produs",
"denumire_sup",
"data_expirare"
],
"sourceID": "8B777432-C0F0-5C59-9FA2-EA7FF27F895E",
"sqlQuery": "SELECT CONCAT(N'CLI|',l.id_intern) AS row_id,CONCAT(N'CLI|',l.id_document) AS invoice_key,\n l.den_produs,l.cod_produs,l.cantitate,l.pret_vanzare AS pret_fara_tva,l.cota_tva_ies AS cota_tva,\n N'Vânzare' AS tip_pret,l.cont_produs,l.denumire_sup,l.data_expirare\nFROM dbo.accesex_facturi_clienti_lin l WHERE :invoice_type=N'CLI' AND l.id_document=:invoice_id\nUNION ALL\nSELECT CONCAT(N'FUR|',l.id_intern) AS row_id,CONCAT(N'FUR|',l.id_document) AS invoice_key,\n l.den_produs,l.cod_produs,l.cantitate,l.pret_achizitie AS pret_fara_tva,l.cota_tva_int AS cota_tva,\n N'Achiziție' AS tip_pret,l.cont_produs,l.denumire_sup,l.data_expirare\nFROM dbo.accesex_facturi_furnizori_lin l WHERE :invoice_type=N'FUR' AND l.id_document=:invoice_id",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "A8E0F43B-17E1-5C2A-9E8E-40B4E561D6C7",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "AA410AB5-260F-5E36-96C2-A2107DB7E060",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"title": "Facturi repartizate",
"urlKey": ""
}
],
"badgeKey": "sens",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data",
"label": "Data",
"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": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "document",
"label": "Serie / număr",
"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": "sens",
"label": "Sens",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "partener",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "incasari",
"label": "Încasări — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "plati",
"label": "Plăți — moneda documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "agent",
"label": "Agent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "centru_profit",
"label": "Centru de profit",
"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": "cont_banca",
"label": "Cont bancă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_corespondent",
"label": "Cont corespondent",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "4AF75A35-AA49-5F88-87C4-30DAD67F5ABA",
"openFilters": [
{
"id": "5442BE31-83C9-502A-BD6A-DBB9F1FABA7A",
"includeAllOption": true,
"key": "sens",
"title": "Sens (Încasare/Plată)",
"type": "text"
},
{
"id": "5DD55FB7-29EE-5119-A583-A501CD2DF4BD",
"includeAllOption": true,
"key": "tip_document",
"title": "Tip document",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"last7Days",
"last30Days",
"currentMonth",
"last90Days"
],
"id": "9B89B9CE-2C74-5B05-A46B-3E6255200C68",
"includeAllOption": false,
"key": "data",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "18BDBE81-C082-54F7-8966-141F1F0EA2F8",
"key": "data",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "partener",
"systemImage": "creditcard",
"title": "Bancă & card",
"titleKey": "tip_document"
},
{
"actions": [
{
"id": "9C30749C-C3C5-50FB-9D89-04F153736935",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "2479B645-3FF0-5CCF-B21D-4008B621191F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6ED5ECF3-B515-5257-A1C9-FFCD548DF585",
"title": "Deschide factura",
"urlKey": ""
}
],
"badgeKey": "suma_achitata",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "tip_factura",
"label": "Tip factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "factura",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "highlight",
"isVisible": true,
"key": "suma_achitata",
"label": "Sumă repartizată din Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "tip_factura",
"label": "Tip factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "factura",
"label": "Factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Repartizarea documentului",
"detailRole": "highlight",
"isVisible": true,
"key": "suma_achitata",
"label": "Sumă repartizată din Nexus",
"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": "66026C12-3BE9-5003-ABA4-B8DDF49D85E8",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "D15BC29C-D4BA-57B6-8FE7-E0F2A088E620",
"key": "data_factura",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "tip_factura",
"systemImage": "doc.text",
"title": "Factură repartizată",
"titleKey": "factura"
},
{
"actions": [
{
"id": "C454E6F8-4FC3-51C1-A329-2E009B7EE824",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "29405C8A-145E-5BCC-8384-9EE6AD27A112",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C2882EB2-2FF6-512C-8CD2-3C3D09CFAEFF",
"title": "Produsele facturii",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6ED5ECF3-B515-5257-A1C9-FFCD548DF585",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_fara_tva",
"label": "Valoare fără TVA în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "60CC20D6-C925-5C91-913E-73335B9CE705",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "ADCBE1E7-97C5-55A5-8864-AEA9260338B5",
"key": "numar_document",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "partener",
"systemImage": "doc.text",
"title": "Factura repartizată",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_fara_tva",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_pret",
"label": "Tip preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C2882EB2-2FF6-512C-8CD2-3C3D09CFAEFF",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_fara_tva",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_pret",
"label": "Tip preț",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cont_produs",
"label": "Cont produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "denumire_sup",
"label": "Denumire suplimentară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "3DCF9B33-BFA2-5DF8-A5DA-D64C9B2F9C77",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "doc.text",
"title": "Produsele facturii repartizate",
"titleKey": "den_produs"
}
],
"relations": [
{
"childDatasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"childKey": "id_document",
"id": "AA410AB5-260F-5E36-96C2-A2107DB7E060",
"name": "Facturile documentului",
"parentDatasetID": "1B0B166C-C627-5FC9-8ABE-53A51D8738B2",
"parentKey": "id_document"
},
{
"childDatasetID": "6ED5ECF3-B515-5257-A1C9-FFCD548DF585",
"childKey": "invoice_key",
"id": "2479B645-3FF0-5CCF-B21D-4008B621191F",
"name": "Deschide factura",
"parentDatasetID": "6439CA7D-2AB6-5783-99BC-7E5816B48743",
"parentKey": "invoice_key"
},
{
"childDatasetID": "C2882EB2-2FF6-512C-8CD2-3C3D09CFAEFF",
"childKey": "invoice_key",
"id": "29405C8A-145E-5BCC-8384-9EE6AD27A112",
"name": "Produsele facturii",
"parentDatasetID": "6ED5ECF3-B515-5257-A1C9-FFCD548DF585",
"parentKey": "invoice_key"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-20T16:18:21Z",
"description": "Document bancar validat → repartizări pe facturi → factura clientului/furnizorului → produse. Păstrează domeniul bancă în lei/devize (BAL/BAD), citirea live, limita și fereastra de 120 zile ale configurației existente, cu filtre native pe perioadă, sens și tip document. În Detalii vezi data decontului, conturile, partenerul, agentul, centrul de profit și explicațiile. Legăturile folosesc tipul financiar + identificatorul documentului și tipul CLI/FUR + identificatorul facturii; nu numele sau numărul imprimat. Repartizările multiple către aceeași factură sunt însumate explicit, fără multiplicarea sumei documentului bancar. O factură se deschide numai dacă este validată și neanulată. Produsele arată preț de vânzare pentru client, preț de achiziție pentru furnizor, cantitate, TVA, cont, denumire suplimentară și expirare. Nu sunt ID-uri pe carduri. Suma repartizată nu este valoarea totală a facturii și nici nu dovedește singură închiderea soldului. Documentele fără repartizări au în mod legitim listă copil goală. Nu este o situație completă de casă, compensări sau efecte. Moneda provine din Nexus, fără conversii Cifru; documentele cu monedă neclară nu afișează un total numeric presupus. Pro, citire la cerere; galeria conține exclusiv date DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-incasari-plati/4392 ; https://www.docs.nexuserp.ro/articol/citire-incasari-plati-linii/4393 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "188544CA-4519-54F6-B6BA-78D2C755580A",
"rootButtonCount": 1,
"summary": "Bancă → repartizări → factura reală → produse; conturi, decont, monedă și explicații, fără confuzii client/furnizor.",
"tags": [
"NexusERP",
"banca",
"card",
"incasari",
"plati",
"OP",
"bilet la ordin",
"extras",
"trezorerie"
],
"title": "Încasări & plăți — bancă & card"
}
}