[
	{
		"table_number": 1,
		"default_value": ">",
		"field_number": 1001,
		"field_name": "[zAsetus]Nimi ID",
		"field": "_prf_kName_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "_prf_"
	},
	{
		"table_number": 3,
		"default_value": ">",
		"field_number": 3002,
		"field_name": "[zRaportti]Nimi",
		"field": "_rep_kName",
		"mandatory": -1,
		"firm_id": 0,
		"table": "_rep_"
	},
	{
		"table_number": 4,
		"default_value": "7",
		"field_number": 4005,
		"field_name": "[Tosite]Tyyppi",
		"field": "vo_kType_",
		"mandatory": 0,
		"firm_id": 0,
		"table": "vo_"
	},
	{
		"table_number": 9,
		"default_value": "1,2",
		"field_number": 9008,
		"field_name": "[Tuote]Ostokerroin",
		"field": "pr_kPurchase_Multiplier",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1",
		"field_number": 9009,
		"field_name": "[Tuote]Varastoitava",
		"field": "pr_kStorable",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1",
		"field_number": 9011,
		"field_name": "[Tuote]Muuntokerr",
		"field": "pr_kConversion_Multiplier",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "kpl",
		"field_number": 9012,
		"field_name": "[Tuote]Yksikkö",
		"field": "pr_kUnit",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "kpl",
		"field_number": 9013,
		"field_name": "[Tuote]Ykskkö 2",
		"field": "pr_kUnit_2",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1,25",
		"field_number": 9018,
		"field_name": "[Tuote]Katekerroin",
		"field": "pr_kProfit_Multiplier",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1",
		"field_number": 9019,
		"field_name": "[Tuote]On tarvelaskennassa",
		"field": "pr_kNeed_Calculation_In_Use",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "M24",
		"field_number": 9029,
		"field_name": "[Tuote]Myyntikoodi",
		"field": "pr_kSales_Order_Code_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "U",
		"field_number": 9030,
		"field_name": "[Tuote]Ulkom. myyntik",
		"field": "pr_kForeign_Sales_Ord_Code_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "OS",
		"field_number": 9031,
		"field_name": "[Tuote]Ostokoodi ",
		"field": "pr_kPurchase_Order_Code_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "",
		"field_number": 9040,
		"field_name": "[Tuote]Hintaryhmä",
		"field": "pr_kPrice_Group_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1",
		"field_number": 9042,
		"field_name": "[Tuote]Suunn. muuntok.",
		"field": "pr_kDesign_Conversion_Multip",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "kpl",
		"field_number": 9043,
		"field_name": "[Tuote]Suunn. yks",
		"field": "pr_kDesign_Unit",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "kpl",
		"field_number": 9044,
		"field_name": "[Tuote]Suunn. yks. 2",
		"field": "pr_kDesign_Unit_2",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "1",
		"field_number": 9045,
		"field_name": "[Tuote]Yks/SYks muuntok.",
		"field": "pr_kUnit__Design_Unit_Multip",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "-1",
		"field_number": 9071,
		"field_name": "[Tuote]Tyyppi",
		"field": "pr_kType_",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 9,
		"default_value": "0,5",
		"field_number": 9073,
		"field_name": "[Tuote]RA toimitusaika (vko)",
		"field": "pr_kRaw_Material_Delivery_Time",
		"mandatory": 0,
		"firm_id": 0,
		"table": "pr_"
	},
	{
		"table_number": 10,
		"default_value": ">",
		"field_number": 10001,
		"field_name": "[Asiakas]TUNNUS",
		"field": "co_kCompany_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "co_"
	},
	{
		"table_number": 10,
		"default_value": "EUR",
		"field_number": 10017,
		"field_name": "[Asiakas]Valuutta",
		"field": "co_kCurrency_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "co_"
	},
	{
		"table_number": 11,
		"default_value": ">",
		"field_number": 11001,
		"field_name": "[Toimittaja]TUNNUS",
		"field": "su_kSupplier_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "su_"
	},
	{
		"table_number": 17,
		"default_value": "<",
		"field_number": 17004,
		"field_name": "[Lasku]Lasku",
		"field": "in_kInvoice_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "in_"
	},
	{
		"table_number": 17,
		"default_value": "NO",
		"field_number": 17028,
		"field_name": "[Lasku]Tyyppi",
		"field": "in_kType_",
		"mandatory": 1,
		"firm_id": 0,
		"table": "in_"
	},
	{
		"table_number": 18,
		"default_value": "NO",
		"field_number": 18024,
		"field_name": "[Laskurivi]Tyyppi",
		"field": "inr_kType_",
		"mandatory": 0,
		"firm_id": 0,
		"table": "inr_"
	},
	{
		"table_number": 20,
		"default_value": "",
		"field_number": 20002,
		"field_name": "[Ostotilauksen rivi]Varastotapahtuma",
		"field": "por_kStock_Event",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "",
		"field_number": 20008,
		"field_name": "[Ostotilauksen rivi]Toimitustila",
		"field": "por_kDelivery_State",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "00.00.00",
		"field_number": 20012,
		"field_name": "[Ostotilauksen rivi]Vahv. toimitus pv",
		"field": "por_kConfirmed_Arrival_Date",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "0",
		"field_number": 20023,
		"field_name": "[Ostotilauksen rivi]Toimitettu mrä",
		"field": "por_kDelivered_Amount",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "AV",
		"field_number": 20027,
		"field_name": "[Ostotilauksen rivi]Tilauksen tila",
		"field": "por_kOrder_State",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "00.00.00",
		"field_number": 20030,
		"field_name": "[Ostotilauksen rivi]Tulopäivä",
		"field": "por_kDate_Of_Arrival",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "00.00.00",
		"field_number": 20038,
		"field_name": "[Ostotilauksen rivi]Ens. vahv. toim. pv",
		"field": "por_kFirst_Confirm_Deliv_Date",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 20,
		"default_value": "00.00.00",
		"field_number": 20039,
		"field_name": "[Ostotilauksen rivi]Alihank. läh. pv",
		"field": "por_kSubcontract_Sent_Date",
		"mandatory": 0,
		"firm_id": 0,
		"table": "por_"
	},
	{
		"table_number": 21,
		"default_value": "<",
		"field_number": 21001,
		"field_name": "[Myyntitilaus]TUNNUS",
		"field": "so_kSales_Order_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "so_"
	},
	{
		"table_number": 21,
		"default_value": "TI",
		"field_number": 21008,
		"field_name": "[Myyntitilaus]Tyyppi",
		"field": "so_kType_",
		"mandatory": 1,
		"firm_id": 0,
		"table": "so_"
	},
	{
		"table_number": 21,
		"default_value": "",
		"field_number": 21009,
		"field_name": "[Myyntitilaus]Maksuehto",
		"field": "so_kTerms_Of_Payment_id",
		"mandatory": 1,
		"firm_id": 0,
		"table": "so_"
	},
	{
		"table_number": 21,
		"default_value": "Jyväskylä",
		"field_number": 21027,
		"field_name": "[Myyntitilaus]Lähtöpaikka",
		"field": "so_kPlace_Of_Departure",
		"mandatory": 0,
		"firm_id": 0,
		"table": "so_"
	},
	{
		"table_number": 21,
		"default_value": "AV",
		"field_number": 21043,
		"field_name": "[Myyntitilaus]Tila",
		"field": "so_kState",
		"mandatory": 1,
		"firm_id": 0,
		"table": "so_"
	},
	{
		"table_number": 23,
		"default_value": "<",
		"field_number": 23006,
		"field_name": "[Myyntitilauksen rivi]Toimituspäivä",
		"field": "sor_kDelivered_Date",
		"mandatory": -1,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "0",
		"field_number": 23010,
		"field_name": "[Myyntitilauksen rivi]Toimitettu mrä",
		"field": "sor_kDelivered_Quantity",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "",
		"field_number": 23012,
		"field_name": "[Myyntitilauksen rivi]Lähetyslista",
		"field": "sor_kDispatch_Note_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "",
		"field_number": 23013,
		"field_name": "[Myyntitilauksen rivi]Varastotapahtuma",
		"field": "sor_kStock_Event",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "",
		"field_number": 23014,
		"field_name": "[Myyntitilauksen rivi]Lasku",
		"field": "sor_kInvoice_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "",
		"field_number": 23021,
		"field_name": "[Myyntitilauksen rivi]Toimitustila",
		"field": "sor_kDelivery_State",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "TI",
		"field_number": 23027,
		"field_name": "[Myyntitilauksen rivi]Tyyppi",
		"field": "sor_kType_",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "00.00.00",
		"field_number": 23036,
		"field_name": "[Myyntitilauksen rivi]Tot. toim. pv",
		"field": "sor_kDelivery_Date",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "AV",
		"field_number": 23039,
		"field_name": "[Myyntitilauksen rivi]Til. tila",
		"field": "sor_kOrder_State",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 23,
		"default_value": "",
		"field_number": 23042,
		"field_name": "[Myyntitilauksen rivi]Valmistuserä",
		"field": "sor_kProduction_Lot",
		"mandatory": 0,
		"firm_id": 0,
		"table": "sor_"
	},
	{
		"table_number": 28,
		"default_value": "<",
		"field_number": 28008,
		"field_name": "[Ostoreskontra]TUNNUS",
		"field": "ap_kCode_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "00.00.00",
		"field_number": 28012,
		"field_name": "[Ostoreskontra]Maksu pv",
		"field": "ap_kPayment_Date",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "2700",
		"field_number": 28017,
		"field_name": "[Ostoreskontra]Ostovelkatili",
		"field": "ap_kPurchase_Debt_Account_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "Viite",
		"field_number": 28019,
		"field_name": "[Ostoreskontra]Viestityyppi",
		"field": "ap_kNote_Type",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "AV",
		"field_number": 28023,
		"field_name": "[Ostoreskontra]Hyväksymistila",
		"field": "ap_kApproval_State",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "Normaali",
		"field_number": 28026,
		"field_name": "[Ostoreskontra]Reskontra",
		"field": "ap_kAccounts_Ledger",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 28,
		"default_value": "0",
		"field_number": 28029,
		"field_name": "[Ostoreskontra]Maksettu yht",
		"field": "ap_kSum_Of_Payment",
		"mandatory": 0,
		"firm_id": 0,
		"table": "ap_"
	},
	{
		"table_number": 29,
		"default_value": "<",
		"field_number": 29001,
		"field_name": "[Ostotilaus]TUNNUS",
		"field": "po_kPurchase_Order_ID",
		"mandatory": -1,
		"firm_id": 0,
		"table": "po_"
	},
	{
		"table_number": 29,
		"default_value": "AV",
		"field_number": 29007,
		"field_name": "[Ostotilaus]Tila",
		"field": "po_kState",
		"mandatory": 0,
		"firm_id": 0,
		"table": "po_"
	},
	{
		"table_number": 29,
		"default_value": "RA",
		"field_number": 29022,
		"field_name": "[Ostotilaus]Tyyppi",
		"field": "po_kType_",
		"mandatory": 0,
		"firm_id": 0,
		"table": "po_"
	},
	{
		"table_number": 33,
		"default_value": "1",
		"field_number": 33024,
		"field_name": "[Resurssirivi]Kerroin",
		"field": "resr_kMultiplier",
		"mandatory": 0,
		"firm_id": 0,
		"table": "resr_"
	},
	{
		"table_number": 37,
		"default_value": "0",
		"field_number": 37003,
		"field_name": "[Reklamaatio]Tila   ",
		"field": "rcl_kState",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 37,
		"default_value": "PM",
		"field_number": 37006,
		"field_name": "[Reklamaatio]Käsittelijä ",
		"field": "rcl_kHandler_id",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 37,
		"default_value": "1",
		"field_number": 37022,
		"field_name": "[Reklamaatio]Virheen tehnyt työvaihe ",
		"field": "rcl_kFault_Made_Work_Phase",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 37,
		"default_value": "50",
		"field_number": 37043,
		"field_name": "[Reklamaatio]Korjauskulujen á-hinta",
		"field": "rcl_kRepair_Price__Unit",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 37,
		"default_value": "1",
		"field_number": 37080,
		"field_name": "[Reklamaatio]Näkyvyys",
		"field": "rcl_kShow_Type",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 37,
		"default_value": "1",
		"field_number": 37082,
		"field_name": "[Reklamaatio]Tulostetaan raporttiin",
		"field": "rcl_kPrint_To_Report",
		"mandatory": 0,
		"firm_id": 0,
		"table": "rcl_"
	},
	{
		"table_number": 38,
		"default_value": "1",
		"field_number": 38004,
		"field_name": "[Lisäkenttä]Tila",
		"field": "af_kState",
		"mandatory": 0,
		"firm_id": 0,
		"table": "af_"
	},
	{
		"table_number": 43,
		"default_value": "TI",
		"field_number": 43003,
		"field_name": "[Työ]Tila",
		"field": "w_kState",
		"mandatory": 0,
		"firm_id": 0,
		"table": "w_"
	},
	{
		"table_number": 44,
		"default_value": "<",
		"field_number": 44001,
		"field_name": "[Työmääräin]Työ/pos nro",
		"field": "wo_kWork__Position_Num_id",
		"mandatory": -1,
		"firm_id": 0,
		"table": "wo_"
	},
	{
		"table_number": 45,
		"default_value": "1",
		"field_number": 45003,
		"field_name": "[Työn lask. materiaali]Kpl/Yks",
		"field": "wme_kQuantity__Unit",
		"mandatory": 0,
		"firm_id": 0,
		"table": "wme_"
	},
	{
		"table_number": 47,
		"default_value": "X",
		"field_number": 47003,
		"field_name": "[Työn lask. työvaihe]Työntekijä",
		"field": "wpe_kEmployee_id",
		"mandatory": 0,
		"firm_id": 1,
		"table": "wpe_"
	},
	{
		"table_number": 47,
		"default_value": "10",
		"field_number": 47060,
		"field_name": "[Työn lask. työvaihe]Seurantalaskuri",
		"field": "wpe_kTrack_Time_Status",
		"mandatory": 0,
		"firm_id": 0,
		"table": "wpe_"
	},
	{
		"table_number": 52,
		"default_value": "VK",
		"field_number": 52012,
		"field_name": "[Ostoreskontran vastakirj.]Tila",
		"field": "appa_kState",
		"mandatory": 0,
		"firm_id": 0,
		"table": "appa_"
	}
]