| 123456789101112131415 |
- SELECT TOP 100 [Client_DB]
- , [Kunde_Nr]
- , [Mahnung_Nr]
- , [Mahnung_Datum]
- , [Mahnstufe]
- , [Beleg_Nr]
- , [Beleg_Datum]
- , [Betrag]
- , [Offen]
- FROM [dbo].[Forderungen_Mahnungen]
- WHERE (
- [Client_DB] = {{ appsmith.URL.queryParams.Client_DB }}
- AND [Kunde_Nr] IN (SELECT [Kunde_Nr] FROM [dbo].[Forderungen_Mahnungen] WHERE [Beleg_Nr] = {{ appsmith.URL.queryParams.Beleg_Nr }} )
- ) OR 1 != 1
- ORDER BY [Mahnung_Datum], [Beleg_Nr]
|
