Product - Medications
/
Y
N
0.0
0.0
1000
1
1
N
Y
5000
Y
admin
2007/04/09 10:47:12.000
Quickvet
MSACCESS
ODBC
Quickvet
-1
Encrypted
EXTRA_OPTION_MYSQL.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Select Inventory FieldsTransform FieldsY Table inputSelect Inventory FieldsY Transform FieldsProduct MedicationY
Product Medication
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODENAME<product.medication>namefalsefalseUNTTYP<product.medication>dispensingUnitsfalsefalseUNTTYP<product.medication>sellingUnitsfalsefalseACTIVE<product.medication>activefalsefalsePRICE1<product.medication>prices[0]<productPrice.unitPrice>pricetruefalseUNTCST<product.medication>prices[0]<productPrice.unitPrice>costtruefalseUNTTYP<product.medication>prices[0]<productPrice.unitPrice>uomtruefalseMARKUP<product.medication>prices[0]<productPrice.unitPrice>markuptruefalseMARKUP<product.medication>prices[0]<productPrice.unitPrice>quantityfalse9999falseDISFEE<product.medication>prices[1]<productPrice.fixedPrice>pricetruefalseCODE<product.medication>identities[0]<entityIdentity.code>codetruefalseGROUP<product.medication>classifications[0]true<lookup.productGroup>$valuefalseCODE<entityRelationship.productTypeProduct>sourcetrue<entity.productType>MEDICATIONfalseCODE<entityRelationship.productTypeProduct>targettrue<product.medication>$valuefalsetruetrue1000
485
119
Y
Select Inventory Fields
SelectValues
Y
1
none
Drug Code
CODE
-2
-2
Drug Name
NAME
-2
-2
Category
GROUP
-2
-2
Unit
UNTTYP
-2
-2
Cost
PACKCOST
-2
-2
Price
PRICE1
-2
-2
Bottling Fee
DISFEE
-2
-2
Active
ACTIVEFLAG
-2
-2
Qty Per Unit
PACKSIZE
-2
-2
Profit Margin
MARKUP
-2
-2
216
120
Y
Table input
TableInput
Y
1
none
Quickvet
select * from druginv
0
N
N
104
122
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
var UNTCST = 0.0
CODE.setString("DRUG" + replace(upper(CODE.getString()),"[^A-Z0-9]+",'_'))
if (CODE.getString() == null || CODE.getString() == "")
CODE.setString("NOCODE")
GROUP.setString(replace(trim(upper(GROUP.getString())),"[^A-Z0-9]+",'_'))
if (NAME.getString() == null || NAME.getString() == "")
NAME.setString("No Name")
if (ACTIVEFLAG.getString() == "NO" || ACTIVEFLAG.getString() == "No")
ACTIVE = false;
if (PRICE1.getNumber() == null)
PRICE1.setNumber("0.0");
if (PACKSIZE.getNumber() != null)
UNTCST = PACKCOST.getNumber()/PACKSIZE.getNumber();
if (UNTTYP.getString() == null || UNTTYP.getString() == "")
UNTTYP.setString("Unit");
ACTIVE
ACTIVE
Boolean
-1
-1
UNTCST
UNTCST
Number
16
2
337
120
Y