SAPB1_VW_CLIENTES_BECOFARMA_WMS

CREATE VIEW [dbo].[VW_CLIENTES_BECOFARMA_WMS]
AS
SELECT T0.CARDCODE AS CODIGO,
T0.CARDNAME AS NOMBRE_COMERCIAL ,
T0.Phone1,
ISNULL(T1.FirstName,'ND') AS CONTACTO,  
T0.u_nit As NIT, 
T0.Address As DIRECCION, 
T0.E_Mail, T0.GroupCode
FROM OCRD T0 LEFT JOIN OCPR T1 ON T0.CardCode = T1.CardCode
WHERE (T0.CARDTYPE = 'C' AND T0.validFor = 'Y')
GO