Product - Inventory Conversion
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Inventory InputSelect Inventory FieldsY Select Inventory FieldsLookup Dispensing FeeY Charges InputFilter Dispensing Fee ChargeY Filter Dispensing Fee ChargeSelect Charge fieldsY Select Charge fieldsRow NormaliserY Row NormaliserLookup Dispensing FeeY Lookup Dispensing FeeTransform Inventory FieldsY Transform Inventory FieldsProduct Medication OutputY Filter Dispensing Fee ChargeDummy (do nothing)Y
Charges Input
XBaseInput
Y
1
none
F:\VETAID\CHARGES.DBF
0
N
N
N
85
287
Y
Dummy (do nothing)
Dummy
Y
1
none
212
388
Y
Filter Dispensing Fee Charge
FilterRows
N
1
none
Select Charge fields
Dummy (do nothing)
N
SERVICE
=
constantStringDispensing Fee-1-1N
217
285
Y
Inventory Input
XBaseInput
Y
1
none
F:\VETAID\INVENTY.DBF
0
N
N
N
91
114
Y
Lookup Dispensing Fee
StreamLookup
Y
1
none
Row Normaliser
N
Y
N
N
DISPFEE
typefield
fee
DISPENSINGFEE
0.0
Number
449
114
Y
Product Medication Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsPRODUCTIDINVENTNAME<product.medication>namefalsefalsePRESENT<product.medication>dispensingUnitsfalsefalsePRESENT<product.medication>sellingUnitsfalsefalseACTIVE<product.medication>activefalsefalseMARKUP<product.medication>prices[0]<productPrice.unitPrice>markuptruefalseSALEPRICE<product.medication>prices[0]<productPrice.unitPrice>pricefalsefalsePRESENT<product.medication>prices[0]<productPrice.unitPrice>uomfalsefalseDISPENSINGFEE<product.medication>prices[1]<productPrice.fixedPrice>pricetruefalsetruetrue1000
749
114
Y
Row Normaliser
Normaliser
Y
1
none
typefield
TOTAL1
1
fee
TOTAL2
2
fee
TOTAL3
3
fee
TOTAL4
4
fee
TOTAL5
5
fee
TOTAL6
6
fee
TOTAL7
7
fee
TOTAL8
8
fee
457
286
Y
Select Charge fields
SelectValues
Y
1
none
SERVICE
-2
-2
TOTAL1
-2
-2
TOTAL2
-2
-2
TOTAL3
-2
-2
TOTAL4
-2
-2
TOTAL5
-2
-2
TOTAL6
-2
-2
TOTAL7
-2
-2
TOTAL8
-2
-2
352
287
Y
Select Inventory Fields
SelectValues
Y
1
none
INVENTNO
-2
-2
INVENTNAME
-2
-2
PRESENT
-2
-2
COSTPRICE
-2
-2
MARKUP
-2
-2
SALEPRICE
-2
-2
DISPFEE
-2
-2
DEACTIVATE
-2
-2
INVENTNO
PRODUCTID
String
20
-2
226
112
Y
Transform Inventory Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
// Transform ProductID
PRODUCTID.setString("DRUG" + PRODUCTID.getString())
// Transform Name
if (INVENTNAME.getString() != null)
INVENTNAME.setString(wordUtils.capitalizeFully(trim(INVENTNAME.getString())))
if (INVENTNAME.getString() == null || INVENTNAME.getString() == "")
INVENTNAME.setString("No Name")
//Transform Presentation - remove per word
if (PRESENT.getString() != null)
PRESENT.setString(trim(replace(PRESENT.getString(),"Per","")))
//Transform Deactivate Date
var ACTIVE = true
if (DEACTIVATE.getDate() != null)
ACTIVE = false
if (DISPENSINGFEE.getString() == "0.0")
DISPENSINGFEE.setString(null)
ACTIVE
ACTIVE
Boolean
-1
-1
588
114
Y