package com.vincent.rsf.server.manager.entity.excel;
|
|
import cn.afterturn.easypoi.excel.annotation.Excel;
|
import com.vincent.rsf.server.manager.entity.excel.annotation.ExcelAutoColumnSize;
|
import com.vincent.rsf.server.manager.entity.excel.annotation.ExcelComment;
|
import lombok.Data;
|
import lombok.EqualsAndHashCode;
|
import lombok.ToString;
|
import lombok.experimental.Accessors;
|
|
import javax.validation.constraints.NotNull;
|
import java.io.Serializable;
|
|
/**
|
* @author Ryan
|
* @version 1.0
|
* @title MatnrsTemplate
|
* @description
|
* @create 2025/3/3 08:40
|
*/
|
@Data
|
public class MatnrsTemplate {
|
|
@NotNull
|
@Excel(name = "物料名称*")
|
@ExcelComment(example = "华为手机")
|
private String name;
|
|
@NotNull
|
@Excel(name = "物料编码*")
|
@ExcelComment(example = "matnr123")
|
private String code;
|
|
|
@Excel(name = "货主标识")
|
@ExcelComment(example = "123")
|
private Long shipperId;
|
|
|
|
@NotNull
|
@Excel(name = "物料分组")
|
@ExcelComment(example = "手机")
|
private Long groupId;
|
|
|
@Excel(name = "ERP编码")
|
@ExcelComment(example = "erp001")
|
private String platCode;
|
|
@NotNull
|
@Excel(name = "规格")
|
@ExcelComment(example = "HW-148*68*10")
|
private String spec;
|
|
@NotNull
|
@Excel(name = "分类名称*")
|
@ExcelComment(example = "移动设备")
|
private String groupName;
|
|
@NotNull
|
@Excel(name = "物料助记码*")
|
@ExcelComment(example = "P3528461569")
|
private String erpCode;
|
|
@NotNull
|
@Excel(name = "型号")
|
@ExcelComment(example = "华为三折叠")
|
private String model;
|
|
@Excel(name = "重量")
|
@ExcelComment(notNull = false, example = "258g")
|
private String weight;
|
|
@Excel(name = "颜色")
|
@ExcelComment(notNull = false, example = "紫红色")
|
private String color;
|
|
@Excel(name = "尺寸")
|
@ExcelComment(notNull = false, example = "148*68*10")
|
private String size;
|
|
@Excel(name = "描述")
|
@ExcelComment(notNull = false, example = "新上市三折叠")
|
private String describle;
|
|
@Excel(name = "标包数量")
|
@ExcelComment(notNull = false, example = "新上市三折叠")
|
private String nromNum;
|
|
@NotNull
|
@Excel(name = "单位")
|
@ExcelComment(example = "部")
|
private String unit;
|
|
@Excel(name = "采购单位")
|
@ExcelComment(example = "部")
|
private String purUnit;
|
|
@Excel(name = "库位单位")
|
@ExcelComment(example = "部")
|
private String stockUnit;
|
|
@NotNull
|
@Excel(name = "分类助记码*")
|
@ExcelComment(example = "256874556")
|
private String groupCode;
|
|
@Excel(name = "ABC类")
|
@ExcelComment(notNull = false, example = "0")
|
private String stockLevel;
|
|
@Excel(name = "安全库存量")
|
@ExcelComment(example = "50")
|
private String safeQty;
|
|
@Excel(name = "最小库存量")
|
@ExcelComment(notNull = false, example = "10")
|
private String minQty;
|
|
@NotNull
|
@Excel(name = "最大库存量")
|
@ExcelComment(notNull = false, example = "150")
|
private String maxQty;
|
|
@Excel(name = "停滞天数")
|
@ExcelComment(notNull = false, example = "25")
|
private String stagn;
|
|
@Excel(name = "有效期")
|
@ExcelComment(notNull = false, example = "25")
|
private String valid;
|
|
@Excel(name = "条形码")
|
@ExcelComment(notNull = false, example = "8001354")
|
private String barcode;
|
|
@Excel(name = "效期预警阈值")
|
@ExcelComment(notNull = false, example = "90")
|
private String validWarn;
|
|
@Excel(name = "是否免检")
|
@ExcelComment(notNull = false, example = "0")
|
private String flagCheck;
|
|
|
}
|
