Customer - Payments
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Select Transaction FieldsTransform FieldsY Filter PaymentsPayment OutputY Filter PaymentsFilter RefundsY Table inputSelect Transaction FieldsY Filter RefundsDummy (do nothing)Y Transform FieldsFilter PaymentsY Filter RefundsModified Java Script ValueY Modified Java Script ValueRefund OutputY
Dummy (do nothing)
Dummy
Y
1
none
442
249
Y
Filter Payments
FilterRows
N
1
none
Payment Output
Filter Refunds
N
N
AMOUNT
>
constantBigNumber0-1-1N
N
AND
CLIENTID
<>
constantNumber0.0-1-1N
440
60
Y
Filter Refunds
FilterRows
Y
1
none
Modified Java Script Value
Dummy (do nothing)
N
N
AMOUNT
<
constantBigNumber0-1-1N
N
AND
CLIENTID
<>
constantNumber0.0-1-1N
438
143
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
AMOUNT.setNumber(abs(AMOUNT.getNumber()))
581
143
Y
Payment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsVISITIDDATE<act.customerAccountPayment>startTimetruefalseTRANSTAT<act.customerAccountPayment>statustruefalseAMOUNT<act.customerAccountPayment>amounttruefalseCLIENTID<act.customerAccountPayment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseVISITID<act.customerAccountPayment>customer[0]<participation.customer>acttrue<act.customerAccountPayment>$valuefalseCLIENTID<act.customerAccountPayment>till[0]<participation.till>entitytrue<party.organisationTill>1falseVISITID<act.customerAccountPayment>till[0]<participation.till>acttrue<act.customerAccountPayment>$valuefalsetruetrue1000
728
60
Y
Refund Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsVISITIDDATE<act.customerAccountRefund>startTimetruefalseTRANSTAT<act.customerAccountRefund>statustruefalseAMOUNT<act.customerAccountRefund>amounttruefalseCLIENTID<act.customerAccountRefund>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseVISITID<act.customerAccountRefund>customer[0]<participation.customer>acttrue<act.customerAccountRefund>$valuefalseCLIENTID<act.customerAccountRefund>till[0]<participation.till>entitytrue<party.organisationTill>1falseVISITID<act.customerAccountRefund>till[0]<participation.till>acttrue<act.customerAccountRefund>$valuefalsetruetrue1000
727
145
Y
Select Transaction Fields
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
AccountNumber
CLIENTID
-2
-2
Date
DATE
-2
-2
Amount Paid
AMOUNT
-2
-2
Comments
DESCRIPTION
-2
-2
Printed
PRINTED
-2
-2
203
55
Y
Table input
TableInput
Y
1
none
Quickvet
select * from invoice
0
N
N
96
56
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
TRANSTAT = "POSTED"
TRANSTAT
TRANSTAT
String
-1
-1
323
58
Y