...
----------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
Implementación
Ejecutar el script PKG_FACTURACION_desa2prod20210714.pck en CAMELLO
Rollback
Ejecutar el script PKG_FACTURACION_desarrolloRespaldo20210714.pck