Audit modifiche
Consulta le modifiche registrate dai trigger database. Gli intervalli data/ora sono interpretati come orario italiano Europe/Rome.
8 eventi mostrati · offset 200Ordinati dal più recente
| Quando | Azione | Tabella | Record | Contesto | Sintesi modifiche |
|---|---|---|---|---|---|
| 22/05/26, 12:28:11 | Modifica | raw_material_balances | 13 | app interna · csv_import · consuntivo_posting · assignment:2145 | quantity: 282 → 14; updated_at: 2026-05-22T10:28:11.519 → 2026-05-22T10:28:11.738 Dettagli before/afterDiff {
"quantity": {
"new": 14,
"old": 282
},
"updated_at": {
"new": "2026-05-22T10:28:11.738",
"old": "2026-05-22T10:28:11.519"
}
}Prima {
"id": 13,
"quantity": 282,
"warehouse": "raw",
"updated_at": "2026-05-22T10:28:11.519",
"raw_material_id": 5
}Dopo {
"id": 13,
"quantity": 14,
"warehouse": "raw",
"updated_at": "2026-05-22T10:28:11.738",
"raw_material_id": 5
} |
| 22/05/26, 12:28:11 | Inserimento | raw_material_movements | 1613 | app interna · csv_import · consuntivo_posting · assignment:2145 | id: ∅ → 1613; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2145; +4 altri campi Dettagli before/afterDiff {
"id": {
"new": 1613,
"old": null
},
"reason": {
"new": "production_consumption",
"old": null
},
"metadata": {
"new": null,
"old": null
},
"reference": {
"new": "assignment:2145",
"old": null
},
"warehouse": {
"new": "raw",
"old": null
},
"occurred_at": {
"new": "2026-05-22T10:28:11.735",
"old": null
},
"quantity_delta": {
"new": -268,
"old": null
},
"raw_material_id": {
"new": 5,
"old": null
}
}Prima null Dopo {
"id": 1613,
"reason": "production_consumption",
"metadata": null,
"reference": "assignment:2145",
"warehouse": "raw",
"occurred_at": "2026-05-22T10:28:11.735",
"quantity_delta": -268,
"raw_material_id": 5
} |
| 22/05/26, 12:28:11 | Inserimento | plan_assignments | 2145 | — | id: ∅ → 2145; date: ∅ → 2026-05-14; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi Dettagli before/afterDiff {
"id": {
"new": 2145,
"old": null
},
"date": {
"new": "2026-05-14",
"old": null
},
"notes": {
"new": null,
"old": null
},
"shift": {
"new": "T2",
"old": null
},
"status": {
"new": "completed",
"old": null
},
"machine_id": {
"new": 14,
"old": null
},
"operator_id": {
"new": 41,
"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": 105,
"old": null
},
"planned_quantity": {
"new": null,
"old": null
},
"produced_quantity": {
"new": 268,
"old": null
},
"setup_from_product_code_id": {
"new": null,
"old": null
}
}Prima null Dopo {
"id": 2145,
"date": "2026-05-14",
"notes": null,
"shift": "T2",
"status": "completed",
"machine_id": 14,
"operator_id": 41,
"scrap_by_type": null,
"setup_minutes": null,
"assignment_type": "production",
"product_code_id": 105,
"planned_quantity": null,
"produced_quantity": 268,
"setup_from_product_code_id": null
} |
| 22/05/26, 12:28:11 | Modifica | inventory_balances | 1068 | app interna · csv_import · consuntivo_posting · assignment:2138 | quantity: 28 → 480; updated_at: 2026-05-14T11:09:43.055 → 2026-05-22T10:28:11.534 Dettagli before/afterDiff {
"quantity": {
"new": 480,
"old": 28
},
"updated_at": {
"new": "2026-05-22T10:28:11.534",
"old": "2026-05-14T11:09:43.055"
}
}Prima {
"id": 1068,
"quantity": 28,
"warehouse": "semi_finished",
"updated_at": "2026-05-14T11:09:43.055",
"product_code_id": 105
}Dopo {
"id": 1068,
"quantity": 480,
"warehouse": "semi_finished",
"updated_at": "2026-05-22T10:28:11.534",
"product_code_id": 105
} |
| 22/05/26, 12:28:11 | Inserimento | inventory_movements | 2647 | app interna · csv_import · consuntivo_posting · assignment:2138 | id: ∅ → 2647; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2138; +5 altri campi Dettagli before/afterDiff {
"id": {
"new": 2647,
"old": null
},
"reason": {
"new": "production_output",
"old": null
},
"metadata": {
"new": null,
"old": null
},
"reference": {
"new": "assignment:2138",
"old": null
},
"warehouse": {
"new": "semi_finished",
"old": null
},
"occurred_at": {
"new": "2026-05-22T10:28:11.526",
"old": null
},
"scrap_by_type": {
"new": null,
"old": null
},
"quantity_delta": {
"new": 452,
"old": null
},
"product_code_id": {
"new": 105,
"old": null
}
}Prima null Dopo {
"id": 2647,
"reason": "production_output",
"metadata": null,
"reference": "assignment:2138",
"warehouse": "semi_finished",
"occurred_at": "2026-05-22T10:28:11.526",
"scrap_by_type": null,
"quantity_delta": 452,
"product_code_id": 105
} |
| 22/05/26, 12:28:11 | Modifica | raw_material_balances | 13 | app interna · csv_import · consuntivo_posting · assignment:2138 | quantity: 734 → 282; updated_at: 2026-05-12T12:45:55.922 → 2026-05-22T10:28:11.519 Dettagli before/afterDiff {
"quantity": {
"new": 282,
"old": 734
},
"updated_at": {
"new": "2026-05-22T10:28:11.519",
"old": "2026-05-12T12:45:55.922"
}
}Prima {
"id": 13,
"quantity": 734,
"warehouse": "raw",
"updated_at": "2026-05-12T12:45:55.922",
"raw_material_id": 5
}Dopo {
"id": 13,
"quantity": 282,
"warehouse": "raw",
"updated_at": "2026-05-22T10:28:11.519",
"raw_material_id": 5
} |
| 22/05/26, 12:28:11 | Inserimento | raw_material_movements | 1609 | app interna · csv_import · consuntivo_posting · assignment:2138 | id: ∅ → 1609; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2138; +4 altri campi Dettagli before/afterDiff {
"id": {
"new": 1609,
"old": null
},
"reason": {
"new": "production_consumption",
"old": null
},
"metadata": {
"new": null,
"old": null
},
"reference": {
"new": "assignment:2138",
"old": null
},
"warehouse": {
"new": "raw",
"old": null
},
"occurred_at": {
"new": "2026-05-22T10:28:11.51",
"old": null
},
"quantity_delta": {
"new": -452,
"old": null
},
"raw_material_id": {
"new": 5,
"old": null
}
}Prima null Dopo {
"id": 1609,
"reason": "production_consumption",
"metadata": null,
"reference": "assignment:2138",
"warehouse": "raw",
"occurred_at": "2026-05-22T10:28:11.51",
"quantity_delta": -452,
"raw_material_id": 5
} |
| 22/05/26, 12:28:11 | Inserimento | plan_assignments | 2138 | — | id: ∅ → 2138; date: ∅ → 2026-05-14; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi Dettagli before/afterDiff {
"id": {
"new": 2138,
"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": 14,
"old": null
},
"operator_id": {
"new": 20,
"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": 105,
"old": null
},
"planned_quantity": {
"new": null,
"old": null
},
"produced_quantity": {
"new": 452,
"old": null
},
"setup_from_product_code_id": {
"new": null,
"old": null
}
}Prima null Dopo {
"id": 2138,
"date": "2026-05-14",
"notes": null,
"shift": "T1",
"status": "completed",
"machine_id": 14,
"operator_id": 20,
"scrap_by_type": null,
"setup_minutes": null,
"assignment_type": "production",
"product_code_id": 105,
"planned_quantity": null,
"produced_quantity": 452,
"setup_from_product_code_id": null
} |