Facturi primite SPV — Pro
Facturi SPV cu filtru obligatoriu importată/neimportată și detalii Nexus.
Facturi primite prin SPV, citite din vederea reală dosar_contabil_mesaje_anaf_view. Pachetul filtrează exclusiv tipul FACTURA PRIMITA; mesajele de stare, erorile generale și facturile trimise nu sunt amestecate în listă.
Varianta Free arată datele esențiale și câmpul real ID document Nexus în Detalii: gol înseamnă că mesajul nu este încă legat. Varianta Pro adaugă furnizorul rezolvat după codul fiscal și un câmp prietenos „Stare import”. La deschidere se aleg starea și perioada; furnizorul poate fi găsit rapid prin căutare, fără enumerarea întregului nomenclator.
Configurare:
1. Creează un login SQL read-only cu SELECT pe dosar_contabil_mesaje_anaf_view.
2. Adaugă sursa SQL Server în Cifru, cu TLS.
3. Importă pachetul, mapează slotul și rulează testul local.
În schema live verificată, id_tabel este completat pentru mesajele legate în Nexus și este NULL pentru cele nelegate. Nu se folosește detalii_nexus ca dovadă de import. Pachet neoficial, fără afiliere NexusERP sau ANAF.
What this package creates
1 Home0 Details1 lists1 sources to map
- Home: Facturi primite prin SPV
Sources are mapped locally and verified before applying.
Custom queriesPRO1 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.sqlQueryWITH parteneri AS (
SELECT
CASE
WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 2) = 'RO'
THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 3, 100)
ELSE UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', ''))
END AS cif_normalizat,
MAX(NULLIF(LTRIM(RTRIM(denumire)), '')) AS den_furnizor
FROM dbo.accesex_parteneri_view WITH (NOLOCK)
WHERE NULLIF(LTRIM(RTRIM(cif_cnp)), '') IS NOT NULL
GROUP BY
CASE
WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 2) = 'RO'
THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 3, 100)
ELSE UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', ''))
END
)
SELECT
m.id, m.id_anaf, m.data_anaf_date, m.tip, m.detalii, m.detalii_nexus,
m.cod_fiscal, m.valoare, m.tva, m.id_tabel, m.tip_tabel, m.citit, m.eroare,
m.id_arhiva, m.tip_arhiva, m.data_cr, m.user_cr,
COALESCE(p.den_furnizor, NULLIF(LTRIM(RTRIM(m.detalii_nexus)), ''),
CONCAT(N'CIF ', LTRIM(RTRIM(m.cod_fiscal)))) AS den_furnizor,
CASE WHEN ISNULL(m.id_tabel, 0) > 0
THEN N'Importată în Nexus'
ELSE N'Neimportată în Nexus'
END AS status_import
FROM dbo.dosar_contabil_mesaje_anaf_view m WITH (NOLOCK)
LEFT JOIN parteneri p
ON p.cif_normalizat =
CASE
WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', '')), 2) = 'RO'
THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', '')), 3, 100)
ELSE UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', ''))
END
WHERE LTRIM(RTRIM(m.tip)) = 'FACTURA PRIMITA'static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (SPV)",
"id": "312D1BB1-C0E6-59F5-B2C7-39BFB3D4423C",
"kind": "sqlServer",
"requiredObjects": [
"dbo.dosar_contabil_mesaje_anaf_view",
"dbo.accesex_parteneri_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "C2E069C5-D60B-57A2-8705-21692456274E",
"key": "data_anaf_date",
"type": "date"
}
],
"id": "44FB3E75-7A23-5AF0-A3D1-BB003C24B82D",
"mappings": [
{
"commonFieldKey": "",
"key": "id",
"label": "ID mesaj",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_anaf",
"label": "ID ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_anaf",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_anaf_date",
"label": "Data ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_anaf_date",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tip",
"label": "Tip mesaj",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "detalii",
"label": "Detalii ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "detalii",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "detalii_nexus",
"label": "Detalii Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "detalii_nexus",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "tax_id",
"key": "cod_fiscal",
"label": "Cod fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_fiscal",
"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": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_tabel",
"label": "ID document Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_tabel",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_tabel",
"label": "Tip document Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_tabel",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "citit",
"label": "Citit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "citit",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "eroare",
"label": "Eroare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "eroare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_arhiva",
"label": "ID arhivă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_arhiva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tip_arhiva",
"label": "Tip arhivă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tip_arhiva",
"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": "user_cr",
"label": "Creat de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "user_cr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "supplier_name",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "status_import",
"label": "Stare import",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "status_import",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Facturi primite prin SPV",
"primaryKey": "id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id",
"id_anaf",
"data_anaf_date",
"tip",
"detalii"
],
"sourceID": "312D1BB1-C0E6-59F5-B2C7-39BFB3D4423C",
"sqlQuery": "WITH parteneri AS (\n SELECT\n CASE\n WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 2) = 'RO'\n THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 3, 100)\n ELSE UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', ''))\n END AS cif_normalizat,\n MAX(NULLIF(LTRIM(RTRIM(denumire)), '')) AS den_furnizor\n FROM dbo.accesex_parteneri_view WITH (NOLOCK)\n WHERE NULLIF(LTRIM(RTRIM(cif_cnp)), '') IS NOT NULL\n GROUP BY\n CASE\n WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 2) = 'RO'\n THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', '')), 3, 100)\n ELSE UPPER(REPLACE(LTRIM(RTRIM(cif_cnp)), ' ', ''))\n END\n)\nSELECT\n m.id, m.id_anaf, m.data_anaf_date, m.tip, m.detalii, m.detalii_nexus,\n m.cod_fiscal, m.valoare, m.tva, m.id_tabel, m.tip_tabel, m.citit, m.eroare,\n m.id_arhiva, m.tip_arhiva, m.data_cr, m.user_cr,\n COALESCE(p.den_furnizor, NULLIF(LTRIM(RTRIM(m.detalii_nexus)), ''),\n CONCAT(N'CIF ', LTRIM(RTRIM(m.cod_fiscal)))) AS den_furnizor,\n CASE WHEN ISNULL(m.id_tabel, 0) > 0\n THEN N'Importată în Nexus'\n ELSE N'Neimportată în Nexus'\n END AS status_import\nFROM dbo.dosar_contabil_mesaje_anaf_view m WITH (NOLOCK)\nLEFT JOIN parteneri p\n ON p.cif_normalizat =\n CASE\n WHEN LEFT(UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', '')), 2) = 'RO'\n THEN SUBSTRING(UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', '')), 3, 100)\n ELSE UPPER(REPLACE(LTRIM(RTRIM(m.cod_fiscal)), ' ', ''))\n END\nWHERE LTRIM(RTRIM(m.tip)) = 'FACTURA PRIMITA'",
"tableName": ""
}
],
"pages": [
{
"actions": [],
"badgeKey": "status_import",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_anaf",
"label": "ID ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_anaf_date",
"label": "Data ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "status_import",
"label": "Stare import",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "44FB3E75-7A23-5AF0-A3D1-BB003C24B82D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id",
"label": "ID mesaj",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_anaf",
"label": "ID ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_anaf_date",
"label": "Data ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tip",
"label": "Tip mesaj",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "detalii",
"label": "Detalii ANAF",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Legătura Nexus",
"detailRole": "information",
"isVisible": true,
"key": "detalii_nexus",
"label": "Detalii Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_fiscal",
"label": "Cod fiscal",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Legătura Nexus",
"detailRole": "information",
"isVisible": true,
"key": "id_tabel",
"label": "ID document Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Legătura Nexus",
"detailRole": "information",
"isVisible": true,
"key": "tip_tabel",
"label": "Tip document Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "citit",
"label": "Citit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "eroare",
"label": "Eroare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Arhivă",
"detailRole": "information",
"isVisible": true,
"key": "id_arhiva",
"label": "ID arhivă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "Arhivă",
"detailRole": "information",
"isVisible": true,
"key": "tip_arhiva",
"label": "Tip arhivă",
"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": "user_cr",
"label": "Creat de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "status_import",
"label": "Stare import",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "C36F8887-D38F-58AF-AADC-F240FA351A2F",
"openFilters": [
{
"id": "7749BCFA-252E-5B05-A3F2-EC98A45EA8B0",
"includeAllOption": false,
"key": "status_import",
"title": "Stare import",
"type": "text"
},
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "0D858B73-A712-5899-B62F-779F2968F514",
"includeAllOption": false,
"key": "data_anaf_date",
"title": "Perioadă",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "C2E069C5-D60B-57A2-8705-21692456274E",
"key": "data_anaf_date",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "id_anaf",
"systemImage": "tray.and.arrow.down",
"title": "Facturi primite prin SPV",
"titleKey": "den_furnizor"
}
],
"relations": [],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-28T07:32:34Z",
"description": "Facturi primite prin SPV, citite din vederea reală dosar_contabil_mesaje_anaf_view. Pachetul filtrează exclusiv tipul FACTURA PRIMITA; mesajele de stare, erorile generale și facturile trimise nu sunt amestecate în listă.\n\nVarianta Free arată datele esențiale și câmpul real ID document Nexus în Detalii: gol înseamnă că mesajul nu este încă legat. Varianta Pro adaugă furnizorul rezolvat după codul fiscal și un câmp prietenos „Stare import”. La deschidere se aleg starea și perioada; furnizorul poate fi găsit rapid prin căutare, fără enumerarea întregului nomenclator.\n\nConfigurare:\n1. Creează un login SQL read-only cu SELECT pe dosar_contabil_mesaje_anaf_view.\n2. Adaugă sursa SQL Server în Cifru, cu TLS.\n3. Importă pachetul, mapează slotul și rulează testul local.\n\nÎn schema live verificată, id_tabel este completat pentru mesajele legate în Nexus și este NULL pentru cele nelegate. Nu se folosește detalii_nexus ca dovadă de import. Pachet neoficial, fără afiliere NexusERP sau ANAF.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "pro",
"packageID": "E9C2C10F-CE8B-5119-8F78-63E81F7BFB97",
"rootButtonCount": 1,
"summary": "Facturi SPV cu filtru obligatoriu importată/neimportată și detalii Nexus.",
"tags": [
"NexusERP",
"ANAF",
"SPV",
"e-Factura",
"read-only"
],
"title": "Facturi primite SPV — Pro"
}
}