Invoice Procedure 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 PORT_NUMBER3306 Merge JoinAdd sequenceY Add sequenceSelect valuesY Select valuesModified Java Script ValueY Modified Java Script ValueInvoice Procedure MapperY Procedures InputSelect Procedure ItemsY Select Procedure ItemsTransform ProcedureY Invoices inputSelect Invoice FieldsY Select Invoice FieldsFilter rowsY Transform ProcedureMerge JoinY Filter rowsMerge JoinY Filter rowsDummy (do nothing)Y Add sequence Sequence Y 1 none INVOICEITEMID N archetypes SEQ_ Y 1 1 9999999 598 218 Y Dummy (do nothing) Dummy Y 1 none 319 139 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 N AND INVOICENO <> constantNumber0.0-1-1N N AND TOTALCH >= constantNumber0.0-1-1N 319 218 Y Invoice Procedure Mapper OpenVPMSLoaderPlugin Y 1 none openvpmsINVOICEITEMIDSTARTDATE<act.customerAccountInvoiceItem>startTimefalsefalseQUANTITY<act.customerAccountInvoiceItem>quantitytruefalseUNITPRICE<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.service>$valuefalseINVOICEITEMID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseINVOICENO<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseINVOICEITEMID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000 920 215 Y Invoices input XBaseInput N 1 none F:\VETAID\INVOICES.DBF 0 N N N 55 215 Y Merge Join MergeJoin N 1 none INNER Filter rows Transform Procedure INVOICENO INVOICENO 512 219 Y Modified Java Script Value ScriptValueMod Y 1 none