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 #199
17 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
29/05/26, 11:28:30Inserimentoorders502app interna · app · order_create · product:199
id: ∅ → 502; status: ∅ → confirmed; customer: ∅ → DYNACAST; quantity: ∅ → 398; +4 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 502,
    "old": null
  },
  "status": {
    "new": "confirmed",
    "old": null
  },
  "customer": {
    "new": "DYNACAST",
    "old": null
  },
  "quantity": {
    "new": 398,
    "old": null
  },
  "delivery_date": {
    "new": "2026-05-29",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  },
  "current_stage_id": {
    "new": 1,
    "old": null
  },
  "produced_quantity": {
    "new": 0,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 502,
  "status": "confirmed",
  "customer": "DYNACAST",
  "quantity": 398,
  "delivery_date": "2026-05-29",
  "product_code_id": 199,
  "current_stage_id": 1,
  "produced_quantity": 0
}
29/05/26, 08:35:39Modificaproduct_codes199app interna · app · product_code_update · product_code:199
code: 00330455 → 00330455_T
Dettagli before/after
Diff
{
  "code": {
    "new": "00330455_T",
    "old": "00330455"
  }
}
Prima
{
  "id": 199,
  "code": "00330455",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0455",
  "short_label": null,
  "raw_material_id": 79,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": null,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 199,
  "code": "00330455_T",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0455",
  "short_label": null,
  "raw_material_id": 79,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": null,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
29/05/26, 08:34:40Modificaproduct_codes199app interna · app · product_code_update · product_code:199
code: 00330452 → 00330455; description: CORPO 0452 → CORPO 0455
Dettagli before/after
Diff
{
  "code": {
    "new": "00330455",
    "old": "00330452"
  },
  "description": {
    "new": "CORPO 0455",
    "old": "CORPO 0452"
  }
}
Prima
{
  "id": 199,
  "code": "00330452",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0452",
  "short_label": null,
  "raw_material_id": 79,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": null,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
Dopo
{
  "id": 199,
  "code": "00330455",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0455",
  "short_label": null,
  "raw_material_id": 79,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": null,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}
28/05/26, 09:30:55Cancellazioneplan_assignments3791—
id: 3791 → ∅; date: 2026-05-26 → ∅; notes: Auto-generato (Ordine #254) → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 3791
  },
  "date": {
    "new": null,
    "old": "2026-05-26"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #254)"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 24
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 99
  },
  "planned_quantity": {
    "new": null,
    "old": 199
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 3791,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
27/05/26, 15:01:39Inserimentoplan_assignments3791app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 3791; date: ∅ → 2026-05-26; notes: ∅ → Auto-generato (Ordine #254); shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 3791,
    "old": null
  },
  "date": {
    "new": "2026-05-26",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #254)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 24,
    "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": 99,
    "old": null
  },
  "planned_quantity": {
    "new": 199,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 3791,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 15:01:39Cancellazioneplan_assignments3676app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: 3676 → ∅; date: 2026-05-26 → ∅; notes: Auto-generato (Ordine #254) → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 3676
  },
  "date": {
    "new": null,
    "old": "2026-05-26"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #254)"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 24
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 99
  },
  "planned_quantity": {
    "new": null,
    "old": 199
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 3676,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
27/05/26, 14:54:54Inserimentoplan_assignments3676app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 3676; date: ∅ → 2026-05-26; notes: ∅ → Auto-generato (Ordine #254); shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 3676,
    "old": null
  },
  "date": {
    "new": "2026-05-26",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #254)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 24,
    "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": 99,
    "old": null
  },
  "planned_quantity": {
    "new": 199,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 3676,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 14:54:54Cancellazioneplan_assignments3560app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: 3560 → ∅; date: 2026-05-26 → ∅; notes: Auto-generato (Ordine #254) → ∅; shift: T2 → ∅; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": null,
    "old": 3560
  },
  "date": {
    "new": null,
    "old": "2026-05-26"
  },
  "notes": {
    "new": null,
    "old": "Auto-generato (Ordine #254)"
  },
  "shift": {
    "new": null,
    "old": "T2"
  },
  "status": {
    "new": null,
    "old": "planned"
  },
  "machine_id": {
    "new": null,
    "old": 14
  },
  "operator_id": {
    "new": null,
    "old": 24
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": null,
    "old": "production"
  },
  "product_code_id": {
    "new": null,
    "old": 99
  },
  "planned_quantity": {
    "new": null,
    "old": 199
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
{
  "id": 3560,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
Dopo
null
27/05/26, 14:40:37Inserimentoplan_assignments3560app interna · app · magic_plan_confirm · magic_plan:2026-05-25:2026-05-29
id: ∅ → 3560; date: ∅ → 2026-05-26; notes: ∅ → Auto-generato (Ordine #254); shift: ∅ → T2; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 3560,
    "old": null
  },
  "date": {
    "new": "2026-05-26",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #254)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 14,
    "old": null
  },
  "operator_id": {
    "new": 24,
    "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": 99,
    "old": null
  },
  "planned_quantity": {
    "new": 199,
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 3560,
  "date": "2026-05-26",
  "notes": "Auto-generato (Ordine #254)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 14,
  "operator_id": 24,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 99,
  "planned_quantity": 199,
  "produced_quantity": null,
  "setup_from_product_code_id": null
}
27/05/26, 11:27:33Inserimentoinventory_balances15531—
id: ∅ → 15531; quantity: ∅ → 0; warehouse: ∅ → finished_planned; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15531,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "finished_planned",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15531,
  "quantity": 0,
  "warehouse": "finished_planned",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15530—
id: ∅ → 15530; quantity: ∅ → 0; warehouse: ∅ → finished_real; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15530,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15530,
  "quantity": 0,
  "warehouse": "finished_real",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15529—
id: ∅ → 15529; quantity: ∅ → 0; warehouse: ∅ → semi_finished_treated; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15529,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "semi_finished_treated",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15529,
  "quantity": 0,
  "warehouse": "semi_finished_treated",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15528—
id: ∅ → 15528; quantity: ∅ → 0; warehouse: ∅ → semi_finished; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15528,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "semi_finished",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15528,
  "quantity": 0,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15527—
id: ∅ → 15527; quantity: ∅ → 0; warehouse: ∅ → at_external_treatment; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15527,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "at_external_treatment",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15527,
  "quantity": 0,
  "warehouse": "at_external_treatment",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15526—
id: ∅ → 15526; quantity: ∅ → 0; warehouse: ∅ → raw_treated; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15526,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "raw_treated",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15526,
  "quantity": 0,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoinventory_balances15525—
id: ∅ → 15525; quantity: ∅ → 0; warehouse: ∅ → raw; updated_at: ∅ → 2026-05-27T09:27:33.762337; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15525,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-27T09:27:33.762337",
    "old": null
  },
  "product_code_id": {
    "new": 199,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15525,
  "quantity": 0,
  "warehouse": "raw",
  "updated_at": "2026-05-27T09:27:33.762337",
  "product_code_id": 199
}
27/05/26, 11:27:33Inserimentoproduct_codes199app interna · app · product_code_create · product_code:00330452
id: ∅ → 199; code: ∅ → 00330452; notes: ∅ → ∅; active: ∅ → true; +12 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 199,
    "old": null
  },
  "code": {
    "new": "00330452",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "active": {
    "new": true,
    "old": null
  },
  "customer": {
    "new": "DYNACAST",
    "old": null
  },
  "flow_type": {
    "new": "direct",
    "old": null
  },
  "description": {
    "new": "CORPO 0452",
    "old": null
  },
  "short_label": {
    "new": null,
    "old": null
  },
  "raw_material_id": {
    "new": 79,
    "old": null
  },
  "packaging_quantity": {
    "new": 1,
    "old": null
  },
  "production_flow_id": {
    "new": 1,
    "old": null
  },
  "assembly_throughput": {
    "new": null,
    "old": null
  },
  "throughput_per_shift": {
    "new": null,
    "old": null
  },
  "external_treatment_status": {
    "new": "none",
    "old": null
  },
  "inventory_source_warehouse": {
    "new": null,
    "old": null
  },
  "inventory_destination_warehouse": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 199,
  "code": "00330452",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0452",
  "short_label": null,
  "raw_material_id": 79,
  "packaging_quantity": 1,
  "production_flow_id": 1,
  "assembly_throughput": null,
  "throughput_per_shift": null,
  "external_treatment_status": "none",
  "inventory_source_warehouse": null,
  "inventory_destination_warehouse": null
}