using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_OUT_ITEMS")]
|
public class MesInvItemOutItems
|
{
|
/// <summary>
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 出库ID
|
/// </summary>
|
[SugarColumn(ColumnName = "item_out_id")]
|
public Guid? ItemOutId { get; set; }
|
|
/// <summary>
|
/// 物料编号
|
/// </summary>
|
[SugarColumn(ColumnName = "item_no")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 申请数量
|
/// </summary>
|
[SugarColumn(ColumnName = "quantity")]
|
public decimal? Quantity { 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>
|
/// 备注信息
|
/// </summary>
|
[SugarColumn(ColumnName = "remark")]
|
public string? Remark { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "factory")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "company")]
|
public string? Company { get; set; }
|
|
/// <summary>
|
/// 推介仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_code")]
|
public string? DepotCode { get; set; }
|
|
/// <summary>
|
/// 推介库位
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_section_code")]
|
public string? DepotSectionCode { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "task_no")]
|
public string? TaskNo { get; set; }
|
|
/// <summary>
|
/// 到货单号
|
/// </summary>
|
[SugarColumn(ColumnName = "work_no")]
|
public string? WorkNo { get; set; }
|
|
/// <summary>
|
/// 到货单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "work_line")]
|
public int? WorkLine { get; set; }
|
|
/// <summary>
|
/// ERP 主表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "erp_id")]
|
public int? ErpId { get; set; }
|
|
/// <summary>
|
/// ERP 从表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "erp_autoid")]
|
public int? ErpAutoid { get; set; }
|
|
/// <summary>
|
/// ERP_料号
|
/// </summary>
|
[SugarColumn(ColumnName = "erp_item_no")]
|
public string? ErpItemNo { get; set; }
|
|
/// <summary>
|
/// 颜色
|
/// </summary>
|
[SugarColumn(ColumnName = "color_name")]
|
public string? ColorName { get; set; }
|
|
/// <summary>
|
/// 最新下载更新标识
|
/// 默认值: ((1))
|
/// </summary>
|
[SugarColumn(ColumnName = "update_flg")]
|
public int? UpdateFlg { get; set; }
|
|
/// <summary>
|
/// 采购单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln_k3id")]
|
public int? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 采购单行ID
|
/// </summary>
|
[SugarColumn(ColumnName = "line_k3id")]
|
public int? LineK3id { get; set; }
|
|
/// <summary>
|
/// 采购单号
|
/// 默认值: ('0')
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln")]
|
public string? Ebeln { get; set; }
|
|
/// <summary>
|
/// 采购订单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln_line")]
|
public int? EbelnLine { get; set; }
|
|
/// <summary>
|
/// 采购订单数量
|
/// </summary>
|
[SugarColumn(ColumnName = "ebeln_qty")]
|
public decimal? EbelnQty { get; set; }
|
|
/// <summary>
|
/// 产品编号
|
/// </summary>
|
[SugarColumn(ColumnName = "board_item")]
|
public string? BoardItem { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "f_type")]
|
public int? FType { get; set; }
|
|
/// <summary>
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "status")]
|
public int? Status { get; set; }
|
|
/// <summary>
|
/// 子子表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "allocateid")]
|
public int? Allocateid { get; set; }
|
|
/// <summary>
|
/// 领料编号/生产工单
|
/// </summary>
|
[SugarColumn(ColumnName = "pbill_no")]
|
public string? PbillNo { get; set; }
|
|
/// <summary>
|
/// erp接口返回
|
/// </summary>
|
[SugarColumn(ColumnName = "erp_mark")]
|
public string? ErpMark { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "rk_no")]
|
public string? RkNo { get; set; }
|
|
/// <summary>
|
/// 已入库数
|
/// </summary>
|
[SugarColumn(ColumnName = "rk_qty")]
|
public decimal? RkQty { get; set; }
|
|
/// <summary>
|
/// 已扫数量
|
/// </summary>
|
[SugarColumn(ColumnName = "tl_qty")]
|
public decimal? TlQty { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "item_id")]
|
public long? ItemId { get; set; }
|
|
/// <summary>
|
/// 物料投料单ID(发料扫码使用)
|
/// </summary>
|
[SugarColumn(ColumnName = "item_dabid")]
|
public Guid? ItemDabid { get; set; }
|
|
/// <summary>
|
/// 应该是到货明细表的guid
|
/// </summary>
|
[SugarColumn(ColumnName = "about_Guid")]
|
public Guid? AboutGuid { get; set; }
|
|
/// <summary>
|
/// 出库明细ID
|
/// </summary>
|
[SugarColumn(ColumnName = "qt_out_id")]
|
public Guid? QtOutId { get; set; }
|
|
/// <summary>
|
/// 仓库id
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_id")]
|
public string? DepotId { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public decimal? KtQty { get; set; }
|
}
|