using System.ComponentModel.DataAnnotations;
|
using System.ComponentModel.DataAnnotations.Schema;
|
using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料入库主表
|
/// </summary>
|
[Table("MES_INV_ITEM_INS")]
|
[SugarTable("MES_INV_ITEM_INS")] //用于SqlSugar
|
public class MesInvItemIns
|
{
|
/// <summary>
|
/// ID(SEQ_INV_ID)
|
/// </summary>
|
[Key]
|
[Column("ID")]
|
[SugarColumn(ColumnName = "ID")] //用于SqlSugar
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[Column("BILL_NO")]
|
[SugarColumn(ColumnName = "BILL_NO")] //用于SqlSugar
|
[StringLength(100, ErrorMessage = "入库单号长度不能超出100")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 单据类型ID
|
/// </summary>
|
[Column("BILL_TYPE_ID")]
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")] //用于SqlSugar
|
public decimal? BillTypeId { get; set; }
|
|
/// <summary>
|
/// 到货单号/计划单号
|
/// </summary>
|
[Column("CBILL_NO")]
|
[SugarColumn(ColumnName = "CBILL_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "到货单号/计划单号长度不能超出50")]
|
public string CbillNo { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[Column("CHECK_DATE")]
|
[SugarColumn(ColumnName = "CHECK_DATE")] //用于SqlSugar
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 已捡数量
|
/// </summary>
|
[Column("CHECK_QTY")]
|
[SugarColumn(ColumnName = "CHECK_QTY")] //用于SqlSugar
|
public decimal? CheckQty { get; set; }
|
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
[Column("CHECK_RES")]
|
[SugarColumn(ColumnName = "CHECK_RES")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "检验结果长度不能超出50")]
|
public string CheckRes { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[Column("CHECK_USER")]
|
[SugarColumn(ColumnName = "CHECK_USER")] //用于SqlSugar
|
[StringLength(32, ErrorMessage = "审核人长度不能超出32")]
|
public string CheckUser { get; set; }
|
|
/// <summary>
|
/// 公司代码
|
/// </summary>
|
[Column("COMPANY")]
|
[SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "公司代码长度不能超出20")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[Column("CREATE_BY")]
|
[SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "创建人长度不能超出30")]
|
public string CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[Column("CREATE_DATE")]
|
[SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 客户名称
|
/// </summary>
|
[Column("CUST_NAME")]
|
[SugarColumn(ColumnName = "CUST_NAME")] //用于SqlSugar
|
[StringLength(300, ErrorMessage = "客户名称长度不能超出300")]
|
public string CustName { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[Column("CUST_NO")]
|
[SugarColumn(ColumnName = "CUST_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "客户编号长度不能超出50")]
|
public string CustNo { get; set; }
|
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
[Column("DEPOTS_CODE")]
|
[SugarColumn(ColumnName = "DEPOTS_CODE")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "仓库编码长度不能超出30")]
|
public string DepotsCode { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
[Column("DEPOTS_ID")]
|
[SugarColumn(ColumnName = "DEPOTS_ID")] //用于SqlSugar
|
public decimal? DepotsId { get; set; }
|
|
/// <summary>
|
/// SAP采购订单号
|
/// </summary>
|
[Column("EBELN")]
|
[SugarColumn(ColumnName = "EBELN")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "SAP采购订单号长度不能超出50")]
|
public string Ebeln { get; set; }
|
|
/// <summary>
|
/// 工厂编码
|
/// </summary>
|
[Column("FACTORY")]
|
[SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar
|
[StringLength(10, ErrorMessage = "工厂编码长度不能超出10")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// 投料单行号
|
/// </summary>
|
[Column("FBILL_LINO")]
|
[SugarColumn(ColumnName = "FBILL_LINO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "投料单行号长度不能超出50")]
|
public string FbillLino { get; set; }
|
|
/// <summary>
|
/// 投料通知单单号
|
/// </summary>
|
[Column("FBILLNO")]
|
[SugarColumn(ColumnName = "FBILLNO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "投料通知单单号长度不能超出50")]
|
public string Fbillno { get; set; }
|
|
/// <summary>
|
/// 入库审核日期
|
/// </summary>
|
[Column("FCHECK_DATE")]
|
[SugarColumn(ColumnName = "FCHECK_DATE")] //用于SqlSugar
|
public DateTime? FcheckDate { get; set; }
|
|
/// <summary>
|
/// 入库审核人
|
/// </summary>
|
[Column("FCHECK_USER")]
|
[SugarColumn(ColumnName = "FCHECK_USER")] //用于SqlSugar
|
[StringLength(10, ErrorMessage = "入库审核人长度不能超出10")]
|
public string FcheckUser { get; set; }
|
|
/// <summary>
|
/// 入库状态
|
/// </summary>
|
[Column("FSTATUS")]
|
[SugarColumn(ColumnName = "FSTATUS")] //用于SqlSugar
|
public decimal? Fstatus { get; set; }
|
|
/// <summary>
|
/// 审核入库人
|
/// </summary>
|
[Column("INSBY")]
|
[SugarColumn(ColumnName = "INSBY")] //用于SqlSugar
|
[StringLength(32, ErrorMessage = "审核入库人长度不能超出32")]
|
public string Insby { get; set; }
|
|
/// <summary>
|
/// 确认入库日期
|
/// </summary>
|
[Column("INSDATE")]
|
[SugarColumn(ColumnName = "INSDATE")] //用于SqlSugar
|
public DateTime? Insdate { get; set; }
|
|
/// <summary>
|
/// 入库日期
|
/// </summary>
|
[Column("INS_DATE")]
|
[SugarColumn(ColumnName = "INS_DATE")] //用于SqlSugar
|
public DateTime? InsDate { get; set; }
|
|
/// <summary>
|
/// IQC检验单号
|
/// </summary>
|
[Column("IQC_RELEASE_NO")]
|
[SugarColumn(ColumnName = "IQC_RELEASE_NO")] //用于SqlSugar
|
[StringLength(300, ErrorMessage = "IQC检验单号长度不能超出300")]
|
public string IqcReleaseNo { get; set; }
|
|
/// <summary>
|
/// 是否检验
|
/// </summary>
|
[Column("ISCHECK")]
|
[SugarColumn(ColumnName = "ISCHECK")] //用于SqlSugar
|
public decimal? Ischeck { get; set; }
|
|
/// <summary>
|
/// 是否显示
|
/// </summary>
|
[Column("IS_VISUAL")]
|
[SugarColumn(ColumnName = "IS_VISUAL")] //用于SqlSugar
|
public decimal? IsVisual { get; set; }
|
|
/// <summary>
|
/// 半成品编号
|
/// </summary>
|
[Column("ITEM_NO")]
|
[SugarColumn(ColumnName = "ITEM_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "半成品编号长度不能超出50")]
|
public string ItemNo { get; set; }
|
|
/// <summary>
|
/// 最后更新人
|
/// </summary>
|
[Column("LASTUPDATE_BY")]
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "最后更新人长度不能超出30")]
|
public string LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 最后更新时间
|
/// </summary>
|
[Column("LASTUPDATE_DATE")]
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 采购单行号
|
/// </summary>
|
[Column("LINE_NO")]
|
[SugarColumn(ColumnName = "LINE_NO")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "采购单行号长度不能超出20")]
|
public string LineNo { get; set; }
|
|
/// <summary>
|
/// 领料工段
|
/// </summary>
|
[Column("MMLIST")]
|
[SugarColumn(ColumnName = "MMLIST")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "领料工段长度不能超出30")]
|
public string Mmlist { get; set; }
|
|
/// <summary>
|
/// 生产订单
|
/// </summary>
|
[Column("MOCODE")]
|
[SugarColumn(ColumnName = "MOCODE")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "生产订单长度不能超出50")]
|
public string Mocode { get; set; }
|
|
/// <summary>
|
/// 冲销事务类型编码
|
/// </summary>
|
[Column("MTTRANSCTION_NO")]
|
[SugarColumn(ColumnName = "MTTRANSCTION_NO")] //用于SqlSugar
|
public decimal? MttransctionNo { get; set; }
|
|
/// <summary>
|
/// 送货单号
|
/// </summary>
|
[Column("PAPER_BILL_NO")]
|
[SugarColumn(ColumnName = "PAPER_BILL_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "送货单号长度不能超出50")]
|
public string PaperBillNo { get; set; }
|
|
/// <summary>
|
/// 0 申请单，1入库单标识
|
/// </summary>
|
[Column("PICK_INS")]
|
[SugarColumn(ColumnName = "PICK_INS")] //用于SqlSugar
|
public decimal? PickIns { get; set; }
|
|
/// <summary>
|
/// 原因
|
/// </summary>
|
[Column("REASON")]
|
[SugarColumn(ColumnName = "REASON")] //用于SqlSugar
|
[StringLength(1000, ErrorMessage = "原因长度不能超出1000")]
|
public string Reason { get; set; }
|
|
/// <summary>
|
/// 退料原因
|
/// </summary>
|
[Column("REM")]
|
[SugarColumn(ColumnName = "REM")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "退料原因长度不能超出50")]
|
public string Rem { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[Column("REMARK")]
|
[SugarColumn(ColumnName = "REMARK")] //用于SqlSugar
|
[StringLength(255, ErrorMessage = "备注长度不能超出255")]
|
public string Remark { get; set; }
|
|
/// <summary>
|
/// SAP返回单据
|
/// </summary>
|
[Column("SAPNO")]
|
[SugarColumn(ColumnName = "SAPNO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "SAP返回单据长度不能超出50")]
|
public string Sapno { get; set; }
|
|
/// <summary>
|
/// 是否已回写SAP
|
/// </summary>
|
[Column("SAPSTATUS")]
|
[SugarColumn(ColumnName = "SAPSTATUS")] //用于SqlSugar
|
public decimal? Sapstatus { get; set; }
|
|
/// <summary>
|
/// SAP返回信息
|
/// </summary>
|
[Column("SAPTEXT")]
|
[SugarColumn(ColumnName = "SAPTEXT")] //用于SqlSugar
|
[StringLength(200, ErrorMessage = "SAP返回信息长度不能超出200")]
|
public string Saptext { get; set; }
|
|
/// <summary>
|
/// SAP返回年份
|
/// </summary>
|
[Column("SAPYEAR")]
|
[SugarColumn(ColumnName = "SAPYEAR")] //用于SqlSugar
|
public decimal? Sapyear { get; set; }
|
|
/// <summary>
|
/// 状态|0-未审核1-审核入库\结案
|
/// </summary>
|
[Column("STATUS")]
|
[SugarColumn(ColumnName = "STATUS")] //用于SqlSugar
|
public decimal? Status { get; set; }
|
|
/// <summary>
|
/// 供应商编码
|
/// </summary>
|
[Column("SUPP_NO")]
|
[SugarColumn(ColumnName = "SUPP_NO")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "供应商编码长度不能超出30")]
|
public string SuppNo { get; set; }
|
|
/// <summary>
|
/// 工单行号
|
/// </summary>
|
[Column("TASK_LINO")]
|
[SugarColumn(ColumnName = "TASK_LINO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "工单行号长度不能超出50")]
|
public string TaskLino { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[Column("TASK_NO")]
|
[SugarColumn(ColumnName = "TASK_NO")] //用于SqlSugar
|
[StringLength(50, ErrorMessage = "任务单号长度不能超出50")]
|
public string TaskNo { get; set; }
|
|
/// <summary>
|
/// 事务类型ID
|
/// </summary>
|
[Column("TRANSACTION_ID")]
|
[SugarColumn(ColumnName = "TRANSACTION_ID")] //用于SqlSugar
|
public decimal? TransactionId { get; set; }
|
|
/// <summary>
|
/// 事务类型编码
|
/// </summary>
|
[Column("TRANSCTION_NO")]
|
[SugarColumn(ColumnName = "TRANSCTION_NO")] //用于SqlSugar
|
[StringLength(30, ErrorMessage = "事务类型编码长度不能超出30")]
|
public string TransctionNo { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[Column("URGENT_FLAG")]
|
[SugarColumn(ColumnName = "URGENT_FLAG")] //用于SqlSugar
|
public decimal? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 退料人工号
|
/// </summary>
|
[Column("USER_NO_BACK")]
|
[SugarColumn(ColumnName = "USER_NO_BACK")] //用于SqlSugar
|
[StringLength(20, ErrorMessage = "退料人工号长度不能超出20")]
|
public string UserNoBack { get; set; }
|
}
|
