Product - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Item InputSelect Inventory FieldsY Filter MedicationsProduct Medication OutputY Filter MedicationsFilter MerchandiseY Select Inventory FieldsTransform FieldsY Transform FieldsFilter MedicationsY Filter MerchandiseProduct Merchandise OutputY Filter CommentsModified Java Script ValueY Modified Java Script ValueProduct Service OutputY Filter CommentsDummy (do nothing)Y Filter MerchandiseFilter CommentsY
Dummy (do nothing)
Dummy
Y
1
none
500
497
Y
Filter Comments
FilterRows
Y
1
none
Modified Java Script Value
Dummy (do nothing)
N
N
TYPE
<>
constantStringC-1-1N
N
AND
TYPE
<>
constantStringH-1-1N
499
390
Y
Filter Medications
FilterRows
Y
1
none
Product Medication Output
Filter Merchandise
N
N
TYPE
=
constantStringM-1-1N
N
OR
TYPE
=
constantStringR-1-1N
504
121
Y
Filter Merchandise
FilterRows
Y
1
none
Product Merchandise Output
Filter Comments
N
TYPE
=
constantStringN-1-1N
501
246
Y
Item Input
TextFileInput
Y
1
none
N
,
"
N
1
1
N
1
N
80
0
Y
N
N
N
DOS
${NETVET_DATA}\items.txt
CSV
None
ITEMID
String
-1
-1
-1
none
N
CODE
String
-1
-1
-1
none
N
NAME
String
-1
-1
-1
none
N
PRINTEDNAME
String
-1
-1
-1
none
N
TYPE
String
-1
-1
-1
none
N
PCKDES
String
-1
-1
-1
none
N
PCKUNT
String
-1
-1
-1
none
N
UNTTYP
String
-1
-1
-1
none
N
DISVERB
String
-1
-1
-1
none
N
PCKCST
String
-1
-1
-1
none
N
UNTCST
String
-1
-1
-1
none
N
AVGCST
String
-1
-1
-1
none
N
MARKUP
String
-1
-1
-1
none
N
DISFEE
String
-1
-1
-1
none
N
PRICE1
String
-1
-1
-1
none
N
PRICE2
String
-1
-1
-1
none
N
PRICE3
String
-1
-1
-1
none
N
PRICE4
String
-1
-1
-1
none
N
PRICE5
String
-1
-1
-1
none
N
PRICE6
String
-1
-1
-1
none
N
MINQTY
String
-1
-1
-1
none
N
MAXQTY
String
-1
-1
-1
none
N
CURQTY
String
-1
-1
-1
none
N
ORDQTY
String
-1
-1
-1
none
N
STTQTY
String
-1
-1
-1
none
N
DRGSTG
String
-1
-1
-1
none
N
GROUP
String
-1
-1
-1
none
N
0
Y
Y
warning
error
line
Y
en_au
94
119
Y
Modified Java Script Value
ScriptValueMod
Y
1
none
0
Script 1
//Script here
if (TYPE.getString() == 'X')
ACTIVE.setBool(false)
641
389
Y
Product Medication Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODE<product.medication>namefalsefalse<product.medication>printedNamefalsefalse<product.medication>dispensingUnitsfalsefalse<product.medication>sellingUnitsfalsefalse<product.medication>dispensingVerbfalsefalse<product.medication>activeIngredientsfalsefalse<product.medication>activefalsefalse<product.medication>prices[0]<productPrice.unitPrice>markuptruefalse<product.medication>prices[0]<productPrice.unitPrice>pricetruefalse<product.medication>prices[0]<productPrice.unitPrice>costtruefalse<product.medication>prices[0]<productPrice.unitPrice>uomtruefalse<product.medication>prices[1]<productPrice.fixedPrice>pricetruefalse<product.medication>identities[0]<entityIdentity.code>codetruefalse<product.medication>classifications[0]true<lookup.productGroup>$valuefalse<entityRelationship.productTypeProduct>sourcetrue<entity.productType>$valuefalse<entityRelationship.productTypeProduct>targettrue<product.medication>$valuefalsetruetrue1000
814
120
Y
Product Merchandise Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODE<product.merchandise>namefalsefalse<product.merchandise>printedNamefalsefalse<product.merchandise>sellingUnitsfalsefalse<product.merchandise>activefalsefalse<product.merchandise>prices[0]<productPrice.unitPrice>markuptruefalse<product.merchandise>prices[0]<productPrice.unitPrice>pricetruefalse<product.merchandise>prices[0]<productPrice.unitPrice>costtruefalse<product.merchandise>prices[0]<productPrice.unitPrice>uomtruefalse<product.merchandise>prices[1]<productPrice.fixedPrice>pricetruefalse<product.merchandise>identities[0]<entityIdentity.code>codetruefalse<product.merchandise>classifications[0]true<lookup.productGroup>$valuefalse<entityRelationship.productTypeProduct>sourcetrue<entity.productType>$valuefalse<entityRelationship.productTypeProduct>targettrue<product.merchandise>$valuefalsetruefalse1000
811
248
Y
Product Service Output
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODE<product.service>namefalsefalse<product.service>printedNamefalsefalse<product.service>activefalsefalse<product.service>prices[0]<productPrice.unitPrice>pricetruefalse<product.service>prices[0]<productPrice.unitPrice>costtruefalse<product.service>identities[0]<entityIdentity.code>codetruefalse<product.service>classifications[0]true<lookup.productGroup>$valuefalse<entityRelationship.productTypeProduct>sourcetrue<entity.productType>$valuefalse<entityRelationship.productTypeProduct>targettrue<product.service>$valuefalsetruefalse1000
808
387
Y
Select Inventory Fields
SelectValues
Y
1
none
ITEMID
-2
-2
CODE
-2
-2
NAME
-2
-2
PRINTEDNAME
-2
-2
TYPE
-2
-2
PCKDES
-2
-2
PCKUNT
-2
-2
UNTTYP
-2
-2
DISVERB
-2
-2
PCKCST
-2
-2
UNTCST
-2
-2
AVGCST
-2
-2
MARKUP
-2
-2
DISFEE
-2
-2
PRICE1
-2
-2
PRICE2
-2
-2
PRICE3
-2
-2
PRICE4
-2
-2
PRICE5
-2
-2
PRICE6
-2
-2
DRGSTG
-2
-2
GROUP
-2
-2
PCKUNT
Number
8
2
PCKCST
Number
8
2
UNTCST
Number
8
2
AVGCST
Number
8
2
MARKUP
Number
8
2
DISFEE
Number
8
2
PRICE1
Number
8
2
PRICE2
Number
8
2
PRICE3
Number
8
2
PRICE4
Number
8
2
PRICE5
Number
8
2
PRICE6
Number
8
2
215
118
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
GROUP.setString(replace(upper(GROUP.getString()),"[^A-Z0-9]+",'_'))
if (NAME.getString() == "" || NAME.getString() == null) {
NAME.setString("No Product Name")
}
CODE.setString(replace(upper(CODE.getString()),"[^A-Z0-9]+",'_'))
if (CODE.getString() == null || CODE.getString() == "")
CODE.setString("NOCODE")
var typ = TYPE.getString()
var PRODUCTTYPE
if (typ == "N")
PRODUCTTYPE = "Normal"
else if (typ == "M")
PRODUCTTYPE = "Medical"
else if (typ == "P")
PRODUCTTYPE = "Procedure"
else if (typ == "D")
PRODUCTTYPE ="Desex"
else if (typ == "R")
PRODUCTTYPE = "Vaccination"
else if (typ == "S")
PRODUCTTYPE = "Surgery"
else if (typ == "E")
PRODUCTTYPE = "Euthanasia"
else
PRODUCTTYPE = "Other"
if (NAME.getString() == null || NAME.getString() == "")
NAME.setString("No Name")
ACTIVE
ACTIVE
Boolean
-1
-1
PRODUCTTYPE
PRODUCTTYPE
String
-1
-1
353
119
Y