SELECT Ss_RFC, Ss_no_serie, Ss_fec_inicial_cert, Ss_fec_final_cert FROM MPROARCHIVOS..Sat_Sellos WHERE (Ss_RFC = 'PRE150416654' AND Ss_no_serie = '00001000000408908448') OR ( Ss_RFC IN ('SAT970701NN3') AND Ss_no_serie = '00001000000408908448') SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_URL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_RFC_SAT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM EMPRESAS..Configuracion WHERE Cf_Variable = 'GEN_DATABASE_APP_VALIDADOR_SAT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_ACUSE_RECIBO_EMPRESA' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_DIRECTORIO_XML_PORTAL' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_IMP_ACUSE_RECIBO_PROVEEDOR' SELECT Cd_Tabla, Cd_Documento FROM Comprobante_Digital WHERE Cd_Tabla IN ('POLIZA','GASTO_REGISTRO','COMPRA','NOTA_CREDITO_PROVEEDOR','GASTO_REGISTRO_NOMINA') AND Cd_Timbre_UUID = 'D693377A-509A-4B3E-A082-882EBC7580C3' AND Es_Cve_Estado <> 'CA' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'LILIANA' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_PROVEEDOR_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'LILIANA' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Ad_ID, Ad_File_Name, Ad_File_Size, Ad_Descripcion,Oper_Alta,Fecha_Alta,'' FROM Adjunto WHERE Ad_Tabla = 'Poliza' AND Ad_Documento = '0000005141' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_PROVEEDOR_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_PERMITIR_MULTISELECCION' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_MODIFICA_TIEMPO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_PERMITIR_EDITAR' SELECT DISTINCT Texto,ID,Transaccion from Configuracion_Etiqueta where (Transaccion = '' or Transaccion = '%') ORDER BY Transaccion DESC SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_FORMATO_MONEDA' SELECT FontSize FROM EMPRESAS..Operadores WHERE Operador = 'LILIANA' SELECT 'SI' EXISTE FROM EMPRESAS..sysobjects sysobjects INNER JOIN EMPRESAS..syscolumns syscolumns ON sysobjects.id = syscolumns.id WHERE sysobjects.name = 'Operadores' AND syscolumns.name = 'FontSize' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_XML_CON_ESQUEMAS' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_RECEPTOR_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_EMISOR_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_BASE_SAT' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_COMPROBANTE_UNICO' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_VALIDA_PROVEEDOR_CFDI' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTO_LIMITE_KB' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_TABLA_GRABA_COMPROBANTE' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_ADJUNTAR_COMPROBANTE_AL_GUARDAR' SELECT Pl_Folio , Pd_ID , Pdc_Id AS ID_2, Pdc_UUID AS UUID, '' AS Serie, '' AS Folio, Pdc_Monto AS Monto, Pdc_RFC AS RFC, Pdc_Moneda AS Moneda, Pdc_Metodo_Pago AS Metodo_Pago , Pdc_Tipo_Cambio AS Tipo_Cambio , 'CFDI' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04') AS Ad_Binary FROM Poliza_Detalle_Comprobante LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante.Pdc_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante.Pdc_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0004' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CFD' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03') AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0004' AND Pdco_Tipo_Comprobante = '03' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CBB' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '05'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0004' AND Pdco_Tipo_Comprobante = '05' UNION ALL SELECT Pl_Folio , Pd_ID , Pdce_Id AS ID_2, Pdce_Numero_Factura AS UUID , '' AS Serie, '' AS Folio, Pdce_Monto AS Monto , Pdce_Tax_Id AS RFC, Pdce_Moneda AS Moneda , Pdce_Metodo_Pago AS Metodo_Pago , Pdce_Tipo_Cambio AS Tipo_Cambio , 'EXTRANJERO' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdce_Id AND Ad_Comprobante = '01'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Extranjero LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Extranjero.Pdce_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Extranjero.Pdce_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0004' SELECT Pl_Folio , Pd_ID , Pdc_Id AS ID_2, Pdc_UUID AS UUID, '' AS Serie, '' AS Folio, Pdc_Monto AS Monto, Pdc_RFC AS RFC, Pdc_Moneda AS Moneda, Pdc_Metodo_Pago AS Metodo_Pago , Pdc_Tipo_Cambio AS Tipo_Cambio , 'CFDI' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04') AS Ad_Binary FROM Poliza_Detalle_Comprobante LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante.Pdc_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante.Pdc_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0003' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CFD' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03') AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0003' AND Pdco_Tipo_Comprobante = '03' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CBB' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '05'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0003' AND Pdco_Tipo_Comprobante = '05' UNION ALL SELECT Pl_Folio , Pd_ID , Pdce_Id AS ID_2, Pdce_Numero_Factura AS UUID , '' AS Serie, '' AS Folio, Pdce_Monto AS Monto , Pdce_Tax_Id AS RFC, Pdce_Moneda AS Moneda , Pdce_Metodo_Pago AS Metodo_Pago , Pdce_Tipo_Cambio AS Tipo_Cambio , 'EXTRANJERO' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdce_Id AND Ad_Comprobante = '01'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Extranjero LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Extranjero.Pdce_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Extranjero.Pdce_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0003' SELECT Pl_Folio , Pd_ID , Pdc_Id AS ID_2, Pdc_UUID AS UUID, '' AS Serie, '' AS Folio, Pdc_Monto AS Monto, Pdc_RFC AS RFC, Pdc_Moneda AS Moneda, Pdc_Metodo_Pago AS Metodo_Pago , Pdc_Tipo_Cambio AS Tipo_Cambio , 'CFDI' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04') AS Ad_Binary FROM Poliza_Detalle_Comprobante LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante.Pdc_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante.Pdc_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0002' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CFD' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03') AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0002' AND Pdco_Tipo_Comprobante = '03' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CBB' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '05'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0002' AND Pdco_Tipo_Comprobante = '05' UNION ALL SELECT Pl_Folio , Pd_ID , Pdce_Id AS ID_2, Pdce_Numero_Factura AS UUID , '' AS Serie, '' AS Folio, Pdce_Monto AS Monto , Pdce_Tax_Id AS RFC, Pdce_Moneda AS Moneda , Pdce_Metodo_Pago AS Metodo_Pago , Pdce_Tipo_Cambio AS Tipo_Cambio , 'EXTRANJERO' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdce_Id AND Ad_Comprobante = '01'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Extranjero LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Extranjero.Pdce_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Extranjero.Pdce_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0002' SELECT Pl_Folio , Pd_ID , Pdc_Id AS ID_2, Pdc_UUID AS UUID, '' AS Serie, '' AS Folio, Pdc_Monto AS Monto, Pdc_RFC AS RFC, Pdc_Moneda AS Moneda, Pdc_Metodo_Pago AS Metodo_Pago , Pdc_Tipo_Cambio AS Tipo_Cambio , 'CFDI' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdc_Id AND Ad_Comprobante = '04') AS Ad_Binary FROM Poliza_Detalle_Comprobante LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante.Pdc_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante.Pdc_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0001' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CFD' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_Comprobante , ISNULL( (SELECT Ad_File_Name FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03'), '') AS Ad_File_Name , (SELECT Ad_Binary FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '03') AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0001' AND Pdco_Tipo_Comprobante = '03' UNION ALL SELECT Pl_Folio , Pd_ID , Pdco_Id AS ID_2, '' AS UUID , Pdco_Serie AS Serie, Pdco_Folio AS Folio, Pdco_Monto AS Monto , Pdco_RFC AS RFC, Pdco_Moneda AS Moneda , Pdco_Metodo_Pago AS Metodo_Pago , Pdco_Tipo_Cambio AS Tipo_Cambio , 'CBB' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdco_Id AND Ad_Comprobante = '05'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Nacional_Otro LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Nacional_Otro.Pdco_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0001' AND Pdco_Tipo_Comprobante = '05' UNION ALL SELECT Pl_Folio , Pd_ID , Pdce_Id AS ID_2, Pdce_Numero_Factura AS UUID , '' AS Serie, '' AS Folio, Pdce_Monto AS Monto , Pdce_Tax_Id AS RFC, Pdce_Moneda AS Moneda , Pdce_Metodo_Pago AS Metodo_Pago , Pdce_Tipo_Cambio AS Tipo_Cambio , 'EXTRANJERO' AS TIPO, ISNULL(Mn_Descripcion, '') AS Mn_Descripcion , ISNULL(Mp_Descripcion, '') AS Mp_Descripcion , ISNULL( (SELECT Ad_Comprobante FROM Adjunto WHERE Adjunto.Ad_Tabla = 'POLIZA' AND Adjunto.Ad_Documento = Pl_Folio + Pd_ID + Pdce_Id AND Ad_Comprobante = '01'), '') AS Ad_Comprobante , '' AS Ad_File_Name , NULL AS Ad_Binary FROM Poliza_Detalle_Comprobante_Extranjero LEFT JOIN Moneda ON Moneda.Mn_Cve_Moneda = Poliza_Detalle_Comprobante_Extranjero.Pdce_Moneda LEFT JOIN Metodo_Pago ON Metodo_Pago.Mp_Cve_Metodo_Pago = Poliza_Detalle_Comprobante_Extranjero.Pdce_Metodo_Pago WHERE Pl_Folio = '0000005141' AND Pd_ID = '0001' SELECT Poliza_Detalle.*, Cuenta_Contable.Cc_Descripcion, isnull(Centro_costo.Cc_Descripcion,'') as Ceco FROM Poliza_Detalle INNER JOIN Cuenta_Contable on Cuenta_Contable.Cc_Cve_Cuenta_Contable = Poliza_Detalle.Cc_Cve_Cuenta_Contable LEFT JOIN Centro_Costo on Centro_Costo.Cc_Cve_Centro_Costo = Poliza_Detalle.Pd_Centro_Costo WHERE Poliza_Detalle.Pl_Folio = '0000005141' SELECT * FROM Periodo_Operativo WHERE '2018-09-21' BETWEEN Pr_Fecha_Inicial AND Pr_Fecha_Final and Pr_Tipo = '00' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'GEN_VALIDAR_PERIODO_OPERATIVO' SELECT COUNT( DISTINCT Pd_Cve_Plantilla_Documento) as Docs FROM Plantilla_Documento WHERE Pd_Cve_Plantilla_Documento IN (SELECT Pd_Cve_Plantilla_Documento FROM Plantilla_Documento_Transaccion WHERE Pdt_Transaccion = 'CT002') SELECT ISNULL(MAX(Pl_Numero),0) as Pl_Numero From poliza Where Em_Cve_Empresa = '0001' AND Pl_Ejercicio = '2018' AND Pl_Periodo = '10' AND Pl_Tipo = '2' SELECT Cf_Tipo, Cf_Descripcion, Cf_Valor FROM Configuracion WHERE Cf_Variable = 'FTO_POLIZA' SELECT Em_Descripcion FROM Empresa Where Em_Cve_Empresa = '0001' AND Es_Cve_Estado <> 'BA' SELECT * FROM Poliza WHERE Pl_Folio = '0000005141' AND Es_Cve_Estado <> 'CA'