using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
|
/// <summary>
|
/// ERP行明细表 - 存储采购/生产订单行项目详情
|
/// </summary>
|
[SugarTable("ERPLINEDETAILS")] // Oracle表名默认大写
|
public class ErpLineDetailsDB
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_ERPLINEDETAILS_ID")]
|
public long Id { get; set; }
|
|
/// <summary>
|
/// 从表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "MID")]
|
public string Mid { get; set; }
|
|
/// <summary>
|
/// 主表ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "EID")]
|
public string Eid { get; set; }
|
|
/// <summary>
|
/// 子行号（订单项下的细分序号）
|
/// </summary>
|
[SugarColumn(ColumnName = "FLINENO", IsNullable = false)]
|
public string FlineNo { get; set; }
|
|
/// <summary>
|
/// 料品ID（关联物料主数据表的外键）
|
/// </summary>
|
[SugarColumn(ColumnName = "FMATERIALID", IsNullable = false)]
|
public string FMaterialId { get; set; }
|
|
/// <summary>
|
/// 需求数量（业务部门提出的原始需求量）
|
/// </summary>
|
[SugarColumn(ColumnName = "REQQTY")]
|
public decimal? ReqQty { get; set; }
|
|
/// <summary>
|
/// 计划到货数量（经MRP运算后的计划量）
|
/// </summary>
|
[SugarColumn(ColumnName = "PLANNEDQTY")]
|
public decimal? PlannedQty { get; set; }
|
|
/// <summary>
|
/// 供应商确认到货数量（供应商承诺的交货量）
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIERCONFIRMSQTY")]
|
public decimal? SupplierConfirmsQty { get; set; }
|
|
/// <summary>
|
/// 要求交货日期（采购申请或订单要求的到货日期）
|
/// </summary>
|
[SugarColumn(ColumnName = "REQUESTDELIVERYDATE")]
|
public string RequestDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 实际到货数量（仓库实际收货数量）
|
/// </summary>
|
[SugarColumn(ColumnName = "ACTUALARRIVALQTY")]
|
public decimal? ActualArrivalQty { get; set; }
|
}
|
