Retail — Z, bonuri și produse — Pro
Gestiune → Z și casă → bon → produse / încasări, cu totaluri native, contexte exacte și Detalii utile.
Perioadă → magazin/gestiune → rapoarte Z și case → bonurile fiecărui Z → produse și modalități de încasare. Include numai Z-uri validate și neanulate, deja centralizate în Nexus. Nu este situația bonurilor încă deschise și nu generează raportul fiscal Z. Cardurile arată numărul documentelor/bonurilor și valorile raportate; Detaliile includ data fiscală, casa, ora Z, corecția, casierul și factura la bon dacă există. Produsele au cod, UM, cantitate, preț cu TVA, valoarea nativă a liniei, discount, cotă TVA, lot și expirare. Încasările păstrează denumirea modalității din Nexus și suma ei. Sunt clasificări înregistrate pe bon, nu confirmări independente de decontare bancară. Legăturile folosesc luna + punctul de lucru + ID-ul părintelui din FK, nu numărul imprimat sau data. Nu multiplică totaluri prin join între produse și plăți. Bonurile unui Z rămân legate corect și peste miezul nopții. Corecțiile și semnele se păstrează, fără conversie valutară sau ABS. Pro separat: Retail Free, Bonuri fiscale Starter și Vânzări azi rămân neschimbate. Live, citiri la cerere, maximum 10.000 Z, 20.000 bonuri, 10.000 produse per context. Nu aduna din nou aceleași vânzări de la nivelul Z și bonuri. Capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-vanzari-retail/4382 ; https://www.docs.nexuserp.ro/articol/vanzari-retail/2894 .
Screenshots
What this package creates
1 Home4 Details5 lists1 sources to map
- Home: Retail pe gestiuni
- Details: Rapoartele Z și casele
- Details: Bonurile acestui Z
- Details: Produsele bonului
- Details: Modalitățile de încasare
- Sub-button: Rapoarte Z și case
- Sub-button: Bonurile raportului Z
- Sub-button: Produse pe bon
- Sub-button: Modalități de încasare pe bon
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 h.id_gestiune AS row_id,h.id_gestiune AS warehouse_key,MAX(h.den_gestiune) AS gestiune,
COUNT_BIG(*) AS rapoarte_z,SUM(h.nr_bonuri) AS bonuri,SUM(h.valoare) AS valoare,SUM(h.valoare_fara_tva) AS fara_tva,SUM(h.tva) AS tva,
CAST(:period_from AS date) AS period_date,
CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,
CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,
CAST(:period_from AS date) AS data_de_la,
DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la FROM dbo.accesex_bonuri_fiscale_cum h WHERE h.valid=1 AND h.anulat=0 AND h.data_document>=:period_from AND h.data_document<:period_until GROUP BY h.id_gestiunestatic read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.1.sqlQuerySELECT h.id_document AS row_id,h.id_gestiune AS warehouse_key, z.anluna AS z_anluna,z.pct_lcr AS z_pl,z.id AS z_id,h.data_document,h.nr_casa,h.zet,h.den_gestiune,h.corectie,h.nr_bonuri, h.valoare,h.valoare_fara_tva,h.tva,h.ora_cr_zet FROM dbo.accesex_bonuri_fiscale_cum h JOIN dbo.bonfisc_cum z ON h.id_document=CONCAT(z.anluna,'_',z.pct_lcr,'_',CONVERT(bigint,z.id)) WHERE h.valid=1 AND h.anulat=0 AND h.data_document>=:period_from AND h.data_document<:period_until AND h.id_gestiune=:warehouse_key
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.2.sqlQuerySELECT h.id_document AS row_id, CONCAT(z.anluna,'_',z.pct_lcr,'_',CONVERT(bigint,z.id)) AS z_key,h.anluna AS bon_anluna,h.pct_lcr AS bon_pl,h.id AS bon_id, h.numar_document,h.data_document,h.data_bon,CONVERT(char(5),h.data_bon,108) AS ora_bon,h.nr_casa,h.zet,h.den_gestiune,h.casier,h.den_client,h.valoare,h.tva, h.serie_factura,h.numar_factura,h.data_factura FROM dbo.bonfisc_cum z JOIN dbo.bonfisc_det d ON d.anluna=z.anluna AND d.pct_lcr=z.pct_lcr AND d.id_boncum=z.id JOIN dbo.accesex_bonuri_fiscale_det h ON h.anluna=d.anluna AND h.pct_lcr=d.pct_lcr AND h.id=d.id WHERE z.anluna=:z_anluna AND z.pct_lcr=:z_pl AND z.id=:z_id AND z.valid=1 AND z.anulat=0
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.3.sqlQuerySELECT l.id_intern AS row_id,l.id_document AS receipt_key,l.den_produs,l.cod_produs,l.um, l.cantitate,l.pret_vanzare_tva,l.valoare,l.cota_tva_ies,l.valoare_discount,l.nr_lot,l.data_expirare,l.sgr FROM dbo.accesex_bonuri_fiscale_det_lin l WHERE l.anluna=:bon_anluna AND l.pl_bon=:bon_pl AND l.id_bon=:bon_id
static read-only checks passed
Statically verified read-only
$.components.workspaceSelection.datasets.4.sqlQuerySELECT CONCAT(x.anluna,'_',x.pct_lcr,'_',CONVERT(bigint,x.id)) AS row_id, CONCAT(x.anluna,'_',x.pl_bon,'_',CONVERT(bigint,x.id_bon)) AS receipt_key,x.desc_plt AS modalitate,x.suma FROM dbo.bonfisc_det_plt_view x WHERE x.anluna=:bon_anluna AND x.pl_bon=:bon_pl AND x.id_bon=:bon_id
static read-only checks passed
View the JSON being importedcollapsed by default
{
"components": {
"sourceSlots": [
{
"displayName": "NexusERP SQL Server",
"id": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"kind": "sqlServer",
"requiredObjects": [
"dbo.accesex_bonuri_fiscale_cum",
"dbo.bonfisc_cum",
"dbo.bonfisc_det",
"dbo.accesex_bonuri_fiscale_det",
"dbo.accesex_bonuri_fiscale_det_lin",
"dbo.bonfisc_det_plt_view"
],
"requiresCustomSQL": true
}
],
"workspaceSelection": {
"commonFields": [],
"datasets": [
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "F3768EAD-6F1C-5A44-8F35-1E7A85D854A7",
"key": "gestiune",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "2562DD22-A162-536B-8144-D4D8D575A954",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "warehouse_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "gestiune",
"label": "Magazin / gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "rapoarte_z",
"label": "Rapoarte Z",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "rapoarte_z",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "bonuri",
"label": "Bonuri reprezentate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bonuri",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare raportată cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "fara_tva",
"label": "Fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "fara_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_date",
"label": "period_date",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_date",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_from",
"label": "period_from",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_from",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "period_until",
"label": "period_until",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "period_until",
"type": "date",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_de_la",
"label": "Interval ales — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_de_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_pana_la",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 5000,
"name": "Retail pe gestiuni",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "34F534DC-D4F8-512A-B438-3A9462E61AC0",
"name": "period_from",
"source": "openingPeriodStart",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_date",
"id": "4F3D578A-ED5B-53EC-B7F8-94837F23961C",
"name": "period_until",
"source": "openingPeriodEndExclusive",
"type": "date"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"gestiune",
"rapoarte_z",
"bonuri",
"valoare",
"fara_tva",
"tva",
"data_de_la",
"data_pana_la"
],
"sourceID": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"sqlQuery": "SELECT h.id_gestiune AS row_id,h.id_gestiune AS warehouse_key,MAX(h.den_gestiune) AS gestiune,\n COUNT_BIG(*) AS rapoarte_z,SUM(h.nr_bonuri) AS bonuri,SUM(h.valoare) AS valoare,SUM(h.valoare_fara_tva) AS fara_tva,SUM(h.tva) AS tva,\n CAST(:period_from AS date) AS period_date,\n CONVERT(varchar(10),CAST(:period_from AS date),23) AS period_from,\n CONVERT(varchar(10),CAST(:period_until AS date),23) AS period_until,\n CAST(:period_from AS date) AS data_de_la,\n DATEADD(day,-1,CAST(:period_until AS date)) AS data_pana_la FROM dbo.accesex_bonuri_fiscale_cum h WHERE h.valid=1 AND h.anulat=0 AND h.data_document>=:period_from AND h.data_document<:period_until GROUP BY h.id_gestiune",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "FAE8E961-B1F4-55B3-A708-6567EC9B332D",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "warehouse_key",
"label": "warehouse_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "warehouse_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "z_anluna",
"label": "z_anluna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "z_anluna",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "z_pl",
"label": "z_pl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "z_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "z_id",
"label": "z_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "z_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data fiscală",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_casa",
"label": "Casa de marcat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_casa",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "zet",
"label": "Raport Z nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zet",
"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": "corectie",
"label": "Corecție înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "corectie",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_bonuri",
"label": "Număr bonuri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_bonuri",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare_fara_tva",
"label": "Fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_fara_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "ora_cr_zet",
"label": "Ora raportului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ora_cr_zet",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Rapoarte Z și case",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_from",
"id": "90615B75-5717-5904-A056-4B5F51386098",
"name": "period_from",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "period_until",
"id": "FC49DE4B-06DF-5001-9B8A-5E1CDD7A4DCF",
"name": "period_until",
"source": "parentField",
"type": "date"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "warehouse_key",
"id": "3E09C87B-589E-5F58-85EB-D59827ECFCD8",
"name": "warehouse_key",
"source": "parentField",
"type": "text"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"data_document",
"nr_casa",
"zet",
"den_gestiune",
"corectie",
"nr_bonuri",
"valoare",
"valoare_fara_tva",
"tva",
"ora_cr_zet"
],
"sourceID": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"sqlQuery": "SELECT h.id_document AS row_id,h.id_gestiune AS warehouse_key,\n z.anluna AS z_anluna,z.pct_lcr AS z_pl,z.id AS z_id,h.data_document,h.nr_casa,h.zet,h.den_gestiune,h.corectie,h.nr_bonuri,\n h.valoare,h.valoare_fara_tva,h.tva,h.ora_cr_zet\nFROM dbo.accesex_bonuri_fiscale_cum h JOIN dbo.bonfisc_cum z ON h.id_document=CONCAT(z.anluna,'_',z.pct_lcr,'_',CONVERT(bigint,z.id))\nWHERE h.valid=1 AND h.anulat=0 AND h.data_document>=:period_from AND h.data_document<:period_until AND h.id_gestiune=:warehouse_key",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "descending",
"id": "F585DCE7-2A2F-5139-B77D-0C0E34425474",
"key": "data_bon",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "z_key",
"label": "z_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "z_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "bon_anluna",
"label": "bon_anluna",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bon_anluna",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "bon_pl",
"label": "bon_pl",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bon_pl",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "bon_id",
"label": "bon_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "bon_id",
"type": "number",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_document",
"label": "Bon nr.",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_document",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "data_document",
"label": "Data fiscală",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_document",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_bon",
"label": "Data bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_bon",
"type": "date",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "ora_bon",
"label": "Ora bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "ora_bon",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "nr_casa",
"label": "Casa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_casa",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "zet",
"label": "Raport Z",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "zet",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_gestiune",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "casier",
"label": "Casier",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "casier",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "den_client",
"label": "Client înscris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_client",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "serie_factura",
"label": "Serie factură la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "serie_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "numar_factura",
"label": "Factură la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "numar_factura",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_factura",
"label": "Data facturii la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_factura",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 20000,
"name": "Bonurile raportului Z",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "z_anluna",
"id": "6075A13B-E07B-5645-A235-6DDCD80A0B12",
"name": "z_anluna",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "z_pl",
"id": "68DAA4B8-4A7F-5E4F-B6B8-CAFF4709711F",
"name": "z_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "z_id",
"id": "5D7339CF-8C0C-5FE3-8F6B-BA5861C44088",
"name": "z_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"numar_document",
"data_document",
"data_bon",
"ora_bon",
"nr_casa",
"zet",
"den_gestiune",
"casier",
"den_client",
"valoare",
"tva",
"serie_factura",
"numar_factura",
"data_factura"
],
"sourceID": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"sqlQuery": "SELECT h.id_document AS row_id,\n CONCAT(z.anluna,'_',z.pct_lcr,'_',CONVERT(bigint,z.id)) AS z_key,h.anluna AS bon_anluna,h.pct_lcr AS bon_pl,h.id AS bon_id,\n h.numar_document,h.data_document,h.data_bon,CONVERT(char(5),h.data_bon,108) AS ora_bon,h.nr_casa,h.zet,h.den_gestiune,h.casier,h.den_client,h.valoare,h.tva,\n h.serie_factura,h.numar_factura,h.data_factura\nFROM dbo.bonfisc_cum z JOIN dbo.bonfisc_det d ON d.anluna=z.anluna AND d.pct_lcr=z.pct_lcr AND d.id_boncum=z.id\nJOIN dbo.accesex_bonuri_fiscale_det h ON h.anluna=d.anluna AND h.pct_lcr=d.pct_lcr AND h.id=d.id\nWHERE z.anluna=:z_anluna AND z.pct_lcr=:z_pl AND z.id=:z_id AND z.valid=1 AND z.anulat=0",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "CE4B059F-7651-53E4-AD3E-0BE34FB11D9C",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "receipt_key",
"label": "receipt_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "receipt_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "den_produs",
"label": "Produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "den_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cod_produs",
"label": "Cod produs",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cod_produs",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "um",
"label": "UM",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "um",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "cantitate",
"label": "Cantitate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "cantitate",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "pret_vanzare_tva",
"label": "Preț cu TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "pret_vanzare_tva",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "valoare",
"label": "Valoare linie în Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare",
"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_discount",
"label": "Discount înregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "valoare_discount",
"type": "number",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "nr_lot",
"label": "Lot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "nr_lot",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "data_expirare",
"type": "date",
"visibleInDetail": true,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "sgr",
"label": "SGR — înregistrare Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "sgr",
"type": "text",
"visibleInDetail": true,
"visibleInList": false
}
],
"maxRows": 10000,
"name": "Produse pe bon",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_anluna",
"id": "A7550400-13E2-5EF9-BD41-180E1E8C695E",
"name": "bon_anluna",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_pl",
"id": "44746AE2-A4F6-5690-885C-561247391E42",
"name": "bon_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_id",
"id": "B81F0DF3-0998-5E53-8590-301DEC40DB74",
"name": "bon_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"den_produs",
"cod_produs",
"um",
"cantitate",
"pret_vanzare_tva",
"valoare",
"cota_tva_ies",
"valoare_discount",
"nr_lot",
"data_expirare",
"sgr"
],
"sourceID": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"sqlQuery": "SELECT l.id_intern AS row_id,l.id_document AS receipt_key,l.den_produs,l.cod_produs,l.um,\n l.cantitate,l.pret_vanzare_tva,l.valoare,l.cota_tva_ies,l.valoare_discount,l.nr_lot,l.data_expirare,l.sgr\nFROM dbo.accesex_bonuri_fiscale_det_lin l WHERE l.anluna=:bon_anluna AND l.pl_bon=:bon_pl AND l.id_bon=:bon_id",
"tableName": ""
},
{
"cacheMode": "live",
"calculatedFields": [],
"customQueryIntegrationName": "NexusERP",
"endpointPath": "",
"fetchSortRules": [
{
"direction": "ascending",
"id": "97E71E18-164C-54E8-B95E-7DD1F0E1621F",
"key": "modalitate",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"id": "48F98985-5576-562D-A931-0DF5EE594183",
"mappings": [
{
"commonFieldKey": "",
"key": "row_id",
"label": "row_id",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "row_id",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "receipt_key",
"label": "receipt_key",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "receipt_key",
"type": "text",
"visibleInDetail": false,
"visibleInList": false
},
{
"commonFieldKey": "",
"key": "modalitate",
"label": "Modalitate înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "modalitate",
"type": "text",
"visibleInDetail": true,
"visibleInList": true
},
{
"commonFieldKey": "",
"key": "suma",
"label": "Sumă înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic",
"sourceColumn": "suma",
"type": "number",
"visibleInDetail": true,
"visibleInList": true
}
],
"maxRows": 5000,
"name": "Modalități de încasare pe bon",
"primaryKey": "row_id",
"queryParameters": [
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_anluna",
"id": "A7550400-13E2-5EF9-BD41-180E1E8C695E",
"name": "bon_anluna",
"source": "parentField",
"type": "text"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_pl",
"id": "44746AE2-A4F6-5690-885C-561247391E42",
"name": "bon_pl",
"source": "parentField",
"type": "number"
},
{
"constantValue": "",
"dayOffset": 0,
"fieldKey": "bon_id",
"id": "B81F0DF3-0998-5E53-8590-301DEC40DB74",
"name": "bon_id",
"source": "parentField",
"type": "number"
}
],
"refreshPolicy": {
"enabled": false,
"intervalMinutes": 60
},
"rootArrayPath": "",
"rowLimitEnabled": true,
"searchKeys": [
"modalitate",
"suma"
],
"sourceID": "2FF93DF7-5CA5-562D-94C2-3ECC80C7FA3A",
"sqlQuery": "SELECT CONCAT(x.anluna,'_',x.pct_lcr,'_',CONVERT(bigint,x.id)) AS row_id,\n CONCAT(x.anluna,'_',x.pl_bon,'_',CONVERT(bigint,x.id_bon)) AS receipt_key,x.desc_plt AS modalitate,x.suma\nFROM dbo.bonfisc_det_plt_view x WHERE x.anluna=:bon_anluna AND x.pl_bon=:bon_pl AND x.id_bon=:bon_id",
"tableName": ""
}
],
"pages": [
{
"actions": [
{
"id": "DB359181-6089-5DF4-ABC2-350654466BE8",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "A802E037-7429-5373-B2E6-B9BF2A903CB9",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "FAE8E961-B1F4-55B3-A708-6567EC9B332D",
"title": "Rapoartele Z și casele",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "rapoarte_z",
"label": "Rapoarte Z",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bonuri",
"label": "Bonuri reprezentate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "2562DD22-A162-536B-8144-D4D8D575A954",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "rapoarte_z",
"label": "Rapoarte Z",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "bonuri",
"label": "Bonuri reprezentate",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "fara_tva",
"label": "Fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_de_la",
"label": "Interval ales — de la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_pana_la",
"label": "Până la",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "9EC164A7-6747-5961-989C-7B695FD170A2",
"openFilters": [
{
"datePeriodOptions": [
"today",
"currentMonth",
"last7Days",
"last30Days",
"last90Days"
],
"id": "62237B8E-90D1-514A-A3EF-9A87CE4668BD",
"includeAllOption": false,
"key": "period_date",
"title": "Perioada",
"type": "date"
}
],
"pageSize": 100,
"requiresOpeningFilterSelection": true,
"showOnHome": true,
"sortRules": [
{
"direction": "ascending",
"id": "F3768EAD-6F1C-5A44-8F35-1E7A85D854A7",
"key": "gestiune",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "person.2",
"title": "Retail pe gestiuni",
"titleKey": "gestiune"
},
{
"actions": [
{
"id": "6C5D7CC1-E11A-56E9-BA1A-B7D42BFEDF0A",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "52C8D3A0-0C6E-5EEA-9CDD-52F9B7A8532A",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"title": "Bonurile acestui Z",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data fiscală",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_casa",
"label": "Casa de marcat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_bonuri",
"label": "Număr bonuri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "FAE8E961-B1F4-55B3-A708-6567EC9B332D",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data fiscală",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_casa",
"label": "Casa de marcat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "corectie",
"label": "Corecție înregistrată",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_bonuri",
"label": "Număr bonuri",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_fara_tva",
"label": "Fără TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ora_cr_zet",
"label": "Ora raportului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "396A8C0E-D8D1-5422-B7A5-E958CE38866E",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "05D45B02-C59C-57FC-B65A-2067309AC67E",
"key": "data_document",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "den_gestiune",
"systemImage": "doc.text",
"title": "Rapoarte Z și case",
"titleKey": "zet"
},
{
"actions": [
{
"id": "5CA50D23-0BAF-5EE5-91A9-3D1AA044741E",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "11447956-A0B9-50CB-971D-43A5CDCE8CFB",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "CE4B059F-7651-53E4-AD3E-0BE34FB11D9C",
"title": "Produsele bonului",
"urlKey": ""
},
{
"id": "CBB41D36-8A6D-56D3-A417-D65E7DE7E979",
"kind": "showRelated",
"relatedInitiallyExpanded": false,
"relatedPresentation": "separate",
"relatedPreviewLimit": 12,
"relatedRowStyle": "cards",
"relatedShowsCount": true,
"relationID": "35596C5F-631F-5DF9-A4E7-458639AA606F",
"systemImage": "list.bullet.rectangle",
"targetDatasetID": "48F98985-5576-562D-A931-0DF5EE594183",
"title": "Modalitățile de încasare",
"urlKey": ""
}
],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_bon",
"label": "Data bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ora_bon",
"label": "Ora bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_casa",
"label": "Casa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"datasetID": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_document",
"label": "Data fiscală",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_bon",
"label": "Data bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "ora_bon",
"label": "Ora bonului",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_casa",
"label": "Casa",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "zet",
"label": "Raport Z",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_gestiune",
"label": "Gestiune",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "den_client",
"label": "Client înscris",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "tva",
"label": "TVA",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "serie_factura",
"label": "Serie factură la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "numar_factura",
"label": "Factură la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_factura",
"label": "Data facturii la bon",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "73D36178-85E5-50F4-B63A-0893A045A6F0",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "descending",
"id": "F585DCE7-2A2F-5139-B77D-0C0E34425474",
"key": "data_bon",
"type": "date"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "casier",
"systemImage": "doc.text",
"title": "Bonurile raportului Z",
"titleKey": "numar_document"
},
{
"actions": [],
"badgeKey": "valoare",
"cardEnrichments": [],
"cardFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"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": "CE4B059F-7651-53E4-AD3E-0BE34FB11D9C",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "um",
"label": "UM",
"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"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "cota_tva_ies",
"label": "Cotă TVA (%)",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "valoare_discount",
"label": "Discount înregistrat",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "nr_lot",
"label": "Lot",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "data_expirare",
"label": "Expirare",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
},
{
"detailGroup": "",
"detailRole": "information",
"isVisible": true,
"key": "sgr",
"label": "SGR — înregistrare Nexus",
"locationLabelKey": "",
"locationLongitudeKey": "",
"presentation": "automatic"
}
],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "CE1B8A20-346F-5BAF-BA52-F73CA11B7DD6",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "C0662EC4-4556-524F-9B67-210C0C480C6C",
"key": "den_produs",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "cod_produs",
"systemImage": "doc.text",
"title": "Produse pe bon",
"titleKey": "den_produs"
},
{
"actions": [],
"badgeKey": "suma",
"cardEnrichments": [],
"cardFieldLayout": [],
"datasetID": "48F98985-5576-562D-A931-0DF5EE594183",
"dateFilterKey": "",
"dateFilterLastDays": 7,
"dateFilterPreset": "none",
"detailFieldLayout": [],
"detailLiveRefreshSeconds": 0,
"fixedFilters": [],
"id": "7775A455-2CC7-5A02-BC73-C6EE46186FF4",
"openFilters": [],
"pageSize": 100,
"requiresOpeningFilterSelection": false,
"showOnHome": false,
"sortRules": [
{
"direction": "ascending",
"id": "97E71E18-164C-54E8-B95E-7DD1F0E1621F",
"key": "modalitate",
"type": "text"
},
{
"direction": "ascending",
"id": "A3C766ED-F630-572E-9A1A-F32A4B99ACA4",
"key": "row_id",
"type": "text"
}
],
"subtitle": "",
"subtitleKey": "",
"systemImage": "doc.text",
"title": "Modalități de încasare pe bon",
"titleKey": "modalitate"
}
],
"relations": [
{
"childDatasetID": "FAE8E961-B1F4-55B3-A708-6567EC9B332D",
"childKey": "warehouse_key",
"id": "A802E037-7429-5373-B2E6-B9BF2A903CB9",
"name": "Rapoartele Z și casele",
"parentDatasetID": "2562DD22-A162-536B-8144-D4D8D575A954",
"parentKey": "warehouse_key"
},
{
"childDatasetID": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"childKey": "z_key",
"id": "52C8D3A0-0C6E-5EEA-9CDD-52F9B7A8532A",
"name": "Bonurile acestui Z",
"parentDatasetID": "FAE8E961-B1F4-55B3-A708-6567EC9B332D",
"parentKey": "row_id"
},
{
"childDatasetID": "CE4B059F-7651-53E4-AD3E-0BE34FB11D9C",
"childKey": "receipt_key",
"id": "11447956-A0B9-50CB-971D-43A5CDCE8CFB",
"name": "Produsele bonului",
"parentDatasetID": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"parentKey": "row_id"
},
{
"childDatasetID": "48F98985-5576-562D-A931-0DF5EE594183",
"childKey": "receipt_key",
"id": "35596C5F-631F-5DF9-A4E7-458639AA606F",
"name": "Modalitățile de încasare",
"parentDatasetID": "CE6AAB99-B7DD-57F0-A336-4B6A3F843540",
"parentKey": "row_id"
}
],
"widgets": []
}
},
"format": "cifru-configuration-package",
"formatVersion": 1,
"manifest": {
"applicationName": "NexusERP",
"configurationLanguages": [
"ro"
],
"countries": [
"RO"
],
"createdAt": "2026-09-27T10:27:45Z",
"description": "Perioadă → magazin/gestiune → rapoarte Z și case → bonurile fiecărui Z → produse și modalități de încasare. Include numai Z-uri validate și neanulate, deja centralizate în Nexus. Nu este situația bonurilor încă deschise și nu generează raportul fiscal Z. Cardurile arată numărul documentelor/bonurilor și valorile raportate; Detaliile includ data fiscală, casa, ora Z, corecția, casierul și factura la bon dacă există. Produsele au cod, UM, cantitate, preț cu TVA, valoarea nativă a liniei, discount, cotă TVA, lot și expirare. Încasările păstrează denumirea modalității din Nexus și suma ei. Sunt clasificări înregistrate pe bon, nu confirmări independente de decontare bancară. Legăturile folosesc luna + punctul de lucru + ID-ul părintelui din FK, nu numărul imprimat sau data. Nu multiplică totaluri prin join între produse și plăți. Bonurile unui Z rămân legate corect și peste miezul nopții. Corecțiile și semnele se păstrează, fără conversie valutară sau ABS. Pro separat: Retail Free, Bonuri fiscale Starter și Vânzări azi rămân neschimbate. Live, citiri la cerere, maximum 10.000 Z, 20.000 bonuri, 10.000 produse per context. Nu aduna din nou aceleași vânzări de la nivelul Z și bonuri. Capturi DEMO. Manuale: https://www.docs.nexuserp.ro/articol/citire-vanzari-retail/4382 ; https://www.docs.nexuserp.ro/articol/vanzari-retail/2894 .",
"licenseCode": "Cifru-Community-1.0",
"minimumCifruVersion": "1.1.0",
"minimumPlan": "pro",
"packageID": "BD6F3D2A-BF3F-50CC-9A75-EEF2C1377883",
"rootButtonCount": 1,
"summary": "Gestiune → Z și casă → bon → produse / încasări, cu totaluri native, contexte exacte și Detalii utile.",
"tags": [
"NexusERP",
"Pro"
],
"title": "Retail — Z, bonuri și produse — Pro"
}
}