Receipt 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 Receipts InputSelect Receipt FieldsY Transform Receipt FieldsFilter rowsY Filter rowsReceipt OutputY Filter rowsRefund OutputY Select Receipt FieldsFilter Null ClientsY Filter Null ClientsTransform Receipt FieldsY Filter Null ClientsDummy (do nothing)Y Filter rows FilterRows Y 1 none Receipt Output Refund Output N AMOUNT >= constantNumber0.0-1-1N 521 137 Y Receipt Output OpenVPMSLoaderPlugin N 1 none openvpmsRECEIPTNOSTATUS<act.customerAccountPayment>statusfalsefalseRECDATE<act.customerAccountPayment>startTimefalsefalseAMOUNT<act.customerAccountPayment>amountfalsefalseCLNUMBER<act.customerAccountPayment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseRECEIPTNO<act.customerAccountPayment>customer[0]<participation.customer>acttrue<act.customerAccountPayment>$valuefalseCLINIC<act.customerAccountPayment>till[0]<participation.till>entitytrue<party.organisationTill>$valuefalseRECEIPTNO<act.customerAccountPayment>till[0]<participation.till>acttrue<act.customerAccountPayment>$valuefalsetruetrue1000 655 140 Y Receipts Input XBaseInput N 1 none F:\VETAID\RECEIPT.DBF 0 N N N 87 135 Y Refund Output OpenVPMSLoaderPlugin N 1 none openvpmsRECEIPTNOSTATUS<act.customerAccountRefund>statusfalsefalseRECDATE<act.customerAccountRefund>startTimefalsefalseAMOUNT<act.customerAccountRefund>amountfalsefalseCLNUMBER<act.customerAccountRefund>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseRECEIPTNO<act.customerAccountRefund>customer[0]<participation.customer>acttrue<act.customerAccountRefund>$valuefalseCLINIC<act.customerAccountRefund>till[0]<participation.till>entitytrue<party.organisationTill>$valuefalseRECEIPTNO<act.customerAccountRefund>till[0]<participation.till>acttrue<act.customerAccountRefund>$valuefalsetruetrue1000 654 231 Y Select Receipt Fields SelectValues Y 1 none CLNUMBER -2 -2 INVOICENO -2 -2 RECEIPTNO -2 -2 RECDATE -2 -2 AMOUNT -2 -2 TYPE -2 -2 CLINIC -2 -2 CLNUMBER - 6 0 INVOICENO - 6 0 RECEIPTNO - 6 0 RECDATE - -2 -2 AMOUNT - 8 2 TYPE - 1 -2 CLINIC - 1 -2 181 133 Y Transform Receipt Fields ScriptValueMod Y 1 none