SELECT paymentRequest.idPaymentRequest, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= GROUP BY paymentRequest.idEmployee SELECT paymentRequest.idPaymentRequest, paymentRequest.dateRegistered AS PRDate, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= AND paymentRequest.idEmployee= ORDER BY paymentRequestStateHistory.idPaymentRequestState, paymentRequest.idPaymentRequest gerentes: Sending mail to #listPL.email#
ID Fecha Proyecto Proveedor N° de factura Concepto Fecha de factura Monto Estado
#listPR_PL.idPaymentRequest# #LSDateFormat(listPR_PL.PRDate, application.dateFormat)# #listPR_PL.project# #listPR_PL.provider# #listPR_PL.billNumber# #listPR_PL.billConcept# #LSDateFormat(listPR_PL.billDate, application.dateFormat)#  #LSCurrencyFormat(listPR_PL.amount)# #listPR_PL.currency# #listPR_PL.paymentRequestState#
#LSDateFormat(listPR_PL.dateRegistered)# #LSTimeFormat(listPR_PL.dateRegistered, "HH:mm")#
SELECT paymentRequest.idPaymentRequest, paymentRequest.dateRegistered AS PRDate, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= AND paymentRequestStateHistory.idPaymentRequestState = ORDER BY paymentRequestStateHistory.idPaymentRequestState, paymentRequest.idPaymentRequest Tesorero: Sending mail to #_mailTo#
ID Fecha Creador Proyecto Proveedor N° de factura Concepto Fecha de factura Monto Estado
#listPR_TR.idPaymentRequest# #LSDateFormat(listPR_TR.PRDate, application.dateFormat)# #listPR_TR.employee# #listPR_TR.project# #listPR_TR.provider# #listPR_TR.billNumber# #listPR_TR.billConcept# #LSDateFormat(listPR_TR.billDate, application.dateFormat)#  #LSCurrencyFormat(listPR_TR.amount)# #listPR_TR.currency# #listPR_TR.paymentRequestState#
#LSDateFormat(listPR_TR.dateRegistered)# #LSTimeFormat(listPR_TR.dateRegistered, "HH:mm")#
SELECT paymentRequest.idPaymentRequest, paymentRequest.dateRegistered AS PRDate, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= AND paymentRequestStateHistory.idPaymentRequestState= ORDER BY paymentRequestStateHistory.idPaymentRequestState, paymentRequest.idPaymentRequest Direccion: Sending mail to #_mailTo#
ID Fecha Creador Proyecto Proveedor N° de factura Concepto Fecha de factura Monto Estado
#listPR_DR.idPaymentRequest# #LSDateFormat(listPR_DR.PRDate, application.dateFormat)# #listPR_DR.employee# #listPR_DR.project# #listPR_DR.provider# #listPR_DR.billNumber# #listPR_DR.billConcept# #LSDateFormat(listPR_DR.billDate, application.dateFormat)#  #LSCurrencyFormat(listPR_DR.amount)# #listPR_DR.currency# #listPR_DR.paymentRequestState#
#LSDateFormat(listPR_DR.dateRegistered)# #LSTimeFormat(listPR_DR.dateRegistered, "HH:mm")#
SELECT paymentRequest.idPaymentRequest, paymentRequest.dateRegistered AS PRDate, paymentRequestState.name AS paymentRequestState, paymentRequest.idEmployee, CONCAT(TRIM(CONCAT(employee.nameFirst, " ", employee.nameFirst1)), " ", TRIM(CONCAT(employee.nameLast, " ", employee.nameLast1))) AS employee, employeeData.email, project.name AS project, provider.name AS provider, paymentRequest.dateRegistered, paymentRequest.billNumber, paymentRequest.billConcept, paymentRequest.billDate, paymentRequest.amountNoTax, paymentRequest.amountTaxToPay, paymentRequest.amountTaxToHold1, paymentRequest.amountTaxToHold2, paymentRequest.amount, currency.name AS currency FROM paymentRequestStateHistory LEFT JOIN paymentRequest ON paymentRequestStateHistory.idPaymentRequest=paymentRequest.idPaymentRequest LEFT JOIN paymentRequestState ON paymentRequestStateHistory.idPaymentRequestState=paymentRequestState.idPaymentRequestState LEFT JOIN employee ON paymentRequest.idEmployee=employee.idEmployee LEFT JOIN employeeData ON employee.idEmployee=employeeData.idEmployee LEFT JOIN project ON paymentRequest.idProject=project.idProject LEFT JOIN provider ON paymentRequest.idProvider=provider.idProvider LEFT JOIN currency ON paymentRequest.idCurrency=currency.idCurrency WHERE CAST(paymentRequestStateHistory.dateRegistered AS DATE)= AND paymentRequestStateHistory.idPaymentRequestState = ORDER BY paymentRequestStateHistory.idPaymentRequestState, paymentRequest.idPaymentRequest Tesorero: Sending mail to #_mailTo#
ID Fecha Creador Proyecto Proveedor N° de factura Concepto Fecha de factura Monto Estado
#listPR_TR.idPaymentRequest# #LSDateFormat(listPR_TR.PRDate, application.dateFormat)# #listPR_TR.employee# #listPR_TR.project# #listPR_TR.provider# #listPR_TR.billNumber# #listPR_TR.billConcept# #LSDateFormat(listPR_TR.billDate, application.dateFormat)#  #LSCurrencyFormat(listPR_TR.amount)# #listPR_TR.currency# #listPR_TR.paymentRequestState#
#LSDateFormat(listPR_TR.dateRegistered)# #LSTimeFormat(listPR_TR.dateRegistered, "HH:mm")#