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 #201
10 eventi mostrati · offset 0Ordinati dal più recente
QuandoAzioneTabellaRecordContestoSintesi modifiche
18/06/26, 13:53:26Inserimentoplan_assignments4719app interna · app · magic_plan_confirm · magic_plan:2026-06-15:2026-06-19
id: ∅ → 4719; date: ∅ → 2026-06-16; notes: ∅ → Auto-generato (Ordine #359); shift: ∅ → T1; +14 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4719,
    "old": null
  },
  "date": {
    "new": "2026-06-16",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #359)",
    "old": null
  },
  "shift": {
    "new": "T1",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 33,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "planned_minutes": {
    "new": 281,
    "old": null
  },
  "product_code_id": {
    "new": 113,
    "old": null
  },
  "capacity_minutes": {
    "new": 450,
    "old": null
  },
  "planned_quantity": {
    "new": 211,
    "old": null
  },
  "order_allocations": {
    "new": [
      {
        "code": "MNA2002016",
        "orderId": 359,
        "quantity": 211,
        "deliveryDate": "2026-06-24",
        "productCodeId": 113,
        "productionDeadline": "2026-06-22"
      }
    ],
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "residual_capacity_minutes": {
    "new": 169,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4719,
  "date": "2026-06-16",
  "notes": "Auto-generato (Ordine #359)",
  "shift": "T1",
  "status": "planned",
  "machine_id": 25,
  "operator_id": 33,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "planned_minutes": 281,
  "product_code_id": 113,
  "capacity_minutes": 450,
  "planned_quantity": 211,
  "order_allocations": [
    {
      "code": "MNA2002016",
      "orderId": 359,
      "quantity": 211,
      "deliveryDate": "2026-06-24",
      "productCodeId": 113,
      "productionDeadline": "2026-06-22"
    }
  ],
  "produced_quantity": null,
  "residual_capacity_minutes": 169,
  "setup_from_product_code_id": null
}
18/06/26, 13:53:26Inserimentoplan_assignments4718app interna · app · magic_plan_confirm · magic_plan:2026-06-15:2026-06-19
id: ∅ → 4718; date: ∅ → 2026-06-15; notes: ∅ → Auto-generato (Ordine #359); shift: ∅ → T2; +14 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 4718,
    "old": null
  },
  "date": {
    "new": "2026-06-15",
    "old": null
  },
  "notes": {
    "new": "Auto-generato (Ordine #359)",
    "old": null
  },
  "shift": {
    "new": "T2",
    "old": null
  },
  "status": {
    "new": "planned",
    "old": null
  },
  "machine_id": {
    "new": 25,
    "old": null
  },
  "operator_id": {
    "new": 27,
    "old": null
  },
  "scrap_by_type": {
    "new": null,
    "old": null
  },
  "setup_minutes": {
    "new": null,
    "old": null
  },
  "assignment_type": {
    "new": "production",
    "old": null
  },
  "planned_minutes": {
    "new": 450,
    "old": null
  },
  "product_code_id": {
    "new": 113,
    "old": null
  },
  "capacity_minutes": {
    "new": 450,
    "old": null
  },
  "planned_quantity": {
    "new": 338,
    "old": null
  },
  "order_allocations": {
    "new": [
      {
        "code": "MNA2002016",
        "orderId": 359,
        "quantity": 338,
        "deliveryDate": "2026-06-24",
        "productCodeId": 113,
        "productionDeadline": "2026-06-22"
      }
    ],
    "old": null
  },
  "produced_quantity": {
    "new": null,
    "old": null
  },
  "residual_capacity_minutes": {
    "new": 0,
    "old": null
  },
  "setup_from_product_code_id": {
    "new": null,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 4718,
  "date": "2026-06-15",
  "notes": "Auto-generato (Ordine #359)",
  "shift": "T2",
  "status": "planned",
  "machine_id": 25,
  "operator_id": 27,
  "scrap_by_type": null,
  "setup_minutes": null,
  "assignment_type": "production",
  "planned_minutes": 450,
  "product_code_id": 113,
  "capacity_minutes": 450,
  "planned_quantity": 338,
  "order_allocations": [
    {
      "code": "MNA2002016",
      "orderId": 359,
      "quantity": 338,
      "deliveryDate": "2026-06-24",
      "productCodeId": 113,
      "productionDeadline": "2026-06-22"
    }
  ],
  "produced_quantity": null,
  "residual_capacity_minutes": 0,
  "setup_from_product_code_id": null
}
29/05/26, 08:35:21Inserimentoinventory_balances15692—
id: ∅ → 15692; quantity: ∅ → 0; warehouse: ∅ → finished_planned; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15692,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "finished_planned",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15692,
  "quantity": 0,
  "warehouse": "finished_planned",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15691—
id: ∅ → 15691; quantity: ∅ → 0; warehouse: ∅ → finished_real; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15691,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "finished_real",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15691,
  "quantity": 0,
  "warehouse": "finished_real",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15690—
id: ∅ → 15690; quantity: ∅ → 0; warehouse: ∅ → semi_finished_treated; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15690,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "semi_finished_treated",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15690,
  "quantity": 0,
  "warehouse": "semi_finished_treated",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15689—
id: ∅ → 15689; quantity: ∅ → 0; warehouse: ∅ → semi_finished; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15689,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "semi_finished",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15689,
  "quantity": 0,
  "warehouse": "semi_finished",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15688—
id: ∅ → 15688; quantity: ∅ → 0; warehouse: ∅ → at_external_treatment; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15688,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "at_external_treatment",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15688,
  "quantity": 0,
  "warehouse": "at_external_treatment",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15687—
id: ∅ → 15687; quantity: ∅ → 0; warehouse: ∅ → raw_treated; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15687,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "raw_treated",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15687,
  "quantity": 0,
  "warehouse": "raw_treated",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoinventory_balances15686—
id: ∅ → 15686; quantity: ∅ → 0; warehouse: ∅ → raw; updated_at: ∅ → 2026-05-29T06:35:21.027351; +1 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 15686,
    "old": null
  },
  "quantity": {
    "new": 0,
    "old": null
  },
  "warehouse": {
    "new": "raw",
    "old": null
  },
  "updated_at": {
    "new": "2026-05-29T06:35:21.027351",
    "old": null
  },
  "product_code_id": {
    "new": 201,
    "old": null
  }
}
Prima
null
Dopo
{
  "id": 15686,
  "quantity": 0,
  "warehouse": "raw",
  "updated_at": "2026-05-29T06:35:21.027351",
  "product_code_id": 201
}
29/05/26, 08:35:21Inserimentoproduct_codes201app interna · app · product_code_create · product_code:00330456_T
id: ∅ → 201; code: ∅ → 00330456_T; notes: ∅ → ∅; active: ∅ → true; +12 altri campi
Dettagli before/after
Diff
{
  "id": {
    "new": 201,
    "old": null
  },
  "code": {
    "new": "00330456_T",
    "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 0456",
    "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": 201,
  "code": "00330456_T",
  "notes": null,
  "active": true,
  "customer": "DYNACAST",
  "flow_type": "direct",
  "description": "CORPO 0456",
  "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
}