Product - Suppliers / YN
0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 17:01:13.040 openvpms localhost MYSQL Native openvpms-setup 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN Select valuesTransform fieldsY Item InputSelect valuesY Transform fieldsFilter rowsY Filter rowsProduct SuppliersY Filter rowsDummy (do nothing)Y Dummy (do nothing) Dummy Y 1 none 464 249 Y Filter rows FilterRows N 1 none Product Suppliers Dummy (do nothing) N N SUPPLIER IS NOT NULL constantString-1-1Y N AND SUPPLIER <> constantString-1-1N 460 143 Y Item Input TextFileInput Y 1 none N , " N
Y
1
N
1 N 1 N 80 0 Y N N N DOS ${NETVET_DATA}\items.txt CSV None ITEMID String -1 -1 -1 none N CODE String -1 -1 -1 none N NAME String -1 -1 -1 none N PRINTEDNAME String -1 -1 -1 none N TYPE String -1 -1 -1 none N PCKDES String -1 -1 -1 none N PCKUNT String -1 -1 -1 none N UNTTYP String -1 -1 -1 none N DISVERB String -1 -1 -1 none N PCKCST String -1 -1 -1 none N UNTCST String -1 -1 -1 none N AVGCST String -1 -1 -1 none N MARKUP String -1 -1 -1 none N DISFEE String -1 -1 -1 none N PRICE1 String -1 -1 -1 none N PRICE2 String -1 -1 -1 none N PRICE3 String -1 -1 -1 none N PRICE4 String -1 -1 -1 none N PRICE5 String -1 -1 -1 none N PRICE6 String -1 -1 -1 none N MINQTY String -1 -1 -1 none N MAXQTY String -1 -1 -1 none N CURQTY String -1 -1 -1 none N ORDQTY String -1 -1 -1 none N STTQTY String -1 -1 -1 none N DRGSTG String -1 -1 -1 none N GROUP String -1 -1 -1 none N SUPPLIER String -1 -1 -1 none N 0 Y Y warning error line Y en_au 106 141 Y Product Suppliers OpenVPMSLoaderPlugin Y 1 none openvpmsCODECODE<entityRelationship.productSupplier>sourcetrue<product.*>$valuefalseSUPPLIER<entityRelationship.productSupplier>targettrue<party.supplierorganisation>$valuefalseNAME<entityRelationship.productSupplier>reorderNametruefalsePCKCST<entityRelationship.productSupplier>listPricetruefalsePCKUNT<entityRelationship.productSupplier>packSizetruefalsetruetrue1000 577 141 Y Select values SelectValues Y 1 none ITEMID -2 -2 NAME -2 -2 SUPPLIER -2 -2 PCKDES -2 -2 PCKUNT -2 -2 PCKCST -2 -2 CODE -2 -2 231 141 Y Transform fields ScriptValueMod Y 1 none