Chris chris-returnless
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "id": "so-100001", | |
| "orderNumber": "100001", | |
| "companyId": "b45f6432-2462-4c6f-b00f-1d9d01000000", | |
| "customerId": "c45f6432-2462-4c6f-b00f-1d9d01000000", | |
| "orderDate": "2026-04-22T10:15:22Z", | |
| "currency": "EUR", | |
| "items": [ | |
| { | |
| "id": "line-1", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "returnDate": "2019-08-24T14:15:22Z", | |
| "externalNumber": "RMA-100045", | |
| "companyId": "b45f6432-2462-4c6f-b00f-1d9d01000000", | |
| "salesOrderId": "b45f6432-2462-4c6f-b00f-1d9d01000000", | |
| "warehouseId": "b45f6432-2462-4c6f-b00f-1d9d01000000", | |
| "externalComment": "Customer announced a partial return", | |
| "internalComment": "Partial return with inspection outcome and financial adjustments", | |
| "contact": "john.doe@example.com", | |
| "creditMemo": { |
chris-returnless
/ RepairCloudAppRegistration.sql
Last active
April 21, 2026 15:06
JTL Wawi 2.0 item fix 🚨 Warning: This query is provided by JTL as an example. Executing it is at your own risk. Always create a full database backup before proceeding.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ============================================================================= | |
| -- Reparatur-Script: Cloud-Apps ohne kBenutzerApp in tRestApiRegistrationRequest | |
| -- ============================================================================= | |
| -- Zweck: Findet Cloud-App-Registrierungen (nCloudApp = 1) ohne zugewiesenen | |
| -- Benutzer (kBenutzerApp IS NULL oder 0) und weist einen aktiven | |
| -- Benutzer zu, der: | |
| -- 1) in eazybusiness.dbo.tBenutzer aktiv ist (nAktiv = 1) | |
| -- 2) über eazybusiness.dbo.tBenutzerFirma dem Mandanten zugeordnet ist | |
| -- 3) dessen kFirma in [MandantDB].dbo.tFirma aktiv ist (cAktiv = 'Y') | |
| -- |