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