package com.ruoyi.sales.dto;
|
|
import com.ruoyi.framework.aspectj.lang.annotation.Excel;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
|
/**
|
* 销售发货历史数据导入-已发货
|
*
|
* @author deslrey
|
* @version 1.0
|
* @since 2026/4/22 11:47
|
*/
|
@Data
|
public class SalesShippingImportDto {
|
|
@Excel(name = "自序")
|
private Long sequence;
|
|
@Excel(name = "分厂")
|
private String branchFactory;
|
|
@Excel(name = "价格审核")
|
private String priceAudit;
|
|
@Excel(name = "订单类型")
|
private String orderType;
|
|
@Excel(name = "报表日期", width = 30, dateFormat = "yyyy/MM/dd HH:mm:ss")
|
private Date reportDate;
|
|
@Excel(name = "发货编号")
|
private String shippingNo;
|
|
@Excel(name = "客户编号")
|
private String customerCode;
|
|
@Excel(name = "客户名称")
|
private String customerName;
|
|
@Excel(name = "工程编号")
|
private String projectNo;
|
|
@Excel(name = "项目名称")
|
private String projectName;
|
|
@Excel(name = "结算币种")
|
private String currency;
|
|
@Excel(name = "付款条件")
|
private String paymentTerms;
|
|
@Excel(name = "业务员")
|
private String salesman;
|
|
@Excel(name = "车号")
|
private String carNo;
|
|
@Excel(name = "订单编号")
|
private String orderNo;
|
|
@Excel(name = "合同编号")
|
private String contractNo;
|
|
@Excel(name = "对方单号")
|
private String customerOrderNo;
|
|
@Excel(name = "产品大类")
|
private String productCategory;
|
|
@Excel(name = "产品子类")
|
private String productSubCategory;
|
|
@Excel(name = "产品名称")
|
private String productName;
|
|
@Excel(name = "数量")
|
private BigDecimal quantity;
|
|
@Excel(name = "单价")
|
private BigDecimal unitPrice;
|
|
@Excel(name = "实际面积")
|
private BigDecimal actualArea;
|
|
@Excel(name = "结算面积")
|
private BigDecimal settlementArea;
|
|
@Excel(name = "玻璃金额")
|
private BigDecimal glassAmount;
|
|
@Excel(name = "其他加工费")
|
private BigDecimal otherProcessFee;
|
|
@Excel(name = "金额")
|
private BigDecimal totalAmount;
|
|
@Excel(name = "重箱")
|
private String heavyBox;
|
|
@Excel(name = "重量")
|
private BigDecimal weight;
|
|
@Excel(name = "单据加工要求")
|
private String orderProcessRequirement;
|
|
@Excel(name = "单据备注")
|
private String orderRemark;
|
|
@Excel(name = "审核后备注")
|
private String auditRemark;
|
|
@Excel(name = "送货地址")
|
private String deliveryAddress;
|
|
@Excel(name = "制单员")
|
private String creator;
|
|
@Excel(name = "玻璃厚度")
|
private String glassThickness;
|
|
@Excel(name = "成品厚度")
|
private String productThickness;
|
|
@Excel(name = "mm平方")
|
private BigDecimal mmSquare;
|
|
@Excel(name = "产品简称")
|
private String productShortName;
|
|
@Excel(name = "运输方式")
|
private String transportType;
|
|
@Excel(name = "价格审核人")
|
private String priceAuditor;
|
|
@Excel(name = "价格审核日期", width = 30, dateFormat = "yyyy/MM/dd")
|
private Date priceAuditDate;
|
|
@Excel(name = "联系人")
|
private String contactPerson;
|
|
@Excel(name = "联系电话")
|
private String contactPhone;
|
|
@Excel(name = "一级地区")
|
private String regionLevel1;
|
|
@Excel(name = "二级地区")
|
private String regionLevel2;
|
|
@Excel(name = "打孔")
|
private Integer holeCount;
|
|
@Excel(name = "挖缺")
|
private Integer notchCount;
|
|
@Excel(name = "安全角")
|
private Integer safetyCornerCount;
|
|
@Excel(name = "磨边(异形)")
|
private String irregularGrinding;
|
}
|
