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 #139
17 eventi mostrati · offset 50Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 12:28:13Inserimentoplan_assignments2218—
id: ∅ → 2218; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2218,
    "old": null
  },
  "date": {
    "new": "2026-05-20",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 15,
    "old": null
  },
  "operator_id": {
    "new": 36,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 1
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 81,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2218,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 36,
  "scrap_by_type": {
    "workedCasting": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 81,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances202app interna · csv_import · consuntivo_posting · assignment:2214
quantity: 347 → 543; updated_at: 2026-05-22T10:28:13.563 → 2026-05-22T10:28:13.836
Dettagli before/after
Diff
{
  "quantity": {
    "new": 543,
    "old": 347
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.836",
    "old": "2026-05-22T10:28:13.563"
  }
}
Prima
{
  "id": 202,
  "quantity": 347,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.563",
  "product_code_id": 139
}
Dopo
{
  "id": 202,
  "quantity": 543,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.836",
  "product_code_id": 139
}
22/05/26, 12:28:13Inserimentoinventory_movements2743app interna · csv_import · consuntivo_posting · assignment:2214
id: ∅ → 2743; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2214; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2743,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2214",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.832",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": 196,
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2743,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2214",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.832",
  "scrap_by_type": null,
  "quantity_delta": 196,
  "product_code_id": 139
}
22/05/26, 12:28:13Modificaraw_material_balances113app interna · csv_import · consuntivo_posting · assignment:2214
quantity: -233 → -429; updated_at: 2026-05-22T10:28:13.554 → 2026-05-22T10:28:13.827
Dettagli before/after
Diff
{
  "quantity": {
    "new": -429,
    "old": -233
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.827",
    "old": "2026-05-22T10:28:13.554"
  }
}
Prima
{
  "id": 113,
  "quantity": -233,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-22T10:28:13.554",
  "raw_material_id": 38
}
Dopo
{
  "id": 113,
  "quantity": -429,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-22T10:28:13.827",
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoraw_material_movements1665app interna · csv_import · consuntivo_posting · assignment:2214
id: ∅ → 1665; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2214; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1665,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2214",
    "old": null
  },
  "warehouse": {
    "new": "raw_treated",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.823",
    "old": null
  },
  "quantity_delta": {
    "new": -196,
    "old": null
  },
  "raw_material_id": {
    "new": 38,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1665,
  "reason": "production_consumption",
  "metadata": null,
  "reference": "assignment:2214",
  "warehouse": "raw_treated",
  "occurred_at": "2026-05-22T10:28:13.823",
  "quantity_delta": -196,
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoplan_assignments2214—
id: ∅ → 2214; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2214,
    "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": 15,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "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": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 196,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2214,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 196,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances202app interna · csv_import · consuntivo_posting · assignment:2204
quantity: 171 → 347; updated_at: 2026-05-22T10:28:13.304 → 2026-05-22T10:28:13.563
Dettagli before/after
Diff
{
  "quantity": {
    "new": 347,
    "old": 171
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.563",
    "old": "2026-05-22T10:28:13.304"
  }
}
Prima
{
  "id": 202,
  "quantity": 171,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.304",
  "product_code_id": 139
}
Dopo
{
  "id": 202,
  "quantity": 347,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.563",
  "product_code_id": 139
}
22/05/26, 12:28:13Inserimentoinventory_movements2731app interna · csv_import · consuntivo_posting · assignment:2204
id: ∅ → 2731; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2204; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2731,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2204",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.559",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "raw": 1,
      "processing": 1,
      "workedCasting": 2
    },
    "old": null
  },
  "quantity_delta": {
    "new": 176,
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2731,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2204",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.559",
  "scrap_by_type": {
    "raw": 1,
    "processing": 1,
    "workedCasting": 2
  },
  "quantity_delta": 176,
  "product_code_id": 139
}
22/05/26, 12:28:13Modificaraw_material_balances113app interna · csv_import · consuntivo_posting · assignment:2204
quantity: -53 → -233; updated_at: 2026-05-22T10:28:13.291 → 2026-05-22T10:28:13.554
Dettagli before/after
Diff
{
  "quantity": {
    "new": -233,
    "old": -53
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.554",
    "old": "2026-05-22T10:28:13.291"
  }
}
Prima
{
  "id": 113,
  "quantity": -53,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-22T10:28:13.291",
  "raw_material_id": 38
}
Dopo
{
  "id": 113,
  "quantity": -233,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-22T10:28:13.554",
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoraw_material_movements1657app interna · csv_import · consuntivo_posting · assignment:2204
id: ∅ → 1657; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"raw":1,"processing":1,"workedCasting":2}}; reference: ∅ → assignment:2204; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1657,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "raw": 1,
        "processing": 1,
        "workedCasting": 2
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2204",
    "old": null
  },
  "warehouse": {
    "new": "raw_treated",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.55",
    "old": null
  },
  "quantity_delta": {
    "new": -180,
    "old": null
  },
  "raw_material_id": {
    "new": 38,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1657,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "raw": 1,
      "processing": 1,
      "workedCasting": 2
    }
  },
  "reference": "assignment:2204",
  "warehouse": "raw_treated",
  "occurred_at": "2026-05-22T10:28:13.55",
  "quantity_delta": -180,
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoplan_assignments2204—
id: ∅ → 2204; date: ∅ → 2026-05-19; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2204,
    "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": 15,
    "old": null
  },
  "operator_id": {
    "new": 36,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "raw": 1,
      "processing": 1,
      "workedCasting": 2
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 176,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2204,
  "date": "2026-05-19",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 36,
  "scrap_by_type": {
    "raw": 1,
    "processing": 1,
    "workedCasting": 2
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 176,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances202app interna · csv_import · consuntivo_posting · assignment:2198
quantity: 12 → 171; updated_at: 2026-05-12T13:40:44.104 → 2026-05-22T10:28:13.304
Dettagli before/after
Diff
{
  "quantity": {
    "new": 171,
    "old": 12
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.304",
    "old": "2026-05-12T13:40:44.104"
  }
}
Prima
{
  "id": 202,
  "quantity": 12,
  "warehouse": "finished_real",
  "updated_at": "2026-05-12T13:40:44.104",
  "product_code_id": 139
}
Dopo
{
  "id": 202,
  "quantity": 171,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.304",
  "product_code_id": 139
}
22/05/26, 12:28:13Inserimentoinventory_movements2723app interna · csv_import · consuntivo_posting · assignment:2198
id: ∅ → 2723; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2198; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2723,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2198",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.3",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "processing": 2,
      "workedCasting": 7
    },
    "old": null
  },
  "quantity_delta": {
    "new": 159,
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2723,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2198",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.3",
  "scrap_by_type": {
    "processing": 2,
    "workedCasting": 7
  },
  "quantity_delta": 159,
  "product_code_id": 139
}
22/05/26, 12:28:13Modificaraw_material_balances113app interna · csv_import · consuntivo_posting · assignment:2198
quantity: 115 → -53; updated_at: 2026-05-12T13:40:19.033 → 2026-05-22T10:28:13.291
Dettagli before/after
Diff
{
  "quantity": {
    "new": -53,
    "old": 115
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.291",
    "old": "2026-05-12T13:40:19.033"
  }
}
Prima
{
  "id": 113,
  "quantity": 115,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-12T13:40:19.033",
  "raw_material_id": 38
}
Dopo
{
  "id": 113,
  "quantity": -53,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-22T10:28:13.291",
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoraw_material_movements1653app interna · csv_import · consuntivo_posting · assignment:2198
id: ∅ → 1653; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"processing":2,"workedCasting":7}}; reference: ∅ → assignment:2198; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1653,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "processing": 2,
        "workedCasting": 7
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2198",
    "old": null
  },
  "warehouse": {
    "new": "raw_treated",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.284",
    "old": null
  },
  "quantity_delta": {
    "new": -168,
    "old": null
  },
  "raw_material_id": {
    "new": 38,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1653,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "processing": 2,
      "workedCasting": 7
    }
  },
  "reference": "assignment:2198",
  "warehouse": "raw_treated",
  "occurred_at": "2026-05-22T10:28:13.284",
  "quantity_delta": -168,
  "raw_material_id": 38
}
22/05/26, 12:28:13Inserimentoplan_assignments2198—
id: ∅ → 2198; date: ∅ → 2026-05-19; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2198,
    "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": 15,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "processing": 2,
      "workedCasting": 7
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 139,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 159,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2198,
  "date": "2026-05-19",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 28,
  "scrap_by_type": {
    "processing": 2,
    "workedCasting": 7
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 139,
  "planned_quantity": null,
  "produced_quantity": 159,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:11Inserimentoplan_assignments2150—
id: ∅ → 2150; date: ∅ → 2026-05-14; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2150,
    "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": 19,
    "old": null
  },
  "operator_id": {
    "new": 37,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 2
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 134,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 139,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2150,
  "date": "2026-05-14",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 19,
  "operator_id": 37,
  "scrap_by_type": {
    "workedCasting": 2
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 134,
  "planned_quantity": null,
  "produced_quantity": 139,
  "setup_from_product_code_id": null
}
← Precedenti