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; }
    }