Customer - Invoice Items
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
-
2007/06/03 14:20:22.718
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize
500
EXTRA_OPTION_MYSQL.useCursorFetch
true
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
-1
STREAM_RESULTS
Y
USE_POOLING
N
Add sequenceTransform FieldsY Transform FieldsFilter rowsY Filter rowsDummy (do nothing)Y Transform InvoiceInvoice ServiceY Filter rowsFilter InvoicesY Filter InvoicesTransform InvoiceY Filter CreditsTransform CreditY Filter InvoicesFilter CounterY Filter CounterFilter CreditsY Filter CounterCounter ServiceY Filter CreditsDummy (do nothing) 2Y Transform CreditFilter Patient CreditsY Filter Patient CreditsCredit ServiceY Filter Patient CreditsPatient Credit ServiceY Drug InputSelect valuesY Select valuesTransform ID1Y Transform ID1Add sequenceY Procedure InputSelect values 2Y Select values 2Transform ID2Y Transform ID2Add sequenceY Stock InputSelect values 3Y Select values 3Transform ID3Y Transform ID3Add sequenceY
Add sequence
Sequence
Y
1
none
SERVICEID
N
SEQ_
Y
1
1
9999999
283
78
Y
Counter Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsSERVICEID<act.customerAccountCounterItem>startTimetruefalse<act.customerAccountCounterItem>unitPricetruefalse<act.customerAccountCounterItem>taxtruefalse<act.customerAccountCounterItem>quantitytruefalse<act.customerAccountCounterItem>product[0]<participation.product>entitytrue<product.*>$valuefalse<act.customerAccountCounterItem>product[0]<participation.product>acttrue<act.customerAccountCounterItem>$valuefalse<actRelationship.customerAccountCounterItem>sourcetrue<act.customerAccountChargesCounter>$valuefalse<actRelationship.customerAccountCounterItem>targettrue<act.customerAccountCounterItem>$valuefalsetruetrue1000
951
159
Y
Credit Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsSERVICEID<act.customerAccountCreditItem>startTimetruefalse<act.customerAccountCreditItem>unitPricetruefalse<act.customerAccountCreditItem>taxtruefalse<act.customerAccountCreditItem>quantitytruefalse<act.customerAccountCreditItem>discounttruefalse<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalse<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalse<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalse<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalse<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalse<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000
950
252
Y
Drug Input
TableInput
Y
1
none
Quickvet
select * from invdrug
0
N
N
19
76
Y
Dummy (do nothing)
Dummy
Y
1
none
488
190
Y
Dummy (do nothing) 2
Dummy
Y
1
none
595
346
Y
Filter Counter
FilterRows
N
1
none
Counter Service
Filter Credits
N
N
UNITPRICE
>=
constantNumber0.0-1-1N
N
AND
PATIENTID
=
constantNumber0.0-1-1N
592
160
Y
Filter Credits
FilterRows
N
1
none
Transform Credit
Dummy (do nothing) 2
N
N
UNITPRICE
<
constantNumber0.0-1-1N
595
249
Y
Filter Invoices
FilterRows
Y
1
none
Transform Invoice
Filter Counter
N
N
UNITPRICE
>=
constantNumber0.0-1-1N
N
AND
PATIENTID
>
constantNumber0.0-1-1N
592
79
Y
Filter Patient Credits
FilterRows
Y
1
none
Credit Service
Patient Credit Service
N
PATIENTID
=
constantNumber0.0-1-1N
819
251
Y
Filter rows
FilterRows
N
1
none
Filter Invoices
Dummy (do nothing)
N
N
VISITID
>
constantNumber0.0-1-1N
N
AND
ACCOUNTID
>
constantNumber0.0-1-1N
N
AND
PRODUCTID
IS NOT NULL
488
78
Y
Invoice Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsSERVICEID<act.customerAccountInvoiceItem>startTimetruefalse<act.customerAccountInvoiceItem>unitPricetruefalse<act.customerAccountInvoiceItem>taxtruefalse<act.customerAccountInvoiceItem>quantitytruefalse<act.customerAccountInvoiceItem>discounttruefalse<act.customerAccountInvoiceItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalse<act.customerAccountInvoiceItem>patient[0]<participation.patient>acttrue<act.customerAccountInvoiceItem>$valuefalse<act.customerAccountInvoiceItem>product[0]<participation.product>entitytrue<product.*>$valuefalse<act.customerAccountInvoiceItem>product[0]<participation.product>acttrue<act.customerAccountInvoiceItem>$valuefalse<actRelationship.customerAccountInvoiceItem>sourcetrue<act.customerAccountChargesInvoice>$valuefalse<actRelationship.customerAccountInvoiceItem>targettrue<act.customerAccountInvoiceItem>$valuefalsetruetrue1000
950
82
Y
Patient Credit Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsSERVICEID<act.customerAccountCreditItem>startTimetruefalse<act.customerAccountCreditItem>unitPricetruefalse<act.customerAccountCreditItem>taxtruefalse<act.customerAccountCreditItem>quantitytruefalse<act.customerAccountCreditItem>patient[0]<participation.patient>entitytrue<party.patientpet>$valuefalse<act.customerAccountCreditItem>patient[0]<participation.patient>acttrue<act.customerAccountCreditItem>$valuefalse<act.customerAccountCreditItem>product[0]<participation.product>entitytrue<product.*>$valuefalse<act.customerAccountCreditItem>product[0]<participation.product>acttrue<act.customerAccountCreditItem>$valuefalse<actRelationship.customerAccountCreditItem>sourcetrue<act.customerAccountChargesCredit>$valuefalse<actRelationship.customerAccountCreditItem>targettrue<act.customerAccountCreditItem>$valuefalsetruetrue1000
953
365
Y
Procedure Input
TableInput
Y
1
none
Quickvet
select * from invproc
0
N
N
23
228
Y
Select values
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
Date
DATE
-2
-2
Drug Code
PRODUCTID
-2
-2
Qty
QUANTITY
-2
-2
Price
UNITPRICE
-2
-2
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
Tax
TAXAMT
-2
-2
SubTotal
TOTAL
-2
-2
104
76
Y
Select values 2
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
Date
DATE
-2
-2
Code
PRODUCTID
-2
-2
Qty
QUANTITY
-2
-2
Price
UNITPRICE
-2
-2
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
Tax
TAXAMT
-2
-2
SubTotal
TOTAL
-2
-2
108
230
Y
Select values 3
SelectValues
Y
1
none
Visit Number
VISITID
-2
-2
DATE
-2
-2
Item Number
PRODUCTID
-2
-2
Qty
QUANTITY
-2
-2
Price
UNITPRICE
-2
-2
AccountNumber
ACCOUNTID
-2
-2
PetNumber
PATIENTID
-2
-2
Tax
TAXAMT
-2
-2
SubTotal
TOTAL
-2
-2
106
371
Y
Stock Input
TableInput
Y
1
none
Quickvet
SELECT
[Visit Number]
, [Line Number]
, [DATE]
, [Item Number]
, [DESCRIPTION]
, Qty
, Price
, SubTotal
, [Lot Number]
, AccountNumber
, PetNumber
, Assisting
, [Tax Rate]
, Tax
, [Inv Loc]
, Completed
FROM Invstock
0
N
N
18
369
Y
Transform Credit
ScriptValueMod
Y
1
none
0
Script 1
//Script here
QUANTITY.setNumber(abs(QUANTITY.getNumber()))
UNITPRICE.setNumber(abs(UNITPRICE.getNumber()))
TAXAMT.setNumber(abs(TAXAMT.getNumber()))
DISCOUNT.setNumber(abs(DISCOUNT.getNumber()))
704
249
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ID = num2str(ACCOUNTID.getNumber()) + "." + num2str(PATIENTID.getNumber())
var DISCOUNT = 0.0
if (TOTAL.getNumber() == 0.0) {
QUANTITY.setNumber(0.0)
}
if (PRODUCTID.getString() == "SERVDISC") {
DISCOUNT = abs(TOTAL.getNumber())
UNITPRICE.setNumber(0.0)
}
ID
ID
String
-1
-1
DISCOUNT
DISCOUNT
Number
16
2
374
77
Y
Transform ID1
ScriptValueMod
Y
1
none
0
Script 1
//Script here
if (PRODUCTID.getString() != null) {
PRODUCTID.setString("DRUG" + replace(upper(PRODUCTID.getString()),"[^A-Z0-9]+",'_'));
}
192
78
Y
Transform ID2
ScriptValueMod
Y
1
none
0
Script 1
//Script here
if (PRODUCTID.getString() != null) {
PRODUCTID.setString("SERV" + replace(upper(PRODUCTID.getString()),"[^A-Z0-9]+",'_'));
}
187
229
Y
Transform ID3
ScriptValueMod
Y
1
none
0
Script 1
//Script here
if (PRODUCTID.getString() != null) {
PRODUCTID.setString("MERCH" + replace(upper(PRODUCTID.getString()),"[^A-Z0-9]+",'_'))
}
187
372
Y
Transform Invoice
ScriptValueMod
Y
1
none
0
Script 1
//Script here
QUANTITY.setNumber(abs(QUANTITY.getNumber()))
UNITPRICE.setNumber(abs(UNITPRICE.getNumber()))
TAXAMT.setNumber(abs(TAXAMT.getNumber()))
DISCOUNT.setNumber(abs(DISCOUNT.getNumber()))
702
81
Y