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