Page History

(lr2.comision + lr2.iva_comision) TOTAL_FACTURA,

0 TOTAL_EXENTAS,

0 TOTAL_GRAVADO_5,

0 TOTAL_IVA_5,

lr2.comision TOTAL_GRAVADO_10,

lr2.iva_comision TOTAL_IVA_10,

LC.FECHA_IMPRESION_FACTURA FECHA_EMISION,

lc.Razon_Social,

substr(lpad(replace(replace(replace(LR2.RUC_COMERCIO,'.',''),'-',''),' ',''),11,'0'),11,1) DV,

nvl(replace(replace(replace(substr(LR2.RUC_COMERCIO,1,length(LR2.RUC_COMERCIO)-1),'.',''),'-',''),' ',''),0) DOCUMENTO,

TO_NUMBER(TO_CHAR(LC.FECHA_LIQUIDACION_HASTA,'YYYYMM')) PERIODO,

LC.NRO_FACTURA FACTURA,

to_number(substr(h.punto_expedicion,-3)) PUNTO_EXPEDICION,

to_number(substr(h.punto_expedicion,1,3)) SUCURSAL,

----------Registro para Archivo.

2 ||chr(9)||-- as tipo_registro,

rpad(nvl(replace(replace(replace(substr(LR2.RUC_COMERCIO,1,length(LR2.RUC_COMERCIO)-1),'.',''),'-',''),' ',''),0),15,' ')

||chr(9)||-- as ruc_cliente,

substr(lpad(replace(replace(replace(LR2.RUC_COMERCIO,'.',''),'-',''),' ',''),11,'0'),11,1)

||chr(9)||-- as DV_cliente,

rpad(lc.razon_social,80) ||chr(9)||-- as nombre_procesador, -- AR. 20150226. V2 dice long=0!!!

1 ||chr(9)||-- as tipo_documento, -- 1-Factura

h.punto_expedicion||'-'||lpad(lc.nro_factura,7,'0')

||chr(9)||-- as nro_documento,

to_char(lc.fecha_impresion_factura,'dd/mm/yyyy')

||chr(9)||-- as fec_documento,

lr2.comision ||chr(9)||-- as monto_10,

lr2.iva_comision ||chr(9)||-- as iva_10,

0 ||chr(9)||-- as monto_5,

0 ||chr(9)||-- as iva_5,

0 ||chr(9)||-- as no_gravada,

(lr2.comision + lr2.iva_comision) ||chr(9)||-- as monto_reportado, -- AR. 20150226.

lpad(1,2) ||chr(9)||-- as condicion_venta, -- 1-contado/2-credito -- AR. 20150226.

lpad(0,3) ||chr(9)||-- as cant_cuotas, -- 0 p/condicion_venta=1 -- AR. 20150226.

h.timbrado -- as nro_timbrado -- AR. 20150226.

as form_221