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 #114
19 eventi mostrati · offset 100Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 12:28:13Inserimentoinventory_movements2742app interna · csv_import · consuntivo_posting · assignment:2213
id: ∅ → 2742; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2213; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2742,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2213",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.804",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 80
    },
    "old": null
  },
  "quantity_delta": {
    "new": 252,
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2742,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2213",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.804",
  "scrap_by_type": {
    "workedCasting": 80
  },
  "quantity_delta": 252,
  "product_code_id": 114
}
22/05/26, 12:28:13Modificaraw_material_balances40app interna · csv_import · consuntivo_posting · assignment:2213
quantity: 1121 → 789; updated_at: 2026-05-22T10:28:13.588 → 2026-05-22T10:28:13.799
Dettagli before/after
Diff
{
  "quantity": {
    "new": 789,
    "old": 1121
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.799",
    "old": "2026-05-22T10:28:13.588"
  }
}
Prima
{
  "id": 40,
  "quantity": 1121,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.588",
  "raw_material_id": 14
}
Dopo
{
  "id": 40,
  "quantity": 789,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.799",
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoraw_material_movements1664app interna · csv_import · consuntivo_posting · assignment:2213
id: ∅ → 1664; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"workedCasting":80}}; reference: ∅ → assignment:2213; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1664,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "workedCasting": 80
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2213",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.795",
    "old": null
  },
  "quantity_delta": {
    "new": -332,
    "old": null
  },
  "raw_material_id": {
    "new": 14,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1664,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "workedCasting": 80
    }
  },
  "reference": "assignment:2213",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:13.795",
  "quantity_delta": -332,
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoplan_assignments2213—
id: ∅ → 2213; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2213,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 31,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 80
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 252,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2213,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 31,
  "scrap_by_type": {
    "workedCasting": 80
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 252,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances937app interna · csv_import · consuntivo_posting · assignment:2205
quantity: 856 → 1149; updated_at: 2026-05-22T10:28:13.118 → 2026-05-22T10:28:13.601
Dettagli before/after
Diff
{
  "quantity": {
    "new": 1149,
    "old": 856
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.601",
    "old": "2026-05-22T10:28:13.118"
  }
}
Prima
{
  "id": 937,
  "quantity": 856,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.118",
  "product_code_id": 114
}
Dopo
{
  "id": 937,
  "quantity": 1149,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.601",
  "product_code_id": 114
}
22/05/26, 12:28:13Inserimentoinventory_movements2732app interna · csv_import · consuntivo_posting · assignment:2205
id: ∅ → 2732; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2205; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2732,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2205",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.594",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 23
    },
    "old": null
  },
  "quantity_delta": {
    "new": 293,
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2732,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2205",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.594",
  "scrap_by_type": {
    "workedCasting": 23
  },
  "quantity_delta": 293,
  "product_code_id": 114
}
22/05/26, 12:28:13Modificaraw_material_balances40app interna · csv_import · consuntivo_posting · assignment:2205
quantity: 1437 → 1121; updated_at: 2026-05-22T10:28:13.109 → 2026-05-22T10:28:13.588
Dettagli before/after
Diff
{
  "quantity": {
    "new": 1121,
    "old": 1437
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.588",
    "old": "2026-05-22T10:28:13.109"
  }
}
Prima
{
  "id": 40,
  "quantity": 1437,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.109",
  "raw_material_id": 14
}
Dopo
{
  "id": 40,
  "quantity": 1121,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.588",
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoraw_material_movements1658app interna · csv_import · consuntivo_posting · assignment:2205
id: ∅ → 1658; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"workedCasting":23}}; reference: ∅ → assignment:2205; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1658,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "workedCasting": 23
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2205",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.584",
    "old": null
  },
  "quantity_delta": {
    "new": -316,
    "old": null
  },
  "raw_material_id": {
    "new": 14,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1658,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "workedCasting": 23
    }
  },
  "reference": "assignment:2205",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:13.584",
  "quantity_delta": -316,
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoplan_assignments2205—
id: ∅ → 2205; date: ∅ → 2026-05-19; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2205,
    "old": null
  },
  "date": {
    "new": "2026-05-19",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 30,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 23
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 293,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2205,
  "date": "2026-05-19",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 30,
  "scrap_by_type": {
    "workedCasting": 23
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 293,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances937app interna · csv_import · consuntivo_posting · assignment:2193
quantity: 598 → 856; updated_at: 2026-05-22T10:28:13.021 → 2026-05-22T10:28:13.118
Dettagli before/after
Diff
{
  "quantity": {
    "new": 856,
    "old": 598
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.118",
    "old": "2026-05-22T10:28:13.021"
  }
}
Prima
{
  "id": 937,
  "quantity": 598,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.021",
  "product_code_id": 114
}
Dopo
{
  "id": 937,
  "quantity": 856,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.118",
  "product_code_id": 114
}
22/05/26, 12:28:13Inserimentoinventory_movements2717app interna · csv_import · consuntivo_posting · assignment:2193
id: ∅ → 2717; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2193; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2717,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2193",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.114",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 54
    },
    "old": null
  },
  "quantity_delta": {
    "new": 258,
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2717,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2193",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.114",
  "scrap_by_type": {
    "workedCasting": 54
  },
  "quantity_delta": 258,
  "product_code_id": 114
}
22/05/26, 12:28:13Modificaraw_material_balances40app interna · csv_import · consuntivo_posting · assignment:2193
quantity: 1749 → 1437; updated_at: 2026-05-22T10:28:13.012 → 2026-05-22T10:28:13.109
Dettagli before/after
Diff
{
  "quantity": {
    "new": 1437,
    "old": 1749
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.109",
    "old": "2026-05-22T10:28:13.012"
  }
}
Prima
{
  "id": 40,
  "quantity": 1749,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.012",
  "raw_material_id": 14
}
Dopo
{
  "id": 40,
  "quantity": 1437,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.109",
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoraw_material_movements1649app interna · csv_import · consuntivo_posting · assignment:2193
id: ∅ → 1649; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"workedCasting":54}}; reference: ∅ → assignment:2193; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1649,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "workedCasting": 54
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2193",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.106",
    "old": null
  },
  "quantity_delta": {
    "new": -312,
    "old": null
  },
  "raw_material_id": {
    "new": 14,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1649,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "workedCasting": 54
    }
  },
  "reference": "assignment:2193",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:13.106",
  "quantity_delta": -312,
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoplan_assignments2193—
id: ∅ → 2193; date: ∅ → 2026-05-19; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2193,
    "old": null
  },
  "date": {
    "new": "2026-05-19",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 31,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 54
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 258,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2193,
  "date": "2026-05-19",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 31,
  "scrap_by_type": {
    "workedCasting": 54
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 258,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances937app interna · csv_import · consuntivo_posting · assignment:2189
quantity: 313 → 598; updated_at: 2026-05-12T13:04:02.083 → 2026-05-22T10:28:13.021
Dettagli before/after
Diff
{
  "quantity": {
    "new": 598,
    "old": 313
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.021",
    "old": "2026-05-12T13:04:02.083"
  }
}
Prima
{
  "id": 937,
  "quantity": 313,
  "warehouse": "finished_real",
  "updated_at": "2026-05-12T13:04:02.083",
  "product_code_id": 114
}
Dopo
{
  "id": 937,
  "quantity": 598,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.021",
  "product_code_id": 114
}
22/05/26, 12:28:13Inserimentoinventory_movements2712app interna · csv_import · consuntivo_posting · assignment:2189
id: ∅ → 2712; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2189; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2712,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2189",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.017",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "processing": 4,
      "workedCasting": 19
    },
    "old": null
  },
  "quantity_delta": {
    "new": 285,
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2712,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2189",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.017",
  "scrap_by_type": {
    "processing": 4,
    "workedCasting": 19
  },
  "quantity_delta": 285,
  "product_code_id": 114
}
22/05/26, 12:28:13Modificaraw_material_balances40app interna · csv_import · consuntivo_posting · assignment:2189
quantity: 2057 → 1749; updated_at: 2026-05-14T09:29:49.486 → 2026-05-22T10:28:13.012
Dettagli before/after
Diff
{
  "quantity": {
    "new": 1749,
    "old": 2057
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.012",
    "old": "2026-05-14T09:29:49.486"
  }
}
Prima
{
  "id": 40,
  "quantity": 2057,
  "warehouse": "raw",
  "updated_at": "2026-05-14T09:29:49.486",
  "raw_material_id": 14
}
Dopo
{
  "id": 40,
  "quantity": 1749,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.012",
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoraw_material_movements1646app interna · csv_import · consuntivo_posting · assignment:2189
id: ∅ → 1646; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"processing":4,"workedCasting":19}}; reference: ∅ → assignment:2189; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1646,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "processing": 4,
        "workedCasting": 19
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2189",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.009",
    "old": null
  },
  "quantity_delta": {
    "new": -308,
    "old": null
  },
  "raw_material_id": {
    "new": 14,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1646,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "processing": 4,
      "workedCasting": 19
    }
  },
  "reference": "assignment:2189",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:13.009",
  "quantity_delta": -308,
  "raw_material_id": 14
}
22/05/26, 12:28:13Inserimentoplan_assignments2189—
id: ∅ → 2189; date: ∅ → 2026-05-18; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2189,
    "old": null
  },
  "date": {
    "new": "2026-05-18",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 36,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "processing": 4,
      "workedCasting": 19
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 114,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 285,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2189,
  "date": "2026-05-18",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 36,
  "scrap_by_type": {
    "processing": 4,
    "workedCasting": 19
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 114,
  "planned_quantity": null,
  "produced_quantity": 285,
  "setup_from_product_code_id": null
}
← Precedenti