Product - Information / YN
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 InputSelect FieldsY Filter ServicesProduct ServiceY Filter ServicesFilter MedicationY Filter MedicationProduct MedicationY Filter MedicationProduct MerchandiseY Select FieldsTransform fieldsY Transform fieldsFilter ServicesY Filter Medication FilterRows Y 1 none Product Medication Product Merchandise N COMPONENTGROUP STARTS WITH constantStringDrug-1-1N 501 264 Y Filter Services FilterRows Y 1 none Product Service Filter Medication N N COMPONENTGROUP STARTS WITH constantStringProf-1-1N N OR COMPONENTGROUP STARTS WITH constantStringLab-1-1N 499 133 Y Item Input TableInput Y 1 none RxWorks select * from item 0 N N 51 133 Y Product Medication OpenVPMSLoaderPlugin Y 1 none openvpmsIDNAME<product.medication>namefalsefalsePRINTEDNAME<product.medication>printedNamefalsefalseSELLINGUNIT<product.medication>dispensingUnitsfalsefalseSELLINGUNIT<product.medication>sellingUnitsfalsefalseINGREDIENTS<product.medication>activeIngredientsfalsefalsePRINTLABEL<product.medication>labelfalsefalseACTIVE<product.medication>activefalsefalseSPECIES<product.medication>species[0]true<lookup.species>$valuefalsetruetrue100 712 263 Y Product Merchandise OpenVPMSLoaderPlugin Y 1 none openvpmsIDNAME<product.merchandise>namefalsefalsePRINTEDNAME<product.merchandise>printedNamefalsefalseSELLINGUNIT<product.merchandise>sellingUnitsfalsefalseACTIVE<product.merchandise>activefalsefalseSPECIES<product.merchandise>species[0]true<lookup.species>$valuefalsetruetrue100 711 376 Y Product Service OpenVPMSLoaderPlugin Y 1 none openvpmsIDNAME<product.service>namefalsefalsePRINTEDNAME<product.service>printedNamefalsefalseACTIVE<product.service>activefalsefalseSPECIES<product.service>species[0]true<lookup.species>$valuefalsetruetrue1000 714 134 Y Select Fields SelectValues Y 1 none Item Code ID -2 -2 Item Service SERVICE -2 -2 Item Name NAME -2 -2 Item Printed Name PRINTEDNAME -2 -2 Item Species SPECIES -2 -2 Item Service Fee Group SERVICEGROUP -2 -2 Item Component Fee Group COMPONENTGROUP -2 -2 Item Component Name SELLINGUNIT -2 -2 Item Category 1 CATEGORY1 -2 -2 Item Category 2 CATEGORY2 -2 -2 Item Category 3 CATEGORY3 -2 -2 Item Category 4 CATEGORY4 -2 -2 Item Category 5 CATEGORY5 -2 -2 Item Print Label PRINTLABEL -2 -2 Item Active Ingredients INGREDIENTS -2 -2 Item Use Stock Control STOCKCONTROL -2 -2 Item Deactivated Date DEACTIVATEDDATE -2 -2 Item Standard Fee STANDARDFEE -2 -2 193 132 Y Transform fields ScriptValueMod Y 1 none