Mijloace fixe — dosarul bunului — Pro
Bun → situație lunară → PIF, amortizare, transferuri și reevaluări, cu identitate sigură și valori din Nexus.
Dosarul bunului din ultima lună contabilă disponibilă: număr inventar, gestiune, clasă/subclasă, responsabil, centru, PIF, metodă și durată, valoare de intrare, amortizare lunară/cumulată, valoare rămasă, subvenție și reevaluare. Sub-butoane: istoric lunar incluzând luna curentă și cele 24 precedente, achiziție/PIF, transferuri și reevaluări. Nu este stoc fizic live. Luna sursei este afișată explicit. Valorile vin din Nexus și nu sunt recalculate în Cifru. Identitatea snapshotului include luna + numărul inventar + gestiunea; istoricul include și produsul + data PIF pentru a separa numerele reutilizate. Transferurile arată numărul anterior și cel nou. Nu se promite o genealogie completă peste renumerotări/importuri istorice; lipsa documentului PIF asociat nu dovedește lipsa achiziției. Nu aduna amortizarea CUMULATĂ din mai multe luni. Creșterea reevaluării este câmpul sursei, nu diferență inventată între două prețuri. Pro, live, maximum 20.000 poziții curente și 5.000 în fiecare desfășurător; citiri doar pentru bunul selectat, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/campuri-stoc-de-imobilizari/4128 ; https://www.docs.nexuserp.ro/articol/studiu-de-caz-mijloace-fixe-achizitie-receptie-punere-in-functiune-amortizare-reevaluare-transferuri/5048 .
Screenshots
What this package creates
1 Home4 Details5 lists1 sources to map
- Home: Dosare mijloace fixe
- Details: Istoric lunar și amortizare
- Details: Achiziție și punere în funcțiune
- Details: Transferurile bunului
- Details: Reevaluările bunului
- Sub-button: Istoric lunar al bunului
- Sub-button: Achiziție și punere în funcțiune
- Sub-button: Transferurile bunului
- Sub-button: Reevaluările bunului
Sources are mapped locally and verified before applying.
Custom queriesPRO5 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(s.anluna,'|',RTRIM(s.nrinv),'|',s.pl_gest,':',s.id_gest) AS row_id,RTRIM(s.nrinv) AS inventory_number, s.pl_pr AS product_pl,s.id_pr AS product_id,COALESCE(CONVERT(varchar(10),s.data_pif,23),'NULL') AS pif_key, s.data_pif,s.anluna,s.denpr,s.nume_gest,s.nume_clasa,s.nume_subcl,s.nume_pers,s.nume_obi,s.met_amort,s.dsn,s.dsr, s.pu,s.pu_calc,s.am_lun,s.am_cum,s.val_ram,s.subventie,s.dif_reev,s.vr_calc FROM dbo.stoc_m_view s WHERE s.anluna=(SELECT MAX(anluna) FROM dbo.stoc_m WHERE anluna<=CONVERT(char(6),GETDATE(),112))
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT CONCAT(s.anluna,'|',RTRIM(s.nrinv),'|',s.pl_gest,':',s.id_gest) AS row_id,:asset_key AS asset_key, s.anluna,s.nume_gest,s.pu_calc,s.am_lun,s.am_cum,s.val_ram,s.met_amort FROM dbo.stoc_m_view s WHERE s.nrinv=:inventory_number AND s.pl_pr=:product_pl AND s.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),s.data_pif,23),'NULL')=:pif_key AND s.anluna>=CONVERT(char(6),DATEADD(month,-24,GETDATE()),112) AND s.anluna<=CONVERT(char(6),GETDATE(),112)
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gest,h.nume_furn,h.nrd_l,h.datad_l,l.data_pif,l.met_amort,l.dsn,l.cod_cls,l.pu,l.pu_calc,l.cantitate,l.valoare FROM dbo.liniinirpif_view l JOIN dbo.nirpif_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_pif AND h.id=l.id_pif WHERE l.nrinv=:inventory_number AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gesto,h.nume_gesti,l.nrinv_v,l.nrinv_n,l.met_amortv,l.met_amort,l.dsn_v,l.dsn_n,l.pu_calc FROM dbo.ntilinii_view l JOIN dbo.nti_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_nti AND h.id=l.id_nti WHERE (l.nrinv_v=:inventory_number OR l.nrinv_n=:inventory_number) AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gest,l.pu_calc,l.npu_calc,l.am_cum,l.nam_cum,l.crestere,l.chdifreev FROM dbo.reevimob_lin_view l JOIN dbo.reevimob_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_rev AND h.id=l.id_rev WHERE l.nrinv=:inventory_number AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "557C9840-6EBB-5990-9A33-49A375507168",
"kind": "sqlServer",
"requiredObjects": [
"dbo.stoc_m",
"dbo.stoc_m_view",
"dbo.liniinirpif_view",
"dbo.nirpif_view",
"dbo.ntilinii_view",
"dbo.nti_view",
"dbo.reevimob_lin_view",
"dbo.reevimob_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
"key": "denpr",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_pl",
"label": "product_pl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "product_id",
"label": "product_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "product_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pif_key",
"label": "pif_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pif_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "inventory_number",
"label": "Număr inventar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "inventory_number",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_pif",
"label": "Punere în funcțiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pif",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anluna",
"label": "Luna situației (AAAALL)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anluna",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "denpr",
"label": "Bun",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "denpr",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gest",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_clasa",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_subcl",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_subcl",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_pers",
"label": "Responsabil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_pers",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_obi",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_obi",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "met_amort",
"label": "Metodă amortizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "met_amort",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "dsn",
"label": "Durată normală — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dsn",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dsr",
"label": "Durată rămasă — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dsr",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pu",
"label": "Valoare intrare înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pu_calc",
"label": "Valoare de inventar calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "am_lun",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "am_cum",
"label": "Amortizare cumulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "am_cum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "val_ram",
"label": "Valoare rămasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "val_ram",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "subventie",
"label": "Subvenție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "subventie",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dif_reev",
"label": "Diferență reevaluare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dif_reev",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "vr_calc",
"label": "Valoare rămasă — calcul Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "vr_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 20000,
"name": "Dosare mijloace fixe",
"primaryKey": "row_id",
"queryParameters": [],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"inventory_number",
"data_pif",
"anluna",
"denpr",
"nume_gest",
"nume_clasa",
"nume_subcl",
"nume_pers",
"nume_obi",
"met_amort",
"dsn",
"dsr",
"pu",
"pu_calc",
"am_lun",
"am_cum",
"val_ram",
"subventie",
"dif_reev",
"vr_calc"
],
"sourceID": "557C9840-6EBB-5990-9A33-49A375507168",
"sqlQuery": "SELECT CONCAT(s.anluna,'|',RTRIM(s.nrinv),'|',s.pl_gest,':',s.id_gest) AS row_id,RTRIM(s.nrinv) AS inventory_number,\n s.pl_pr AS product_pl,s.id_pr AS product_id,COALESCE(CONVERT(varchar(10),s.data_pif,23),'NULL') AS pif_key,\n s.data_pif,s.anluna,s.denpr,s.nume_gest,s.nume_clasa,s.nume_subcl,s.nume_pers,s.nume_obi,s.met_amort,s.dsn,s.dsr,\n s.pu,s.pu_calc,s.am_lun,s.am_cum,s.val_ram,s.subventie,s.dif_reev,s.vr_calc\nFROM dbo.stoc_m_view s WHERE s.anluna=(SELECT MAX(anluna) FROM dbo.stoc_m WHERE anluna<=CONVERT(char(6),GETDATE(),112))",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "1F9BF66F-0B0E-5AD3-8B97-539855A3EECD",
"key": "anluna",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "0DEA2BAC-17FF-5641-BDDB-092EC00F8C04",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "asset_key",
"label": "asset_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "asset_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anluna",
"label": "Lună (AAAALL)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anluna",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gest",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pu_calc",
"label": "Valoare de inventar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "am_lun",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "am_cum",
"label": "Amortizare cumulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "am_cum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "val_ram",
"label": "Valoare rămasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "val_ram",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "met_amort",
"label": "Metodă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "met_amort",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Istoric lunar al bunului",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "B2917793-1508-5FEE-9573-F71E89640062",
"name": "asset_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "inventory_number",
"id": "E81E5902-CB47-5962-B0B6-4F1FD6DB2B9F",
"name": "inventory_number",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "0CA1A62C-09B6-509F-9A62-C63E768C2B13",
"name": "product_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "7008D04D-C4B7-5BCC-90BD-5BCB22CE2808",
"name": "product_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "pif_key",
"id": "2C17D2F5-B5F8-56CD-AE39-F934C7483532",
"name": "pif_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"anluna",
"nume_gest",
"pu_calc",
"am_lun",
"am_cum",
"val_ram",
"met_amort"
],
"sourceID": "557C9840-6EBB-5990-9A33-49A375507168",
"sqlQuery": "SELECT CONCAT(s.anluna,'|',RTRIM(s.nrinv),'|',s.pl_gest,':',s.id_gest) AS row_id,:asset_key AS asset_key,\n s.anluna,s.nume_gest,s.pu_calc,s.am_lun,s.am_cum,s.val_ram,s.met_amort\nFROM dbo.stoc_m_view s WHERE s.nrinv=:inventory_number AND s.pl_pr=:product_pl AND s.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),s.data_pif,23),'NULL')=:pif_key AND s.anluna>=CONVERT(char(6),DATEADD(month,-24,GETDATE()),112)\n AND s.anluna<=CONVERT(char(6),GETDATE(),112)",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "E51E4897-9A5B-5B70-8A03-B5E89D70BF52",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "asset_key",
"label": "asset_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "asset_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_doc",
"label": "NIR/PIF nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gest",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nume_furn",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_furn",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nrd_l",
"label": "Document de intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nrd_l",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "datad_l",
"label": "Data documentului de intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "datad_l",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pif",
"label": "Punere în funcțiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pif",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "met_amort",
"label": "Metodă amortizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "met_amort",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dsn",
"label": "Durată normală — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dsn",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cod_cls",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_cls",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pu",
"label": "Valoare intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pu_calc",
"label": "Valoare pentru calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Achiziție și punere în funcțiune",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "B2917793-1508-5FEE-9573-F71E89640062",
"name": "asset_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "inventory_number",
"id": "E81E5902-CB47-5962-B0B6-4F1FD6DB2B9F",
"name": "inventory_number",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "0CA1A62C-09B6-509F-9A62-C63E768C2B13",
"name": "product_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "7008D04D-C4B7-5BCC-90BD-5BCB22CE2808",
"name": "product_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "pif_key",
"id": "2C17D2F5-B5F8-56CD-AE39-F934C7483532",
"name": "pif_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"nr_doc",
"data_doc",
"nume_gest",
"nume_furn",
"nrd_l",
"datad_l",
"data_pif",
"met_amort",
"dsn",
"cod_cls",
"pu",
"pu_calc",
"cantitate",
"valoare"
],
"sourceID": "557C9840-6EBB-5990-9A33-49A375507168",
"sqlQuery": "SELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gest,h.nume_furn,h.nrd_l,h.datad_l,l.data_pif,l.met_amort,l.dsn,l.cod_cls,l.pu,l.pu_calc,l.cantitate,l.valoare\nFROM dbo.liniinirpif_view l JOIN dbo.nirpif_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_pif AND h.id=l.id_pif\nWHERE l.nrinv=:inventory_number AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "DDA0E1D7-700E-5EB0-83F5-8E8307EFCEF0",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "asset_key",
"label": "asset_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "asset_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_doc",
"label": "Transfer nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gesto",
"label": "Din gestiunea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gesto",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gesti",
"label": "În gestiunea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gesti",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nrinv_v",
"label": "Număr inventar anterior",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nrinv_v",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nrinv_n",
"label": "Număr inventar nou",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nrinv_n",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "met_amortv",
"label": "Metodă anterioară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "met_amortv",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "met_amort",
"label": "Metodă nouă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "met_amort",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dsn_v",
"label": "Durată anterioară — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dsn_v",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "dsn_n",
"label": "Durată nouă — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "dsn_n",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pu_calc",
"label": "Valoare înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Transferurile bunului",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "B2917793-1508-5FEE-9573-F71E89640062",
"name": "asset_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "inventory_number",
"id": "E81E5902-CB47-5962-B0B6-4F1FD6DB2B9F",
"name": "inventory_number",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "0CA1A62C-09B6-509F-9A62-C63E768C2B13",
"name": "product_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "7008D04D-C4B7-5BCC-90BD-5BCB22CE2808",
"name": "product_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "pif_key",
"id": "2C17D2F5-B5F8-56CD-AE39-F934C7483532",
"name": "pif_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"nr_doc",
"data_doc",
"nume_gesto",
"nume_gesti",
"nrinv_v",
"nrinv_n",
"met_amortv",
"met_amort",
"dsn_v",
"dsn_n",
"pu_calc"
],
"sourceID": "557C9840-6EBB-5990-9A33-49A375507168",
"sqlQuery": "SELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gesto,h.nume_gesti,l.nrinv_v,l.nrinv_n,l.met_amortv,l.met_amort,l.dsn_v,l.dsn_n,l.pu_calc\nFROM dbo.ntilinii_view l JOIN dbo.nti_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_nti AND h.id=l.id_nti\nWHERE (l.nrinv_v=:inventory_number OR l.nrinv_n=:inventory_number) AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "9ECF3A7A-5521-57EB-862A-C99EA673AED0",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "asset_key",
"label": "asset_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "asset_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_doc",
"label": "Reevaluare nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_doc",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_doc",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nume_gest",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pu_calc",
"label": "Valoare înainte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "npu_calc",
"label": "Valoare după",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "npu_calc",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "am_cum",
"label": "Amortizare cumulată înainte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "am_cum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nam_cum",
"label": "Amortizare cumulată după",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nam_cum",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "crestere",
"label": "Creștere înregistrată în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "crestere",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "chdifreev",
"label": "Diferență pe cheltuieli — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "chdifreev",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Reevaluările bunului",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "row_id",
"id": "B2917793-1508-5FEE-9573-F71E89640062",
"name": "asset_key",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "inventory_number",
"id": "E81E5902-CB47-5962-B0B6-4F1FD6DB2B9F",
"name": "inventory_number",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_pl",
"id": "0CA1A62C-09B6-509F-9A62-C63E768C2B13",
"name": "product_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "product_id",
"id": "7008D04D-C4B7-5BCC-90BD-5BCB22CE2808",
"name": "product_id",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "pif_key",
"id": "2C17D2F5-B5F8-56CD-AE39-F934C7483532",
"name": "pif_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"nr_doc",
"data_doc",
"nume_gest",
"pu_calc",
"npu_calc",
"am_cum",
"nam_cum",
"crestere",
"chdifreev"
],
"sourceID": "557C9840-6EBB-5990-9A33-49A375507168",
"sqlQuery": "SELECT CONCAT(l.anluna,'|',l.pct_lcr,':',l.id) AS row_id,:asset_key AS asset_key,h.nr_doc,h.data_doc,h.nume_gest,l.pu_calc,l.npu_calc,l.am_cum,l.nam_cum,l.crestere,l.chdifreev\nFROM dbo.reevimob_lin_view l JOIN dbo.reevimob_view h ON h.anluna=l.anluna AND h.pct_lcr=l.pl_rev AND h.id=l.id_rev\nWHERE l.nrinv=:inventory_number AND l.pl_pr=:product_pl AND l.id_pr=:product_id AND COALESCE(CONVERT(varchar(10),l.data_pif,23),'NULL')=:pif_key AND h.valid=1 AND h.anulat=0",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "B723CDED-F1BF-57C0-A8AF-403D8AA6A9AD",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "DB226A58-F235-5EFC-86B3-D407CF46B730",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "0DEA2BAC-17FF-5641-BDDB-092EC00F8C04",
"title": "Istoric lunar și amortizare",
"urlKey": ""
},
{
"id": "D53480CE-E3E8-5206-9905-A3F3B5C07B28",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "C00ABD6E-2E93-5AEE-A59E-8D34045545F1",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "E51E4897-9A5B-5B70-8A03-B5E89D70BF52",
"title": "Achiziție și punere în funcțiune",
"urlKey": ""
},
{
"id": "03C56994-8DF8-5436-8B2F-BA2FC2548E93",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "046995B0-E67B-57DE-AAD4-7422FF845CFE",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DDA0E1D7-700E-5EB0-83F5-8E8307EFCEF0",
"title": "Transferurile bunului",
"urlKey": ""
},
{
"id": "3F86635D-1E49-57BF-B957-397F26D3F5E7",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "0B998C8E-6A6C-5ED4-8EAB-C7CEF4FFA0C7",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "9ECF3A7A-5521-57EB-862A-C99EA673AED0",
"title": "Reevaluările bunului",
"urlKey": ""
}
],
"badgeKey": "val_ram",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anluna",
"label": "Luna situației (AAAALL)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amort",
"label": "Metodă amortizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pif",
"label": "Punere în funcțiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anluna",
"label": "Luna situației (AAAALL)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_clasa",
"label": "Clasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_subcl",
"label": "Subclasă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_pers",
"label": "Responsabil",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_obi",
"label": "Centru de profit",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amort",
"label": "Metodă amortizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dsn",
"label": "Durată normală — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dsr",
"label": "Durată rămasă — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu",
"label": "Valoare intrare înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu_calc",
"label": "Valoare de inventar calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_cum",
"label": "Amortizare cumulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "subventie",
"label": "Subvenție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dif_reev",
"label": "Diferență reevaluare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "vr_calc",
"label": "Valoare rămasă — calcul Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "FF0ACB66-2A20-56FB-B4B1-8DA9D0F7A1DB",
"openFilters": [
{
"id": "A32D8B92-017B-50F7-B4C9-3673109FCF8D",
"includeAllOption": true,
"key": "nume_gest",
"title": "Gestiune",
"type": "text"
},
{
"id": "056CCD8B-0419-5B0A-AC85-B976B6EC6000",
"includeAllOption": true,
"key": "nume_clasa",
"title": "Clasă",
"type": "text"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "FA54A7D7-A679-5E08-8908-E8B4A4A893DC",
"key": "denpr",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "inventory_number",
"systemImage": "person.2",
"title": "Dosare mijloace fixe",
"titleKey": "denpr"
},
{
"actions": [],
"badgeKey": "val_ram",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "0DEA2BAC-17FF-5641-BDDB-092EC00F8C04",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu_calc",
"label": "Valoare de inventar",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_lun",
"label": "Amortizare lunară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_cum",
"label": "Amortizare cumulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amort",
"label": "Metodă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "A478AEAD-8E68-57C4-A016-DE6717238EAA",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "1F9BF66F-0B0E-5AD3-8B97-539855A3EECD",
"key": "anluna",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nume_gest",
"systemImage": "doc.text",
"title": "Istoric lunar al bunului",
"titleKey": "anluna"
},
{
"actions": [],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "E51E4897-9A5B-5B70-8A03-B5E89D70BF52",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gest",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nrd_l",
"label": "Document de intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "datad_l",
"label": "Data documentului de intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pif",
"label": "Punere în funcțiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amort",
"label": "Metodă amortizare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dsn",
"label": "Durată normală — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_cls",
"label": "Clasificare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu",
"label": "Valoare intrare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu_calc",
"label": "Valoare pentru calcul",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "996DC939-B266-5E71-9666-859BA6D89181",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nr_doc",
"systemImage": "doc.text",
"title": "Achiziție și punere în funcțiune",
"titleKey": "nume_furn"
},
{
"actions": [],
"badgeKey": "pu_calc",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gesto",
"label": "Din gestiunea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DDA0E1D7-700E-5EB0-83F5-8E8307EFCEF0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nume_gesto",
"label": "Din gestiunea",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nrinv_v",
"label": "Număr inventar anterior",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nrinv_n",
"label": "Număr inventar nou",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amortv",
"label": "Metodă anterioară",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "met_amort",
"label": "Metodă nouă",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dsn_v",
"label": "Durată anterioară — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "dsn_n",
"label": "Durată nouă — ani",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "40357296-ED3D-551E-9759-CE0C29DAACD4",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nr_doc",
"systemImage": "doc.text",
"title": "Transferurile bunului",
"titleKey": "nume_gesti"
},
{
"actions": [],
"badgeKey": "npu_calc",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "9ECF3A7A-5521-57EB-862A-C99EA673AED0",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_doc",
"label": "Data",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pu_calc",
"label": "Valoare înainte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "am_cum",
"label": "Amortizare cumulată înainte",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nam_cum",
"label": "Amortizare cumulată după",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "crestere",
"label": "Creștere înregistrată în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "chdifreev",
"label": "Diferență pe cheltuieli — Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "718A9C72-3342-5831-9125-DA624F610054",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "B7E58F58-0AB8-580C-B490-79C79488EC31",
"key": "data_doc",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "nr_doc",
"systemImage": "doc.text",
"title": "Reevaluările bunului",
"titleKey": "nume_gest"
}
],
"relations": [
{
"childDatasetID": "0DEA2BAC-17FF-5641-BDDB-092EC00F8C04",
"childKey": "asset_key",
"id": "DB226A58-F235-5EFC-86B3-D407CF46B730",
"name": "Istoric lunar și amortizare",
"parentDatasetID": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"parentKey": "row_id"
},
{
"childDatasetID": "E51E4897-9A5B-5B70-8A03-B5E89D70BF52",
"childKey": "asset_key",
"id": "C00ABD6E-2E93-5AEE-A59E-8D34045545F1",
"name": "Achiziție și punere în funcțiune",
"parentDatasetID": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"parentKey": "row_id"
},
{
"childDatasetID": "DDA0E1D7-700E-5EB0-83F5-8E8307EFCEF0",
"childKey": "asset_key",
"id": "046995B0-E67B-57DE-AAD4-7422FF845CFE",
"name": "Transferurile bunului",
"parentDatasetID": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"parentKey": "row_id"
},
{
"childDatasetID": "9ECF3A7A-5521-57EB-862A-C99EA673AED0",
"childKey": "asset_key",
"id": "0B998C8E-6A6C-5ED4-8EAB-C7CEF4FFA0C7",
"name": "Reevaluările bunului",
"parentDatasetID": "A96318A9-E0C8-50F4-9DD1-D91059EB051D",
"parentKey": "row_id"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T10:33:24Z",
"description": "Dosarul bunului din ultima lună contabilă disponibilă: număr inventar, gestiune, clasă/subclasă, responsabil, centru, PIF, metodă și durată, valoare de intrare, amortizare lunară/cumulată, valoare rămasă, subvenție și reevaluare. Sub-butoane: istoric lunar incluzând luna curentă și cele 24 precedente, achiziție/PIF, transferuri și reevaluări. Nu este stoc fizic live. Luna sursei este afișată explicit. Valorile vin din Nexus și nu sunt recalculate în Cifru. Identitatea snapshotului include luna + numărul inventar + gestiunea; istoricul include și produsul + data PIF pentru a separa numerele reutilizate. Transferurile arată numărul anterior și cel nou. Nu se promite o genealogie completă peste renumerotări/importuri istorice; lipsa documentului PIF asociat nu dovedește lipsa achiziției. Nu aduna amortizarea CUMULATĂ din mai multe luni. Creșterea reevaluării este câmpul sursei, nu diferență inventată între două prețuri. Pro, live, maximum 20.000 poziții curente și 5.000 în fiecare desfășurător; citiri doar pentru bunul selectat, capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/campuri-stoc-de-imobilizari/4128 ; https://www.docs.nexuserp.ro/articol/studiu-de-caz-mijloace-fixe-achizitie-receptie-punere-in-functiune-amortizare-reevaluare-transferuri/5048 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "4549CB6C-96CA-56F5-BC0E-84188F1B0E8E",
"rootButtonCount": 1,
"summary": "Bun → situație lunară → PIF, amortizare, transferuri și reevaluări, cu identitate sigură și valori din Nexus.",
"tags": [
"NexusERP",
"Pro"
],
"title": "Mijloace fixe — dosarul bunului — Pro"
}
}