Product - Fixed prices /

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 Service OptionsSelect valuesY Filter MedicationMedication Fixed pricesY Filter MedicationMerchandise Fixed PricesY Filter ServicesFilter MedicationY Filter ServicesService Fixed PricesY Transform fieldsFilter ServicesY Cost InputSelect values 2Y Select valuesSort rowsY Select values 2Sort rows 2Y Sort rows 2Merge JoinY Merge JoinAdd sequenceY Add sequenceTransform fieldsY Sort rowsUnique rowsY Unique rowsMerge JoinY Add sequence Sequence Y 1 none FIXEDPRICEID N SEQ_ Y 1 1 9999999 469 139 Y Cost Input TableInput Y 1 none RxWorks select * from [Item Cost Structure] 0 N N 57 296 Y Filter Medication FilterRows Y 1 none Medication Fixed prices Merchandise Fixed Prices N COMPONENTGROUP STARTS WITH constantStringDrug-1-1N 678 274 Y Filter Services FilterRows Y 1 none Service Fixed Prices Filter Medication N N COMPONENTGROUP STARTS WITH constantStringProf-1-1N N OR COMPONENTGROUP STARTS WITH constantStringLab-1-1N 680 141 Y Item Service Options TableInput Y 1 none RxWorks select * from [Item Service Fee Options] inner join [item] on [Item Service Fee Options].[Item Code]=[Item].[Item Code] 0 N N 59 139 Y Medication Fixed prices OpenVPMSLoaderPlugin Y 1 none openvpmsFIXEDPRICEIDFROMDATE$ID<product.medication>prices[0]<productPrice.fixedPrice>fromDatefalsefalseMARKUP$ID<product.medication>prices[0]<productPrice.fixedPrice>markupfalsefalseMAXDISCOUNT$ID<product.medication>prices[0]<productPrice.fixedPrice>maxDiscountfalsefalsePRICE$ID<product.medication>prices[0]<productPrice.fixedPrice>pricefalsefalseNAME$ID<product.medication>prices[0]<productPrice.fixedPrice>namefalsefalseCOST$ID<product.medication>prices[0]<productPrice.fixedPrice>costfalsefalsetruetrue100 837 271 Y Merchandise Fixed Prices OpenVPMSLoaderPlugin Y 1 none openvpmsFIXEDPRICEIDFROMDATE$ID<product.merchandise>prices[0]<productPrice.fixedPrice>fromDatefalsefalseMARKUP$ID<product.merchandise>prices[0]<productPrice.fixedPrice>markupfalsefalseMAXDISCOUNT$ID<product.merchandise>prices[0]<productPrice.fixedPrice>maxDiscountfalsefalsePRICE$ID<product.merchandise>prices[0]<productPrice.fixedPrice>pricefalsefalseNAME$ID<product.merchandise>prices[0]<productPrice.fixedPrice>namefalsefalseCOST$ID<product.merchandise>prices[0]<productPrice.fixedPrice>costfalsefalsetruetrue100 838 386 Y Merge Join MergeJoin Y 1 none INNER Unique rows Sort rows 2 ID FROMDATE ID FROMDATE 374 140 Y Select values SelectValues Y 1 none Item Code ID -2 -2 Item Description NAME -2 -2 Item Date FROMDATE -2 -2 Item Markup MARKUP -2 -2 Item Maximum Discount MAXDISCOUNT -2 -2 Item Sale Price PRICE -2 -2 Item Component Fee Group COMPONENTGROUP -2 -2 146 139 Y Select values 2 SelectValues Y 1 none Item Code ID -2 -2 Item Date FROMDATE -2 -2 Item Service Fee Cost Price COST -2 -2 153 295 Y Service Fixed Prices OpenVPMSLoaderPlugin Y 1 none openvpmsFIXEDPRICEIDFROMDATE$ID<product.service>prices[0]<productPrice.fixedPrice>fromDatefalsefalseMARKUP$ID<product.service>prices[0]<productPrice.fixedPrice>markupfalsefalseMAXDISCOUNT$ID<product.service>prices[0]<productPrice.fixedPrice>maxDiscountfalsefalsePRICE$ID<product.service>prices[0]<productPrice.fixedPrice>pricefalsefalseNAME$ID<product.service>prices[0]<productPrice.fixedPrice>namefalsefalseCOST$ID<product.service>prices[0]<productPrice.fixedPrice>costfalsefalsetruetrue1000 832 142 Y Sort rows SortRows Y 1 none %%java.io.tmpdir%% out 5000 Y ID Y NAME Y FROMDATE N 228 140 Y Sort rows 2 SortRows Y 1 none %%java.io.tmpdir%% out 5000 Y ID Y FROMDATE Y 262 294 Y Transform fields ScriptValueMod Y 1 none