Customer - Invoices /

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 InvoicesInvoice ItemsY Add sequenceTransform FieldsY Transform FieldsFilter InvoicesY Filter Patient CreditsPatient Credit ItemsY Table inputSelect valuesY Select valuesAdd sequenceY Filter InvoicesFilter Counter SalesY Filter Counter SalesFilter Patient CreditsY Filter Counter SalesCounter ItemsY Filter Patient CreditsFilter CreditsY Filter CreditsDummy (do nothing)Y Filter CreditsCredit ItemsY Add sequence Sequence Y 1 none SERVICEID N SEQ_ Y 1 1 9999999 186 73 Y Counter Items OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCounterItem>startTimetruefalseAMOUNT<act.customerAccountCounterItem>unitPricetruefalseTAXAMT<act.customerAccountCounterItem>taxtruefalseDISPFEE<act.customerAccountCounterItem>fixedPricetruefalseQTY<act.customerAccountCounterItem>quantitytruefalseITEM<act.customerAccountCounterItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCounterItem>product[0]<participation.product>acttrue<act.customerAccountCounterItem>$valuefalseTRANSID<actRelationship.customerAccountCounterItem>sourcetrue<act.customerAccountChargesCounter>$valuefalseSERVICEID<actRelationship.customerAccountCounterItem>targettrue<act.customerAccountCounterItem>$valuefalsetruetrue1000 616 153 Y Credit Items OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCreditItem>startTimetruefalseAMOUNT<act.customerAccountCreditItem>unitPricetruefalseTAXAMT<act.customerAccountCreditItem>taxtruefalseDISPFEE<act.customerAccountCreditItem>fixedPricetruefalseQTY<act.customerAccountCreditItem>quantitytruefalseITEM<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalseDOCTOR<act.customerAccountCreditItem>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseSERVICEID<act.customerAccountCreditItem>clinician[0]<participation.clinician>acttrue<act.customerAccountCreditItem>$valuefalseTRANSID<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalseSERVICEID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000 620 335 Y Dummy (do nothing) Dummy Y 1 none 370 418 Y Filter Counter Sales FilterRows N 1 none Counter Items Filter Patient Credits N N TRANTYPE >= constantInteger 100-10N N AND PATIENTID = constantInteger-1-10N N AND TRANAMOUNT >= constantBigNumber0.0-1-1N 371 154 Y Filter Credits FilterRows N 1 none Credit Items Dummy (do nothing) N N TRANTYPE >= constantInteger 100-10N N AND TRANAMOUNT < constantBigNumber0.0-1-1N N AND PATIENTID = constantInteger-1-10N 371 335 Y Filter Invoices FilterRows Y 1 none Invoice Items Filter Counter Sales N N TRANTYPE >= constantInteger 100-10N N AND PATIENTID <> constantInteger-1-10N N AND TRANAMOUNT >= constantBigNumber0.0-1-1N 371 76 Y Filter Patient Credits FilterRows N 1 none Patient Credit Items Filter Credits N N TRANTYPE >= constantInteger 100-10N N AND TRANAMOUNT < constantBigNumber0.0-1-1N N AND PATIENTID <> constantInteger-1-10N 369 242 Y Invoice Items OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountInvoiceItem>startTimetruefalseAMOUNT<act.customerAccountInvoiceItem>unitPricetruefalseTAXAMT<act.customerAccountInvoiceItem>taxtruefalseDISPFEE<act.customerAccountInvoiceItem>fixedPricetruefalseQTY<act.customerAccountInvoiceItem>quantitytruefalsePATIENTID<act.customerAccountInvoiceItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountInvoiceItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalseITEM<act.customerAccountInvoiceItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseDOCTOR<act.customerAccountInvoiceItem>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseSERVICEID<act.customerAccountInvoiceItem>clinician[0]<participation.clinician>acttrue<act.customerAccountInvoiceItem>$valuefalseTRANSID<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseSERVICEID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000 616 75 Y Patient Credit Items OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCreditItem>startTimetruefalseAMOUNT<act.customerAccountCreditItem>unitPricetruefalseTAXAMT<act.customerAccountCreditItem>taxtruefalseDISPFEE<act.customerAccountCreditItem>fixedPricetruefalseQTY<act.customerAccountCreditItem>quantitytruefalsePATIENTID<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalseITEM<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalseDOCTOR<act.customerAccountCreditItem>clinician[0]<participation.clinician>entitytrue<security.user>$valuefalseSERVICEID<act.customerAccountCreditItem>clinician[0]<participation.clinician>acttrue<act.customerAccountCreditItem>$valuefalseTRANSID<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalseSERVICEID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000 618 239 Y Select values SelectValues Y 1 none Client Number CLIENTID -2 -2 Patient Number PATIENTID -2 -2 Transaction Number TRANSID -2 -2 Transaction Type TRANTYPE -2 -2 Incomplete Status STATUS -2 -2 Consultation Date DATE -2 -2 Consulting Vet DOCTOR -2 -2 Item Code ITEM -2 -2 Item Service Cost Price FIXEDCOST -2 -2 Item Service Sale Price FIXEDSALE -2 -2 Item Service Tax FIXEDTAX -2 -2 Item Component Number QTY -2 -2 Item Component Cost Price COMPCOST -2 -2 Item Component Sale Price COMPSALE -2 -2 Item Component Tax COMPTAX -2 -2 Item Service Unit Price FIXEDPRICE -2 -2 Item Component Unit Price UNITPRICE -2 -2 Transaction Amount TRANAMOUNT -2 -2 103 73 Y Table input TableInput Y 1 none RxWorks SELECT * FROM (Visit INNER JOIN (Consultation INNER JOIN [Consultation Item] ON Consultation.[Consultation Number] = [Consultation Item].[Consultation Number]) ON Visit.[Visit Number] = Consultation.[Visit Number]) INNER JOIN [Transaction] ON Visit.[Visit Number] = Transaction.[Visit Number] 0 N N 32 74 Y Transform Fields ScriptValueMod Y 1 none