Invoice Lab 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 Lab MapperY Lab Items InputSelect Lab FieldsY Select Lab FieldsTransform Lab FieldsY Invoices inputSelect Invoice FieldsY Select Invoice FieldsFilter rowsY Transform Lab FieldsMerge JoinY Filter rowsDummy (do nothing)Y Filter rowsMerge JoinY Add sequence Sequence Y 1 none INVOICEITEMID N archetypes SEQ_ Y 1 1 9999999 598 218 Y Dummy (do nothing) Dummy Y 1 none 335 114 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 335 215 Y Invoice Lab 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 908 217 Y Invoices input XBaseInput N 1 none F:\VETAID\INVOICES.DBF 0 N N N 55 215 Y Lab Items Input XBaseInput Y 1 none F:\VETAID\CONLTEST.DBF 0 N N N 53 312 Y Merge Join MergeJoin N 1 none INNER Filter rows Transform Lab Fields INVOICENO INVOICENO 512 219 Y Modified Java Script Value ScriptValueMod Y 1 none