Product - Services
/
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 ServiceY
Product Service
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODENAME<product.service>namefalsefalseACTIVE<product.service>activefalsefalsePRICE1<product.service>prices[0]<productPrice.unitPrice>pricefalsefalsePRICE1<product.service>prices[0]<productPrice.unitPrice>uomtrueUnitfalsePRICE1<product.service>prices[0]<productPrice.unitPrice>quantityfalse9999falseCODE<product.service>identities[0]<entityIdentity.code>codetruefalseGROUP<product.service>classifications[0]true<lookup.productGroup>$valuefalseCODE<entityRelationship.productTypeProduct>sourcetrue<entity.productType>SERVICEfalseCODE<entityRelationship.productTypeProduct>targettrue<product.service>$valuefalsetruefalse1000
503
121
Y
Select Inventory Fields
SelectValues
Y
1
none
Code
CODE
-2
-2
Description
NAME
-2
-2
Price
PRICE1
-2
-2
Active
ACTIVEFLAG
-2
-2
Category
GROUP
-2
-2
215
118
Y
Table input
TableInput
Y
1
none
Quickvet
select * from procedre
0
N
N
85
117
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
if (NAME.getString() == "" || NAME.getString() == null) {
NAME.setString("No Product Name")
}
CODE.setString("SERV" + 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 (ACTIVEFLAG.getString() == "NO" || ACTIVEFLAG.getString() == "No") {
ACTIVE = false
}
if (PRICE1.getNumber() == null) {
PRICE1.setNumber(0.0);
}
ACTIVE
ACTIVE
Boolean
-1
-1
352
121
Y