using SqlSugar; namespace MES.Service.Modes; /// /// 部门生产订单信息表 /// [SugarTable("MES_DEP_TASK_INFO")] public class MesDepTaskInfo { /// /// 部门生产订单ID /// [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// /// 订单编号 /// [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// /// ERP物料编号 /// [SugarColumn(ColumnName = "ERP_ITEM_NO")] public string ErpItemNo { get; set; } /// /// 工单数量 /// [SugarColumn(ColumnName = "PLAN_QTY")] public decimal? PlanQty { get; set; } /// /// 已生产量 /// [SugarColumn(ColumnName = "COMPLETE_QTY")] public decimal? CompleteQty { get; set; } /// /// 备损数量 /// [SugarColumn(ColumnName = "BACKUP_QTY")] public decimal? BackupQty { get; set; } /// /// 下载时间 /// [SugarColumn(ColumnName = "DOWN_TIME")] public DateTime? DownTime { get; set; } /// /// 计划开始时间 /// [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")] public DateTime? PlanBeginTime { get; set; } /// /// 计划结束时间 /// [SugarColumn(ColumnName = "PLAN_FINISH_TIME")] public DateTime? PlanFinishTime { get; set; } /// /// 实际完工时间 /// [SugarColumn(ColumnName = "REAL_FINISH_TIME")] public DateTime? RealFinishTime { get; set; } /// /// 生产状态(待产\生产\挂起\完工) /// [SugarColumn(ColumnName = "PRODUCE_STATE")] public string ProduceState { get; set; } /// /// 实际开工时间 /// [SugarColumn(ColumnName = "REAL_BEGIN_TIME")] public DateTime? RealBeginTime { get; set; } /// /// 是否挂起 /// [SugarColumn(ColumnName = "HANG_UP")] public string HangUp { get; set; } /// /// 仓库编号 /// [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// /// 报废数量 /// [SugarColumn(ColumnName = "DISCARD_QTY")] public decimal? DiscardQty { get; set; } /// /// 始收料时间 /// [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")] public DateTime? FirstItemReceiptTime { get; set; } /// /// 始齐料时间 /// [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")] public DateTime? FirstItemReadyTime { get; set; } /// /// 客户编号 /// [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// /// 出货包装方式 /// [SugarColumn(ColumnName = "PACK_SHIP_TYPE")] public string PackShipType { get; set; } /// /// 包装注意事项 /// [SugarColumn(ColumnName = "PACK_SHIP_MEMO")] public string PackShipMemo { get; set; } /// /// 是否已排产 /// [SugarColumn(ColumnName = "ISSCHEME")] public short? Isscheme { get; set; } /// /// 条码类型ID /// [SugarColumn(ColumnName = "BARCODE_TYPE_ID")] public decimal? BarcodeTypeId { get; set; } /// /// 发布状态 /// [SugarColumn(ColumnName = "ISSUE_STATUS")] public short? IssueStatus { get; set; } /// /// 状态(0=排产未发布、1=排产已发布、2=已领料、3=已生产、4=暂停、8=已完工、9=异常) /// [SugarColumn(ColumnName = "FLAG")] public short? Flag { get; set; } /// /// 领料时间 /// [SugarColumn(ColumnName = "MAT_DATE")] public DateTime? MatDate { get; set; } /// /// 工作中心 /// [SugarColumn(ColumnName = "WORKCENTER_NO")] public string WorkcenterNo { get; set; } /// /// 已下载订单标识Y-已下载,N-未下载 /// [SugarColumn(ColumnName = "DOWN_FLAG")] public short? DownFlag { get; set; } /// /// 环保代码 /// [SugarColumn(ColumnName = "ROHSE_CODE")] public string RohseCode { get; set; } /// /// 客户PO /// [SugarColumn(ColumnName = "CUST_PO")] public string CustPo { get; set; } /// /// 客户型号 /// [SugarColumn(ColumnName = "CUST_STYLE")] public string CustStyle { get; set; } /// /// 产品打印固定值 /// [SugarColumn(ColumnName = "PROC_PRINT_VALUE")] public string ProcPrintValue { get; set; } /// /// 创建人 /// [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// /// 创建时间 /// [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// /// 更新人 /// [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// /// 更新时间 /// [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// /// 备注 /// [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// /// 审批状态 /// [SugarColumn(ColumnName = "FCHECK_STATUS")] public string FcheckStatus { get; set; } /// /// 审核人 /// [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// /// 审核日期 /// [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// /// 工厂 /// [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// /// 公司 /// [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// /// 数据来源 /// [SugarColumn(ColumnName = "DATA_FROM")] public string DataFrom { get; set; } /// /// 生产订单表头ID /// [SugarColumn(ColumnName = "MOID")] public decimal? Moid { get; set; } /// /// 物料ID /// [SugarColumn(ColumnName = "PARTID")] public decimal? Partid { get; set; } /// /// ERP工单状态 状态(NA-开立/FM-锁定/OP-审核/CL-关闭) /// [SugarColumn(ColumnName = "STATUS")] public string Status { get; set; } /// /// 生产工单 /// [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// /// 创建日期 /// [SugarColumn(ColumnName = "CREATEDATE")] public DateTime? Createdate { get; set; } /// /// 颜色 /// [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// /// 关闭时间 /// [SugarColumn(ColumnName = "CLOSETIME")] public DateTime? Closetime { get; set; } /// /// 物料编号 /// [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// /// 从表ID /// [SugarColumn(ColumnName = "MODID")] public decimal? Modid { get; set; } /// /// 最新下载更新标识 /// [SugarColumn(ColumnName = "UPDATE_FLG")] public decimal? UpdateFlg { get; set; } /// /// 生产工单行号 /// [SugarColumn(ColumnName = "MOCODE_LINE")] public decimal? MocodeLine { get; set; } /// /// 丝印总数 /// [SugarColumn(ColumnName = "SILK_QTY")] public decimal? SilkQty { get; set; } /// /// 丝印单价 /// [SugarColumn(ColumnName = "SILK_PRICE")] public decimal? SilkPrice { get; set; } /// /// 物料ID /// [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } }