NexusERP
Documente comerciale și NIR cu linii
Facturi, avize și note de intrare-recepție, fiecare cu antet clar și linii în același ecran.
Pachet read-only verificat pe obiectele AccesEx expuse de instalarea NexusERP testată de Cifru. Creează trei butoane Home distincte — Facturi clienți, Avize clienți și Note intrare-recepție — iar liniile documentului apar în același ecran, sub antet. Nu amestecă facturile cu NIR și nu inventează tabele.
Pregătire în NexusERP / SQL Server:
1. Administratorul bazei creează un login SQL dedicat Cifru cu drept SELECT numai pe cele șase obiecte AccesEx enumerate de pachet.
2. Expune SQL Server printr-o conexiune TLS accesibilă telefonului (VPN este preferabil accesului public).
3. Confirmă că instalarea ta conține exact view-urile/tabelele AccesEx; versiunile Nexus pot diferi.
Configurare în Cifru pe iPhone/iPad:
1. Surse → Adaugă sursă → SQL Server.
2. Completează hostul, portul, baza, utilizatorul read-only și parola; păstrează TLS activ și rulează testul structurii.
3. Construire → Comunitate → Importă pachetul; mapează singurul slot „NexusERP SQL Server (AccesEx)” la sursa creată.
4. Rulează „Testează citirea și compatibilitatea”. Cifru verifică local fiecare obiect și fiecare câmp înainte de aplicare.
Pachetul nu conține host, parolă, date sau credențiale. Este neoficial și nu este afiliat NexusERP.
Ce creează pachetul
3 Home3 Detalii6 liste1 surse de legat
- Home: Facturi clienți
- Home: Avize clienți
- Home: Note intrare-recepție
- Detalii: Linii factură
- Detalii: Linii aviz
- Detalii: Linii NIR
- Sub-buton: Linii factură
- Sub-buton: Linii aviz
- Sub-buton: Linii NIR
Sursele se mapează local și se verifică înainte de aplicare.
Vezi JSON-ul care se importărestrâns implicit
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server (AccesEx)",
"id": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_facturi_clienti",
"dbo.accesex_facturi_clienti_lin",
"dbo.accesex_avize_clienti_view",
"dbo.accesex_avize_clienti_lin_view",
"dbo.accesex_note_de_intrare_receptie",
"dbo.accesex_note_de_intrare_receptie_lin"
],
"requiresCustomSQL": false
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "C44269D0-0028-5540-9ACC-E182E89EBDDB",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_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": "document_number",
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "customer_name",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"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": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_incasata",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_incasata",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sold",
"label": "Sold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sold",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "stare_factura",
"label": "Stare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "stare_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "user_creare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Facturi clienți",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"serie_document",
"numar_document",
"data_document",
"den_client"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_clienti"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "DF3BCA5D-FD1A-56BF-B419-E26D0872B7F6",
"mappings": [
{
"commonFieldKey": "",
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_linie_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_intrare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Linii facturi clienți",
"primaryKey": "id_linie_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_linie_document",
"id_document",
"id_intern",
"id_produs",
"cod_produs"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_facturi_clienti_lin"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "BECADDAC-CF5C-5192-B55F-E397E166AD11",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_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": "document_number",
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "customer_name",
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"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": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_cu_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "validare",
"label": "Validat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Avize clienți",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"serie_document",
"numar_document",
"data_document",
"den_client"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_avize_clienti_view"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "C85BAE32-A76B-556A-BEC0-E082A1966BC4",
"mappings": [
{
"commonFieldKey": "",
"key": "_id",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "_id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cota_tva_ies",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cota_tva_ies",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Linii avize clienți",
"primaryKey": "_id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"_id",
"id_document",
"id_intern",
"cod_produs",
"den_produs"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_avize_clienti_lin_view"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"id": "24D9DA7B-5E9E-5D4F-8B95-BD4971331256",
"mappings": [
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_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": "document_number",
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "document_date",
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "supplier_name",
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_furnizor",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"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": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "validare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "anulare",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_cr",
"label": "Data creării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_cr",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 500,
"name": "Note de intrare-recepție",
"primaryKey": "id_document",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id_document",
"serie_document",
"numar_document",
"data_document",
"den_furnizor"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_note_de_intrare_receptie"
},
{
"cacheMode": "cached",
"calculatedFields": [],
"customQueryIntegrationName": "",
"endpointPath": "",
"fetchSortRules": [],
"id": "6902F0F5-5EF4-5862-B3BE-B059CA77A8B8",
"mappings": [
{
"commonFieldKey": "",
"key": "id",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_nir",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_nir",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_intern",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "id_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "product_code",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "product_name",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "quantity",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_achizitie",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare",
"label": "Preț vânzare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_intrare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 2000,
"name": "Linii note de intrare-recepție",
"primaryKey": "id",
"refreshPolicy": {
"enabled": true,
"intervalMinutes": 15
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"id",
"id_document",
"id_nir",
"id_intern",
"id_produs"
],
"sourceID": "80CABD76-D6DB-5FFE-81DE-FB20F2087E76",
"sqlQuery": "",
"tableName": "dbo.accesex_note_de_intrare_receptie_lin"
}
],
"pages": [
{
"actions": [
{
"id": "97AA8F18-9112-5511-865A-578083D28108",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "DC3798DD-0D83-59DD-ACD8-7EBD45E8B7A2",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "DF3BCA5D-FD1A-56BF-B419-E26D0872B7F6",
"title": "Linii factură",
"urlKey": ""
}
],
"badgeKey": "valoare_cu_tva",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C44269D0-0028-5540-9ACC-E182E89EBDDB",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_incasata",
"label": "Încasat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sold",
"label": "Sold",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "stare_factura",
"label": "Stare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "user_creare",
"label": "Creată de",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "D472B5F3-CB51-55E8-B73E-17D94C3D0512",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_client",
"systemImage": "doc.text",
"title": "Facturi clienți",
"titleKey": "numar_document"
},
{
"actions": [
{
"id": "CC1D2C7B-3FDF-566F-A905-BA832C81803C",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "E13BB58A-5F12-5D0A-BC21-33B38A90FAAA",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "C85BAE32-A76B-556A-BEC0-E082A1966BC4",
"title": "Linii aviz",
"urlKey": ""
}
],
"badgeKey": "valoare_cu_tva",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "BECADDAC-CF5C-5192-B55F-E397E166AD11",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare_cu_tva",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "B624F60F-03B9-5E4A-A38F-C97FF419613E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_client",
"systemImage": "doc.text",
"title": "Avize clienți",
"titleKey": "numar_document"
},
{
"actions": [
{
"id": "DFD048DA-9FA7-5269-AE30-720C6671194A",
"kind": "showRelated",
"relatedInitiallyExpanded": true,
"relatedPresentation": "inline",
"relatedPreviewLimit": 12,
"relatedRowStyle": "table",
"relatedShowsCount": true,
"relationID": "FCD10439-5829-5C9A-B906-650E14762A6F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "6902F0F5-5EF4-5862-B3BE-B059CA77A8B8",
"title": "Linii NIR",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "24D9DA7B-5E9E-5D4F-8B95-BD4971331256",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_document",
"label": "Serie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_document",
"label": "Număr document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data documentului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_furnizor",
"label": "Furnizor",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "validare",
"label": "Validată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "anulare",
"label": "Anulată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_cr",
"label": "Data creării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "9CA04C84-9C10-586E-BCF1-04959C17BD0F",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": true,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
}
],
"subtitle": "",
"subtitleKey": "den_furnizor",
"systemImage": "doc.text",
"title": "Note intrare-recepție",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "DF3BCA5D-FD1A-56BF-B419-E26D0872B7F6",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_linie_document",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "51024BD8-69E9-5C33-9C9F-392101D1D969",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "tablecells",
"title": "Linii factură",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "C85BAE32-A76B-556A-BEC0-E082A1966BC4",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "_id",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare",
"label": "Valoare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "3B20F9A5-08C8-51E2-97C2-CFCA4E32FB81",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "tablecells",
"title": "Linii aviz",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "cantitate",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "6902F0F5-5EF4-5862-B3BE-B059CA77A8B8",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id",
"label": "ID linie",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_document",
"label": "ID document",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_nir",
"label": "ID NIR",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_intern",
"label": "ID intern",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "id_produs",
"label": "ID produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "highlight",
"isVisible": true,
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_achizitie",
"label": "Preț achiziție",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare",
"label": "Preț vânzare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "pret_vanzare_tva",
"label": "Preț vânzare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_intrare",
"label": "Data intrării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Data expirării",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"fixedFilters": [],
"id": "B62FDB14-94AF-52EB-9166-86662FB1009A",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "tablecells",
"title": "Linii NIR",
"titleKey": "den_produs"
}
],
"relations": [
{
"childDatasetID": "DF3BCA5D-FD1A-56BF-B419-E26D0872B7F6",
"childKey": "id_document",
"id": "DC3798DD-0D83-59DD-ACD8-7EBD45E8B7A2",
"name": "Linii factură",
"parentDatasetID": "C44269D0-0028-5540-9ACC-E182E89EBDDB",
"parentKey": "id_document"
},
{
"childDatasetID": "C85BAE32-A76B-556A-BEC0-E082A1966BC4",
"childKey": "id_document",
"id": "E13BB58A-5F12-5D0A-BC21-33B38A90FAAA",
"name": "Linii aviz",
"parentDatasetID": "BECADDAC-CF5C-5192-B55F-E397E166AD11",
"parentKey": "id_document"
},
{
"childDatasetID": "6902F0F5-5EF4-5862-B3BE-B059CA77A8B8",
"childKey": "id_document",
"id": "FCD10439-5829-5C9A-B906-650E14762A6F",
"name": "Linii NIR",
"parentDatasetID": "24D9DA7B-5E9E-5D4F-8B95-BD4971331256",
"parentKey": "id_document"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-07-24T16:26:43Z",
"description": "Pachet read-only verificat pe obiectele AccesEx expuse de instalarea NexusERP testată de Cifru. Creează trei butoane Home distincte — Facturi clienți, Avize clienți și Note intrare-recepție — iar liniile documentului apar în același ecran, sub antet. Nu amestecă facturile cu NIR și nu inventează tabele.\n\nPregătire în NexusERP / SQL Server:\n1. Administratorul bazei creează un login SQL dedicat Cifru cu drept SELECT numai pe cele șase obiecte AccesEx enumerate de pachet.\n2. Expune SQL Server printr-o conexiune TLS accesibilă telefonului (VPN este preferabil accesului public).\n3. Confirmă că instalarea ta conține exact view-urile/tabelele AccesEx; versiunile Nexus pot diferi.\n\nConfigurare în Cifru pe iPhone/iPad:\n1. Surse → Adaugă sursă → SQL Server.\n2. Completează hostul, portul, baza, utilizatorul read-only și parola; păstrează TLS activ și rulează testul structurii.\n3. Construire → Comunitate → Importă pachetul; mapează singurul slot „NexusERP SQL Server (AccesEx)” la sursa creată.\n4. Rulează „Testează citirea și compatibilitatea”. Cifru verifică local fiecare obiect și fiecare câmp înainte de aplicare.\n\nPachetul nu conține host, parolă, date sau credențiale. Este neoficial și nu este afiliat NexusERP.",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.0",
"minimumPlan": "starter",
"packageID": "D9E2ABD2-8272-5E6E-969F-3C26218713E6",
"rootButtonCount": 3,
"summary": "Facturi, avize și note de intrare-recepție, fiecare cu antet clar și linii în același ecran.",
"tags": [
"NexusERP",
"facturi",
"avize",
"NIR",
"SQL Server",
"read-only"
],
"title": "Documente comerciale și NIR cu linii"
}
}