using SqlSugar;
|
using System.ComponentModel;
|
|
namespace MES.Service.Modes;
|
|
[SugarTable("MES_ITEM_QTRR_DETAIL")]
|
public class MesItemQtrrDetail
|
{
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_QTRKD")]
|
[Description("ID")]
|
public decimal Id { get; set; }
|
|
[SugarColumn(ColumnName = "MID")]
|
[Description("MID")]
|
public decimal Mid { get; set; }
|
|
[SugarColumn(ColumnName = "QD001")]
|
[Description("工单号")]
|
public string Qd001 { get; set; }
|
|
[SugarColumn(ColumnName = "QD002")]
|
[Description("物料编号")]
|
public string Qd002 { get; set; }
|
|
[SugarColumn(ColumnName = "QD003")]
|
[Description("物料名称")]
|
public string Qd003 { get; set; }
|
|
[SugarColumn(ColumnName = "QD004")]
|
[Description("规格型号")]
|
public string Qd004 { get; set; }
|
|
[SugarColumn(ColumnName = "QD005")]
|
[Description("颜色")]
|
public string Qd005 { get; set; }
|
|
[SugarColumn(ColumnName = "QD006")]
|
[Description("计划数量")]
|
public decimal? Qd006 { get; set; }
|
|
[SugarColumn(ColumnName = "QD007")]
|
[Description("申请数量")]
|
public decimal? Qd007 { get; set; }
|
|
[SugarColumn(ColumnName = "QD008", DefaultValue = "0")]
|
[Description("已入数量")]
|
public decimal Qd008 { get; set; } = 0;
|
|
[SugarColumn(ColumnName = "QD009", Length = 30)]
|
[Description("单位")]
|
public string Qd009 { get; set; }
|
|
[SugarColumn(ColumnName = "QD010", Length = 500)]
|
[Description("备注")]
|
public string Qd010 { get; set; }
|
|
[SugarColumn(ColumnName = "QD011", DefaultValue = "0")]
|
[Description("完结标识")]
|
public decimal Qd011 { get; set; } = 0;
|
|
[SugarColumn(ColumnName = "QD012")]
|
[Description("物料内码")]
|
public decimal? Qd012 { get; set; }
|
|
/* 新增字段 */
|
|
[SugarColumn(ColumnName = "LINE_NUMBER")]
|
[Description("行号(物料顺序)")]
|
public int? LineNumber { get; set; }
|
|
[SugarColumn(ColumnName = "PRODUCTION_RELATED")]
|
[Description("生产相关")]
|
public string ProductionRelated { get; set; }
|
|
[SugarColumn(ColumnName = "STORAGE_TYPE")]
|
[Description("存储类型")]
|
public string StorageType { get; set; }
|
|
[SugarColumn(ColumnName = "OWNER_ORGANIZATION")]
|
[Description("货主组织")]
|
public string OwnerOrganization { get; set; }
|
|
[SugarColumn(ColumnName = "STORAGE_LOCATION")]
|
[Description("存储地点")]
|
public string StorageLocation { get; set; }
|
|
[SugarColumn(ColumnName = "SUPPLIER_CODE")]
|
[Description("供应商编码")]
|
public string SupplierCode { get; set; }
|
|
[SugarColumn(ColumnName = "CUSTOMER_CODE")]
|
[Description("客户编码")]
|
public string CustomerCode { get; set; }
|
|
[SugarColumn(ColumnName = "PROJECT_CODE")]
|
[Description("关联项目编码")]
|
public string ProjectCode { get; set; }
|
|
[SugarColumn(ColumnName = "TASK_CODE")]
|
[Description("关联任务编码")]
|
public string TaskCode { get; set; }
|
|
[SugarColumn(ColumnName = "PRODUCTION_ORDER")]
|
[Description("生产订单号")]
|
public string ProductionOrder { get; set; }
|
|
[SugarColumn(ColumnName = "DAILY_PLAN")]
|
[Description("生产线日计划编号")]
|
public string DailyPlan { get; set; }
|
|
[SugarColumn(ColumnName = "PRODUCTION_ACTIVITY")]
|
[Description("生产活动")]
|
public string ProductionActivity { get; set; }
|
|
[SugarColumn(ColumnName = "FINISHED_PRODUCT")]
|
[Description("产成品编码")]
|
public string FinishedProduct { get; set; }
|
}
|
