package com.sunda.spmsorder.entity.vo;

import com.github.crab2died.annotation.ExcelField;

import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
/**
 * 收货效率统计报表导出类
 * @author 0113389
 *
 */
@Data
public class ReceivingGoodsReportVO {

	@ApiModelProperty(value = "工厂")
	@ExcelField(title = "werks", order = 1)
	String werks;

	@ApiModelProperty(value = "仓库地点")
	@ExcelField(title = "whsLocationCode", order = 2)
	String whsLocationCode;

	@ApiModelProperty(value = "单据类型")
	@ExcelField(title = "orderType", order = 3)
	String orderType;

	@ApiModelProperty(value = "SAP交货单")
	@ExcelField(title = "sapDeliveyNote", order = 4)
	String sapDeliveyNote;

	@ApiModelProperty(value = "交货单行号")
	@ExcelField(title = "sapDeliveyNoteItem", order = 5)
	String sapDeliveyNoteItem;

	@ApiModelProperty(value = "交货单状态")
	@ExcelField(title = "spmsStatus", order = 6)
	String spmsStatus;

	@ApiModelProperty(value = "采购订单")
	@ExcelField(title = "purchaseNo", order = 7)
	String purchaseNo;

	@ApiModelProperty(value = "采购订单行项目")
	@ExcelField(title = "purchaseNoItem", order = 8)
	String purchaseNoItem;

	@ApiModelProperty(value = "装箱单")
	@ExcelField(title = "sapPackageList", order = 9)
	String sapPackageList;

	@ApiModelProperty(value = "柜号")
	@ExcelField(title = "cabinetNumber", order = 10)
	String cabinetNumber;

	@ApiModelProperty(value = "SPMS入库单")
	@ExcelField(title = "spmsId", order = 11)
	String spmsId;

	@ApiModelProperty(value = "入库单状态")
	@ExcelField(title = "inSpmsStatus", order = 12)
	String inSpmsStatus;

	@ApiModelProperty(value = "需求单号")
	@ExcelField(title = "requirementNo", order = 13)
	String requirementNo;

	@ApiModelProperty(value = "需求申请人")
	@ExcelField(title = "demander", order = 14)
	String demander;

	@ApiModelProperty(value = "箱码")
	@ExcelField(title = "boxNote", order = 15)
	String boxNote;

	@ApiModelProperty(value = "物料编码")
	@ExcelField(title = "materialNo", order = 16)
	String materialNo;

	@ApiModelProperty(value = "物料描述")
	@ExcelField(title = "materialZhDesc", order = 17)
	String materialZhDesc;

	@ApiModelProperty(value = "应收数量")
	@ExcelField(title = "receivableQtyBasicUnit", order = 18)
	String receivableQtyBasicUnit;

	@ApiModelProperty(value = "实收数量")
	@ExcelField(title = "actualQtyBasicUnit", order = 19)
	String actualQtyBasicUnit;

	@ApiModelProperty(value = "基本单位")
	@ExcelField(title = "basicUnit", order = 20)
	String basicUnit;

	@ApiModelProperty(value = "应收件数")
	@ExcelField(title = "receivableQtyUnitSales", order = 21)
	String receivableQtyUnitSales;

	@ApiModelProperty(value = "实收件数")
	@ExcelField(title = "actualQtyUnitSales", order = 22)
	String actualQtyUnitSales;

	@ApiModelProperty(value = "销售单位")
	@ExcelField(title = "unitSale", order = 23)
	String unitSale;

	@ApiModelProperty(value = "交货时间")
	@ExcelField(title = "deliveryDate", order = 24)
	String deliveryDate;

	@ApiModelProperty(value = "到达时间")
	@ExcelField(title = "arrivalTime", order = 25)
	String arrivalTime;

	@ApiModelProperty(value = "入库创建时间")
	@ExcelField(title = "inWhsCreateTime", order = 26)
	String inWhsCreateTime;

	@ApiModelProperty(value = "审批时间")
	@ExcelField(title = "approvalDate", order = 27)
	String approvalDate;

	@ApiModelProperty(value = "入库完成时间")
	@ExcelField(title = "inWhsEndTime", order = 28)
	String inWhsEndTime;

	@ApiModelProperty(value = "OA审批时间")
	@ExcelField(title = "oaApprovalDate", order = 29)
	String oaApprovalDate;

	@ApiModelProperty(value = "少收过账时间")
	@ExcelField(title = "underchargePostingDate", order = 30)
	String underchargePostingDate;

	@ApiModelProperty(value = "多收过账时间")
	@ExcelField(title = "overchargePostingDate", order = 31)
	String overchargePostingDate;

	@ApiModelProperty(value = "交货完成时间")
	@ExcelField(title = "receivingDate", order = 32)
	String receivingDate;
	
	@ApiModelProperty(value = "SAP物料凭证")
	@ExcelField(title = "sapVoucherNumber", order = 33)
	String sapVoucherNumber;
	
	@ApiModelProperty(value = "SAP少收物料凭证")
	@ExcelField(title = "underVoucherNumber", order = 34)
	String underVoucherNumber;
	
	@ApiModelProperty(value = "SAP多收物料凭证")
	@ExcelField(title = "overVoucherNumber", order = 35)
	String overVoucherNumber;
	
	@ApiModelProperty(value = "操作用户")
	@ExcelField(title = "createUser", order = 36)
	String createUser;
	
	@ApiModelProperty(value = "入库耗时")
	@ExcelField(title = "timeWarehousing", order = 37)
	String timeWarehousing;
	
	@ApiModelProperty(value = "交货耗时")
	@ExcelField(title = "timeDelivery", order = 38)
	String timeDelivery;
	
	@ApiModelProperty(value = "查询日期")
	@ExcelField(title = "nowDate", order = 39)
	String nowDate;
}