Customer - Invoices /

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 Table inputSelect Transaction FieldsY Filter CreditsTransform CreditsY Transform CreditsCredit OutputY Filter CreditsFilter Counter salesY Filter Counter salesDummy (do nothing)Y Filter Counter salesCounter SalesY Counter Sales OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDDATE<act.customerAccountChargesCounter>startTimetruefalseTRANSTAT<act.customerAccountChargesCounter>statustruefalseAMOUNT<act.customerAccountChargesCounter>amounttruefalseTAXAMT<act.customerAccountChargesCounter>taxtruefalseCLIENTID<act.customerAccountChargesCounter>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseVISITID<act.customerAccountChargesCounter>customer[0]<participation.customer>acttrue<act.customerAccountChargesCounter>$valuefalsetruetrue1000 746 247 Y Credit Output OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDDATE<act.customerAccountChargesCredit>startTimetruefalseTRANSTAT<act.customerAccountChargesCredit>statustruefalseAMOUNT<act.customerAccountChargesCredit>amounttruefalseTAXAMT<act.customerAccountChargesCredit>taxtruefalseDESCRIPTION<act.customerAccountChargesCredit>notestruefalsePRINTED<act.customerAccountChargesCredit>printedtruefalseCLIENTID<act.customerAccountChargesCredit>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseVISITID<act.customerAccountChargesCredit>customer[0]<participation.customer>acttrue<act.customerAccountChargesCredit>$valuefalsetruetrue1000 748 143 Y Dummy (do nothing) Dummy Y 1 none 453 382 Y Filter Counter sales FilterRows Y 1 none Counter Sales Dummy (do nothing) N N CLIENTID <> constantNumber0.0-1-1N N AND PATIENTID = constantNumber0.0-1-1N N AND AMOUNT > constantNumber0.0-1-1N 453 247 Y Filter Credits FilterRows Y 1 none Transform Credits Filter Counter sales N N CLIENTID <> constantInteger 0-10N N AND AMOUNT < constantNumber0.0-1-1N 453 152 Y Filter Invoices FilterRows Y 1 none Invoice Output Filter Credits N N AMOUNT >= constantBigNumber0-1-1N N AND CLIENTID <> constantInteger 0-10N N AND PATIENTID <> constantInteger 0-10N 453 57 Y Invoice Output OpenVPMSLoaderPlugin Y 1 none openvpmsVISITIDDATE<act.customerAccountChargesInvoice>startTimetruefalseTRANSTAT<act.customerAccountChargesInvoice>statustruefalseAMOUNT<act.customerAccountChargesInvoice>amounttruefalseTAXAMT<act.customerAccountChargesInvoice>taxtruefalseDESCRIPTION<act.customerAccountChargesInvoice>notestruefalsePRINTED<act.customerAccountChargesInvoice>printedtruefalseCLIENTID<act.customerAccountChargesInvoice>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseVISITID<act.customerAccountChargesInvoice>customer[0]<participation.customer>acttrue<act.customerAccountChargesInvoice>$valuefalsetruetrue1000 749 56 Y Select Transaction Fields SelectValues Y 1 none Visit Number VISITID -2 -2 AccountNumber CLIENTID -2 -2 Date DATE -2 -2 Total Invoice AMOUNT -2 -2 Printed PRINTED -2 -2 Status STATUS -2 -2 Tax TAXAMT -2 -2 Comments DESCRIPTION -2 -2 PetNumber PATIENTID -2 -2 204 54 Y Table input TableInput Y 1 none Quickvet select * from invoice 0 N N 96 55 Y Transform Credits ScriptValueMod Y 1 none