Product - Information
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 17:01:13.040
RxWorks
MSACCESS
ODBC
RxWorks
-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
Item InputSelect FieldsY Filter ServicesProduct ServiceY Filter ServicesFilter MedicationY Filter MedicationProduct MedicationY Filter MedicationProduct MerchandiseY Select FieldsTransform fieldsY Transform fieldsFilter ServicesY
Filter Medication
FilterRows
Y
1
none
Product Medication
Product Merchandise
N
COMPONENTGROUP
STARTS WITH
constantStringDrug-1-1N
501
264
Y
Filter Services
FilterRows
Y
1
none
Product Service
Filter Medication
N
N
COMPONENTGROUP
STARTS WITH
constantStringProf-1-1N
N
OR
COMPONENTGROUP
STARTS WITH
constantStringLab-1-1N
499
133
Y
Item Input
TableInput
Y
1
none
RxWorks
select * from item
0
N
N
51
133
Y
Product Medication
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<product.medication>namefalsefalse<product.medication>printedNamefalsefalse<product.medication>dispensingUnitsfalsefalse<product.medication>sellingUnitsfalsefalse<product.medication>activeIngredientsfalsefalse<product.medication>labelfalsefalse<product.medication>activefalsefalse<product.medication>species[0]true<lookup.species>$valuefalsetruetrue100
712
263
Y
Product Merchandise
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<product.merchandise>namefalsefalse<product.merchandise>printedNamefalsefalse<product.merchandise>sellingUnitsfalsefalse<product.merchandise>activefalsefalse<product.merchandise>species[0]true<lookup.species>$valuefalsetruetrue100
711
376
Y
Product Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsID<product.service>namefalsefalse<product.service>printedNamefalsefalse<product.service>activefalsefalse<product.service>species[0]true<lookup.species>$valuefalsetruetrue1000
714
134
Y
Select Fields
SelectValues
Y
1
none
Item Code
ID
-2
-2
Item Service
SERVICE
-2
-2
Item Name
NAME
-2
-2
Item Printed Name
PRINTEDNAME
-2
-2
Item Species
SPECIES
-2
-2
Item Service Fee Group
SERVICEGROUP
-2
-2
Item Component Fee Group
COMPONENTGROUP
-2
-2
Item Component Name
SELLINGUNIT
-2
-2
Item Category 1
CATEGORY1
-2
-2
Item Category 2
CATEGORY2
-2
-2
Item Category 3
CATEGORY3
-2
-2
Item Category 4
CATEGORY4
-2
-2
Item Category 5
CATEGORY5
-2
-2
Item Print Label
PRINTLABEL
-2
-2
Item Active Ingredients
INGREDIENTS
-2
-2
Item Use Stock Control
STOCKCONTROL
-2
-2
Item Deactivated Date
DEACTIVATEDDATE
-2
-2
Item Standard Fee
STANDARDFEE
-2
-2
193
132
Y
Transform fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
if (DEACTIVATEDDATE.getDate() != null)
ACTIVE = false
if (NAME.getString() == "" || NAME.getString() == null)
NAME.setString("No Name")
SPECIES.setString(replace(upper(SPECIES.getString()),"[^A-Z0-9]+",'_'))
if (SPECIES.getString() == "_ALL_SPECIES_")
SPECIES.setString(null);
ACTIVE
ACTIVE
Boolean
-1
-1
318
134
Y