package com.example.excel;
|
|
import com.alibaba.excel.annotation.ExcelProperty;
|
import lombok.Data;
|
|
import java.math.BigDecimal;
|
|
@Data
|
public class DataExcelImport {
|
@ExcelProperty("编号(不允许修改、增加和删除")
|
private Integer sortNo;
|
@ExcelProperty("序号")
|
private Integer seqNo;
|
|
@ExcelProperty("二级单位")
|
private String secondaryUnit;
|
|
@ExcelProperty("单位编码")
|
private String unitCode;
|
|
@ExcelProperty("单位名称")
|
private String unitName;
|
|
@ExcelProperty("交易流水号")
|
private String transactionNo;
|
|
@ExcelProperty("摘要")
|
private String summary;
|
|
@ExcelProperty("流水金额")
|
private BigDecimal amount;
|
|
@ExcelProperty("会计期间")
|
private String accountingPeriod;
|
|
@ExcelProperty("凭证号")
|
private String voucherNo;
|
|
@ExcelProperty("BIP合同号")
|
private String bpContractNo;
|
|
@ExcelProperty("合同中心对应合同号")
|
private String contractCenterNo;
|
|
@ExcelProperty("BIP发票号")
|
private String bpInvoiceNo;
|
|
@ExcelProperty("百旺系统对应发票号")
|
private String gkInvoiceNo;
|
|
@ExcelProperty("四者未关联原因")
|
private String businessRelation;
|
|
@ExcelProperty("备注")
|
private String remark;
|
|
@ExcelProperty("PK_VOUCHER")
|
private String pkVoucher;
|
}
|