{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["威凤"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"威凤","index":0,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["仓库耗材代码（WMS）","品名","规格","个","卷","板","订单内耗"]
[1,"1#化妆盒","16*10.8*9.6",2,0,0,0,"mrc000000000000000531",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H2,\"','\",K2,\"','00','00','\",B2,\"','\",C2,\"','\",A2,\"',\",D2,\",\",E2,\",\",F2,\",0,0);\")","v":"values('mrc000000000000000531','mhbs575004538273665024','00','00','1#化妆盒','16*10.8*9.6','1',2,0,0,0,0);"},"mhbs575004538273665024"]
[2,"2#化妆盒","22*15*10",2.8,0,0,0,"mrc000000000000000532",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H3,\"','\",K2,\"','00','00','\",B3,\"','\",C3,\"','\",A3,\"',\",D3,\",\",E3,\",\",F3,\",0,0);\")","v":"values('mrc000000000000000532','mhbs575004538273665024','00','00','2#化妆盒','22*15*10','2',2.8,0,0,0,0);"}]
[3,"3#化妆盒","26*15*18",3.7,0,0,0,"mrc000000000000000533","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H4,\"','\",K2,\"','00','00','\",B4,\"','\",C4,\"','\",A4,\"',\",D4,\",\",E4,\",\",F4,\",0,0);\")","v":"values('mrc000000000000000533','mhbs575004538273665024','00','00','3#化妆盒','26*15*18','3',3.7,0,0,0,0);"}]
[4,"N1","32*20*27",6,0,0,0,"mrc000000000000000534","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H5,\"','\",K2,\"','00','00','\",B5,\"','\",C5,\"','\",A5,\"',\",D5,\",\",E5,\",\",F5,\",0,0);\")","v":"values('mrc000000000000000534','mhbs575004538273665024','00','00','N1','32*20*27','4',6,0,0,0,0);"}]
[5,"N2","40*32*27",10.1,0,0,0,"mrc000000000000000535","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H6,\"','\",K2,\"','00','00','\",B6,\"','\",C6,\"','\",A6,\"',\",D6,\",\",E6,\",\",F6,\",0,0);\")","v":"values('mrc000000000000000535','mhbs575004538273665024','00','00','N2','40*32*27','5',10.1,0,0,0,0);"}]
[6,"N3","48*40*27",12.5,0,0,0,"mrc000000000000000536","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H7,\"','\",K2,\"','00','00','\",B7,\"','\",C7,\"','\",A7,\"',\",D7,\",\",E7,\",\",F7,\",0,0);\")","v":"values('mrc000000000000000536','mhbs575004538273665024','00','00','N3','48*40*27','6',12.5,0,0,0,0);"}]
[7,"N4","40*32*54",13,0,0,0,"mrc000000000000000537","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H8,\"','\",K2,\"','00','00','\",B8,\"','\",C8,\"','\",A8,\"',\",D8,\",\",E8,\",\",F8,\",0,0);\")","v":"values('mrc000000000000000537','mhbs575004538273665024','00','00','N4','40*32*54','7',13,0,0,0,0);"}]
["5#","5#纸箱","35*25*19",6,0,0,0,"mrc000000000000000538","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H9,\"','\",K2,\"','00','00','\",B9,\"','\",C9,\"','\",A9,\"',\",D9,\",\",E9,\",\",F9,\",0,0);\")","v":"values('mrc000000000000000538','mhbs575004538273665024','00','00','5#纸箱','35*25*19','5#',6,0,0,0,0);"}]
["6#","6#纸箱","43*21*27",10.1,0,0,0,"mrc000000000000000539","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H10,\"','\",K2,\"','00','00','\",B10,\"','\",C10,\"','\",A10,\"',\",D10,\",\",E10,\",\",F10,\",0,0);\")","v":"values('mrc000000000000000539','mhbs575004538273665024','00','00','6#纸箱','43*21*27','6#',10.1,0,0,0,0);"}]
["7#","7#纸箱","50*35*19",12.5,0,0,0,"mrc000000000000000540","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H11,\"','\",K2,\"','00','00','\",B11,\"','\",C11,\"','\",A11,\"',\",D11,\",\",E11,\",\",F11,\",0,0);\")","v":"values('mrc000000000000000540','mhbs575004538273665024','00','00','7#纸箱','50*35*19','7#',12.5,0,0,0,0);"}]
["A","客户纸箱","多尺寸",0,0,0,0,"mrc000000000000000541","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H12,\"','\",K2,\"','10','00','\",B12,\"','\",C12,\"','\",A12,\"',\",D12,\",\",E12,\",\",F12,\",0,0);\")","v":"values('mrc000000000000000541','mhbs575004538273665024','10','00','客户纸箱','多尺寸','A',0,0,0,0,0);"}]
["QPM","气泡膜","30cm*60m",0,44.2,0,0,"mrc000000000000000542",{"$f":"CONCATENATE(\"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)\")","v":"insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)"},{"$f":"CONCATENATE(\"values('\",H13,\"','\",K2,\"','10','00','\",B13,\"','\",C13,\"','\",A13,\"',\",D13,\",\",E13,\",\",F13,\",0,0);\")","v":"values('mrc000000000000000542','mhbs575004538273665024','10','00','气泡膜','30cm*60m','QPM',0,44.2,0,0,0);"}]
["JD","胶纸","5cm",0,9.7,0,0,"mrc000000000000000543","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H14,\"','\",K2,\"','10','00','\",B14,\"','\",C14,\"','\",A14,\"',\",D14,\",\",E14,\",\",F14,\",0,0);\")","v":"values('mrc000000000000000543','mhbs575004538273665024','10','00','胶纸','5cm','JD',0,9.7,0,0,0);"}]
["QZD11","气柱袋","11柱",1.1,0,0,0,"mrc000000000000000544","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H15,\"','\",K2,\"','10','00','\",B15,\"','\",C15,\"','\",A15,\"',\",D15,\",\",E15,\",\",F15,\",0,0);\")","v":"values('mrc000000000000000544','mhbs575004538273665024','10','00','气柱袋','11柱','QZD11',1.1,0,0,0,0);"}]
["QPD1","气泡袋","20*30",0.4,0,0,0,"mrc000000000000000545","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H16,\"','\",K2,\"','10','00','\",B16,\"','\",C16,\"','\",A16,\"',\",D16,\",\",E16,\",\",F16,\",0,0);\")","v":"values('mrc000000000000000545','mhbs575004538273665024','10','00','气泡袋','20*30','QPD1',0.4,0,0,0,0);"}]
["QPD2","气泡袋","20*40",0.5,0,0,0,"mrc000000000000000546","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H17,\"','\",K2,\"','10','00','\",B17,\"','\",C17,\"','\",A17,\"',\",D17,\",\",E17,\",\",F17,\",0,0);\")","v":"values('mrc000000000000000546','mhbs575004538273665024','10','00','气泡袋','20*40','QPD2',0.5,0,0,0,0);"}]
["QPD3","气泡袋","25*40",0.7,0,0,0,"mrc000000000000000547","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H18,\"','\",K2,\"','10','00','\",B18,\"','\",C18,\"','\",A18,\"',\",D18,\",\",E18,\",\",F18,\",0,0);\")","v":"values('mrc000000000000000547','mhbs575004538273665024','10','00','气泡袋','25*40','QPD3',0.7,0,0,0,0);"}]
["TCQP","填充气泡","10*20",0,374,0,0,"mrc000000000000000548","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H19,\"','\",K2,\"','10','00','\",B19,\"','\",C19,\"','\",A19,\"',\",D19,\",\",E19,\",\",F19,\",0,0);\")","v":"values('mrc000000000000000548','mhbs575004538273665024','10','00','填充气泡','10*20','TCQP',0,374,0,0,0);"}]
["QGZ","气管柱",0,0,374,0,0,"mrc000000000000000549","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H20,\"','\",K2,\"','10','00','\",B20,\"','\",C20,\"','\",A20,\"',\",D20,\",\",E20,\",\",F20,\",0,0);\")","v":"values('mrc000000000000000549','mhbs575004538273665024','10','00','气管柱','0','QGZ',0,374,0,0,0);"}]
["CRM","缠绕膜",0,0,59.5,0,0,"mrc000000000000000550","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H21,\"','\",K2,\"','10','00','\",B21,\"','\",C21,\"','\",A21,\"',\",D21,\",\",E21,\",\",F21,\",0,0);\")","v":"values('mrc000000000000000550','mhbs575004538273665024','10','00','缠绕膜','0','CRM',0,59.5,0,0,0);"}]
["MB","木卡板",0,0,0,150,0,"mrc000000000000000551","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H22,\"','\",K2,\"','10','00','\",B22,\"','\",C22,\"','\",A22,\"',\",D22,\",\",E22,\",\",F22,\",0,0);\")","v":"values('mrc000000000000000551','mhbs575004538273665024','10','00','木卡板','0','MB',0,0,150,0,0);"}]
["JB","胶卡板",0,0,0,200,0,"mrc000000000000000552","insert into merch_rate_cnsmb(cnsmb_rate_sn,merch_sn,cnsmb_type,own_type,prod_name,spec,code,indiv_price,roll_price,board_price,order_cspt,is_valid)",{"$f":"CONCATENATE(\"values('\",H23,\"','\",K2,\"','10','00','\",B23,\"','\",C23,\"','\",A23,\"',\",D23,\",\",E23,\",\",F23,\",0,0);\")","v":"values('mrc000000000000000552','mhbs575004538273665024','10','00','胶卡板','0','JB',0,0,200,0,0);"}]
["生成sql时注意第1,2,3个字段"]