package com.ga.core.vo.ledger;

import com.ga.common.annotation.ExcelColumn;
import lombok.Data;

import java.math.BigDecimal;

@Data
public class LedgerExcelVO {
    @ExcelColumn(header = "정산월",     order = 1, width = 10)
    private String settleMonth;
    @ExcelColumn(header = "증권번호",   order = 2, width = 18)
    private String policyNo;
    @ExcelColumn(header = "설계사명",   order = 3, width = 12)
    private String agentName;
    @ExcelColumn(header = "소속",       order = 4, width = 18)
    private String orgName;
    @ExcelColumn(header = "보험사",     order = 5, width = 14)
    private String companyName;
    @ExcelColumn(header = "상품",       order = 6, width = 24)
    private String productName;
    @ExcelColumn(header = "보험종류",   order = 7, width = 10, codeGroup = "INSURANCE_TYPE")
    private String insuranceType;
    @ExcelColumn(header = "보험료",     order = 8, width = 14, format = "#,##0")
    private BigDecimal premium;
    @ExcelColumn(header = "회사수수료율", order = 9, width = 12, format = "0.00")
    private BigDecimal companyRate;
    @ExcelColumn(header = "회사수수료", order = 10, width = 14, format = "#,##0")
    private BigDecimal companyAmount;
    @ExcelColumn(header = "지급율",     order = 11, width = 10, format = "0.00")
    private BigDecimal payoutRate;
    @ExcelColumn(header = "설계사수수료", order = 12, width = 14, format = "#,##0")
    private BigDecimal agentAmount;
    @ExcelColumn(header = "세액",       order = 13, width = 12, format = "#,##0")
    private BigDecimal taxAmount;
}
