Customer - Invoices Conversion /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 12:20:17.563 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 Invoices inputSelect Invoice FieldsY Transform Invoice FieldsFilter NullsY Select Invoice FieldsTransform Invoice FieldsY Split CreditsCustomer Invoice OutputY Split CreditsCustomer Credit OutputY Filter NullsSplit CreditsY Filter NullsDummy (do nothing)Y Customer Credit Output OpenVPMSLoaderPlugin N 1 none openvpmsINVOICENOTOTALCH<act.customerAccountChargesCredit>amounttruefalseSTATUS<act.customerAccountChargesCredit>statustruefalseDATE1<act.customerAccountChargesCredit>startTimetruefalseCLNUMBER<act.customerAccountChargesCredit>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseINVOICENO<act.customerAccountChargesCredit>customer[0]<participation.customer>acttrue<act.customerAccountChargesCredit>$valuefalsetruetrue 711 239 Y Customer Invoice Output OpenVPMSLoaderPlugin N 1 none openvpmsINVOICENOTOTALCH<act.customerAccountChargesInvoice>amounttruefalseSTATUS<act.customerAccountChargesInvoice>statustruefalseDATE1<act.customerAccountChargesInvoice>startTimetruefalseCLNUMBER<act.customerAccountChargesInvoice>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseINVOICENO<act.customerAccountChargesInvoice>customer[0]<participation.customer>acttrue<act.customerAccountChargesInvoice>$valuefalsetruetrue 710 134 Y Dummy (do nothing) Dummy Y 1 none 458 248 Y Filter Nulls FilterRows Y 1 none Split Credits Dummy (do nothing) N N CLNUMBER <> constantNumber0.0-1-1N N AND CLNUMBER IS NOT NULL N AND INVOICENO IS NOT NULL N AND INVOICENO <> constantNumber0.0-1-1N 455 136 Y Invoices input XBaseInput N 1 none F:\VETAID\INVOICES.DBF 0 N N N 81 135 Y Select Invoice Fields SelectValues Y 1 none CLNUMBER -2 -2 PETNUMBER -2 -2 INVOICENO -2 -2 DATE1 -2 -2 TOTALCH -2 -2 AMOUNTOWE -2 -2 COMPLETED -2 -2 202 135 Y Split Credits FilterRows Y 1 none Customer Invoice Output Customer Credit Output N TOTALCH >= constantNumber0.0-1-1N 554 135 Y Transform Invoice Fields ScriptValueMod Y 1 none