Добавление нового столбца

DECLARE @FirstDate datetime
DECLARE @LastDate datetime
DECLARE @DEP INT
DECLARE @DocNumber VARCHAR(50)
DECLARE @ArtCode VARCHAR(50)
 
SET @DEP = 18--@P1
 
SET @FirstDate = '2023-02-01'--@P2  за  270 дней
SET @LastDate = '2023-02-28'--'2021-09-28 23:59'--@P3
SET @DocNumber = '%'--@P4
SET @ArtCode = '%%%'--@P5
 
 
 
SELECT  
    'OUT'
    , prd_PrimaryCode
    , prdl_Description
    ,CASE
            WHEN PAV.pav_Value = 75 THEN 'запчасти'
            WHEN PAV.pav_Value = 74 THEN 'оснастка'
            WHEN PAV.pav_Value IN (71,72,73,76,78,82) THEN 'инструмент'
            END AS BU
    
    ,  REPLACE(REPLACE(ord_Code, '\', ''), '/','')
    , convert(varchar, isnull(ost_executeDate, ost_ShipDate), 20)
    , convert(int, sum(case when osi_StatusID = 11
                then -1 * (osi_Quantity - osi_QuantitySU)
                else 1 * osi_Quantity
                end)) as Quantity
 
 
 
 
from
 
    LV_Order WITH (NOLOCK)
    left outer join LV_OrderItem WITH (NOLOCK) on ori_OrderID = ord_ID
    left outer join LV_OrderShipment WITH (NOLOCK)  on ost_OrderID = ord_ID
    left outer join LV_OrderShipItem WITH (NOLOCK) on osi_OrderItemID = ori_ID
    left outer join LV_Product WITH (NOLOCK) on prd_ID = ori_ProductID
    left outer join LV_ProductAttributesValues PAV WITH (NOLOCK) on  prd_id = PAV.pav_ProductID
    left outer join LV_ProductLang (NOLOCK) on prdl_ProductID = prd_ID and prdl_LanguageID = 4
    left outer join lv_ItemUnit UBox  (NOLOCK)  on UBox.itu_ProductID = prd_ID and UBox.itu_UnitID = 6  --
    left outer join LV_ItemPackTypeHierarchy  (NOLOCK)  HBox on HBox.iph_ParentItemUnitID = UBox.itu_ID
    left outer join lv_ItemUnit UPal  (NOLOCK) on UPal.itu_ProductID = prd_ID and UPal.itu_UnitID = 26  --
    left outer join LV_ItemPackTypeHierarchy HPal  (NOLOCK) on HPal.iph_ParentItemUnitID = UPal.itu_ID
 
where
    ord_DepositorID = @DEP
                and ord_Code like @DocNumber
    and prd_PrimaryCode like @ArtCode
    and ord_StatusID = 3
    and ost_StatusID = 10
    and osi_StatusID in (10, 11)
    and convert(varchar, isnull(ost_executeDate, ost_ShipDate), 20) between @FirstDate and @LastDate
 and ord_code not like 'ea_%'
 and PAV.pav_attributeID = 76
 group by
    prd_PrimaryCode
    ,prdl_Description
    ,PAV.pav_Value
    ,ord_Code
    ,convert(varchar, isnull(ost_executeDate, ost_ShipDate), 20)
    ,ord_CustomerID
    ,ord_Memo
    ,convert(int,isnull(HBox.iph_Quantity, 1))
    ,convert(int,isnull(HPal.iph_Quantity, 1))
order by 4,6