Customer - Payments /

YN 0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:20:22.718 RxWorks MSACCESS ODBC RxWorks -1 Encrypted EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER-1 STREAM_RESULTSY USE_POOLINGN Filter PaymentsFilter RefundsY Filter RefundsDummy (do nothing)Y Add sequenceTransform FieldsY Filter PaymentsFilter CashY Filter CashCash PaymentY Filter CashFilter ChequeY Filter ChequeFilter Credit CardY Filter Credit CardCredit Card PaymentY Filter Credit CardFilter EFTY Filter EFTEFT PaymentY Filter EFTFilter DiscountY Filter Refund CashCash RefundY Filter Refund CashFilter Refund ChequeY Filter Refund ChequeFilter Refund Credit CardY Filter Refund Credit CardCredit Card RefundY Filter Refund Credit CardFilter Refund EFTY Filter Refund EFTEFT RefundY Filter RefundsFilter Refund CashY Filter Refund EFTInvalid RefundY Filter Refund ChequeCheque RefundY Filter ChequeCheque PaymentY Filter DiscountDiscount PaymentY Filter DiscountInvalid PaymentY Transform FieldsFilter PaymentsY Table inputSelect valuesY Select valuesAdd sequenceY Add sequence Sequence Y 1 none SERVICEID N SEQ_ Y 1 1 9999999 167 73 Y Cash Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountPaymentCash>startTimetruefalseAMOUNT<act.customerAccountPaymentCash>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCash>$valuefalsetruetrue1000 717 78 Y Cash Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountRefundCash>startTimetruefalseAMOUNT<act.customerAccountRefundCash>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCash>$valuefalsetruetrue1000 733 527 Y Cheque Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountPaymentCheque>startTimetruefalseAMOUNT<act.customerAccountPaymentCheque>amounttruefalseNAME<act.customerAccountPaymentCheque>banktruefalseREFERENCE<act.customerAccountPaymentCheque>bsbtruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCheque>$valuefalsetruetrue1000 718 167 Y Cheque Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountRefundCheque>startTimetruefalseAMOUNT<act.customerAccountRefundCheque>amounttruefalseNAME<act.customerAccountRefundCheque>banktruefalseREFERENCE<act.customerAccountRefundCheque>bsbtruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCheque>$valuefalsetruetrue1000 734 596 Y Credit Card Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountPaymentCredit>startTimetruefalseAMOUNT<act.customerAccountPaymentCredit>amounttruefalseNAME<act.customerAccountPaymentCredit>creditCardtruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentCredit>$valuefalsetruetrue1000 718 238 Y Credit Card Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountRefundCredit>startTimetruefalseAMOUNT<act.customerAccountRefundCredit>amounttruefalseNAME<act.customerAccountRefundCredit>creditCardtruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundCredit>$valuefalsetruetrue1000 735 667 Y Discount Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountPaymentDiscount>startTimetruefalseAMOUNT<act.customerAccountPaymentDiscount>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentDiscount>$valuefalsetruetrue1000 722 406 Y Dummy (do nothing) Dummy Y 1 none 358 646 Y EFT Payment OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDAMOUNT<act.customerAccountPaymentEFT>amounttruefalseTRANSID<actRelationship.customerAccountPaymentItem>sourcetrue<act.customerAccountPayment>$valuefalseSERVICEID<actRelationship.customerAccountPaymentItem>targettrue<act.customerAccountPaymentEFT>$valuefalseDATE<act.customerAccountPaymentEFT>startTimetruefalsetruetrue1000 718 320 Y EFT Refund OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountRefundEFT>startTimetruefalseAMOUNT<act.customerAccountRefundEFT>amounttruefalseTRANSID<actRelationship.customerAccountRefundItem>sourcetrue<act.customerAccountRefund>$valuefalseSERVICEID<actRelationship.customerAccountRefundItem>targettrue<act.customerAccountRefundEFT>$valuefalsetruetrue1000 737 740 Y Filter Cash FilterRows Y 1 none Cash Payment Filter Cheque N TRANTYPE = constantInteger 1-10N 510 76 Y Filter Cheque FilterRows Y 1 none Cheque Payment Filter Credit Card N TRANTYPE = constantInteger 7-10N 511 165 Y Filter Credit Card FilterRows Y 1 none Credit Card Payment Filter EFT N N TRANTYPE = constantInteger 9-10N 512 238 Y Filter Discount FilterRows Y 1 none Discount Payment Invalid Payment N N TRANTYPE = constantInteger 5-10N 507 405 Y Filter EFT FilterRows Y 1 none EFT Payment Filter Discount N N TRANTYPE = constantInteger 8-10N 509 320 Y Filter Payments FilterRows Y 1 none Filter Cash Filter Refunds N N N OLDAMOUNT >= constantNumber0.0-1-1N N AND N TRANTYPE = constantInteger 1-10N N OR TRANTYPE = constantInteger 5-10N N OR TRANTYPE = constantInteger 7-10N N OR TRANTYPE = constantInteger 8-10N N OR TRANTYPE = constantInteger 9-10N N OR TRANTYPE = constantInteger 10-10N 364 75 Y Filter Refund Cash FilterRows Y 1 none Cash Refund Filter Refund Cheque N TRANTYPE = constantInteger 1-10N 515 526 Y Filter Refund Cheque FilterRows Y 1 none Cheque Refund Filter Refund Credit Card N TRANTYPE = constantInteger 7-10N 511 600 Y Filter Refund Credit Card FilterRows Y 1 none Credit Card Refund Filter Refund EFT N N TRANTYPE = constantInteger 9-10N 514 669 Y Filter Refund EFT FilterRows Y 1 none EFT Refund Invalid Refund N N TRANTYPE = constantInteger 8-10N 511 741 Y Filter Refunds FilterRows Y 1 none Filter Refund Cash Dummy (do nothing) N N OLDAMOUNT < constantNumber0.0-1-1N N AND N TRANTYPE = constantInteger 1-10N N OR TRANTYPE = constantInteger 5-10N N OR TRANTYPE = constantInteger 7-10N N OR TRANTYPE = constantInteger 8-10N N OR TRANTYPE = constantInteger 9-10N N OR TRANTYPE = constantInteger 10-10N 360 524 Y Invalid Payment Dummy Y 1 none 506 469 Y Invalid Refund Dummy Y 1 none 512 821 Y Select values SelectValues Y 1 none Transaction Number TRANSID -2 -2 Transaction Date DATE -2 -2 Transaction Amount AMOUNT -2 -2 Transaction Type TRANTYPE -2 -2 Bank Reference REFERENCE -2 -2 Bank Name NAME -2 -2 97 74 Y Table input TableInput Y 1 none RxWorks select * from Transactions 0 N N 27 74 Y Transform Fields ScriptValueMod Y 1 none