Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT E1_XCTMDW,
- E1_FILIAL,
- E1_PARCELA,
- E1_XRPS,
- E1_VALOR,
- CONVERT(VARCHAR(8000),CONVERT(VARBINARY(8000), E1_XHIST)) HISTORICO,
- CONVERT(VARCHAR(8000),CONVERT(VARBINARY(8000), E1_XHIST)) HISTORICO,
- CONTRATO.CodigoContrato,
- CONTRATO.Valor,
- HTITULO.F2_DOC,
- HTITULO.F2_SERIE,
- BTITULO.D2_COD
- FROM [192.168.0.185].[MW_CLASSIC].[dbo].[tb_agreement] CONTRATO
- LEFT JOIN SE1010 POS
- ON POS.E1_XCTMDW = CONTRATO.CodigoContrato COLLATE Latin1_General_BIN
- LEFT JOIN SF2010 HTITULO
- ON POS.E1_NUMNOTA = HTITULO.F2_DOC
- LEFT JOIN SD2010 BTITULO
- ON HTITULO.F2_DOC = BTITULO.D2_DOC
- LEFT JOIN SC5010 PEDIDO
- ON BTITULO.D2_PEDIDO = PEDIDO.C5_NUM
- LEFT JOIN SC6010 PEDIDODESC
- ON PEDIDO.C5_NUM = PEDIDODESC.C6_NUM
- WHERE E1_XCTMDW = '195/2018'
- AND POS.D_E_L_E_T_ = ''
- AND PEDIDO.D_E_L_E_T_ =''
- SELECT CONTRATO.CodigoContrato,
- CONTRATO.Valor,
- PRE.C5_XCTMDW,
- PRE.C5_FILIAL,
- PRE.C5_NOTA,
- PRE.C5_SERIE,
- PRE.C5_XOPFAT,
- PRECORPO.C6_FILIAL,
- PRECORPO.C6_PRODUTO,
- PRECORPO.C6_VALOR,
- PRECORPO.C6_ITEM,
- PRECORPO.C6_DESCRI,
- FROM SC6010 PRECORPO,
- [192.168.0.185].[MW_CLASSIC].[dbo].[tb_agreement] CONTRATO
- LEFT JOIN SC5010 PRE
- ON PRE.C5_XCTMDW = CONTRATO.CodigoContrato COLLATE Latin1_General_BIN
- LEFT JOIN SF2010 HTITULO
- ON PRE.C5_NOTA = HTITULO.F2_DOC AND PRE.C5_FILIAL = HTITULO.F2_FILIAL
- LEFT JOIN SD2010 BTITULO
- ON HTITULO.F2_DOC = BTITULO.D2_DOC AND HTITULO.F2_FILIAL = BTITULO.D2_FILIAL
- WHERE PRE.C5_XOPFAT = '2'
- AND PRE.D_E_L_E_T_ = ''
- AND PRE.C5_XCTMDW = '137/2018'
- AND PRE.C5_NUM = PRECORPO.C6_NUM
- AND PRE.C5_FILIAL = PRECORPO.C6_FILIAL
Add Comment
Please, Sign In to add comment