https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30144 --- Comment #1 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Created attachment 193017 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=193017&action=edit Bug 30144: Add servicing_instruction field to aqorders table This patch adds a new TEXT field 'servicing_instruction' to the aqorders table to store EDIFACT servicing instructions (GIR LVT/LVC segments) as JSON. The field stores an array of instruction groups, where each group is an array of instruction objects with 'type' (LVC or LVT) and 'value' fields. Structure: [[{type:"LVC",value:"BB"},{type:"LVT",value:"text"}],[...]] This allows for: - Multiple servicing instruction groups per order line - Combinations of coded (LVC) and free-text (LVT) instructions - Instructions that work together in groups Also adds EDIFACT_SI authorized value category with EDItEUR List 3B servicing instruction codes for coded (LVC) instructions. Test plan: 1. Run database update 2. Verify aqorders.servicing_instruction field exists 3. Verify EDIFACT_SI authorized value category is created 4. Verify authorized values include codes like BB, BI, etc. -- You are receiving this mail because: You are watching all bug changes.