using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 物料入库主表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_INS")]
|
public class MesInvItemIns
|
{
|
/// <summary>
|
/// ID(SEQ_INV_ID)
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 状态|0-未审核1-审核入库\\结案
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public byte? Status { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOTS_ID")]
|
public long? 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 long? BillTypeId { get; set; }
|
|
/// <summary>
|
/// 事务类型ID
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSACTION_ID")]
|
public long? 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 long? CheckQty { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "MMLIST")]
|
public string? Mmlist { get; set; }
|
|
/// <summary>
|
/// </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>
|
/// 状态 | 0-未审核 1-审核入库/结案
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTATUS")]
|
public byte? Fstatus { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPSTATUS")]
|
public byte? Sapstatus { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPNO")]
|
public string? Sapno { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPYEAR")]
|
public short? Sapyear { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "SAPTEXT")]
|
public string? Saptext { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ISCHECK")]
|
public byte? Ischeck { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "INSBY")]
|
public string? Insby { get; set; }
|
|
/// <summary>
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_VISUAL")]
|
public byte? IsVisual { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string? Company { get; set; }
|
|
/// <summary>
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "URGENT_FLAG")]
|
public string? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string? LineNo { get; set; }
|
|
/// <summary>
|
/// 冲销事务类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MTTRANSCTION_NO")]
|
public long? 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>
|
/// 入库单的相关单号（生产相关存 指令单号 -1，采购相关的存到货单号）
|
/// </summary>
|
[SugarColumn(ColumnName = "CBILL_NO")]
|
public string? CbillNo { get; set; }
|
|
/// <summary>
|
/// 0 申请单，1入库单标识
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "PICK_INS")]
|
public byte? 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; }
|
|
/// <summary>
|
/// 报工人
|
/// </summary>
|
[SugarColumn(ColumnName = "BGR")]
|
public string? Bgr { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_ID")]
|
public string? SuppId { get; set; }
|
|
/// <summary>
|
/// 收料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ReceiveOrgId")]
|
public string? ReceiveOrgId { get; set; }
|
|
/// <summary>
|
/// 入库单的相关单号（生产相关存 指令单号 -1，采购相关的存到货单号）
|
/// </summary>
|
[SugarColumn(ColumnName = "work_no")]
|
public string? WorkNo { get; set; }
|
|
/// <summary>
|
/// 入库类别（事务类型名称）
|
/// </summary>
|
[SugarColumn(ColumnName = "in_type")]
|
public string? InType { get; set; }
|
|
|
//在数据库查询时忽略这个字段
|
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
|
}
|
