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 #146
16 eventi mostrati · offset 150Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 12:28:14Inserimentoplan_assignments2240—
id: ∅ → 2240; date: ∅ → 2026-05-21; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2240,
    "old": null
  },
  "date": {
    "new": "2026-05-21",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 18,
    "old": null
  },
  "operator_id": {
    "new": 40,
    "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": 146,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 84,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2240,
  "date": "2026-05-21",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 40,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 146,
  "planned_quantity": null,
  "produced_quantity": 84,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:14Modificainventory_balances489app interna · csv_import · consuntivo_posting · assignment:2231
quantity: 128 → 211; updated_at: 2026-05-22T10:28:14.108 → 2026-05-22T10:28:14.278
Dettagli before/after
Diff
{
  "quantity": {
    "new": 211,
    "old": 128
  },
  "updated_at": {
    "new": "2026-05-22T10:28:14.278",
    "old": "2026-05-22T10:28:14.108"
  }
}
Prima
{
  "id": 489,
  "quantity": 128,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:14.108",
  "product_code_id": 146
}
Dopo
{
  "id": 489,
  "quantity": 211,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:14.278",
  "product_code_id": 146
}
22/05/26, 12:28:14Inserimentoinventory_movements2764app interna · csv_import · consuntivo_posting · assignment:2231
id: ∅ → 2764; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2231; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2764,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2231",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:14.272",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 3
    },
    "old": null
  },
  "quantity_delta": {
    "new": 83,
    "old": null
  },
  "product_code_id": {
    "new": 146,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2764,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2231",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:14.272",
  "scrap_by_type": {
    "workedCasting": 3
  },
  "quantity_delta": 83,
  "product_code_id": 146
}
22/05/26, 12:28:14Modificaraw_material_balances133app interna · csv_import · consuntivo_posting · assignment:2231
quantity: 821 → 735; updated_at: 2026-05-22T10:28:14.1 → 2026-05-22T10:28:14.265
Dettagli before/after
Diff
{
  "quantity": {
    "new": 735,
    "old": 821
  },
  "updated_at": {
    "new": "2026-05-22T10:28:14.265",
    "old": "2026-05-22T10:28:14.1"
  }
}
Prima
{
  "id": 133,
  "quantity": 821,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:14.1",
  "raw_material_id": 45
}
Dopo
{
  "id": 133,
  "quantity": 735,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:14.265",
  "raw_material_id": 45
}
22/05/26, 12:28:14Inserimentoraw_material_movements1678app interna · csv_import · consuntivo_posting · assignment:2231
id: ∅ → 1678; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"workedCasting":3}}; reference: ∅ → assignment:2231; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1678,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "workedCasting": 3
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2231",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:14.26",
    "old": null
  },
  "quantity_delta": {
    "new": -86,
    "old": null
  },
  "raw_material_id": {
    "new": 45,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1678,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "workedCasting": 3
    }
  },
  "reference": "assignment:2231",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:14.26",
  "quantity_delta": -86,
  "raw_material_id": 45
}
22/05/26, 12:28:14Inserimentoplan_assignments2231—
id: ∅ → 2231; date: ∅ → 2026-05-21; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2231,
    "old": null
  },
  "date": {
    "new": "2026-05-21",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": 18,
    "old": null
  },
  "operator_id": {
    "new": 22,
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 3
    },
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "product_code_id": {
    "new": 146,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 83,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2231,
  "date": "2026-05-21",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 22,
  "scrap_by_type": {
    "workedCasting": 3
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 146,
  "planned_quantity": null,
  "produced_quantity": 83,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:14Modificainventory_balances489app interna · csv_import · consuntivo_posting · assignment:2225
quantity: 48 → 128; updated_at: 2026-05-22T10:28:13.661 → 2026-05-22T10:28:14.108
Dettagli before/after
Diff
{
  "quantity": {
    "new": 128,
    "old": 48
  },
  "updated_at": {
    "new": "2026-05-22T10:28:14.108",
    "old": "2026-05-22T10:28:13.661"
  }
}
Prima
{
  "id": 489,
  "quantity": 48,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.661",
  "product_code_id": 146
}
Dopo
{
  "id": 489,
  "quantity": 128,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:14.108",
  "product_code_id": 146
}
22/05/26, 12:28:14Inserimentoinventory_movements2758app interna · csv_import · consuntivo_posting · assignment:2225
id: ∅ → 2758; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2225; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2758,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2225",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:14.105",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": 80,
    "old": null
  },
  "product_code_id": {
    "new": 146,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2758,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2225",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:14.105",
  "scrap_by_type": null,
  "quantity_delta": 80,
  "product_code_id": 146
}
22/05/26, 12:28:14Modificaraw_material_balances133app interna · csv_import · consuntivo_posting · assignment:2225
quantity: 901 → 821; updated_at: 2026-05-22T10:28:13.648 → 2026-05-22T10:28:14.1
Dettagli before/after
Diff
{
  "quantity": {
    "new": 821,
    "old": 901
  },
  "updated_at": {
    "new": "2026-05-22T10:28:14.1",
    "old": "2026-05-22T10:28:13.648"
  }
}
Prima
{
  "id": 133,
  "quantity": 901,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.648",
  "raw_material_id": 45
}
Dopo
{
  "id": 133,
  "quantity": 821,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:14.1",
  "raw_material_id": 45
}
22/05/26, 12:28:14Inserimentoraw_material_movements1672app interna · csv_import · consuntivo_posting · assignment:2225
id: ∅ → 1672; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2225; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1672,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2225",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:14.097",
    "old": null
  },
  "quantity_delta": {
    "new": -80,
    "old": null
  },
  "raw_material_id": {
    "new": 45,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1672,
  "reason": "production_consumption",
  "metadata": null,
  "reference": "assignment:2225",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:14.097",
  "quantity_delta": -80,
  "raw_material_id": 45
}
22/05/26, 12:28:14Inserimentoplan_assignments2225—
id: ∅ → 2225; date: ∅ → 2026-05-20; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2225,
    "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": 18,
    "old": null
  },
  "operator_id": {
    "new": 40,
    "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": 146,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 80,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2225,
  "date": "2026-05-20",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 40,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 146,
  "planned_quantity": null,
  "produced_quantity": 80,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:13Modificainventory_balances489app interna · csv_import · consuntivo_posting · assignment:2207
quantity: 13 → 48; updated_at: 2026-05-12T13:47:23.056 → 2026-05-22T10:28:13.661
Dettagli before/after
Diff
{
  "quantity": {
    "new": 48,
    "old": 13
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.661",
    "old": "2026-05-12T13:47:23.056"
  }
}
Prima
{
  "id": 489,
  "quantity": 13,
  "warehouse": "finished_real",
  "updated_at": "2026-05-12T13:47:23.056",
  "product_code_id": 146
}
Dopo
{
  "id": 489,
  "quantity": 48,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:13.661",
  "product_code_id": 146
}
22/05/26, 12:28:13Inserimentoinventory_movements2734app interna · csv_import · consuntivo_posting · assignment:2207
id: ∅ → 2734; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2207; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2734,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2207",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.655",
    "old": null
  },
  "scrap_by_type": {
    "new": {
      "workedCasting": 1
    },
    "old": null
  },
  "quantity_delta": {
    "new": 35,
    "old": null
  },
  "product_code_id": {
    "new": 146,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2734,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2207",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:13.655",
  "scrap_by_type": {
    "workedCasting": 1
  },
  "quantity_delta": 35,
  "product_code_id": 146
}
22/05/26, 12:28:13Modificaraw_material_balances133app interna · csv_import · consuntivo_posting · assignment:2207
quantity: 937 → 901; updated_at: 2026-05-12T13:47:07.574 → 2026-05-22T10:28:13.648
Dettagli before/after
Diff
{
  "quantity": {
    "new": 901,
    "old": 937
  },
  "updated_at": {
    "new": "2026-05-22T10:28:13.648",
    "old": "2026-05-12T13:47:07.574"
  }
}
Prima
{
  "id": 133,
  "quantity": 937,
  "warehouse": "raw",
  "updated_at": "2026-05-12T13:47:07.574",
  "raw_material_id": 45
}
Dopo
{
  "id": 133,
  "quantity": 901,
  "warehouse": "raw",
  "updated_at": "2026-05-22T10:28:13.648",
  "raw_material_id": 45
}
22/05/26, 12:28:13Inserimentoraw_material_movements1660app interna · csv_import · consuntivo_posting · assignment:2207
id: ∅ → 1660; reason: ∅ → production_consumption; metadata: ∅ → {"scrapByType":{"workedCasting":1}}; reference: ∅ → assignment:2207; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 1660,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": {
      "scrapByType": {
        "workedCasting": 1
      }
    },
    "old": null
  },
  "reference": {
    "new": "assignment:2207",
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:13.644",
    "old": null
  },
  "quantity_delta": {
    "new": -36,
    "old": null
  },
  "raw_material_id": {
    "new": 45,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 1660,
  "reason": "production_consumption",
  "metadata": {
    "scrapByType": {
      "workedCasting": 1
    }
  },
  "reference": "assignment:2207",
  "warehouse": "raw",
  "occurred_at": "2026-05-22T10:28:13.644",
  "quantity_delta": -36,
  "raw_material_id": 45
}
22/05/26, 12:28:13Inserimentoplan_assignments2207—
id: ∅ → 2207; date: ∅ → 2026-05-19; notes: ∅ → ∅; shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2207,
    "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": 18,
    "old": null
  },
  "operator_id": {
    "new": 27,
    "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": 146,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 35,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2207,
  "date": "2026-05-19",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": 18,
  "operator_id": 27,
  "scrap_by_type": {
    "workedCasting": 1
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 146,
  "planned_quantity": null,
  "produced_quantity": 35,
  "setup_from_product_code_id": null
}
← Precedenti