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