using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 收料单明细表（对应MES_INV_ITEM_ARN_DETAIL表）
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_ARN_DETAIL")]
|
public class MesInvItemArnDetail
|
{
|
// /// <summary>
|
// /// 收料通知单分录内码
|
// /// </summary>
|
// [SugarColumn(IsPrimaryKey = true)] // 默认为主键（若实际主键不是该字段，可根据业务调整主键配置）
|
// public int? LineNo { get; set; }
|
|
/// <summary>
|
/// 采购单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln")]
|
public string? Ebeln { get; set; }
|
/// <summary>
|
/// 明细表记录唯一标识（主键）
|
/// </summary>
|
[SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
/// 关联主表（MES_INV_ITEM_ARN）的 ID
|
/// </summary>
|
[SugarColumn(ColumnName = "parent_Guid")]
|
public Guid? Mid { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "item_id")]
|
public int? ItemId { get; set; }
|
|
/// <summary>
|
/// 采购订单数量
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln_qty")]
|
public decimal? EbelnQty { get; set; }
|
|
/// <summary>
|
/// 本次应收数量
|
/// </summary>
|
[SugarColumn(ColumnName = "sub_qty")]
|
public decimal? SubQty { get; set; }
|
|
/// <summary>
|
/// 本次实收数量
|
/// </summary>
|
[SugarColumn(ColumnName = "quantity")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PurchaseUnit")] // 未提供具体MES标识，默认按属性名映射（若实际字段名不同，需补充ColumnName）
|
public string? PurchaseUnit { get; set; }
|
|
/// <summary>
|
/// 库存单位
|
/// </summary>
|
[SugarColumn(ColumnName = "InventoryUnit")] // 未提供具体MES标识，默认按属性名映射（若实际字段名不同，需补充ColumnName）
|
public string? InventoryUnit { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "memo")]
|
public string? Memo { get; set; }
|
|
/// <summary>
|
/// 采购单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln_k3id")]
|
public int? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 采购单行ID
|
/// </summary>
|
[SugarColumn(ColumnName = "line_k3id")]
|
public int? LineK3id { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn (ColumnName = "SalesOrderId")] // 未提供具体MES标识，默认按属性名映射（若实际字段名不同，需补充ColumnName）
|
|
public string? SalesOrderId { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "MtoNo")] // 未提供具体MES标识，默认按属性名映射（若实际字段名不同，需补充ColumnName）
|
public string? MtoNo { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "Lot")] // 未提供具体MES标识，默认按属性名映射（若实际字段名不同，需补充ColumnName）
|
public string? Lot { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[SugarColumn(ColumnName = "urgent_flag")]
|
public bool? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 收货仓库编号
|
/// </summary>
|
[SugarColumn(ColumnName = "Depot_Id")]
|
public string? DepotId { get; set; }
|
|
/// <summary>
|
/// 发货单行ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DeliveryLineID")]
|
public int? DeliveryLineID { get; set; }
|
/// <summary>
|
/// 发货单行ID
|
/// </summary>
|
[SugarColumn(ColumnName = "Eid")]
|
public int? Eid { get; set; }
|
|
|
}
|
