...
- Use algorithm to generate declaration_number
- Declaration number should consist of a 4 serial symbols and 8 number symbols and looks like XXXX-12H4-245D
- Add field to ops.declarations and il.declaration_requests - declaration_number
- Add declaration_number to print out form
Validate uniqueness of human readable declaration number
- generate declaration_number
- SELECT Search declaration_id FROM number in declarations where .declaration_number =$and/or declaration_requests.declaration_.number
- if exists = go to 'generate declaration_number'
- else save declaration_number to declaration_request