{
	"model":{
		"designer":{
		},
		"API":{
			"eventHandler":""
		},
		"proxy":{
			"url":"/api/{entity}",
			"reader":{
				"type":"json",
				"rootProperty":"rows",
				"totalProperty":"totalRows"
			},
			"write":{
				"type":"json",
				"writeAllFields":false
			},
			"actionMethods":{
				"create":"POST",
				"read":"GET",
				"update":"PATCH",
				"destroy":"DELETE"
			},
			"xtype":"Ext.data.proxy.Rest",
			"limitParam":"size",
			"portfolio":false,
			"ccsid":"",
			"prefix":""
		},
		"types":{
		},
		"entities":{
			"IMLQuantity":{
				"columns":[
					{
						"type":"integer",
						"name":"id",
						"title":"Id"
					},{
						"type":"integer",
						"name":"customernumber",
						"title":"Customer ID"
					},{
						"type":"varchar(20)",
						"name":"customerid",
						"len":20,
						"title":"Customer Id"
					},{
						"type":"char(1)",
						"name":"location",
						"len":1,
						"title":"Location"
					},{
						"type":"integer",
						"name":"mould_id",
						"title":"MouldId",
						"nulls":"NULL"
					},{
						"type":"integer",
						"name":"material_id",
						"title":"MaterialId",
						"nulls":"NULL"
					},{
						"type":"integer",
						"name":"shape_id",
						"title":"ShapeId",
						"nulls":"NULL"
					},{
						"type":"integer",
						"name":"min_qty_design",
						"title":"Min. Qty per design"
					},{
						"type":"integer",
						"name":"min_qty_mould",
						"title":"Min. Qty per mould"
					},{
						"type":"integer",
						"name":"createdby",
						"title":"Created by"
					},{
						"type":"integer",
						"name":"changedby",
						"title":"Changed by"
					},{
						"type":"timestamp",
						"name":"createdtime",
						"title":"Created",
						"uitype":"isotimestamp",
						"native":"true"
					},{
						"type":"timestamp",
						"name":"changedtime",
						"title":"Changed",
						"uitype":"isotimestamp",
						"native":"true"
					},{
						"type":"bool",
						"name":"composite_allowed",
						"title":"Composite allowed"
					},{
						"type":"varchar(1000)",
						"name":"comments",
						"len":1000,
						"title":"Comments"
					}
				],
				"uiFeatures":{
				},
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"name":"id",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"location",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"customernumber",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"mould_id",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"material_id",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"shape_id",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"min_qty_mould",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"min_qty_design",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"createdby",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"createdtime",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"changedby",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"changedtime",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"name":"portfolio",
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						},
						"list":{
							"features":{
								"menu":{
								}
							},
							"sortable":true,
							"editMode":"window",
							"rowmodel":"rowmodel",
							"extraParams":{
							},
							"columns":[
								{
									"name":"id",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"customerid",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"mould_ltlgmi",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"mould_ltlgmn",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"material_imilmi",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"material_imilmn",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"imltype_iyilti",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"imltype_iyiltn",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"min_qty_design",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"min_qty_mould",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"location",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"customernumber",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"name":"createdtime",
									"showned":true,
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"filters":[
								
							],
							"name":"list"
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"customernumber"
								},{
									"name":"id"
								},{
									"name":"customerid"
								},{
									"name":"location"
								},{
									"name":"mould"
								},{
									"name":"material"
								},{
									"name":"imltype"
								},{
									"name":"min_qty_mould"
								},{
									"name":"min_qty_design"
								},{
									"name":"composite_allowed"
								},{
									"name":"comments"
								},{
									"name":"createdby"
								},{
									"name":"createdtime"
								},{
									"name":"changedby"
								},{
									"name":"changedtime"
								}
							],
							"items":{
								"columns":[
									{
										"name":"customernumber",
										"title":"Customer ID",
										"type":"integer",
										"sequence":0
									},{
										"fieldLabel":"Id",
										"type":"number",
										"name":"id",
										"title":"Id",
										"readOnly":true,
										"sequence":1
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"scustopf",
										"url":"/api/customer",
										"searchUrl":"/api/customer",
										"limitParam":"limit",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"readOnly":true,
										"fieldLabel":"Customer Id",
										"allowBlank":true,
										"syncEvent":"change",
										"name":"customerid",
										"title":"Customer Id",
										"group":"group53",
										"len":20,
										"sequence":0
									},{
										"type":"sqlcombobox",
										"url":"/api/picker/location",
										"displayField":"name",
										"valueField":"key",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"actionMethods":{
											"create":"POST",
											"read":"POST",
											"update":"POST",
											"destroy":"DELETE"
										},
										"params":{
										},
										"readOnly":true,
										"fieldLabel":"Location",
										"allowBlank":true,
										"width":50,
										"sequence":1,
										"syncEvent":"change",
										"title":"Location",
										"name":"location",
										"group":"group53",
										"len":1
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"slomtxpf",
										"url":"/api/picker/mould",
										"searchUrl":"/api/picker/mould",
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"asObject":true,
										"fieldLabel":"mould",
										"syncEvent":"change",
										"title":"mould",
										"name":"mould",
										"group":"group22",
										"sequence":0
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"simlmtpf",
										"url":"/api/picker/material",
										"searchUrl":"/api/picker/material",
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"asObject":true,
										"fieldLabel":"Material",
										"sequence":1,
										"syncEvent":"change",
										"title":"material",
										"name":"material",
										"group":"group22"
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"simltppf",
										"url":"/api/picker/shape",
										"searchUrl":"/api/picker/shape",
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"asObject":true,
										"fieldLabel":"Type",
										"sequence":2,
										"syncEvent":"change",
										"title":"imltype",
										"name":"imltype",
										"group":"group22"
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"Min. Qty per mould",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"name":"min_qty_mould",
										"title":"Min. Qty per mould",
										"group":"group22",
										"uitype":"decimalnumber"
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"Min. Qty per design",
										"allowBlank":true,
										"sequence":4,
										"syncEvent":"change",
										"title":"Min. Qty per design",
										"name":"min_qty_design",
										"group":"group22"
									},{
										"type":"boolean",
										"inputValue":true,
										"fieldLabel":"Composite allowed",
										"allowBlank":true,
										"sequence":5,
										"syncEvent":"change",
										"title":"Composite allowed",
										"name":"composite_allowed",
										"group":"group22"
									},{
										"type":"textarea",
										"fieldLabel":"Comments",
										"allowBlank":true,
										"sequence":6,
										"syncEvent":"change",
										"name":"comments",
										"title":"Comments",
										"group":"group22",
										"len":1000
									},{
										"type":"entitypicker",
										"dmd":"dmd/portfolio.dmd",
										"entity":"NAVUSRET00",
										"pageSize":20,
										"view":"portfolio",
										"editable":true,
										"readOnly":true,
										"fieldLabel":"Created by",
										"allowBlank":true,
										"syncEvent":"change",
										"title":"Created by",
										"name":"createdby",
										"group":"group39",
										"sequence":0
									},{
										"type":"isotimestampdisplay",
										"date":true,
										"time":true,
										"seconds":true,
										"dateformat":"Y-m-d-h.i.s.u",
										"readOnly":true,
										"fieldLabel":"Created",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"title":"Created",
										"name":"createdtime",
										"group":"group39",
										"uitype":"isotimestamp",
										"native":"true"
									},{
										"type":"entitypicker",
										"dmd":"dmd/portfolio.dmd",
										"entity":"NAVUSRET00",
										"pageSize":20,
										"view":"portfolio",
										"editable":true,
										"readOnly":true,
										"fieldLabel":"Changed by",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"title":"Changed by",
										"name":"changedby",
										"group":"group39"
									},{
										"type":"isotimestampdisplay",
										"date":true,
										"time":true,
										"seconds":true,
										"dateformat":"Y-m-d-h.i.s.u",
										"readOnly":true,
										"fieldLabel":"Changed",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"name":"changedtime",
										"title":"Changed",
										"group":"group39",
										"uitype":"isotimestamp",
										"native":"true"
									}
								]
							},
							"layout":{
							},
							"groups":{
								"group53":{
									"name":"group53",
									"title":"Customer",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":0
								},
								"group22":{
									"name":"group22",
									"title":"Minimum Quantities",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"sequence":1,
									"xtype":"fieldset",
									"layout":"anchor"
								},
								"group39":{
									"name":"group39",
									"title":"Revisions",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":100
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":2
								}
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							},
							"name":"portfolio"
						}
					}
				},
				"name":"IMLQuantity",
				"title":"Min. IML quantity",
				"idColumn":"id",
				"keys":[
					
				],
				"designer":{
					"x":14,
					"y":12,
					"width":193,
					"height":478,
					"lastmodified":1551191381108
				},
				"permission":{
					"add":{
						"form":true,
						"grid":true
					},
					"edit":{
						"form":true,
						"grid":true
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"A"
			},
			"PPO":{
				"columns":[
					{
						"type":"integer",
						"name":"id",
						"title":"Id"
					},{
						"type":"char(1)",
						"name":"cust_location",
						"len":1,
						"title":"Customer Location"
					},{
						"type":"varchar(20)",
						"name":"customerid",
						"len":20,
						"title":"CustomerId"
					},{
						"type":"integer",
						"name":"cust_id",
						"title":"Customer Number"
					},{
						"type":"varchar(255)",
						"name":"cust_contact",
						"len":255,
						"title":"Customer Contact"
					},{
						"type":"varchar(255)",
						"name":"cust_phone2",
						"len":255,
						"title":"Customer Alt Phone"
					},{
						"type":"integer",
						"name":"cust_kam_id",
						"title":"Customer KAM"
					},{
						"type":"integer",
						"name":"cust_cs_rep",
						"title":"Customer Service Rep"
					},{
						"type":"char(1)",
						"name":"factory_location",
						"len":1,
						"title":"Factory Location"
					},{
						"type":"varchar(255)",
						"name":"status",
						"len":255,
						"title":"Status"
					},{
						"type":"varchar(255)",
						"name":"supplier",
						"len":255,
						"title":"Supplier"
					},{
						"type":"char(1)",
						"name":"ordertype",
						"len":1,
						"title":"Order Type"
					},{
						"type":"integer",
						"name":"po_number",
						"title":"PO Number"
					},{
						"type":"varchar(255)",
						"name":"comments",
						"len":255,
						"title":"Comments"
					},{
						"type":"integer",
						"name":"qty_override_by",
						"title":"Quantity Approved By"
					},{
						"type":"timestamp",
						"name":"qty_override_date",
						"title":"Quantity Approved Date",
						"nulls":"NULL",
						"native":"true"
					},{
						"type":"integer",
						"name":"createdby",
						"title":"Created By"
					},{
						"type":"integer",
						"name":"changedby",
						"title":"Changed By",
						"nulls":1
					},{
						"type":"timestamp",
						"name":"createdtime",
						"title":"Created",
						"uitype":"isotimestamp",
						"native":"true"
					},{
						"type":"timestamp",
						"name":"changedtime",
						"title":"Changed",
						"uitype":"isotimestamp",
						"native":"true"
					}
				],
				"uiFeatures":{
				},
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"id",
									"width":50,
									"title":"Id",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"customerid",
									"width":80,
									"title":"CustomerId",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"cust_contact",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"factory_location",
									"width":50,
									"title":"Factory Location",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"status",
									"width":120,
									"title":"Status",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"supplier",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"po_number",
									"width":120,
									"title":"PO Number",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"cust_location",
									"width":50,
									"title":"Customer Location",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"cust_id",
									"width":120,
									"title":"Customer Number",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"comments",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"changedtime",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"items":{
								"columns":[
									{
										"fieldLabel":"Id",
										"type":"number",
										"name":"id",
										"title":"Id",
										"readOnly":true
									}
								]
							},
							"layout":{
							},
							"features":{
							},
							"name":"portfolio",
							"sortable":true,
							"editMode":"window",
							"rowmodel":"rowmodel",
							"filters":[
								
							]
						},
						"cs":{
							"features":{
								"menu":{
								}
							},
							"sortable":true,
							"editMode":"window",
							"rowmodel":"rowmodel",
							"extraParams":{
							},
							"columns":[
								{
									"showned":true,
									"name":"id",
									"width":60,
									"title":"Id",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"customerid",
									"width":100,
									"title":"CustomerId",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"cust_contact",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"cust_phone2",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"factory_location",
									"width":100,
									"title":"Factory Location",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"status",
									"width":80,
									"title":"Status",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"supplier",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"ordertype",
									"width":80,
									"title":"Order Type",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"po_number",
									"width":100,
									"title":"PO Number",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"comments",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"changedtime",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"filters":[
								
							]
						},
						"factory":{
							"features":{
								"menu":{
								}
							},
							"sortable":true,
							"editMode":"window",
							"rowmodel":"rowmodel",
							"extraParams":{
							},
							"columns":[
								{
									"showned":true,
									"name":"id",
									"width":60,
									"title":"Id",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"customerid",
									"width":100,
									"title":"CustomerId",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"status",
									"width":80,
									"title":"Status",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"supplier",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"ordertype",
									"width":80,
									"title":"Order Type",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"po_number",
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"comments",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"factory_location",
									"width":100,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"changedtime",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"cust_id"
								},{
									"name":"customerid"
								},{
									"name":"cust_location"
								},{
									"name":"cust_contact"
								},{
									"name":"cust_phone2"
								},{
									"name":"cust_kam_id"
								},{
									"name":"cust_cs_rep"
								},{
									"name":"status"
								},{
									"name":"factory_location"
								},{
									"name":"supplier"
								},{
									"name":"ordertype"
								},{
									"name":"po_number"
								},{
									"name":"comments"
								},{
									"name":"qty_override_by"
								},{
									"name":"qty_override_date"
								},{
									"name":"id"
								},{
									"name":"createdby"
								},{
									"name":"createdtime"
								},{
									"name":"changedby"
								},{
									"name":"changedtime"
								}
							],
							"items":{
								"columns":[
									{
										"name":"cust_id",
										"title":"Customer Number",
										"type":"integer",
										"sequence":0
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"scustopf",
										"url":"/api/customer",
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"fieldLabel":"CustomerId",
										"allowBlank":true,
										"syncEvent":"change",
										"fieldParams":[
											{
												"name":"cust_location"
											}
										],
										"name":"customerid",
										"title":"CustomerId",
										"group":"customer",
										"len":20,
										"sequence":0
									},{
										"type":"varchar",
										"readOnly":true,
										"fieldLabel":"Customer Location",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"title":"Customer Location",
										"name":"cust_location",
										"group":"customer",
										"len":1
									},{
										"type":"varchar",
										"fieldLabel":"Customer Contact",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"title":"Customer Contact",
										"name":"cust_contact",
										"group":"customer",
										"len":255
									},{
										"type":"varchar",
										"fieldLabel":"Customer Alt Phone",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"title":"Customer Alt Phone",
										"name":"cust_phone2",
										"group":"customer",
										"len":255
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"Customer KAM",
										"allowBlank":true,
										"sequence":4,
										"syncEvent":"change",
										"name":"cust_kam_id",
										"title":"Customer KAM",
										"group":"customer"
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"Customer Service Rep",
										"allowBlank":true,
										"sequence":5,
										"syncEvent":"change",
										"name":"cust_cs_rep",
										"title":"Customer Service Rep",
										"group":"customer"
									},{
										"type":"picker",
										"values":[
											{
												"key":"Draft"
											},{
												"key":"Ready"
											},{
												"key":"Order"
											},{
												"key":"Closed"
											}
										],
										"valueField":"key",
										"displayField":"key",
										"editable":true,
										"fieldLabel":"Status",
										"allowBlank":true,
										"syncEvent":"change",
										"title":"Status",
										"name":"status",
										"group":"order",
										"len":255,
										"default":"Draft",
										"sequence":0
									},{
										"type":"sqlcombobox",
										"url":"/api/picker/location",
										"displayField":"name",
										"valueField":"key",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"actionMethods":{
										},
										"params":{
										},
										"fieldLabel":"Factory Location",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"title":"Factory Location",
										"name":"factory_location",
										"group":"order",
										"len":1
									},{
										"type":"varchar",
										"fieldLabel":"Supplier",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"name":"supplier",
										"title":"Supplier",
										"group":"order",
										"len":255
									},{
										"type":"picker",
										"values":[
											{
												"key":"I"
											},{
												"key":"O"
											}
										],
										"valueField":"key",
										"displayField":"key",
										"editable":true,
										"fieldLabel":"Order Type",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"name":"ordertype",
										"title":"Order Type",
										"group":"order",
										"len":1,
										"default":"I"
									},{
										"type":"integer",
										"decimalPrecision":2,
										"allowDecimals":true,
										"allowBlank":true,
										"readOnly":true,
										"fieldLabel":"PO Number",
										"name":"po_number",
										"title":"PO Number",
										"sequence":4,
										"group":"order"
									},{
										"type":"textarea",
										"fieldLabel":"Comments",
										"allowBlank":true,
										"sequence":5,
										"syncEvent":"change",
										"name":"comments",
										"title":"Comments",
										"group":"order",
										"len":255
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"readOnly":true,
										"fieldLabel":"Quantity Approved By",
										"allowBlank":true,
										"sequence":6,
										"syncEvent":"change",
										"title":"Quantity Approved By",
										"name":"qty_override_by",
										"group":"order"
									},{
										"type":"isotimestampdisplay",
										"native":"true",
										"date":true,
										"time":true,
										"seconds":true,
										"dateformat":"Y-m-d-h.i.s.u",
										"readOnly":true,
										"fieldLabel":"Quantity Approved Date",
										"allowBlank":true,
										"sequence":7,
										"syncEvent":"change",
										"name":"qty_override_date",
										"title":"Quantity Approved Date",
										"group":"order",
										"nulls":"NULL"
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"readOnly":true,
										"fieldLabel":"Id",
										"allowBlank":true,
										"sequence":8,
										"syncEvent":"change",
										"title":"Id",
										"name":"id",
										"group":"order"
									},{
										"type":"entitypicker",
										"dmd":"dmd/portfolio.dmd",
										"entity":"NAVUSRET00",
										"pageSize":20,
										"view":"portfolio",
										"editable":true,
										"readOnly":true,
										"fieldLabel":"Created By",
										"allowBlank":true,
										"syncEvent":"change",
										"title":"Created By",
										"name":"createdby",
										"group":"revisions",
										"sequence":0
									},{
										"type":"isotimestampdisplay",
										"date":true,
										"time":true,
										"seconds":true,
										"dateformat":"Y-m-d-h.i.s.u",
										"readOnly":true,
										"fieldLabel":"Created",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"title":"Created",
										"name":"createdtime",
										"group":"revisions",
										"uitype":"isotimestamp",
										"native":"true"
									},{
										"type":"entitypicker",
										"dmd":"dmd/portfolio.dmd",
										"entity":"NAVUSRET00",
										"pageSize":20,
										"view":"portfolio",
										"editable":true,
										"readOnly":true,
										"fieldLabel":"Changed By",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"name":"changedby",
										"title":"Changed By",
										"group":"revisions",
										"nulls":1
									},{
										"type":"isotimestampdisplay",
										"date":true,
										"time":true,
										"seconds":true,
										"dateformat":"Y-m-d-h.i.s.u",
										"readOnly":true,
										"fieldLabel":"Changed",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"title":"Changed",
										"name":"changedtime",
										"group":"revisions",
										"uitype":"isotimestamp",
										"nulls":1,
										"native":"true"
									}
								]
							},
							"layout":{
							},
							"groups":{
								"customer":{
									"name":"customer",
									"title":"Customer",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":0
								},
								"order":{
									"name":"order",
									"title":"PreOrder",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":1
								},
								"revisions":{
									"name":"revisions",
									"title":"Revisions",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":2
								}
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							},
							"features":{
							},
							"name":"portfolio"
						}
					}
				},
				"name":"PPO",
				"designer":{
					"x":241,
					"y":11,
					"width":200,
					"height":629,
					"lastmodified":1549373297388
				},
				"permission":{
					"add":{
						"form":true,
						"grid":true
					},
					"edit":{
						"form":true,
						"grid":true
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"B",
				"keys":[
					
				],
				"title":"PurchasePreOrder",
				"idColumn":"id"
			},
			"PPOLines":{
				"columns":[
					{
						"type":"integer",
						"name":"id",
						"title":"Id"
					},{
						"type":"varchar(20)",
						"name":"articleid",
						"len":20,
						"title":"Article Id"
					},{
						"type":"decimal(9,0)",
						"name":"article_id",
						"title":"ArticleId - deprecated",
						"len":9
					},{
						"type":"integer",
						"name":"material_id",
						"title":"MaterialId"
					},{
						"type":"integer",
						"name":"quantity",
						"title":"Qty"
					},{
						"type":"decimal(12,2)",
						"name":"costprice",
						"len":12,
						"dec":2,
						"title":"Cost 1000pcs"
					},{
						"type":"date",
						"name":"deliverydate",
						"title":"Delivery Date at Customer",
						"uitype":"date",
						"native":"true"
					},{
						"type":"integer",
						"name":"ppo_id",
						"title":"PPO Id"
					},{
						"type":"char(1)",
						"name":"factory_location",
						"len":1,
						"title":"Factory Location"
					}
				],
				"uiFeatures":{
				},
				"ui":{
					"grids":{
						"portfolio":{
							"features":{
							},
							"columns":[
								{
									"showned":true,
									"name":"id",
									"width":60,
									"title":"Id"
								},{
									"showned":true,
									"name":"article_articleid",
									"mapping":"article.articleid",
									"width":150,
									"title":"Article Id"
								},{
									"showned":true,
									"name":"article_araint",
									"mapping":"article.araint",
									"title":"Article",
									"flex":1
								},{
									"showned":true,
									"name":"material_id",
									"width":100
								},{
									"showned":true,
									"name":"quantity",
									"width":100
								},{
									"showned":true,
									"name":"costprice",
									"width":100
								},{
									"showned":true,
									"name":"deliverydate",
									"width":100
								},{
									"showned":true,
									"name":"factory_location",
									"width":100
								}
							],
							"sortable":true,
							"editable":true,
							"editMode":"window",
							"rowmodel":"rowmodel",
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"article_id"
								},{
									"name":"articleid"
								},{
									"name":"article"
								},{
									"name":"material_id"
								},{
									"name":"quantity"
								},{
									"name":"deliverydate"
								},{
									"name":"costprice"
								},{
									"name":"id"
								},{
									"name":"factory_location"
								},{
									"name":"ppo_id"
								}
							],
							"items":{
								"columns":[
									{
										"name":"article_id",
										"title":"ArticleId - deprecated",
										"type":"decimal",
										"len":9
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"sarticpf",
										"url":"/api/article",
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"asObject":true,
										"fieldLabel":"Article Id",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"fieldParams":[
											{
												"name":"factory_location"
											}
										],
										"title":"Article Id",
										"name":"articleid",
										"len":20
									},{
										"type":"restentitypicker",
										"dmd":"dmd/spi-pk2.dmd",
										"entity":"sarticpf",
										"url":"/api/article",
										"fieldParams":[
											{
												"name":"factory_location"
											}
										],
										"limitParam":"size",
										"queryParam":"search",
										"rootProperty":"rows",
										"totalProperty":"totalRows",
										"pageSize":20,
										"editable":true,
										"fieldLabel":"Article",
										"allowBlank":true,
										"syncEvent":"change",
										"name":"article",
										"title":"article",
										"group":"data"
									},{
										"type":"number",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"MaterialId",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"title":"MaterialId",
										"name":"material_id",
										"group":"data"
									},{
										"type":"number",
										"decimalPrecision":2,
										"allowDecimals":true,
										"fieldLabel":"Qty",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"title":"Qty",
										"name":"quantity",
										"group":"data"
									},{
										"type":"date",
										"format":"m/d/Y",
										"submitFormat":"Y-m-d",
										"fieldLabel":"Delivery Date at Customer",
										"allowBlank":true,
										"sequence":3,
										"syncEvent":"change",
										"title":"Delivery Date at Customer",
										"name":"deliverydate",
										"group":"data",
										"uitype":"date",
										"native":"true"
									},{
										"type":"number",
										"decimalPrecision":2,
										"allowDecimals":true,
										"forcePrecision":true,
										"fieldLabel":"Cost 1000pcs",
										"allowBlank":true,
										"sequence":4,
										"syncEvent":"change",
										"title":"Cost 1000pcs",
										"name":"costprice",
										"group":"data",
										"len":12,
										"dec":2
									},{
										"type":"number",
										"decimalPrecision":2,
										"allowDecimals":true,
										"readOnly":true,
										"fieldLabel":"Id",
										"allowBlank":true,
										"syncEvent":"change",
										"name":"id",
										"title":"Id",
										"group":"ids"
									},{
										"type":"varchar",
										"fieldLabel":"Factory Location",
										"allowBlank":true,
										"sequence":1,
										"syncEvent":"change",
										"readOnly":true,
										"name":"factory_location",
										"title":"Factory Location",
										"group":"ids",
										"len":1
									},{
										"type":"number",
										"decimalSeparator":".",
										"decimalPrecision":2,
										"allowDecimals":true,
										"readOnly":true,
										"fieldLabel":"PPO Id",
										"allowBlank":true,
										"sequence":2,
										"syncEvent":"change",
										"title":"PPO Id",
										"name":"ppo_id",
										"group":"ids"
									}
								]
							},
							"layout":{
							},
							"groups":{
								"data":{
									"name":"data",
									"title":"Data",
									"padding":10,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor"
								},
								"ids":{
									"name":"ids",
									"title":"Ids",
									"padding":10,
									"collapsible":true,
									"collapsed":true,
									"defaults":{
										"anchor":"100%",
										"labelWidth":160
									},
									"xtype":"fieldset",
									"layout":"anchor",
									"sequence":1
								}
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							},
							"features":{
							}
						}
					}
				},
				"name":"PPOLines",
				"title":"PPO Lines",
				"idColumn":"id",
				"designer":{
					"x":459,
					"y":10,
					"width":200,
					"height":425,
					"lastmodified":1549277503361
				},
				"permission":{
					"add":{
						"form":true,
						"grid":true
					},
					"edit":{
						"form":true,
						"grid":true
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"C",
				"keys":[
					
				]
			}
		},
		"relations":[
			{
				"between":{
					"entity":"PPOLines",
					"on":[
						{
							"name":"articleid"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"sarticpf",
					"on":[
						{
							"name":"ararti"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"as":"article",
					"title":"article",
					"shownAsChild":{
					}
				},
				"cid":"A",
				"was":"",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"IMLQuantity",
					"occurrence":"one",
					"on":[
						{
							"name":"mould_id"
						}
					]
				},
				"and":{
					"entity":"slomldpf",
					"occurrence":"many",
					"on":[
						{
							"name":"lmstat"
						}
					]
				},
				"id":"",
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					}
				},
				"cid":"B"
			},{
				"was":"",
				"between":{
					"entity":"IMLQuantity",
					"occurrence":"one",
					"on":[
						{
							"name":"material_id"
						}
					]
				},
				"and":{
					"entity":"simlmtpf",
					"occurrence":"many",
					"on":[
						{
							"name":"imilmi"
						}
					]
				},
				"id":"",
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					}
				},
				"cid":"C"
			},{
				"was":"",
				"between":{
					"entity":"IMLQuantity",
					"occurrence":"one",
					"on":[
						{
							"name":"mould_id"
						}
					]
				},
				"and":{
					"entity":"slomldpf",
					"occurrence":"many",
					"on":[
						{
							"name":"lmlgmi"
						}
					]
				},
				"id":"",
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					}
				},
				"cid":"D"
			}
		],
		"languages":{
			"da":{
				"text":{
				}
			},
			"en":{
				"text":{
				}
			}
		},
		"navigator":{
		},
		"menu":{
		},
		"generate":{
			"tables":true,
			"views":true,
			"primaryKey":true,
			"constraints":true,
			"version":false
		},
		"name":"spippo",
		"title":"Superfos ppo DB",
		"header":"#cbd0d5",
		"text":"#000000",
		"require":[
			"/www/dev/basext/customized/dmd/spi-pk2.dmd"
		],
		"version":false
	}
}