using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料入库主表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_ARN")]
|
public class MesInvItemArn
|
{
|
/// <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 = "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 = "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 = "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>
|
/// 确认入库日期
|
/// </summary>
|
[SugarColumn(ColumnName = "INS_DATE")]
|
public DateTime? Insdate { 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 = "COMPANY")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[SugarColumn(ColumnName = "URGENT_FLAG")]
|
public short? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 冲销事务类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MTTRANSCTION_NO")]
|
public decimal? MttransctionNo { get; set; }
|
|
/// <summary>
|
/// IQC检验单号
|
/// </summary>
|
[SugarColumn(ColumnName = "IQC_RELEASE_NO")]
|
public string IqcReleaseNo { get; set; }
|
|
/// <summary>
|
/// 是否显示
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_VISUAL")]
|
public decimal? IsVisual { get; set; }
|
|
/// <summary>
|
/// 0=采购，1=委外
|
/// </summary>
|
[SugarColumn(ColumnName = "F_TYPE")]
|
public decimal? FType { get; set; }
|
|
/// <summary>
|
/// ERP到货单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public string EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 条码条印进度
|
/// </summary>
|
[SugarColumn(ColumnName = "BARCODE_RATIO")]
|
public decimal? BarcodeRatio { get; set; }
|
|
/// <summary>
|
/// ERP单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPNO")]
|
public string Erpno { get; set; }
|
|
/// <summary>
|
/// 是否已退货0-未退货，1-退货
|
/// </summary>
|
[SugarColumn(ColumnName = "THSTATUS")]
|
public short? Thstatus { get; set; }
|
|
/// <summary>
|
/// ERP退货单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPTHNO")]
|
public string Erpthno { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
|
}
|
