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;
|
|
}
|
