USE Dashboard
GO
CREATE VIEW DestinoFactura
AS
-- Destino por factura
-- Martín Jiménez @onceplus
-- 23.abr.2019
-- 15.JUL.2020 Campo Empresa
SELECT
Empresa = 'MINI',
NumDoc = SOPNUMBE,
FechaDoc = DOCDATE,
IdClie = CUSTNMBR,
NombreCliente = CUSTNAME,
IdDestino = PRSTADCD,
Direccion1 = ADDRESS1,
Direccion2 = ADDRESS2,
Ciudad = CITY,
Estado = STATE
FROM
MGM..SOP30200
UNION ALL
SELECT
Empresa = 'DISE',
NumDoc = SOPNUMBE,
FechaDoc = DOCDATE,
IdClie = CUSTNMBR,
NombreCliente = CUSTNAME,
IdDestino = PRSTADCD,
Direccion1 = ADDRESS1,
Direccion2 = ADDRESS2,
Ciudad = CITY,
Estado = STATE
FROM
DISE..SOP30200