Bancă & card — cu facturi achitate
Încasări și plăți bancă/card cu drill pe facturile achitate (OP, BO); read-only, fără SQL personalizat.
Încasări și plăți prin BANCĂ și CARD din NexusERP (read-only, live) — varianta Starter, fără SQL personalizat.
Două butoane: „Încasări bancă & card" și „Plăți bancă & card". La deschidere alegi filtrele (Tip document, Perioadă) și apeși afișare. Fiecare rând: Data, Tip, Partener, Sumă, Monedă, Explicații.
Drill: atinge un document → vezi FACTURILE pe care le-a stins (tip, serie/număr, dată, sumă achitată), legate prin document. Util pentru OP și bilete la ordin.
Sursă: dbo.accesex_incasari_plati_view + dbo.accesex_incasari_plati_lin_view (cont bancar RON). Necesită Starter (o legătură Detalii). Pentru sens agregat și widget-uri, vezi varianta Pro.
What this package creates
2 Home1 Details2 lists1 sources to map
- Home: Încasări bancă & card
- Home: Plăți bancă & card
- Details: Facturile documentului
Sources are mapped locally and verified before applying.
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "D82AEB79-D672-5BA9-9534-E22419B46984",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_incasari_plati_view",
"dbo.accesex_incasari_plati_lin_view"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "CB947E7C-4667-5BA3-9074-82611BFE2962",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_financiar",
"label": "Cont (tehnic)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_financiar",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "plata",
"label": "Sens (tehnic)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "plata",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "partner_name",
"key": "den_coresp",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_coresp",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "amount",
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"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": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "explicatii",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 800,
"name": "Documente bancă/card",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_coresp",
"explicatii",
"tip_document"
],
"sourceID": "D82AEB79-D672-5BA9-9534-E22419B46984",
"sqlQuery": "",
"tableName": "dbo.accesex_incasari_plati_view"
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "D15BC29C-D4BA-57B6-8FE7-E0F2A088E620",
"key": "data_factura",
"type": "date"
}
],
"id": "DD1B147D-29A8-5333-94F4-77D17E63F900",
"mappings": [
{
"commonFieldKey": "",
"key": "id_factura",
"label": "ID",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_factura",
"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": "",
"key": "serie_factura",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "document_number",
"key": "numar_factura",
"label": "Număr factură",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_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_repartizata",
"label": "Sumă achitată (lei)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma_repartizata",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 500,
"name": "Facturi achitate",
"primaryKey": "id_factura",
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"numar_factura",
"serie_factura",
"tip_factura"
],
"sourceID": "D82AEB79-D672-5BA9-9534-E22419B46984",
"sqlQuery": "",
"tableName": "dbo.accesex_incasari_plati_lin_view"
}
],
"pages": [
{
"actions": [
{
"id": "FABBA1CC-2C70-5511-8CD5-E687D0399390",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "250F11AD-E6DC-59C2-80FD-42283C2F886E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DD1B147D-29A8-5333-94F4-77D17E63F900",
"title": "Facturi achitate",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_coresp",
"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"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CB947E7C-4667-5BA3-9074-82611BFE2962",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_coresp",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "5C926644-17B0-59A2-ACAD-9102BCF83E53",
"key": "tip_financiar",
"op": "equals",
"type": "text",
"value": "BAL"
},
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "DC764170-8F4C-5E2E-AB2C-F634CC2E9E08",
"key": "plata",
"op": "equals",
"type": "number",
"value": "0"
}
],
"id": "009AAE1E-8BE5-54AA-9372-2D8E4A66CB44",
"openFilters": [
{
"id": "5DD55FB7-29EE-5119-A583-A501CD2DF4BD",
"includeAllOption": true,
"key": "tip_document",
"title": "Tip document",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"last7Days",
"last30Days",
"currentMonth",
"last90Days"
],
"id": "061E50EE-00A0-5BBF-A1C5-24FDEC73DDDD",
"includeAllOption": false,
"key": "data_document",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_coresp",
"systemImage": "arrow.down.circle",
"title": "Încasări bancă & card",
"titleKey": "tip_document"
},
{
"actions": [
{
"id": "FABBA1CC-2C70-5511-8CD5-E687D0399390",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "250F11AD-E6DC-59C2-80FD-42283C2F886E",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DD1B147D-29A8-5333-94F4-77D17E63F900",
"title": "Facturi achitate",
"urlKey": ""
}
],
"badgeKey": "",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_coresp",
"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"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CB947E7C-4667-5BA3-9074-82611BFE2962",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip_document",
"label": "Tip document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_coresp",
"label": "Partener",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "suma",
"label": "Sumă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "moneda",
"label": "Monedă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "explicatii",
"label": "Explicații",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "5C926644-17B0-59A2-ACAD-9102BCF83E53",
"key": "tip_financiar",
"op": "equals",
"type": "text",
"value": "BAL"
},
{
"dateLastDays": 7,
"dateMode": "fixedDate",
"id": "FE147672-2425-5C51-8BFA-4B0DAB8C7513",
"key": "plata",
"op": "equals",
"type": "number",
"value": "1"
}
],
"id": "3A072512-D142-54BD-811D-E437C8FA10CC",
"openFilters": [
{
"id": "5DD55FB7-29EE-5119-A583-A501CD2DF4BD",
"includeAllOption": true,
"key": "tip_document",
"title": "Tip document",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"last7Days",
"last30Days",
"currentMonth",
"last90Days"
],
"id": "061E50EE-00A0-5BBF-A1C5-24FDEC73DDDD",
"includeAllOption": false,
"key": "data_document",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_coresp",
"systemImage": "arrow.up.circle",
"title": "Plăți bancă & card",
"titleKey": "tip_document"
}
],
"relations": [
{
"childDatasetID": "DD1B147D-29A8-5333-94F4-77D17E63F900",
"childKey": "id_document",
"id": "250F11AD-E6DC-59C2-80FD-42283C2F886E",
"name": "Facturile documentului",
"parentDatasetID": "CB947E7C-4667-5BA3-9074-82611BFE2962",
"parentKey": "id_document"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-08-20T16:18:21Z",
"description": "Încasări și plăți prin BANCĂ și CARD din NexusERP (read-only, live) — varianta Starter, fără SQL personalizat.\n\nDouă butoane: „Încasări bancă & card\" și „Plăți bancă & card\". La deschidere alegi filtrele (Tip document, Perioadă) și apeși afișare. Fiecare rând: Data, Tip, Partener, Sumă, Monedă, Explicații.\n\nDrill: atinge un document → vezi FACTURILE pe care le-a stins (tip, serie/număr, dată, sumă achitată), legate prin document. Util pentru OP și bilete la ordin.\n\nSursă: dbo.accesex_incasari_plati_view + dbo.accesex_incasari_plati_lin_view (cont bancar RON). Necesită Starter (o legătură Detalii). Pentru sens agregat și widget-uri, vezi varianta Pro.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "starter",
"packageID": "6BF852AF-53D6-509B-8A79-E1D918404EFD",
"rootButtonCount": 2,
"summary": "Încasări și plăți bancă/card cu drill pe facturile achitate (OP, BO); read-only, fără SQL personalizat.",
"tags": [
"NexusERP",
"banca",
"card",
"incasari",
"plati",
"facturi",
"trezorerie"
],
"title": "Bancă & card — cu facturi achitate"
}
}