package com.chinaztt.mes.warehouse.excel;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import com.chinaztt.mes.warehouse.util.LocalDateStringConverter;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
import java.time.LocalDateTime;
|
|
/**
|
* @Author: yangyao
|
* @Date: 2022-10-17 9:30
|
*/
|
@Data
|
public class InventoryData {
|
@ExcelProperty("盘点编号")
|
private String inyNo;
|
@ExcelProperty(value="盘点描述")
|
private String inyDesc;
|
@ExcelProperty(value="状态")
|
private String inyStatus;
|
@ExcelProperty(value="创建人")
|
private String createUser;
|
@ExcelProperty(value="创建时间",converter = LocalDateStringConverter.class)
|
private LocalDateTime createTime;
|
@ExcelProperty(value="零件号")
|
private String partNo;
|
@ExcelProperty(value="零件名称")
|
private String partName;
|
@ExcelProperty(value="计划方法(只能传A、K、P)")
|
private String planningMethod;
|
@ExcelProperty(value="sn号")
|
private String sn;
|
@ExcelProperty(value="ifs批次号")
|
private String ifsBatchNo;
|
@ExcelProperty(value="仓库")
|
private String warehouseName;
|
@ExcelProperty(value="库位编号")
|
private String locNo;
|
@ExcelProperty(value="库存数量")
|
private BigDecimal stockQuantity;
|
@ExcelProperty(value="盘点数量")
|
private BigDecimal inyQty;
|
@ExcelProperty(value="盘点差异数量")
|
private BigDecimal inyDiffQty;
|
@ExcelProperty(value="扫码提交次数")
|
private Long commitNum;
|
@ExcelProperty(value="单位")
|
private String unit;
|
}
|