Audit modifiche

Consulta le modifiche registrate dai trigger database. Gli intervalli data/ora sono interpretati come orario italiano Europe/Rome.

Azzera filtri
Filtro record attivo: codice prodotto #122
4 eventi mostrati · offset 50Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 12:28:12Inserimentoinventory_movements2671app interna · csv_import · consuntivo_posting · assignment:2156
id: ∅ → 2671; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2156; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2671,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2156",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:12.081",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": 157,
    "old": null
  },
  "product_code_id": {
    "new": 122,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2671,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2156",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:12.081",
  "scrap_by_type": null,
  "quantity_delta": 157,
  "product_code_id": 122
}
22/05/26, 12:28:12Modificaraw_material_balances61app interna · csv_import · consuntivo_posting · assignment:2156
quantity: 312 → 155; updated_at: 2026-05-12T13:13:28.396 → 2026-05-22T10:28:12.074
Dettagli before/after
Diff
{
  "quantity": {
    "new": 155,
    "old": 312
  },
  "updated_at": {
    "new": "2026-05-22T10:28:12.074",
    "old": "2026-05-12T13:13:28.396"
  }
}
Prima
{
  "id": 61,
  "quantity": 312,
  "warehouse": "raw",
  "updated_at": "2026-05-12T13:13:28.396",
  "raw_material_id": 21
}
Dopo
{
  "id": 61,
  "quantity": 155,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:12.074",
  "raw_material_id": 21
}
22/05/26, 12:28:12Inserimentoraw_material_movements1621app interna · csv_import · consuntivo_posting · assignment:2156
id: ∅ → 1621; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2156; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1621,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2156",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:12.067",
    "old": null
  },
  "quantity_delta": {
    "new": -157,
    "old": null
  },
  "raw_material_id": {
    "new": 21,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1621,
  "reason": "production_consumption",
  "metadata": null,
  "reference": "assignment:2156",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:12.067",
  "quantity_delta": -157,
  "raw_material_id": 21
}
22/05/26, 12:28:12Inserimentoplan_assignments2156—
id: ∅ → 2156; date: ∅ → 2026-05-14; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2156,
    "old": null
  },
  "date": {
    "new": "2026-05-14",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 24,
    "old": null
  },
  "operator_id": {
    "new": 25,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 122,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 157,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2156,
  "date": "2026-05-14",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 24,
  "operator_id": 25,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 122,
  "planned_quantity": null,
  "produced_quantity": 157,
  "setup_from_product_code_id": null
}
← Precedenti