DEMOMySql/MicroServices/Business/Bussiness.Model/Sale/wms_seorderentry.cs

using Business.EntityFrameworkCore;
using Business.Models;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Diagnostics;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Volo.Abp.AuditLogging;
using Volo.Abp.Specifications;

namespace Bussiness.Model.Tech
{
    /// <summary>
    ///销售订单明细表
    /// </summary>
    public class wms_seorderentry : BaseEntity
    {
        /// <summary>
        /// 销售订单明细表id
        /// </summary>
        [Key]
        public long seorderentry_id { get; set; }

        /// <summary>
        /// 销售订单id
        /// </summary>
        public long seorder_id { get; set; }

        /// <summary>
        /// 销售订单编号
        /// </summary>
        [StringLength(50)]
        public long bill_no { get; set; }

        /// <summary>
        /// 行号
        /// </summary>
        public int entry_seq { get; set; }

        /// <summary>
        /// 对应代码
        /// </summary>
        [StringLength(255)]
        public string map_number { get; set; }

        /// <summary>
        /// 代码名称
        /// </summary>
        [StringLength(255)]
        public string map_name { get; set; }

        /// <summary>
        /// 产品代码
        /// </summary>
        [StringLength(255)]
        public string item_number { get; set; }

        /// <summary>
        /// FMS旧料号
        /// </summary>
        [StringLength(255)]
        public string fms_number { get; set; }

        /// <summary>
        /// 产品名称
        /// </summary>
        [StringLength(255)]
        public int item_name { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(255)]
        public int specification { get; set; }

        /// <summary>
        /// 加急级别
        /// </summary>
        public int urgent { get; set; }

        /// <summary>
        /// BOM编号
        /// </summary>
        [StringLength(255)]
        public string bom_number { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [StringLength(50)]
        public string unit { get; set; }

        /// <summary>
        /// 订单数量
        /// </summary>
        [DecimalPrecision(20,8)]
        public decimal qty { get; set; }

        /// <summary>
        /// 单价
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal price { get; set; }

        /// <summary>
        /// 含税单价
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal tax_price { get; set; }

        /// <summary>
        /// 金额
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal amount { get; set; }

        /// <summary>
        /// 税率
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal tax_rate { get; set; }

        /// <summary>
        /// 折扣率
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal discount_rate { get; set; }

        /// <summary>
        /// 折扣额
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal discount_amount { get; set; }

        /// <summary>
        /// 实际含税单价
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal aux_price_discount { get; set; }

        /// <summary>
        /// 销项税额
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal tax_amtount { get; set; }

        /// <summary>
        /// 价税合计
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal total_amount { get; set; }

        /// <summary>
        /// 客户要求交期
        /// </summary>
        public DateTime plan_date { get; set; }

        /// <summary>
        /// 最终交货日期
        /// </summary>
        public DateTime date { get; set; }

        /// <summary>
        /// 计划员
        /// </summary>
        [StringLength(50)]
        public string planner_name { get; set; }

        /// <summary>
        /// 计划员_工号
        /// </summary>
        [StringLength(50)]
        public string planner_no { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [StringLength(255)]
        public string remark { get; set; }

        /// <summary>
        /// 源单编号
        /// </summary>
        [StringLength(50)]
        public string soure_bill_no { get; set; }

        /// <summary>
        /// 客户订单号
        /// </summary>
        [StringLength(50)]
        public string custom_order_bill_no { get; set; }

        /// <summary>
        /// 客户订单行号
        /// </summary>
        public int custom_order_entryid { get; set; }

        /// <summary>
        /// 系统建议交期(产能)
        /// </summary>
        public DateTime sys_capacity_date { get; set; }

        /// <summary>
        ///调整建议交期
        /// </summary>
        public DateTime adjust_date { get; set; }

        /// <summary>
        ///调整建议交期
        /// </summary>
        public bool mrp_closed { get; set; }

        /// <summary>
        /// 操作时间
        /// </summary>
        public DateTime op_time { get; set; }

        /// <summary>
        /// 客户料号
        /// </summary>
        [StringLength(50)]
        public string custom_order_itemno { get; set; }

        /// <summary>
        /// 数据状态标识 0停用 1启用
        /// </summary>
        public bool state { get; set; }

        /// <summary>
        /// 评审状态
        /// </summary>
        public int rstate { get; set; }

        /// <summary>
        /// 评审次数
        /// </summary>
        public int rnumber { get; set; }

        /// <summary>
        /// 订单进度
        /// </summary>
        [StringLength(255)]
        public string progress { get; set; }

        /// <summary>
        /// 发货通知单数量
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal deliver_notice_count { get; set; }

        /// <summary>
        /// 发货数量（已出库数量）
        /// </summary>
        [DecimalPrecision(20, 8)]
        public decimal deliver_count { get; set; }

        /// <summary>
        /// 业务员工号
        /// </summary>
        [StringLength(255)]
        public string se_reject_reason { get; set; }

        /// <summary>
        /// 出库类型
        /// </summary>
        [StringLength(50)]
        public string out_stock_type { get; set; }

        /// <summary>
        /// 是否完成检测，0未完成，1完成
        /// </summary>
        public bool is_checked { get; set; }

        /// <summary>
        /// 系统建议交期(物料)
        /// </summary>
        public DateTime sys_material_date { get; set; }

        /// <summary>
        /// 合同编号
        /// </summary>
        public string contract_no { get; set; }

        /// </summary>
        public long create_dept { get; set; }
    }
}