Customer - Transactions
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
RxWorks
MSACCESS
ODBC
RxWorks
-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 Transform FieldsFilter InvoicesY Filter InvoicesInvoice OutputY Filter CreditsFilter PaymentsY Filter CreditsCredit OutputY Filter PaymentsPayment OutputY Filter PaymentsFilter RefundsY Filter RefundsRefund OutputY Filter RefundsFilter DebitY Filter DebitDebit OutputY Filter DebitFilter CreditY Filter CreditCredit Adj OutputY Filter CreditFilter InitY Filter InitFilter BadY Filter BadBad OutputY Table inputSelect Transaction FieldsY Filter BadDummy (do nothing)Y Filter InitInit OutputY Filter InvoicesFilter Counter SalesY Filter Counter SalesFilter CreditsY Filter Counter SalesCounter SalesY
Bad Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountBadDebt>startTimetruefalseTRANSTAT<act.customerAccountBadDebt>statustruefalseAMOUNT<act.customerAccountBadDebt>amounttruefalseTAXAMT<act.customerAccountBadDebt>taxtruefalseREFERENCE<act.customerAccountBadDebt>referencetruefalseDESCRIPTION<act.customerAccountDebitAdjust>notesfalsefalseCLIENTID<act.customerAccountBadDebt>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountBadDebt>customer[0]<participation.customer>acttrue<act.customerAccountBadDebt>$valuefalsetruetrue1000
764
627
Y
Counter Sales
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountChargesCounter>startTimetruefalseTRANSTAT<act.customerAccountChargesCounter>statustruefalseAMOUNT<act.customerAccountChargesCounter>amounttruefalseTAXAMT<act.customerAccountChargesCounter>taxtruefalseCLIENTID<act.customerAccountChargesCounter>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesCounter>customer[0]<participation.customer>acttrue<act.customerAccountChargesCounter>$valuefalsetruetrue1000
753
122
Y
Credit Adj Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountCreditAdjust>startTimetruefalseTRANSTAT<act.customerAccountCreditAdjust>statustruefalseAMOUNT<act.customerAccountCreditAdjust>amounttruefalseTAXAMT<act.customerAccountCreditAdjust>taxtruefalseREFERENCE<act.customerAccountCreditAdjust>referencetruefalseDESCRIPTION<act.customerAccountDebitAdjust>notesfalsefalseCLIENTID<act.customerAccountCreditAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountCreditAdjust>customer[0]<participation.customer>acttrue<act.customerAccountCreditAdjust>$valuefalsetruetrue1000
763
482
Y
Credit Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountChargesCredit>startTimetruefalseTRANSTAT<act.customerAccountChargesCredit>statustruefalseAMOUNT<act.customerAccountChargesCredit>amounttruefalseTAXAMT<act.customerAccountChargesCredit>taxtruefalseREFERENCE<act.customerAccountChargesCredit>referencetruefalseDESCRIPTION<act.customerAccountChargesCredit>notestruefalseCLIENTID<act.customerAccountChargesCredit>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesCredit>customer[0]<participation.customer>acttrue<act.customerAccountChargesCredit>$valuefalsetruetrue1000
755
189
Y
Debit Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountDebitAdjust>startTimetruefalseTRANSTAT<act.customerAccountDebitAdjust>statustruefalseAMOUNT<act.customerAccountDebitAdjust>amounttruefalseTAXAMT<act.customerAccountDebitAdjust>taxtruefalseREFERENCE<act.customerAccountDebitAdjust>referencetruefalseDESCRIPTION<act.customerAccountDebitAdjust>notesfalsefalseCLIENTID<act.customerAccountDebitAdjust>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountDebitAdjust>customer[0]<participation.customer>acttrue<act.customerAccountDebitAdjust>$valuefalsetruetrue1000
760
414
Y
Dummy (do nothing)
Dummy
Y
1
none
467
721
Y
Filter Bad
FilterRows
Y
1
none
Bad Output
Dummy (do nothing)
N
TYPE
=
constantInteger 6-10N
469
624
Y
Filter Counter Sales
FilterRows
N
1
none
Counter Sales
Filter Credits
N
N
TYPE
>=
constantInteger 100-10N
N
AND
OLDAMOUNT
>=
constantBigNumber0-1-1N
N
AND
PATIENTID
=
constantInteger-1-10N
469
122
Y
Filter Credit
FilterRows
Y
1
none
Credit Adj Output
Filter Init
N
N
OLDAMOUNT
<
constantNumber0.0-1-1N
N
AND
N
TYPE
=
constantInteger 12-10N
N
OR
TYPE
=
constantInteger 13-10N
N
OR
TYPE
=
constantInteger 14-10N
N
OR
TYPE
=
constantInteger 15-10N
N
OR
TYPE
=
constantInteger 16-10N
469
483
Y
Filter Credits
FilterRows
Y
1
none
Credit Output
Filter Payments
N
N
TYPE
>=
constantInteger 100-10N
N
AND
OLDAMOUNT
<
constantBigNumber0.00-1-1N
468
190
Y
Filter Debit
FilterRows
Y
1
none
Debit Output
Filter Credit
N
N
OLDAMOUNT
>=
constantNumber0.0-1-1N
N
AND
N
TYPE
=
constantInteger 12-10N
N
OR
TYPE
=
constantInteger 13-10N
N
OR
TYPE
=
constantInteger 14-10N
N
OR
TYPE
=
constantInteger 15-10N
N
OR
TYPE
=
constantInteger 16-10N
469
415
Y
Filter Init
FilterRows
Y
1
none
Init Output
Filter Bad
N
N
AND
TYPE
=
constantInteger 11-10N
469
552
Y
Filter Invoices
FilterRows
Y
1
none
Invoice Output
Filter Counter Sales
N
N
TYPE
>=
constantInteger 100-10N
N
AND
OLDAMOUNT
>=
constantBigNumber0-1-1N
N
AND
PATIENTID
<>
constantInteger-1-10N
467
57
Y
Filter Payments
FilterRows
Y
1
none
Payment Output
Filter Refunds
N
N
OLDAMOUNT
>=
constantNumber0.0-1-1N
N
AND
N
TYPE
=
constantInteger 7-10N
N
OR
TYPE
=
constantInteger 8-10N
N
OR
TYPE
=
constantInteger 9-10N
N
OR
TYPE
=
constantInteger 10-10N
N
OR
TYPE
=
constantInteger 1-10N
N
OR
TYPE
=
constantInteger 5-10N
467
258
Y
Filter Refunds
FilterRows
Y
1
none
Refund Output
Filter Debit
N
N
OLDAMOUNT
<
constantNumber0.0-1-1N
N
AND
N
TYPE
=
constantInteger 7-10N
N
OR
TYPE
=
constantInteger 8-10N
N
OR
TYPE
=
constantInteger 9-10N
N
OR
TYPE
=
constantInteger 10-10N
N
OR
TYPE
=
constantInteger 1-10N
N
OR
TYPE
=
constantInteger 5-10N
467
336
Y
Init Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountInitialBalance>startTimetruefalseTRANSTAT<act.customerAccountInitialBalance>statustruefalseAMOUNT<act.customerAccountInitialBalance>amounttruefalseREFERENCE<act.customerAccountInitialBalance>referencetruefalseCREDIT<act.customerAccountInitialBalance>credittruefalseCLIENTID<act.customerAccountInitialBalance>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountInitialBalance>customer[0]<participation.customer>acttrue<act.customerAccountInitialBalance>$valuefalsetruetrue1000
767
553
Y
Invoice Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountChargesInvoice>startTimetruefalseTRANSTAT<act.customerAccountChargesInvoice>statustruefalseAMOUNT<act.customerAccountChargesInvoice>amounttruefalseTAXAMT<act.customerAccountChargesInvoice>taxtruefalseREFERENCE<act.customerAccountChargesInvoice>referencetruefalseDESCRIPTION<act.customerAccountChargesInvoice>notestruefalseCLIENTID<act.customerAccountChargesInvoice>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountChargesInvoice>customer[0]<participation.customer>acttrue<act.customerAccountChargesInvoice>$valuefalsetruetrue1000
750
56
Y
Payment Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountPayment>startTimetruefalseTRANSTAT<act.customerAccountPayment>statustruefalseAMOUNT<act.customerAccountPayment>amounttruefalseREFERENCE<act.customerAccountPayment>referencetruefalseCLIENTID<act.customerAccountPayment>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountPayment>customer[0]<participation.customer>acttrue<act.customerAccountPayment>$valuefalseCLINIC<act.customerAccountPayment>till[0]<participation.till>entitytrue<party.organisationTill>$valuefalseTRANSID<act.customerAccountPayment>till[0]<participation.till>acttrue<act.customerAccountPayment>$valuefalsetruetrue1000
757
259
Y
Refund Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsTRANSIDDATE<act.customerAccountRefund>startTimetruefalseTRANSTAT<act.customerAccountRefund>statustruefalseAMOUNT<act.customerAccountRefund>amounttruefalseREFERENCE<act.customerAccountRefund>referencetruefalseCLIENTID<act.customerAccountRefund>customer[0]<participation.customer>entitytrue<party.customerperson>$valuefalseTRANSID<act.customerAccountRefund>customer[0]<participation.customer>acttrue<act.customerAccountRefund>$valuefalseCLINIC<act.customerAccountRefund>till[0]<participation.till>entitytrue<party.organisationTill>$valuefalseTRANSID<act.customerAccountRefund>till[0]<participation.till>acttrue<act.customerAccountRefund>$valuefalsetruetrue1000
762
333
Y
Select Transaction Fields
SelectValues
Y
1
none
Transaction Number
TRANSID
-2
-2
Client Number
CLIENTID
-2
-2
Transaction Date
DATE
-2
-2
Transaction Amount
AMOUNT
-2
-2
Transaction Type
TYPE
-2
-2
Transaction Text
DESCRIPTION
-2
-2
Transaction Tax
TAXAMT
-2
-2
Reference No
REFERENCE
-2
-2
Type Name
TYPENAME
-2
-2
Patient Number
PATIENTID
-2
-2
Incomplete Status
STATUS
-2
-2
Special Instructions
INSTRUCTIONS
-2
-2
Clinic Code
CLINIC
-2
-2
214
55
Y
Table input
TableInput
Y
1
none
RxWorks
SELECT *
FROM ([Transaction] LEFT JOIN [Visit] ON Visit.[Visit Number] = Transaction.[Visit Number]) INNER JOIN [Transaction Type] ON Transaction.[Transaction Type] = [Transaction Type].[Type Code];
0
N
N
66
59
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var TRANSTAT = "POSTED"
var OLDAMOUNT = AMOUNT.getNumber()
// If Settlement Discount make negate old amount
if (TYPE.getInt() == 5)
OLDAMOUNT = - OLDAMOUNT
// If Balance Transfer set Credit flag according to amount
var CREDIT = false
if (TYPE.getNumber() == 11 && AMOUNT.getNumber() < 0)
CREDIT = true
// Make amounst absolute
AMOUNT.setNumber(abs(AMOUNT.getNumber()))
TAXAMT.setNumber(abs(TAXAMT.getNumber()))
if (DESCRIPTION.getString() == null)
DESCRIPTION.setString(TYPENAME.getString())
else
DESCRIPTION.setString(TYPENAME.getString() + '-' + DESCRIPTION.getString())
if (INSTRUCTIONS.getString() != null)
DESCRIPTION.setString(DESCRIPTION.getString() + '\n' + INSTRUCTIONS.getString())
TRANSTAT
TRANSTAT
String
-1
-1
OLDAMOUNT
OLDAMOUNT
Number
16
2
CREDIT
CREDIT
Boolean
-1
-1
340
57
Y