var designer_type = {
	type1: {
		"success": true,
		"data": {
			"plan": {
				"id": "P002",
				"name": "2022经销商折扣政策A",
				"statecode": "Input",
				"buckets": [
					{
						"code": "record-list-Bucket",
						"name": "协议条款",
						"children": [
							{
								"code": "agreementList",
								"name": "折扣条款-零售补偿",
								"dimension": "Tag",
								"size": 20,
								"columncount": 17,
								"children": [
									{ "id": "record-03", "bandid": "record_list", "code": "state_name", "name": "状态", "fieldname": "state_name", "expression": "[折扣条款-零售补偿].[状态]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-04", "bandid": "record_list", "code": "code", "name": "备案号", "fieldname": "code", "expression": "[折扣条款-零售补偿].[备案号]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-05", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[折扣条款-零售补偿].[备案类型]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-06", "bandid": "record_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[折扣条款-零售补偿].[经销商编码]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-07", "bandid": "record_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[折扣条款-零售补偿].[经销商名称]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-08", "bandid": "record_list", "code": "terminal_code", "name": "终端编码", "fieldname": "terminal_code", "expression": "[折扣条款-零售补偿].[终端编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-09", "bandid": "record_list", "code": "terminal_name", "name": "终端名称", "fieldname": "terminal_name", "expression": "[折扣条款-零售补偿].[终端名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-10", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[折扣条款-零售补偿].[产品编码]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-11", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[折扣条款-零售补偿].[产品名称]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-12", "bandid": "record_list", "code": "terminal_type", "name": "终端类型", "fieldname": "terminal_type", "expression": "[折扣条款-零售补偿].[终端类型]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-13", "bandid": "record_list", "code": "terminal_province", "name": "终端省份", "fieldname": "terminal_province", "expression": "[折扣条款-零售补偿].[终端省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-14", "bandid": "record_list", "code": "price_raw", "name": "销售单价", "fieldname": "price_raw", "expression": "[折扣条款-零售补偿].[销售单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-15", "bandid": "record_list", "code": "versionno", "name": "版本号", "fieldname": "versionno", "expression": "[折扣条款-零售补偿].[版本号]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-16", "bandid": "record_list", "code": "spec", "name": "规格", "fieldname": "spec", "expression": "[折扣条款-零售补偿].[规格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-17", "bandid": "record_list", "code": "terminal_city", "name": "终端城市", "fieldname": "terminal_city", "expression": "[折扣条款-零售补偿].[终端城市]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-18", "bandid": "record_list", "code": "batchno", "name": "备案批号", "fieldname": "batchno", "expression": "[折扣条款-零售补偿].[备案批号]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-19", "bandid": "record_list", "code": "customer_province", "name": "区域省份", "fieldname": "customer_province", "expression": "[折扣条款-零售补偿].[区域省份]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-20", "bandid": "record_list", "code": "tiered_rebate_rate_name", "name": "阶梯折扣率名称", "fieldname": "tiered_rebate_rate_name", "expression": "[折扣条款-零售补偿].[阶梯折扣率名称]", "indexno": 17, "ismeasure": false, "isshow": false, "isused": false, "fields": false}
								]
							}
						]
					},
					{
						"code": "flow-list-Bucket",
						"name": "业务数据",
						"children": [
							{
								"code": "terminalsale",
								"name": "流向-终端纯销",
								"dimension": "Tag",
								"size": 120,
								"columncount": 17,
								"children": [
									{ "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "code", "name": "编码", "fieldname": "code", "expression": "[流向-终端纯销].[编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[流向-终端纯销].[年份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[流向-终端纯销].[月份]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[流向-终端纯销].[流向日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省份", "fieldname": "supplyer_province", "expression": "[流向-终端纯销].[上游省份]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游城市", "fieldname": "supplyer_city", "expression": "[流向-终端纯销].[上游城市]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[流向-终端纯销].[上游编码]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[流向-终端纯销].[上游名称]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_province", "name": "下游省份", "fieldname": "customer_province", "expression": "[流向-终端纯销].[下游省份]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_city", "name": "下游城市", "fieldname": "customer_city", "expression": "[流向-终端纯销].[下游城市]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_code", "name": "下游编码", "fieldname": "customer_code", "expression": "[流向-终端纯销].[下游编码]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_name", "name": "下游名称", "fieldname": "customer_name", "expression": "[流向-终端纯销].[下游名称]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[流向-终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[流向-终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[流向-终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "价格", "fieldname": "price", "expression": "[流向-终端纯销].[价格]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false}
								]
							},
						]
					}
				],
				"workbook": {
					"id": "rebate_test",
					"planid": "P002",
					"code": "rebate_test",
					"bandid": "record_list",
					"typecode": "main",
					"no": 2,
					"columns": [
						{ "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "年份", "bandid": "agreementList", "bandcolumn": "year", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[折扣条款-零售补偿].[年份]", "orderno": 0, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "季度", "bandid": "agreementList", "bandcolumn": "season", "bookfield": "xtek60eyng85", "variant": "", "expression": "[折扣条款-零售补偿].[季度]", "orderno": 1, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "折扣名称", "bandid": "agreementList", "bandcolumn": "fee_name", "bookfield": "bqof64azwg09", "variant": "", "expression": "[折扣条款-零售补偿].[折扣名称]", "orderno": 2, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "备案号", "bandid": "agreementList", "bandcolumn": "code", "bookfield": "mph0hre275nu", "variant": "", "expression": "[折扣条款-零售补偿].[备案号]", "orderno": 3, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "协议编码", "bandid": "agreementList", "bandcolumn": "agreement_code", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[折扣条款-零售补偿].[协议编码]", "orderno": 4, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "客户-编码", "bandid": "agreementList", "bandcolumn": "customer_code", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[折扣条款-零售补偿].[客户-编码]", "orderno": 5, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "客户-名称", "bandid": "agreementList", "bandcolumn": "customer_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[折扣条款-零售补偿].[客户-名称]", "orderno": 6, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "终端编码", "bandid": "agreementList", "bandcolumn": "terminal_code", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[折扣条款-零售补偿].[终端编码]", "orderno": 7, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "终端名称", "bandid": "agreementList", "bandcolumn": "terminal_name", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[折扣条款-零售补偿].[终端名称]", "orderno": 8, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "产品-编码", "bandid": "factorysale", "bandcolumn": "product_code", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[工厂发货].[产品-编码]", "orderno": 9, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "产品-名称", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[折扣条款-零售补偿].[产品-名称]", "orderno": 10, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "规格", "bandid": "agreementList", "bandcolumn": "spec", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "[折扣条款-零售补偿].[规格]", "orderno": 11, "align": "center", "formatter": "text", "width": "1"},
						/////
						{ "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[折扣条款-零售补偿].[流向数量]", "orderno": 12, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "销售金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[折扣条款-零售补偿].[销售金额]", "orderno": 13, "align": "right", "formatter": "money", "width": "1"},
						{ "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "存量金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[折扣条款-零售补偿].[存量金额]", "orderno": 14, "align": "right", "formatter": "money", "width": "1"},
						{ "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "扣率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[折扣条款-零售补偿].[扣率]", "orderno": 15, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "差额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[销售金额]-[存量金额]", "orderno": 16, "align": "right", "formatter": "money", "width": "1"},
						{ "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "([销售金额]-[存量金额])×[扣率]", "orderno": 17, "align": "right", "formatter": "money", "width": "1"},
						
						
					]
				}
			}
		}
	},
	
	type2: {
		"success": true,
		"data": {
			"plan": {
				"id": "P005",
				"name": "Sale-In 达成奖励",
				"statecode": "Input",
				"buckets": [
					{
						"code": "record-list-Bucket",
						"name": "协议条款",
						"children": [
							{
								"code": "agreementList",
								"name": "折扣条款-指标达成",
								"dimension": "Tag",
								"size": 20,
								"columncount": 17,
								"children": [
									{ "id": "record-03", "bandid": "record_list", "code": "state_name", "name": "状态", "fieldname": "state_name", "expression": "[折扣条款-零售补偿].[状态]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-04", "bandid": "record_list", "code": "code", "name": "备案号", "fieldname": "code", "expression": "[折扣条款-零售补偿].[备案号]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-05", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[折扣条款-零售补偿].[备案类型]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-06", "bandid": "record_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[折扣条款-零售补偿].[经销商编码]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-07", "bandid": "record_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[折扣条款-零售补偿].[经销商名称]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-08", "bandid": "record_list", "code": "terminal_code", "name": "终端编码", "fieldname": "terminal_code", "expression": "[折扣条款-零售补偿].[终端编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-09", "bandid": "record_list", "code": "terminal_name", "name": "终端名称", "fieldname": "terminal_name", "expression": "[折扣条款-零售补偿].[终端名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-10", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[折扣条款-零售补偿].[产品编码]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-11", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[折扣条款-零售补偿].[产品名称]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-12", "bandid": "record_list", "code": "terminal_type", "name": "终端类型", "fieldname": "terminal_type", "expression": "[折扣条款-零售补偿].[终端类型]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-13", "bandid": "record_list", "code": "terminal_province", "name": "终端省份", "fieldname": "terminal_province", "expression": "[折扣条款-零售补偿].[终端省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-14", "bandid": "record_list", "code": "price_raw", "name": "销售单价", "fieldname": "price_raw", "expression": "[折扣条款-零售补偿].[销售单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-15", "bandid": "record_list", "code": "versionno", "name": "版本号", "fieldname": "versionno", "expression": "[折扣条款-零售补偿].[版本号]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-16", "bandid": "record_list", "code": "spec", "name": "规格", "fieldname": "spec", "expression": "[折扣条款-零售补偿].[规格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-17", "bandid": "record_list", "code": "terminal_city", "name": "终端城市", "fieldname": "terminal_city", "expression": "[折扣条款-零售补偿].[终端城市]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-18", "bandid": "record_list", "code": "batchno", "name": "备案批号", "fieldname": "batchno", "expression": "[折扣条款-零售补偿].[备案批号]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-19", "bandid": "record_list", "code": "customer_province", "name": "区域省份", "fieldname": "customer_province", "expression": "[折扣条款-零售补偿].[区域省份]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-20", "bandid": "record_list", "code": "tiered_rebate_rate_name", "name": "阶梯折扣率名称", "fieldname": "tiered_rebate_rate_name", "expression": "[折扣条款-零售补偿].[阶梯折扣率名称]", "indexno": 17, "ismeasure": false, "isshow": false, "isused": false, "fields": false}
								]
							}
						]
					},
					{
						"code": "flow-list-Bucket",
						"name": "业务数据",
						"children": [
							{
								"code": "terminalsale",
								"name": "流向-采购流向",
								"dimension": "Tag",
								"size": 120,
								"columncount": 17,
								"children": [
									{ "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "code", "name": "编码", "fieldname": "code", "expression": "[流向-终端纯销].[编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[流向-终端纯销].[年份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[流向-终端纯销].[月份]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[流向-终端纯销].[流向日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省份", "fieldname": "supplyer_province", "expression": "[流向-终端纯销].[上游省份]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游城市", "fieldname": "supplyer_city", "expression": "[流向-终端纯销].[上游城市]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[流向-终端纯销].[上游编码]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[流向-终端纯销].[上游名称]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_province", "name": "下游省份", "fieldname": "customer_province", "expression": "[流向-终端纯销].[下游省份]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_city", "name": "下游城市", "fieldname": "customer_city", "expression": "[流向-终端纯销].[下游城市]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_code", "name": "下游编码", "fieldname": "customer_code", "expression": "[流向-终端纯销].[下游编码]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_name", "name": "下游名称", "fieldname": "customer_name", "expression": "[流向-终端纯销].[下游名称]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[流向-终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[流向-终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[流向-终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "价格", "fieldname": "price", "expression": "[流向-终端纯销].[价格]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false}
								]
							},
						]
					}
				],
				"workbook": {
					"id": "rebate_test",
					"planid": "P002",
					"code": "rebate_test",
					"bandid": "record_list",
					"typecode": "main",
					"no": 2,
					"columns": [
						{ "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "折扣项目", "bandid": "agreementList", "bandcolumn": "year", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[折扣项目]", "orderno": 0, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "年度", "bandid": "agreementList", "bandcolumn": "season", "bookfield": "xtek60eyng85", "variant": "", "expression": "[年度]", "orderno": 1, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "fee_name", "bookfield": "bqof64azwg09", "variant": "", "expression": "[经销商编码]", "orderno": 2, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "经销商名称", "bandid": "agreementList", "bandcolumn": "code", "bookfield": "mph0hre275nu", "variant": "", "expression": "[经销商名称]", "orderno": 3, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "采购金额", "bandid": "agreementList", "bandcolumn": "agreement_code", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[采购金额]", "orderno": 4, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "指标", "bandid": "agreementList", "bandcolumn": "customer_code", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[指标]", "orderno": 5, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "达成率", "bandid": "agreementList", "bandcolumn": "customer_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[达成率]", "orderno": 6, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "封顶线", "bandid": "agreementList", "bandcolumn": "terminal_code", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[封顶线]", "orderno": 7, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "达成计算金额", "bandid": "agreementList", "bandcolumn": "terminal_name", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[采购金额] × min([采购金额],[指标金额]×[封顶线])", "orderno": 8, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "达成返利比率", "bandid": "factorysale", "bandcolumn": "product_code", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[达成返利比率]", "orderno": 9, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "达成奖励", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[达成计算金额]×[达成返利比率]", "orderno": 10, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "超额金额", "bandid": "agreementList", "bandcolumn": "spec", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "max(0,[采购金额]×[指标金额])", "orderno": 11, "align": "right", "formatter": "text", "width": "1"},
						/////
						{ "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "超额返利比率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[超额返利比率]", "orderno": 12, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "超额返利", "bandid": "agreementList", "bandcolumn": "", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[超额金额]×[超额返利比率]", "orderno": 13, "align": "right", "formatter": "money", "width": "1"},
						{ "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "折扣总额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[达成返利]+[超额返利]", "orderno": 14, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "扣率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[折扣条款-零售补偿].[扣率]", "orderno": 15, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "差额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[销售金额]-[存量金额]", "orderno": 16, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "([销售金额]-[存量金额])×[扣率]", "orderno": 17, "align": "right", "formatter": "money", "width": "1"},
						
						
					]
				}
			}
		}
	},
	
	type3: {
		"success": true,
		"data": {
			"plan": {
				"id": "P002",
				"name": "2022经销商折扣政策A",
				"statecode": "Input",
				"buckets": [
					{
						"code": "record-list-Bucket",
						"name": "协议条款",
						"children": [
							{
								"code": "agreementList",
								"name": "折扣条款-广阔市场补偿",
								"dimension": "Tag",
								"size": 20,
								"columncount": 17,
								"children": [
									{ "id": "record-03", "bandid": "record_list", "code": "state_name", "name": "状态", "fieldname": "state_name", "expression": "[折扣条款-零售补偿].[状态]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-04", "bandid": "record_list", "code": "code", "name": "备案号", "fieldname": "code", "expression": "[折扣条款-零售补偿].[备案号]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-05", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[折扣条款-零售补偿].[备案类型]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-06", "bandid": "record_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[折扣条款-零售补偿].[经销商编码]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-07", "bandid": "record_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[折扣条款-零售补偿].[经销商名称]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-08", "bandid": "record_list", "code": "terminal_code", "name": "终端编码", "fieldname": "terminal_code", "expression": "[折扣条款-零售补偿].[终端编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-09", "bandid": "record_list", "code": "terminal_name", "name": "终端名称", "fieldname": "terminal_name", "expression": "[折扣条款-零售补偿].[终端名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-10", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[折扣条款-零售补偿].[产品编码]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-11", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[折扣条款-零售补偿].[产品名称]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-12", "bandid": "record_list", "code": "terminal_type", "name": "终端类型", "fieldname": "terminal_type", "expression": "[折扣条款-零售补偿].[终端类型]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-13", "bandid": "record_list", "code": "terminal_province", "name": "终端省份", "fieldname": "terminal_province", "expression": "[折扣条款-零售补偿].[终端省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-14", "bandid": "record_list", "code": "price_raw", "name": "销售单价", "fieldname": "price_raw", "expression": "[折扣条款-零售补偿].[销售单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-15", "bandid": "record_list", "code": "versionno", "name": "版本号", "fieldname": "versionno", "expression": "[折扣条款-零售补偿].[版本号]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-16", "bandid": "record_list", "code": "spec", "name": "规格", "fieldname": "spec", "expression": "[折扣条款-零售补偿].[规格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-17", "bandid": "record_list", "code": "terminal_city", "name": "终端城市", "fieldname": "terminal_city", "expression": "[折扣条款-零售补偿].[终端城市]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-18", "bandid": "record_list", "code": "batchno", "name": "备案批号", "fieldname": "batchno", "expression": "[折扣条款-零售补偿].[备案批号]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-19", "bandid": "record_list", "code": "customer_province", "name": "区域省份", "fieldname": "customer_province", "expression": "[折扣条款-零售补偿].[区域省份]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-20", "bandid": "record_list", "code": "tiered_rebate_rate_name", "name": "阶梯折扣率名称", "fieldname": "tiered_rebate_rate_name", "expression": "[折扣条款-零售补偿].[阶梯折扣率名称]", "indexno": 17, "ismeasure": false, "isshow": false, "isused": false, "fields": false}
								]
							}
						]
					},
					{
						"code": "flow-list-Bucket",
						"name": "业务数据",
						"children": [
							{
								"code": "terminalsale",
								"name": "流向-终端纯销",
								"dimension": "Tag",
								"size": 120,
								"columncount": 17,
								"children": [
									{ "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "code", "name": "编码", "fieldname": "code", "expression": "[流向-终端纯销].[编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[流向-终端纯销].[年份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[流向-终端纯销].[月份]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[流向-终端纯销].[流向日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省份", "fieldname": "supplyer_province", "expression": "[流向-终端纯销].[上游省份]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游城市", "fieldname": "supplyer_city", "expression": "[流向-终端纯销].[上游城市]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[流向-终端纯销].[上游编码]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[流向-终端纯销].[上游名称]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_province", "name": "下游省份", "fieldname": "customer_province", "expression": "[流向-终端纯销].[下游省份]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_city", "name": "下游城市", "fieldname": "customer_city", "expression": "[流向-终端纯销].[下游城市]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_code", "name": "下游编码", "fieldname": "customer_code", "expression": "[流向-终端纯销].[下游编码]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_name", "name": "下游名称", "fieldname": "customer_name", "expression": "[流向-终端纯销].[下游名称]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[流向-终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[流向-终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[流向-终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "价格", "fieldname": "price", "expression": "[流向-终端纯销].[价格]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false}
								]
							},
						]
					}
				],
				"workbook": {
					"id": "rebate_test",
					"planid": "P002",
					"code": "rebate_test",
					"bandid": "record_list",
					"typecode": "main",
					"no": 2,
					"columns": [
						{ "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "折扣项目", "bandid": "agreementList", "bandcolumn": "year", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[折扣项目]", "orderno": 0, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "年度", "bandid": "agreementList", "bandcolumn": "season", "bookfield": "xtek60eyng85", "variant": "", "expression": "[年度]", "orderno": 1, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "fee_name", "bookfield": "bqof64azwg09", "variant": "", "expression": "[经销商编码]", "orderno": 2, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "经销商名称", "bandid": "agreementList", "bandcolumn": "code", "bookfield": "mph0hre275nu", "variant": "", "expression": "[经销商名称]", "orderno": 3, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "agreement_code", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[流向数量]", "orderno": 4, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "补偿比例", "bandid": "agreementList", "bandcolumn": "customer_code", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[补偿比例]", "orderno": 5, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "补偿单价", "bandid": "agreementList", "bandcolumn": "customer_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[补偿单价]", "orderno": 6, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "使用限定", "bandid": "agreementList", "bandcolumn": "terminal_code", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[使用限定]", "orderno": 7, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "terminal_name", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[流向数量]×[补偿比例]×[补偿单价]", "orderno": 8, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "产品-编码", "bandid": "factorysale", "bandcolumn": "product_code", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[工厂发货].[产品-编码]", "orderno": 9, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "产品-名称", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[折扣条款-零售补偿].[产品-名称]", "orderno": 10, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "规格", "bandid": "agreementList", "bandcolumn": "spec", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "[折扣条款-零售补偿].[规格]", "orderno": 11, "align": "center", "formatter": "text", "width": "1"},
						// /////
						// { "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[折扣条款-零售补偿].[流向数量]", "orderno": 12, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "销售金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[折扣条款-零售补偿].[销售金额]", "orderno": 13, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "存量金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[折扣条款-零售补偿].[存量金额]", "orderno": 14, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "扣率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[折扣条款-零售补偿].[扣率]", "orderno": 15, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "差额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[销售金额]-[存量金额]", "orderno": 16, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "([销售金额]-[存量金额])×[扣率]", "orderno": 17, "align": "right", "formatter": "money", "width": "1"},
						
						
					]
				}
			}
		}
	},
	type4: {
		"success": true,
		"data": {
			"plan": {
				"id": "P002",
				"name": "2022经销商折扣政策A",
				"statecode": "Input",
				"buckets": [
					{
						"code": "record-list-Bucket",
						"name": "协议条款",
						"children": [
							{
								"code": "agreementList",
								"name": "折扣条款-差价补偿",
								"dimension": "Tag",
								"size": 20,
								"columncount": 17,
								"children": [
									{ "id": "record-03", "bandid": "record_list", "code": "state_name", "name": "状态", "fieldname": "state_name", "expression": "[折扣条款-零售补偿].[状态]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-04", "bandid": "record_list", "code": "code", "name": "备案号", "fieldname": "code", "expression": "[折扣条款-零售补偿].[备案号]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-05", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[折扣条款-零售补偿].[备案类型]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-06", "bandid": "record_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[折扣条款-零售补偿].[经销商编码]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-07", "bandid": "record_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[折扣条款-零售补偿].[经销商名称]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-08", "bandid": "record_list", "code": "terminal_code", "name": "终端编码", "fieldname": "terminal_code", "expression": "[折扣条款-零售补偿].[终端编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-09", "bandid": "record_list", "code": "terminal_name", "name": "终端名称", "fieldname": "terminal_name", "expression": "[折扣条款-零售补偿].[终端名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-10", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[折扣条款-零售补偿].[产品编码]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-11", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[折扣条款-零售补偿].[产品名称]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-12", "bandid": "record_list", "code": "terminal_type", "name": "终端类型", "fieldname": "terminal_type", "expression": "[折扣条款-零售补偿].[终端类型]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-13", "bandid": "record_list", "code": "terminal_province", "name": "终端省份", "fieldname": "terminal_province", "expression": "[折扣条款-零售补偿].[终端省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-14", "bandid": "record_list", "code": "price_raw", "name": "销售单价", "fieldname": "price_raw", "expression": "[折扣条款-零售补偿].[销售单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-15", "bandid": "record_list", "code": "versionno", "name": "版本号", "fieldname": "versionno", "expression": "[折扣条款-零售补偿].[版本号]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-16", "bandid": "record_list", "code": "spec", "name": "规格", "fieldname": "spec", "expression": "[折扣条款-零售补偿].[规格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-17", "bandid": "record_list", "code": "terminal_city", "name": "终端城市", "fieldname": "terminal_city", "expression": "[折扣条款-零售补偿].[终端城市]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-18", "bandid": "record_list", "code": "batchno", "name": "备案批号", "fieldname": "batchno", "expression": "[折扣条款-零售补偿].[备案批号]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-19", "bandid": "record_list", "code": "customer_province", "name": "区域省份", "fieldname": "customer_province", "expression": "[折扣条款-零售补偿].[区域省份]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-20", "bandid": "record_list", "code": "tiered_rebate_rate_name", "name": "阶梯折扣率名称", "fieldname": "tiered_rebate_rate_name", "expression": "[折扣条款-零售补偿].[阶梯折扣率名称]", "indexno": 17, "ismeasure": false, "isshow": false, "isused": false, "fields": false}
								]
							}
						]
					},
					{
						"code": "flow-list-Bucket",
						"name": "业务数据",
						"children": [
							{
								"code": "terminalsale",
								"name": "流向-终端纯销",
								"dimension": "Tag",
								"size": 120,
								"columncount": 17,
								"children": [
									{ "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "code", "name": "编码", "fieldname": "code", "expression": "[流向-终端纯销].[编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[流向-终端纯销].[年份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[流向-终端纯销].[月份]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[流向-终端纯销].[流向日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省份", "fieldname": "supplyer_province", "expression": "[流向-终端纯销].[上游省份]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游城市", "fieldname": "supplyer_city", "expression": "[流向-终端纯销].[上游城市]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[流向-终端纯销].[上游编码]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[流向-终端纯销].[上游名称]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_province", "name": "下游省份", "fieldname": "customer_province", "expression": "[流向-终端纯销].[下游省份]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_city", "name": "下游城市", "fieldname": "customer_city", "expression": "[流向-终端纯销].[下游城市]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_code", "name": "下游编码", "fieldname": "customer_code", "expression": "[流向-终端纯销].[下游编码]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_name", "name": "下游名称", "fieldname": "customer_name", "expression": "[流向-终端纯销].[下游名称]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[流向-终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[流向-终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[流向-终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "价格", "fieldname": "price", "expression": "[流向-终端纯销].[价格]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false}
								]
							},
						]
					}
				],
				"workbook": {
					"id": "rebate_test",
					"planid": "P002",
					"code": "rebate_test",
					"bandid": "record_list",
					"typecode": "main",
					"no": 2,
					"columns": [
						{ "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "折扣项目", "bandid": "agreementList", "bandcolumn": "year", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[折扣项目]", "orderno": 0, "align": "center", "formatter": "text", "width": "1.5"},
						{ "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "年度", "bandid": "agreementList", "bandcolumn": "season", "bookfield": "xtek60eyng85", "variant": "", "expression": "[年度]", "orderno": 1, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "fee_name", "bookfield": "bqof64azwg09", "variant": "", "expression": "[经销商编码]", "orderno": 2, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "经销商名称", "bandid": "agreementList", "bandcolumn": "code", "bookfield": "mph0hre275nu", "variant": "", "expression": "[经销商名称]", "orderno": 3, "align": "center", "formatter": "text", "width": "2.5"},
						{ "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "agreement_code", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[流向数量]", "orderno": 4, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "补偿比例", "bandid": "agreementList", "bandcolumn": "customer_code", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[补偿比例]", "orderno": 5, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "补偿单价", "bandid": "agreementList", "bandcolumn": "customer_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[补偿单价]", "orderno": 6, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "使用限定", "bandid": "agreementList", "bandcolumn": "terminal_code", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[使用限定]", "orderno": 7, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "terminal_name", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[流向数量]×[补偿单价]", "orderno": 8, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "产品-编码", "bandid": "factorysale", "bandcolumn": "product_code", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[工厂发货].[产品-编码]", "orderno": 9, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "产品-名称", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[折扣条款-零售补偿].[产品-名称]", "orderno": 10, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "规格", "bandid": "agreementList", "bandcolumn": "spec", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "[折扣条款-零售补偿].[规格]", "orderno": 11, "align": "center", "formatter": "text", "width": "1"},
						// /////
						// { "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[折扣条款-零售补偿].[流向数量]", "orderno": 12, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "销售金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[折扣条款-零售补偿].[销售金额]", "orderno": 13, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "存量金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[折扣条款-零售补偿].[存量金额]", "orderno": 14, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "扣率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[折扣条款-零售补偿].[扣率]", "orderno": 15, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "差额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[销售金额]-[存量金额]", "orderno": 16, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "([销售金额]-[存量金额])×[扣率]", "orderno": 17, "align": "right", "formatter": "money", "width": "1"},
						
						
					]
				}
			}
		}
	},
	type5: {
		"success": true,
		"data": {
			"plan": {
				"id": "P002",
				"name": "2022经销商折扣政策A",
				"statecode": "Input",
				"buckets": [
					{
						"code": "record-list-Bucket",
						"name": "协议条款",
						"children": [
							{
								"code": "agreementList",
								"name": "折扣条款-差价补偿",
								"dimension": "Tag",
								"size": 20,
								"columncount": 17,
								"children": [
									{ "id": "record-03", "bandid": "record_list", "code": "state_name", "name": "状态", "fieldname": "state_name", "expression": "[折扣条款-零售补偿].[状态]", "indexno": 0, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-04", "bandid": "record_list", "code": "code", "name": "备案号", "fieldname": "code", "expression": "[折扣条款-零售补偿].[备案号]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-05", "bandid": "record_list", "code": "type_name", "name": "备案类型", "fieldname": "type_name", "expression": "[折扣条款-零售补偿].[备案类型]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-06", "bandid": "record_list", "code": "customer_code", "name": "经销商编码", "fieldname": "customer_code", "expression": "[折扣条款-零售补偿].[经销商编码]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-07", "bandid": "record_list", "code": "customer_name", "name": "经销商名称", "fieldname": "customer_name", "expression": "[折扣条款-零售补偿].[经销商名称]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-08", "bandid": "record_list", "code": "terminal_code", "name": "终端编码", "fieldname": "terminal_code", "expression": "[折扣条款-零售补偿].[终端编码]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-09", "bandid": "record_list", "code": "terminal_name", "name": "终端名称", "fieldname": "terminal_name", "expression": "[折扣条款-零售补偿].[终端名称]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-10", "bandid": "record_list", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[折扣条款-零售补偿].[产品编码]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-11", "bandid": "record_list", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[折扣条款-零售补偿].[产品名称]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-12", "bandid": "record_list", "code": "terminal_type", "name": "终端类型", "fieldname": "terminal_type", "expression": "[折扣条款-零售补偿].[终端类型]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-13", "bandid": "record_list", "code": "terminal_province", "name": "终端省份", "fieldname": "terminal_province", "expression": "[折扣条款-零售补偿].[终端省份]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-14", "bandid": "record_list", "code": "price_raw", "name": "销售单价", "fieldname": "price_raw", "expression": "[折扣条款-零售补偿].[销售单价]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-15", "bandid": "record_list", "code": "versionno", "name": "版本号", "fieldname": "versionno", "expression": "[折扣条款-零售补偿].[版本号]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-16", "bandid": "record_list", "code": "spec", "name": "规格", "fieldname": "spec", "expression": "[折扣条款-零售补偿].[规格]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-17", "bandid": "record_list", "code": "terminal_city", "name": "终端城市", "fieldname": "terminal_city", "expression": "[折扣条款-零售补偿].[终端城市]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "record-18", "bandid": "record_list", "code": "batchno", "name": "备案批号", "fieldname": "batchno", "expression": "[折扣条款-零售补偿].[备案批号]", "indexno": 15, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-19", "bandid": "record_list", "code": "customer_province", "name": "区域省份", "fieldname": "customer_province", "expression": "[折扣条款-零售补偿].[区域省份]", "indexno": 16, "ismeasure": false, "isshow": false, "isused": false, "fields": false},
									{ "id": "record-20", "bandid": "record_list", "code": "tiered_rebate_rate_name", "name": "阶梯折扣率名称", "fieldname": "tiered_rebate_rate_name", "expression": "[折扣条款-零售补偿].[阶梯折扣率名称]", "indexno": 17, "ismeasure": false, "isshow": false, "isused": false, "fields": false}
								]
							}
						]
					},
					{
						"code": "flow-list-Bucket",
						"name": "业务数据",
						"children": [
							{
								"code": "terminalsale",
								"name": "流向-终端纯销",
								"dimension": "Tag",
								"size": 120,
								"columncount": 17,
								"children": [
									{ "id": "flow-terminal-01", "bandid": "flow_terminal", "code": "code", "name": "编码", "fieldname": "code", "expression": "[流向-终端纯销].[编码]", "indexno": 0, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-02", "bandid": "flow_terminal", "code": "year", "name": "年份", "fieldname": "year", "expression": "[流向-终端纯销].[年份]", "indexno": 1, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-03", "bandid": "flow_terminal", "code": "month", "name": "月份", "fieldname": "month", "expression": "[流向-终端纯销].[月份]", "indexno": 2, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-17", "bandid": "flow_terminal", "code": "doc_date", "name": "流向日期", "fieldname": "doc_date", "expression": "[流向-终端纯销].[流向日期]", "indexno": 3, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-04", "bandid": "flow_terminal", "code": "supplyer_province", "name": "上游省份", "fieldname": "supplyer_province", "expression": "[流向-终端纯销].[上游省份]", "indexno": 4, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-05", "bandid": "flow_terminal", "code": "supplyer_city", "name": "上游城市", "fieldname": "supplyer_city", "expression": "[流向-终端纯销].[上游城市]", "indexno": 5, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-06", "bandid": "flow_terminal", "code": "supplyer_code", "name": "上游编码", "fieldname": "supplyer_code", "expression": "[流向-终端纯销].[上游编码]", "indexno": 6, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-07", "bandid": "flow_terminal", "code": "supplyer_name", "name": "上游名称", "fieldname": "supplyer_name", "expression": "[流向-终端纯销].[上游名称]", "indexno": 7, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-08", "bandid": "flow_terminal", "code": "customer_province", "name": "下游省份", "fieldname": "customer_province", "expression": "[流向-终端纯销].[下游省份]", "indexno": 8, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-09", "bandid": "flow_terminal", "code": "customer_city", "name": "下游城市", "fieldname": "customer_city", "expression": "[流向-终端纯销].[下游城市]", "indexno": 9, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-10", "bandid": "flow_terminal", "code": "customer_code", "name": "下游编码", "fieldname": "customer_code", "expression": "[流向-终端纯销].[下游编码]", "indexno": 10, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-11", "bandid": "flow_terminal", "code": "customer_name", "name": "下游名称", "fieldname": "customer_name", "expression": "[流向-终端纯销].[下游名称]", "indexno": 11, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-12", "bandid": "flow_terminal", "code": "product_code", "name": "产品编码", "fieldname": "product_code", "expression": "[流向-终端纯销].[产品编码]", "indexno": 12, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-13", "bandid": "flow_terminal", "code": "product_name", "name": "产品名称", "fieldname": "product_name", "expression": "[流向-终端纯销].[产品名称]", "indexno": 13, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-14", "bandid": "flow_terminal", "code": "qty", "name": "数量", "fieldname": "qty", "expression": "[流向-终端纯销].[数量]", "indexno": 14, "ismeasure": false, "isshow": true, "isused": false, "fields": false},
									{ "id": "flow-terminal-15", "bandid": "flow_terminal", "code": "price", "name": "价格", "fieldname": "price", "expression": "[流向-终端纯销].[价格]", "indexno": 15, "ismeasure": false, "isshow": true, "isused": false, "fields": false}
								]
							},
						]
					}
				],
				"workbook": {
					"id": "rebate_test",
					"planid": "P002",
					"code": "rebate_test",
					"bandid": "record_list",
					"typecode": "main",
					"no": 2,
					"columns": [
						{ "id": "6767465634274f2db8ca0b01f04daef7", "iskey": false, "indexno": 0, "code": "m8t1j589zoxx", "name": "折扣项目", "bandid": "agreementList", "bandcolumn": "year", "bookfield": "m8t1j589zoxx", "variant": "", "expression": "[折扣项目]", "orderno": 0, "align": "center", "formatter": "text", "width": "1.5"},
						{ "id": "a8929f1434bb40f996bf743489835e8d", "iskey": false, "indexno": 1, "code": "xtek60eyng85", "name": "年度", "bandid": "agreementList", "bandcolumn": "season", "bookfield": "xtek60eyng85", "variant": "", "expression": "[年度]", "orderno": 1, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "40aac564df9748b79f8e373730049325", "iskey": false, "indexno": 2, "code": "bqof64azwg09", "name": "经销商编码", "bandid": "agreementList", "bandcolumn": "fee_name", "bookfield": "bqof64azwg09", "variant": "", "expression": "[经销商编码]", "orderno": 2, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "6bb47cdabc164438b0e74cf504ca6f71", "iskey": false, "indexno": 3, "code": "mph0hre275nu", "name": "经销商名称", "bandid": "agreementList", "bandcolumn": "code", "bookfield": "mph0hre275nu", "variant": "", "expression": "[经销商名称]", "orderno": 3, "align": "center", "formatter": "text", "width": "2.5"},
						{ "id": "d3977d9beeee4b9da4b59e6f703d61f3", "iskey": false, "indexno": 4, "code": "tfkcx7ku08ld", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "agreement_code", "bookfield": "tfkcx7ku08ld", "variant": "", "expression": "[流向数量]", "orderno": 4, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "1847d79248924122a0e7afe4137222f4", "iskey": false, "indexno": 5, "code": "v13kggpbbpco", "name": "补偿比例", "bandid": "agreementList", "bandcolumn": "customer_code", "bookfield": "v13kggpbbpco", "variant": "", "expression": "[补偿比例]", "orderno": 5, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "7e67b2e973a74e11bbbf103950f2f330", "iskey": false, "indexno": 6, "code": "bdlzd0nfpsm1", "name": "补偿单价", "bandid": "agreementList", "bandcolumn": "customer_name", "bookfield": "bdlzd0nfpsm1", "variant": "", "expression": "[补偿单价]", "orderno": 6, "align": "right", "formatter": "text", "width": "1"},
						{ "id": "f9d88e1bb32f47adb674e7c8d7a8faad", "iskey": false, "indexno": 7, "code": "g0r05cr2x7kl", "name": "使用限定", "bandid": "agreementList", "bandcolumn": "terminal_code", "bookfield": "g0r05cr2x7kl", "variant": "", "expression": "[使用限定]", "orderno": 7, "align": "center", "formatter": "text", "width": "1"},
						{ "id": "cfeee20fc81245b898876ee31ff4950f", "iskey": false, "indexno": 8, "code": "j57u8la2edbu", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "terminal_name", "bookfield": "j57u8la2edbu", "variant": "", "expression": "[流向数量]×[补偿比例]×[补偿单价]", "orderno": 8, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "63b970b7f8164f6b9daf1feb203558f9", "iskey": false, "indexno": 9, "code": "qqxrwkpniqdd", "name": "产品-编码", "bandid": "factorysale", "bandcolumn": "product_code", "bookfield": "qqxrwkpniqdd", "variant": "", "expression": "[工厂发货].[产品-编码]", "orderno": 9, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "11e9b831ab574456b0fcbddbdc0b2757", "iskey": false, "indexno": 10, "code": "dqcmdpzpt2oz", "name": "产品-名称", "bandid": "agreementList", "bandcolumn": "product_name", "bookfield": "dqcmdpzpt2oz", "variant": "", "expression": "[折扣条款-零售补偿].[产品-名称]", "orderno": 10, "align": "center", "formatter": "text", "width": "1"},
						// { "id": "573d13eed21a4517b75aff6de173e10e", "iskey": false, "indexno": 11, "code": "tkdrha0j5z4a", "name": "规格", "bandid": "agreementList", "bandcolumn": "spec", "bookfield": "tkdrha0j5z4a", "variant": "", "expression": "[折扣条款-零售补偿].[规格]", "orderno": 11, "align": "center", "formatter": "text", "width": "1"},
						// /////
						// { "id": "52801959eeee4a9abd084d8bd01f8143", "iskey": false, "indexno": 12, "code": "cv6doar7tb0n", "name": "流向数量", "bandid": "agreementList", "bandcolumn": "", "bookfield": "cv6doar7tb0n", "variant": "", "expression": "[折扣条款-零售补偿].[流向数量]", "orderno": 12, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "83ce787d717e411aa47bbeb54ced0a0a", "iskey": false, "indexno": 13, "code": "g0ckvxzpde1w", "name": "销售金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "g0ckvxzpde1w", "variant": "", "expression": "[折扣条款-零售补偿].[销售金额]", "orderno": 13, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "801e79c1663c44019b8c78f594e6c25f", "iskey": false, "indexno": 14, "code": "io8cdw34jkvx", "name": "存量金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "io8cdw34jkvx", "variant": "", "expression": "[折扣条款-零售补偿].[存量金额]", "orderno": 14, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "8d59f7ffab524b04afa436baba1c0853", "iskey": false, "indexno": 15, "code": "gthzjxbrz9fp", "name": "扣率", "bandid": "agreementList", "bandcolumn": "", "bookfield": "gthzjxbrz9fp", "variant": "", "expression": "[折扣条款-零售补偿].[扣率]", "orderno": 15, "align": "right", "formatter": "text", "width": "1"},
						// { "id": "648c22282c41449fa526cd7974f29a1f", "iskey": false, "indexno": 16, "code": "duoeeegbmf29", "name": "差额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "duoeeegbmf29", "variant": "", "expression": "[销售金额]-[存量金额]", "orderno": 16, "align": "right", "formatter": "money", "width": "1"},
						// { "id": "e5a2a8b497874a449ef5871e5a06cab7", "iskey": false, "indexno": 17, "code": "pcuki55dq5i2", "name": "折扣金额", "bandid": "agreementList", "bandcolumn": "", "bookfield": "pcuki55dq5i2", "variant": "", "expression": "([销售金额]-[存量金额])×[扣率]", "orderno": 17, "align": "right", "formatter": "money", "width": "1"},
						
						
					]
				}
			}
		}
	},
}

var designer_datalist_type = {
	type1: {
		"m8t1j589zoxx": [//年份
			"2023",
			"2023",
			"2023",
			"2023",
			"2023",
			"2023",
			"2023"
		],
		"xtek60eyng85": [//季度
			"1",
			"1",
			"1",
			"1",
			"1",
			"1",
			"1"
		],
		"bqof64azwg09": [//折扣名称
			"零售补偿",
			"零售补偿",
			"零售补偿",
			"零售补偿",
			"零售补偿",
			"零售补偿",
			"零售补偿"
		],
		"mph0hre275nu": [//备案号
			"F-M-0001",
			"F-M-0001",
			"F-M-0001",
			"F-M-0002",
			"F-M-0002",
			"F-M-0003",
			"F-M-0004"
		],
		"tfkcx7ku08ld": [//协议编码
			"A-A-0001",
			"A-A-0001",
			"A-A-0001",
			"A-A-0002",
			"A-A-0002",
			"A-A-0003",
			"A-A-0004"
		],
		"v13kggpbbpco": [//客户-编码
			"C000006",
			"C000006",
			"C000006",
			"C000006",
			"C000006",
			"C000006",
			"C000006"
		],
		"bdlzd0nfpsm1": [//客户-名称
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司",
			"汕头市翔跃药业有限公司"
		],
		"g0r05cr2x7kl": [//终端编码
			"HP00013",
			"HP00013",
			"HP00013",
			"HP00014",
			"HP00014",
			"HP00015",
			"HP00016"
		],
		"j57u8la2edbu": [//终端名称
			"汕头大学医学院第一附属医院",
			"汕头大学医学院第一附属医院",
			"汕头大学医学院第一附属医院",
			"汕头市潮阳区大峰医院",
			"汕头市潮阳区大峰医院",
			"汕头市第二人民医院",
			"汕头潮南民生医院"
		],
		"qqxrwkpniqdd": [//产品-编码
			"PD001",
			"PD001",
			"PD001",
			"PD002",
			"PD002",
			"PD003",
			"PD004"
		],
		"dqcmdpzpt2oz": [//产品-名称
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱",
			"康莱注射液|100ml：10g|1瓶/盒_21盒/箱"
		],
		"tkdrha0j5z4a": [//规格
			"0.45g*72*100",
			"0.45g*72*100",
			"0.45g*72*100",
			"0.45g*72*100",
			"0.45g*72*100",
			"0.45g*72*100",
			"0.45g*72*100"
		],
		"cv6doar7tb0n": [//流向数量
			"10",
			"15",
			"8",
			"6",
			"20",
			"15",
			"10"
		],
		"g0ckvxzpde1w": [//销售金额
			"10000",
			"15000",
			"8000",
			"6000",
			"20000",
			"15000",
			"10000"
		],
		"io8cdw34jkvx": [//存量金额
			"5000",
			"3000",
			"2000",
			"2000",
			"5000",
			"2000",
			"1000"
		],
		"gthzjxbrz9fp": [//扣率
			"0",
			"0.1",
			"0",
			"0",
			"0.2",
			"0.1",
			"0"
		],
		"duoeeegbmf29": [//差额
			"5000",
			"12000",
			"6000",
			"4000",
			"15000",
			"13000",
			"9000"
		
		],
		"pcuki55dq5i2": [//折扣金额
			"0",
			"1200",
			"0",
			"0",
			"3000",
			"1300",
			"0"
		],
	},
	
	type2: {
		"m8t1j589zoxx": [
			"年度Sale-In奖励",
			"年度Sale-In奖励",
			"年度Sale-In奖励",
			"年度Sale-In奖励",
			"年度Sale-In奖励"
		],
		"xtek60eyng85": [
			"2022",
			"2022",
			"2022",
			"2022",
			"2022"
		],
		"bqof64azwg09": [//折扣名称
			"209801",
			"209802",
			"209803",
			"209804",
			"209805"
		],
		"mph0hre275nu": [//备案号
			"上海云诚医疗器械有限公司",
			"上海启元医疗器械有限公司",
			"北京大通医疗器械有限公司",
			"北京天源医疗器械有限公司",
			"北京华城医疗器械有限公司",
		],
		"tfkcx7ku08ld": [//协议编码
			"￥108,000.00",
			"￥250,000.00",
			"￥79,000.00",
			"￥201,000.00",
			"￥350,000.00"
		],
		"v13kggpbbpco": [//客户-编码
			"￥90,000.00",
			"￥255,102.04",
			"￥59,848.48",
			"￥173,275.86",
			"￥273,437.50"
		],
		"bdlzd0nfpsm1": [//客户-名称
			"120%",
			"98%",
			"132%",
			"116%",
			"128%"
		],
		"g0r05cr2x7kl": [//终端编码
			"125%",
			"125%",
			"125%",
			"125%",
			"125%"
		],
		"j57u8la2edbu": [//终端名称
			"￥108,000.00",
			"￥250,000.00",
			"￥98,750.00",
			"￥201,000.00",
			"￥437,500.00"
		],
		"qqxrwkpniqdd": [//产品-编码
			"2%",
			"0%",
			"2%",
			"2%",
			"2%"
		],
		"dqcmdpzpt2oz": [//产品-名称
			"￥2,160.00",
			"￥0.00",
			"￥1,975.00",
			"￥4,020.00",
			"￥8,750.00"
		],
		"tkdrha0j5z4a": [//规格
			"￥18,000.00",
			"￥0.00",
			"￥19,151.52",
			"￥27,724.14",
			"￥76,562.50"
		],
		"cv6doar7tb0n": [//流向数量
			"1%",
			"1%",
			"1%",
			"1%",
			"1%"
		],
		"g0ckvxzpde1w": [//销售金额
			180.00,
			0.00,
			191.52,
			277.24,
			765.63
		],
		"io8cdw34jkvx": [//存量金额
			2340.00,
			0.00,
			2166.52,
			4297.24,
			9515.63
		]
	},
	type3: {
		"m8t1j589zoxx": [//年份
			"市场推广政策补偿",
			"市场推广政策补偿"
		],
		"xtek60eyng85": [//季度
			"2022",
			"2022"
		],
		"bqof64azwg09": [//折扣名称
			"209801",
			"209802"
		],
		"mph0hre275nu": [//备案号
			"上海云诚医疗器械有限公司",
			"北京大通医疗器械有限公司"
		],
		"tfkcx7ku08ld": [//协议编码
			"100",
			"160"
		],
		"v13kggpbbpco": [//客户-编码
			"50%",
			"50%"
		],
		"bdlzd0nfpsm1": [//客户-名称
			"￥100.00",
			"￥100.00"
		],
		"g0r05cr2x7kl": [//终端编码
			"PFO",
			"PFO"
		],
		"j57u8la2edbu": [//终端名称
			"￥10,000.00",
			"￥16,000.00"
		]
		
	},
	
	type4: {
		"m8t1j589zoxx": [//年份
			"渠道价差补偿",
			"渠道价差补偿"
		],
		"xtek60eyng85": [//季度
			"2022",
			"2022"
		],
		"bqof64azwg09": [//折扣名称
			"209801",
			"209802"
		],
		"mph0hre275nu": [//备案号
			"上海云诚医疗器械有限公司",
			"北京大通医疗器械有限公司"
		],
		"tfkcx7ku08ld": [//协议编码
			"100",
			"160"
		],
		// "v13kggpbbpco": [//客户-编码
		// 	"50%",
		// 	"50%"
		// ],
		"bdlzd0nfpsm1": [//客户-名称
			"￥100.00",
			"￥100.00"
		],
		"g0r05cr2x7kl": [//终端编码
			"PFO",
			"PFO"
		],
		"j57u8la2edbu": [//终端名称
			"￥10,000.00",
			"￥16,000.00"
		]
		
	},
	type5: {
		"m8t1j589zoxx": [//年份
			"渠道价差补偿",
			"渠道价差补偿"
		],
		"xtek60eyng85": [//季度
			"2022",
			"2022"
		],
		"bqof64azwg09": [//折扣名称
			"209801",
			"209802"
		],
		"mph0hre275nu": [//备案号
			"上海云诚医疗器械有限公司",
			"北京大通医疗器械有限公司"
		],
		"tfkcx7ku08ld": [//协议编码
			"100",
			"160"
		],
		"v13kggpbbpco": [//客户-编码
			"50%",
			"50%"
		],
		"bdlzd0nfpsm1": [//客户-名称
			"￥100.00",
			"￥100.00"
		],
		"g0r05cr2x7kl": [//终端编码
			"PFO",
			"PFO"
		],
		"j57u8la2edbu": [//终端名称
			"￥10,000.00",
			"￥16,000.00"
		]
		
	}
}