Product - Procedure Conversion /

YN 0.0 0.0 1000 1 1 N Y 5000 Y admin 2007/04/09 17:01:13.040 archetypes MYSQL Native openvpms 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN conversion localhost MYSQL Native conversion 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 EXTRA_OPTION_MYSQL.defaultFetchSize500 EXTRA_OPTION_MYSQL.useCursorFetchtrue IS_CLUSTEREDN MAXIMUM_POOL_SIZE10 PORT_NUMBER3306 STREAM_RESULTSY USE_POOLINGN openvpms localhost MYSQL Native openvpms 3306 openvpms Encrypted 2be98afc86aa7f2e4a409ab7ec882a2c9 PORT_NUMBER3306 Procedures InputSelect Procedure fieldsY Select Procedure fieldsTransform Procedure FieldsY Transform Procedure FieldsProduct Procedure OutputY Procedures Input XBaseInput Y 1 none F:\VETAID\CSTPROCS.DBF 0 N N N 91 113 Y Product Procedure Output OpenVPMSLoaderPlugin Y 1 none openvpmsPRODUCTIDDESCRIPT<product.service>namefalsefalseCOMPONENT<product.service>prices[0]<productPrice.unitPrice>pricetruefalseTOTALCH<product.service>prices[1]<productPrice.fixedPrice>pricetruefalsetruetrue 554 112 Y Select Procedure fields SelectValues Y 1 none PROCCODE -2 -2 DESCRIPT -2 -2 COMPONENT -2 -2 TOTALCH -2 -2 PROCCODE PRODUCTID String 20 0 DESCRIPT - 30 -2 COMPONENT - 8 2 TOTALCH - 8 2 219 114 Y Transform Procedure Fields ScriptValueMod Y 1 none