Consulta per obtenir les dades necessaries per fer els enviament EDI de Mitjans
declare @DocEntry as int=352050; SELECT T0.DocEntry NumAlbara ,ROW_NUMBER() OVER(PARTITION BY T6.PackageNum ORDER BY T0.DocEntry ASC) Linia ,T0.LineNum+1 LiniaAlbara ,T6.PackageNum ,T6.Quantity ,T6.unitMsr ,T0.DocDate Data ,T0.ItemCode ,T0.CodeBars ,T8.DistNumber U_Lote ,( SELECT SUM(PK.Qtd) FROM SGAMIT09.dbo.LIGAORDENSDISTD OD JOIN SGAMIT09.dbo.Picking PK on PK.SerieOrdDistribuicao=OD.SERIE and PK.NumeroOrdDistribuicao=OD.NUMERO and PK.LINHA=OD.linha WHERE OD.NGUIA=T0.DocEntry and PK.Artigo=T0.ItemCode COLLATE Modern_Spanish_CI_AS and PK.lote=T8.DistNumber COLLATE Modern_Spanish_CI_AS ) UnitatsPicking ,ABS(T7.Quantity) U_CantLote ,T1.SalUnitMsr ,T0.U_rsaQt2 ,T1.U_INTRX_EDI_CUEXP ,T0.Quantity ,T0.OrderedQty ,T8.ExpDate ,T1.U_INTRX_EDI_DUN ,T1.U_INTRX_EDI_TIPART ,T0.WhsCode U_Almacen ,T4.PackageNum ,T4.U_INTRX_CODSSCC SSCC ,T4.U_INTRX_EDI_CANTC ,T4.U_INTRX_EDI_PESOB ,T4.U_INTRX_EDI_TIPO ,T5.U_INTRX_EDI_TEEDI TIPEMB ,T1.U_intrx_diasCadALE VidaUtil ,DATEADD(day,T1.U_intrx_diasCadALE,GETDATE()) DataLimit FROM DLN1 T0 JOIN DLN8 T6 on T6.DocEntry=T0.DocEntry and T6.ItemCode=T0.ItemCode JOIN DLN7 T4 on T4.DocEntry=T0.DocEntry and T4.PackageNum=T6.PackageNum JOIN OITM T1 on T1.ItemCode=T0.ItemCode JOIN OITL T3 on T3.DocEntry=T0.DocEntry and T3.DocType=15 and T3.DocLine=T0.LineNum JOIN ITL1 T7 on T7.LogEntry=T3.LogEntry JOIN OBTN T8 on T8.SysNumber=T7.SysNumber and T8.ItemCode=T7.ItemCode JOIN OPKG T5 on T5.PkgType=T4.PackageTyp WHERE T0.DocEntry=@DocEntry ORDER BY T6.PackageNum,Linia