50 lines
1.5 KiB
SQL
50 lines
1.5 KiB
SQL
-- Copia de la consulta en agofer_comisiones.pl
|
|
SELECT
|
|
com.id_sucursal AS suc,
|
|
com.id_vendedor AS cod_vendedor,
|
|
vdr.nombre_vendedor AS vendedor,
|
|
c.id_cliente AS cod_cliente,
|
|
c.nombre_cliente AS cliente,
|
|
sec.id_sector AS cod_sector,
|
|
sec.descripcion AS sector,
|
|
vt.id_tipovendedor AS tipo_vdr,
|
|
com.id_documento AS documento,
|
|
com.id_documento_cruce AS documento_cruce,
|
|
com.id_item AS cod_item,
|
|
i.descripcion AS item,
|
|
l.descripcion AS linea,
|
|
lc.descripcion AS linea_comision,
|
|
com.periodo AS periodo,
|
|
com.factor_prorrateo AS factor_prorrateo,
|
|
com.factor_comision AS comision_cop_por_kg,
|
|
mo.descripcion AS rango_mora,
|
|
com.cantidad AS cantidad,
|
|
com.peso_un AS peso_un,
|
|
com.valor_comision AS comision
|
|
FROM
|
|
valor_comision_recaudo_kg com
|
|
LEFT JOIN vendedor vdr
|
|
USING (id_vendedor,id_sucursal)
|
|
LEFT JOIN vendedor_has_tipovendedor vt
|
|
USING (id_vendedor,id_sucursal)
|
|
LEFT JOIN item i
|
|
USING (id_sucursal,id_item)
|
|
LEFT JOIN linea l
|
|
ON (i.tipo = l.tipo AND LEFT(i.id_linea,2) = l.id_linea)
|
|
LEFT JOIN linea_has_linea_comision lhc
|
|
ON (l.id_linea=lhc.id_linea)
|
|
LEFT JOIN linea_comision lc
|
|
USING (id_linea_comision)
|
|
LEFT JOIN tipo_mora mo
|
|
USING (id_rangomora)
|
|
LEFT JOIN recaudo doc
|
|
USING (id_sucursal,id_documento,id_documento_cruce)
|
|
LEFT JOIN cliente c
|
|
USING (id_cliente)
|
|
LEFT JOIN sector sec
|
|
ON (LEFT(c.id_sector,2)=sec.id_sector)
|
|
|
|
WHERE
|
|
EXTRACT(YEAR_MONTH FROM com.periodo) = 201205
|
|
|