//using Admin.NET.Core; //using System.Security.AccessControl; //namespace Admin.NET.Application.Entity; ///// 此视图已废弃,要使用 v_wms_stock_quan_group 【Editby shaocx,2024-07-28】 ///// ///// --物料汇总库存 /////可用库存、总库存、锁定库存、库位、库区、物料、跟踪码等 /////查询条件: 库存状态=3(已上架)且库存质检状态=2(合格)【add by liuwq, 2024/06/14】 ///// //[MySugarTableViewAttribute("v_wms_stock_quan_use_group", "物料可用汇总库存")] //public class v_wms_stock_quan_use_group //{ // /// // /// 物料编码 // /// // [Required] // [SugarColumn(ColumnName = "MaterialCode", ColumnDescription = "物料编码", Length = 50)] // public string MaterialCode { get; set; } // /// // /// 物料名称 // /// // [SugarColumn(ColumnName = "MaterialName", ColumnDescription = "物料名称", Length = 50)] // public string? MaterialName { get; set; } // /// // /// 库存单位 // /// // [SugarColumn(ColumnName = "MaterialUnit", ColumnDescription = "库存单位", Length = 50)] // public string? MaterialUnit { get; set; } // /// // /// 采购单位 // /// // [SugarColumn(ColumnName = "POUnit", ColumnDescription = "采购单位", Length = 50)] // public string? POUnit { get; set; } // /// // ///实物总库存 // /// // [Required] // [SugarColumn(ColumnName = "AllQuantity", ColumnDescription = "实物总库存", Length = 10, DecimalDigits = 3)] // public decimal AllQuantity { get; set; } // /// // ///最终可用库存(已扣减预配锁定数) // ///NotPredetermineLockedQtyAvailableQty-PredetermineLockedQty // /// // [Required] // [SugarColumn(ColumnName = "RealAvailableQty", ColumnDescription = "最终可用库存(已扣减预配锁定数)", Length = 10, DecimalDigits = 3)] // public decimal RealAvailableQty { get; set; } // /// // ///未扣减掉预配锁定数的可用库存 // /// // [Required] // [SugarColumn(ColumnName = "NotPredetermineLockedQtyAvailableQty", ColumnDescription = "未扣减掉预配锁定数的可用库存", Length = 10, DecimalDigits = 3)] // public decimal NotPredetermineLockedQtyAvailableQty { get; set; } // /// // /// 预配锁定数 // /// // [Required] // [SugarColumn(ColumnName = "PredetermineLockedQty", ColumnDescription = "预配锁定数", Length = 10, DecimalDigits = 3)] // public decimal PredetermineLockedQty { get; set; } // /// // /// 跟踪码实物物料锁定数 // /// // [Required] // [SugarColumn(ColumnName = "SNLockedQty", ColumnDescription = "跟踪码实物物料锁定数", Length = 10, DecimalDigits = 3)] // public decimal SNLockedQty { get; set; } //}