Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- unidad_negocio.f281_descripcion,
- unidad_negocio.f281_id
- ,mvtoped.f431_cant1_pedida
- ,mvtoped.f431_precio_unitario_base * mvtoped.f431_cant1_pedida precio
- ,(CONVERT ( INT, mvtoentidad.f753_dato_numero ) * 1.0) / 1000 * mvtoped.f431_cant1_pedida AS metros
- ,(CONVERT ( INT, mvtoentidad.f753_dato_numero ) * 1.0 ) / 1000 * mvtoped.f431_cant1_pedida / (mvtoped.f431_precio_unitario_base * mvtoped.f431_cant1_pedida ) AS precio_metro
- FROM
- unoee.dbo.t430_cm_pv_docto ped
- INNER JOIN unoee.dbo.t431_cm_pv_movto mvtoped ON ped.f430_rowid = mvtoped.f431_rowid_pv_docto
- INNER JOIN unoee.dbo.t281_co_unidades_negocio unidad_negocio ON mvtoped.f431_id_un_movto = unidad_negocio.f281_id
- INNER JOIN unoee.dbo.t121_mc_items_extensiones iext ON mvtoped.f431_rowid_item_ext = iext.f121_rowid
- INNER JOIN unoee.dbo.t120_mc_items i ON i.f120_rowid = iext.f121_rowid_item
- INNER JOIN unoee.dbo.t753_mm_movto_entidad_columna mvtoentidad ON i.f120_rowid_movto_entidad = mvtoentidad.f753_rowid_movto_entidad
- WHERE
- ped.f430_id_cia = 1
- AND ped.f430_ind_estado <> '9'
- AND mvtoentidad.f753_rowid_entidad_atributo IN('58')
- AND ped.f430_id_fecha BETWEEN '2019-01-15 00:00:00' AND '2020-01-15 23:59:59'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement