Customer - Invoice Drug Items Conversion /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 11:52:22.354 archetypes MYSQL Native openvpms 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN conversion localhost MYSQL Native conversion 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN openvpms localhost MYSQL Native openvpms 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN Merge JoinAdd sequenceY Add sequenceSelect valuesY Drug Items InputSelect Drug ItemsY Select Drug ItemsTransform Drug ItemsY Invoices inputSelect Invoice FieldsY Select Invoice FieldsFilter rowsY Transform Drug ItemsMerge JoinY Filter rowsMerge JoinY Filter rowsDummy (do nothing)Y Select valuesTransform Invoice ItemsY Transform Invoice ItemsSplit CreditsY Split CreditsInvoice Drug ItemsY Split CreditsCredit Drug ItemsY Add sequence Sequence Y 1 none INVOICEITEMID N archetypes SEQ_ Y 1 1 9999999 472 218 Y Credit Drug Items OpenVPMSLoaderPlugin Y 1 none openvpmsINVOICEITEMIDSTARTDATE<act.customerAccountInvoiceItem>startTimefalsefalseQUANTITY<act.customerAccountCreditItem>quantitytruefalseFIXEDPRICE<act.customerAccountCreditItem>fixedPricetruefalseUNITPRICE<act.customerAccountCreditItem>unitPricetruefalseTAX<act.customerAccountCreditItem>taxtruefalsePETNUMBER<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseINVOICEITEMID<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalsePRODUCTID<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.medication>$valuefalseINVOICEITEMID<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseINVOICENO<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseINVOICEITEMID<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountInvoiceItem>$valuefalsefalsetrue1000 878 312 Y Drug Items Input XBaseInput Y 1 none F:\VETAID\INVCLNT.DBF 0 N N N 41 325 Y Dummy (do nothing) Dummy Y 1 none 273 110 Y Filter rows FilterRows Y 1 none Merge Join Dummy (do nothing) N N CLNUMBER <> constantString0.0-1-1N N AND PETNUMBER <> constantString0.0-1-1N N AND CLNUMBER IS NOT NULL N AND PETNUMBER IS NOT NULL N AND INVOICENO IS NOT NULL 274 216 Y Invoice Drug Items OpenVPMSLoaderPlugin Y 1 none openvpmsINVOICEITEMIDSTARTDATE<act.customerAccountInvoiceItem>startTimefalsefalseQUANTITY<act.customerAccountInvoiceItem>quantitytruefalseFIXEDPRICE<act.customerAccountInvoiceItem>fixedPricetruefalseUNITPRICE<act.customerAccountInvoiceItem>unitPricetruefalseTAX<act.customerAccountInvoiceItem>taxtruefalsePETNUMBER<act.customerAccountInvoiceItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalseINVOICEITEMID<act.customerAccountInvoiceItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalsePRODUCTID<act.customerAccountInvoiceItem>product[0]<participation.product>entitytrue<product.medication>$valuefalseINVOICEITEMID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseINVOICENO<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseINVOICEITEMID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsefalsetrue1000 876 217 Y Invoices input XBaseInput N 1 none F:\VETAID\INVOICES.DBF 0 N N N 44 216 Y Merge Join MergeJoin N 1 none INNER Filter rows Transform Drug Items INVOICENO INVOICENO 392 219 Y Select Drug Items SelectValues Y 1 none INVOICENO -2 -2 INVENTNO -2 -2 INVAMT QUANTITY -2 -2 INVCOST -2 -2 FEES FIXEDPRICE -2 -2 TAX -2 -2 INVENTNO PRODUCTID String 20 -2 156 327 Y Select Invoice Fields SelectValues Y 1 none CLNUMBER -2 -2 PETNUMBER -2 -2 INVOICENO -2 -2 DATE1 STARTDATE -2 -2 141 215 Y Select values SelectValues Y 1 none CLNUMBER -2 -2 PETNUMBER -2 -2 INVOICENO -2 -2 STARTDATE -2 -2 PRODUCTID -2 -2 QUANTITY -2 -2 UNITPRICE -2 -2 FIXEDPRICE -2 -2 TAX -2 -2 INVOICEITEMID -2 -2 CLNUMBER - 6 0 PETNUMBER - 6 0 INVOICENO - 6 0 STARTDATE - -2 -2 PRODUCTID - 6 0 QUANTITY - 8 2 UNITPRICE - 8 2 FIXEDPRICE - 8 2 TAX - 8 2 INVOICEITEMID String 20 0 551 217 Y Split Credits FilterRows Y 1 none Invoice Drug Items Credit Drug Items N UNITPRICE >= constantNumber0.0-1-1N 742 219 Y Transform Drug Items ScriptValueMod Y 1 none