Customer - Payment Services /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 10:47:12.000 Quickvet MSACCESS ODBC Quickvet -1 Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER-1 STREAM_RESULTSY USE_POOLINGN Select Transaction FieldsTransform FieldsY Filter PaymentsFilter RefundsY Table inputSelect Transaction FieldsY Filter RefundsDummy (do nothing)Y Transform FieldsFilter PaymentsY Filter RefundsModified Java Script ValueY Filter CashCash PaymentY Filter CashFilter ChequeY Filter ChequeCheque PaymentY Filter EFTEFT PaymentY Filter PaymentsFilter CashY Filter Refund CashCash RefundY Filter Refund CashFilter Refund ChequeY Filter Refund ChequeCheque RefundY Filter Refund EFTEFT RefundY Modified Java Script ValueFilter Refund CashY Filter ChequeFilter EFTY Filter EFTCredit Card PaymentY Filter Refund ChequeFilter Refund EFTY Filter Refund EFTCredit Card RefundY Cash Payment OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountPaymentCash>amounttruefalseVISITID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseVISITID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCash>$valuefalsetruetrue1000 757 58 Y Cash Refund OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountRefundCash>amounttruefalseVISITID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseVISITID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCash>$valuefalsetruetrue1000 773 501 Y Cheque Payment OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountPaymentCheque>amounttruefalseVISITID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseVISITID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCheque>$valuefalsetruetrue1000 760 134 Y Cheque Refund OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountRefundCheque>amounttruefalseVISITID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseVISITID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCheque>$valuefalsetruetrue1000 772 575 Y Credit Card Payment OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountPaymentCredit>amounttruefalseVISITID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseVISITID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCredit>$valuefalsetruetrue1000 762 308 Y Credit Card Refund OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountRefundCredit>amounttruefalseVISITID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseVISITID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCredit>$valuefalsetruetrue1000 779 761 Y Dummy (do nothing) Dummy Y 1 none 438 653 Y EFT Payment OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountPaymentEFT>amounttruefalseVISITID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseVISITID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentEFT>$valuefalsetruetrue1000 763 228 Y EFT Refund OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDAMOUNT<act.customerAccountRefundEFT>amounttruefalseVISITID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseVISITID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundEFT>$valuefalsetruetrue1000 780 681 Y Filter Cash FilterRows Y 1 none Cash Payment Filter Cheque N TYPE CONTAINS constantStringCash-1-1N 539 57 Y Filter Cheque FilterRows N 1 none Cheque Payment Filter EFT N TYPE CONTAINS constantStringCheque-1-1N 538 139 Y Filter EFT FilterRows N 1 none EFT Payment Credit Card Payment N N TYPE CONTAINS constantStringEFT-1-1N 541 227 Y Filter Payments FilterRows N 1 none Filter Cash Filter Refunds N N AMOUNT > constantBigNumber0-1-1N N AND CLIENTID <> constantNumber0.0-1-1N 440 60 Y Filter Refund Cash FilterRows Y 1 none Cash Refund Filter Refund Cheque N TYPE CONTAINS constantStringCash-1-1N 659 500 Y Filter Refund Cheque FilterRows Y 1 none Cheque Refund Filter Refund EFT N TYPE CONTAINS constantStringCheque-1-1N 655 579 Y Filter Refund EFT FilterRows Y 1 none EFT Refund Credit Card Refund N N TYPE CONTAINS constantStringEFT-1-1N 656 680 Y Filter Refunds FilterRows Y 1 none Modified Java Script Value Dummy (do nothing) N N AMOUNT < constantBigNumber0-1-1N N AND CLIENTID <> constantNumber0.0-1-1N 436 499 Y Modified Java Script Value ScriptValueMod Y 1 none