using Admin.NET.Core;
|
using System.Security.AccessControl;
|
namespace Admin.NET.Application.Entity;
|
|
/// <summary>
|
/// --物料汇总库存
|
///可用库存、总库存、锁定库存、库位、库区、物料、跟踪码等
|
///查询条件： 库存状态=3（已上架）且库存质检状态=2（合格）【add by liuwq, 2024/06/14】
|
/// </summary>
|
[MySugarTableViewAttribute("v_wms_stock_quan_group", "物料汇总库存")]
|
public class v_wms_stock_quan_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>
|
[SugarColumn(ColumnName = "Quantity", ColumnDescription = "全部库存", Length = 10, DecimalDigits = 3)]
|
public decimal Quantity { get; set; }
|
|
|
|
/// <summary>
|
///预配数
|
/// </summary>
|
[SugarColumn(ColumnName = "PredetermineLockedQty", ColumnDescription = "预配数", Length = 10, DecimalDigits = 3)]
|
public decimal PredetermineLockedQty { get; set; }
|
|
/// <summary>
|
///理论可用库存（包含了预配数）
|
/// </summary>
|
[SugarColumn(ColumnName = "TheoryUseQty", ColumnDescription = "理论可用库存（包含了预配数）", Length = 10, DecimalDigits = 3)]
|
public decimal TheoryUseQty { get; set; }
|
|
|
/// <summary>
|
///可用库存
|
/// </summary>
|
[SugarColumn(ColumnName = "UseQty", ColumnDescription = "可用库存", Length = 10, DecimalDigits = 3)]
|
public decimal UseQty { get; set; }
|
|
|
/// <summary>
|
///其他不可用库存
|
/// </summary>
|
[SugarColumn(ColumnName = "OtherLockQty", ColumnDescription = "其他不可用库存", Length = 10, DecimalDigits = 3)]
|
public decimal OtherLockQty { get; set; }
|
|
|
|
|
|
}
|
