namespace Admin.NET.Plugin.AiDOP.Universal;

/// <summary>
/// 物料主数据（ItemMaster 表，外部 ERP 表，只读映射）
/// </summary>
[IgnoreTable]
[SugarTable("ItemMaster", "物料主数据")]
public class ItemMaster
{
    /// <summary>自增列</summary>
    [SugarColumn(ColumnName = "RecID", IsPrimaryKey = true, IsIdentity = true)]
    public int RecID { get; set; }

    /// <summary>域名</summary>
    [SugarColumn(ColumnName = "Domain", Length = 8, IsNullable = true)]
    public string? Domain { get; set; }

    /// <summary>零件号</summary>
    [SugarColumn(ColumnName = "ItemNum", Length = 30, IsNullable = true)]
    public string? ItemNum { get; set; }

    /// <summary>描述</summary>
    [SugarColumn(ColumnName = "Descr", Length = 60, IsNullable = true)]
    public string? Descr { get; set; }

    /// <summary>描述1</summary>
    [SugarColumn(ColumnName = "Descr1", Length = 60, IsNullable = true)]
    public string? Descr1 { get; set; }

    /// <summary>单位</summary>
    [SugarColumn(ColumnName = "UM", Length = 4, IsNullable = true)]
    public string? UM { get; set; }

    /// <summary>库位</summary>
    [SugarColumn(ColumnName = "Location", Length = 10, IsNullable = true)]
    public string? Location { get; set; }

    /// <summary>版本</summary>
    [SugarColumn(ColumnName = "Rev", Length = 4, IsNullable = true)]
    public string? Rev { get; set; }

    /// <summary>图纸</summary>
    [SugarColumn(ColumnName = "Drawing", Length = 30, IsNullable = true)]
    public string? Drawing { get; set; }

    /// <summary>状态</summary>
    [SugarColumn(ColumnName = "Status", Length = 1, IsNullable = true)]
    public string? Status { get; set; }

    /// <summary>零件类型</summary>
    [SugarColumn(ColumnName = "ItemType", Length = 2, IsNullable = true)]
    public string? ItemType { get; set; }

    /// <summary>P/L 件（P=采购/L=制造）</summary>
    [SugarColumn(ColumnName = "PurMfg", Length = 1, IsNullable = true)]
    public string? PurMfg { get; set; }

    /// <summary>地点</summary>
    [SugarColumn(ColumnName = "Site", Length = 8, IsNullable = true)]
    public string? Site { get; set; }

    /// <summary>购买者</summary>
    [SugarColumn(ColumnName = "Buyer", Length = 8, IsNullable = true)]
    public string? Buyer { get; set; }

    /// <summary>计划员</summary>
    [SugarColumn(ColumnName = "Planner", Length = 8, IsNullable = true)]
    public string? Planner { get; set; }

    /// <summary>生产线</summary>
    [SugarColumn(ColumnName = "ProdLine", Length = 10, IsNullable = true)]
    public string? ProdLine { get; set; }

    /// <summary>采购计量单位</summary>
    [SugarColumn(ColumnName = "PurUM", Length = 4, IsNullable = true)]
    public string? PurUM { get; set; }

    /// <summary>变更日期</summary>
    [SugarColumn(ColumnName = "ModDate", IsNullable = true)]
    public DateTime? ModDate { get; set; }

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

    /// <summary>更新时间</summary>
    [SugarColumn(ColumnName = "UpdateTime", IsNullable = true)]
    public DateTime? UpdateTime { get; set; }

    /// <summary>有效</summary>
    [SugarColumn(ColumnName = "IsActive", IsNullable = true)]
    public int? IsActive { get; set; }

    /// <summary>备注</summary>
    [SugarColumn(ColumnName = "Remark", Length = 255, IsNullable = true)]
    public string? Remark { get; set; }
}