package com.zy.asrs.common.domain.entity; import com.alibaba.excel.annotation.ExcelIgnoreUnannotated; import com.alibaba.excel.annotation.ExcelProperty; import com.zy.asrs.common.wms.entity.Mat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; /** * 0.A 1.B 2.C 3.D 4.E 5.F 6.G 7.H 8.I * 9.J 10.K 11.L 12.M 13.N 14.O 15.P 16.Q 17.R 18.S * 19.T 20.U 21.V 22.W 23.X 24.Y 25.Z */ @Data @ExcelIgnoreUnannotated public class MatExcel extends Mat { @ExcelProperty(index = 0, value = "一级分类") private String priClass; @ExcelProperty(index = 1, value = "二级分类") private String secClass; @ExcelProperty(index = 2, value = "品号") private String matnr; @ExcelProperty(index = 3, value = "商品名称") private String maktx; @ExcelProperty(index = 4, value = "主要仓库") private String mainHost; @ExcelProperty(index = 5, value = "主要来源") private String mainSource; @ExcelProperty(index = 6, value = "条码") private String barcode; @ExcelProperty(index = 7, value = "循环盘点码") private String cyclePickCode; @ExcelProperty(index = 8, value = "存放位置") private String locationStock; @ExcelProperty(index = 9, value = "材质") private String material; @ExcelProperty(index = 10, value = "机型") private String model; @ExcelProperty(index = 11, value = "制令") private String decrees; @ExcelProperty(index = 12, value = "重量") private String weight; @ExcelProperty(index = 13, value = "图号") private String imgNum; @ExcelProperty(index = 14, value = "采购单位") private String purchasingUnits; @ExcelProperty(index = 15, value = "工艺编号") private String processNumber; @ExcelProperty(index = 16, value = "指定bom") private String bom; @ExcelProperty(index = 17, value = "安全存量") private String safeNum; @ExcelProperty(index = 18, value = "最低补量") private String miniCount; @ExcelProperty(index = 19, value = "补货倍量") private String replenishmentNum; @ExcelProperty(index = 20, value = "自定义1") private String tmp1; @ExcelProperty(index = 21, value = "自定义2") private String tmp2; @ExcelProperty(index = 22, value = "自定义3") private String tmp3; @ExcelProperty(index = 23, value = "按需求补货") private String restockDemand; @ExcelProperty(index = 24, value = "失效") private String lapse; @ExcelProperty(index = 25, value = "快捷码") private String shortcuts; @ExcelProperty(index = 26, value = "计量单位") private String units; @ExcelProperty(index = 27, value = "长度") private String length; @ExcelProperty(index = 28, value = "宽度") private String width; @ExcelProperty(index = 29, value = "高度") private String height; @ExcelProperty(index = 30, value = "会计分类") private String accountingClass; @ExcelProperty(index = 31, value = "批号管理") private String batch; @ExcelProperty(index = 32, value = "存货核算") private String inventoryAccount; @ExcelProperty(index = 33, value = "规格") private String specs; }