package com.sunda.spmsoversea.dto;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

/**
 * 导出开发工单
 * @author 0113390
 *
 */
@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class SpmsKulingReportExcel implements Serializable {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	@ColumnWidth(18)
	@ExcelProperty("工厂")
	private String werks;

	@ColumnWidth(18)
	@ExcelProperty("仓库地点")
	private String lgort;

	@ColumnWidth(18)
	@ExcelProperty("物料编码")
	private String matnr;

	@ColumnWidth(18)
	@ExcelProperty("物料描述")
	private String maktx;

	@ColumnWidth(18)
	@ExcelProperty("基本单位")
	private String meins;

	@ColumnWidth(18)
	@ExcelProperty("件数单位")
	private String erfme;

	@ColumnWidth(18)
	@ExcelProperty("库存总数量")
	private String labst;

	@ColumnWidth(18)
	@ExcelProperty("库存总件数")
	private String erfmg;

	@ColumnWidth(18)
	@ExcelProperty("库存总金额")
	private String dmbtr;

	@ColumnWidth(18)
	@ExcelProperty("币种")
	private String waers;

	@ColumnWidth(18)
	@ExcelProperty("30天内件数")
	private String erfmg30;

	@ColumnWidth(18)
	@ExcelProperty("60天内件数")
	private String erfmg60;

	@ColumnWidth(18)
	@ExcelProperty("90天内件数")
	private String erfmg90;

	@ColumnWidth(18)
	@ExcelProperty("120天内件数")
	private String erfmg120;

	@ColumnWidth(18)
	@ExcelProperty("150天内件数")
	private String erfmg150;

	@ColumnWidth(18)
	@ExcelProperty("180天内件数")
	private String erfmg180;

	@ColumnWidth(18)
	@ExcelProperty("210天内件数")
	private String erfmg210;

	@ColumnWidth(18)
	@ExcelProperty("240天内件数")
	private String erfmg240;

	@ColumnWidth(18)
	@ExcelProperty("270天内件数")
	private String erfmg270;

	@ColumnWidth(18)
	@ExcelProperty("300天内件数")
	private String erfmg300;

	@ColumnWidth(18)
	@ExcelProperty("330天内件数")
	private String erfmg330;

	@ColumnWidth(18)
	@ExcelProperty("365天内件数")
	private String erfmg365;

	@ColumnWidth(18)
	@ExcelProperty("365天以上件数")
	private String erfmg366;

	@ColumnWidth(18)
	@ExcelProperty("30天内数量")
	private String labst30;

	@ColumnWidth(18)
	@ExcelProperty("60天内数量")
	private String labst60;

	@ColumnWidth(18)
	@ExcelProperty("90天内数量")
	private String labst90;

	@ColumnWidth(18)
	@ExcelProperty("120天内数量")
	private String labst120;

	@ColumnWidth(18)
	@ExcelProperty("150天内数量")
	private String labst150;

	@ColumnWidth(18)
	@ExcelProperty("180天内数量")
	private String labst180;

	@ColumnWidth(18)
	@ExcelProperty("210天内数量")
	private String labst210;

	@ColumnWidth(18)
	@ExcelProperty("240天内数量")
	private String labst240;

	@ColumnWidth(18)
	@ExcelProperty("270天内数量")
	private String labst270;

	@ColumnWidth(18)
	@ExcelProperty("300天内数量")
	private String labst300;

	@ColumnWidth(18)
	@ExcelProperty("330天内数量")
	private String labst330;

	@ColumnWidth(18)
	@ExcelProperty("365天内数量")
	private String labst365;

	@ColumnWidth(18)
	@ExcelProperty("365天以上数量")
	private String labst366;

	@ColumnWidth(18)
	@ExcelProperty("30天内金额")
	private String dmbtr30;

	@ColumnWidth(18)
	@ExcelProperty("60天内金额")
	private String dmbtr60;

	@ColumnWidth(18)
	@ExcelProperty("90天内金额")
	private String dmbtr90;

	@ColumnWidth(18)
	@ExcelProperty("120天内金额")
	private String dmbtr120;

	@ColumnWidth(18)
	@ExcelProperty("150天内金额")
	private String dmbtr150;

	@ColumnWidth(18)
	@ExcelProperty("180天内金额")
	private String dmbtr180;

	@ColumnWidth(18)
	@ExcelProperty("210天内金额")
	private String dmbtr210;

	@ColumnWidth(18)
	@ExcelProperty("240天内金额")
	private String dmbtr240;

	@ColumnWidth(18)
	@ExcelProperty("270天内金额")
	private String dmbtr270;

	@ColumnWidth(18)
	@ExcelProperty("300天内金额")
	private String dmbtr300;

	@ColumnWidth(18)
	@ExcelProperty("330天内金额")
	private String dmbtr330;

	@ColumnWidth(18)
	@ExcelProperty("365天内金额")
	private String dmbtr365;

	@ColumnWidth(18)
	@ExcelProperty("365天以上金额")
	private String dmbtr366;

	@ColumnWidth(18)
	@ExcelProperty("物料层次")
	private String prdha;

	@ColumnWidth(18)
	@ExcelProperty("物料层次名称-中文")
	private String vtext;




}