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 #121
7 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
18/06/26, 13:53:26Cancellazioneplan_assignments4642app interna · app · magic_plan_confirm · magic_plan:2026-06-15:2026-06-19
id: 4642 → ∅; date: 2026-06-15 → ∅; notes: Auto-generato (Ordine #410) → ∅; shift: T1 → ∅; +14 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 4642
  },
  "date": {
    "new": null,
    "old": "2026-06-15"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #410)"
  },
  "shift": {
    "new": null,
    "old": "T1"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 17
  },
  "operator_id": {
    "new": null,
    "old": 22
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "planned_minutes": {
    "new": null,
    "old": null
  },
  "product_code_id": {
    "new": null,
    "old": 135
  },
  "capacity_minutes": {
    "new": null,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": 121
  },
  "order_allocations": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "residual_capacity_minutes": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 4642,
  "date": "2026-06-15",
  "notes": "Auto-generato (Ordine #410)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 17,
  "operator_id": 22,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "planned_minutes": null,
  "product_code_id": 135,
  "capacity_minutes": null,
  "planned_quantity": 121,
  "order_allocations": null,
  "produced_quantity": null,
  "residual_capacity_minutes": null,
  "setup_from_product_code_id": null
}
Dopo
null
15/06/26, 12:08:20Inserimentoplan_assignments4642app interna · app · magic_plan_confirm · magic_plan:2026-06-15:2026-06-19
id: ∅ → 4642; date: ∅ → 2026-06-15; notes: ∅ → Auto-generato (Ordine #410); shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4642,
    "old": null
  },
  "date": {
    "new": "2026-06-15",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #410)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 17,
    "old": null
  },
  "operator_id": {
    "new": 22,
    "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": 135,
    "old": null
  },
  "planned_quantity": {
    "new": 121,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4642,
  "date": "2026-06-15",
  "notes": "Auto-generato (Ordine #410)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 17,
  "operator_id": 22,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 135,
  "planned_quantity": 121,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 12:44:59Modificaproduct_codes121—
throughput_per_shift: 63 → 473
Dettagli before/after
Diff
{
  "throughput_per_shift": {
    "new": 473,
    "old": 63
  }
}
Prima
{
  "id": 121,
  "code": "SCA2099772",
  "notes": null,
  "active": true,
  "customer": "SCANIA",
  "flow_type": "direct",
  "description": "BRACKET SCANIA 772",
  "short_label": null,
  "raw_material_id": 20,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 63,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 121,
  "code": "SCA2099772",
  "notes": null,
  "active": true,
  "customer": "SCANIA",
  "flow_type": "direct",
  "description": "BRACKET SCANIA 772",
  "short_label": null,
  "raw_material_id": 20,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": 473,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
22/05/26, 14:55:36Cancellazioneplan_assignments1623—
id: 1623 → ∅; date: 2026-04-07 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2241 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 1623
  },
  "date": {
    "new": null,
    "old": "2026-04-07"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2241"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": null,
    "old": 26
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "assembly"
  },
  "product_code_id": {
    "new": null,
    "old": 104
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 121
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 1623,
  "date": "2026-04-07",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2241",
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 26,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 104,
  "planned_quantity": null,
  "produced_quantity": 121,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 14:55:08Cancellazioneplan_assignments2074—
id: 2074 → ∅; date: 2026-05-08 → ∅; notes: Import storico consuntivo 2026 - riga Google Form #2935 → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 2074
  },
  "date": {
    "new": null,
    "old": "2026-05-08"
  },
  "notes": {
    "new": null,
    "old": "Import storico consuntivo 2026 - riga Google Form #2935"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "completed"
  },
  "machine_id": {
    "new": null,
    "old": 25
  },
  "operator_id": {
    "new": null,
    "old": 36
  },
  "scrap_by_type": {
    "new": null,
    "old": {
      "workedCasting": 3
    }
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 113
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": 121
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 2074,
  "date": "2026-05-08",
  "notes": "Import storico consuntivo 2026 - riga Google Form #2935",
  "shift": "T2",
  "status": "completed",
  "machine_id": 25,
  "operator_id": 36,
  "scrap_by_type": {
    "workedCasting": 3
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 113,
  "planned_quantity": null,
  "produced_quantity": 121,
  "setup_from_product_code_id": null
}
Dopo
null
22/05/26, 13:02:56Modificainventory_balances14314app interna · app · inventory_manual_adjustment · product:121:finishedReal
quantity: 144 → 132; updated_at: 2026-05-12T13:13:02.227315 → 2026-05-22T11:02:56.672
Dettagli before/after
Diff
{
  "quantity": {
    "new": 132,
    "old": 144
  },
  "updated_at": {
    "new": "2026-05-22T11:02:56.672",
    "old": "2026-05-12T13:13:02.227315"
  }
}
Prima
{
  "id": 14314,
  "quantity": 144,
  "warehouse": "finished_real",
  "updated_at": "2026-05-12T13:13:02.227315",
  "product_code_id": 121
}
Dopo
{
  "id": 14314,
  "quantity": 132,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T11:02:56.672",
  "product_code_id": 121
}
22/05/26, 13:02:56Inserimentoinventory_movements2794app interna · app · inventory_manual_adjustment · product:121:finishedReal
id: ∅ → 2794; reason: ∅ → manual_adjustment; metadata: ∅ → {"note":null,"warehouse":"finished_real","targetValue":132}; reference: ∅ → manual:finished_real; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2794,
    "old": null
  },
  "reason": {
    "new": "manual_adjustment",
    "old": null
  },
  "metadata": {
    "new": {
      "note": null,
      "warehouse": "finished_real",
      "targetValue": 132
    },
    "old": null
  },
  "reference": {
    "new": "manual:finished_real",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-21T09:02:00",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": -12,
    "old": null
  },
  "product_code_id": {
    "new": 121,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2794,
  "reason": "manual_adjustment",
  "metadata": {
    "note": null,
    "warehouse": "finished_real",
    "targetValue": 132
  },
  "reference": "manual:finished_real",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-21T09:02:00",
  "scrap_by_type": null,
  "quantity_delta": -12,
  "product_code_id": 121
}