Customer - Invoice Items / YN
0.0 0.0 1000 1 1 N Y 5000 Y - 2007/06/03 14:20:22.718 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 Add sequenceTransform FieldsY Transform FieldsFilter rowsY Filter rowsDummy (do nothing)Y Transform InvoiceInvoice ServiceY Filter rowsFilter InvoicesY Filter InvoicesTransform InvoiceY Filter CreditsTransform CreditY Filter InvoicesFilter CounterY Filter CounterFilter CreditsY Filter CounterCounter ServiceY Filter CreditsDummy (do nothing) 2Y Transform CreditFilter Patient CreditsY Filter Patient CreditsCredit ServiceY Filter Patient CreditsPatient Credit ServiceY Drug InputSelect valuesY Select valuesTransform ID1Y Transform ID1Add sequenceY Procedure InputSelect values 2Y Select values 2Transform ID2Y Transform ID2Add sequenceY Stock InputSelect values 3Y Select values 3Transform ID3Y Transform ID3Add sequenceY Add sequence Sequence Y 1 none SERVICEID N SEQ_ Y 1 1 9999999 283 78 Y Counter Service OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCounterItem>startTimetruefalseUNITPRICE<act.customerAccountCounterItem>unitPricetruefalseTAXAMT<act.customerAccountCounterItem>taxtruefalseQUANTITY<act.customerAccountCounterItem>quantitytruefalsePRODUCTID<act.customerAccountCounterItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCounterItem>product[0]<participation.product>acttrue<act.customerAccountCounterItem>$valuefalseVISITID<actRelationship.customerAccountCounterItem>sourcetrue<act.customerAccountChargesCounter>$valuefalseSERVICEID<actRelationship.customerAccountCounterItem>targettrue<act.customerAccountCounterItem>$valuefalsetruetrue1000 951 159 Y Credit Service OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCreditItem>startTimetruefalseUNITPRICE<act.customerAccountCreditItem>unitPricetruefalseTAXAMT<act.customerAccountCreditItem>taxtruefalseQUANTITY<act.customerAccountCreditItem>quantitytruefalseDISCOUNT<act.customerAccountCreditItem>discounttruefalseID<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalsePRODUCTID<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalseVISITID<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalseSERVICEID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000 950 252 Y Drug Input TableInput Y 1 none Quickvet select * from invdrug 0 N N 19 76 Y Dummy (do nothing) Dummy Y 1 none 488 190 Y Dummy (do nothing) 2 Dummy Y 1 none 595 346 Y Filter Counter FilterRows N 1 none Counter Service Filter Credits N N UNITPRICE >= constantNumber0.0-1-1N N AND PATIENTID = constantNumber0.0-1-1N 592 160 Y Filter Credits FilterRows N 1 none Transform Credit Dummy (do nothing) 2 N N UNITPRICE < constantNumber0.0-1-1N 595 249 Y Filter Invoices FilterRows Y 1 none Transform Invoice Filter Counter N N UNITPRICE >= constantNumber0.0-1-1N N AND PATIENTID > constantNumber0.0-1-1N 592 79 Y Filter Patient Credits FilterRows Y 1 none Credit Service Patient Credit Service N PATIENTID = constantNumber0.0-1-1N 819 251 Y Filter rows FilterRows N 1 none Filter Invoices Dummy (do nothing) N N VISITID > constantNumber0.0-1-1N N AND ACCOUNTID > constantNumber0.0-1-1N N AND PRODUCTID IS NOT NULL 488 78 Y Invoice Service OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountInvoiceItem>startTimetruefalseUNITPRICE<act.customerAccountInvoiceItem>unitPricetruefalseTAXAMT<act.customerAccountInvoiceItem>taxtruefalseQUANTITY<act.customerAccountInvoiceItem>quantitytruefalseDISCOUNT<act.customerAccountInvoiceItem>discounttruefalseID<act.customerAccountInvoiceItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountInvoiceItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalsePRODUCTID<act.customerAccountInvoiceItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseVISITID<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseSERVICEID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000 950 82 Y Patient Credit Service OpenVPMSLoaderPlugin Y 1 none openvpmsSERVICEIDDATE<act.customerAccountCreditItem>startTimetruefalseUNITPRICE<act.customerAccountCreditItem>unitPricetruefalseTAXAMT<act.customerAccountCreditItem>taxtruefalseQUANTITY<act.customerAccountCreditItem>quantitytruefalseID<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseSERVICEID<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalsePRODUCTID<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalseSERVICEID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalseVISITID<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalseSERVICEID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000 953 365 Y Procedure Input TableInput Y 1 none Quickvet select * from invproc 0 N N 23 228 Y Select values SelectValues Y 1 none Visit Number VISITID -2 -2 Date DATE -2 -2 Drug Code PRODUCTID -2 -2 Qty QUANTITY -2 -2 Price UNITPRICE -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 Tax TAXAMT -2 -2 SubTotal TOTAL -2 -2 104 76 Y Select values 2 SelectValues Y 1 none Visit Number VISITID -2 -2 Date DATE -2 -2 Code PRODUCTID -2 -2 Qty QUANTITY -2 -2 Price UNITPRICE -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 Tax TAXAMT -2 -2 SubTotal TOTAL -2 -2 108 230 Y Select values 3 SelectValues Y 1 none Visit Number VISITID -2 -2 DATE -2 -2 Item Number PRODUCTID -2 -2 Qty QUANTITY -2 -2 Price UNITPRICE -2 -2 AccountNumber ACCOUNTID -2 -2 PetNumber PATIENTID -2 -2 Tax TAXAMT -2 -2 SubTotal TOTAL -2 -2 106 371 Y Stock Input TableInput Y 1 none Quickvet SELECT [Visit Number] , [Line Number] , [DATE] , [Item Number] , [DESCRIPTION] , Qty , Price , SubTotal , [Lot Number] , AccountNumber , PetNumber , Assisting , [Tax Rate] , Tax , [Inv Loc] , Completed FROM Invstock 0 N N 18 369 Y Transform Credit ScriptValueMod Y 1 none