Product - Suppliers
/
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.defaultFetchSize500
EXTRA_OPTION_MYSQL.useCursorFetchtrue
IS_CLUSTEREDN
MAXIMUM_POOL_SIZE10
PORT_NUMBER-1
STREAM_RESULTSY
USE_POOLINGN
Item BrandsSelect valuesY Transform fieldsProduct SuppliersY Select valuesTransform fieldsY
Item Brands
TableInput
Y
1
none
RxWorks
select * from [Item Brand]
0
N
N
59
139
Y
Product Suppliers
OpenVPMSLoaderPlugin
Y
1
none
openvpmsIDID<entityRelationship.productSupplier>sourcetrue<product.*>$valuefalseSUPPLIERID<entityRelationship.productSupplier>targettrue<party.supplierorganisation>$valuefalseNAME<entityRelationship.productSupplier>reorderNametruefalseCODE<entityRelationship.productSupplier>reorderCodetruefalseBARCODE<entityRelationship.productSupplier>barCodetruefalseLISTPRICE<entityRelationship.productSupplier>listPricetruefalsePACKSIZE<entityRelationship.productSupplier>packSizetruefalseENDDATE<entityRelationship.productSupplier>activeEndTimetruefalsetruetrue1000
477
142
Y
Select values
SelectValues
Y
1
none
Item Code
ID
-2
-2
Supplier
SUPPLIERID
-2
-2
Brand Name
NAME
-2
-2
Stock Order Code
CODE
-2
-2
Bar Code
BARCODE
-2
-2
Last Price
LISTPRICE
-2
-2
Pack Size
PACKSIZE
-2
-2
Deactivated Date
ENDDATE
-2
-2
165
140
Y
Transform fields
ScriptValueMod
Y
1
none
0
Script 1
//Script here
302
141
Y