using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 出库申请物料表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_OUT_ITEMS")]
|
public class MesInvItemOutItems
|
{
|
/// <summary>
|
/// SEQ_ITEM_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 出库ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_OUT_ID")]
|
public decimal? 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 decimal? WorkLine { get; set; }
|
|
/// <summary>
|
/// ERP 主表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public decimal? ErpId { get; set; }
|
|
/// <summary>
|
/// ERP 从表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_AUTOID")]
|
public decimal? 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>
|
/// 最新下载更新标识
|
/// </summary>
|
[SugarColumn(ColumnName = "UPDATE_FLG")]
|
public decimal? UpdateFlg { get; set; }
|
|
/// <summary>
|
/// 采购单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public decimal? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 采购单行ID
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_K3ID")]
|
public decimal? LineK3id { get; set; }
|
|
/// <summary>
|
/// 采购单号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN")]
|
public string? Ebeln { get; set; }
|
|
/// <summary>
|
/// 采购订单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_LINE")]
|
public decimal? 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 decimal? FType { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public decimal? Status { get; set; }
|
|
/// <summary>
|
/// 子子表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ALLOCATEID")]
|
public decimal? 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 decimal? ItemId { get; set; }
|
|
/// <summary>
|
/// 物料投料单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_DABID")]
|
public decimal? ItemDabid { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
|
[SugarColumn(IsIgnore = true)] public string? QuantityOk { get; set; }
|
}
|
