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 #101
13 eventi mostrati · offset 300Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
22/05/26, 14:24:46Modificaorders72app interna · app · order_bulk_status_update · orders:17,16,19,20,15,18,45,46,49,51,50,48,52,53,54,61,62,63,65,66,69,70,59,58,57,56,64,43,67,55,68,60,77,73,75,76,72,74,79,78,80,83,81,87,85,84,86,82,93,92,91,90,89,88,95,98,99,101,100,96,94,108,113,107,114,106,105,104,103,102,112,111,110,109,141,136,139,116,115,120,97,119,118,117,221,121,122,140,206,222,214,193,123,124,215,194,223,207,200,130,131,132,133,134,135,195,224,201,208,137,138,142,126,127,128,129,144,143,196,145,146,147,148,149,150,151,152,153,154,155,156,157,158,202,209,216,225,159,160,161,162,226,203,217,210,197,163,211,227,204,218,198,219,199,205,212,228,164,220,165,177,166,178,167,168,179,229,213,180,169,181,170,171,182,183,172,184,173,185,174,186,175,176,187
status: confirmed → obsolete
Dettagli before/after
Diff
{
  "status": {
    "new": "obsolete",
    "old": "confirmed"
  }
}
Prima
{
  "id": 72,
  "status": "confirmed",
  "customer": "MAN",
  "quantity": 80,
  "delivery_date": "2026-05-22",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 72,
  "status": "obsolete",
  "customer": "MAN",
  "quantity": 80,
  "delivery_date": "2026-05-22",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:24:46Modificaorders46app interna · app · order_bulk_status_update · orders:17,16,19,20,15,18,45,46,49,51,50,48,52,53,54,61,62,63,65,66,69,70,59,58,57,56,64,43,67,55,68,60,77,73,75,76,72,74,79,78,80,83,81,87,85,84,86,82,93,92,91,90,89,88,95,98,99,101,100,96,94,108,113,107,114,106,105,104,103,102,112,111,110,109,141,136,139,116,115,120,97,119,118,117,221,121,122,140,206,222,214,193,123,124,215,194,223,207,200,130,131,132,133,134,135,195,224,201,208,137,138,142,126,127,128,129,144,143,196,145,146,147,148,149,150,151,152,153,154,155,156,157,158,202,209,216,225,159,160,161,162,226,203,217,210,197,163,211,227,204,218,198,219,199,205,212,228,164,220,165,177,166,178,167,168,179,229,213,180,169,181,170,171,182,183,172,184,173,185,174,186,175,176,187
status: confirmed → obsolete
Dettagli before/after
Diff
{
  "status": {
    "new": "obsolete",
    "old": "confirmed"
  }
}
Prima
{
  "id": 46,
  "status": "confirmed",
  "customer": "MAN",
  "quantity": 160,
  "delivery_date": "2026-05-18",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 46,
  "status": "obsolete",
  "customer": "MAN",
  "quantity": 160,
  "delivery_date": "2026-05-18",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 14:24:46Modificaorders81app interna · app · order_bulk_status_update · orders:17,16,19,20,15,18,45,46,49,51,50,48,52,53,54,61,62,63,65,66,69,70,59,58,57,56,64,43,67,55,68,60,77,73,75,76,72,74,79,78,80,83,81,87,85,84,86,82,93,92,91,90,89,88,95,98,99,101,100,96,94,108,113,107,114,106,105,104,103,102,112,111,110,109,141,136,139,116,115,120,97,119,118,117,221,121,122,140,206,222,214,193,123,124,215,194,223,207,200,130,131,132,133,134,135,195,224,201,208,137,138,142,126,127,128,129,144,143,196,145,146,147,148,149,150,151,152,153,154,155,156,157,158,202,209,216,225,159,160,161,162,226,203,217,210,197,163,211,227,204,218,198,219,199,205,212,228,164,220,165,177,166,178,167,168,179,229,213,180,169,181,170,171,182,183,172,184,173,185,174,186,175,176,187
status: confirmed → obsolete
Dettagli before/after
Diff
{
  "status": {
    "new": "obsolete",
    "old": "confirmed"
  }
}
Prima
{
  "id": 81,
  "status": "confirmed",
  "customer": "MAN",
  "quantity": 80,
  "delivery_date": "2026-05-27",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
Dopo
{
  "id": 81,
  "status": "obsolete",
  "customer": "MAN",
  "quantity": 80,
  "delivery_date": "2026-05-27",
  "product_code_id": 101,
  "current_stage_id": null,
  "produced_quantity": 0
}
22/05/26, 13:48:05Modificainventory_balances720app interna · app · inventory_manual_adjustment · product:101:finishedReal
quantity: 240 → 80; updated_at: 2026-05-22T10:28:11.558 → 2026-05-22T11:48:05.241
Dettagli before/after
Diff
{
  "quantity": {
    "new": 80,
    "old": 240
  },
  "updated_at": {
    "new": "2026-05-22T11:48:05.241",
    "old": "2026-05-22T10:28:11.558"
  }
}
Prima
{
  "id": 720,
  "quantity": 240,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:11.558",
  "product_code_id": 101
}
Dopo
{
  "id": 720,
  "quantity": 80,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T11:48:05.241",
  "product_code_id": 101
}
22/05/26, 13:48:05Inserimentoinventory_movements2825app interna · app · inventory_manual_adjustment · product:101:finishedReal
id: ∅ → 2825; reason: ∅ → manual_adjustment; metadata: ∅ → {"note":null,"warehouse":"finished_real","targetValue":80}; reference: ∅ → manual:finished_real; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2825,
    "old": null
  },
  "reason": {
    "new": "manual_adjustment",
    "old": null
  },
  "metadata": {
    "new": {
      "note": null,
      "warehouse": "finished_real",
      "targetValue": 80
    },
    "old": null
  },
  "reference": {
    "new": "manual:finished_real",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-18T09:47:00",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": -160,
    "old": null
  },
  "product_code_id": {
    "new": 101,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2825,
  "reason": "manual_adjustment",
  "metadata": {
    "note": null,
    "warehouse": "finished_real",
    "targetValue": 80
  },
  "reference": "manual:finished_real",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-18T09:47:00",
  "scrap_by_type": null,
  "quantity_delta": -160,
  "product_code_id": 101
}
22/05/26, 12:28:14Inserimentoplan_assignments2235—
id: ∅ → 2235; date: ∅ → 2026-05-21; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2235,
    "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": 19,
    "old": null
  },
  "operator_id": {
    "new": 28,
    "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": 137,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 101,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2235,
  "date": "2026-05-21",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 19,
  "operator_id": 28,
  "scrap_by_type": {
    "workedCasting": 2
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 137,
  "planned_quantity": null,
  "produced_quantity": 101,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:11Modificainventory_balances720app interna · csv_import · consuntivo_posting · assignment:2139
quantity: 194 → 240; updated_at: 2026-05-14T11:21:16.184 → 2026-05-22T10:28:11.558
Dettagli before/after
Diff
{
  "quantity": {
    "new": 240,
    "old": 194
  },
  "updated_at": {
    "new": "2026-05-22T10:28:11.558",
    "old": "2026-05-14T11:21:16.184"
  }
}
Prima
{
  "id": 720,
  "quantity": 194,
  "warehouse": "finished_real",
  "updated_at": "2026-05-14T11:21:16.184",
  "product_code_id": 101
}
Dopo
{
  "id": 720,
  "quantity": 240,
  "warehouse": "finished_real",
  "updated_at": "2026-05-22T10:28:11.558",
  "product_code_id": 101
}
22/05/26, 12:28:11Modificainventory_balances718app interna · csv_import · consuntivo_posting · assignment:2139
quantity: 370 → 324; updated_at: 2026-05-14T11:21:16.179 → 2026-05-22T10:28:11.557
Dettagli before/after
Diff
{
  "quantity": {
    "new": 324,
    "old": 370
  },
  "updated_at": {
    "new": "2026-05-22T10:28:11.557",
    "old": "2026-05-14T11:21:16.179"
  }
}
Prima
{
  "id": 718,
  "quantity": 370,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-14T11:21:16.179",
  "product_code_id": 101
}
Dopo
{
  "id": 718,
  "quantity": 324,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-22T10:28:11.557",
  "product_code_id": 101
}
22/05/26, 12:28:11Inserimentoinventory_movements2649app interna · csv_import · consuntivo_posting · assignment:2139
id: ∅ → 2649; reason: ∅ → production_output; metadata: ∅ → ∅; reference: ∅ → assignment:2139; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2649,
    "old": null
  },
  "reason": {
    "new": "production_output",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2139",
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:11.553",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": 46,
    "old": null
  },
  "product_code_id": {
    "new": 101,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2649,
  "reason": "production_output",
  "metadata": null,
  "reference": "assignment:2139",
  "warehouse": "finished_real",
  "occurred_at": "2026-05-22T10:28:11.553",
  "scrap_by_type": null,
  "quantity_delta": 46,
  "product_code_id": 101
}
22/05/26, 12:28:11Inserimentoinventory_movements2648app interna · csv_import · consuntivo_posting · assignment:2139
id: ∅ → 2648; reason: ∅ → production_consumption; metadata: ∅ → ∅; reference: ∅ → assignment:2139; +5 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2648,
    "old": null
  },
  "reason": {
    "new": "production_consumption",
    "old": null
  },
  "metadata": {
    "new": null,
    "old": null
  },
  "reference": {
    "new": "assignment:2139",
    "old": null
  },
  "warehouse": {
    "new": "semi_finished",
    "old": null
  },
  "occurred_at": {
    "new": "2026-05-22T10:28:11.55",
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "quantity_delta": {
    "new": -46,
    "old": null
  },
  "product_code_id": {
    "new": 101,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2648,
  "reason": "production_consumption",
  "metadata": null,
  "reference": "assignment:2139",
  "warehouse": "semi_finished",
  "occurred_at": "2026-05-22T10:28:11.55",
  "scrap_by_type": null,
  "quantity_delta": -46,
  "product_code_id": 101
}
22/05/26, 12:28:11Inserimentoplan_assignments2139—
id: ∅ → 2139; date: ∅ → 2026-05-14; notes: ∅ → ∅; shift: ∅ → T1; +10 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 2139,
    "old": null
  },
  "date": {
    "new": "2026-05-14",
    "old": null
  },
  "notes": {
    "new": null,
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "completed",
    "old": null
  },
  "machine_id": {
    "new": null,
    "old": null
  },
  "operator_id": {
    "new": 36,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "assembly",
    "old": null
  },
  "product_code_id": {
    "new": 101,
    "old": null
  },
  "planned_quantity": {
    "new": null,
    "old": null
  },
  "produced_quantity": {
    "new": 46,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 2139,
  "date": "2026-05-14",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": null,
  "operator_id": 36,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 101,
  "planned_quantity": null,
  "produced_quantity": 46,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:11Modificaplan_assignments2112—
Nessuna differenza campi
Dettagli before/after
Diff
{}
Prima
{
  "id": 2112,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 41,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 101,
  "planned_quantity": null,
  "produced_quantity": 34,
  "setup_from_product_code_id": null
}
Dopo
{
  "id": 2112,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T2",
  "status": "completed",
  "machine_id": null,
  "operator_id": 41,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "assembly",
  "product_code_id": 101,
  "planned_quantity": null,
  "produced_quantity": 34,
  "setup_from_product_code_id": null
}
22/05/26, 12:28:11Modificaplan_assignments2098—
Nessuna differenza campi
Dettagli before/after
Diff
{}
Prima
{
  "id": 2098,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 20,
  "scrap_by_type": {
    "workedCasting": 20
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 101,
  "planned_quantity": null,
  "produced_quantity": 304,
  "setup_from_product_code_id": null
}
Dopo
{
  "id": 2098,
  "date": "2026-05-13",
  "notes": null,
  "shift": "T1",
  "status": "completed",
  "machine_id": 15,
  "operator_id": 20,
  "scrap_by_type": {
    "workedCasting": 20
  },
  "setup_minutes": null,
  "assignment_type": "production",
  "product_code_id": 101,
  "planned_quantity": null,
  "produced_quantity": 304,
  "setup_from_product_code_id": null
}
← Precedenti