{
	"model":{
		"proxy":{
			"defaultHive":"ip2-services/",
			"url":"ip2dmdProxy.aspx",
			"portfolio":true,
			"reader":{
				"type":"json",
				"rootProperty":"rows",
				"totalProperty":"totalRows"
			},
			"write":{
				"type":"json",
				"writeAllFields":false
			},
			"actionMethods":{
				"create":"POST",
				"read":"GET",
				"update":"POST",
				"destroy":"POST"
			},
			"xtype":"Ext.data.proxy.Ajax",
			"limitParam":"limit"
		},
		"API":{
			"eventHandler":"ip2-services/ip2dmdProxy.aspx"
		},
		"entities":{
			"Custbal":{
				"temp":{
					"newEntity":true
				},
				"title":"Customer Balances",
				"primaryKey":[
					"Custref"
				],
				"columns":[
					{
						"title":"Customer Code",
						"ccsid":285,
						"type":"char(10)",
						"name":"Custref",
						"len":10
					},{
						"title":"Current Balance",
						"type":"decimal(9,2)",
						"name":"Balance",
						"len":9,
						"dec":2
					},{
						"title":"Aged 30 days",
						"type":"decimal(9,2)",
						"name":"Aged30",
						"len":9,
						"dec":2
					},{
						"title":"Aged 60 days",
						"type":"decimal(9,2)",
						"name":"Aged60",
						"len":9,
						"dec":2
					},{
						"title":"Aged 90 days",
						"type":"decimal(9,2)",
						"name":"Aged90",
						"len":9,
						"dec":2
					},{
						"title":"Aged 120+ days",
						"type":"decimal(9,2)",
						"name":"Aged120",
						"len":9,
						"dec":2
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Custref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Balance",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Aged30",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Aged60",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Aged90",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Aged120",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Custref"
								},{
									"name":"Balance"
								},{
									"name":"Aged30"
								},{
									"name":"Aged60"
								},{
									"name":"Aged90"
								},{
									"name":"Aged120"
								}
							],
							"items":[
								{
									"name":"Custref",
									"title":"Customer Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Balance",
									"title":"Current Balance",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Aged30",
									"title":"Aged 30 days",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Aged60",
									"title":"Aged 60 days",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Aged90",
									"title":"Aged 90 days",
									"hostiable":false,
									"sequence":4
								},{
									"name":"Aged120",
									"title":"Aged 120+ days",
									"hostiable":false,
									"sequence":5
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":10,
					"y":10,
					"width":200,
					"height":133,
					"lastmodified":1560943894149
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"A",
				"name":"Custbal",
				"menuEntryPoint":false,
				"keys":[
					
				]
			},
			"Salesdly":{
				"temp":{
					"newEntity":true
				},
				"title":"Sales Order Delivery Address",
				"primaryKey":[
					"Orderref"
				],
				"columns":[
					{
						"title":"Order Number",
						"ccsid":285,
						"type":"char(6)",
						"name":"Orderref",
						"len":6
					},{
						"title":"Delivery Address Lin",
						"ccsid":285,
						"type":"char(40)",
						"name":"Dlyaddr1",
						"len":40
					},{
						"title":"Delivery Address Lin",
						"ccsid":285,
						"type":"char(40)",
						"name":"Dlyaddr2",
						"len":40
					},{
						"title":"Delivery Address Lin",
						"ccsid":285,
						"type":"char(40)",
						"name":"Dlyaddr3",
						"len":40
					},{
						"title":"Delivery Address Lin",
						"ccsid":285,
						"type":"char(40)",
						"name":"Dlyaddr4",
						"len":40
					},{
						"title":"Delivery Postcode",
						"ccsid":285,
						"type":"char(10)",
						"name":"Dlypost",
						"len":10
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Orderref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Dlyaddr1",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Dlyaddr2",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Dlyaddr3",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Dlyaddr4",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Dlypost",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Orderref"
								},{
									"name":"Dlyaddr1"
								},{
									"name":"Dlyaddr2"
								},{
									"name":"Dlyaddr3"
								},{
									"name":"Dlyaddr4"
								},{
									"name":"Dlypost"
								}
							],
							"items":[
								{
									"name":"Orderref",
									"title":"Order Number",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Dlyaddr1",
									"title":"Delivery Address Lin",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Dlyaddr2",
									"title":"Delivery Address Lin",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Dlyaddr3",
									"title":"Delivery Address Lin",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Dlyaddr4",
									"title":"Delivery Address Lin",
									"hostiable":false,
									"sequence":4
								},{
									"name":"Dlypost",
									"title":"Delivery Postcode",
									"hostiable":false,
									"sequence":5
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":670,
					"y":10,
					"width":200,
					"height":130,
					"lastmodified":1560943913844
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"B",
				"name":"Salesdly",
				"menuEntryPoint":false,
				"keys":[
					
				]
			},
			"Salesdtl":{
				"temp":{
					"newEntity":true
				},
				"title":"Sales Order Details",
				"primaryKey":[
					"Orderref","Orderline"
				],
				"columns":[
					{
						"title":"Order Number",
						"ccsid":285,
						"type":"char(6)",
						"name":"Orderref",
						"len":6
					},{
						"title":"Order Line Number",
						"edtcde":"3",
						"type":"decimal(3,0)",
						"name":"Orderline",
						"len":3
					},{
						"title":"Product Code",
						"ccsid":285,
						"type":"char(20)",
						"name":"Prodref",
						"len":20
					},{
						"title":"Warehouse Code",
						"ccsid":285,
						"type":"char(3)",
						"name":"Warehse",
						"len":3
					},{
						"title":"Qty Ordered",
						"edtcde":"L",
						"type":"decimal(7,0)",
						"name":"Orderqty",
						"len":7
					},{
						"title":"Qty Allocated for De",
						"edtcde":"L",
						"type":"decimal(7,0)",
						"name":"Delryqty",
						"len":7
					},{
						"title":"Total Sale Price",
						"edtcde":"J",
						"type":"decimal(9,2)",
						"name":"Saletotal",
						"len":9,
						"dec":2
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Orderline",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Prodref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Warehse",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Orderqty",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Delryqty",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Saletotal",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Orderref"
								},{
									"name":"Orderline"
								},{
									"name":"Prodref"
								},{
									"name":"Warehse"
								},{
									"name":"Orderqty"
								},{
									"name":"Delryqty"
								},{
									"name":"Saletotal"
								}
							],
							"items":[
								{
									"name":"Orderref",
									"title":"Order Number",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Orderline",
									"title":"Order Line Number",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Prodref",
									"title":"Product Code",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Warehse",
									"title":"Warehouse Code",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Orderqty",
									"title":"Qty Ordered",
									"hostiable":false,
									"sequence":4
								},{
									"name":"Delryqty",
									"title":"Qty Allocated for De",
									"hostiable":false,
									"sequence":5
								},{
									"name":"Saletotal",
									"title":"Total Sale Price",
									"hostiable":false,
									"sequence":6
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":450,
					"y":160,
					"width":200,
					"height":133,
					"lastmodified":1560944251978
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"C",
				"name":"Salesdtl",
				"menuEntryPoint":false,
				"keys":[
					
				]
			},
			"Saleshdr":{
				"temp":{
					"newEntity":true
				},
				"title":"Sales Order Header",
				"primaryKey":[
					"Orderref"
				],
				"columns":[
					{
						"title":"Order Number",
						"ccsid":285,
						"type":"char(6)",
						"name":"Orderref",
						"len":6
					},{
						"title":"Customer Code",
						"ccsid":285,
						"type":"char(10)",
						"name":"Custref",
						"len":10
					},{
						"title":"Order Date",
						"uitype":"date",
						"type":"date",
						"name":"Orderdate"
					},{
						"title":"Required Date",
						"uitype":"date",
						"type":"date",
						"name":"Reqrddate"
					},{
						"title":"Status",
						"type":"decimal(3,0)",
						"name":"Status",
						"len":3
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Orderref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Custref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Orderdate",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Reqrddate",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Status",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Orderref"
								},{
									"name":"Custref"
								},{
									"name":"Orderdate"
								},{
									"name":"Reqrddate"
								},{
									"name":"Status"
								}
							],
							"items":[
								{
									"name":"Orderref",
									"title":"Order Number",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Custref",
									"title":"Customer Code",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Orderdate",
									"title":"Order Date",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Reqrddate",
									"title":"Required Date",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Status",
									"title":"Status",
									"hostiable":false,
									"sequence":4
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":450,
					"y":10,
					"width":200,
					"height":133,
					"lastmodified":1560944124906
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"D",
				"name":"Saleshdr",
				"menuEntryPoint":true,
				"keys":[
					
				]
			},
			"Custmast":{
				"title":"Customer Master",
				"primaryKey":[
					"Custref"
				],
				"columns":[
					{
						"title":"Customer Code",
						"ccsid":285,
						"type":"char(10)",
						"name":"Custref",
						"len":10
					},{
						"title":"Customer Name",
						"ccsid":285,
						"uitype":"searchField",
						"isTitle":true,
						"type":"char(50)",
						"name":"Name",
						"len":50
					},{
						"title":"Customer Short Name",
						"ccsid":285,
						"type":"char(10)",
						"name":"Shortname",
						"len":10
					},{
						"title":"Address Line 1",
						"ccsid":285,
						"isTitle":true,
						"type":"char(49)",
						"name":"Address1",
						"len":49
					},{
						"title":"Address Line 2",
						"ccsid":285,
						"isTitle":true,
						"type":"char(40)",
						"name":"Address2",
						"len":40
					},{
						"title":"Address Line 3",
						"ccsid":285,
						"type":"char(40)",
						"name":"Address3",
						"len":40
					},{
						"title":"Address Line 4",
						"ccsid":285,
						"type":"char(40)",
						"name":"Address4",
						"len":40
					},{
						"title":"Postcode",
						"ccsid":285,
						"isTitle":true,
						"type":"char(10)",
						"name":"Postcode",
						"len":10
					},{
						"title":"Credit Limit",
						"edtcde":"J",
						"type":"decimal(9,0)",
						"name":"Credlmt",
						"len":9
					},{
						"title":"Phone Number",
						"ccsid":285,
						"type":"char(20)",
						"name":"Phone",
						"len":20
					},{
						"title":"Website Address",
						"ccsid":285,
						"type":"char(50)",
						"name":"Website",
						"len":50
					},{
						"title":"Customer Contact Nam",
						"ccsid":285,
						"type":"char(40)",
						"name":"Contact",
						"len":40
					}
				],
				"uiFeatures":{
				},
				"ui":{
					"grids":{
						"commonAll":{
							"columns":[
								{
									"showned":true,
									"name":"Custref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Name",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Shortname",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Address1",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Address2",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Address3",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Address4",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Postcode",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Credlmt",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Phone",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Website",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Contact",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						},
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Custref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Name",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Shortname",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Postcode",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Credlmt",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Phone",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Website",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Contact",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Custref"
								},{
									"name":"Name"
								},{
									"name":"Shortname"
								},{
									"name":"Address1"
								},{
									"name":"Address2"
								},{
									"name":"Address3"
								},{
									"name":"Address4"
								},{
									"name":"Postcode"
								},{
									"name":"Credlmt"
								},{
									"name":"Phone"
								},{
									"name":"Website"
								},{
									"name":"Contact"
								}
							],
							"items":[
								{
									"name":"Custref",
									"title":"Customer Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Name",
									"title":"Customer Name",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Shortname",
									"title":"Customer Short Name",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Address1",
									"title":"Address Line 1",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Address2",
									"title":"Address Line 2",
									"hostiable":false,
									"sequence":4
								},{
									"name":"Address3",
									"title":"Address Line 3",
									"hostiable":false,
									"sequence":5
								},{
									"name":"Address4",
									"title":"Address Line 4",
									"hostiable":false,
									"sequence":6
								},{
									"name":"Postcode",
									"title":"Postcode",
									"hostiable":false,
									"sequence":7
								},{
									"name":"Credlmt",
									"title":"Credit Limit",
									"hostiable":false,
									"sequence":8
								},{
									"name":"Phone",
									"title":"Phone Number",
									"hostiable":false,
									"sequence":9
								},{
									"name":"Website",
									"title":"Website Address",
									"hostiable":false,
									"sequence":10
								},{
									"name":"Contact",
									"title":"Customer Contact Nam",
									"hostiable":false,
									"sequence":11
								}
							],
							"layout":{
								"Bing":{
									"renderAs":"tab"
								},
								"Map":{
									"renderAs":"portlet",
									"position":{
										"row":1,
										"column":2
									}
								},
								"Saleshdr":{
									"renderAs":"childtab"
								},
								"Stats":{
									"renderAs":"childtab"
								}
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":230,
					"y":10,
					"width":200,
					"height":133,
					"lastmodified":1560943898971
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"affiliations":{
					"Bing":{
						"title":"Search the net",
						"url":"'http://www.bing.com/search?q=' CONCAT urlencode(name)",
						"renderAs":"fulltab"
					},
					"Map":{
						"title":"Map",
						"url":"'http://www.icebreak.org/geoCoding.html?address='  CONCAT name CONCAT ',' CONCAT address1 CONCAT ',' CONCAT postcode",
						"renderAs":"portlet",
						"position":{
							"row":1,
							"column":2
						},
						"cls":"affiliation"
					}
				},
				"widgets":{
				},
				"cid":"E",
				"name":"Custmast",
				"menuEntryPoint":true,
				"keys":[
					
				]
			},
			"Stocklvl":{
				"temp":{
					"newEntity":true
				},
				"title":"Stock Levels",
				"primaryKey":[
					"Prodref","Warehse"
				],
				"columns":[
					{
						"title":"Product Code",
						"ccsid":285,
						"type":"char(20)",
						"name":"Prodref",
						"len":20
					},{
						"title":"Warehouse Code",
						"ccsid":285,
						"type":"char(3)",
						"name":"Warehse",
						"len":3
					},{
						"title":"Qty In Stock",
						"edtcde":"L",
						"type":"decimal(7,0)",
						"name":"Stockqty",
						"len":7
					},{
						"title":"Qty Allocated",
						"edtcde":"L",
						"type":"decimal(7,0)",
						"name":"Allocqty",
						"len":7
					},{
						"title":"Qty on Purchase Orde",
						"edtcde":"L",
						"type":"decimal(7,0)",
						"name":"Purchqty",
						"len":7
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Prodref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Proddesc1",
									"flex":1,
									"as":"Prodmast_Proddesc1",
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Warehse",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Waredesc",
									"flex":1,
									"as":"Waremast_Waredesc",
									"hidden":false,
									"hide":false,
									"isTitle":true
								},{
									"showned":true,
									"name":"Stockqty",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Allocqty",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Purchqty",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								{
									"dataIndex":"Proddesc1",
									"dataType":"string",
									"dataDateType":"datetime",
									"isString":false,
									"multiSelect":false,
									"sortDirection":"ASC",
									"overRuleable":true,
									"dmd":{
									},
									"checkboxes":[
										false,false
									],
									"fieldValues":[
										"",""
									],
									"notValue":false,
									"values":[
										
									]
								}
							],
							"sort":"Proddesc1 ASC"
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Prodref"
								},{
									"name":"Warehse"
								},{
									"name":"Stockqty"
								},{
									"name":"Allocqty"
								},{
									"name":"Purchqty"
								}
							],
							"items":[
								{
									"name":"Prodref",
									"title":"Product Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Warehse",
									"title":"Warehouse Code",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Stockqty",
									"title":"Qty In Stock",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Allocqty",
									"title":"Qty Allocated",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Purchqty",
									"title":"Qty on Purchase Orde",
									"hostiable":false,
									"sequence":4
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":670,
					"y":310,
					"width":200,
					"height":133,
					"lastmodified":1561367913758
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"keys":[
					
				],
				"cid":"F",
				"name":"Stocklvl",
				"menuEntryPoint":true
			},
			"Stats":{
				"temp":{
					"newEntity":true
				},
				"title":"Sales Statistics",
				"primaryKey":[
					"Custref","Prodref"
				],
				"columns":[
					{
						"title":"Customer Code",
						"ccsid":285,
						"type":"char(10)",
						"name":"Custref",
						"len":10
					},{
						"title":"Product Code",
						"ccsid":285,
						"type":"char(20)",
						"name":"Prodref",
						"len":20
					},{
						"title":"Sales YTD",
						"edtcde":"J",
						"type":"decimal(9,2)",
						"name":"Salesytd",
						"len":9,
						"dec":2
					},{
						"title":"Sales Current Qtr",
						"edtcde":"J",
						"type":"decimal(9,2)",
						"name":"Salesqtr",
						"len":9,
						"dec":2
					},{
						"title":"Sales Current Mth",
						"edtcde":"J",
						"type":"decimal(9,2)",
						"name":"Salesmth",
						"len":9,
						"dec":2
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Custref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Prodref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Salesytd",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Salesqtr",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Salesmth",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Custref"
								},{
									"name":"Prodref"
								},{
									"name":"Salesytd"
								},{
									"name":"Salesqtr"
								},{
									"name":"Salesmth"
								}
							],
							"items":[
								{
									"name":"Custref",
									"title":"Customer Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Prodref",
									"title":"Product Code",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Salesytd",
									"title":"Sales YTD",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Salesqtr",
									"title":"Sales Current Qtr",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Salesmth",
									"title":"Sales Current Mth",
									"hostiable":false,
									"sequence":4
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":230,
					"y":310,
					"width":200,
					"height":133,
					"lastmodified":1560943927897
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"G",
				"name":"Stats",
				"menuEntryPoint":false,
				"keys":[
					
				]
			},
			"Prodmast":{
				"temp":{
					"newEntity":true
				},
				"title":{
					"en":"Product Master",
					"da":"Prdukt register"
				},
				"primaryKey":[
					"Prodref"
				],
				"columns":[
					{
						"title":"Product Code",
						"ccsid":285,
						"type":"char(20)",
						"name":"Prodref",
						"len":20
					},{
						"title":"Product Description",
						"ccsid":285,
						"type":"char(40)",
						"name":"Proddesc1",
						"len":40
					},{
						"title":"Product Description",
						"ccsid":285,
						"type":"char(40)",
						"name":"Proddesc2",
						"len":40
					},{
						"title":"Retail Price",
						"edtcde":"J",
						"type":"decimal(7,2)",
						"name":"Saleprice",
						"len":7,
						"dec":2
					},{
						"title":"Cost Price",
						"edtcde":"J",
						"type":"decimal(7,2)",
						"name":"Costprice",
						"len":7,
						"dec":2
					},{
						"title":"Link to Product Imag",
						"ccsid":285,
						"type":"char(50)",
						"name":"Image",
						"len":50
					},{
						"title":"Link to Product Spec",
						"ccsid":285,
						"type":"char(50)",
						"name":"Spec",
						"len":50
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Prodref",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Proddesc1",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Proddesc2",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Saleprice",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Costprice",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Image",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Spec",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Prodref"
								},{
									"name":"Proddesc1"
								},{
									"name":"Proddesc2"
								},{
									"name":"Saleprice"
								},{
									"name":"Costprice"
								},{
									"name":"Image"
								},{
									"name":"Spec"
								}
							],
							"items":[
								{
									"name":"Prodref",
									"title":"Product Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Proddesc1",
									"title":"Product Description",
									"hostiable":false,
									"sequence":1
								},{
									"name":"Proddesc2",
									"title":"Product Description",
									"hostiable":false,
									"sequence":2
								},{
									"name":"Saleprice",
									"title":"Retail Price",
									"hostiable":false,
									"sequence":3
								},{
									"name":"Costprice",
									"title":"Cost Price",
									"hostiable":false,
									"sequence":4
								},{
									"name":"Image",
									"title":"Link to Product Imag",
									"hostiable":false,
									"sequence":5
								},{
									"name":"Spec",
									"title":"Link to Product Spec",
									"hostiable":false,
									"sequence":6
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":450,
					"y":310,
					"width":200,
					"height":133,
					"lastmodified":1560943933279
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"form":true,
						"grid":false
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"H",
				"widgets":{
				},
				"name":"Prodmast",
				"menuEntryPoint":true,
				"keys":[
					
				]
			},
			"Waremast":{
				"temp":{
					"newEntity":true
				},
				"title":"Warehouse Master",
				"primaryKey":[
					"Warehse"
				],
				"columns":[
					{
						"title":"Warehouse Code",
						"ccsid":285,
						"type":"char(3)",
						"name":"Warehse",
						"len":3
					},{
						"title":"Warehouse Descriptio",
						"ccsid":285,
						"type":"char(40)",
						"name":"Waredesc",
						"len":40
					}
				],
				"ui":{
					"grids":{
						"portfolio":{
							"columns":[
								{
									"showned":true,
									"name":"Warehse",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								},{
									"showned":true,
									"name":"Waredesc",
									"flex":1,
									"hidden":false,
									"hide":false,
									"isTitle":false
								}
							],
							"sortable":true,
							"editMode":"tab",
							"rowmodel":"rowmodel",
							"features":{
							},
							"filters":[
								
							]
						}
					},
					"forms":{
						"portfolio":{
							"columns":[
								{
									"name":"Warehse"
								},{
									"name":"Waredesc"
								}
							],
							"items":[
								{
									"name":"Warehse",
									"title":"Warehouse Code",
									"hostiable":false,
									"sequence":0
								},{
									"name":"Waredesc",
									"title":"Warehouse Descriptio",
									"hostiable":false,
									"sequence":1
								}
							],
							"layout":{
							},
							"groups":{
							},
							"relation":[
								
							],
							"affilations":[
								
							],
							"widgets":{
							}
						}
					}
				},
				"designer":{
					"x":890,
					"y":310,
					"width":200,
					"height":133,
					"lastmodified":1560943943876
				},
				"permission":{
					"add":{
						"form":true
					},
					"edit":{
						"grid":true,
						"form":true
					},
					"remove":{
						"grid":true,
						"form":true
					}
				},
				"cid":"I",
				"name":"Waremast",
				"menuEntryPoint":true,
				"keys":[
					
				]
			}
		},
		"languages":{
			"da":{
				"text":{
					"aged 120+ days":"Over 120 dage",
					"aged 30 days":"Over 30 dage",
					"aged 60 days":"Over 60 dage",
					"aged 90 days":"Over 90 dage",
					"customer master":"Kunde master",
					"portfolio demo":"Portfolio Demo",
					"product master":"Prdukt register",
					"product code":"Produkt Kode"
				}
			},
			"en":{
				"text":{
					"customer master":"Customer master",
					"product master":"Product Master",
					"product code":"Product Code"
				}
			}
		},
		"relations":[
			{
				"between":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Salesdly",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"J"
				},
				"cid":"A",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"K"
				},
				"cid":"B",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Waremast",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":true
					},
					"cid":"L"
				},
				"cid":"C",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Stocklvl",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Waremast",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":true
					},
					"cid":"M"
				},
				"cid":"D",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Custbal",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"N"
				},
				"cid":"E",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"O"
				},
				"cid":"F",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Stats",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":true
					},
					"cid":"P"
				},
				"cid":"G",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"Q"
				},
				"cid":"H",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Stats",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"R"
				},
				"cid":"I",
				"was":"",
				"id":""
			},{
				"between":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Stocklvl",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"S"
				},
				"cid":"J",
				"was":"",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Custbal",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"N"
				},
				"cid":"K",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"O"
				},
				"cid":"L",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Salesdly",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"J"
				},
				"cid":"M",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Saleshdr",
					"on":[
						{
							"name":"Orderref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"K"
				},
				"cid":"N",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Stats",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Custmast",
					"on":[
						{
							"name":"Custref"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":true
					},
					"cid":"P"
				},
				"cid":"O",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Stats",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"R"
				},
				"cid":"P",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":false
					},
					"cid":"Q"
				},
				"cid":"Q",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Stocklvl",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"many"
				},
				"and":{
					"entity":"Prodmast",
					"on":[
						{
							"name":"Prodref"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":true,
						"and":false
					},
					"cid":"S"
				},
				"cid":"R",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Waremast",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Salesdtl",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":true
					},
					"cid":"L"
				},
				"cid":"S",
				"id":""
			},{
				"was":"",
				"between":{
					"entity":"Waremast",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"one"
				},
				"and":{
					"entity":"Stocklvl",
					"on":[
						{
							"name":"Warehse"
						}
					],
					"occurrence":"many"
				},
				"properties":{
					"shownAsChild":{
						"between":false,
						"and":true
					},
					"cid":"M"
				},
				"cid":"T",
				"id":""
			}
		],
		"menu":[
			{
				"type":"entity",
				"entity":"Custmast"
			},{
				"type":"entity",
				"entity":"Prodmast"
			},{
				"type":"entity",
				"entity":"Saleshdr"
			},{
				"type":"entity",
				"entity":"Waremast"
			},{
				"type":"entity",
				"entity":"Stocklvl"
			},{
				"type":"dmd",
				"title":"Domain Model Designer"
			},{
				"type":"link",
				"url":"http://www.system-metode.dk",
				"title":"System & Metode",
				"icon":"/system/images/icons/16x16/link.png"
			}
		],
		"navigator":{
			"system":5
		},
		"name":"PORTFDEMO",
		"title":"Portfolio Demo",
		"types":{
		},
		"designer":{
			"slider":200
		},
		"generate":{
			"tables":true,
			"views":true,
			"primaryKey":true,
			"constraints":true,
			"version":false
		},
		"header":"#cbd0d5",
		"text":"#000000",
		"ccsid":"",
		"prefix":"",
		"version":false
	}
}