Changes between Version 11 and Version 12 of UseCaseModel/ShipmentDetails

Timestamp:

12/28/24 21:31:38 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/ShipmentDetails

@@ -60 +60 @@
 {{{
 select 
-        c.customer_name,
-        CONCAT(a.city , ', ', a.street, ', ',a.building_number, ', ', a.postcode) AS customer_address,
-        w.wine_name, 
-        sl.wine_base_price, 
-        sl.wine_agreed_price, 
-        sl.wine_quantity
+    c.customer_name as CustomerName,
+    CONCAT(a.city , ', ', a.street, ', ',a.building_number, ', ', a.postcode) AS CustomerAddress,
+    w.wine_name as WineName, 
+    sl.wine_base_price as WineBasePrice, 
+    sl.wine_agreed_price as WineAgreedPrice, 
+    sl.wine_quantity as WineQuantity
 from shipment_load sl
 join customer c on sl.customer_id = c.customer_id