{ "ReportVersion": "2020.2.1.0", "ReportGuid": "6841c322468445f6b4793c01e374c040", "ReportName": "Report", "ReportAlias": "Report", "ReportCreated": "/Date(329400000+0530)/", "ReportChanged": "/Date(1657017065482+0530)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "PreviewSettings": 268435455, "Script": "using System;\r\nusing System.Drawing;\r\nusing System.Windows.Forms;\r\nusing System.Data;\r\nusing Stimulsoft.Controls;\r\nusing Stimulsoft.Base.Drawing;\r\nusing Stimulsoft.Report;\r\nusing Stimulsoft.Report.Dialogs;\r\nusing Stimulsoft.Report.Components;\r\n\r\nnamespace Reports\r\n{\r\n public class Report : Stimulsoft.Report.StiReport\r\n {\r\n public Report() {\r\n this.InitializeComponent();\r\n }\r\n\r\n #region StiReport Designer generated code - do not modify\r\n\t\t#endregion StiReport Designer generated code - do not modify\r\n }\r\n}\r\n", "ReferencedAssemblies": { "0": "System.Dll", "1": "System.Drawing.Dll", "2": "System.Windows.Forms.Dll", "3": "System.Data.Dll", "4": "System.Xml.Dll", "5": "Stimulsoft.Controls.Dll", "6": "Stimulsoft.Base.Dll", "7": "Stimulsoft.Report.Dll" }, "Dictionary": { "Variables": { "0": { "Name": "Company", "Alias": "Company", "Type": "System.String" }, "1": { "Name": "Email", "Alias": "Email", "Type": "System.String", "ReadOnly": true }, "2": { "Value": "AFT1056", "Name": "Orderno", "DialogInfo": { "DateTimeType": "DateAndTime" }, "Alias": "Orderno", "Type": "System.String", "RequestFromUser": true } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "DataSource1", "Alias": "DataSource1", "Key": "fc91b6a7571443a299c092500ffc5a26", "Columns": { "0": { "Name": "BlindTypeExtras", "Index": -1, "NameInSource": "BlindTypeExtras", "Alias": "BlindTypeExtras", "Type": "System.String" }, "1": { "Name": "Brackets", "Index": -1, "NameInSource": "Brackets", "Alias": "Brackets", "Type": "System.String" }, "2": { "Name": "CAddres", "Index": -1, "NameInSource": "CAddres", "Alias": "CAddres", "Type": "System.String" }, "3": { "Name": "CAddres1", "Index": -1, "NameInSource": "CAddres1", "Alias": "CAddres1", "Type": "System.String" }, "4": { "Name": "CPostCode", "Index": -1, "NameInSource": "CPostCode", "Alias": "CPostCode", "Type": "System.String" }, "5": { "Name": "Ccity", "Index": -1, "NameInSource": "Ccity", "Alias": "Ccity", "Type": "System.String" }, "6": { "Name": "Ccountry", "Index": -1, "NameInSource": "Ccountry", "Alias": "Ccountry", "Type": "System.String" }, "7": { "Name": "Cemail", "Index": -1, "NameInSource": "Cemail", "Alias": "Cemail", "Type": "System.String" }, "8": { "Name": "Cfax", "Index": -1, "NameInSource": "Cfax", "Alias": "Cfax", "Type": "System.String" }, "9": { "Name": "Cname", "Index": -1, "NameInSource": "Cname", "Alias": "Cname", "Type": "System.String" }, "10": { "Name": "ComponentExtras", "Index": -1, "NameInSource": "ComponentExtras", "Alias": "ComponentExtras", "Type": "System.String" }, "11": { "Name": "Controls", "Index": -1, "NameInSource": "Controls", "Alias": "Controls", "Type": "System.String" }, "12": { "Name": "Cphone", "Index": -1, "NameInSource": "Cphone", "Alias": "Cphone", "Type": "System.String" }, "13": { "Name": "Cstate", "Index": -1, "NameInSource": "Cstate", "Alias": "Cstate", "Type": "System.String" }, "14": { "Name": "CustDiscount", "Index": -1, "NameInSource": "CustDiscount", "Alias": "CustDiscount", "Type": "System.Decimal" }, "15": { "Name": "CustDiscountcomp", "Index": -1, "NameInSource": "CustDiscountcomp", "Alias": "CustDiscountcomp", "Type": "System.Decimal" }, "16": { "Name": "CutCharge", "Index": -1, "NameInSource": "CutCharge", "Alias": "CutCharge", "Type": "System.String" }, "17": { "Name": "CutChargeSubComp", "Index": -1, "NameInSource": "CutChargeSubComp", "Alias": "CutChargeSubComp", "Type": "System.String" }, "18": { "Name": "CutChargeSubCompprice", "Index": -1, "NameInSource": "CutChargeSubCompprice", "Alias": "CutChargeSubCompprice", "Type": "System.Decimal" }, "19": { "Name": "Cwebsite", "Index": -1, "NameInSource": "Cwebsite", "Alias": "Cwebsite", "Type": "System.String" }, "20": { "Name": "DelAddress", "Index": -1, "NameInSource": "DelAddress", "Alias": "DelAddress", "Type": "System.String" }, "21": { "Name": "DelAddress1", "Index": -1, "NameInSource": "DelAddress1", "Alias": "DelAddress1", "Type": "System.String" }, "22": { "Name": "DelAddress2", "Index": -1, "NameInSource": "DelAddress2", "Alias": "DelAddress2", "Type": "System.String" }, "23": { "Name": "DelCity", "Index": -1, "NameInSource": "DelCity", "Alias": "DelCity", "Type": "System.String" }, "24": { "Name": "DelCounty", "Index": -1, "NameInSource": "DelCounty", "Alias": "DelCounty", "Type": "System.String" }, "25": { "Name": "Delcompany", "Index": -1, "NameInSource": "Delcompany", "Alias": "Delcompany", "Type": "System.String" }, "26": { "Name": "Delcountry", "Index": -1, "NameInSource": "Delcountry", "Alias": "Delcountry", "Type": "System.String" }, "27": { "Name": "Delmobile", "Index": -1, "NameInSource": "Delmobile", "Alias": "Delmobile", "Type": "System.String" }, "28": { "Name": "Delphone", "Index": -1, "NameInSource": "Delphone", "Alias": "Delphone", "Type": "System.String" }, "29": { "Name": "Delpostcode", "Index": -1, "NameInSource": "Delpostcode", "Alias": "Delpostcode", "Type": "System.String" }, "30": { "Name": "Descriptions", "Index": -1, "NameInSource": "Descriptions", "Alias": "Descriptions", "Type": "System.String" }, "31": { "Name": "Extras", "Index": -1, "NameInSource": "Extras", "Alias": "Extras", "Type": "System.String" }, "32": { "Name": "Extras1", "Index": -1, "NameInSource": "Extras1", "Alias": "Extras1", "Type": "System.String" }, "33": { "Name": "Extras2", "Index": -1, "NameInSource": "Extras2", "Alias": "Extras2", "Type": "System.String" }, "34": { "Name": "Extras3", "Index": -1, "NameInSource": "Extras3", "Alias": "Extras3", "Type": "System.String" }, "35": { "Name": "Extras4", "Index": -1, "NameInSource": "Extras4", "Alias": "Extras4", "Type": "System.String" }, "36": { "Name": "Extrasnetpriceformula", "Index": -1, "NameInSource": "Extrasnetpriceformula", "Alias": "Extrasnetpriceformula", "Type": "System.String", "Ident": "Calc", "Expression": "IIF(DataSource1.overrideprice!=\"\",\"\",(System.Convert.ToDouble(DataSource1.listprice)-System.Convert.ToDouble(DataSource1.Netpriceforpricetable)))" }, "37": { "Name": "Extrasprice", "Index": -1, "NameInSource": "Extrasprice", "Alias": "Extrasprice", "Type": "System.Decimal" }, "38": { "Name": "Fabric", "Index": -1, "NameInSource": "Fabric", "Alias": "Fabric", "Type": "System.String" }, "39": { "Name": "FabricExtra", "Index": -1, "NameInSource": "FabricExtra", "Alias": "FabricExtra", "Type": "System.String" }, "40": { "Name": "FurtherInstructions", "Index": -1, "NameInSource": "FurtherInstructions", "Alias": "FurtherInstructions", "Type": "System.String" }, "41": { "Name": "HeadrailColour", "Index": -1, "NameInSource": "HeadrailColour", "Alias": "HeadrailColour", "Type": "System.String" }, "42": { "Name": "In_Date", "Index": -1, "NameInSource": "In_Date", "Alias": "In_Date", "Type": "System.DateTime" }, "43": { "Name": "Inno", "Index": -1, "NameInSource": "Inno", "Alias": "Inno", "Type": "System.String" }, "44": { "Name": "Locations", "Index": -1, "NameInSource": "Locations", "Alias": "Locations", "Type": "System.String" }, "45": { "Name": "Mrs", "Index": -1, "NameInSource": "Mrs", "Alias": "Mrs", "Type": "System.String" }, "46": { "Name": "Netpriceforpricetable", "Index": -1, "NameInSource": "Netpriceforpricetable", "Alias": "Netpriceforpricetable", "Type": "System.String", "Ident": "Calc", "Expression": "(DataSource1.Newprice-(System.Convert.ToDouble(DataSource1.Newprice)*System.Convert.ToDouble(DataSource1.CustDiscount))/100)" }, "47": { "Name": "Newprice", "Index": -1, "NameInSource": "Newprice", "Alias": "Newprice", "Type": "System.Decimal" }, "48": { "Name": "Newpriceplus", "Index": -1, "NameInSource": "Newpriceplus", "Alias": "Newpriceplus", "Type": "System.Int32", "Ident": "Calc", "Expression": "IIF(System.Convert.ToDouble(DataSource1.oioverrideprice)>0,DataSource1.oioverrideprice,System.Convert.ToDouble(DataSource1.Newprice) + System.Convert.ToDouble(DataSource1.xprice) +System.Convert.ToDouble(DataSource1.yprice) +System.Convert.ToDouble(DataSource1.xyprice) +System.Convert.ToDouble(DataSource1.fixprice) +((System.Convert.ToDouble(DataSource1.perprice)/100)*System.Convert.ToDouble(DataSource1.Newprice)))" }, "49": { "Name": "Newunitpriceextras", "Index": -1, "NameInSource": "Newunitpriceextras", "Alias": "Newunitpriceextras", "Type": "System.String", "Ident": "Calc", "Expression": "Round(System.Convert.ToDouble(DataSource1.itemcost)-System.Convert.ToDouble(DataSource1.Newprice),2)" }, "50": { "Name": "Product", "Index": -1, "NameInSource": "Product", "Alias": "Product", "Type": "System.String" }, "51": { "Name": "ProductExtras", "Index": -1, "NameInSource": "ProductExtras", "Alias": "ProductExtras", "Type": "System.String" }, "52": { "Name": "ProductExtrasQTY", "Index": -1, "NameInSource": "ProductExtrasQTY", "Alias": "ProductExtrasQTY", "Type": "System.Decimal" }, "53": { "Name": "Ptype", "Index": -1, "NameInSource": "Ptype", "Alias": "Ptype", "Type": "System.String" }, "54": { "Name": "SDrope", "Index": -1, "NameInSource": "SDrope", "Alias": "SDrope", "Type": "System.Decimal" }, "55": { "Name": "SWidth", "Index": -1, "NameInSource": "SWidth", "Alias": "SWidth", "Type": "System.Decimal" }, "56": { "Name": "ShuFabric", "Index": -1, "NameInSource": "ShuFabric", "Alias": "ShuFabric", "Type": "System.String" }, "57": { "Name": "SuName", "Index": -1, "NameInSource": "SuName", "Alias": "SuName", "Type": "System.String" }, "58": { "Name": "SubColour1", "Index": -1, "NameInSource": "SubColour1", "Alias": "SubColour1", "Type": "System.String" }, "59": { "Name": "Subtotalb", "Index": -1, "NameInSource": "Subtotalb", "Alias": "Subtotalb", "Type": "System.String" }, "60": { "Name": "Supplier", "Index": -1, "NameInSource": "Supplier", "Alias": "Supplier", "Type": "System.String" }, "61": { "Name": "Terms", "Index": -1, "NameInSource": "Terms", "Alias": "Terms", "Type": "System.String" }, "62": { "Name": "Termsorg", "Index": -1, "NameInSource": "Termsorg", "Alias": "Termsorg", "Type": "System.String" }, "63": { "Name": "Totab", "Index": -1, "NameInSource": "Totab", "Alias": "Totab", "Type": "System.Decimal" }, "64": { "Name": "Tprice", "Index": -1, "NameInSource": "Tprice", "Alias": "Tprice", "Type": "System.String" }, "65": { "Name": "Unitprice", "Index": -1, "NameInSource": "Unitprice", "Alias": "Unitprice", "Type": "System.String" }, "66": { "Name": "Unitpriceformula", "Index": -1, "NameInSource": "Unitpriceformula", "Alias": "Unitpriceformula", "Type": "System.String", "Ident": "Calc", "Expression": "IIF(DataSource1.product_no==\"3301\",(DataSource1.Extrasprice*DataSource1.domesticmarkupExtrasprice),DataSource1.itemcost)" }, "67": { "Name": "Unitpricnew", "Index": -1, "NameInSource": "Unitpricnew", "Alias": "Unitpricnew", "Type": "System.Int32", "Ident": "Calc", "Expression": "System.Convert.ToDouble(DataSource1.Tprice) - System.Convert.ToDouble(DataSource1.Extrasprice)" }, "68": { "Name": "aaa", "Index": -1, "NameInSource": "aaa", "Alias": "aaa", "Type": "System.String" }, "69": { "Name": "accountnumber", "Index": -1, "NameInSource": "accountnumber", "Alias": "accountnumber", "Type": "System.String" }, "70": { "Name": "accref", "Index": -1, "NameInSource": "accref", "Alias": "accref", "Type": "System.String" }, "71": { "Name": "address", "Index": -1, "NameInSource": "address", "Alias": "address", "Type": "System.String" }, "72": { "Name": "address1", "Index": -1, "NameInSource": "address1", "Alias": "address1", "Type": "System.String" }, "73": { "Name": "altphone", "Index": -1, "NameInSource": "altphone", "Alias": "altphone", "Type": "System.String" }, "74": { "Name": "amountoutstanding", "Index": -1, "NameInSource": "amountoutstanding", "Alias": "amountoutstanding", "Type": "System.Decimal" }, "75": { "Name": "bankname", "Index": -1, "NameInSource": "bankname", "Alias": "bankname", "Type": "System.String" }, "76": { "Name": "city", "Index": -1, "NameInSource": "city", "Alias": "city", "Type": "System.String" }, "77": { "Name": "comment", "Index": -1, "NameInSource": "comment", "Alias": "comment", "Type": "System.String" }, "78": { "Name": "company", "Index": -1, "NameInSource": "company", "Alias": "company", "Type": "System.String" }, "79": { "Name": "companyName", "Index": -1, "NameInSource": "companyName", "Alias": "companyName", "Type": "System.String" }, "80": { "Name": "country_curr", "Index": -1, "NameInSource": "country_curr", "Alias": "country_curr", "Type": "System.String" }, "81": { "Name": "county", "Index": -1, "NameInSource": "county", "Alias": "county", "Type": "System.String" }, "82": { "Name": "createddate", "Index": -1, "NameInSource": "createddate", "Alias": "createddate", "Type": "System.DateTime" }, "83": { "Name": "currency_symbol", "Index": -1, "NameInSource": "currency_symbol", "Alias": "currency_symbol", "Type": "System.String" }, "84": { "Name": "curtainfabric", "Index": -1, "NameInSource": "curtainfabric", "Alias": "curtainfabric", "Type": "System.String" }, "85": { "Name": "customer_discount", "Index": -1, "NameInSource": "customer_discount", "Alias": "customer_discount", "Type": "System.String" }, "86": { "Name": "custref", "Index": -1, "NameInSource": "custref", "Alias": "custref", "Type": "System.String" }, "87": { "Name": "custtype", "Index": -1, "NameInSource": "custtype", "Alias": "custtype", "Type": "System.String" }, "88": { "Name": "daterequired", "Index": -1, "NameInSource": "daterequired", "Alias": "daterequired", "Type": "System.DateTime" }, "89": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "90": { "Name": "discount_amount_value", "Index": -1, "NameInSource": "discount_amount_value", "Alias": "discount_amount_value", "Type": "System.Decimal" }, "91": { "Name": "discount_percentage_value", "Index": -1, "NameInSource": "discount_percentage_value", "Alias": "discount_percentage_value", "Type": "System.Decimal" }, "92": { "Name": "domesticmarkupExtrasprice", "Index": -1, "NameInSource": "domesticmarkupExtrasprice", "Alias": "domesticmarkupExtrasprice", "Type": "System.Decimal" }, "93": { "Name": "drope", "Index": -1, "NameInSource": "drope", "Alias": "drope", "Type": "System.String" }, "94": { "Name": "email", "Index": -1, "NameInSource": "email", "Alias": "email", "Type": "System.String" }, "95": { "Name": "firstname", "Index": -1, "NameInSource": "firstname", "Alias": "firstname", "Type": "System.String" }, "96": { "Name": "fixprice", "Index": -1, "NameInSource": "fixprice", "Alias": "fixprice", "Type": "System.Decimal" }, "97": { "Name": "gross_override_value", "Index": -1, "NameInSource": "gross_override_value", "Alias": "gross_override_value", "Type": "System.String" }, "98": { "Name": "invoicedate", "Index": -1, "NameInSource": "invoicedate", "Alias": "invoicedate", "Type": "System.DateTime" }, "99": { "Name": "invoicedescription", "Index": -1, "NameInSource": "invoicedescription", "Alias": "invoicedescription", "Type": "System.String" }, "100": { "Name": "itemcost", "Index": -1, "NameInSource": "itemcost", "Alias": "itemcost", "Type": "System.Decimal" }, "101": { "Name": "itemoverride", "Index": -1, "NameInSource": "itemoverride", "Alias": "itemoverride", "Type": "System.String" }, "102": { "Name": "label3", "Index": -1, "NameInSource": "label3", "Alias": "label3", "Type": "System.String" }, "103": { "Name": "label4", "Index": -1, "NameInSource": "label4", "Alias": "label4", "Type": "System.String" }, "104": { "Name": "listprice", "Index": -1, "NameInSource": "listprice", "Alias": "listprice", "Type": "System.Decimal" }, "105": { "Name": "logoname", "Index": -1, "NameInSource": "logoname", "Alias": "logoname", "Type": "System.String" }, "106": { "Name": "mobile", "Index": -1, "NameInSource": "mobile", "Alias": "mobile", "Type": "System.String" }, "107": { "Name": "net_override_value", "Index": -1, "NameInSource": "net_override_value", "Alias": "net_override_value", "Type": "System.String" }, "108": { "Name": "netprice", "Index": -1, "NameInSource": "netprice", "Alias": "netprice", "Type": "System.Decimal" }, "109": { "Name": "newcolourlisttext", "Index": -1, "NameInSource": "newcolourlisttext", "Alias": "newcolourlisttext", "Type": "System.String" }, "110": { "Name": "oioverrideprice", "Index": -1, "NameInSource": "oioverrideprice", "Alias": "oioverrideprice", "Type": "System.String" }, "111": { "Name": "orderdate", "Index": -1, "NameInSource": "orderdate", "Alias": "orderdate", "Type": "System.DateTime" }, "112": { "Name": "overrideprice", "Index": -1, "NameInSource": "overrideprice", "Alias": "overrideprice", "Type": "System.String" }, "113": { "Name": "overridetypeid", "Index": -1, "NameInSource": "overridetypeid", "Alias": "overridetypeid", "Type": "System.Int32" }, "114": { "Name": "paymentterms", "Index": -1, "NameInSource": "paymentterms", "Alias": "paymentterms", "Type": "System.String" }, "115": { "Name": "perprice", "Index": -1, "NameInSource": "perprice", "Alias": "perprice", "Type": "System.Decimal" }, "116": { "Name": "phone", "Index": -1, "NameInSource": "phone", "Alias": "phone", "Type": "System.String" }, "117": { "Name": "postcode", "Index": -1, "NameInSource": "postcode", "Alias": "postcode", "Type": "System.String" }, "118": { "Name": "product_no", "Index": -1, "NameInSource": "product_no", "Alias": "product_no", "Type": "System.String" }, "119": { "Name": "productname", "Index": -1, "NameInSource": "productname", "Alias": "productname", "Type": "System.String" }, "120": { "Name": "productname1", "Index": -1, "NameInSource": "productname1", "Alias": "productname1", "Type": "System.String" }, "121": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.Int32" }, "122": { "Name": "quantity", "Index": -1, "NameInSource": "quantity", "Alias": "quantity", "Type": "System.Decimal" }, "123": { "Name": "quotationdescription", "Index": -1, "NameInSource": "quotationdescription", "Alias": "quotationdescription", "Type": "System.String" }, "124": { "Name": "s_h_amount", "Index": -1, "NameInSource": "s_h_amount", "Alias": "s_h_amount", "Type": "System.Decimal" }, "125": { "Name": "salesorder_no", "Index": -1, "NameInSource": "salesorder_no", "Alias": "salesorder_no", "Type": "System.String" }, "126": { "Name": "sequence_no", "Index": -1, "NameInSource": "sequence_no", "Alias": "sequence_no", "Type": "System.Int32" }, "127": { "Name": "softadjustmenttype", "Index": -1, "NameInSource": "softadjustmenttype", "Alias": "softadjustmenttype", "Type": "System.Int32" }, "128": { "Name": "sortcode", "Index": -1, "NameInSource": "sortcode", "Alias": "sortcode", "Type": "System.String" }, "129": { "Name": "sostatus", "Index": -1, "NameInSource": "sostatus", "Alias": "sostatus", "Type": "System.String" }, "130": { "Name": "specialterms", "Index": -1, "NameInSource": "specialterms", "Alias": "specialterms", "Type": "System.String" }, "131": { "Name": "subtotal", "Index": -1, "NameInSource": "subtotal", "Alias": "subtotal", "Type": "System.Decimal" }, "132": { "Name": "surname", "Index": -1, "NameInSource": "surname", "Alias": "surname", "Type": "System.String" }, "133": { "Name": "tax_final", "Index": -1, "NameInSource": "tax_final", "Alias": "tax_final", "Type": "System.Decimal" }, "134": { "Name": "termseight", "Index": -1, "NameInSource": "termseight", "Alias": "termseight", "Type": "System.String" }, "135": { "Name": "termsfive", "Index": -1, "NameInSource": "termsfive", "Alias": "termsfive", "Type": "System.String" }, "136": { "Name": "termsfour", "Index": -1, "NameInSource": "termsfour", "Alias": "termsfour", "Type": "System.String" }, "137": { "Name": "termsnine", "Index": -1, "NameInSource": "termsnine", "Alias": "termsnine", "Type": "System.String" }, "138": { "Name": "termsone", "Index": -1, "NameInSource": "termsone", "Alias": "termsone", "Type": "System.String" }, "139": { "Name": "termsseven", "Index": -1, "NameInSource": "termsseven", "Alias": "termsseven", "Type": "System.String" }, "140": { "Name": "termssix", "Index": -1, "NameInSource": "termssix", "Alias": "termssix", "Type": "System.String" }, "141": { "Name": "termsten", "Index": -1, "NameInSource": "termsten", "Alias": "termsten", "Type": "System.String" }, "142": { "Name": "termsthree", "Index": -1, "NameInSource": "termsthree", "Alias": "termsthree", "Type": "System.String" }, "143": { "Name": "termstwo", "Index": -1, "NameInSource": "termstwo", "Alias": "termstwo", "Type": "System.String" }, "144": { "Name": "title", "Index": -1, "NameInSource": "title", "Alias": "title", "Type": "System.String" }, "145": { "Name": "total", "Index": -1, "NameInSource": "total", "Alias": "total", "Type": "System.Decimal" }, "146": { "Name": "totalpaid", "Index": -1, "NameInSource": "totalpaid", "Alias": "totalpaid", "Type": "System.Decimal" }, "147": { "Name": "usecustomerspecificvatrate", "Index": -1, "NameInSource": "usecustomerspecificvatrate", "Alias": "usecustomerspecificvatrate", "Type": "System.String" }, "148": { "Name": "usespecialterms", "Index": -1, "NameInSource": "usespecialterms", "Alias": "usespecialterms", "Type": "System.String" }, "149": { "Name": "usetermseight", "Index": -1, "NameInSource": "usetermseight", "Alias": "usetermseight", "Type": "System.String" }, "150": { "Name": "usetermsfive", "Index": -1, "NameInSource": "usetermsfive", "Alias": "usetermsfive", "Type": "System.String" }, "151": { "Name": "usetermsfour", "Index": -1, "NameInSource": "usetermsfour", "Alias": "usetermsfour", "Type": "System.String" }, "152": { "Name": "usetermsnine", "Index": -1, "NameInSource": "usetermsnine", "Alias": "usetermsnine", "Type": "System.String" }, "153": { "Name": "usetermsone", "Index": -1, "NameInSource": "usetermsone", "Alias": "usetermsone", "Type": "System.String" }, "154": { "Name": "usetermsseven", "Index": -1, "NameInSource": "usetermsseven", "Alias": "usetermsseven", "Type": "System.String" }, "155": { "Name": "usetermssix", "Index": -1, "NameInSource": "usetermssix", "Alias": "usetermssix", "Type": "System.String" }, "156": { "Name": "usetermsten", "Index": -1, "NameInSource": "usetermsten", "Alias": "usetermsten", "Type": "System.String" }, "157": { "Name": "usetermsthree", "Index": -1, "NameInSource": "usetermsthree", "Alias": "usetermsthree", "Type": "System.String" }, "158": { "Name": "usetermstwo", "Index": -1, "NameInSource": "usetermstwo", "Alias": "usetermstwo", "Type": "System.String" }, "159": { "Name": "vatnumber", "Index": -1, "NameInSource": "vatnumber", "Alias": "vatnumber", "Type": "System.String" }, "160": { "Name": "vatrate", "Index": -1, "NameInSource": "vatrate", "Alias": "vatrate", "Type": "System.Decimal" }, "161": { "Name": "vatvalue", "Index": -1, "NameInSource": "vatvalue", "Alias": "vatvalue", "Type": "System.Decimal" }, "162": { "Name": "width", "Index": -1, "NameInSource": "width", "Alias": "width", "Type": "System.String" }, "163": { "Name": "widthmeasuretype", "Index": -1, "NameInSource": "widthmeasuretype", "Alias": "widthmeasuretype", "Type": "System.String" }, "164": { "Name": "xprice", "Index": -1, "NameInSource": "xprice", "Alias": "xprice", "Type": "System.Decimal" }, "165": { "Name": "xyprice", "Index": -1, "NameInSource": "xyprice", "Alias": "xyprice", "Type": "System.Decimal" }, "166": { "Name": "yprice", "Index": -1, "NameInSource": "yprice", "Alias": "yprice", "Type": "System.Decimal" } }, "NameInSource": "My", "SqlCommand": "SELECT DISTINCT\r\n\r\nReplace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(vtiger_inventoryproductrel.parametername_textvalues,\"##Fitting Height: mm##, \",\"\"), \" \", \" \"),\" \", \" \"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 6,1), \"\"),\" \"), \"\"),IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 7,1), \"\"),\" \"), \"\"),IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 8,1), \"\"),\" \"), \"\"),IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 9,1), \"\"),\" \"), \"\"),IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrder.value, \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='3') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 10,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 6,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 7,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 8,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 9,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_EditableList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='2') Limit 10,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_ParameterType.productTypeSubName), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_ParameterType.productTypeSubName, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_ParameterType ON softMax_SalesOrder.parameterId = softMax_ParameterType.parameterId AND softMax_SalesOrder.value = softMax_ParameterType.parameterTypeId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='10') and softMax_ParameterType.status = '0' and softMax_SalesOrder.status = '0' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value, \" \", IF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\nIF(vtiger_inventoryproductrel.widthfraction='0','',\r\nIF(vtiger_inventoryproductrel.widthfraction='1','1/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='2','1/4 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='3','3/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='4','1/2 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='5','5/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='6','3/4 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='7','7/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='9','1/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='10','3/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='11','5/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='12','7/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='13','9/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='14','11/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='15','13/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='16','15/16 ','')))))))))))))))), \"\"), vtiger_inventoryproductrel.widthmeasuretype), if(softMax_ProductsParameter.specinvo = \"1~0\", concat(softMax_SalesOrder.value, \" \", IF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\nIF(vtiger_inventoryproductrel.widthfraction='0','',\r\nIF(vtiger_inventoryproductrel.widthfraction='1','1/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='2','1/4 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='3','3/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='4','1/2 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='5','5/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='6','3/4 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='7','7/8 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='9','1/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='10','3/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='11','5/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='12','7/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='13','9/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='14','11/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='15','13/16 ',\r\nIF(vtiger_inventoryproductrel.widthfraction='16','15/16 ','')))))))))))))))), \"\"), vtiger_inventoryproductrel.widthmeasuretype), \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='4') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value, \" \", IF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\nIF(vtiger_inventoryproductrel.dropfraction='0','',\r\nIF(vtiger_inventoryproductrel.dropfraction='1','1/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='2','1/4 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='3','3/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='4','1/2 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='5','5/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='6','3/4 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='7','7/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='9','1/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='10','3/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='11','5/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='12','7/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='13','9/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='14','11/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='15','13/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='16','15/16 ','')))))))))))))))), \"\"), vtiger_inventoryproductrel.widthmeasuretype), if(softMax_ProductsParameter.specinvo = \"1~0\", concat(softMax_SalesOrder.value, \" \", IF(vtiger_inventoryproductrel.widthmeasuretype='inch',\r\nIF(vtiger_inventoryproductrel.dropfraction='0','',\r\nIF(vtiger_inventoryproductrel.dropfraction='1','1/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='2','1/4 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='3','3/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='4','1/2 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='5','5/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='6','3/4 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='7','7/8 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='9','1/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='10','3/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='11','5/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='12','7/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='13','9/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='14','11/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='15','13/16 ',\r\nIF(vtiger_inventoryproductrel.dropfraction='16','15/16 ','')))))))))))))))), \"\"), vtiger_inventoryproductrel.widthmeasuretype), \"\"))))\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='5') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(\"##\",softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(\"##\",softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value, \" \", vtiger_inventoryproductrel.widthmeasuretype,'##',\", \"), if(softMax_ProductsParameter.specinvo = \"1~0\", concat(softMax_SalesOrder.value, \" \", vtiger_inventoryproductrel.widthmeasuretype,'##',\", \"), \"\"))))\r\nFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='6') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(\"##\",softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(\"##\",softMax_ProductsParameter.parameterName, \": \", softMax_SalesOrder.value, \" \", vtiger_inventoryproductrel.widthmeasuretype,'##',\", \"), if(softMax_ProductsParameter.specinvo = \"1~0\", concat(softMax_SalesOrder.value, \" \", vtiger_inventoryproductrel.widthmeasuretype,'##',\", \"), \"\"))))\r\nFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterListId='7') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 6,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 7,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 8,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 9,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ProductsParameter.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ProductsParameter.parameterName, \": \", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')), if(softMax_ProductsParameter.specinvo = \"1~0\", GROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', '), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterListId='18' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.parameterid Limit 10,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 1\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1) GROUP by softMax_SubComponent.priceid Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 11\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 11) GROUP by softMax_SubComponent.priceid Limit 6,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nTrim(if(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\")))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 12\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 12) GROUP by softMax_SubComponent.priceid Limit 6,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 1,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 2,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 3,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 4,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 5,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT \r\nif(softMax_SubComponent.spec_compinvo = \"0~1\", concat(softMax_SubComponent.componentname, \": \"), if(softMax_SubComponent.spec_compinvo = \"1~1\", \"\", if(softMax_SubComponent.spec_compinvo = \"0~0\", concat(softMax_SubComponent.componentname, \": \", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ',')), if(softMax_SubComponent.spec_compinvo = \"1~0\", GROUP_CONCAT(softMax_SubFixedpriceSalesorder.componentname SEPARATOR ','), \"\"))))\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN softMax_SubComponent ON softMax_SubComponent.component_id = softMax_FixedpriceSalesorder.fixedpriceid\r\nINNER JOIN softMax_SubFixedpriceSalesorder ON softMax_SubFixedpriceSalesorder.component_id = softMax_SubComponent.priceid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nand softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\r\nand softMax_SubComponent.status = 0\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid\r\nand softMax_SubComponent.productid = vtiger_inventoryproductrel.productid and softMax_SubComponent.fixedorpercentage = 15\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 15) GROUP by softMax_SubComponent.priceid Limit 6,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_ParameterTypeSub.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_ParameterTypeSub.parameterName, \": \", softMax_EditableSubList.Name), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableSubList.Name, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_ParameterType ON softMax_SalesOrder.parameterId = softMax_ParameterType.parameterId AND softMax_SalesOrder.value = softMax_ParameterType.parameterTypeId\r\nRIGHT Join softMax_SalesOrderProductTypeValue ON softMax_SalesOrderProductTypeValue.salesorderid = softMax_SalesOrder.salesorderid AND softMax_SalesOrderProductTypeValue.inventoryproductrelSequenceNo = softMax_SalesOrder.inventoryproductrelSequenceNo\r\nRIGHT Join softMax_EditableSubList ON softMax_SalesOrderProductTypeValue.parameterTypeSubSubId = softMax_EditableSubList.parameterTypeSubSubId\r\nRIGHT Join softMax_ParameterTypeSub ON softMax_EditableSubList.parameterTypeSubId = softMax_ParameterTypeSub.parameterTypeSubId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id AND softMax_SalesOrder.status = '0'\r\nAND softMax_ParameterTypeSub.parameterTypeId = softMax_ParameterType.parameterTypeId\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid AND softMax_ParameterTypeSub.status = 0\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='10') and softMax_ParameterType.status = '0' and softMax_SalesOrder.status = '0' and softMax_SalesOrderProductTypeValue.status = 0 and softMax_EditableSubList.status = 0 Limit 0,1), \"\"),\" \"), \"\"), IFNULL(COALESCE((SELECT CASE WHEN \r\n(SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_EditParameterTypeSub.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_EditParameterTypeSub.parameterName, \": \", softMax_EditableSubSubList.productSubSubName), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableSubSubList.productSubSubName, \"\"))))\r\nFROM\r\nvtiger_salesorder\r\nINNER JOIN softMax_SalesOrder on vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nINNER Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nINNER JOIN softMax_SalesOrderSub on vtiger_salesorder.salesorderid = softMax_SalesOrderSub.salesorderid\r\nInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nInner Join softMax_EditableSubSubList ON softMax_EditParameterTypeSub.productTypeSubId = softMax_EditableSubSubList.productTypeSubId AND softMax_SalesOrderSub.valuee = softMax_EditableSubSubList.productTypeSubSubId\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL) \r\nAND (softMax_ProductsParameter.parameterListId='10')\r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) !='' \r\nTHEN \r\n(SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_EditParameterTypeSub.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_EditParameterTypeSub.parameterName, \": \", softMax_EditableSubSubList.productSubSubName), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_EditableSubSubList.productSubSubName, \"\"))))\r\nFROM\r\nvtiger_salesorder\r\nINNER JOIN softMax_SalesOrder on vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nINNER Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nINNER JOIN softMax_SalesOrderSub on vtiger_salesorder.salesorderid = softMax_SalesOrderSub.salesorderid\r\nInner Join softMax_EditParameterTypeSub ON softMax_EditParameterTypeSub.productTypeSubId = softMax_SalesOrderSub.parametertypesubid\r\nInner Join softMax_EditableSubSubList ON softMax_EditParameterTypeSub.productTypeSubId = softMax_EditableSubSubList.productTypeSubId AND softMax_SalesOrderSub.valuee = softMax_EditableSubSubList.productTypeSubSubId\r\nwhere (softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id OR softMax_SalesOrderSub.salesorderid IS NULL) \r\nAND (softMax_ProductsParameter.parameterListId='10')\r\nAND (softMax_SalesOrderSub.inventoryproductrelSequenceNo =vtiger_inventoryproductrel.sequence_no OR softMax_SalesOrderSub.inventoryproductrelSequenceNo IS NULL) AND softMax_SalesOrderSub.status = '0' Limit 0,1) \r\nELSE \r\n(SELECT\r\nif(softMax_ProductsParameter.specinvo = \"0~1\", concat(softMax_EditParameterTypeSub.parameterName, \": \"), if(softMax_ProductsParameter.specinvo = \"1~1\", \"\", if(softMax_ProductsParameter.specinvo = \"0~0\", concat(softMax_EditParameterTypeSub.parameterName, \": \", softMax_SalesOrderSub.valuee), if(softMax_ProductsParameter.specinvo = \"1~0\", softMax_SalesOrderSub.valuee, \"\"))))\r\nFROM softMax_ProductsParameter\r\nRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_ParameterType ON softMax_SalesOrder.parameterId = softMax_ParameterType.parameterId AND softMax_SalesOrder.value = softMax_ParameterType.parameterTypeId\r\nRIGHT Join softMax_SalesOrderProductTypeValue ON softMax_SalesOrderProductTypeValue.salesorderid = softMax_SalesOrder.salesorderid AND softMax_SalesOrderProductTypeValue.inventoryproductrelSequenceNo = softMax_SalesOrder.inventoryproductrelSequenceNo\r\nRIGHT Join softMax_EditableSubList ON softMax_SalesOrderProductTypeValue.parameterTypeSubSubId = softMax_EditableSubList.parameterTypeSubSubId\r\nRIGHT Join softMax_ParameterTypeSub ON softMax_EditableSubList.parameterTypeSubId = softMax_ParameterTypeSub.parameterTypeSubId\r\nright join softMax_EditParameterTypeSub on softMax_EditParameterTypeSub.parameterTypeSubSubId = softMax_EditableSubList.parameterTypeSubSubId\r\nright join softMax_SalesOrderSub on softMax_SalesOrderSub.parametertypesubid = softMax_EditParameterTypeSub.productTypeSubId\r\n\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id AND softMax_SalesOrder.status = '0'\r\nAND softMax_ParameterTypeSub.parameterTypeId = softMax_ParameterType.parameterTypeId\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid AND softMax_ParameterTypeSub.status = 0\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND (softMax_ProductsParameter.parameterListId='10') and softMax_ParameterType.status = '0'\r\nand softMax_SalesOrderSub.salesorderid = vtiger_inventoryproductrel.id and softMax_SalesOrder.status = '0' and softMax_SalesOrderProductTypeValue.status = 0 and softMax_EditableSubList.status = 0 Limit 0,1) \r\nEND), \"\"),\" \"), \"\") as aaa,\r\n\r\n\r\n\tvtiger_currency_info.label3,\r\n\tvtiger_currency_info.label4,\r\n\tvtiger_account.country_curr,\r\n\tvtiger_currency_info.currency_symbol,\r\n\tvtiger_salesorder.invoicedate,\r\n\tvtiger_salesorder.orderdate,\r\n\tvtiger_inventoryproductrel.sequence_no,\r\n\tvtiger_salesorder.createddate,\r\n\tvtiger_salesorder.salesorder_no,\r\n\tvtiger_salesorder.accref,\r\n\tvtiger_salesorder.title,\r\n\r\n\t(SELECT CASE WHEN (vtiger_salesorder.company=\".\" or vtiger_salesorder.company=\"-\") THEN \"\" ELSE vtiger_salesorder.company END) As company,\r\n(SELECT CASE WHEN (vtiger_salesorder.address=\".\" or vtiger_salesorder.address=\"-\") THEN \"\" ELSE vtiger_salesorder.address END) As address,\r\n(SELECT CASE WHEN (vtiger_salesorder.address1=\".\" or vtiger_salesorder.address1=\"-\") THEN \"\" ELSE vtiger_salesorder.address1 END) As address1,\r\n(SELECT CASE WHEN (vtiger_salesorder.city=\".\" or vtiger_salesorder.city=\"-\") THEN \"\" ELSE vtiger_salesorder.city END) As city,\r\n(SELECT CASE WHEN (vtiger_salesorder.county=\".\" or vtiger_salesorder.county=\"-\") THEN \"\" ELSE vtiger_salesorder.county END) As county,\r\n(SELECT CASE WHEN (vtiger_salesorder.postcode=\".\" or vtiger_salesorder.postcode=\"-\") THEN \"\" ELSE vtiger_salesorder.postcode END) As postcode,\r\nvtiger_salesorder.phone,\r\nvtiger_salesorder.altphone,\r\nvtiger_salesorder.email,\r\nvtiger_salesorder.mobile,\r\nvtiger_salesorder.custref,\r\nvtiger_salesorder.custtype,\r\nvtiger_salesorder.total,\r\nvtiger_salesorder.subtotal,\r\nvtiger_salesorder.totalpaid,\r\nvtiger_salesorder.sostatus,\r\nvtiger_salesorder.s_h_amount,\r\nvtiger_salesorder.amountoutstanding,\r\nvtiger_salesorder.usecustomerspecificvatrate,\r\nvtiger_salesorder.discount_percentage_value,\r\nvtiger_salesorder.discount_amount_value,\r\nvtiger_inventoryproductrel.overrideprice,\r\nvtiger_salesorder.gross_override_value,\r\nvtiger_salesorder.net_override_value,\r\nvtiger_salesorder.softadjustmenttype,\r\nvtiger_salesorder.tax_final,\r\nvtiger_salesorder.daterequired,\r\nvtiger_salesorder.paymentterms,\r\nvtiger_inventoryproductrel.quantity,\r\nvtiger_inventoryproductrel.vatvalue,\r\nvtiger_inventoryproductrel.widthmeasuretype,\r\nCONCAT(IF(vtiger_inventoryproductrel.widthmeasuretype='inch',(vtiger_inventoryproductrel.width),Round(vtiger_inventoryproductrel.width,0)),vtiger_inventoryproductrel.widthmeasuretype,\" \") As width,\r\nCONCAT(\"x \",IF(vtiger_inventoryproductrel.widthmeasuretype='inch',(vtiger_inventoryproductrel.drope), Round(vtiger_inventoryproductrel.drope,0)),vtiger_inventoryproductrel.widthmeasuretype,\", \") As drope,\r\nvtiger_inventoryproductrel.listprice,\r\nvtiger_inventoryproductrel.description,\r\nvtiger_inventoryproductrel.comment,\r\nvtiger_inventoryproductrel.itemcost,\r\nvtiger_inventoryproductrel.overridetypeid,\r\nvtiger_inventoryproductrel.itemoverride,\r\nvtiger_products.product_no,\r\nvtiger_products.customer_discount,\r\nif((vtiger_products.product_no='116' or vtiger_products.product_no='381'),\"Curtain\",vtiger_products.productname) As productname,\r\nvtiger_organizationdetails.bankname,\r\nvtiger_organizationdetails.accountnumber,\r\nvtiger_organizationdetails.sortcode,\r\nvtiger_organizationdetails.vatnumber,\r\nvtiger_organizationdetails.logoname,\r\nvtiger_organizationdetails.vatrate,\r\nvtiger_organizationdetails.organizationname As Cname,\r\nvtiger_organizationdetails.address As CAddres,\r\nvtiger_organizationdetails.address2 As CAddres1,\r\nvtiger_organizationdetails.city As Ccity,\r\nvtiger_organizationdetails.state As Cstate,\r\nvtiger_organizationdetails.country As Ccountry,\r\nvtiger_organizationdetails.code As CPostCode,\r\nvtiger_organizationdetails.phone As Cphone,\r\nvtiger_organizationdetails.fax As Cfax,\r\nvtiger_organizationdetails.email As Cemail,\r\nvtiger_organizationdetails.website As Cwebsite,\r\nsoftMax_AlternateDeliveryAddress.comapnyname As Delcompany,\r\nsoftMax_AlternateDeliveryAddress.mobile As Delmobile,\r\nsoftMax_AlternateDeliveryAddress.addName As DelAddress,\r\nsoftMax_AlternateDeliveryAddress.address1 As DelAddress1,\r\nsoftMax_AlternateDeliveryAddress.address2 As DelAddress2,\r\nsoftMax_AlternateDeliveryAddress.city As DelCity,\r\nsoftMax_AlternateDeliveryAddress.county As DelCounty,\r\nsoftMax_AlternateDeliveryAddress.postcode As Delpostcode,\r\nsoftMax_AlternateDeliveryAddress.country As Delcountry,\r\nsoftMax_AlternateDeliveryAddress.phone As Delphone,\r\nvtiger_salesorder.netprice,\r\nvtiger_salesorder.usespecialterms,\r\nvtiger_salesorder.specialterms,\r\nvtiger_salesorder.quotationdescription,\r\nvtiger_salesorder.invoicedescription,\r\nvtiger_salesorder.termsone,\r\nvtiger_salesorder.termstwo,\r\nvtiger_salesorder.termsthree,\r\nvtiger_salesorder.termsfour,\r\nvtiger_salesorder.termsfive,\r\nvtiger_salesorder.termssix,\r\nvtiger_salesorder.termsseven,\r\nvtiger_salesorder.termseight,\r\nvtiger_salesorder.termsnine,\r\nvtiger_salesorder.termsten,\r\nvtiger_salesorder.usetermsone,\r\nvtiger_salesorder.usetermstwo,\r\nvtiger_salesorder.usetermsthree,\r\nvtiger_salesorder.usetermsfour,\r\nvtiger_salesorder.usetermsfive,\r\nvtiger_salesorder.usetermssix,\r\nvtiger_salesorder.usetermsseven,\r\nvtiger_salesorder.usetermseight,\r\nvtiger_salesorder.usetermsnine,\r\nvtiger_salesorder.usetermsten,\r\n\r\nSUBSTRING_INDEX(REPLACE(if((vtiger_products.product_no='116' or vtiger_products.product_no='381'),\"Curtain\",vtiger_products.productname), \r\nIFNULL(COALESCE(concat((Select \r\n\tSubstring_index ((vtiger_vendor.vendorname),' Blinds',1)\r\n\tFROM\r\n\tvtiger_salesorder\r\n\tinner Join softMax_SalesOrderVendorInfo ON softMax_SalesOrderVendorInfo.salesorderid = vtiger_salesorder.salesorderid \r\nLEFT JOIN vtiger_vendor ON softMax_SalesOrderVendorInfo.vendorid = vtiger_vendor.vendorid\r\nwhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nand vtiger_inventoryproductrel.productid = vtiger_products.productid AND \r\nsoftMax_SalesOrderVendorInfo.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no and (softMax_SalesOrderVendorInfo.status = '0')) Limit 0,1),' '), \"\"),\" \"), ''), '(', 1) as productname1,\r\n\r\n(SELECT\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nFROM\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nvtiger_salesorder\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\ninner join softMax_Component on softMax_Component.priceid = softMax_FixedpriceSalesorder.fixedpriceid and softMax_Component.parameterid = softMax_FixedpriceSalesorder.parameterid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nAND softMax_ProductsParameter.parameterName = 'Component'\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_Component.productid = vtiger_inventoryproductrel.productid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_Component.status = 0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As ComponentExtras,\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\r\n\r\n(SELECT CASE WHEN\r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Product' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1)!='' \r\nTHEN \r\n(SELECT \r\n\tGROUP_CONCAT(softMax_FixedpriceSalesorder.componentname SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.parameterName = 'Product' and softMax_FixedpriceSalesorder.componentname <> 'None'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1)\r\nELSE\r\n(SELECT\r\n\tsoftMax_EditableList.Name\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nRIGHT Join softMax_EditableList ON softMax_SalesOrder.parameterId = softMax_EditableList.parameterId AND softMax_SalesOrder.value = softMax_EditableList.editableListId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_ProductsParameter.parameterName = 'Product' and softMax_EditableList.Name <> 'na' and softMax_EditableList.Name <> 'NA' and softMax_EditableList.Name <> 'n/a' and softMax_EditableList.Name <> 'N/A' and softMax_EditableList.Name <> 'None' Limit 0,1)\r\nEND) As Product,\r\n\r\n(Select if(vtiger_salesorder.quotationdescription<>'',vtiger_salesorder.quotationdescription,IF(vtiger_salesorder.custtype = 'Domestic',vtiger_organizationdetails.domesticpaymentterms,IF(vtiger_salesorder.custtype='Contract',vtiger_organizationdetails.contractpaymentterms,vtiger_organizationdetails.tradepaymentterms)))) As Termsorg,\r\n(SELECT CASE WHEN vtiger_salesorder.company<>'' THEN vtiger_salesorder.company ELSE CONCAT(if(vtiger_salesorder.title=\".\" or vtiger_salesorder.title=\"-\",\"\",CONCAT(vtiger_salesorder.title,\" \")),if(vtiger_salesorder.firstname=\".\" or vtiger_salesorder.firstname=\"-\" or vtiger_salesorder.firstname=\" \",\"\",CONCAT(vtiger_salesorder.firstname,\" \")),if(vtiger_salesorder.surname=\".\" or vtiger_salesorder.surname=\"-\",\"\",vtiger_salesorder.surname)) END)As companyName,\r\n\r\n(SELECT IF(vtiger_inventoryproductrel.widthmeasuretype='inch',Round((vtiger_inventoryproductrel.drope*25.4),0),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='cm',(vtiger_inventoryproductrel.drope*10),vtiger_inventoryproductrel.drope))) As SDrope,\r\n(SELECT IF(vtiger_inventoryproductrel.widthmeasuretype='inch',Round((vtiger_inventoryproductrel.width*25.4),0),\r\n\tIF(vtiger_inventoryproductrel.widthmeasuretype='cm',(vtiger_inventoryproductrel.width*10),vtiger_inventoryproductrel.width))) As SWidth,\r\n\r\n(SELECT CASE WHEN \r\n(vtiger_salesorder.gross_override_value=\"0.00\" and vtiger_salesorder.net_override_value=\"0.00\") or \r\n(vtiger_salesorder.gross_override_value='' and vtiger_salesorder.net_override_value='') or\r\n(vtiger_salesorder.gross_override_value='0.00' and vtiger_salesorder.net_override_value='') or\r\n(vtiger_salesorder.gross_override_value='' and vtiger_salesorder.net_override_value='0.00') THEN \r\nif((vtiger_inventoryproductrel.overrideprice>0 or vtiger_inventoryproductrel.overrideprice=\"0.00\"),Round(vtiger_inventoryproductrel.overrideprice/vtiger_inventoryproductrel.quantity,2),Round(vtiger_inventoryproductrel.listprice/vtiger_inventoryproductrel.quantity,2) ) ELSE '' END) As Unitprice,\r\n\r\n(SELECT CASE WHEN \r\n(vtiger_salesorder.gross_override_value=\"0.00\" and vtiger_salesorder.net_override_value=\"0.00\") or \r\n(vtiger_salesorder.gross_override_value='' and vtiger_salesorder.net_override_value='') or\r\n(vtiger_salesorder.gross_override_value='0.00' and vtiger_salesorder.net_override_value='') or\r\n(vtiger_salesorder.gross_override_value='' and vtiger_salesorder.net_override_value='0.00') THEN \r\nif((vtiger_inventoryproductrel.overrideprice>0 or vtiger_inventoryproductrel.overrideprice=\"0.00\"),vtiger_inventoryproductrel.overrideprice,vtiger_inventoryproductrel.listprice) ELSE '' END) As Tprice,\r\n\r\n(SELECT\r\n\tsoftMax_SalesOrder.value\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterName='Further Instructions' or softMax_ProductsParameter.parameterName = 'Further Instruction' or softMax_ProductsParameter.parameterName = 'Notes' or softMax_ProductsParameter.parameterName = 'Special Instructions') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1) As FurtherInstructions,\r\n\r\n(SELECT\r\n\tsoftMax_SalesOrder.value\r\n\tFROM\r\n\tsoftMax_SalesOrder\r\n\tInner Join softMax_ProductsParameter ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND `vtiger_salesorder`.`salesorderid` = `vtiger_inventoryproductrel`.`id`\r\nAND vtiger_products.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid \r\nAND vtiger_salesorder.salesorderid = softMax_SalesOrder.salesorderid\r\nAND (softMax_ProductsParameter.parameterName='Location' or softMax_ProductsParameter.parameterName='Room' or softMax_ProductsParameter.parameterName='Blind Location') and softMax_SalesOrder.value <> 'na' and softMax_SalesOrder.value <> 'NA' and softMax_SalesOrder.value <> 'n/a' and softMax_SalesOrder.value <> 'N/A' Limit 0,1) As Locations,\r\n\r\n(SELECT CASE WHEN \r\n(SELECT\r\n\tsoftMax_CustomerDiscount.discount\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN vtiger_account ON vtiger_salesorder.custno = vtiger_account.accountid\r\nINNER JOIN softMax_CustomerDiscount ON softMax_CustomerDiscount.accountid = vtiger_account.accountid\r\nINNER JOIN vtiger_products ON vtiger_products.productid=softMax_CustomerDiscount.product\r\nwhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid \r\nAND softMax_CustomerDiscount.materialGroup='0') Limit 0,1)>0 \r\nTHEN \r\n(SELECT\r\n\tsoftMax_CustomerDiscount.discount\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN vtiger_account ON vtiger_salesorder.custno = vtiger_account.accountid\r\nINNER JOIN softMax_CustomerDiscount ON softMax_CustomerDiscount.accountid = vtiger_account.accountid\r\nINNER JOIN vtiger_products ON vtiger_products.productid=softMax_CustomerDiscount.product\r\nwhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid \r\nAND softMax_CustomerDiscount.materialGroup='0') Limit 0,1)\r\nELSE \r\n(SELECT\r\n\tsoftMax_CustomerDiscount.discount\r\n\tFROM softMax_ProductsParameter\r\n\tRIGHT Join softMax_SalesOrder ON softMax_SalesOrder.parameterId = softMax_ProductsParameter.parameterId\r\ninner join vtiger_salesorder ON softMax_SalesOrder.salesorderid = vtiger_salesorder.salesorderid\r\nINNER JOIN vtiger_account ON vtiger_salesorder.custno = vtiger_account.accountid\r\nINNER JOIN softMax_CustomerDiscount ON softMax_CustomerDiscount.accountid = vtiger_account.accountid\r\nINNER JOIN vtiger_products ON vtiger_products.productid=softMax_CustomerDiscount.product\r\nRIGHT Join softMax_ParameterType ON softMax_SalesOrder.parameterId = softMax_ParameterType.parameterId AND softMax_SalesOrder.value = softMax_ParameterType.parameterTypeId\r\nwhere softMax_SalesOrder.salesorderid = vtiger_inventoryproductrel.id\r\nAND softMax_ProductsParameter.productid = vtiger_inventoryproductrel.productid\r\nAND softMax_SalesOrder.inventoryproductrelSequenceNo = vtiger_inventoryproductrel.sequence_no\r\nAND softMax_SalesOrder.value=softMax_CustomerDiscount.materialGroup\r\nAND softMax_ProductsParameter.parameterName = 'Product Type' and softMax_ParameterType.status = '0' and softMax_SalesOrder.status = '0' Limit 0,1)\r\nEND) As CustDiscount,\r\n\r\n(SELECT\r\nsoftMax_CustomerComponent_Discount.discount\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN vtiger_account ON vtiger_salesorder.custno = vtiger_account.accountid\r\nINNER JOIN softMax_CustomerComponent_Discount ON softMax_CustomerComponent_Discount.accountid = vtiger_account.accountid\r\nINNER JOIN vtiger_products ON vtiger_products.productid=softMax_CustomerComponent_Discount.product\r\nwhere (vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id \r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) Limit 0,1) as CustDiscountcomp,\r\n\r\n(SELECT \r\n\tSum(softMax_FixedpriceSalesorder.fixedprice)\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\ninner join softMax_Component on softMax_Component.priceid = softMax_FixedpriceSalesorder.fixedpriceid and softMax_Component.parameterid = softMax_FixedpriceSalesorder.parameterid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id and softMax_Component.productid = vtiger_inventoryproductrel.productid and softMax_Component.status = 0 and softMax_ProductsParameter.parameterName <> 'Product'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As Extrasprice,\r\n\r\n(SELECT \r\n\tSum(softMax_Component.domesticmarkup)\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\ninner join softMax_Component on softMax_Component.priceid = softMax_FixedpriceSalesorder.fixedpriceid and softMax_Component.parameterid = softMax_FixedpriceSalesorder.parameterid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id and softMax_Component.productid = vtiger_inventoryproductrel.productid and softMax_Component.status = 0 and softMax_ProductsParameter.parameterName='Component'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As domesticmarkupExtrasprice,\r\n\r\n(SELECT\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nsoftMax_SubFixedpriceSalesorder.componentname\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nFROM\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id and softMax_SubComponent.parameterid = softMax_SubFixedpriceSalesorder.parameterid\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_products.product_no='3301' and vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Cut Charge\")\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.productid = vtiger_products.productid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_Component.productid = vtiger_products.productid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As CutChargeSubComp,\t\r\n\r\n\r\n(SELECT\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nsoftMax_SubFixedpriceSalesorder.reportsubfixedprice\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nFROM\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nsoftMax_SubFixedpriceSalesorder\r\ninner join vtiger_salesorder on softMax_SubFixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\ninner join softMax_SubComponent on softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id and softMax_SubComponent.parameterid = softMax_SubFixedpriceSalesorder.parameterid\r\ninner join softMax_Component on softMax_Component.priceid = softMax_SubComponent.component_id\r\nwhere vtiger_products.product_no='3301' and vtiger_salesorder.salesorderid = softMax_SubFixedpriceSalesorder.salesorderid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand vtiger_inventoryproductrel.sequence_no = softMax_SubFixedpriceSalesorder.sequenceno\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.priceid = softMax_SubFixedpriceSalesorder.component_id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.status = 0 and (softMax_SubComponent.componentname = \"Cut Charge\")\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubComponent.productid = vtiger_products.productid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_Component.productid = vtiger_products.productid\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\nand softMax_SubFixedpriceSalesorder.fixedorpercentage = 1 limit 0,1) As CutChargeSubCompprice,\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\r\n(SELECT \r\n\tGROUP_CONCAT(concat(Round(softMax_FixedpriceSalesorder.qty,0), \" \", softMax_FixedpriceSalesorder.componentname) SEPARATOR ', ')\r\nFROM \r\nvtiger_salesorder\r\nINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\ninner join softMax_Component on softMax_Component.priceid = softMax_FixedpriceSalesorder.fixedpriceid and softMax_Component.parameterid = softMax_FixedpriceSalesorder.parameterid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id and softMax_Component.productid = vtiger_inventoryproductrel.productid and softMax_Component.status = 0 and softMax_ProductsParameter.parameterName = 'Product'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As ProductExtras,\r\n\r\n(SELECT \r\n\tsoftMax_FixedpriceSalesorder.qty\r\n\tFROM \r\n\tvtiger_salesorder\r\n\tINNER JOIN softMax_FixedpriceSalesorder ON softMax_FixedpriceSalesorder.salesorderid = vtiger_salesorder.salesorderid\r\nRIGHT Join softMax_ProductsParameter ON softMax_FixedpriceSalesorder.parameterId = softMax_ProductsParameter.parameterId\r\ninner join softMax_Component on softMax_Component.priceid = softMax_FixedpriceSalesorder.fixedpriceid and softMax_Component.parameterid = softMax_FixedpriceSalesorder.parameterid\r\nWHERE (vtiger_inventoryproductrel.sequence_no = softMax_FixedpriceSalesorder.sequenceno\r\nAND vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id and softMax_Component.productid = vtiger_inventoryproductrel.productid and softMax_Component.status = 0 and softMax_ProductsParameter.parameterName = 'Product'\r\nAND vtiger_inventoryproductrel.productid = vtiger_products.productid) GROUP by softMax_FixedpriceSalesorder.salesorderid Limit 0,1) As ProductExtrasQTY,\r\n\r\n\r\n(SELECT CASE WHEN (vtiger_salesorder.firstname=\".\" or vtiger_salesorder.firstname=\"-\" or vtiger_salesorder.firstname=\"\") THEN \"\" ELSE vtiger_salesorder.firstname END) As firstname,\r\n(SELECT CASE WHEN (vtiger_salesorder.surname=\".\" or vtiger_salesorder.surname=\"-\" or vtiger_salesorder.surname=\"\") THEN \"\" ELSE vtiger_salesorder.surname END) As surname,\r\n\r\n(SELECT CASE WHEN (vtiger_salesorder.title=\".\" or vtiger_salesorder.title=\"-\") THEN \"\" ELSE CONCAT (vtiger_salesorder.title, \" \") END) As Mrs,\r\n(SELECT CASE WHEN vtiger_salesorder.invoiceno>0 THEN vtiger_salesorder.invoiceno ELSE vtiger_salesorder.salesorder_no END) As Inno,\r\n(SELECT CASE WHEN vtiger_salesorder.invoicedate<>'' THEN vtiger_salesorder.invoicedate ELSE vtiger_salesorder.orderdate END) As In_Date,\r\n(SELECT CASE WHEN vtiger_salesorder.net_override_value>0 THEN vtiger_salesorder.net_override_value WHEN vtiger_salesorder.gross_override_value>0 THEN vtiger_salesorder.gross_override_value-vtiger_salesorder.tax_final ELSE vtiger_salesorder.listprice END) As Subtotalb,\r\n(SELECT CASE WHEN vtiger_salesorder.net_override_value>0 THEN vtiger_salesorder.net_override_value+vtiger_salesorder.tax_final WHEN vtiger_salesorder.gross_override_value>0 THEN vtiger_salesorder.gross_override_value-vtiger_salesorder.tax_final ELSE vtiger_salesorder.listprice+vtiger_salesorder.tax_final END) As Totab,\r\n(SELECT CASE WHEN vtiger_salesorder.custtype<>'Domestic' THEN \"30 Days\" ELSE \"Balance on Completion\" END)As Terms\r\n\r\nFROM\r\nvtiger_salesorder\r\nINNER JOIN vtiger_inventoryproductrel ON vtiger_salesorder.salesorderid = vtiger_inventoryproductrel.id\r\nLEFT OUTER JOIN vtiger_account ON vtiger_salesorder.custno = vtiger_account.accountid\r\nLEFT OUTER JOIN softMax_AlternateDeliveryAddress ON vtiger_salesorder.deliveryaddressid = softMax_AlternateDeliveryAddress.alternateAddressSeq\r\nLEFT OUTER JOIN vtiger_products ON vtiger_inventoryproductrel.productid = vtiger_products.productid,\r\nvtiger_organizationdetails\r\nINNER JOIN vtiger_currency_info ON vtiger_organizationdetails.countryid = vtiger_currency_info.currency_id\r\nWHERE (vtiger_products.productid>0 AND (FIND_IN_SET(vtiger_salesorder.salesorder_no, '{Orderno}') or FIND_IN_SET(vtiger_salesorder.salesorderid, '{Orderno}')) AND vtiger_inventoryproductrel.onhold = '0' AND vtiger_inventoryproductrel.status = '0' and vtiger_inventoryproductrel.quantity>0)\r\nORDER BY Locations" }, "1": { "Ident": "StiMySqlSource", "Name": "DataSource2", "Alias": "DataSource2", "Key": "7c4f98b0b6764e47b7ea7c2015003f98", "Columns": { "0": { "Name": "salesorder_no", "Index": -1, "NameInSource": "salesorder_no", "Alias": "salesorder_no", "Type": "System.String" } }, "NameInSource": "My", "SqlCommand": "Select\r\n\tvtiger_salesorder.salesorder_no\r\n\r\n\tfrom\r\n\tvtiger_salesorder\r\n\r\n\twhere FIND_IN_SET(vtiger_salesorder.salesorder_no, '{Orderno}')" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "My", "Alias": "My", "ConnectionStringEncrypted": "41Zpa2Jco/HLRynM5Vw0Y4twdcJhWlqEYlqhzGh0YWflbMsJSwjL6flJ1ZhqXGUXjWppK01ZQ4HiW9WY6SWgXot0" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page3", "Guid": "751811c7dcbffb6f84aaebfbb70c1aa9", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiPageFooterBand", "Name": "PageFooterBand1", "ClientRectangle": "0,27.49,19.01,0.8", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text53", "Guid": "4fb6d20f8b1f4f0bb85543ba2aa3fd72", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "8,0.11,3.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{PageNumber} / {TotalPageCount}" }, "HorAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" } } }, "1": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand1", "ClientRectangle": "0,0.4,19.01,8.7", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text90", "Guid": "aa75ce55e5d34b698ec7b198a4ce72ac", "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0.14,5.9,8.6,2.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Mrs + DataSource1.firstname + \" \" + DataSource1.surname}{IIF(DataSource1.company+ \" \" == \" \",\" \",\"\r\n\"+DataSource1.company)}{IIF(DataSource1.address+ \" \" == \" \",\" \",\"\r\n\"+DataSource1.address)}{IIF(DataSource1.address1+ \" \" == \" \",\" \",\"\r\n\"+DataSource1.address1)}{IIF(DataSource1.city+ \" \" == \" \",\" \",\"\r\n\"+DataSource1.city)}{IIF(DataSource1.county+ \" \" == \" \",\"\",\"\r\n\"+DataSource1.county)}{IIF(DataSource1.postcode+ \" \" == \" \",\" \",\", \"+DataSource1.postcode)}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text91", "Guid": "47da870a1ed841bca54ea7ee141ccb2b", "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10.14,5.9,8.6,2.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.DelAddress + DataSource1.DelAddress1 + DataSource1.DelAddress2 + \r\nDataSource1.DelCity + DataSource1.DelCounty + DataSource1.Delpostcode + DataSource1.Delphone + DataSource1.Delcompany + DataSource1.Delmobile== \"\", \r\nDataSource1.Mrs + DataSource1.firstname + \" \" + DataSource1.surname + IIF(DataSource1.company+ \" \" == \" \",\" \",\"\r\n\"+DataSource1.company) +\r\nIIF( DataSource1.address + \" \" == \" \",\" \", \"\r\n\"+DataSource1.address)+\r\nIIF( DataSource1.address1 + \" \" == \" \",\" \", \"\r\n\"+DataSource1.address1 ) + \r\nIIF(DataSource1.city + \" \" == \" \",\" \", \"\r\n\" + DataSource1.city ) +\r\nIIF( DataSource1.county + \" \" == \" \",\"\", \"\r\n\" + DataSource1.county ) +\r\nIIF( DataSource1.postcode + \" \" == \" \",\" \", \", \" + DataSource1.postcode ) ,\r\nIIF(DataSource1.DelAddress + \" \" == \" \",\" \", DataSource1.DelAddress ) +\r\nIIF(DataSource1.Delcompany + \" \" == \" \",\" \", \"\r\n\" + DataSource1.Delcompany ) +\r\nIIF(DataSource1.DelAddress1 + \" \" == \" \",IIF(DataSource1.DelAddress2 + \" \" == \" \",\" \", \"\r\n\" + DataSource1.DelAddress2 ),\"\r\n\" + DataSource1.DelAddress1 + IIF(DataSource1.DelAddress2 + \" \" == \" \",\" \", \" \" + DataSource1.DelAddress2 ) )+\r\nIIF(DataSource1.DelCity + \" \" == \" \",IIF(DataSource1.DelCounty + \" \" == \" \",\" \", \"\r\n\" + DataSource1.DelCounty),\"\r\n\" + DataSource1.DelCity + IIF(DataSource1.DelCounty + \" \" == \" \",\" \", \" \" + DataSource1.DelCounty) )+\r\nIIF(DataSource1.Delpostcode + \" \" == \" \",\" \", \"\r\n\" + DataSource1.Delpostcode) +\r\nIIF(DataSource1.Delphone + \" \" == \" \",IIF(DataSource1.Delmobile + \" \" == \" \",\" \", \"\r\nMob: \" + DataSource1.Delmobile),\"\r\n\" + DataSource1.Delphone + IIF(DataSource1.Delmobile + \" \" == \" \",\" \", \" Mob: \" + DataSource1.Delmobile) ))}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text97", "Guid": "7912903eff0f4ee38ce0df72019d3431", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,3,1.4,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Tel:" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text98", "Guid": "9e747cdd180d41629da44ac3251fe6a7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,3.5,1.4,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Email:" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text100", "Guid": "0c5a5f41330144b793b36061e7eaa899", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,4.5,1.4,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.label4}:" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text101", "Guid": "8a87ae1aaa5d408da9bf07781571251b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,3,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Cphone}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text102", "Guid": "3ef5bfee286644f3804adcde8f3045d7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,3.5,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "orders@aftblinds.ie" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text103", "Guid": "693eb25496d14b5796e335da7734d9f4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,4.5,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.vatnumber}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text104", "Guid": "7f396e4b2ed343378e315d12e11e87f3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,4,5,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Cwebsite}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "9": { "Ident": "StiText", "Name": "Text105", "Guid": "e2bfb1b2ac7d422485a22bd918a9918d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.8,6,1.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.Cname+ \" \" == \" \",\" \",DataSource1.Cname)}\r\n{IIF(DataSource1.CAddres+ \" \" == \" \",\" \",DataSource1.CAddres)}{IIF(DataSource1.CAddres1+ \" \" == \" \",\" \",\"\r\n\" + DataSource1.CAddres1)}{IIF(DataSource1.Ccity+ \" \" == \" \",\" \",+ \", \" +DataSource1.Ccity)}{IIF(DataSource1.CPostCode+ \" \" == \" \",\" \",+ \", \" +DataSource1.CPostCode)}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text106", "Guid": "5ad2472f8bb14e6d9c4952ffd1a9e96b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10,8.4,9,0.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Text58" }, "Font": ";10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:255,255,255", "TextBrush": "solid:255,255,255", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text1", "Guid": "561e73986cec443ca441aa6b6b8f817d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,8.4,9,0.2", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Text58" }, "Font": ";10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:255,255,255", "TextBrush": "solid:255,255,255", "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text66", "Guid": "083853399c1a4cb4b7938cb32cc6a420", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "7.6,0,3.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "INVOICE" }, "HorAlignment": "Center", "Font": "Calibri;12;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text2", "Guid": "381df28d25aa471abea369cabb6cc656", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,0,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Invoice No." }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "14": { "Ident": "StiText", "Name": "Text18", "Guid": "057d800b378a470a8d5cc0596da86019", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,0.5,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.Inno}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black" }, "15": { "Ident": "StiText", "Name": "Text19", "Guid": "cb57efa4f70f41efbdc1568a87883727", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,1.5,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.accref}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "DataColumn" }, "16": { "Ident": "StiText", "Name": "Text20", "Guid": "0548f662092442a2a79ba525c58ccca9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,1,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Account No." }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "17": { "Ident": "StiText", "Name": "Text57", "Guid": "7ab55f2a98004d2c9866cd2a8bd78b5c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,3.5,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.In_Date}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "dd-MM-yyyy" }, "Type": "DataColumn" }, "18": { "Ident": "StiText", "Name": "Text17", "Guid": "2be92aa71ce34a8baf42e56595d5789b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,3,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Invoice Date" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "19": { "Ident": "StiText", "Name": "Text52", "Guid": "c9b3fbbb90f54ad88737dc778e48452d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,4,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Cust. Reference" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "20": { "Ident": "StiText", "Name": "Text59", "Guid": "b3ca081dae6541c581863dd24212ee59", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,4.5,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.custref}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "dd-MM-yyyy" }, "Type": "DataColumn" }, "21": { "Ident": "StiText", "Name": "Text99", "Guid": "294ec3f1ac604ce2a46e99c6c9bb4b42", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,4,1.4,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Website:" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "22": { "Ident": "StiText", "Name": "Text4", "Guid": "136072b847ad93316c7991b18d7dfa7b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,2,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Order No." }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "23": { "Ident": "StiText", "Name": "Text8", "Guid": "56332e3f5dcf477bab68ce5b91c5a23c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,2.5,5.8,0.5", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.salesorder_no}" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "dd-MM-yyyy" }, "Type": "Expression" }, "24": { "Ident": "StiText", "Name": "Text14", "Guid": "f50241d3404add650119aecf1bd434d3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,5.2,9,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Invoice To" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "25": { "Ident": "StiText", "Name": "Text23", "Guid": "1249c0deb55a09b0926b835a0f1f4ffb", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10,5.2,9,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Deliver To" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "26": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive19", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,5.2,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "7a82040363724169b5257081fc2c7eff" }, "27": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive19", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9,8.4,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "7a82040363724169b5257081fc2c7eff" }, "28": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive21", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10,5.2,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "194126f4be384d0a8cbfbb31e7a2b258" }, "29": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive21", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "19,8.4,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "194126f4be384d0a8cbfbb31e7a2b258" }, "30": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive6", "Guid": "0b0fd8d000a54975839d91400897e961", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,0.5,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "31": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive10", "Guid": "3505695a861e4e6fbfc471c9d3c11277", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,1,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "32": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive11", "Guid": "82d1b677197d4acaad7ec9adc63eaa1b", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,1.5,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "33": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive5", "Guid": "259a33e586f1423fb58eaeee1d710f27", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,2,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "34": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive7", "Guid": "1bdc18adc17842c297a911f19867e7f6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,3.5,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "35": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive3", "Guid": "bd80b011353940ff977827e399952a98", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,4,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "36": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive8", "Guid": "fd47d1c4793c4e8bacea03d138329e54", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,4.5,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "37": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "47426dfc10a243cb98e62747d3212b1f" }, "38": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "19,5,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "47426dfc10a243cb98e62747d3212b1f" }, "39": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive1", "Guid": "d31d0e62f28cffd1ac70ee3c5d6fbe51", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,2.5,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "40": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive9", "Guid": "ed42acbec3e35b313b6874433ff0857d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,3,5.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "41": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive12", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,5.8,9,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "42": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive13", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10,5.8,9,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "CanGrow": false, "NewPageBefore": true, "KeepGroupHeaderTogether": false, "KeepGroupTogether": true, "PrintOnAllPages": true, "Condition": { "Value": "{DataSource1.salesorder_no}" } }, "2": { "Ident": "StiGroupHeaderBand", "Name": "GroupHeaderBand2", "ClientRectangle": "0,9.9,19.01,0.6", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text75", "Guid": "0cf853851423c3cad91d8ffef40a89d7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0,9,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Description" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0" }, "1": { "Ident": "StiText", "Name": "Text78", "Guid": "c8a1827dcc703557a9ad54d09cbf6868", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0,2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Net Price" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text10", "Guid": "99543d991d76c0c108d887ed4874b150", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0,1.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Disc. %" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text21", "Guid": "1b7bd1b8d348fdc10202fc977e8033a5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.38,0,1.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Unit Price" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text34", "Guid": "c94c3d437d908d5194a6590519e6b7f9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.39,0,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Product" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text12", "Guid": "742e1a1642b8a4f0967461626fda5c1e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,1.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Qty" }, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "6": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "56d4c4e35a50d479451372fde3400184" }, "7": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "4cb177007a611388539395af9378e7ee" }, "8": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "f5a806a3e50df00c698072fdf772bdc1" }, "9": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive36", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "bd02f1d264dfbd9df22dec06b097361e" }, "10": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive16", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "97c99cee410a5b9d2780312e49fafa81" }, "11": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "56d4c4e35a50d479451372fde3400184" }, "12": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive3", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "4cb177007a611388539395af9378e7ee" }, "13": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "f5a806a3e50df00c698072fdf772bdc1" }, "14": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive16", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "97c99cee410a5b9d2780312e49fafa81" }, "15": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive36", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "19,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "bd02f1d264dfbd9df22dec06b097361e" }, "16": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "bbc5b7b5a0d2437789deeefaeb08269e" }, "17": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive10", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "b393325dd9ed6eb3e4b0bc1bccbbee7f" }, "18": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "b393325dd9ed6eb3e4b0bc1bccbbee7f" } }, "PrintOnAllPages": true, "Condition": { "Value": "{DataSource1.salesorder_no}" } }, "3": { "Ident": "StiDataBand", "Name": "DataBand3", "ClientRectangle": "0,11.3,19.01,1", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1.product_no == \"437\"}" }, "Enabled": false, "Font": ";10;;", "BorderSides": "None" } }, "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text81", "Guid": "b4de3a8f2884c12e4e2de1b1ee70728b", "CanShrink": true, "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.5,0.1,8.9,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{Trim(Replace(Replace(DataSource1.aaa, \"####,\", \"\"), \"##\", \"\"))}" }, "Font": "Calibri;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text82", "Guid": "fa9a044ba17e25c3125aafc0ad690cad", "CanShrink": true, "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0.1,2,0.6", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{IIF(System.Convert.ToDouble(DataSource1.Tprice)>0,System.Convert.ToDouble(DataSource1.Tprice) - (System.Convert.ToDouble(DataSource1.Tprice)*DataSource1.discount_percentage_value) / 100,DataSource1.Tprice)}" }, "HorAlignment": "Center", "Font": "Calibri;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": ",", "UseLocalSetting": false }, "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text62", "Guid": "689876cf005a70ed00b5e8289e503173", "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0.1,1.8,0.6", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1.CustDiscountcomp ==\"\"}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{IIF(DataSource1.overrideprice!=\"\",\"\",IIF(DataSource1.ComponentExtras==\"32mm Slipstream Tubing - 5m Length\",DataSource1.CustDiscountcomp))}" }, "HorAlignment": "Center", "Font": "Calibri;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": ",", "UseLocalSetting": false }, "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text13", "Guid": "92cc819b28c0189f08048bafeb80c66a", "CanGrow": true, "GrowToHeight": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,0.1,3,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.productname}" }, "Font": "Calibri;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:0,255,255,255", "TextBrush": "solid:0,0,0", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text15", "Guid": "a47be519e1efee28a4d4b3929d3f012f", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.1,1.4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.quantity}" }, "HorAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:0,0,0", "Brush": "solid:", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text77", "Guid": "c1adfcefce224529badae4ea8b417f15", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0.1,1.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "HideZeros": true, "Text": { "Value": "{DataSource1.Unitpriceformula}" }, "HorAlignment": "Center", "Font": "Calibri;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text40", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0.8,9,0.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text41", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0.8,1.8,0.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text42", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0.8,1.8,0.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text43", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0.8,2,0.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text44", "Guid": "fb54eef3f2e3b7fddddc0747a914169f", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0.1,1.8,0.8", "Conditions": { "0": { "Ident": "StiCondition", "Item": "Expression", "Expression": { "Value": "{DataSource1.CustDiscount==\"\"}" }, "Enabled": false, "BorderSides": "None" } }, "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.overridetypeid==\"3\",DataSource1.itemoverride,IIF(DataSource1.overrideprice!=\"\",\"\",DataSource1.CustDiscount))}" }, "HorAlignment": "Center", "Font": "Calibri;9;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiNumberFormatService", "NegativePattern": 1, "GroupSeparator": "," }, "Type": "Expression" }, "11": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "e540c3f0449e01587cc3ba20da478bef" }, "12": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive12", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "4d0ef271361ac85bc279ba20f1037e53" }, "13": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive15", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "5252698b3349c600f25b3929ef19b7a0" }, "14": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "ba41d9ab8c8c04d58bf9a1ada7cdebdf" }, "15": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive11", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "9136a37a365ddc504ce7a5e587d78fb7" } }, "DataSourceName": "DataSource1" }, "4": { "Ident": "StiGroupFooterBand", "Name": "GroupFooterBand1", "ClientRectangle": "0,13.1,19.01,3.2", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:", "Components": { "0": { "Ident": "StiText", "Name": "Text25", "Guid": "68013e66bf534b9f8a83a0307bc804c2", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,1,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.currency_symbol} {Format(\"{0:#,##0.00}\", DataSource1.netprice)}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "1": { "Ident": "StiText", "Name": "Text26", "Guid": "80e77e103f5b44ae8b3df1c8f830d9b9", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,1.6,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.currency_symbol} {Format(\"{0:#,##0.00}\", DataSource1.tax_final)}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "2": { "Ident": "StiText", "Name": "Text16", "Guid": "13b24b862aab4fe28f68e73f691f5268", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,2,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.currency_symbol} {Format(\"{0:#,##0.00}\", DataSource1.totalpaid)}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "3": { "Ident": "StiText", "Name": "Text28", "Guid": "b4addfc6bd1b4c6e96c0901b3f81369a", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,1,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Subtotal:" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "4": { "Ident": "StiText", "Name": "Text27", "Guid": "65b021dc222f4580916e75b24f4045c6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,1.6,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.label3}:" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "5": { "Ident": "StiText", "Name": "Text3", "Guid": "f864b96c539040d280f58407e21a2991", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,2,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Payments:" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "6": { "Ident": "StiText", "Name": "Text54", "Guid": "bdc74823c3a94007b782b96ee81dc0aa", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,0.6,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.discount_amount_value>0,DataSource1.currency_symbol + Format(\"{0:#,##0.00}\", DataSource1.discount_amount_value),\"\")}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "7": { "Ident": "StiText", "Name": "Text55", "Guid": "62bcc13f6d224b9ab1706cc5dacc5f62", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,0.6,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.discount_amount_value>0,\"Discount:\",\"\")}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "8": { "Ident": "StiText", "Name": "Text24", "Guid": "04e42e406d344daaa2c03050e0e70f67", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,0.2,2.2,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.s_h_amount>0,DataSource1.currency_symbol + Format(\"{0:#,##0.00}\", DataSource1.s_h_amount),\"\")}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "9": { "Ident": "StiText", "Name": "Text6", "Guid": "5853ac1a130e42c3b3bc9e238e34e92d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,0.2,2.6,0.4", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{IIF(DataSource1.s_h_amount>0,\"Delivery\",\"\")}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "10": { "Ident": "StiText", "Name": "Text11", "Guid": "5fb8bf7d629b4c39ac03136380f5b94a", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "16.8,2.4,2.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.currency_symbol} {Format(\"{0:#,##0.00}\", DataSource1.amountoutstanding)}" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "11": { "Ident": "StiText", "Name": "Text7", "Guid": "3e32a8952ad04761909ba3416ef63c93", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "14,2.4,2.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Total:" }, "CanBreak": true, "HorAlignment": "Right", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "12": { "Ident": "StiText", "Name": "Text9", "Guid": "84d4d44f06c14bc8a4ca89c4f726daac", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.6,13.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " Payment To:" }, "CanBreak": true, "HorAlignment": "Center", "VertAlignment": "Center", "Font": "Calibri;10;Bold;", "Border": ";;;;;;;solid:Black", "Brush": "solid:216,216,216", "TextBrush": "solid:0,0,0", "Type": "Expression" }, "13": { "Ident": "StiText", "Name": "Text5", "Guid": "ff4ec9e9f21c356a3be260edd4c8a4f6", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.8,0.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Bank:" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "14": { "Ident": "StiText", "Name": "Text22", "Guid": "6662c699b7bb14450dcd321cccce7de3", "CanGrow": true, "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.2,3,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Distribution Ltd" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "Expression" }, "15": { "Ident": "StiText", "Name": "Text29", "Guid": "0502362c77c92be305817f091cb57a6e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,2.4,0.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "A/C:" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "16": { "Ident": "StiText", "Name": "Text30", "Guid": "a43509cb410fa9909028764204d34aee", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0.8,1.8,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.bankname}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "17": { "Ident": "StiText", "Name": "Text31", "Guid": "dc01d57133ee714bf314307757553001", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0.8,2.4,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.accountnumber}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "TextFormat": { "Ident": "StiCustomFormatService", "StringFormat": "dd/MM/yyyy" }, "Type": "Expression" }, "18": { "Ident": "StiText", "Name": "Text32", "Guid": "615d7183cfd5b5dc368e7fd33419370e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9,1.2,0.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "Sort:" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "19": { "Ident": "StiText", "Name": "Text33", "Guid": "5d9fb7720def45420099985b6db29bef", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.8,1.2,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{DataSource1.sortcode}" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "20": { "Ident": "StiText", "Name": "Text35", "Guid": "604ed11b3c6b30714da6ed9bd7eba5c8", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9,1.8,1.6,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "BIC (swift):" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "21": { "Ident": "StiText", "Name": "Text36", "Guid": "fb4e289b9a48dd76c568cc78699c576c", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10.6,1.8,3.2,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": " IPBSIE2D" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "22": { "Ident": "StiText", "Name": "Text37", "Guid": "6e836081487958181de4ab29f5047d96", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9,2.4,0.8,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "IBAN:" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "23": { "Ident": "StiText", "Name": "Text38", "Guid": "2fd4a4451156bf89940715f58af9df0a", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "9.8,2.4,4,0.6", "Interaction": { "Ident": "StiInteraction" }, "CanBreak": true, "VertAlignment": "Center", "Font": "Calibri;10;;", "Border": ";;;;;;;solid:Black", "Brush": "solid:", "TextBrush": "solid:Black", "Type": "Expression" }, "24": { "Ident": "StiStartPointPrimitive", "Name": "StartPointPrimitive1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,0.6,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "d18bc9539b144cd5800d12d667cb857d" }, "25": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.8,3,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "d18bc9539b144cd5800d12d667cb857d" }, "26": { "Ident": "StiHorizontalLinePrimitive", "Name": "HorizontalLinePrimitive14", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,1.2,13.8,0.0254", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "27": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive5", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "19,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "bbc5b7b5a0d2437789deeefaeb08269e" }, "28": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive4", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "ba41d9ab8c8c04d58bf9a1ada7cdebdf" }, "29": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive12", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "4d0ef271361ac85bc279ba20f1037e53" }, "30": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive15", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "5252698b3349c600f25b3929ef19b7a0" }, "31": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive11", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "e540c3f0449e01587cc3ba20da478bef" }, "32": { "Ident": "StiEndPointPrimitive", "Name": "EndPointPrimitive10", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,0,0,0", "Interaction": { "Ident": "StiInteraction" }, "ReferenceToGuid": "9136a37a365ddc504ce7a5e587d78fb7" } }, "PrintAtBottom": true }, "5": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive10", "Guid": "bd02f1d264dfbd9df22dec06b097361e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,9.9,19,0.6", "Interaction": { "Ident": "StiInteraction" } }, "6": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive5", "Guid": "56d4c4e35a50d479451372fde3400184", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,9.9,0.0254,0.6", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "7": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive6", "Guid": "f5a806a3e50df00c698072fdf772bdc1", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,9.9,0.0254,0.6", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "8": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive8", "Guid": "e540c3f0449e01587cc3ba20da478bef", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,11.3,0.0254,1.8", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "9": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive9", "Guid": "4d0ef271361ac85bc279ba20f1037e53", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,11.3,0.0254,1.8", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "10": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive1", "Guid": "4cb177007a611388539395af9378e7ee", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "15.2,9.9,0.0254,0.6", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "11": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive10", "Guid": "5252698b3349c600f25b3929ef19b7a0", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "17,11.3,0.0254,1.8", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "12": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive11", "Guid": "97c99cee410a5b9d2780312e49fafa81", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,9.9,0.0254,0.6", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "13": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive2", "Guid": "ba41d9ab8c8c04d58bf9a1ada7cdebdf", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.4,11.3,0.0254,1.8", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "14": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive8", "Guid": "7a82040363724169b5257081fc2c7eff", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,5.6,9,3.2", "Interaction": { "Ident": "StiInteraction" } }, "15": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive9", "Guid": "194126f4be384d0a8cbfbb31e7a2b258", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "10,5.6,9,3.2", "Interaction": { "Ident": "StiInteraction" } }, "16": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive2", "Guid": "d18bc9539b144cd5800d12d667cb857d", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,13.7,13.8,2.4", "Interaction": { "Ident": "StiInteraction" } }, "17": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive1", "Guid": "bbc5b7b5a0d2437789deeefaeb08269e", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "0,10.5,19,2.6", "Interaction": { "Ident": "StiInteraction" } }, "18": { "Ident": "StiRectanglePrimitive", "Name": "RectanglePrimitive3", "Guid": "47426dfc10a243cb98e62747d3212b1f", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "13.2,0.4,5.8,5", "Interaction": { "Ident": "StiInteraction" } }, "19": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive3", "Guid": "b393325dd9ed6eb3e4b0bc1bccbbee7f", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "4.4,9.9,0.0254,0.6", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" }, "20": { "Ident": "StiVerticalLinePrimitive", "Name": "VerticalLinePrimitive4", "Guid": "9136a37a365ddc504ce7a5e587d78fb7", "MinSize": "0,0", "MaxSize": "0,0", "ClientRectangle": "1.4,11.3,0.0254,1.8", "Interaction": { "Ident": "StiInteraction" }, "StartCap": ";;;", "EndCap": ";;;" } }, "PaperSize": "A4", "PageWidth": 21.01, "PageHeight": 29.69, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1.0, "Right": 1.0, "Top": 0.6, "Bottom": 0.8 } } } }