Invoice Service 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 Modified Java Script ValueInvoice Service MapperY Service Items InputSelect Service FieldsY Invoices inputSelect Invoice FieldsY Select Invoice FieldsFilter rowsY Transform Service ItemsMerge JoinY Filter rowsDummy (do nothing)Y Filter rowsMerge JoinY Add sequenceSelect valuesY Select valuesModified Java Script ValueY Select Service FieldsFilter rows 2Y Filter rows 2Transform Service ItemsY Filter rows 2Dummy (do nothing) 2Y Add sequence Sequence Y 1 none INVOICEITEMID N archetypes SEQ_ Y 1 1 9999999 596 216 Y Dummy (do nothing) Dummy Y 1 none 324 133 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 TOTALCH >= constantNumber0.0-1-1N 324 215 Y Invoice Service Mapper 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.service>$valuefalseINVOICEITEMID<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalseINVOICENO<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalseINVOICEITEMID<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000 911 214 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 Service Items INVOICENO INVOICENO 512 216 Y Modified Java Script Value ScriptValueMod Y 1 none