using Business.Core.Attributes; using Microsoft.EntityFrameworkCore; using System; using System.ComponentModel; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace Business.Domain { /// ///销售订单明细表 /// [Comment("销售订单明细表")] [CollectionName("dopbase", "crm_seorderentry")] [Index(nameof(bill_no), nameof(entry_seq), nameof(tenant_id), nameof(factory_id), IsUnique = true)] public class crm_seorderentry : BaseEntity { ///// ///// 销售订单明细表id ///// //[Key] //[Comment("销售订单明细表id")] //public long seorderentry_id { get; set; } /// /// 销售订单id /// [Comment("销售订单id")] public long? seorder_id { get; set; } /// /// 销售订单编号 /// [StringLength(50)] [Comment("销售订单编号")] public string bill_no { get; set; } /// /// 行号 /// [Comment("行号")] public int? entry_seq { get; set; } /// /// 对应代码 /// [StringLength(255)] [Comment("对应代码")] public string map_number { get; set; } /// /// 代码名称 /// [StringLength(255)] [Comment("代码名称")] public string map_name { get; set; } /// /// 产品代码 /// [StringLength(255)] [Comment("产品代码")] public string item_number { get; set; } /// /// FMS旧料号 /// [StringLength(255)] [Comment("FMS旧料号")] public string fms_number { get; set; } /// /// 产品名称 /// [StringLength(255)] [Comment("产品名称")] public string item_name { get; set; } /// /// 规格型号 /// [StringLength(255)] [Comment("规格型号")] public string specification { get; set; } /// /// 加急级别 /// [Comment("加急级别")] public int? urgent { get; set; } /// /// BOM编号 /// [StringLength(255)] [Comment("BOM编号")] public string bom_number { get; set; } /// /// 单位 /// [StringLength(50)] [Comment("单位")] public string unit { get; set; } /// /// 订单数量 /// [Precision(20, 8)] [Comment("订单数量")] public decimal? qty { get; set; } /// /// 单价 /// [Precision(23, 10)] [Comment("单价")] public decimal? price { get; set; } /// /// 含税单价 /// [Precision(23, 10)] [Comment("含税单价")] public decimal? tax_price { get; set; } /// /// 金额 /// [Precision(23, 10)] [Comment("金额")] public decimal? amount { get; set; } /// /// 税率 /// [Precision(23, 10)] [Comment("税率")] public decimal? tax_rate { get; set; } /// /// 折扣率 /// [Precision(23, 10)] [Comment("折扣率")] public decimal? discount_rate { get; set; } /// /// 折扣额 /// [Precision(23, 10)] [Comment("折扣额")] public decimal? discount_amount { get; set; } /// /// 实际含税单价 /// [Precision(23, 10)] [Comment("实际含税单价")] public decimal? aux_price_discount { get; set; } /// /// 销项税额 /// [Precision(23, 10)] [Comment("销项税额")] public decimal? tax_amtount { get; set; } /// /// 价税合计 /// [Precision(23, 10)] [Comment("价税合计")] public decimal? total_amount { get; set; } /// /// 客户要求交期 /// [Comment("客户要求交期")] public DateTime? plan_date { get; set; } /// /// 最终交货日期 /// [Comment("最终交货日期")] public DateTime? date { get; set; } /// /// 计划员 /// [StringLength(50)] [Comment("计划员")] public string planner_name { get; set; } /// /// 计划员_工号 /// [StringLength(50)] [Comment("计划员_工号")] public string planner_no { get; set; } /// /// 备注 /// [StringLength(255)] [Comment("备注")] public string remark { get; set; } /// /// 源单编号 /// [StringLength(50)] [Comment("源单编号")] public string soure_bill_no { get; set; } /// /// 客户订单号 /// [StringLength(50)] [Comment("客户订单号")] public string custom_order_bill_no { get; set; } /// /// 客户订单行号 /// [Comment("客户订单行号")] public int? custom_order_entryid { get; set; } /// /// 系统建议交期(产能) /// [Comment("系统建议交期(产能)")] public DateTime? sys_capacity_date { get; set; } /// ///调整建议交期 /// [Comment("调整建议交期")] public DateTime? adjust_date { get; set; } /// ///调整建议交期 /// [Comment("mrp关闭")] [DefaultValue(false)] public bool? mrp_closed { get; set; } /// /// 操作时间 /// [Comment("操作时间")] public DateTime? op_time { get; set; } /// /// 客户料号 /// [StringLength(80)] [Comment("客户料号")] public string custom_order_itemno { get; set; } /// /// 数据状态标识 0停用 1启用 /// [Comment("数据状态标识 0停用 1启用")] [DefaultValue(true)] public bool? state { get; set; } /// /// 评审状态 /// [Comment("评审状态")] public int? rstate { get; set; } /// /// 评审次数 /// [Comment("评审次数")] public int? rnumber { get; set; } /// /// 订单进度(1,新增 2,检查 3,评审 4,执行 5,发运) 暂定,如需调整需要调整引用位置 /// [StringLength(255)] [Comment("订单进度")] public string progress { get; set; } /// /// 发货通知单数量 /// [Precision(23, 10)] [Comment("发货通知单数量")] public decimal? deliver_notice_count { get; set; } /// /// 发货数量(已出库数量) /// [Precision(23, 10)] [Comment("发货数量(已出库数量)")] public decimal? deliver_count { get; set; } /// /// 业务员工号 /// [StringLength(80)] [Comment("业务员工号")] public string se_reject_reason { get; set; } /// /// 出库类型 /// [StringLength(50)] [Comment("出库类型")] public string out_stock_type { get; set; } /// /// 是否完成检测,0未完成,1完成 /// [Comment("是否完成检测,0未完成,1完成")] public bool? is_checked { get; set; } /// /// 系统建议交期(物料) /// [Comment("系统建议交期(物料)")] public DateTime? sys_material_date { get; set; } /// /// 合同编号 /// [Comment("合同编号")] [StringLength(50)] public string contract_no { get; set; } /// /// 创建部门id /// [Comment("创建部门id")] public long? create_dept { get; set; } /// /// 计算ID /// [Comment("计算id")] [NotMapped] public long? bang_id { get; set; } } }