package com.fzzy.async.fzzy61.entity;

import com.alibaba.fastjson.annotation.JSONField;
import com.bstek.dorado.annotation.PropertyDef;
import lombok.Data;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;

/**
 * 综合管理-损溢管理
 *
 * @author: andy.jia
 * @description:
 * @version:
 * @data:2020年5月27日
 */
@Data
@Entity
@Table(name = "D_INOUT_LOSS_OVER")
public class Fz61InoutLossOver implements Serializable {

    public static String SORT_PROP = "updateTime";

    @Id
    @Column(name = "ID_", length = 40)
    @PropertyDef(label = "损益单号", description = "业务日期(yyyyMMdd)+3位顺序号组成")
    private String id;

    @Column(name = "COMPANY_ID_", length = 10)
    @PropertyDef(label = "组织编码")
    private String companyId;

    @Column(name = "DEPT_ID_", length = 40)
    @PropertyDef(label = "所属分库")
    private String deptId;

    @Column(name = "DEPOT_ID_", length = 50)
    @PropertyDef(label = "所属仓库")
    private String depotId;

    @Column(name = "SUBMIT_TIME_")
    @PropertyDef(label = "业务日期", description = "yyyy-MM-dd")
    private Date submitTime;

    @Column(name = "TYPE_", length = 1)
    @PropertyDef(label = "类型", description = "1：损耗，2：损失，3：其他")
    private String type;

    @Column(name = "FOOD_VARIETY_", length = 10)
    @PropertyDef(label = "粮食品种")
    private String foodVariety;

    @Column(name = "FOOD_LEVEL_", length = 10)
    @PropertyDef(label = "粮食等级")
    private String foodLevel;

    @Column(name = "FOOD_TYPE_", length = 10)
    @PropertyDef(label = "粮食性质")
    private String foodType;

    @Column(name = "QUANTITY_ID1", length = 40)
    @PropertyDef(label = "入库质检", description = "数据从MQuantity中获取，上个质检批次")
    private String quantity1;

    @PropertyDef(label = "入库净重", description = "单位：KG")
    @Column(name = "rkjz", precision = 20, scale = 6)
    private Double rkjz;

    @PropertyDef(label = "入库数量", description = "单位：KG")
    @Column(name = "rksl", precision = 20, scale = 6)
    private Double rksl;

    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @PropertyDef(label = "入库时间")
    @Column(name = "rksj")
    private Date rksj;

    @PropertyDef(label = "入库水分(%)")
    @Column(name = "rksf", precision = 20, scale = 6)
    private Double rksf;

    @PropertyDef(label = "入库杂质(%)")
    @Column(name = "rkzz", precision = 20, scale = 6)
    private Double rkzz;

    @Column(name = "QUANTITY_ID2", length = 40)
    @PropertyDef(label = "出库质检", description = "数据从MQuantity中获取，上个质检批次")
    private String quantity2;

    @Column(name = "ccsc")
    @PropertyDef(label = "储存时长", description = "单位：月")
    private Integer ccsc;

    @JSONField(format = "yyyy-MM-dd HH:mm:ss")
    @PropertyDef(label = "出库时间")
    @Column(name = "cksj")
    private Date cksj;

    @PropertyDef(label = "出库净重", description = "单位：KG")
    @Column(name = "ckjz", precision = 20, scale = 6)
    private Double ckjz;

    @PropertyDef(label = "出库水分(%)")
    @Column(name = "cksf", precision = 16, scale = 6)
    private Double cksf;

    @PropertyDef(label = "出库杂质(%)")
    @Column(name = "ckzz", precision = 16, scale = 6)
    private Double ckzz;

    @Column(name = "qzsfkl")
    @PropertyDef(label = "水分减量")
    private Double qzsfkl;

    @Column(name = "qzzzkl")
    @PropertyDef(label = "杂质减量")
    private Double qzzzkl;

    @Column(name = "qzszkl")
    @PropertyDef(label = "水杂总减量")
    private Double qzszkl;

    @Column(name = "qzzrshde")
    @PropertyDef(label = "保管自然损耗")
    private Double qzzrshde;

    @Column(name = "chsl")
    @PropertyDef(label = "超耗数量")
    private Double chsl;

    @Column(name = "AMOUNT_")
    @PropertyDef(label = "损耗量", description = "损溢数量KG；损耗为正数，溢余为负数")
    private Double amount;

    @Column(name = "LOSS_PER_")
    @PropertyDef(label = "损耗率")
    private Double lossPer;

    @PropertyDef(label = "是否超耗")
    @Column(name = "sfch")
    private Integer sfch;

    @PropertyDef(label = "损益是否正常", description = "0：正常 1：不正常")
    @Column(name = "sysfzc", length = 1)
    private String sysfzc;

    @PropertyDef(label = "损溢原因")
    @Column(name = "syyy", length = 400)
    private String syyy;

    @PropertyDef(label = "出清确认标识")
    @Column(name = "cqqrbs")
    private Integer cqqrbs;

    @Column(name = "cqqrsj")
    @PropertyDef(label = "出清确认时间")
    private Date cqqrsj;

    @PropertyDef(label = "仓储审核人")
    @Column(name = "ccshr", length = 64)
    private String ccshr;

    @Column(name = "AUDIT_CCSH_", length = 10)
    @PropertyDef(label = "审批状态")
    private String auditCcsh;

    @Column(name = "INFO_CCSH_", length = 200)
    @PropertyDef(label = "审核说明")
    private String InfoCcsh;

    @PropertyDef(label = "质检审核人")
    @Column(name = "zjshr", length = 64)
    private String zjshr;

    @Column(name = "AUDIT_ZJSH_", length = 10)
    @PropertyDef(label = "审批状态")
    private String auditZjsh;

    @Column(name = "INFO_ZJSH_", length = 200)
    @PropertyDef(label = "审核说明")
    private String infoZjsh;

    @PropertyDef(label = "统计审核人")
    @Column(name = "tjshr", length = 64)
    private String tjshr;

    @Column(name = "AUDIT_TJSH_", length = 10)
    @PropertyDef(label = "审批状态")
    private String auditTjsh;

    @Column(name = "INFO_TJSH_", length = 200)
    @PropertyDef(label = "审核说明")
    private String infoTjsh;

    @PropertyDef(label = "会计审核人")
    @Column(name = "kjshr", length = 64)
    private String kjshr;

    @Column(name = "AUDIT_KJSH_", length = 10)
    @PropertyDef(label = "审批状态")
    private String auditKjsh;

    @Column(name = "INFO_KJSH_", length = 200)
    @PropertyDef(label = "审核说明")
    private String infoKjsh;

    @PropertyDef(label = "领导审核人")
    @Column(name = "ldshr", length = 64)
    private String ldshr;

    @Column(name = "AUDIT_LDSH_", length = 10)
    @PropertyDef(label = "审批状态", description = "最终审核状态以领导审核为准")
    private String auditLdsh;

    @Column(name = "INFO_LDSH_", length = 200)
    @PropertyDef(label = "审核说明")
    private String infoLdsh;

    @Column(name = "REMARK_", length = 300)
    @PropertyDef(label = "备注")
    private String remark;

    @Column(name = "UPDATE_TIME_")
    @PropertyDef(label = "更新时间")
    private Date updateTime;

    @Column(name = "UPDATE_USER_", length = 50)
    @PropertyDef(label = "更新人")
    private String updateUser;

}