| | |
| | | raise notice '- using debitor (%): %', relatedDebitor.uuid, relatedDebitor; |
| | | raise notice '- using bankAccount (%): %', relatedBankAccount.uuid, relatedBankAccount; |
| | | insert |
| | | into hs_office_sepamandate (uuid, debitoruuid, bankAccountuuid, reference, validity) |
| | | values (uuid_generate_v4(), relatedDebitor.uuid, relatedBankAccount.uuid, 'ref'||idName, daterange('20221001' , '20261231', '[]')); |
| | | into hs_office_sepamandate (uuid, debitoruuid, bankAccountuuid, reference, agreement, validity) |
| | | values (uuid_generate_v4(), relatedDebitor.uuid, relatedBankAccount.uuid, 'ref'||idName, '20220930', daterange('20221001' , '20261231', '[]')); |
| | | end; $$; |
| | | --// |
| | | |