select  1 as [FixOrder], A.[ItemInfo_ItemCode] as [ItemInfo_ItemCode], isnull( case  when A1.[ItemFormAttribute] in (16, 22) then A.[ItemInfo_ItemName] else A1.[Name] end ,'') as [ItemID_Name],  A3.[Code] as [Bin_Code], A3.[Segment1] as [Bin_Segment1], A4.[Code] as [Wh_Code], A.[DocDate] as  [Main_DocDate], A7.[DocTypeName] as [Main_DocTypeName], A.[DocNo] as [Main_DocNo], A.[Doc_EntityID] as [Doc_EntityID], A.[Doc_EntityType] as [Doc_EntityType], A.[DocOrg] as [Main_DocOrg], A.[Direction] as [Main_Direction], A.[DocLineNo] as [Main_DocLineNo], convert(decimal(24,9),null) as [Temp_InQtyIU], A5.[Round_Precision] as [IURound_Precision],  case  when ((A.[DocType_EntityType] != 'UFIDA.U9.AP.APMatch.APMatchDocType') and (A.[BackLineType] = 0)) then (Power((-(1)),(A.[Direction] + A.[DisplayDirection])) * A2.[StoreUOMQty]) else convert(decimal(24,9),0) end  as [Temp_OutQtyIU], convert(decimal(24,9),null) as [Temp_BalQtyIU], A8.[Name] as [Wh_Name], A9.[DescFlexField_CombineName] as [ItemDescFlex_CombineName], A10.[Name] as [Bin_Name], A.[TransUpdateTime] as [Main_TransUpdateTime], dbo.F_GetMD5key((((('' + '') + isnull(convert(nvarchar(2000),A.[ItemInfo_ItemCode]),'')) + '') + isnull(convert(nvarchar(2000),isnull( case  when A1.[ItemFormAttribute] in (16, 22) then A.[ItemInfo_ItemName] else A1.[Name] end ,'')),''))) as [BizKey] from  InvTrans_TransLine as A  left join [CBO_ItemMaster] as A1 on (A.[ItemInfo_ItemID] = A1.[ID])  left join [InvTrans_TransLineBin] as A2 on (A.[ID] = A2.[TransLine])  left join [CBO_Bin] as A3 on (A2.[BinInfo_Bin] = A3.[ID])  left join [CBO_Wh] as A4 on (A.[Wh] = A4.[ID])  left join [Base_UOM] as A5 on (A.[StoreUOM] = A5.[ID])  left join [Base_Organization] as A6 on (A.[Org] = A6.[ID])  left join [InvTrans_TransLine_Trl] as A7 on (A7.SysMlFlag = 'zh-CN') and (A.[ID] = A7.[ID])  left join [CBO_Wh_Trl] as A8 on (A8.SysMlFlag = 'zh-CN') and (A4.[ID] = A8.[ID])  left join [CBO_ItemMaster_Trl] as A9 on (A9.SysMlFlag = 'zh-CN') and (A1.[ID] = A9.[ID])  left join [CBO_Bin_Trl] as A10 on (A10.SysMlFlag = 'zh-CN') and (A3.[ID] = A10.[ID]) where  ((((((A.[DisplayDirection] = 1) and A.[QtyPriceDealFlg] in (0, 1)) and (A.[IsInit] = 0)) and A.[DocDate] between '2026-03-01' and '2026-03-21') and (A6.[Code] = N'DL01')))