[
	{
		"_prf_text_value": "ap_qry_cHyTila;1\nap_qry_cAvoin;1\nap_aspopSuorit;OP 529002-2303935,Kassa,195042-32\nap_qry_dLasku1;1.9.2001\nap_qry_dLasku2;31.12.2001\nap_qry_dErä1;1.10.1998\nap_qry_dErä2;31.10.1998\nap_qry_lbQryType;1\n",
		"name_en_us": "open",
		"_prf_name_id": "_qry_ap_Avoin",
		"name": "Avoin",
		"table": "ord"
	},
	{
		"_prf_text_value": "ap_qry_cHyTila;1\nap_qry_cKirj;1\nap_aspopSuorit;OP 529002-2303935,Kassa,195042-32\nap_qry_dLasku1;1.9.2001\nap_qry_dLasku2;31.12.2001\nap_qry_dErä1;1.10.1998\nap_qry_dErä2;31.10.1998\nap_qry_lbQryType;1\n",
		"name_en_us": "entered",
		"_prf_name_id": "_qry_ap_Kirjattu",
		"name": "Kirjattu",
		"table": "ord"
	},
	{
		"_prf_text_value": "ap_qry_cHyTila;1\nap_qry_cHyvä;1\nap_aspopSuorit;OP 529002-2303935,Kassa,195042-32\nap_qry_dLasku1;1.9.2001\nap_qry_dLasku2;31.12.2001\nap_qry_dErä1;1.10.1998\nap_qry_dErä2;31.10.1998\nap_qry_lbQryType;1\n",
		"name_en_us": "payable",
		"_prf_name_id": "_qry_ap_Maksettavat",
		"name": "Maksettavat",
		"table": "ord"
	},
	{
		"_prf_text_value": "do_qry_cType;1\ndo_qry_asTypeCheck;\u0012,,\u0012,,\u0012,\u0012,,,\ndo_qry_asType;Soitto,Koodaus,Selvitys,Kässäri,Myynti,Käynti,Versio,Muu,Testaus\ndo_qry_cState;1\ndo_qry_asStateCheck;\u0012,\u0012,,,,\ndo_qry_asState;Avoin,Aloit.,Tehty,Myöh.,Peruttu,Vaiheessa\ndo_qry_sSeller;AK\ndo_qry_lbQryType;1\n",
		"name_en_us": "open_sales",
		"_prf_name_id": "_qry_do_Avoin myynti",
		"name": "Avoin myynti",
		"table": "do"
	},
	{
		"_prf_text_value": "_txt:=\"KI\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"HY\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"|\";kFalse )\n_date:=_date Current (kTrue )+3\n_qry Fld (0;ap_kDue_Date ;\"<=\";->_date;\"\";kTrue )\n",
		"execute": true,
		"name_en_us": "_exe_3pv maksuun",
		"name": "3pv maksuun",
		"_prf_name_id": "_qry_exe_ap_3pv maksuun",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"KI\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"HY\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"|\";kFalse )\n_date:=_date Current (kTrue )+7\n_qry Fld (0;ap_kDue_Date ;\"<=\";->_date;\"\";kTrue )\n",
		"execute": true,
		"name_en_us": "_exe_7pv maksuun",
		"name": "7pv maksuun",
		"_prf_name_id": "_qry_exe_ap_7pv maksuun",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"KI\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"HY\"\n_qry Fld (0;ap_kApproval_State ;\"=\";->_txt;\"|\";kFalse )\n_date:=_date Current (kTrue )\n_qry Fld (0;ap_kDue_Date ;\"<=\";->_date;\"\";kTrue )\n",
		"execute": true,
		"name_en_us": "_exe_Tänään maksuun",
		"name": "Tänään maksuun",
		"_prf_name_id": "_qry_exe_ap_Tänään maksuun",
		"table": "ord"
	},
	{
		"_prf_text_value": "COMPILER_in\n_txt:=ksWildcard +<>in_tElectronicInvoiceSendType+ksWildcard \n_qry Fld (0;co_kSend_Type ;\"=\";->_txt;\"\";kTrue )",
		"execute": true,
		"name_en_us": "_exe_FinvoiceCustomer",
		"name": "FinvoiceCustomer",
		"_prf_name_id": "_qry_exe_co_FinvoiceCustomer",
		"table": "co"
	},
	{
		"_prf_text_value": "_txt:=ksWildcard +<>in_tElectronicInvoiceSendType+ksWildcard \n_qry Fld (0;in_kSend_Type ;\"=\";->_txt;\"\";kTrue )",
		"execute": true,
		"name_en_us": "_exe_FinvoiceAll",
		"name": "FinvoiceAll",
		"_prf_name_id": "_qry_exe_in_FinvoiceAll",
		"table": "in"
	},
	{
		"_prf_text_value": "_txt:=ksWildcard +<>in_tElectronicInvoiceSendType+ksWildcard \n_qry Fld(0;in_kSend_Type;\"=\";->_txt;\"*\";kFalse)\n_long:=0\n_qry Fld (0;in_kState ;\"<=\";->_Long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_FinvoiceOpen",
		"name": "FinvoiceOpen",
		"_prf_name_id": "_qry_exe_in_FinvoiceOpen",
		"table": "in"
	},
	{
		"_prf_text_value": "_txt:=ksWildcard +<>in_tElectronicInvoiceSendType+ksWildcard \n_qry Fld(0;in_kSend_Type;\"=\";->_txt;\"*\";kFalse)\n_qry Fld(0;in_kSend_State;\"#\";->_txt;\"&*\";kFalse)\n_long:=0\n_qry Fld (0;in_kState ;\"<=\";->_Long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_FinvoiceOpenNotSent",
		"name": "FinvoiceOpenNotSent",
		"_prf_name_id": "_qry_exe_in_FinvoiceOpenNotSent",
		"table": "in"
	},
	{
		"_prf_text_value": "_fo SEL_USE (Into current selection;\"\")\n\nARRAY TEXT(_atArr;0)\n_sel_ SEL_TO_ARR_one (wo_kWork__Position_Num_id;->_atArr)\n_qry ARRAY (wo_kWork__Position_Num_id;->_atArr)\nARRAY TEXT(_atArr;0)\n\nwo_ OPEN_QRY (kTrue)\n_txt:=ld_kStateStarted\n_qry Fld (0;wo_kState;\"#\";->_txt;\"\";kTrue;kFalse)\n\n_long:=_fo_ SpecialOrderFld (kSet;wo_kProduction_Lot)",
		"execute": true,
		"name_en_us": "_exe_SelectedNotStartedSameProducts",
		"name": "SelectedNotStartedSameProducts",
		"_prf_name_id": "_qry_exe_wo_SelectedNotStartedSameProducts",
		"table": "pro"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!\n_date2:=_date Current (kTrue)\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"#\";->_date;\"*\";kTrue )\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"<=\";->_date2;\"&\";kTrue )\n_set CREATE(por_kTbl;\"por_LateSetTmp1\")\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"=\";->_date;\"*\";kTrue )\n_qry Fld (0;por_kRequested_Delivery_Date;\"<=\";->_date2;\"&\";kTrue )\n_set CREATE(por_kTbl;\"por_LateSetTmp2\")\n\n_set UNION(por_kTbl;\"por_LateSetTmp1\";\"por_LateSetTmp2\";\"por_LateSetTmp1\")\n_set USE(por_kTbl;\"por_LateSetTmp1\")\n\n_sel RELATE ONE SELECTION(por_kPurchase_Order_id;po_kPurchase_Order_id)\n_firm SEL_REDUCE (po_kTbl )\n\n_set CLEAR(por_kTbl;\"por_LateSetTmp1\")\n_set CLEAR(por_kTbl;\"por_LateSetTmp2\")\n",
		"execute": true,
		"name_en_us": "_exe_Myöhässä",
		"name": "Myöhässä",
		"_prf_name_id": "_qry_exe_po_Myöhässä",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"VA\"\n_qry Fld (po_kTbl;po_kState ;\"=\";->_txt;\"*\";kFalse;kFalse )\n_long:=-10\n_qry Fld (po_kTbl;po_kTransfer_State ;\"<=\";->_long;\"&\";kFalse;kFalse )",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_po_Sql Lähetettävät",
		"table": "ord"
	},
	{
		"_prf_text_value": "[Purchase_Order]Transfer_id:=[Purchase_Order]Purchase_Order_ID",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_po_Sql Tallenna_siirtotunnus",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (po_kTbl;po_kTransfer_id ;\"=\";->_txt;\"\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_po_Sql Tyhjä_siirtotunnus",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"AV\"  `haetaan \"avoin\"-tyyppiset rivit (tilauksen tyyppi on AV|TI|VA|OT)\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"TI\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|*\";kFalse )\n_txt:=\"VA\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|*\";kFalse )\n_txt:=\"OT\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|\";kFalse )\n\n_txt:=\"\"  `etsitään valinnasta rivit joita ei ole toimitettu\n_qry Fld (0;por_kDelivery_State ;\"=\";->_txt;\"\";kTrue )  `kTrue = etsii valinnasta\n\n_txt:=\"MU\"  `etsitään valinnasta muut paitsi MU- ja SI-tyyppiset rivit\n_qry Fld (0;por_kType_ ;\"#\";->_txt;\"*\";kTrue )\n_txt:=\"SI\"\n_qry Fld (0;por_kType_ ;\"#\";->_txt;\"&\";kTrue )",
		"execute": true,
		"name_en_us": "_exe_Kaikki avoimet",
		"name": "Kaikki avoimet",
		"_prf_name_id": "_qry_exe_por_Kaikki avoimet",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_txt:=\"VA\"\n_qry Fld (po_kTbl;po_kState ;\"=\";->_txt;\"\";kFalse;kFalse )\n_sel RELATE MANY SELECTION(por_kPurchase_Order_id)\n_long:=-10\n_qry Fld (por_kTbl;por_kTransfer_State ;\"<=\";->_long;\"\";kTrue;kFalse )",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_por_Sql Lähetettävät",
		"table": "ordr"
	},
	{
		"_prf_text_value": "[Purchase_Order_Row]Transfer_id:=[Purchase_Order_Row]Purchase_Order_id+\"-\"+String([Purchase_Order_Row]Row_Number)",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_por_Sql Tallenna_siirtotunnus",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (por_kTbl;por_kTransfer_id ;\"=\";->_txt;\"\";kFalse;kFalse )",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_por_Sql Tyhjä_siirtotunnus",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_txt:=\"AV\"  `haetaan \"avoin\"-tyyppiset rivit (tilauksen tyyppi on AV|TI|VA|OT)\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"TI\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|*\";kFalse )\n_txt:=\"VA\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|*\";kFalse )\n_txt:=\"OT\"\n_qry Fld (0;por_kOrder_State ;\"=\";->_txt;\"|\";kFalse )\n\n_txt:=\"\"  `etsitään valinnasta rivit joita ei ole toimitettu\n_qry Fld (0;por_kDelivery_State ;\"=\";->_txt;\"\";kTrue )  `kTrue = etsii valinnasta\n\n_txt:=\"MU\"  `etsitään valinnasta muut paitsi MU- ja SI-tyyppiset rivit\n_qry Fld (0;por_kType_ ;\"#\";->_txt;\"*\";kTrue )\n_txt:=\"SI\"\n_qry Fld (0;por_kType_ ;\"#\";->_txt;\"&\";kTrue )\n\n_txt:=\"10187\"  `etsitään valinnasta UC-ABRA-toimittajien rivit\n_qry Fld (por_kTbl ;po_kSupplier_id ;\"=\";->_txt;\"\";kTrue )  `kTrue = etsii valinnasta",
		"execute": true,
		"name_en_us": "_exe_UC-ABRA avoimet",
		"name": "UC-ABRA avoimet",
		"_prf_name_id": "_qry_exe_por_UC-ABRA avoimet",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_set CREATE (pr_kTbl ;\"pr_MissingDrawingSetOrig\")\npr_ DOCUMENT_EXIST(\"Piirustus\";pr_kTbl)\n_set CREATE (pr_kTbl ;\"pr_MissingDrawingSet1\")\n_set DIFFERENCE (pr_kTbl ;\"pr_MissingDrawingSetOrig\";\"pr_MissingDrawingSet1\";\"pr_MissingDrawingSet1\")\n_set USE (pr_kTbl ;\"pr_MissingDrawingSet1\")\n_set CLEAR (pr_kTbl ;\"pr_MissingDrawingSet1\")\n_set CLEAR (pr_kTbl ;\"pr_MissingDrawingSetOrig\")",
		"execute": true,
		"name_en_us": "_exe_DrawingMissing",
		"name": "DrawingMissing",
		"_prf_name_id": "_qry_exe_pr_DrawingMissing",
		"table": "pr"
	},
	{
		"_prf_text_value": "",
		"execute": true,
		"name_en_us": "_exe_LinkFilter",
		"name": "LinkFilter",
		"_prf_name_id": "_qry_exe_pr_LinkFilter",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"=\";->_txt;\"\";kFalse)\n\n_txt:=_fld Name4DLong (pr_kAction_Limit__unit)+\">\"+_fld Name4DLong (pr_kStock_Balance__unit)\n_qry_ Formula (pr_kTbl ;_txt;kTrue )",
		"execute": true,
		"name_en_us": "_exe_Mat_hälraja_alittunut",
		"name": "Mat_hälraja_alittunut",
		"_prf_name_id": "_qry_exe_pr_Mat_hälraja_alittunut",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"=\";->_txt;\"*\";kFalse)\n\n_date:=_date Current(kTrue)+5\n_qry Fld (0;pr_kCritical_Start_Date;\"<=\";->_date;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_ProductCrStartDate5",
		"name": "ProductCrStartDate5",
		"_prf_name_id": "_qry_exe_pr_ProductCrStartDate5",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"=\";->_txt;\"*\";kFalse)\n\n_long:=0\n_qry Fld (0;pr_kFree_Amount  ;\"<\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_PurchaseOrderNeed",
		"name": "PurchaseOrderNeed",
		"_prf_name_id": "_qry_exe_pr_PurchaseOrderNeed",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"RL0@\"\n_qry Fld (0;pr_kProduct_id;\"=\";->_txt;\"*\";kFalse)\n_txt:=\"HL0@\"\n_qry Fld (0;pr_kProduct_id;\"=\";->_txt;\"|\";kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_RST_HST",
		"name": "RST_HST",
		"_prf_name_id": "_qry_exe_pr_RST_HST",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"#\";->_txt;\"\";kFalse)\n\n_txt:=_fld Name4DLong (pr_kAction_Limit__unit)+\">\"+_fld Name4DLong (pr_kStock_Balance__unit)\n_qry_ Formula (pr_kTbl ;_txt;kTrue )",
		"execute": true,
		"name_en_us": "_exe_Töiden_hälraja_alittunut",
		"name": "Töiden_hälraja_alittunut",
		"_prf_name_id": "_qry_exe_pr_Töiden_hälraja_alittunut",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"#\";->_txt;\"*\";kFalse)\n\n_date:=_date Current(kTrue)+5\n_qry Fld (0;pr_kCritical_Start_Date;\"<=\";->_date;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_WorkOrderCrStartDate5",
		"name": "WorkOrderCrStartDate5",
		"_prf_name_id": "_qry_exe_pr_WorkOrderCrStartDate5",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;pr_kWork__Position_Num_id;\"#\";->_txt;\"*\";kFalse)\n\n_long:=0\n_qry Fld (0;pr_kFree_Amount  ;\"<\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_WorkOrderNeed",
		"name": "WorkOrderNeed",
		"_prf_name_id": "_qry_exe_pr_WorkOrderNeed",
		"table": "pr"
	},
	{
		"_prf_text_value": "_txt:=\"TI\"\n_qry Fld (0;so_kType_ ;\"=\";->_txt;\"*\";kFalse )\n_txt:=\"MT\"\n_qry Fld (0;so_kType_ ;\"=\";->_txt;\"|\";kFalse )\n\n_txt:=\"PE\"\n_qry Fld (0;so_kState ;\"#\";->_txt;\"\";kTrue )  `find selection\n\nIf (_sel RecsInSel (so_kTbl )>0)\n  _sel RELATE MANY SELECTION (sor_kSales_Order_id )\n  _txt:=\"\"\n  _qry Fld (0;sor_kInvoice_id ;\"=\";->_txt;\"\";kTrue )\n  _sel RELATE ONE SELECTION (sor_kSales_Order_id ;so_kSales_Order_ID )\nEnd if ",
		"execute": true,
		"name_en_us": "_exe_Laskuttamatta",
		"name": "Laskuttamatta",
		"_prf_name_id": "_qry_exe_so_Laskuttamatta",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;sor_kDelivery_State ;\"#\";->_txt;\"*\";kFalse )\n_txt:=\"\"\n_qry Fld (0;sor_kWaybill_id ;\"=\";->_txt;\"&\";kFalse )\n\n_sel RELATE ONE SELECTION (sor_kSales_Order_id ;so_kSales_Order_ID )\n\n_txt:=\"PE\"\n_qry Fld (0;so_kState ;\"#\";->_txt;\"\";kTrue )  `find selection",
		"execute": true,
		"name_en_us": "_exe_Rahtikirja tekemättä",
		"name": "Rahtikirja tekemättä",
		"_prf_name_id": "_qry_exe_so_Rahtikirja tekemättä",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld(0;sor_kInvoice_id;\"=\";->_txt;\"*\";kFalse)\n_txt:=\"\"\n_qry Fld(0;sor_kDelivery_State;\"#\";->_txt;\"&\";kFalse)\n_sel RELATE ONE SELECTION(sor_kSales_Order_id;so_kSales_Order_ID)\n\n_txt:=\"PE\"\n_qry Fld(0;so_kState;\"#\";->_txt;\"\";kTrue)",
		"execute": true,
		"name_en_us": "_exe_Toimitettu laskuttamatta",
		"name": "Toimitettu laskuttamatta",
		"_prf_name_id": "_qry_exe_so_Toimitettu laskuttamatta",
		"table": "ord"
	},
	{
		"_prf_text_value": "sor_HAE AVOIMET\n_sel RELATE ONE SELECTION(sor_kSales_Order_id;so_kSales_Order_ID)",
		"execute": true,
		"name_en_us": "_exe_Toimittamatta",
		"name": "Toimittamatta",
		"_prf_name_id": "_qry_exe_so_Toimittamatta",
		"table": "ord"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!`!01.01.90!\n_date2:=_date Current (kTrue )+14\n_info_ TIME_PERIOD_ASK (\"Toimituspäivä-väli:\";_date;_date2)\nIf (OK=1)\n  _info_ TIME_PERIOD_DATES_GET (->_date;->_date2)\n  sor_HAE AVOIMET (False)\n  _qry Fld (0;sor_kDelivered_Date ;\">=\";->_date;\"*\";kTrue )\n  _qry Fld (0;sor_kDelivered_Date ;\"<=\";->_date2;\"&\";kTrue )\n  _firm SEL_REDUCE (sor_kTbl )\n  _sel RELATE ONE SELECTION (sor_kSales_Order_id ;so_kSales_Order_ID )\nEnd if ",
		"execute": true,
		"name_en_us": "_exe_Toimittamatta_pv",
		"name": "Toimittamatta_pv",
		"_prf_name_id": "_qry_exe_so_Toimittamatta_pv",
		"table": "ord"
	},
	{
		"_prf_text_value": "sor_HAE AVOIMET (False)\n_set CREATE (sor_kTbl;\"sor_OpenRows_tmp\")\n\n_txt:=\"600 SONET\"\n_qry Fld (0;pr_kProduct_Group;\"#\";->_txt;\"\";kFalse;kFalse)\n_sel RELATE MANY SELECTION (sor_kProduct_id)\n_set CREATE (sor_kTbl;\"sor_OpenRows_tmp2\")\n_set INTERSECTION (sor_kTbl;\"sor_OpenRows_tmp\";\"sor_OpenRows_tmp2\";\"sor_OpenRows_tmp\")\n\n_txt:=\"KAUKONEN\"\n_qry Fld (0;so_kEmployee_id;\"=\";->_txt;\"*\";kFalse;kFalse)\n_txt:=\"KYMÄLÄINEN\"\n_qry Fld (0;so_kEmployee_id;\"=\";->_txt;\"|\";kFalse;kFalse)\n_sel RELATE MANY SELECTION (sor_kSales_Order_id)\n_set CREATE (sor_kTbl;\"sor_OpenRows_tmp2\")\n\n_set INTERSECTION (sor_kTbl;\"sor_OpenRows_tmp\";\"sor_OpenRows_tmp2\";\"sor_OpenRows_tmp\")\n_set USE (sor_kTbl;\"sor_OpenRows_tmp\")\n_set CLEAR (sor_kTbl;\"sor_OpenRows_tmp\")\n_set CLEAR (sor_kTbl;\"sor_OpenRows_tmp2\")",
		"execute": true,
		"name_en_us": "_exe_KaukonenKymalainen",
		"name": "KaukonenKymalainen",
		"_prf_name_id": "_qry_exe_sor_KaukonenKymalainen",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_set CREATE (w_kTbl ;\"w_MissingDrawingSetOrig\")\n\nif(True)\n  pr_ DOCUMENT_EXIST(\"Piirustus\";w_kTbl)\n  _set CREATE (w_kTbl ;\"w_MissingDrawingSet1\")\nelse\n  _txt:=\"Piirustus\"\n  _qry Fld (0;af_kHeader ;\"=\";->_txt;\"\";kFalse )\n  _lnk_ SELECTION_LINKED_SELECT (0;af_kTbl ;w_kTbl )  `get works\n  _set CREATE (w_kTbl ;\"w_MissingDrawingSet1\")\n  _lnk_ SELECTION_LINKED_SELECT (0;af_kTbl ;pr_kTbl )  `get products\n  _sel RELATE MANY SELECTION (w_kProduct_id )\n  _set CREATE (w_kTbl ;\"w_MissingDrawingSet2\")\n  _set UNION (w_kTbl ;\"w_MissingDrawingSet1\";\"w_MissingDrawingSet2\";\"w_MissingDrawingSet1\")\n  _set CLEAR (w_kTbl ;\"w_MissingDrawingSet2\")\nend if\n\n_set DIFFERENCE (w_kTbl ;\"w_MissingDrawingSetOrig\";\"w_MissingDrawingSet1\";\"w_MissingDrawingSet1\")\n_set USE (w_kTbl ;\"w_MissingDrawingSet1\")\n_set CLEAR (w_kTbl ;\"w_MissingDrawingSet1\")\n_set CLEAR (w_kTbl ;\"w_MissingDrawingSetOrig\")",
		"execute": true,
		"name_en_us": "_exe_DrawingMissing",
		"name": "DrawingMissing",
		"_prf_name_id": "_qry_exe_w_DrawingMissing",
		"table": "pr"
	},
	{
		"_prf_text_value": "",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_wma_Sql Lähetettävät",
		"table": "prma"
	},
	{
		"_prf_text_value": "[Work_Material_Actual]Transfer_id:=[Work_Order]Sales_Order_id+\"-\"+String([Work_Order]Sales_Order_Row_id;\"000\")+\"#\"+[Work_Material_Actual]Record_ID",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_wma_Sql Tallenna_siirtotunnus",
		"table": "prma"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (wma_kTbl;wma_kTransfer_id ;\"=\";->_txt;\"\";kFalse;kFalse )\n\n",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_wma_Sql Tyhjä_siirtotunnus",
		"table": "prma"
	},
	{
		"_prf_text_value": "_rel AUTOMATIC_ONE (kTrue )\n_txt:=\"\"\n_qry Fld (wme_kTbl ;w_kRecord_ID ;\"=\";->_txt;\"\";kFalse )\n_rel AUTOMATIC_ONE (kPrevious )",
		"execute": true,
		"name_en_us": "_exe_Orphan",
		"name": "Orphan",
		"_prf_name_id": "_qry_exe_wme_Orphan",
		"table": "prma"
	},
	{
		"_prf_text_value": "_sel ALL_RECS (pr_kTbl)\n_sel RELATE MANY SELECTION (wme_kRaw_Material_id)\n_sel SELECTED_NOT (wme_kTbl)",
		"execute": true,
		"name_en_us": "_exe_OrphanMaterial",
		"name": "OrphanMaterial",
		"_prf_name_id": "_qry_exe_wme_OrphanMaterial",
		"table": "prma"
	},
	{
		"_prf_text_value": "",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_wme_Sql Lähetettävät",
		"table": "prma"
	},
	{
		"_prf_text_value": "[Work_Material_Estimated]Transfer_id:=[Work_Material_Estimated]Record_ID",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_wme_Sql Tallenna_siirtotunnus",
		"table": "prma"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (wme_kTbl;wme_kTransfer_id ;\"=\";->_txt;\"\";kFalse;kFalse )\n\n",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_wme_Sql Tyhjä_siirtotunnus",
		"table": "prma"
	},
	{
		"_prf_text_value": "_txt:=\"-1\"\n_qry Fld (wpa_kTbl;wpa_kType_ ;\"=\";->_txt;\"\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_wpa_Sql Lähetettävät",
		"table": "prwo"
	},
	{
		"_prf_text_value": "[Work_Phase_Actual]Transfer_id:=[Work_Order]Sales_Order_id+\"-\"+String([Work_Order]Sales_Order_Row_id;\"000\")+\"#\"+[Work_Phase_Actual]Record_ID",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_wpa_Sql Tallenna_siirtotunnus",
		"table": "prwo"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (wpa_kTbl;wpa_kTransfer_id ;\"=\";->_txt;\"\";kFalse )\n\n",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_wpa_Sql Tyhjä_siirtotunnus",
		"table": "prwo"
	},
	{
		"_prf_text_value": "",
		"execute": true,
		"name_en_us": "_exe_Sql Lähetettävät",
		"name": "Sql Lähetettävät",
		"_prf_name_id": "_qry_exe_wpe_Sql Lähetettävät",
		"table": "prwo"
	},
	{
		"_prf_text_value": "[Work_Phase_Estimated]Transfer_id:=[Work_Phase_Estimated]Record_ID",
		"execute": true,
		"name_en_us": "_exe_Sql Tallenna_siirtotunnus",
		"name": "Sql Tallenna_siirtotunnus",
		"_prf_name_id": "_qry_exe_wpe_Sql Tallenna_siirtotunnus",
		"table": "prwo"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (wpe_kTbl;wpe_kTransfer_id ;\"=\";->_txt;\"\";kFalse;kFalse )\n",
		"execute": true,
		"name_en_us": "_exe_Sql Tyhjä_siirtotunnus",
		"name": "Sql Tyhjä_siirtotunnus",
		"_prf_name_id": "_qry_exe_wpe_Sql Tyhjä_siirtotunnus",
		"table": "prwo"
	},
	{
		"_prf_text_value": "IN_QRY_CRESKON;1\nSSRRLAEIRES;1\nIN_QRY_DPVALKU;1.1.2000\nIN_QRY_DPVLOPP;31.12.2000\n",
		"name_en_us": "open",
		"_prf_name_id": "_qry_in_Avoimet",
		"name": "Avoimet",
		"table": "in"
	},
	{
		"_prf_text_value": "IN_QRY_CTYYPPI;1\nIN_QRY_CHY;1\nIN_QRY_CKO;1\nSSRRLAEIRES;1\nIN_QRY_DPVALKU;01.01.2000\nIN_QRY_DPVLOPP;31.12.2000\n",
		"name_en_us": "refund_and_interest_invoices",
		"_prf_name_id": "_qry_in_Hyvitys ja korkolaskut",
		"name": "Hyvitys ja korkolaskut",
		"table": "in"
	},
	{
		"_prf_text_value": "in_qry_cTyyppi;1\nin_qry_cKÄ;1\nssrrLaEiRes;1\nin_qry_dPvAlku;1.1.2000\nin_qry_dPvLopp;31.12.2000\n",
		"name_en_us": "invoice_cash",
		"_prf_name_id": "_qry_in_Käteislaskut",
		"name": "Käteislaskut",
		"table": "in"
	},
	{
		"_prf_text_value": "in_qry_cTulost;1\nrsrrLaEiTul;1\nssrrLaEiRes;1\nin_qry_dPvAlku;1.1.2000\nin_qry_dPvLopp;31.12.2000\n",
		"name_en_us": "not_printed",
		"_prf_name_id": "_qry_in_Tulostamattomat",
		"name": "Tulostamattomat",
		"table": "in"
	},
	{
		"_prf_text_value": "in_qry_cTulost;1\nrsrrLaOnTul;1\nssrrLaEiRes;1\nin_qry_dPvAlku;01.01.2000\nin_qry_dPvLopp;31.12.2000\nin_qry_lbQryType;1\n",
		"name_en_us": "printed",
		"_prf_name_id": "_qry_in_Tulostetut",
		"name": "Tulostetut",
		"table": "in"
	},
	{
		"_prf_text_value": "inr_qry_cTyyppi;1\ninr_qry_cNO;1\ninr_qry_cHY;1\ninr_qry_cVÄ;1\ninr_qry_cKO;1\ninr_qry_cKÄ;1\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "invoice_row_vat",
		"_prf_name_id": "_qry_inr_ALV Laskurivit",
		"name": "ALV Laskurivit",
		"table": "inr"
	},
	{
		"_prf_text_value": "inr_qry_sTuoteR;SU\ninr_qry_cOKoodi;1\ninr_qry_sOKoodi;0\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "history",
		"_prf_name_id": "_qry_inr_Historia",
		"name": "Historia",
		"table": "inr"
	},
	{
		"_prf_text_value": "inr_qry_dLPvAlk;1.12.2004\ninr_qry_dLPvLop;31.12.2004\ninr_qry_sTuoteR;SU\ninr_qry_sLToimi;MANAGE\ninr_qry_cOKoodi;1\ninr_qry_sOKoodi;2\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "history_df",
		"_prf_name_id": "_qry_inr_Historia_df",
		"name": "Historia_df",
		"table": "inr"
	},
	{
		"_prf_text_value": "inr_qry_cLPvm;1\ninr_qry_dLPvAlk;14.9.2006\ninr_qry_dLPvLop;14.9.2006\ninr_qry_sLToimi;MANAGE\ninr_qry_sOKoodi;0\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "intrastat",
		"_prf_name_id": "_qry_inr_Intrastat",
		"name": "Intrastat",
		"table": "inr"
	},
	{
		"_prf_text_value": "inr_qry_cLPvm;1\ninr_qry_dLPvAlk;1.1.2009\ninr_qry_dLPvLop;31.12.2009\nusrrLrOnKäy;1\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "invoices_per_customer",
		"_prf_name_id": "_qry_inr_Laskutus/Asiakas",
		"name": "Laskutus/Asiakas",
		"table": "inr"
	},
	{
		"_prf_text_value": "inr_qry_cLPvm;1\ninr_qry_dLPvAlk;1.1.1990\ninr_qry_dLPvLop;31.5.2014\ninr_qry_cNO;1\ninr_qry_cVÄ;1\ninr_qry_sLToimi;MANAGE\ninr_qry_sOKoodi;0\nusrrLrOnKäy;1\nin_qry_lbQryType;1\ninr_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "units_and_value",
		"_prf_name_id": "_qry_inr_Units & Value",
		"name": "Units & Value",
		"table": "inr"
	},
	{
		"_prf_text_value": "po_qry_cTyyppi;1\npo_qry_cTyAH;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cVA;1\npo_qry_lbQryType;1\n",
		"name_en_us": "subcontracts",
		"_prf_name_id": "_qry_po_Alihankinnat",
		"name": "Alihankinnat",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_qry_sToimit;a@\npo_qry_cTyyppi;1\npo_qry_cTyAH;1\npo_qry_cTila;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cVA;1\npo_qry_dEtop1;10/06/15\npo_qry_dEtop2;31/12/15\npo_qry_lbQryType;1\n",
		"name_en_us": "open_subcontracts",
		"_prf_name_id": "_qry_po_Avoimet alihankinnat",
		"name": "Avoimet alihankinnat",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_qry_cTyyppi;1\npo_qry_cTyRA;1\npo_qry_cTila;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cVA;1\npo_qry_lbQryType;1\n",
		"name_en_us": "open_raw_material",
		"_prf_name_id": "_qry_po_Avoimet RA",
		"name": "Avoimet RA",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_qry_cTyyppi;1\npo_qry_cTyRA;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cVA;1\npo_qry_lbQryType;1\n",
		"name_en_us": "raw_materials",
		"_prf_name_id": "_qry_po_Raaka-aineet",
		"name": "Raaka-aineet",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_qry_cTila;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cVA;1\npo_qry_lbQryType;1\n",
		"name_en_us": "not_delivered",
		"_prf_name_id": "_qry_po_Toimittamattomat",
		"name": "Toimittamattomat",
		"table": "ord"
	},
	{
		"_prf_text_value": "POR_QRY_CAV;1\nPOR_QRY_COT;1\nPOR_QRY_CTITILA;1\nPOR_QRY_CTAV;1\nPOR_QRY_CTTI;1\nPOR_QRY_CTTO;1\nPOR_QRY_COTT;1\nPOR_QRY_CTVA;1\nPOR_QRY_CRES;1\nSSRROREIRES;1\nPOR_QRY_CVAPVM;1\nPOR_QRY_DVAALKU;1.1.1999\nPOR_QRY_DVALOPP;31.12.2006\nPOR_QRY_LBQRYTYPE;1\nPO_QRY_LBQRYTYPE;1\nPR_QRY_LBQRYTYPE;1\n",
		"name_en_us": "open",
		"_prf_name_id": "_qry_por_Avoimet",
		"name": "Avoimet",
		"table": "ordr"
	},
	{
		"_prf_text_value": "por_qry_cTila;1\npor_qry_cOT;1\npor_qry_cLT;1\npor_qry_cTTI;1\npor_qry_cTTO;1\npor_qry_cOTT;1\npor_qry_cTVA;1\nssrrOrEiRes;1\npor_qry_cVaPvm;1\npor_qry_dVaAlku;1.6.2000\npor_qry_dVaLopp;30.6.2020\npor_qry_lbQryType;1\npo_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "reliability_of_delivery",
		"_prf_name_id": "_qry_por_Toimitusvarmuus",
		"name": "Toimitusvarmuus",
		"table": "ordr"
	},
	{
		"_prf_text_value": "pr_qry_cEiKäyt;1\nusrtuEiKäy1;1\nappa_rtuHälRa1;1\npr_qry_lbQryType;1\n",
		"name_en_us": "_",
		"_prf_name_id": "_qry_pr_",
		"name": "",
		"table": "pr"
	},
	{
		"_prf_text_value": "pr_qry_cEiKäyt;1\nusrtuEiKäy1;1\npr_qry_cHälRaj;1\nappa_rtuHälRa1;1\npr_qry_lbQryType;1\n",
		"name_en_us": "below_action_limit",
		"_prf_name_id": "_qry_pr_Hälytysraja alittunut",
		"name": "Hälytysraja alittunut",
		"table": "pr"
	},
	{
		"_prf_text_value": "pr_qry_cEiKäyt;1\nusrtuEiKäy1;1\nappa_rtuHälRa1;1\npr_qry_lbQryType;1\n",
		"name_en_us": "in_use",
		"_prf_name_id": "_qry_pr_Käytössä",
		"name": "Käytössä",
		"table": "pr"
	},
	{
		"_prf_text_value": "rcl_qry_cLoadGroup;1\nrcl_qry_sLoadGroup;@\nrcl_qry_cState;1\nrcl_qry_lState;1\nrcl_qry_cCalculationType;1\nrcl_qry_lCalculationType;1\nrcl_qry_lbQryType;1\n",
		"name_en_us": "report_search",
		"_prf_name_id": "_qry_rcl_Raporttihaku",
		"name": "Raporttihaku",
		"table": "rcl"
	},
	{
		"_prf_text_value": "rcl_qry_cLoadGroup;1\nrcl_qry_sLoadGroup;h@\nrcl_qry_cFinishedDate;1\nrcl_qry_lState;1\nrcl_qry_lCalculationType;1\nrcl_qry_lbQryType;1\n",
		"name_en_us": "test",
		"_prf_name_id": "_qry_rcl_testi",
		"name": "testi",
		"table": "rcl"
	},
	{
		"_prf_text_value": "rcl_qry_cState;1\nrcl_qry_lState;-1\nrcl_qry_cCalculationType;1\nrcl_qry_lCalculationType;0\nrcl_qry_lbQryType;1\n",
		"name_en_us": "new_not_counted",
		"_prf_name_id": "_qry_rcl_Uusi, ei lasketa",
		"name": "Uusi, ei lasketa",
		"table": "rcl"
	},
	{
		"_prf_text_value": "so_qry_cTyyppi;1\nso_qry_cTA;1\nso_qry_cTila;1\nso_qry_cAT;1\nso_qry_cAL;1\nso_qry_dTiAlk;01.01.01\nso_qry_dTiLop;31.12.01\nso_qry_lbQryType;1\nso_qry_cVA;1\nso_qry_cEV;1\n",
		"name_en_us": "open_offers",
		"_prf_name_id": "_qry_so_Av. tarjoukset",
		"name": "Av. tarjoukset",
		"table": "ord"
	},
	{
		"_prf_text_value": "so_qry_cTyyppi;1\nso_qry_cTA;1\nso_qry_cTI;1\nso_qry_cTila;1\nso_qry_cAT;1\n",
		"name_en_us": "open_offer_and_order",
		"_prf_name_id": "_qry_so_Avoimet ta ti",
		"name": "Avoimet ta ti",
		"table": "ord"
	},
	{
		"_prf_text_value": "SO_QRY_CTYYPPI;1\nSO_QRY_CTI;1\nSO_QRY_CTILA;1\nSO_QRY_CAT;1\nSO_QRY_CAL;1\nSO_QRY_LBQRYTYPE;1\nSO_QRY_CVA;1\nSO_QRY_CEV;1\n",
		"name_en_us": "open_orders",
		"_prf_name_id": "_qry_so_Avoimet til.",
		"name": "Avoimet til.",
		"table": "ord"
	},
	{
		"_prf_text_value": "SO_QRY_CTA;1\nSO_QRY_CTI;1\nSO_QRY_CTILA;1\nSO_QRY_DTOALKU;1.1.2004\nSO_QRY_DTOLOPP;31.12.2004\nSO_QRY_DTIALK;1.1.2002\nSO_QRY_DTILOP;31.12.2002\nSO_QRY_STILAAJ;manage\nSO_QRY_SMYYJA;pm\nSO_QRY_LBQRYTYPE;1\nSO_QRY_CEV;1\n",
		"name_en_us": "not_confirmed",
		"_prf_name_id": "_qry_so_Ei vahv.",
		"name": "Ei vahv.",
		"table": "ord"
	},
	{
		"_prf_text_value": "so_qry_cTyyppi;1\nso_qry_cTI;1\nso_qry_cTila;1\nso_qry_cVA;1\n",
		"name_en_us": "accepted_orders",
		"_prf_name_id": "_qry_so_Hyväksytyt tilaukset",
		"name": "Hyväksytyt tilaukset",
		"table": "ord"
	},
	{
		"_prf_text_value": "SO_QRY_CTYYPPI;1\nSO_QRY_CTI;1\nSO_QRY_CTILA;1\nSO_QRY_CLO;1\n",
		"name_en_us": "finished_orders",
		"_prf_name_id": "_qry_so_Lopetetut tilaukset",
		"name": "Lopetetut tilaukset",
		"table": "ord"
	},
	{
		"_prf_text_value": "SO_QRY_CTI;1\nSO_QRY_CTILA;1\nSO_QRY_CLO;1\nSO_QRY_CLS;1\nSO_QRY_LBQRYTYPE;1\n",
		"name_en_us": "delivered_not_invoiced",
		"_prf_name_id": "_qry_so_Toimitetut laskuttamatta",
		"name": "Toimitetut laskuttamatta",
		"table": "ord"
	},
	{
		"_prf_text_value": "SOR_QRY_CTILA;1\nSOR_QRY_CAV;1\nSOR_QRY_CTYYPPI;1\nSOR_QRY_CTI;1\nSOR_QRY_CMTTILA;1\nSOR_QRY_CMTAV;1\nSOR_QRY_CMTAL;1\nSOR_QRY_CLASKU;1\nTSRRMREILAS;1\nSOR_QRY_LBQRYTYPE;1\nSO_QRY_LBQRYTYPE;1\nPR_QRY_LBQRYTYPE;1\nSOR_QRY_CMTVA;1\n",
		"name_en_us": "open",
		"_prf_name_id": "_qry_sor_Avoimet",
		"name": "Avoimet",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cAV;1\nsor_qry_dToToAl;01.01.02\nsor_qry_dToToLo;31.12.02\nsor_qry_lbQryType;2\nso_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "open_salesorderrow_2000",
		"_prf_name_id": "_qry_sor_Avoimet myyntirivit 2000",
		"name": "Avoimet myyntirivit 2000",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cLA;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cMtLO;1\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "picking_list",
		"_prf_name_id": "_qry_sor_Keräyslista",
		"name": "Keräyslista",
		"table": "ordr"
	},
	{
		"_prf_text_value": "SOR_QRY_CAV;1\nSOR_QRY_COT;1\nSOR_QRY_CLT;1\nSOR_QRY_CTI;1\nSOR_QRY_CVM;1\nSOR_QRY_CMTAV;1\nSOR_QRY_CMTAL;1\nSOR_QRY_DTOTOAL;1.1.2004\nSOR_QRY_DTOTOLO;31.12.2004\nSOR_QRY_CLASKU;1\nTSRRMREILAS;1\nSOR_QRY_CLAHETE;1\nRSRRMRONLAH;1\nSOR_QRY_LBQRYTYPE;1\nSO_QRY_LBQRYTYPE;1\nPR_QRY_LBQRYTYPE;1\n",
		"name_en_us": "ready_for_invoicing",
		"_prf_name_id": "_qry_sor_Laskutettavat",
		"name": "Laskutettavat",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cMtLO;1\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\nsor_qry_cLasku;1\ntsrrMrEiLas;1\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\nsor_qry_tProductType;0,1,2\n",
		"name_en_us": "sent_not_invoiced",
		"_prf_name_id": "_qry_sor_Laskuttamattomat lähetetyt",
		"name": "Laskuttamattomat lähetetyt",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cMtLO;1\nsor_qry_cToToPv;1\nsor_qry_dToToAl;01.01.02\nsor_qry_dToToLo;31.12.02\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "lead_time",
		"_prf_name_id": "_qry_sor_Läpimenoaika",
		"name": "Läpimenoaika",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cAV;1\nsor_qry_cTI;1\nsor_qry_cVM;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\ntsrrMrEiLas;1\nsor_qry_cTiPvm;1\nsor_qry_dTiAlku;1.4.2011\nsor_qry_dTiLopp;1.4.2011\nsor_qry_cToimit;1\nsor_qry_sToimit;@\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "sales_per_supplier",
		"_prf_name_id": "_qry_sor_Myynti_toimittaja",
		"name": "Myynti_toimittaja",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTI;1\nsor_qry_cVM;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cTilaus;1\nsor_qry_sTiAlku;080009\ntsrrMrEiLas;1\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "undo",
		"_prf_name_id": "_qry_sor_Peru",
		"name": "Peru",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cMtLO;1\nsor_qry_cToToPv;1\nsor_qry_dToToAl;01.01.2007\nsor_qry_dToToLo;31.03.2007\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "structure_need_q1_07",
		"_prf_name_id": "_qry_sor_Rakennetarve Q1/07",
		"name": "Rakennetarve Q1/07",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_dToAlku;25.12.2008\nsor_qry_dToLopp;11.1.2009\nsor_qry_cToToPv;1\nsor_qry_dToToAl;1.1.2009\nsor_qry_dToToLo;31.1.2009\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "delivered_time_span",
		"_prf_name_id": "_qry_sor_Toimitetut aikaväliltä",
		"name": "Toimitetut aikaväliltä",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cAV;1\nsor_qry_cTI;1\nsor_qry_cVM;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\ntsrrMrEiLas;1\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\nsor_qry_tProductType;0,1,2\n",
		"name_en_us": "not_delivered",
		"_prf_name_id": "_qry_sor_Toimittamattomat",
		"name": "Toimittamattomat",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cAV;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cToPvm;1\nsor_qry_dToAlku;1.2.2014\nsor_qry_dToLopp;28.2.2014\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "delivery_list",
		"_prf_name_id": "_qry_sor_Toimituslista",
		"name": "Toimituslista",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cMtLO;1\nsor_qry_cToToPv;1\nsor_qry_dToToAl;1.1.2001\nsor_qry_dToToLo;31.12.2014\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "reliability_of_delivery",
		"_prf_name_id": "_qry_sor_Toimitusvarmuus",
		"name": "Toimitusvarmuus",
		"table": "ordr"
	},
	{
		"_prf_text_value": "SOR_QRY_COT;1\nSOR_QRY_CLT;1\nSOR_QRY_CTYYPPI;1\nSOR_QRY_CTI;1\nSOR_QRY_CMTAV;1\nSOR_QRY_CMTAL;1\nSOR_QRY_CMTLO;1\nSOR_QRY_CTOPVM;1\nSOR_QRY_DTOALKU;1.1.2006\nSOR_QRY_DTOLOPP;31.1.2006\nSOR_QRY_DTOTOAL;1.1.2003\nSOR_QRY_DTOTOLO;31.10.2003\nTSRRMREILAS;1\nSOR_QRY_LBQRYTYPE;1\nSO_QRY_LBQRYTYPE;1\nPR_QRY_LBQRYTYPE;1\n",
		"name_en_us": "reliability_of_delivery2",
		"_prf_name_id": "_qry_sor_Toimitusvarmuus2",
		"name": "Toimitusvarmuus2",
		"table": "ordr"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cAV;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cVM;1\nsor_qry_cLA;1\nsor_qry_cAH;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_dToToAl;1.1.2007\nsor_qry_dToToLo;31.3.2007\ntsrrMrEiLas;1\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtVA;1\nsor_qry_cProductionLot;1\nsor_qry_cProductType;1\nsor_qry_tProductType;0,1,2\n",
		"name_en_us": "work_order_not_done",
		"_prf_name_id": "_qry_sor_Työmääräin tekemättä",
		"name": "Työmääräin tekemättä",
		"table": "ordr"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003",
		"_prf_name_id": "_qry_vo_TK 2002-2003",
		"name": "TK 2002-2003",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0200000\nvo_qry_sVoucherNumEnd;0209999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_cash",
		"_prf_name_id": "_qry_vo_TK 2002-2003 kassa",
		"name": "TK 2002-2003 kassa",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0290000\nvo_qry_sVoucherNumEnd;0299999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_compensation_for_expenses",
		"_prf_name_id": "_qry_vo_TK 2002-2003 kulukorvaukset",
		"name": "TK 2002-2003 kulukorvaukset",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0280000\nvo_qry_sVoucherNumEnd;0289999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_invoice_payment",
		"_prf_name_id": "_qry_vo_TK 2002-2003 myyntireskontra",
		"name": "TK 2002-2003 myyntireskontra",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0270000\nvo_qry_sVoucherNumEnd;0279999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_accounts_payable",
		"_prf_name_id": "_qry_vo_TK 2002-2003 ostoreskontra",
		"name": "TK 2002-2003 ostoreskontra",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0210000\nvo_qry_sVoucherNumEnd;0219999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_bank_account",
		"_prf_name_id": "_qry_vo_TK 2002-2003 pankkitili",
		"name": "TK 2002-2003 pankkitili",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;020001\nvo_qry_sVoucherIDEnd;0299999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.4.2002\nvo_qry_dDateEnd;31.3.2003\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;1\nvo_qry_sVoucherNumStart;0260000\nvo_qry_sVoucherNumEnd;0269999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2002-2003_opening_of_account",
		"_prf_name_id": "_qry_vo_TK 2002-2003 tilin avaus ja päätös",
		"name": "TK 2002-2003 tilin avaus ja päätös",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;060001\nvo_qry_sVoucherIDEnd;0699999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.1.2005\nvo_qry_dDateEnd;31.12.2005\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_sVoucherNumStart;0260000\nvo_qry_sVoucherNumEnd;0269999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2005",
		"_prf_name_id": "_qry_vo_Tk 2005",
		"name": "Tk 2005",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;060001\nvo_qry_sVoucherIDEnd;0699999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.1.2006\nvo_qry_dDateEnd;31.12.2006\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_sVoucherNumStart;0260000\nvo_qry_sVoucherNumEnd;0269999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2006",
		"_prf_name_id": "_qry_vo_TK 2006",
		"name": "TK 2006",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;060001\nvo_qry_sVoucherIDEnd;0699999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.1.2007\nvo_qry_dDateEnd;31.12.2007\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_sVoucherNumStart;0260000\nvo_qry_sVoucherNumEnd;0269999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2007",
		"_prf_name_id": "_qry_vo_TK 2007",
		"name": "TK 2007",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;060001\nvo_qry_sVoucherIDEnd;0699999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.1.2008\nvo_qry_dDateEnd;31.8.2008\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_sVoucherNumStart;0260000\nvo_qry_sVoucherNumEnd;0269999\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "accounting_perioid_2008",
		"_prf_name_id": "_qry_vo_TK 2008",
		"name": "TK 2008",
		"table": "bkv"
	},
	{
		"_prf_text_value": "vo_qry_lcVoucherID;0\nvo_qry_sVoucherIDStart;0000001\nvo_qry_sVoucherIDEnd;0099999\nvo_qry_lcDate;1\nvo_qry_dDateStart;1.1.2006\nvo_qry_dDateEnd;31.12.2006\nvo_qry_lcType;0\nvo_qry_lcState;0\nvo_qry_lbQryType;1\nvo_qry_lcVoucherNum;0\nvo_qry_lcYear;0\nvo_qry_lYearStart;0\nvo_qry_lYearEnd;0\nvo_qry_lcMonth;0\nvo_qry_lMonthStart;0\nvo_qry_lMonthEnd;0\n",
		"name_en_us": "tkX",
		"_prf_name_id": "_qry_vo_TK?",
		"name": "TK?",
		"table": "bkv"
	},
	{
		"_prf_text_value": "wo_qry_sTyömä;as\nwo_qry_lAlVko1;0\nwo_qry_lAlVko2;0\nwo_qry_lVaVko1;200146\nwo_qry_lVaVko2;200147\nwo_qry_dVapv1;1.2.2006\nwo_qry_dVapv2;28.2.2006\nwo_qry_cTila;1\nwo_qry_cEK;1\nwo_qry_cKU;1\nwo_qry_cAL;1\nwo_qry_cTA;1\nwo_qry_sTyPiir;asd\nrsrvaOnJLas;1\nwo_qry_lbQryType;1\nw_qry_lbQryType;1\n",
		"name_en_us": "open",
		"_prf_name_id": "_qry_wo_Avoimet",
		"name": "Avoimet",
		"table": "pro"
	},
	{
		"_prf_text_value": "wo_qry_sTyömä;jhhjk\nwo_qry_lAlVko1;0\nwo_qry_lAlVko2;0\nwo_qry_cVaVko;1\nwo_qry_lVaVko1;200146\nwo_qry_lVaVko2;200147\nwo_qry_dVapv1;1.6.2003\nwo_qry_dVapv2;30.6.2003\nwo_qry_sTyPiir;asd\nrsrvaOnJLas;1\nwo_qry_lbQryType;1\nw_qry_lbQryType;1\n",
		"name_en_us": "bonus_calculation",
		"_prf_name_id": "_qry_wo_Bonuslaskenta",
		"name": "Bonuslaskenta",
		"table": "pro"
	},
	{
		"_prf_text_value": "wo_qry_sTyömä;asds\nwo_qry_lAlVko1;0\nwo_qry_lAlVko2;0\nwo_qry_lVaVko1;200146\nwo_qry_lVaVko2;200147\nwo_qry_dVapv1;1.6.2003\nwo_qry_dVapv2;30.6.2003\nwo_qry_cTila;1\nwo_qry_cLT;1\nwo_qry_sTyPiir;asdasas\nrsrvaOnJLas;1\nwo_qry_lbQryType;1\nw_qry_lbQryType;1\n",
		"name_en_us": "finished",
		"_prf_name_id": "_qry_wo_Lopetetut",
		"name": "Lopetetut",
		"table": "pro"
	},
	{
		"_prf_text_value": "wo_qry_sTyömä;as333\nwo_qry_lAlVko1;0\nwo_qry_lAlVko2;0\nwo_qry_lVaVko1;200146\nwo_qry_lVaVko2;200147\nwo_qry_dVapv1;1.2.2006\nwo_qry_dVapv2;28.2.2006\nwo_qry_cTila;1\nwo_qry_cPE;1\nwo_qry_sTyPiir;asd\nrsrvaOnJLas;1\nwo_qry_lbQryType;1\nw_qry_lbQryType;1\n",
		"name_en_us": "canceled",
		"_prf_name_id": "_qry_wo_Perutut",
		"name": "Perutut",
		"table": "pro"
	},
	{
		"_prf_text_value": "WO_QRY_LVAVKO1;200146\nWO_QRY_LVAVKO2;200147\nWO_QRY_DVAPV1;1.2.2006\nWO_QRY_DVAPV2;28.2.2006\nWO_QRY_CTILA;1\nRSRVAONJLAS;1\nWO_QRY_LBQRYTYPE;1\nW_QRY_LBQRYTYPE;1\nWO_QRY_CPY;1\n",
		"name_en_us": "stopped",
		"_prf_name_id": "_qry_wo_Pysäytetyt",
		"name": "Pysäytetyt",
		"table": "pro"
	},
	{
		"_prf_text_value": "WO_QRY_LVAVKO1;200146\nWO_QRY_LVAVKO2;200147\nWO_QRY_CTILA;1\nWO_QRY_CKU;1\nWO_QRY_CAL;1\nRSRVAONJLAS;1\nWO_QRY_LBQRYTYPE;1\nW_QRY_LBQRYTYPE;1\n",
		"name_en_us": "do_completed",
		"_prf_name_id": "_qry_wo_Tee toteutuneet",
		"name": "Tee toteutuneet",
		"table": "pro"
	},
	{
		"_prf_text_value": "wo_qry_lAlVko1;0\nwo_qry_lAlVko2;0\nwo_qry_lVaVko1;200146\nwo_qry_lVaVko2;200147\nwo_qry_cVapv;1\nwo_qry_dVapv1;28.11.1990\nwo_qry_dVapv2;28.11.2014\nwo_qry_cJLas;1\nrsrvaOnJLas;1\nwo_qry_lbQryType;1\nw_qry_lbQryType;1\n",
		"name_en_us": "production_sales_report",
		"_prf_name_id": "_qry_wo_Tuotannon myyntiraportti",
		"name": "Tuotannon myyntiraportti",
		"table": "pro"
	},
	{
		"_prf_text_value": "_err MESSAGE@\n__test_exe\nALERT@\nBEEP\nwo_WHOLE_STRUCTURE_FIND@\nwo_LOWER_STRUCTURE_FIND@\npr_ @\n_lnk_ @\nso_HAE@\nsor_HAE@\npo_HAE@\npor_HAE@\n_ord@\n_qry@\n_sel RELATE@\n_sel ALL_RECS@\n_sel SELECTED_NOT@\n_sel SEL_TO_ARR@\n_sel_ SEL_TO_ARR@\n_rel AUTOMATIC_ONE@\n_set@\n_txt@\n_str@\n_real@\n_long@\n_date@\n_time@\n_bool@\n_ptr:=@\n_ptr2:=@\n_at@\n_al@\nIf@\nElse@\nEnd @\nFOR@\nCase of\nCOMPILER@\n\n//@\n`@\n_info_@\n_firm @\nzz_@\nARRAY @\nC_@\nxapp TblRun@\n_el RUN@\nwo_ @\nstpa_ @\n_fo SEL_USE@\n$@\nwos_ OPEN_QRY@\n_prf_ JSON@\n",
		"execute": true,
		"_prf_name_id": "_qry_exe_LegalCommands"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!`!01.01.90!\n_date2:=_date Current (kTrue )+7\n_info_ TIME_PERIOD_ASK (\"Toimituspäivä-väli:\";_date;_date2)\nIf (OK=1)\n  _info_ TIME_PERIOD_DATES_GET (->_date;->_date2)\n  sor_HAE AVOIMET (False)\n  _qry Fld (0;sor_kConfirmed_Delivery_Date ;\">=\";->_date;\"*\";kTrue )\n  _qry Fld (0;sor_kConfirmed_Delivery_Date ;\"<=\";->_date2;\"&\";kTrue )\n  _firm SEL_REDUCE (sor_kTbl )\n  _sel RELATE ONE SELECTION (sor_kSales_Order_id ;so_kSales_Order_ID )\nEnd if ",
		"execute": true,
		"name_en_us": "_exe_Toimittamatta_vahv_pv",
		"name": "Toimittamatta_vahv_pv",
		"_prf_name_id": "_qry_exe_so_Toimittamatta_vahv_pv",
		"table": "ord"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wlg_kState;\"=\";->_long;\"*\";kFalse )  \n_long:=1\n_qry Fld (0;wlg_kType_;\"=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Aktiiviset_solut",
		"name": "Aktiiviset_solut",
		"_prf_name_id": "_qry_exe_wlg_Aktiiviset_solut",
		"table": "res"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!`!01.01.90!\n_date2:=_date Current (kTrue )+7\n_info_ TIME_PERIOD_ASK (\"Toimituspäivä-väli:\";_date;_date2)\nIf (OK=1)\n  _info_ TIME_PERIOD_DATES_GET (->_date;->_date2)\n  sor_HAE AVOIMET (False)\n  _qry Fld (0;sor_kConfirmed_Delivery_Date ;\">=\";->_date;\"*\";kTrue )\n  _qry Fld (0;sor_kConfirmed_Delivery_Date ;\"<=\";->_date2;\"&\";kTrue )\n  _firm SEL_REDUCE (sor_kTbl )\nEnd if ",
		"execute": true,
		"name_en_us": "_exe_Toimittamatta_vahv_pv",
		"name": "Toimittamatta_vahv_pv",
		"_prf_name_id": "_qry_exe_sor_Toimittamatta_vahv_pv",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!`!01.01.90!\n_date2:=_date Current (kTrue )+7\n_info_ TIME_PERIOD_ASK (\"Toimituspäivä-väli:\";_date;_date2)\nIf (OK=1)\n  _info_ TIME_PERIOD_DATES_GET (->_date;->_date2)\n  sor_HAE AVOIMET (False)\n  _qry Fld (0;sor_kDelivered_Date ;\">=\";->_date;\"*\";kTrue )\n  _qry Fld (0;sor_kDelivered_Date ;\"<=\";->_date2;\"&\";kTrue )\n  _firm SEL_REDUCE (sor_kTbl )\nEnd if ",
		"execute": true,
		"name_en_us": "_exe_Toimittamatta_pv",
		"name": "Toimittamatta_pv",
		"_prf_name_id": "_qry_exe_sor_Toimittamatta_pv",
		"table": "ordr"
	},
	{
		"_prf_text_value": "C_POINTER(_ptr;_ptr2)\nARRAY TEXT(_atArr;0)\nARRAY TEXT(_atArr2;0)\n\nxapp TblRun (kInit ;por_kTbl ;kNoEvent )\n_txt:=\"\"\n_qry Fld (0;por_kProduction_Lot ;\"#\";->_txt;\"\";kFalse )\npor_HAE AVOIMET (True;2)\n_ptr:=_fld PtrToFldNumArr (por_kProduction_Lot ;por_kConfirmed_Arrival_Date ;por_kRecord_ID )\n_ptr2:=_fld PtrToFldArr2 (_ptr)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\nxapp TblRun (kInit ;wo_kTbl ;kNoEvent )\n_qry ARRAY (wo_kProduction_Lot ;->por_asProduction_Lot)\n_ptr:=_fld PtrToFldNumArr (wo_kProduction_Lot ;wo_kSales_Order_id ;wo_kSales_Order_Row_id )\n_ptr2:=_fld PtrToFldArr2 (_ptr)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\n_qry ARRAY (sor_kSales_Order_id ;->wo_asSales_Order_id)\nsor_HAE AVOIMET (True)\n_ptr:=_fld PtrToFldNumArr (sor_kSales_Order_id ;sor_kRow_Number ;sor_kDelivered_Date ;sor_kRecord_ID )\n_ptr2:=_fld PtrToFldArr2 (_ptr)  `_ptr2:=_arr PtrToTmpArr (->_atArr;->_alArr;->_adArr;->_atArr2)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\n_long2:=Size of array(wo_asProduction_Lot)\nARRAY TEXT(_atArr;_long2)  `sor_ record id -array\nARRAY TEXT(_atArr2;_long2)  `sor_ record id -array\n_long5:=0\nFor (_long;1;_long2)\n  _long3:=Find in array(por_asProduction_Lot;wo_asProduction_Lot{_long})\n  If (_long3>0)\n    _txt:=wo_asSales_Order_id{_long}\n    _long4:=wo_alSales_Order_Row_id{_long}\n    _long4:=_arr InTwoFind (->sor_asSales_Order_id;->_txt;->sor_alRow_Number;->_long4;1)\n    If (_long4>0)  `sor found\n      If (sor_adDelivered_Date{_long4}<por_adConfirmed_Arrival_Date{_long3})  `check if sor_ date is smaller than por_ date\n        _long5:=_long5+1\n        _atArr{_long5}:=sor_atRecord_ID{_long4}  `add sor record id to arr\n        _atArr2{_long5}:=por_atRecord_ID{_long3}  `add sor record id to arr\n      End if \n    End if \n  End if \nEnd for \nARRAY TEXT(_atArr;_long5)\n_qry ARRAY (sor_kRecord_ID ;->_atArr)\n\nIf (Size of array(_atArr2)>0)\n  _qry ARRAY (por_kRecord_ID ;->_atArr2)\n  _set CREATE (por_kTbl ;\"<>por_TooLateSet\")\n  _el RUN (_el_kmOutput ;por_kTbl ;Into set ;\"<>por_TooLateSet\";kFalse ;_el_kmOutput ;0)\nEnd if \n\nARRAY TEXT(_atArr;0)\nARRAY TEXT(_atArr2;0)\n",
		"execute": true,
		"name_en_us": "_exe_AH-myöhässä",
		"name": "AH-myöhässä",
		"_prf_name_id": "_qry_exe_sor_AH-myöhässä",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_fo SEL_USE (Into current selection;\"\")\n\nwo_WHOLE_STRUCTURE_FIND\n\n_long:=_fo_ SpecialOrderFld (kSet;wo_kParent_Production_Lot)",
		"execute": true,
		"name_en_us": "_exe_SelectedSameStructure",
		"name": "SelectedSameStructure",
		"_prf_name_id": "_qry_exe_wo_SelectedSameStructure",
		"table": "pro"
	},
	{
		"_prf_text_value": "C_POINTER(_ptr;_ptr2)\nARRAY TEXT(_atArr;0)\nARRAY TEXT(_atArr2;0)\n\nxapp TblRun (kInit ;por_kTbl ;kNoEvent )\n_txt:=\"\"\n_qry Fld (0;por_kProduction_Lot ;\"#\";->_txt;\"\";kFalse )\npor_HAE AVOIMET (True;2)\n_ptr:=_fld PtrToFldNumArr (por_kProduction_Lot ;por_kConfirmed_Arrival_Date ;por_kRecord_ID )\n_ptr2:=_fld PtrToFldArr2 (_ptr)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\nxapp TblRun (kInit ;wo_kTbl ;kNoEvent )\n_qry ARRAY (wo_kProduction_Lot ;->por_asProduction_Lot)\n_ptr:=_fld PtrToFldNumArr (wo_kProduction_Lot ;wo_kSales_Order_id ;wo_kSales_Order_Row_id )\n_ptr2:=_fld PtrToFldArr2 (_ptr)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\n_qry ARRAY (sor_kSales_Order_id ;->wo_asSales_Order_id)\nsor_HAE AVOIMET (True)\n_ptr:=_fld PtrToFldNumArr (sor_kSales_Order_id ;sor_kRow_Number ;sor_kConfirmed_Delivery_Date ;sor_kRecord_ID )\n_ptr2:=_fld PtrToFldArr2 (_ptr)  `_ptr2:=_arr PtrToTmpArr (->_atArr;->_alArr;->_adArr;->_atArr2)\n_sel SEL_TO_ARR (_ptr;_ptr2)\n\n_long2:=Size of array(wo_asProduction_Lot)\nARRAY TEXT(_atArr;_long2)  `sor_ record id -array\nARRAY TEXT(_atArr2;_long2)  `sor_ record id -array\n_long5:=0\nFor (_long;1;_long2)\n  _long3:=Find in array(por_asProduction_Lot;wo_asProduction_Lot{_long})\n  If (_long3>0)\n    _txt:=wo_asSales_Order_id{_long}\n    _long4:=wo_alSales_Order_Row_id{_long}\n    _long4:=_arr InTwoFind (->sor_asSales_Order_id;->_txt;->sor_alRow_Number;->_long4;1)\n    If (_long4>0)  `sor found\n      If (sor_adConfirmed_Delivery_Date{_long4}<por_adConfirmed_Arrival_Date{_long3})  `check if sor_ date is smaller than por_ date\n        _long5:=_long5+1\n        _atArr{_long5}:=sor_atRecord_ID{_long4}  `add sor record id to arr\n        _atArr2{_long5}:=por_atRecord_ID{_long3}  `add sor record id to arr\n      End if \n    End if \n  End if \nEnd for \nARRAY TEXT(_atArr;_long5)\n_qry ARRAY (sor_kRecord_ID ;->_atArr)\n\nIf (Size of array(_atArr2)>0)\n  _qry ARRAY (por_kRecord_ID ;->_atArr2)\n  _set CREATE (por_kTbl ;\"<>por_TooLateSet\")\n  _el RUN (_el_kmOutput ;por_kTbl ;Into set ;\"<>por_TooLateSet\";kFalse ;_el_kmOutput ;0)\nEnd if \n\nARRAY TEXT(_atArr;0)\nARRAY TEXT(_atArr2;0)\n",
		"execute": true,
		"name_en_us": "_exe_AH-myöhässä_vahvistuspv",
		"name": "AH-myöhässä_vahvistuspv",
		"_prf_name_id": "_qry_exe_sor_AH-myöhässä_vahvistuspv",
		"table": "ordr"
	},
	{
		"_prf_text_value": "PR_QRY_STUOTER;POS\nPR_QRY_SALARYH;SBK\nPR_QRY_CVARSTO;1\nRSRTUVARST1;1\nPR_QRY_CEIKAYT;1\nUSRTUEIKAY1;1\nAPPA_RTUHALRA1;1\nPR_QRY_CPAATOI;1\nPR_QRY_SPAATOI;@\nPR_QRY_COSTOKO;1\nPR_QRY_SOSTOKO;0\nPR_QRY_LBQRYTYPE;1\n",
		"name_en_us": "stock_values",
		"_prf_name_id": "_qry_pr_StockValues",
		"name": "StockValues",
		"table": "pr"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!\n_date2:=_date Current (kTrue)\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"#\";->_date;\"*\";kTrue;kFalse )\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"<=\";->_date2;\"&\";kTrue;kFalse )\n_set CREATE(por_kTbl;\"por_LateSetTmp1\")\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"=\";->_date;\"*\";kTrue;kFalse  )\n_qry Fld (0;por_kRequested_Delivery_Date;\"<=\";->_date2;\"&\";kTrue;kFalse  )\n_set CREATE(por_kTbl;\"por_LateSetTmp2\")\n_set UNION(por_kTbl;\"por_LateSetTmp1\";\"por_LateSetTmp2\";\"por_LateSetTmp1\")\n\n_set USE(por_kTbl;\"por_LateSetTmp1\")\n\n_firm SEL_REDUCE (por_kTbl )\nIf (_set RecsInSet(por_kTbl;\"por_LateSetTmp1\")>0)\n  _long:=_fo_ SpecialOrderFld (kSet;-por_kConfirmed_Arrival_Date)\nElse\n  _long:=_fo_ SpecialOrderFld (kSet;-por_kRequested_Delivery_Date)\nEnd if\n\n_set CLEAR(por_kTbl;\"por_LateSetTmp1\")\n_set CLEAR(por_kTbl;\"por_LateSetTmp2\")",
		"execute": true,
		"name_en_us": "_exe_Late",
		"name": "Late",
		"_prf_name_id": "_qry_exe_por_Late",
		"table": "ordr"
	},
	{
		"_prf_text_value": "wo_ OPEN_QRY (kFalse)\n_txt:=ld_kStateStarted\n_qry Fld (0;wo_kState;\"#\";->_txt;\"\";kTrue;kFalse)\n\n_long:=_fo_ SpecialOrderFld (kSet;wo_kStart_Date)",
		"execute": true,
		"name_en_us": "_exe_NotStartedPriority",
		"name": "NotStartedPriority",
		"_prf_name_id": "_qry_exe_wo_NotStartedPriority",
		"table": "pro"
	},
	{
		"_prf_text_value": "_date:=!00.00.00!\n_date2:=_date Current (kTrue)\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"#\";->_date;\"*\";kTrue )\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"<=\";->_date2;\"&\";kTrue )\n_set CREATE(por_kTbl;\"por_LateSetTmp1\")\n\npor_HAE AVOIMET (False;0)\n_qry Fld (0;por_kConfirmed_Arrival_Date;\"=\";->_date;\"*\";kTrue )\n_qry Fld (0;por_kRequested_Delivery_Date;\"<=\";->_date2;\"&\";kTrue )\n_set CREATE(por_kTbl;\"por_LateSetTmp2\")\n\n_set UNION(por_kTbl;\"por_LateSetTmp1\";\"por_LateSetTmp2\";\"por_LateSetTmp1\")\n_set USE(por_kTbl;\"por_LateSetTmp1\")\n\n_sel RELATE ONE SELECTION(por_kPurchase_Order_id;po_kPurchase_Order_id)\n_firm SEL_REDUCE (po_kTbl )\n\n_set CLEAR(por_kTbl;\"por_LateSetTmp1\")\n_set CLEAR(por_kTbl;\"por_LateSetTmp2\")",
		"execute": true,
		"name_en_us": "_exe_Late",
		"name": "Late",
		"_prf_name_id": "_qry_exe_po_Late",
		"table": "ord"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Työsuhde_voimassa",
		"name": "Työsuhde_voimassa",
		"_prf_name_id": "_qry_exe_em_Työsuhde_voimassa",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=1\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Irtisanoutunut",
		"name": "Irtisanoutunut",
		"_prf_name_id": "_qry_exe_em_Irtisanoutunut",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=2\n_qry Fld (0;em_kState_ ;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Irtisanottu_henk_koht_syistä",
		"name": "Irtisanottu_henk_koht_syistä",
		"_prf_name_id": "_qry_exe_em_Irtisanottu_henk_koht_syistä",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=6\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Irtisanottu_tuot_ja_tal_syistä",
		"name": "Irtisanottu_tuot_ja_tal_syistä",
		"_prf_name_id": "_qry_exe_em_Irtisanottu_tuot_ja_tal_syistä",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=3\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Työsuhde_purettu",
		"name": "Työsuhde_purettu",
		"_prf_name_id": "_qry_exe_em_Työsuhde_purettu",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=4\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Eläkkeellä",
		"name": "Eläkkeellä",
		"_prf_name_id": "_qry_exe_em_Eläkkeellä",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=5\n_qry Fld (0;em_kState_;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Päättynyt_tuntematon_syy",
		"name": "Päättynyt_tuntematon_syy",
		"_prf_name_id": "_qry_exe_em_Päättynyt_tuntematon_syy",
		"table": "per"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wlg_kState;\"=\";->_long;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Aktiiviset",
		"name": "Aktiiviset",
		"_prf_name_id": "_qry_exe_wlg_Aktiiviset",
		"table": "res"
	},
	{
		"_prf_text_value": "_sel ALL_RECS(wlg_kTbl)",
		"execute": true,
		"name_en_us": "_exe_Kaikki",
		"name": "Kaikki",
		"_prf_name_id": "_qry_exe_wlg_Kaikki",
		"table": "res"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wlg_kState;\"=\";->_long;\"*\";kFalse )  \n_long:=0\n_qry Fld (0;wlg_kType_;\"=\";->_long;\"&*\";kFalse )  \n_bool:=False\n_qry Fld (0;wlg_kSubcontract;\"=\";->_bool;\"&*\";kFalse )  \n_txt:=\"RAAKA_AINE\"\n_qry Fld (0;wlg_kWork_Load_Group_ID;\"#\";->_txt;\"&\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Aktiiviset_omat",
		"name": "Aktiiviset_omat",
		"_prf_name_id": "_qry_exe_wlg_Aktiiviset_omat",
		"table": "res"
	},
	{
		"_prf_text_value": "_bool:=True\n_qry Fld (0;wlg_kSubcontract;\"=\";->_bool;\"\";kFalse )  ",
		"execute": true,
		"name_en_us": "_exe_Alihankinnat",
		"name": "Alihankinnat",
		"_prf_name_id": "_qry_exe_wlg_Alihankinnat",
		"table": "res"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wlg_kState;\"<\";->_long;\"\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Ei_aktiiviset",
		"name": "Ei_aktiiviset",
		"_prf_name_id": "_qry_exe_wlg_Ei_aktiiviset",
		"table": "res"
	},
	{
		"_prf_text_value": "_txt:=\"LT\"\n_qry Fld(wpa_kTbl;wo_kState;\"#\";->_txt;\"\";kFalse)",
		"execute": true,
		"name_en_us": "_exe_Open",
		"name": "Open",
		"_prf_name_id": "_qry_exe_wpa_Open",
		"table": "prwo"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wcap_kType_ ;\"=\";->_long;\"*\";kFalse )\n_long:=0\n_qry Fld (0;wcap_kState ;\">=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Yleinen",
		"name": "Yleinen",
		"_prf_name_id": "_qry_exe_wcap_Yleinen",
		"table": "cap"
	},
	{
		"_prf_text_value": "_long:=1\n_qry Fld (0;wcap_kType_ ;\"=\";->_long;\"*\";kFalse )\n_long:=0\n_qry Fld (0;wcap_kState ;\">=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Vuoro",
		"name": "Vuoro",
		"_prf_name_id": "_qry_exe_wcap_Vuoro",
		"table": "cap"
	},
	{
		"_prf_text_value": "_long:=2\n_qry Fld (0;wcap_kType_ ;\"=\";->_long;\"*\";kFalse )\n_long:=0\n_qry Fld (0;wcap_kState ;\">=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Vuororaja",
		"name": "Vuororaja",
		"_prf_name_id": "_qry_exe_wcap_Vuororaja",
		"table": "cap"
	},
	{
		"_prf_text_value": "_long:=3\n_qry Fld (0;wcap_kType_ ;\"=\";->_long;\"*\";kFalse )\n_long:=0\n_qry Fld (0;wcap_kState ;\">=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Työntekijä",
		"name": "Työntekijä",
		"_prf_name_id": "_qry_exe_wcap_Työntekijä",
		"table": "cap"
	},
	{
		"_prf_text_value": "_long:=4\n_qry Fld (0;wcap_kType_ ;\"=\";->_long;\"*\";kFalse )\n_long:=0\n_qry Fld (0;wcap_kState ;\">=\";->_long;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Kuormitusryhmä",
		"name": "Kuormitusryhmä",
		"_prf_name_id": "_qry_exe_wcap_Kuormitusryhmä",
		"table": "cap"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;wcap_kState ;\"<\";->_long;\"\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_Ei käytössä",
		"name": "Ei käytössä",
		"_prf_name_id": "_qry_exe_wcap_Ei käytössä",
		"table": "cap"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cAV;1\nsor_qry_cTyyppi;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cVM;1\nsor_qry_cLA;1\nsor_qry_cAH;1\nsor_qry_cMtTila;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cToPvm;1\nsor_qry_dToAlku;1.12.2014\nsor_qry_dToLopp;31.12.2014\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "order_book",
		"_prf_name_id": "_qry_sor_Tilauskanta",
		"name": "Tilauskanta",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld(0;in_kSend_State;\"=\";->_txt;\"*\";kFalse)\n_long:=0\n_qry Fld (0;in_kState ;\"<=\";->_long;\"&*\";kFalse )\n_date:=_date Current(kTrue)-5000\n_qry Fld (0;in_kDate_ ;\">=\";->_date;\"&\";kFalse )",
		"execute": true,
		"name_en_us": "_exe_MaestroOpenNotSent",
		"name": "MaestroOpenNotSent",
		"_prf_name_id": "_qry_exe_in_MaestroOpenNotSent",
		"table": "in"
	},
	{
		"_prf_text_value": "sor_HAE AVOIMET (False)\n_sel RELATE ONE SELECTION (sor_kProduct_id;pr_kProduct_ID)\npr_ TREE_QRY (pr_kTbl;2;kAll)\n_sel RELATE MANY SELECTION (w_kProduct_id)\n_sel RELATE MANY SELECTION (wpe_kWork__Position_Num_id)\n\n_qry_ FLD_TXT_RANGE (wpe_kWork_Load_Group_id;\"BW@,Daewoo\";kTrue)\n\n_sel RELATE ONE SELECTION (wpe_kWork__Position_Num_id;w_kWork__Position_Num_id)\n_sel RELATE ONE SELECTION (w_kProduct_id;pr_kProduct_ID)\n_sel RELATE MANY SELECTION (sor_kProduct_id)\nsor_HAE AVOIMET (True)\n_firm SEL_REDUCE (sor_kTbl)",
		"execute": true,
		"name_en_us": "_exe_OpenLoadgroup_BW,Daewoo",
		"name": "OpenLoadgroup_BW,Daewoo",
		"_prf_name_id": "_qry_exe_sor_OpenLoadgroup_BW,Daewoo",
		"table": "ordr"
	},
	{
		"_prf_text_value": "COMPILER_xapp_constant \nwo_ OPEN_QRY (kFalse)\n_txt:=ld_kStateLoaded\n_qry Fld (0;wo_kState;\"=\";->_txt;\"*\";kTrue;kFalse)\n_txt:=\"\"\n_qry Fld (0;wo_kWork_Order_ID;\"=\";->_txt;\"&\";kTrue;kFalse)\n_sel RELATE MANY SELECTION (wos_kProduction_Lot)\n\n_long:=_fo_ SpecialOrderFld (kSet;wos_kPhase_Critical_Start_Date)\n",
		"execute": true,
		"name_en_us": "_exe_OpenNotPrinted",
		"name": "OpenNotPrinted",
		"_prf_name_id": "_qry_exe_wos_OpenNotPrinted",
		"table": "prwo"
	},
	{
		"_prf_text_value": "COMPILER_xapp_constant \nwo_ OPEN_QRY (kFalse)\n_txt:=ld_kStateLoaded\n_qry Fld (0;wo_kState;\"=\";->_txt;\"*\";kTrue;kFalse)\n_txt:=\"\"\n_qry Fld (0;wo_kWork_Order_ID;\"=\";->_txt;\"&\";kTrue;kFalse)\n_sel RELATE MANY SELECTION (wos_kProduction_Lot)\n_txt:=\"UC\"\n_qry Fld (0;wos_kWork_Load_Group_id;\"=\";->_txt;\"\";kTrue;kFalse)\n\n_long:=_fo_ SpecialOrderFld (kSet;wos_kPhase_Critical_Start_Date)\n",
		"execute": true,
		"name_en_us": "_exe_OpenNotPrinted-UC",
		"name": "OpenNotPrinted-UC",
		"_prf_name_id": "_qry_exe_wos_OpenNotPrinted-UC",
		"table": "prwo"
	},
	{
		"_prf_text_value": "COMPILER_xapp_constant \nwo_ OPEN_QRY (kFalse)\n_txt:=ld_kStateLoaded\n_qry Fld (0;wo_kState;\"=\";->_txt;\"*\";kTrue;kFalse)\n_txt:=\"\"\n_qry Fld (0;wo_kWork_Order_ID;\"=\";->_txt;\"&\";kTrue;kFalse)\n_sel RELATE MANY SELECTION (wos_kProduction_Lot)\n_long:=1\n_qry Fld (0;wos_kWork_Phase;\"=\";->_long;\"\";kTrue;kFalse)\n\n_long:=_fo_ SpecialOrderFld (kSet;wos_kPhase_Critical_Start_Date)",
		"execute": true,
		"name_en_us": "_exe_OpenNotPrinted-vaihe1",
		"name": "OpenNotPrinted-vaihe1",
		"_prf_name_id": "_qry_exe_wos_OpenNotPrinted-vaihe1",
		"table": "prwo"
	},
	{
		"_prf_text_value": "C_LONGINT($$stpa_lUseSelection)\nc_text($stpa_tTypePallet)\n$stpa_lUseSelection:=kFalse\nCOMPILER_stpa\nIf ($stpa_lUseSelection=kFalse)\n$stpa_tTypePallet:=stpa_kTypePallet\n_qry Fld (0;stpa_kType_;\"=\";->$stpa_tTypePallet;\"\";kFalse;kFalse)\nEnd if \n\nsor_HAE AVOIMET (False)\nARRAY TEXT($stpa_atSorSalesOrder;0)\nARRAY LONGINT($stpa_alSorRow;0)\nARRAY LONGINT($stpa_alSorPartialRow;0)\n_sel_ SEL_TO_ARR_THREE (sor_kSales_Order_id;->$stpa_atSorSalesOrder;sor_kRow_Number;->$stpa_alSorRow;sor_kPartial_Delivery_Number;->$stpa_alSorPartialRow)\n\n  // generate sales ordewr-row array\n  // same as variable: sor_pll_sSalesOrder\n$stpa_lArrSize:=Size of array($stpa_atSorSalesOrder)\nFor ($stpa_lIndex;1;$stpa_lArrSize)\nIf ($stpa_alSorPartialRow{$stpa_lIndex}=0)\n$stpa_alSorPartialRow{$stpa_lIndex}:=1\nEnd if \n$stpa_atSorSalesOrder{$stpa_lIndex}:=$stpa_atSorSalesOrder{$stpa_lIndex}+\"/\"+String($stpa_alSorRow{$stpa_lIndex};\"###000\")+\".\"+String($stpa_alSorPartialRow{$stpa_lIndex})\nEnd for \n\n\nARRAY TEXT($stpa_atSalesOrderRow;0)\nARRAY TEXT($stpa_atRecordId;0)\n_sel_ SEL_TO_ARR_TWO (stpa_kOrder_Row;->$stpa_atSalesOrderRow;stpa_kRecord_ID;->$stpa_atRecordId)\n\n$stpa_lArrSize:=Size of array($stpa_atSalesOrderRow)\nARRAY TEXT($stpa_atRecordIdSelected;$stpa_lArrSize)\n$stpa_lSelectedIndex:=0\nFor ($stpa_lIndex;1;$stpa_lArrSize)\nIf (($stpa_atSalesOrderRow{$stpa_lIndex}=\"\") | (Find in array($stpa_atSorSalesOrder;$stpa_atSalesOrderRow{$stpa_lIndex})>0))\n$stpa_lSelectedIndex:=$stpa_lSelectedIndex+1\n$stpa_atRecordIdSelected{$stpa_lSelectedIndex}:=$stpa_atRecordId{$stpa_lIndex}\nEnd if \nEnd for \nARRAY TEXT($stpa_atRecordIdSelected;$stpa_lSelectedIndex)\n_qry ARRAY (stpa_kRecord_ID;->$stpa_atRecordIdSelected)\n\n",
		"execute": true,
		"name_en_us": "_exe_NotDeliveredPallets",
		"name": "NotDeliveredPallets",
		"_prf_name_id": "_qry_exe_stpa_NotDeliveredPallets",
		"table": "st"
	},
	{
		"_prf_text_value": "_long:=0\n_qry Fld (0;em_kState_;\">=\";->_long;\"\";kTrue)\n",
		"execute": true,
		"name_en_us": "_exe_LinkFilter",
		"name": "LinkFilter",
		"_prf_name_id": "_qry_exe_em_LinkFilter",
		"table": "per"
	},
	{
		"_prf_text_value": "wo_ OPEN_QRY (kFalse)\n_txt:=\"\"\n_qry Fld (0;wo_kWork_Order_ID;\"=\";->_txt;\"*\";kTrue;kFalse)\n_txt:=\"05@\"\n_qry Fld (0;wo_kProduction_Lot;\"#\";->_txt;\"&\";kTrue;kFalse)",
		"execute": true,
		"name_en_us": "_exe_NotPrinted",
		"name": "NotPrinted",
		"_prf_name_id": "_qry_exe_wo_NotPrinted",
		"table": "pro"
	},
	{
		"_prf_text_value": "wos_ OPEN_QRY (kTrue)\n\nARRAY TEXT(_atArr;0)\n_txt:=\"wo_Bysoft.json\"\n_prf_ JSON_NAME_INIT (_txt;kTrue)\n_prf_ JSON (_txt;\"SendLoadgroup\";->_atArr)\n_prf_ JSON_CLEAR (_txt)\n\n_qry ARRAY (wos_kWork_Load_Group_id;->_atArr;kTrue)\n_sel RELATE ONE SELECTION(wos_kProduction_Lot;wo_kProduction_Lot)\n\n_txt:=\"@bysoft@\"\n_qry Fld (0;wo_kTransfer_Info;\"#\";->_txt;\"\";kTrue;kFalse)",
		"execute": true,
		"name_en_us": "_exe_SendToBysoft",
		"name": "SendToBysoft",
		"_prf_name_id": "_qry_exe_wo_SendToBysoft",
		"table": "pro"
	},
	{
		"_prf_text_value": "_fo SEL_USE (Into current selection;\"\")\n\nwo_ OPEN_QRY (kTrue)\n\n_txt:=_fld Name4DLong (wo_kProduction_Lot)+\"=\"+_fld Name4DLong (wo_kParent_Production_Lot)\n_long:=_qry_ Formula (wo_kTbl;_txt;kTrue)\n_set CREATE (wo_kTbl;\"$wo_MainLevelQuerySet1\")\n\n_fo SEL_USE (Into current selection;\"\")\n_txt:=\"\"\n_qry Fld (0;wo_kParent_Production_Lot;\"=\";->_txt;\"\";kTrue)\n_set CREATE (wo_kTbl;\"$wo_MainLevelQuerySet2\")\n\n_set UNION (wo_kTbl;\"$wo_MainLevelQuerySet1\";\"$wo_MainLevelQuerySet2\";\"$wo_MainLevelQuerySet1\")\n_set USE (wo_kTbl;\"$wo_MainLevelQuerySet1\")\n\n_set CLEAR (wo_kTbl;\"$wo_MainLevelQuerySet1\")\n_set CLEAR (wo_kTbl;\"$wo_MainLevelQuerySet2\")",
		"execute": true,
		"name_en_us": "_exe_MainLevel",
		"name": "MainLevel",
		"_prf_name_id": "_qry_exe_wo_MainLevel",
		"table": "pro"
	},
	{
		"_prf_text_value": "sor_qry_cTila;1\nsor_qry_cOT;1\nsor_qry_cLT;1\nsor_qry_cTI;1\nsor_qry_cTT;1\nsor_qry_cVM;1\nsor_qry_cLA;1\nsor_qry_cAH;1\nsor_qry_cMtAV;1\nsor_qry_cMtAL;1\nsor_qry_cToPvm;1\nsor_qry_dToAlku;1.12.2014\nsor_qry_dToLopp;31.12.2014\nsor_qry_dToToAl;1.1.2004\nsor_qry_dToToLo;31.12.2004\nsor_qry_lbQryType;1\nso_qry_lbQryType;1\npr_qry_lbQryType;1\nsor_qry_cMtEV;1\nsor_qry_cMtVA;1\n",
		"name_en_us": "deliveries",
		"_prf_name_id": "_qry_sor_Toimitukset",
		"name": "Toimitukset",
		"table": "ordr"
	},
	{
		"_prf_text_value": "_fo SEL_USE (Into current selection;\"\")\n\nwo_LOWER_STRUCTURE_FIND\n\n_long:=_fo_ SpecialOrderFld (kSet;wo_kParent_Production_Lot)",
		"execute": true,
		"name_en_us": "_exe_SelectedSameStructureLower",
		"name": "SelectedSameStructureLower",
		"_prf_name_id": "_qry_exe_wo_SelectedSameStructureLower",
		"table": "pro"
	},
	{
		"_prf_text_value": "so_HAE AVOIMET(False)\n_txt:=\"TI\"\n_qry Fld (0;so_kType_;\">=\";->_txt;\"*\";kTrue;kFalse)\n_date:=!1.8.2014!\n_qry Fld (0;so_kOrder_Date;\">=\";->_date;\"&*\";kTrue;kFalse)\n_txt:=\"\"\n_qry Fld (0;so_kTransfer_id;\"=\";->_txt;\"&\";kTrue;kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_SendToItella",
		"name": "SendToItella",
		"_prf_name_id": "_qry_exe_so_SendToItella",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_HAE AVOIMET(False)\n_date:=!1.8.2014!\n_qry Fld (0;po_kOrder_Date;\">=\";->_date;\"*\";kTrue;kFalse)\n_txt:=\"\"\n_qry Fld (0;po_kTransfer_id;\"=\";->_txt;\"&\";kTrue;kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_SendToItella",
		"name": "SendToItella",
		"_prf_name_id": "_qry_exe_po_SendToItella",
		"table": "ord"
	},
	{
		"_prf_text_value": "so_HAE AVOIMET(False)\n_txt:=\"\"\n_qry Fld (0;so_kTransfer_id;\"#\";->_txt;\"\";kTrue;kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_SentToItellaOpen",
		"name": "SentToItellaOpen",
		"_prf_name_id": "_qry_exe_so_SentToItellaOpen",
		"table": "ord"
	},
	{
		"_prf_text_value": "por_qry_cTila;1\npor_qry_cOT;1\npor_qry_cLT;1\npor_qry_cTAV;1\npor_qry_cTTI;1\npor_qry_cTTO;1\npor_qry_cOTT;1\npor_qry_cTVA;1\npor_qry_cVarTap;1\nrsrrOrEiVar;1\nssrrOrEiRes;1\npor_qry_dVaAlku;1.1.1999\npor_qry_dVaLopp;31.12.2006\npor_qry_lbQryType;1\npo_qry_lbQryType;1\npr_qry_lbQryType;1\n",
		"name_en_us": "add_to_stock",
		"_prf_name_id": "_qry_por_Lisää varastoon",
		"name": "Lisää varastoon",
		"table": "ordr"
	},
	{
		"_prf_text_value": "ARRAY TEXT(_atArr;0)\n_txt:=\"POS\"\n_qry Fld (0;pr_kProduct_Group;\"=\";->_txt;\"*\";kFalse)\n_bool:=False\n_qry Fld (0;pr_kNot_In_Use;\"=\";->_bool;\"&\";kFalse)\n_sel_ SEL_TO_ARR_ONE (pr_kProduct_ID;->_atArr)\n\n_txt:=\"\"\n_qry Fld (0;sor_kInvoice_id;\"=\";->_txt;\"*\";kFalse)\n_qry Fld (0;sor_kDelivery_State;\"#\";->_txt;\"&*\";kFalse)\n_long:=0\n_qry Fld (0;sor_kDelivered_Quantity;\"#\";->_long;\"&\";kFalse)\n_set CREATE (sor_kTbl;\"$sor_Set1\")\n\n_qry ARRAY (sor_kProduct_id;->_atArr;kTrue)\nARRAY TEXT(_atArr;0)\n_set CREATE (sor_kTbl;\"$sor_Pos\")\n\n_set DIFFERENCE (sor_kTbl;\"$sor_Set1\";\"$sor_Pos\";\"$sor_Set1\")\n_set USE (sor_kTbl;\"$sor_Set1\")\n_set CLEAR (sor_kTbl;\"$sor_Set1\")\n_set CLEAR (sor_kTbl;\"$sor_Pos\")\n\n_sel RELATE ONE SELECTION (sor_kSales_Order_id;so_kSales_Order_ID)\n\n_txt:=\"PE\"\n_qry Fld (0;so_kState;\"#\";->_txt;\"*\";kTrue)\n_txt:=\"LA\"\n_qry Fld (0;so_kType_;\"#\";->_txt;\"&*\";kTrue)\n_date:=!01.01.2015!\n_qry Fld (0;so_kOrder_Date;\">=\";->_date;\"&\";kTrue)",
		"execute": true,
		"name_en_us": "_exe_Toimitettu laskuttamatta_nrx",
		"name": "Toimitettu laskuttamatta_nrx",
		"_prf_name_id": "_qry_exe_so_Toimitettu laskuttamatta_nrx",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;so_kTransfer_id;\"#\";->_txt;\"\";kFalse;kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_SentToItella",
		"name": "SentToItella",
		"_prf_name_id": "_qry_exe_so_SentToItella",
		"table": "ord"
	},
	{
		"_prf_text_value": "_txt:=\"\"\n_qry Fld (0;po_kTransfer_id;\"#\";->_txt;\"\";kFalse;kFalse)\n",
		"execute": true,
		"name_en_us": "_exe_SentToItella",
		"name": "SentToItella",
		"_prf_name_id": "_qry_exe_po_SentToItella",
		"table": "ord"
	},
	{
		"_prf_text_value": "_date:=!1.1.2015!\n_qry Fld (0;por_kDate_Of_Arrival;\">=\";->_date;\"*\";kFalse )\n_long:=0\n_qry Fld (0;por_kPrice_Confirmation;\"=\";->_long;\"&\";kFalse )\n\n_sel RELATE ONE SELECTION(por_kPurchase_Order_id;po_kPurchase_Order_id)\n_firm SEL_REDUCE (po_kTbl )",
		"execute": true,
		"name_en_us": "_exe_ConfirmPrice",
		"name": "ConfirmPrice",
		"_prf_name_id": "_qry_exe_po_ConfirmPrice",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_HAE AVOIMET(False)\n_txt:=\"\"\n_qry Fld (0;po_kTransfer_id;\"#\";->_txt;\"\";kTrue;kFalse)\n\n",
		"execute": true,
		"name_en_us": "_exe_SentToItellaOpen",
		"name": "SentToItellaOpen",
		"_prf_name_id": "_qry_exe_po_SentToItellaOpen",
		"table": "ord"
	},
	{
		"_prf_text_value": "po_qry_cTunnus;1\npo_qry_sTunnu1;a\npo_qry_sTunnu2;a\npo_qry_cToimit;1\npo_qry_sToimit;a@\npo_qry_cTyyppi;1\npo_qry_cTyRA;1\npo_qry_cTyAH;1\npo_qry_cTila;1\npo_qry_cAV;1\npo_qry_cTI;1\npo_qry_cTO;1\npo_qry_cPE;1\npo_qry_cVA;1\npo_qry_cEtopv;1\npo_qry_dEtop1;10/06/15\npo_qry_dEtop2;31/12/15\npo_qry_cTilpv;1\npo_qry_dTilp1;10/06/15\npo_qry_dTilp2;10/06/15\npo_qry_cValuut;1\npo_qry_sValuut;a\npo_qry_lbQryType;1\npo_qry_cOT;1\npo_qry_cTA;1\npo_qry_cCostCenter;1\npo_qry_tCostCenter;a\n",
		"name_en_us": "all",
		"name_en_us_us": "all",
		"_prf_name_id": "_qry_po_all",
		"name": "all",
		"table": "ord"
	},
	{
		"_prf_text_value": "so_qry_cTyyppi;1\nso_qry_cTA;1\nso_qry_cTI;1\nso_qry_cVM;1\nso_qry_cLA;1\nso_qry_cTT;1\nso_qry_cAH;1\nso_qry_cTila;1\nso_qry_cAT;1\nso_qry_cAL;1\nso_qry_cLO;1\nso_qry_cPE;1\nso_qry_cTunnus;1\nso_qry_sTuAlk;1\nso_qry_sTuLop;1\nso_qry_cToPvm;1\nso_qry_dToAlku;1.6.2015\nso_qry_dToLopp;1.6.2015\nso_qry_cTiPvm;1\nso_qry_dTiAlk;1.1.2001\nso_qry_dTiLop;31.12.2001\nso_qry_cTilaaj;1\nso_qry_sTilaaj;1\nso_qry_cLaskut;1\nso_qry_sLaskut;1\nso_qry_cToimAs;1\nso_qry_sToimAs;1\nso_qry_cAsR;1\nso_qry_sAsR;1\nso_qry_cMyyjä;1\nso_qry_sMyyjä;1\nso_qry_cToimit;1\nso_qry_sToimit;12 \nso_qry_cValuut;1\nso_qry_sValuut;1\nso_qry_cLS;1\nso_qry_lbQryType;1\nso_qry_cVA;1\nso_qry_cEV;1\nso_qry_cCostCenter;1\nso_qry_tCostCenter;1\n",
		"name_en_us": "all",
		"name_en_us_us": "all",
		"_prf_name_id": "_qry_so_all",
		"name": "all",
		"table": "ord"
	},
	{
		"_prf_text_value": "cope_qry_lcAsia;1\ncope_qry_sAsia;1\ncope_qry_lcNimi;1\ncope_qry_sNimi;1\ncope_qry_lbQryType;1\n",
		"name_en_us": "all",
		"name_en_us_us": "all",
		"_prf_name_id": "_qry_cope_all",
		"name": "all",
		"table": "cope"
	},
	{
		"_prf_text_value": "co_qry_cTunnus;1\nco_qry_sTunnus;a\nco_qry_cAsiaka;1\nco_qry_sAsiaka;a\nco_qry_cAsnro;1\nco_qry_sAsnro;a\nco_qry_cMaksue;1\nco_qry_sMaksue;a\nco_qry_cValuut;1\nco_qry_sValuut;a\nco_qry_cOletmy;1\nco_qry_sOletmy;a\nco_qry_cMuuPv;1\nco_qry_dMuuPv1;1.6.2015\nco_qry_dMuuPv2;1.6.2015\nco_qry_lbQryType;1\nco_qry_cCostCenter;1\nco_qry_tCostCenter;a\nco_qry_cType_;1\nco_qry_lType_;1\nco_qry_cState;1\nco_qry_lState;1\nco_qry_cGroup1;1\nco_qry_tGroup1;1\nco_qry_cGroup2;1\nco_qry_tGroup2;1\nco_qry_cGroup3;1\nco_qry_tGroup3;1\n",
		"name_en_us": "all",
		"name_en_us_us": "all",
		"_prf_name_id": "_qry_co_all",
		"name": "all",
		"table": "co"
	},
	{
		"_prf_text_value": "coad_qry_lcAsia;1\ncoad_qry_sAsia;asd\ncoad_qry_lbQryType;1\n",
		"name_en_us": "all",
		"name_en_us_us": "all",
		"_prf_name_id": "_qry_coad_all",
		"name": "all",
		"table": "coad"
	}
]