{ "ReportVersion": "2019.1.1", "ReportGuid": "94f9996b7c4c411cb5e3e17771b23933", "ReportName": "Report", "ReportAlias": "Report", "ReportFile": "ListInQuery.mrt", "ReportCreated": "/Date(-7200000+0100)/", "ReportChanged": "/Date(-7200000+0100)/", "EngineVersion": "EngineV2", "CalculationMode": "Interpretation", "ReportUnit": "Centimeters", "RequestParameters": true, "Dictionary": { "Variables": { "0": { "Name": "var1", "DialogInfo": { "DateTimeType": "DateAndTime", "ItemsInitializationType": "Columns", "KeysColumn": "eol_item2.id", "ValuesColumn": "eol_item2.description", "AllowUserValues": false }, "Alias": "var1", "Type": "Stimulsoft.Report.StringList", "RequestFromUser": true }, "1": { "Value": "(var1.Count == 0 ? \"(' ')\" : \"(\" + var1.ToQueryString(\"'\") + \")\")", "Name": "var2", "Alias": "var2", "Type": "System.String", "ReadOnly": true, "InitBy": "Expression" } }, "DataSources": { "0": { "Ident": "StiMySqlSource", "Name": "eol_item", "Alias": "eol_item", "Columns": { "0": { "Name": "barcode", "Index": -1, "NameInSource": "barcode", "Alias": "barcode", "Type": "System.String" }, "1": { "Name": "class_01", "Index": -1, "NameInSource": "class_01", "Alias": "class_01", "Type": "System.String" }, "2": { "Name": "class_02", "Index": -1, "NameInSource": "class_02", "Alias": "class_02", "Type": "System.String" }, "3": { "Name": "class_03", "Index": -1, "NameInSource": "class_03", "Alias": "class_03", "Type": "System.String" }, "4": { "Name": "class_04", "Index": -1, "NameInSource": "class_04", "Alias": "class_04", "Type": "System.String" }, "5": { "Name": "class_05", "Index": -1, "NameInSource": "class_05", "Alias": "class_05", "Type": "System.String" }, "6": { "Name": "class_06", "Index": -1, "NameInSource": "class_06", "Alias": "class_06", "Type": "System.String" }, "7": { "Name": "class_07", "Index": -1, "NameInSource": "class_07", "Alias": "class_07", "Type": "System.String" }, "8": { "Name": "class_08", "Index": -1, "NameInSource": "class_08", "Alias": "class_08", "Type": "System.String" }, "9": { "Name": "class_09", "Index": -1, "NameInSource": "class_09", "Alias": "class_09", "Type": "System.String" }, "10": { "Name": "class_10", "Index": -1, "NameInSource": "class_10", "Alias": "class_10", "Type": "System.String" }, "11": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "12": { "Name": "copy_remarks", "Index": -1, "NameInSource": "copy_remarks", "Alias": "copy_remarks", "Type": "System.Int16" }, "13": { "Name": "cost_price_currency", "Index": -1, "NameInSource": "cost_price_currency", "Alias": "cost_price_currency", "Type": "System.String" }, "14": { "Name": "cost_price_new", "Index": -1, "NameInSource": "cost_price_new", "Alias": "cost_price_new", "Type": "System.Double" }, "15": { "Name": "cost_price_standard", "Index": -1, "NameInSource": "cost_price_standard", "Alias": "cost_price_standard", "Type": "System.Double" }, "16": { "Name": "created", "Index": -1, "NameInSource": "created", "Alias": "created", "Type": "System.DateTime" }, "17": { "Name": "creator", "Index": -1, "NameInSource": "creator", "Alias": "creator", "Type": "System.String" }, "18": { "Name": "creator_full_name", "Index": -1, "NameInSource": "creator_full_name", "Alias": "creator_full_name", "Type": "System.String" }, "19": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "20": { "Name": "division", "Index": -1, "NameInSource": "division", "Alias": "division", "Type": "System.Int16" }, "21": { "Name": "end_date", "Index": -1, "NameInSource": "end_date", "Alias": "end_date", "Type": "System.DateTime" }, "22": { "Name": "extra_description", "Index": -1, "NameInSource": "extra_description", "Alias": "extra_description", "Type": "System.String" }, "23": { "Name": "free_bool_field_01", "Index": -1, "NameInSource": "free_bool_field_01", "Alias": "free_bool_field_01", "Type": "System.Int16" }, "24": { "Name": "free_bool_field_02", "Index": -1, "NameInSource": "free_bool_field_02", "Alias": "free_bool_field_02", "Type": "System.Int16" }, "25": { "Name": "free_bool_field_03", "Index": -1, "NameInSource": "free_bool_field_03", "Alias": "free_bool_field_03", "Type": "System.Int16" }, "26": { "Name": "free_bool_field_04", "Index": -1, "NameInSource": "free_bool_field_04", "Alias": "free_bool_field_04", "Type": "System.Int16" }, "27": { "Name": "free_bool_field_05", "Index": -1, "NameInSource": "free_bool_field_05", "Alias": "free_bool_field_05", "Type": "System.Int16" }, "28": { "Name": "free_date_field_01", "Index": -1, "NameInSource": "free_date_field_01", "Alias": "free_date_field_01", "Type": "System.DateTime" }, "29": { "Name": "free_date_field_02", "Index": -1, "NameInSource": "free_date_field_02", "Alias": "free_date_field_02", "Type": "System.DateTime" }, "30": { "Name": "free_date_field_03", "Index": -1, "NameInSource": "free_date_field_03", "Alias": "free_date_field_03", "Type": "System.DateTime" }, "31": { "Name": "free_date_field_04", "Index": -1, "NameInSource": "free_date_field_04", "Alias": "free_date_field_04", "Type": "System.DateTime" }, "32": { "Name": "free_date_field_05", "Index": -1, "NameInSource": "free_date_field_05", "Alias": "free_date_field_05", "Type": "System.DateTime" }, "33": { "Name": "free_number_field_01", "Index": -1, "NameInSource": "free_number_field_01", "Alias": "free_number_field_01", "Type": "System.Double" }, "34": { "Name": "free_number_field_02", "Index": -1, "NameInSource": "free_number_field_02", "Alias": "free_number_field_02", "Type": "System.Double" }, "35": { "Name": "free_number_field_03", "Index": -1, "NameInSource": "free_number_field_03", "Alias": "free_number_field_03", "Type": "System.Double" }, "36": { "Name": "free_number_field_04", "Index": -1, "NameInSource": "free_number_field_04", "Alias": "free_number_field_04", "Type": "System.Double" }, "37": { "Name": "free_number_field_05", "Index": -1, "NameInSource": "free_number_field_05", "Alias": "free_number_field_05", "Type": "System.Double" }, "38": { "Name": "free_number_field_06", "Index": -1, "NameInSource": "free_number_field_06", "Alias": "free_number_field_06", "Type": "System.Double" }, "39": { "Name": "free_number_field_07", "Index": -1, "NameInSource": "free_number_field_07", "Alias": "free_number_field_07", "Type": "System.Double" }, "40": { "Name": "free_number_field_08", "Index": -1, "NameInSource": "free_number_field_08", "Alias": "free_number_field_08", "Type": "System.Double" }, "41": { "Name": "free_text_field_01", "Index": -1, "NameInSource": "free_text_field_01", "Alias": "free_text_field_01", "Type": "System.String" }, "42": { "Name": "free_text_field_02", "Index": -1, "NameInSource": "free_text_field_02", "Alias": "free_text_field_02", "Type": "System.String" }, "43": { "Name": "free_text_field_03", "Index": -1, "NameInSource": "free_text_field_03", "Alias": "free_text_field_03", "Type": "System.String" }, "44": { "Name": "free_text_field_04", "Index": -1, "NameInSource": "free_text_field_04", "Alias": "free_text_field_04", "Type": "System.String" }, "45": { "Name": "free_text_field_05", "Index": -1, "NameInSource": "free_text_field_05", "Alias": "free_text_field_05", "Type": "System.String" }, "46": { "Name": "free_text_field_06", "Index": -1, "NameInSource": "free_text_field_06", "Alias": "free_text_field_06", "Type": "System.String" }, "47": { "Name": "free_text_field_07", "Index": -1, "NameInSource": "free_text_field_07", "Alias": "free_text_field_07", "Type": "System.String" }, "48": { "Name": "free_text_field_08", "Index": -1, "NameInSource": "free_text_field_08", "Alias": "free_text_field_08", "Type": "System.String" }, "49": { "Name": "free_text_field_09", "Index": -1, "NameInSource": "free_text_field_09", "Alias": "free_text_field_09", "Type": "System.String" }, "50": { "Name": "free_text_field_10", "Index": -1, "NameInSource": "free_text_field_10", "Alias": "free_text_field_10", "Type": "System.String" }, "51": { "Name": "glcosts", "Index": -1, "NameInSource": "glcosts", "Alias": "glcosts", "Type": "System.String" }, "52": { "Name": "glcosts_code", "Index": -1, "NameInSource": "glcosts_code", "Alias": "glcosts_code", "Type": "System.String" }, "53": { "Name": "glcosts_description", "Index": -1, "NameInSource": "glcosts_description", "Alias": "glcosts_description", "Type": "System.String" }, "54": { "Name": "glrevenue", "Index": -1, "NameInSource": "glrevenue", "Alias": "glrevenue", "Type": "System.String" }, "55": { "Name": "glrevenue_code", "Index": -1, "NameInSource": "glrevenue_code", "Alias": "glrevenue_code", "Type": "System.String" }, "56": { "Name": "glrevenue_description", "Index": -1, "NameInSource": "glrevenue_description", "Alias": "glrevenue_description", "Type": "System.String" }, "57": { "Name": "glstock", "Index": -1, "NameInSource": "glstock", "Alias": "glstock", "Type": "System.String" }, "58": { "Name": "glstock_code", "Index": -1, "NameInSource": "glstock_code", "Alias": "glstock_code", "Type": "System.String" }, "59": { "Name": "glstock_description", "Index": -1, "NameInSource": "glstock_description", "Alias": "glstock_description", "Type": "System.String" }, "60": { "Name": "gross_weight", "Index": -1, "NameInSource": "gross_weight", "Alias": "gross_weight", "Type": "System.Double" }, "61": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "62": { "Name": "is_batch_item", "Index": -1, "NameInSource": "is_batch_item", "Alias": "is_batch_item", "Type": "System.Int16" }, "63": { "Name": "is_batch_number_item", "Index": -1, "NameInSource": "is_batch_number_item", "Alias": "is_batch_number_item", "Type": "System.Int16" }, "64": { "Name": "is_fraction_allowed_item", "Index": -1, "NameInSource": "is_fraction_allowed_item", "Alias": "is_fraction_allowed_item", "Type": "System.Int16" }, "65": { "Name": "is_make_item", "Index": -1, "NameInSource": "is_make_item", "Alias": "is_make_item", "Type": "System.Int16" }, "66": { "Name": "is_new_contract", "Index": -1, "NameInSource": "is_new_contract", "Alias": "is_new_contract", "Type": "System.Int16" }, "67": { "Name": "is_on_demand_item", "Index": -1, "NameInSource": "is_on_demand_item", "Alias": "is_on_demand_item", "Type": "System.Int16" }, "68": { "Name": "is_package_item", "Index": -1, "NameInSource": "is_package_item", "Alias": "is_package_item", "Type": "System.Int16" }, "69": { "Name": "is_purchase_item", "Index": -1, "NameInSource": "is_purchase_item", "Alias": "is_purchase_item", "Type": "System.Int16" }, "70": { "Name": "is_registration_code_item", "Index": -1, "NameInSource": "is_registration_code_item", "Alias": "is_registration_code_item", "Type": "System.Int16" }, "71": { "Name": "is_sales_item", "Index": -1, "NameInSource": "is_sales_item", "Alias": "is_sales_item", "Type": "System.Int16" }, "72": { "Name": "is_serial_item", "Index": -1, "NameInSource": "is_serial_item", "Alias": "is_serial_item", "Type": "System.Int16" }, "73": { "Name": "is_serial_number_item", "Index": -1, "NameInSource": "is_serial_number_item", "Alias": "is_serial_number_item", "Type": "System.Int16" }, "74": { "Name": "is_stock_item", "Index": -1, "NameInSource": "is_stock_item", "Alias": "is_stock_item", "Type": "System.Int16" }, "75": { "Name": "is_subcontracted_item", "Index": -1, "NameInSource": "is_subcontracted_item", "Alias": "is_subcontracted_item", "Type": "System.Int16" }, "76": { "Name": "is_taxable_item", "Index": -1, "NameInSource": "is_taxable_item", "Alias": "is_taxable_item", "Type": "System.Int16" }, "77": { "Name": "is_time", "Index": -1, "NameInSource": "is_time", "Alias": "is_time", "Type": "System.Int16" }, "78": { "Name": "is_webshop_item", "Index": -1, "NameInSource": "is_webshop_item", "Alias": "is_webshop_item", "Type": "System.Int16" }, "79": { "Name": "item_group", "Index": -1, "NameInSource": "item_group", "Alias": "item_group", "Type": "System.String" }, "80": { "Name": "item_group_code", "Index": -1, "NameInSource": "item_group_code", "Alias": "item_group_code", "Type": "System.String" }, "81": { "Name": "item_group_description", "Index": -1, "NameInSource": "item_group_description", "Alias": "item_group_description", "Type": "System.String" }, "82": { "Name": "modified", "Index": -1, "NameInSource": "modified", "Alias": "modified", "Type": "System.DateTime" }, "83": { "Name": "modifier", "Index": -1, "NameInSource": "modifier", "Alias": "modifier", "Type": "System.String" }, "84": { "Name": "modifier_full_name", "Index": -1, "NameInSource": "modifier_full_name", "Alias": "modifier_full_name", "Type": "System.String" }, "85": { "Name": "net_weight", "Index": -1, "NameInSource": "net_weight", "Alias": "net_weight", "Type": "System.Double" }, "86": { "Name": "net_weight_unit", "Index": -1, "NameInSource": "net_weight_unit", "Alias": "net_weight_unit", "Type": "System.String" }, "87": { "Name": "notes", "Index": -1, "NameInSource": "notes", "Alias": "notes", "Type": "System.String" }, "88": { "Name": "picture_name", "Index": -1, "NameInSource": "picture_name", "Alias": "picture_name", "Type": "System.String" }, "89": { "Name": "picture_thumbnail_url", "Index": -1, "NameInSource": "picture_thumbnail_url", "Alias": "picture_thumbnail_url", "Type": "System.String" }, "90": { "Name": "picture_url", "Index": -1, "NameInSource": "picture_url", "Alias": "picture_url", "Type": "System.String" }, "91": { "Name": "sales_vat_code", "Index": -1, "NameInSource": "sales_vat_code", "Alias": "sales_vat_code", "Type": "System.String" }, "92": { "Name": "sales_vat_code_description", "Index": -1, "NameInSource": "sales_vat_code_description", "Alias": "sales_vat_code_description", "Type": "System.String" }, "93": { "Name": "search_code", "Index": -1, "NameInSource": "search_code", "Alias": "search_code", "Type": "System.String" }, "94": { "Name": "security_level", "Index": -1, "NameInSource": "security_level", "Alias": "security_level", "Type": "System.Int16" }, "95": { "Name": "start_date", "Index": -1, "NameInSource": "start_date", "Alias": "start_date", "Type": "System.DateTime" }, "96": { "Name": "stock", "Index": -1, "NameInSource": "stock", "Alias": "stock", "Type": "System.Double" }, "97": { "Name": "unit", "Index": -1, "NameInSource": "unit", "Alias": "unit", "Type": "System.String" }, "98": { "Name": "unit_description", "Index": -1, "NameInSource": "unit_description", "Alias": "unit_description", "Type": "System.String" }, "99": { "Name": "unit_type", "Index": -1, "NameInSource": "unit_type", "Alias": "unit_type", "Type": "System.String" } }, "NameInSource": "Suit", "Type": "Table", "SqlCommand": "select * from eol_item where id IN {var2}" }, "1": { "Ident": "StiMySqlSource", "Name": "eol_item2", "Alias": "eol_item2", "Columns": { "0": { "Name": "barcode", "Index": -1, "NameInSource": "barcode", "Alias": "barcode", "Type": "System.String" }, "1": { "Name": "class_01", "Index": -1, "NameInSource": "class_01", "Alias": "class_01", "Type": "System.String" }, "2": { "Name": "class_02", "Index": -1, "NameInSource": "class_02", "Alias": "class_02", "Type": "System.String" }, "3": { "Name": "class_03", "Index": -1, "NameInSource": "class_03", "Alias": "class_03", "Type": "System.String" }, "4": { "Name": "class_04", "Index": -1, "NameInSource": "class_04", "Alias": "class_04", "Type": "System.String" }, "5": { "Name": "class_05", "Index": -1, "NameInSource": "class_05", "Alias": "class_05", "Type": "System.String" }, "6": { "Name": "class_06", "Index": -1, "NameInSource": "class_06", "Alias": "class_06", "Type": "System.String" }, "7": { "Name": "class_07", "Index": -1, "NameInSource": "class_07", "Alias": "class_07", "Type": "System.String" }, "8": { "Name": "class_08", "Index": -1, "NameInSource": "class_08", "Alias": "class_08", "Type": "System.String" }, "9": { "Name": "class_09", "Index": -1, "NameInSource": "class_09", "Alias": "class_09", "Type": "System.String" }, "10": { "Name": "class_10", "Index": -1, "NameInSource": "class_10", "Alias": "class_10", "Type": "System.String" }, "11": { "Name": "code", "Index": -1, "NameInSource": "code", "Alias": "code", "Type": "System.String" }, "12": { "Name": "copy_remarks", "Index": -1, "NameInSource": "copy_remarks", "Alias": "copy_remarks", "Type": "System.Int16" }, "13": { "Name": "cost_price_currency", "Index": -1, "NameInSource": "cost_price_currency", "Alias": "cost_price_currency", "Type": "System.String" }, "14": { "Name": "cost_price_new", "Index": -1, "NameInSource": "cost_price_new", "Alias": "cost_price_new", "Type": "System.Double" }, "15": { "Name": "cost_price_standard", "Index": -1, "NameInSource": "cost_price_standard", "Alias": "cost_price_standard", "Type": "System.Double" }, "16": { "Name": "created", "Index": -1, "NameInSource": "created", "Alias": "created", "Type": "System.DateTime" }, "17": { "Name": "creator", "Index": -1, "NameInSource": "creator", "Alias": "creator", "Type": "System.String" }, "18": { "Name": "creator_full_name", "Index": -1, "NameInSource": "creator_full_name", "Alias": "creator_full_name", "Type": "System.String" }, "19": { "Name": "description", "Index": -1, "NameInSource": "description", "Alias": "description", "Type": "System.String" }, "20": { "Name": "division", "Index": -1, "NameInSource": "division", "Alias": "division", "Type": "System.Int16" }, "21": { "Name": "end_date", "Index": -1, "NameInSource": "end_date", "Alias": "end_date", "Type": "System.DateTime" }, "22": { "Name": "extra_description", "Index": -1, "NameInSource": "extra_description", "Alias": "extra_description", "Type": "System.String" }, "23": { "Name": "free_bool_field_01", "Index": -1, "NameInSource": "free_bool_field_01", "Alias": "free_bool_field_01", "Type": "System.Int16" }, "24": { "Name": "free_bool_field_02", "Index": -1, "NameInSource": "free_bool_field_02", "Alias": "free_bool_field_02", "Type": "System.Int16" }, "25": { "Name": "free_bool_field_03", "Index": -1, "NameInSource": "free_bool_field_03", "Alias": "free_bool_field_03", "Type": "System.Int16" }, "26": { "Name": "free_bool_field_04", "Index": -1, "NameInSource": "free_bool_field_04", "Alias": "free_bool_field_04", "Type": "System.Int16" }, "27": { "Name": "free_bool_field_05", "Index": -1, "NameInSource": "free_bool_field_05", "Alias": "free_bool_field_05", "Type": "System.Int16" }, "28": { "Name": "free_date_field_01", "Index": -1, "NameInSource": "free_date_field_01", "Alias": "free_date_field_01", "Type": "System.DateTime" }, "29": { "Name": "free_date_field_02", "Index": -1, "NameInSource": "free_date_field_02", "Alias": "free_date_field_02", "Type": "System.DateTime" }, "30": { "Name": "free_date_field_03", "Index": -1, "NameInSource": "free_date_field_03", "Alias": "free_date_field_03", "Type": "System.DateTime" }, "31": { "Name": "free_date_field_04", "Index": -1, "NameInSource": "free_date_field_04", "Alias": "free_date_field_04", "Type": "System.DateTime" }, "32": { "Name": "free_date_field_05", "Index": -1, "NameInSource": "free_date_field_05", "Alias": "free_date_field_05", "Type": "System.DateTime" }, "33": { "Name": "free_number_field_01", "Index": -1, "NameInSource": "free_number_field_01", "Alias": "free_number_field_01", "Type": "System.Double" }, "34": { "Name": "free_number_field_02", "Index": -1, "NameInSource": "free_number_field_02", "Alias": "free_number_field_02", "Type": "System.Double" }, "35": { "Name": "free_number_field_03", "Index": -1, "NameInSource": "free_number_field_03", "Alias": "free_number_field_03", "Type": "System.Double" }, "36": { "Name": "free_number_field_04", "Index": -1, "NameInSource": "free_number_field_04", "Alias": "free_number_field_04", "Type": "System.Double" }, "37": { "Name": "free_number_field_05", "Index": -1, "NameInSource": "free_number_field_05", "Alias": "free_number_field_05", "Type": "System.Double" }, "38": { "Name": "free_number_field_06", "Index": -1, "NameInSource": "free_number_field_06", "Alias": "free_number_field_06", "Type": "System.Double" }, "39": { "Name": "free_number_field_07", "Index": -1, "NameInSource": "free_number_field_07", "Alias": "free_number_field_07", "Type": "System.Double" }, "40": { "Name": "free_number_field_08", "Index": -1, "NameInSource": "free_number_field_08", "Alias": "free_number_field_08", "Type": "System.Double" }, "41": { "Name": "free_text_field_01", "Index": -1, "NameInSource": "free_text_field_01", "Alias": "free_text_field_01", "Type": "System.String" }, "42": { "Name": "free_text_field_02", "Index": -1, "NameInSource": "free_text_field_02", "Alias": "free_text_field_02", "Type": "System.String" }, "43": { "Name": "free_text_field_03", "Index": -1, "NameInSource": "free_text_field_03", "Alias": "free_text_field_03", "Type": "System.String" }, "44": { "Name": "free_text_field_04", "Index": -1, "NameInSource": "free_text_field_04", "Alias": "free_text_field_04", "Type": "System.String" }, "45": { "Name": "free_text_field_05", "Index": -1, "NameInSource": "free_text_field_05", "Alias": "free_text_field_05", "Type": "System.String" }, "46": { "Name": "free_text_field_06", "Index": -1, "NameInSource": "free_text_field_06", "Alias": "free_text_field_06", "Type": "System.String" }, "47": { "Name": "free_text_field_07", "Index": -1, "NameInSource": "free_text_field_07", "Alias": "free_text_field_07", "Type": "System.String" }, "48": { "Name": "free_text_field_08", "Index": -1, "NameInSource": "free_text_field_08", "Alias": "free_text_field_08", "Type": "System.String" }, "49": { "Name": "free_text_field_09", "Index": -1, "NameInSource": "free_text_field_09", "Alias": "free_text_field_09", "Type": "System.String" }, "50": { "Name": "free_text_field_10", "Index": -1, "NameInSource": "free_text_field_10", "Alias": "free_text_field_10", "Type": "System.String" }, "51": { "Name": "glcosts", "Index": -1, "NameInSource": "glcosts", "Alias": "glcosts", "Type": "System.String" }, "52": { "Name": "glcosts_code", "Index": -1, "NameInSource": "glcosts_code", "Alias": "glcosts_code", "Type": "System.String" }, "53": { "Name": "glcosts_description", "Index": -1, "NameInSource": "glcosts_description", "Alias": "glcosts_description", "Type": "System.String" }, "54": { "Name": "glrevenue", "Index": -1, "NameInSource": "glrevenue", "Alias": "glrevenue", "Type": "System.String" }, "55": { "Name": "glrevenue_code", "Index": -1, "NameInSource": "glrevenue_code", "Alias": "glrevenue_code", "Type": "System.String" }, "56": { "Name": "glrevenue_description", "Index": -1, "NameInSource": "glrevenue_description", "Alias": "glrevenue_description", "Type": "System.String" }, "57": { "Name": "glstock", "Index": -1, "NameInSource": "glstock", "Alias": "glstock", "Type": "System.String" }, "58": { "Name": "glstock_code", "Index": -1, "NameInSource": "glstock_code", "Alias": "glstock_code", "Type": "System.String" }, "59": { "Name": "glstock_description", "Index": -1, "NameInSource": "glstock_description", "Alias": "glstock_description", "Type": "System.String" }, "60": { "Name": "gross_weight", "Index": -1, "NameInSource": "gross_weight", "Alias": "gross_weight", "Type": "System.Double" }, "61": { "Name": "id", "Index": -1, "NameInSource": "id", "Alias": "id", "Type": "System.String" }, "62": { "Name": "is_batch_item", "Index": -1, "NameInSource": "is_batch_item", "Alias": "is_batch_item", "Type": "System.Int16" }, "63": { "Name": "is_batch_number_item", "Index": -1, "NameInSource": "is_batch_number_item", "Alias": "is_batch_number_item", "Type": "System.Int16" }, "64": { "Name": "is_fraction_allowed_item", "Index": -1, "NameInSource": "is_fraction_allowed_item", "Alias": "is_fraction_allowed_item", "Type": "System.Int16" }, "65": { "Name": "is_make_item", "Index": -1, "NameInSource": "is_make_item", "Alias": "is_make_item", "Type": "System.Int16" }, "66": { "Name": "is_new_contract", "Index": -1, "NameInSource": "is_new_contract", "Alias": "is_new_contract", "Type": "System.Int16" }, "67": { "Name": "is_on_demand_item", "Index": -1, "NameInSource": "is_on_demand_item", "Alias": "is_on_demand_item", "Type": "System.Int16" }, "68": { "Name": "is_package_item", "Index": -1, "NameInSource": "is_package_item", "Alias": "is_package_item", "Type": "System.Int16" }, "69": { "Name": "is_purchase_item", "Index": -1, "NameInSource": "is_purchase_item", "Alias": "is_purchase_item", "Type": "System.Int16" }, "70": { "Name": "is_registration_code_item", "Index": -1, "NameInSource": "is_registration_code_item", "Alias": "is_registration_code_item", "Type": "System.Int16" }, "71": { "Name": "is_sales_item", "Index": -1, "NameInSource": "is_sales_item", "Alias": "is_sales_item", "Type": "System.Int16" }, "72": { "Name": "is_serial_item", "Index": -1, "NameInSource": "is_serial_item", "Alias": "is_serial_item", "Type": "System.Int16" }, "73": { "Name": "is_serial_number_item", "Index": -1, "NameInSource": "is_serial_number_item", "Alias": "is_serial_number_item", "Type": "System.Int16" }, "74": { "Name": "is_stock_item", "Index": -1, "NameInSource": "is_stock_item", "Alias": "is_stock_item", "Type": "System.Int16" }, "75": { "Name": "is_subcontracted_item", "Index": -1, "NameInSource": "is_subcontracted_item", "Alias": "is_subcontracted_item", "Type": "System.Int16" }, "76": { "Name": "is_taxable_item", "Index": -1, "NameInSource": "is_taxable_item", "Alias": "is_taxable_item", "Type": "System.Int16" }, "77": { "Name": "is_time", "Index": -1, "NameInSource": "is_time", "Alias": "is_time", "Type": "System.Int16" }, "78": { "Name": "is_webshop_item", "Index": -1, "NameInSource": "is_webshop_item", "Alias": "is_webshop_item", "Type": "System.Int16" }, "79": { "Name": "item_group", "Index": -1, "NameInSource": "item_group", "Alias": "item_group", "Type": "System.String" }, "80": { "Name": "item_group_code", "Index": -1, "NameInSource": "item_group_code", "Alias": "item_group_code", "Type": "System.String" }, "81": { "Name": "item_group_description", "Index": -1, "NameInSource": "item_group_description", "Alias": "item_group_description", "Type": "System.String" }, "82": { "Name": "modified", "Index": -1, "NameInSource": "modified", "Alias": "modified", "Type": "System.DateTime" }, "83": { "Name": "modifier", "Index": -1, "NameInSource": "modifier", "Alias": "modifier", "Type": "System.String" }, "84": { "Name": "modifier_full_name", "Index": -1, "NameInSource": "modifier_full_name", "Alias": "modifier_full_name", "Type": "System.String" }, "85": { "Name": "net_weight", "Index": -1, "NameInSource": "net_weight", "Alias": "net_weight", "Type": "System.Double" }, "86": { "Name": "net_weight_unit", "Index": -1, "NameInSource": "net_weight_unit", "Alias": "net_weight_unit", "Type": "System.String" }, "87": { "Name": "notes", "Index": -1, "NameInSource": "notes", "Alias": "notes", "Type": "System.String" }, "88": { "Name": "picture_name", "Index": -1, "NameInSource": "picture_name", "Alias": "picture_name", "Type": "System.String" }, "89": { "Name": "picture_thumbnail_url", "Index": -1, "NameInSource": "picture_thumbnail_url", "Alias": "picture_thumbnail_url", "Type": "System.String" }, "90": { "Name": "picture_url", "Index": -1, "NameInSource": "picture_url", "Alias": "picture_url", "Type": "System.String" }, "91": { "Name": "sales_vat_code", "Index": -1, "NameInSource": "sales_vat_code", "Alias": "sales_vat_code", "Type": "System.String" }, "92": { "Name": "sales_vat_code_description", "Index": -1, "NameInSource": "sales_vat_code_description", "Alias": "sales_vat_code_description", "Type": "System.String" }, "93": { "Name": "search_code", "Index": -1, "NameInSource": "search_code", "Alias": "search_code", "Type": "System.String" }, "94": { "Name": "security_level", "Index": -1, "NameInSource": "security_level", "Alias": "security_level", "Type": "System.Int16" }, "95": { "Name": "start_date", "Index": -1, "NameInSource": "start_date", "Alias": "start_date", "Type": "System.DateTime" }, "96": { "Name": "stock", "Index": -1, "NameInSource": "stock", "Alias": "stock", "Type": "System.Double" }, "97": { "Name": "unit", "Index": -1, "NameInSource": "unit", "Alias": "unit", "Type": "System.String" }, "98": { "Name": "unit_description", "Index": -1, "NameInSource": "unit_description", "Alias": "unit_description", "Type": "System.String" }, "99": { "Name": "unit_type", "Index": -1, "NameInSource": "unit_type", "Alias": "unit_type", "Type": "System.String" } }, "NameInSource": "Suit", "SqlCommand": "select * from eol_item" } }, "Databases": { "0": { "Ident": "StiMySqlDatabase", "Name": "Suit", "Alias": "Suit", "ConnectionStringEncrypted": "41z5a8ZL+5nzFdWEY5zhP4t40UhhBUNZYk399OI9sXvCpq2MyVlLyG8T2aXhHONG2Fr7SEZKw+3hSg==" } } }, "Pages": { "0": { "Ident": "StiPage", "Name": "Page1", "Guid": "b39a1edb487e47ec926b555df9e40434", "Interaction": { "Ident": "StiInteraction" }, "Border": ";;2;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "Text1", "Guid": "f8b3bbf7cebadf5e26144248d656c4f4", "ClientRectangle": "1.8,-0.8,10,0.6", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{var2}" }, "Font": ";10;Bold;", "Border": "All;105,105,105;;;;;;solid:105,105,105", "Brush": "solid:255,255,0", "TextBrush": "solid:Black" }, "1": { "Ident": "StiDataBand", "Name": "DataCategories", "ClientRectangle": "0,0.4,19,0.8", "Interaction": { "Ident": "StiBandInteraction" }, "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "Components": { "0": { "Ident": "StiText", "Name": "DataCategories_CategoryID", "Guid": "e28a6121e582be22052998177ffc3473", "CanGrow": true, "ClientRectangle": "0,0,6.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{eol_item.code}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" }, "1": { "Ident": "StiText", "Name": "DataCategories_CategoryName", "Guid": "74941e38480d31ed029878436ac7a95b", "CanGrow": true, "ClientRectangle": "6.4,0,6.4,0.8", "Interaction": { "Ident": "StiInteraction" }, "Text": { "Value": "{eol_item.description}" }, "VertAlignment": "Center", "Border": ";;;;;;;solid:Black", "Brush": "solid:Transparent", "TextBrush": "solid:Black", "TextOptions": { "WordWrap": true }, "Type": "DataColumn" } }, "DataSourceName": "eol_item" } }, "PageWidth": 21, "PageHeight": 29.7, "Watermark": { "TextBrush": "solid:50,0,0,0" }, "Margins": { "Left": 1, "Right": 1, "Top": 1, "Bottom": 1 } } } }