Product - Unit 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 Quantity Break InputSelect valuesY Filter MedicationMedication Unit pricesY Filter MedicationMerchandise Unit PricesY Filter ServicesFilter MedicationY Filter ServicesService Unit 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 UNITPRICEID N SEQ_ Y 1 1 9999999 443 142 Y Cost Input TableInput Y 1 none RxWorks select * from [Item Cost Structure] 0 N N 67 296 Y Filter Medication FilterRows Y 1 none Medication Unit prices Merchandise Unit Prices N COMPONENTGROUP STARTS WITH constantStringDrug-1-1N 615 274 Y Filter Services FilterRows Y 1 none Service Unit Prices Filter Medication N N COMPONENTGROUP STARTS WITH constantStringProf-1-1N N OR COMPONENTGROUP STARTS WITH constantStringLab-1-1N 613 141 Y Item Quantity Break Input TableInput Y 1 none RxWorks select * from [Item Quantity Break] inner join [item] on [Item Quantity Break].[Item Code]=[Item].[Item Code] 0 N N 59 139 Y Medication Unit prices OpenVPMSLoaderPlugin Y 1 none openvpmsUNITPRICEIDFROMDATE$ID<product.medication>prices[0]<productPrice.unitPrice>fromDatefalsefalseQUANTITY$ID<product.medication>prices[0]<productPrice.unitPrice>quantityfalsefalseMARKUP$ID<product.medication>prices[0]<productPrice.unitPrice>markupfalsefalseMAXDISCOUNT$ID<product.medication>prices[0]<productPrice.unitPrice>maxDiscountfalsefalsePRICE$ID<product.medication>prices[0]<productPrice.unitPrice>pricefalsefalseUOM$ID<product.medication>prices[0]<productPrice.unitPrice>uomfalsefalseCOST$ID<product.medication>prices[0]<productPrice.unitPrice>costfalsefalsetruetrue100 837 274 Y Merchandise Unit Prices OpenVPMSLoaderPlugin Y 1 none openvpmsUNITPRICEIDFROMDATE$ID<product.merchandise>prices[0]<productPrice.unitPrice>fromDatefalsefalseQUANTITY$ID<product.merchandise>prices[0]<productPrice.unitPrice>quantityfalsefalseMARKUP$ID<product.merchandise>prices[0]<productPrice.unitPrice>markupfalsefalseMAXDISCOUNT$ID<product.merchandise>prices[0]<productPrice.unitPrice>maxDiscountfalsefalsePRICE$ID<product.merchandise>prices[0]<productPrice.unitPrice>pricefalsefalseUOM$ID<product.merchandise>prices[0]<productPrice.unitPrice>uomfalsefalseCOST$ID<product.merchandise>prices[0]<productPrice.unitPrice>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 Date FROMDATE -2 -2 Item Quantity QUANTITY -2 -2 Item Markup MARKUP -2 -2 Item Maximum Discount MAXDISCOUNT -2 -2 Item Sale Price PRICE -2 -2 Item Component Name UOM -2 -2 Item Component Fee Group COMPONENTGROUP -2 -2 159 138 Y Select values 2 SelectValues Y 1 none Item Code ID -2 -2 Item Date FROMDATE -2 -2 Item Component Cost Price COST -2 -2 154 295 Y Service Unit Prices OpenVPMSLoaderPlugin Y 1 none openvpmsUNITPRICEIDFROMDATE$ID<product.service>prices[0]<productPrice.unitPrice>fromDatefalsefalseQUANTITY$ID<product.service>prices[0]<productPrice.unitPrice>quantityfalsefalseMARKUP$ID<product.service>prices[0]<productPrice.unitPrice>markupfalsefalseMAXDISCOUNT$ID<product.service>prices[0]<productPrice.unitPrice>maxDiscountfalsefalsePRICE$ID<product.service>prices[0]<productPrice.unitPrice>pricefalsefalseUOM$ID<product.service>prices[0]<productPrice.unitPrice>uomfalsefalseCOST$ID<product.service>prices[0]<productPrice.unitPrice>costfalsefalsetruetrue1000 832 141 Y Sort rows SortRows Y 1 none %%java.io.tmpdir%% out 5000 Y ID Y QUANTITY Y FROMDATE N 247 138 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