using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     物料库存表
/// </summary>
[SugarTable("MES_INV_ITEM_STOCKS")]
public class MesInvItemStocks
{
    /// <summary>
    ///     SEQ_ME_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

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

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

    /// <summary>
    ///     客户物料编码（无条码手工录入，有条码为冗余字段）
    /// </summary>
    [SugarColumn(ColumnName = "C_ITEM_CODE")]
    public string? CItemCode { get; set; }

    /// <summary>
    ///     本司物料编码（无条码手工录入，有条码为冗余字段）
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     子库id
    /// </summary>
    [SugarColumn(ColumnName = "DEPOTS_ID")]
    public decimal? DepotsId { get; set; }

    /// <summary>
    ///     货位id
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
    public decimal? DepotSectionsId { get; set; }

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

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

    /// <summary>
    ///     环保标志（无条码手工录入，有条码为冗余字段）(0-否，1-是)
    /// </summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public short? EpFlag { get; set; }

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

    /// <summary>
    ///     重量
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_WT")]
    public decimal? ItemWt { get; set; }

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

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

    /// <summary>
    ///     检验日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     0 物料 1 半成品 2 成品
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_TYPE")]
    public short? ItemType { get; set; }

    /// <summary>
    ///     入库日期
    /// </summary>
    [SugarColumn(ColumnName = "INDEP_DATE")]
    public DateTime? IndepDate { 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 = "IQC_STATUS")]
    public string? IqcStatus { get; set; }

    /// <summary>
    ///     小车条码
    /// </summary>
    [SugarColumn(ColumnName = "FCAR")]
    public string? Fcar { get; set; }

    /// <summary>
    ///     冻结提交重检，0：未提交，1：已提交
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_SUBMIT")]
    public short? VisibleSubmit { get; set; }

    /// <summary>
    ///     提交重检人
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_SUBMIT_BY")]
    public string? VisibleSubmitBy { get; set; }

    /// <summary>
    ///     提交重检时间
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_SUBMIT_DATE")]
    public DateTime? VisibleSubmitDate { get; set; }

    /// <summary>
    ///     产品型号
    /// </summary>
    [SugarColumn(ColumnName = "BOARD_STYLE")]
    public string? BoardStyle { get; set; }

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

    /// <summary>
    ///     任务单行号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_LINE")]
    public decimal? 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>
    ///     单号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }

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

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

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

    /// <summary>
    ///     是否专用
    /// </summary>
    [SugarColumn(ColumnName = "IS_ZY")]
    public decimal? IsZy { get; set; }

    /// <summary>
    ///     销售订单
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER")]
    public string? SalesOrder { get; set; }

    /// <summary>
    ///     是否已冻结,1冻结
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE")]
    public short? Visible { get; set; }

    /// <summary>
    ///     是否寄存
    /// </summary>
    [SugarColumn(ColumnName = "IS_JC")]
    public decimal? IsJc { get; set; }

    /// <summary>
    ///     寄存工单
    /// </summary>
    [SugarColumn(ColumnName = "JC_BILL_NO")]
    public string? JcBillNo { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "FMTONO")]
    public string? Fmtono { get; set; }

    /// <summary>
    ///     中箱码
    /// </summary>
    [SugarColumn(ColumnName = "MEDIUMBOXCODE")]
    public string? MediumBoxCode { get; set; }

    /// <summary>
    ///     栈板码
    /// </summary>
    [SugarColumn(ColumnName = "STACKCODE")]
    public string? StackCode { get; set; }

    /// <summary>
    ///     仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_ID")]
    public decimal? DepotId { get; set; }

    /// <summary>
    ///     大箱条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE_D")]
    public string? ItemBarcodeD { get; set; }

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

    /// <summary>
    ///     是否推送
    /// </summary>
    [SugarColumn(ColumnName = "IS_TS")]
    public decimal? IsTs { get; set; }

    /// <summary>
    ///     冻结更新人
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_UPDATE_BY")]
    public string? VisibleUpdateBy { get; set; }

    /// <summary>
    ///     冻结更新时间
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_UPDATE_DATE")]
    public DateTime? VisibleUpdateDate { get; set; }

    /// <summary>
    ///     冻结更新理由
    /// </summary>
    [SugarColumn(ColumnName = "VISIBLE_UPDATE_REASON")]
    public string? VisibleUpdateReason { get; set; }

    /// <summary>
    ///     注释
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }
}