AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/MaterialWarehouse/InventoryPosting/Entity/AdoInventoryMaster.cs

using SqlSugar;

namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.InventoryPosting.Entity;

/// <summary>
/// DOP-L3 库存汇总账（影子）。**非旧 InvMaster**，DOP 自建、Shadow-only。
/// 自然键据 pr_SFM_InventoryTransactionProcessing2 实核：JOIN/UPDATE 均按 Domain+ItemNum+Location（不含批次，批次维度下沉 LocationDetail）。
/// </summary>
[SugarTable("ado_inventory_master", "DOP-L3库存汇总账(影子,非旧InvMaster)")]
[SugarIndex("uk_ado_inv_master", nameof(TenantId), OrderByType.Asc, nameof(DomainCode), OrderByType.Asc, nameof(ItemNum), OrderByType.Asc, nameof(Location), OrderByType.Asc, IsUnique = true)]
public class AdoInventoryMaster : AdoInvEntityBase
{
    [SugarColumn(ColumnName = "item_num", ColumnDescription = "物料号", Length = 50, IsNullable = false, DefaultValue = "")]
    public string ItemNum { get; set; }

    [SugarColumn(ColumnName = "location", ColumnDescription = "库位", Length = 30, IsNullable = false, DefaultValue = "")]
    public string Location { get; set; }

    [SugarColumn(ColumnName = "qty_on_hand", ColumnDescription = "在手库存", Length = 18, DecimalDigits = 5, DefaultValue = "0")]
    public decimal QtyOnHand { get; set; }

    [SugarColumn(ColumnName = "avail_status_qty", ColumnDescription = "非限制/可用库存", Length = 18, DecimalDigits = 5, DefaultValue = "0")]
    public decimal AvailStatusQty { get; set; }

    [SugarColumn(ColumnName = "assay_qty", ColumnDescription = "质检库存", Length = 18, DecimalDigits = 5, DefaultValue = "0")]
    public decimal AssayQty { get; set; }

    [SugarColumn(ColumnName = "freeze_qty", ColumnDescription = "冻结库存", Length = 18, DecimalDigits = 5, DefaultValue = "0")]
    public decimal FreezeQty { get; set; }

    [SugarColumn(ColumnName = "last_rct_time", ColumnDescription = "最近收货时间", IsNullable = true)]
    public DateTime? LastRctTime { get; set; }

    [SugarColumn(ColumnName = "is_active", ColumnDescription = "是否有效", DefaultValue = "1")]
    public bool IsActive { get; set; }
}