using SqlSugar;

namespace NewPdaSqlServer.entity;

/// <summary>
///     库存交易记录表
/// </summary>
[SugarTable("MES_INV_BUSINESS2")]
public class MesInvBusiness2
{
    /// <summary>
    ///     ID(seq_inv_id)
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     状态|0-未交易1-已交易
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public long? Status { get; set; }

    /// <summary>
    ///     单据类型ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_TYPE_ID")]
    public long? BillTypeId { get; set; }

    /// <summary>
    ///     事务类型编码
    /// </summary>
    [SugarColumn(ColumnName = "TRANSACTION_CODE")]
    public string? TransactionCode { get; set; }

    /// <summary>
    ///     交易类型|1-入库0-转库-1出库
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public long? BusinessType { get; set; }

    /// <summary>
    ///     单据ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_ID")]
    public long? BillId { get; set; }

    /// <summary>
    ///     单据编码
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }

    /// <summary>
    ///     生产订单号
    /// </summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string? TaskNo { get; set; }

    /// <summary>
    ///     客户编号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_NO")]
    public string? CustomerNo { get; set; }

    /// <summary>
    ///     单据行ID
    /// </summary>
    [SugarColumn(ColumnName = "BILL_LINE_ID")]
    public long? BillLineId { get; set; }

    /// <summary>
    ///     物料条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE")]
    public string? ItemBarcode { get; set; }

    /// <summary>
    ///     本司物料编码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     客户物料编码
    /// </summary>
    [SugarColumn(ColumnName = "C_ITEM_CODE")]
    public string? CItemCode { get; set; }

    /// <summary>
    ///     厂家批次
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NO")]
    public string? LotNo { get; set; }

    /// <summary>
    ///     是否环保(0:否,1:是)
    /// </summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public bool? EpFlag { get; set; }

    /// <summary>
    ///     数量
    /// </summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

    /// <summary>
    ///     源子库CODE
    /// </summary>
    [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
    public string? FromInvDepotsCode { get; set; }

    /// <summary>
    ///     源货位CODE
    /// </summary>
    [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
    public string? FromInvDepotSectionsCode { get; set; }

    /// <summary>
    ///     目的子库CODE
    /// </summary>
    [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
    public string? ToInvDepotsCode { get; set; }

    /// <summary>
    ///     目的货位CODE
    /// </summary>
    [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
    public string? ToInvDepotSectionsCode { get; set; }

    /// <summary>
    ///     交易异常信息
    /// </summary>
    [SugarColumn(ColumnName = "DESCRIPTION")]
    public string? Description { get; set; }

    /// <summary>
    ///     创建人
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string? CreateBy { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     最后更新人
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string? LastupdateBy { get; set; }

    /// <summary>
    ///     最后更新时间
    /// </summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    ///     超损统计标识
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
    public bool? UllageStatFlag { get; set; }

    /// <summary>
    ///     分厂编码
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string? Factory { get; set; }

    /// <summary>
    ///     公司代码
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string? Company { get; set; }

    /// <summary>
    ///     箱号条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE2")]
    public string? ItemBarcode2 { get; set; }

    /// <summary>
    ///     卡板条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE3")]
    public string? ItemBarcode3 { get; set; }

    /// <summary>
    ///     任务单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_NO")]
    public string? WorkNo { get; set; }

    /// <summary>
    ///     任务单行号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_LINE")]
    public int? WorkLine { get; set; }

    /// <summary>
    ///     供应商
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }

    /// <summary>
    ///     生产线
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string? LineNo { get; set; }

    /// <summary>
    ///     采购订单id
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public long? EbelnK3id { get; set; }

    /// <summary>
    ///     采购订单行id
    /// </summary>
    [SugarColumn(ColumnName = "LINE_K3ID")]
    public long? LineK3id { get; set; }

    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public long? ItemId { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_ID")]
    public string? SuppId { get; set; }

    /// <summary>
    ///     源仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "FROM_DEPOT_ID")]
    public int? FromDepotId { get; set; }

    /// <summary>
    ///     目的仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOT_ID")]
    public int? InvDepotId { get; set; }

    /// <summary>
    ///     mes单据明细行id
    /// </summary>
    [SugarColumn(ColumnName = "MES_LINE")]
    public Guid? MesLine { get; set; }
}