Product - Merchandise
/
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 MerchandiseY
Product Merchandise
OpenVPMSLoaderPlugin
Y
1
none
openvpmsCODENAME<product.merchandise>namefalsefalseUNTTYP<product.merchandise>sellingUnitsfalsefalseACTIVE<product.merchandise>activefalsefalseMARKUP<product.merchandise>prices[0]<productPrice.unitPrice>markuptruefalsePRICE1<product.merchandise>prices[0]<productPrice.unitPrice>pricetruefalseUNTCST<product.merchandise>prices[0]<productPrice.unitPrice>costtruefalseUNTTYP<product.merchandise>prices[0]<productPrice.unitPrice>uomtruefalseUNTTYP<product.merchandise>prices[0]<productPrice.unitPrice>quantityfalse9999falseCODE<product.merchandise>identities[0]<entityIdentity.code>codetruefalseGROUP<product.merchandise>classifications[0]true<lookup.productGroup>$valuefalseCODE<entityRelationship.productTypeProduct>sourcetrue<entity.productType>MERCHANDISEfalseCODE<entityRelationship.productTypeProduct>targettrue<product.merchandise>$valuefalsetruefalse1000
487
119
Y
Select Inventory Fields
SelectValues
Y
1
none
Item Number
CODE
-2
-2
Description
NAME
-2
-2
Category
GROUP
-2
-2
Cost
PACKCOST
-2
-2
Price
PRICE1
-2
-2
Profit Margin
MARKUP
-2
-2
Unit
UNTTYP
-2
-2
Active
ACTIVEFLAG
-2
-2
Qty per Unit
PACKSIZE
-2
-2
215
120
Y
Table input
TableInput
Y
1
none
Quickvet
select * from stock
0
N
N
105
122
Y
Transform Fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
var ACTIVE = true
var UNTCST = 0.0
CODE.setString("MERCH" + 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