using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料入库主表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_INS")]
|
public class MesInvItemIns
|
{
|
/// <summary>
|
/// ID(SEQ_INV_ID)
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 状态|0-未审核1-审核入库\结案
|
/// </summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public short? Status { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOTS_ID")]
|
public decimal? DepotsId { get; set; }
|
|
/// <summary>
|
/// 原因
|
/// </summary>
|
[SugarColumn(ColumnName = "REASON")]
|
public string Reason { 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>
|
/// 单据类型ID
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
|
public decimal? BillTypeId { get; set; }
|
|
/// <summary>
|
/// 事务类型ID
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSACTION_ID")]
|
public decimal? TransactionId { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string Remark { get; set; }
|
|
/// <summary>
|
/// 送货单号
|
/// </summary>
|
[SugarColumn(ColumnName = "PAPER_BILL_NO")]
|
public string PaperBillNo { get; set; }
|
|
/// <summary>
|
/// 退料人工号
|
/// </summary>
|
[SugarColumn(ColumnName = "USER_NO_BACK")]
|
public string UserNoBack { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_USER")]
|
public string CheckUser { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 生产订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string TaskNo { get; set; }
|
|
/// <summary>
|
/// 入库日期
|
/// </summary>
|
[SugarColumn(ColumnName = "INS_DATE")]
|
public DateTime? InsDate { get; set; }
|
|
/// <summary>
|
/// 检验结果
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_RES")]
|
public string CheckRes { get; set; }
|
|
/// <summary>
|
/// 已捡数量
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_QTY")]
|
public decimal? CheckQty { get; set; }
|
|
/// <summary>
|
/// 领料工段
|
/// </summary>
|
[SugarColumn(ColumnName = "MMLIST")]
|
public string Mmlist { get; set; }
|
|
/// <summary>
|
/// SAP采购订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN")]
|
public string Ebeln { get; set; }
|
|
/// <summary>
|
/// 仓库编码
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOTS_CODE")]
|
public string DepotsCode { get; set; }
|
|
/// <summary>
|
/// 事务类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSCTION_NO")]
|
public string TransctionNo { get; set; }
|
|
/// <summary>
|
/// 供应商编码
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string SuppNo { get; set; }
|
|
/// <summary>
|
/// 入库状态
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTATUS")]
|
public short? Fstatus { get; set; }
|
|
/// <summary>
|
/// 工厂编码
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// 是否已回写SAP
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPSTATUS")]
|
public short? Sapstatus { get; set; }
|
|
/// <summary>
|
/// SAP返回单据
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPNO")]
|
public string Sapno { get; set; }
|
|
/// <summary>
|
/// SAP返回年份
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPYEAR")]
|
public short? Sapyear { get; set; }
|
|
/// <summary>
|
/// SAP返回信息
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPTEXT")]
|
public string Saptext { get; set; }
|
|
/// <summary>
|
/// 确认入库日期
|
/// </summary>
|
[SugarColumn(ColumnName = "INSDATE")]
|
public DateTime? InsdateA { get; set; }
|
|
/// <summary>
|
/// 是否检验
|
/// </summary>
|
[SugarColumn(ColumnName = "ISCHECK")]
|
public decimal? Ischeck { get; set; }
|
|
/// <summary>
|
/// 审核入库人
|
/// </summary>
|
[SugarColumn(ColumnName = "INSBY")]
|
public string Insby { get; set; }
|
|
/// <summary>
|
/// 是否显示
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_VISUAL")]
|
public decimal? IsVisual { get; set; }
|
|
/// <summary>
|
/// 公司代码
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[SugarColumn(ColumnName = "URGENT_FLAG")]
|
public short? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 采购单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string LineNo { get; set; }
|
|
/// <summary>
|
/// 冲销事务类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MTTRANSCTION_NO")]
|
public decimal? MttransctionNo { get; set; }
|
|
/// <summary>
|
/// 工单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_LINO")]
|
public string TaskLino { get; set; }
|
|
/// <summary>
|
/// 投料通知单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "FBILLNO")]
|
public string Fbillno { get; set; }
|
|
/// <summary>
|
/// 投料单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "FBILL_LINO")]
|
public string FbillLino { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_NO")]
|
public string CustNo { get; set; }
|
|
/// <summary>
|
/// 客户名称
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_NAME")]
|
public string CustName { get; set; }
|
|
/// <summary>
|
/// IQC检验单号
|
/// </summary>
|
[SugarColumn(ColumnName = "IQC_RELEASE_NO")]
|
public string IqcReleaseNo { get; set; }
|
|
/// <summary>
|
/// 到货单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CBILL_NO")]
|
public string CbillNo { get; set; }
|
|
/// <summary>
|
/// 0 申请单，1入库单标识
|
/// </summary>
|
[SugarColumn(ColumnName = "PICK_INS")]
|
public decimal? PickIns { get; set; }
|
|
/// <summary>
|
/// 入库审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "FCHECK_USER")]
|
public string FcheckUser { get; set; }
|
|
/// <summary>
|
/// 入库审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "FCHECK_DATE")]
|
public DateTime? FcheckDate { get; set; }
|
|
/// <summary>
|
/// 任务汇报单
|
/// </summary>
|
[SugarColumn(ColumnName = "RBILL_NO")]
|
public string RbillNo { get; set; }
|
|
//在数据库查询时忽略这个字段
|
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
|
}
|
