SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'RLCFDI' ORDER BY Fr_ID
EXEC SP_RPT_RLCFDI_2 '01-0001049'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'RLCFDI'
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'FACTURA' AND Clave = '01-0001049' and not imagen is null  
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'CAORGR' ORDER BY Fr_ID
EXEC SP_RPT_CAORGR_2 'FACTURA', '01-0001049', '03', '105'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'CAORGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
EXEC SP_RPT_SDIGGR_2 'FACTURA', '01-0001049', '02', '130'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'SDIGGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'SDIGGR' ORDER BY Fr_ID
EXEC SP_RPT_SDIGGR_2 'FACTURA', '01-0001049', '01', '130'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'SDIGGR'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'DEFAGR' ORDER BY Fr_ID
EXEC SP_RPT_DEFAGR_2 '01-0001049'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'DEFAGR'
SELECT Mn_Impresion_Letras, Mn_Impresion_Moneda FROM Moneda WHERE Mn_Cve_Moneda = 'MXN'
EXEC SP_RPT_ZFDI44_3 '01-0001049'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'ZFDI44' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
EXEC SP_RPT_PROIMP_2 '01-0001049', '0007'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'PROIMP'
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'ZDESAF' ORDER BY Fr_ID
EXEC SP_RPT_ZDESAF_2 'FACTURA', '01-0001049', '0007'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'
SELECT TOP 1    Fr_Procedure1,    Fr_Procedure2,    Fr_Procedure3,    Fr_LineasDetalle,    Fr_Alto_Hoja,    Fr_Ancho_Hoja,    Fr_Caida_Libre FROM    Formato WHERE    Fr_Cve_Formato = 'ZDESAF'
SELECT * FROM Formato WHERE Fr_Tipo = '03' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
SELECT Imagen FROM Imagen_Objeto WHERE Objeto = 'MEMBRETE' AND Clave = 'CFDI18' and not imagen is null  
EXEC SP_RPT_ZFDI44_1 '01-0001049'
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'ZFDI44' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '01' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
SELECT * FROM Formato WHERE Fr_Tipo = '02' AND Fr_Cve_Formato = 'PROIMP' ORDER BY Fr_ID
EXEC SP_RPT_PROIMP_2 '01-0001049', '0006'
SELECT top 1 Fr_Caida_Libre AS Nombre FROM Formato WHERE Fr_Cve_Formato = 'ZFDI44'