Customer - Transactions /

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 Transform FieldsFilter InvoicesY Filter InvoicesInvoice OutputY Filter InvoicesFilter CreditsY Filter CreditsFilter PaymentsY Filter CreditsCredit OutputY Filter PaymentsPayment OutputY Filter PaymentsFilter RefundsY Filter RefundsRefund OutputY Table inputSelect Transaction FieldsY Filter RefundsDummy (do nothing)Y Credit Output OpenVPMSLoaderPlugin Y 1 none openvpmsTRANSIDDATE<act.customerAccountChargesCredit>startTimetruefalseTRANSTAT<act.customerAccountChargesCredit>statustruefalseAMOUNT<act.customerAccountChargesCredit>amounttruefalseTAXAMT<act.customerAccountChargesCredit>taxtruefalseREFERENCE<act.customerAccountChargesCredit>referencetruefalseDESCRIPTION<act.customerAccountChargesCredit>notestruefalseCLIENTID<act.customerAccountChargesCredit>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesCredit>customer[0]<participation.customer>acttrue<act.customerAccountChargesCredit>$valuefalsetruetrue1000 753 127 Y Dummy (do nothing) Dummy Y 1 none 468 406 Y Filter Credits FilterRows Y 1 none Credit Output Filter Payments N TYPE = constantInteger 2-10N 464 130 Y Filter Invoices FilterRows Y 1 none Invoice Output Filter Credits N TYPE = constantInteger 0-10N 465 57 Y Filter Payments FilterRows Y 1 none Payment Output Filter Refunds N TYPE = constantInteger 1-10N 465 214 Y Filter Refunds FilterRows Y 1 none Refund Output Dummy (do nothing) N TYPE = constantInteger 6-10N 468 310 Y Invoice Output OpenVPMSLoaderPlugin Y 1 none openvpmsTRANSIDDATE<act.customerAccountChargesInvoice>startTimetruefalseTRANSTAT<act.customerAccountChargesInvoice>statustruefalseAMOUNT<act.customerAccountChargesInvoice>amounttruefalseTAXAMT<act.customerAccountChargesInvoice>taxtruefalseREFERENCE<act.customerAccountChargesInvoice>referencetruefalseDESCRIPTION<act.customerAccountChargesInvoice>notestruefalseCLIENTID<act.customerAccountChargesInvoice>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesInvoice>customer[0]<participation.customer>acttrue<act.customerAccountChargesInvoice>$valuefalsetruetrue1000 750 56 Y Payment Output OpenVPMSLoaderPlugin Y 1 none openvpmsTRANSIDDATE<act.customerAccountPayment>startTimetruefalseTRANSTAT<act.customerAccountPayment>statustruefalseAMOUNT<act.customerAccountPayment>amounttruefalseREFERENCE<act.customerAccountPayment>referencetruefalseCLIENTID<act.customerAccountPayment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountPayment>customer[0]<participation.customer>acttrue<act.customerAccountPayment>$valuefalseCLIENTID<act.customerAccountPayment>till[0]<participation.till>entitytrue<party.organisationTill>1falseTRANSID<act.customerAccountPayment>till[0]<participation.till>acttrue<act.customerAccountPayment>$valuefalsetruetrue1000 754 216 Y Refund Output OpenVPMSLoaderPlugin Y 1 none openvpmsTRANSIDDATE<act.customerAccountRefund>startTimetruefalseTRANSTAT<act.customerAccountRefund>statustruefalseAMOUNT<act.customerAccountRefund>amounttruefalseREFERENCE<act.customerAccountRefund>referencetruefalseCLIENTID<act.customerAccountRefund>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountRefund>customer[0]<participation.customer>acttrue<act.customerAccountRefund>$valuefalseCLIENTID<act.customerAccountRefund>till[0]<participation.till>entitytrue<party.organisationTill>1falseTRANSID<act.customerAccountRefund>till[0]<participation.till>acttrue<act.customerAccountRefund>$valuefalsetruetrue1000 756 310 Y Select Transaction Fields SelectValues Y 1 none Visit Number VISITID -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 Date DATE -2 -2 Total Invoice AMOUNT -2 -2 Amount Paid RECEIVED -2 -2 Comments DESCRIPTION -2 -2 Printed PRINTED -2 -2 Tax TAXAMT -2 -2 Cash Payment CASH -2 -2 Credit Card Payment CREDIT -2 -2 Check Payment CHEQUE -2 -2 Debit Card Payment EFT -2 -2 Adjustment ADJUST -2 -2 Status STATUS -2 -2 Amount Tendered TENDERED -2 -2 213 55 Y Transform Fields ScriptValueMod Y 1 none