List of invoice lines with blank order numbers
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
We need a list of invoice lines that have blank order numbers.
Resolution
> s+ xxx50;
SQL> select z601_rec_key_2 from z601 where substr (z601_rec_key_3,1,9) = '000000000' and (substr (z601_rec_key_2,21,15) is not null and substr (z601_rec_key_2,21,3) ^= ' ');
- Article last edited: 8-Dec-2018