using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料入库条码明细
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
|
public class MesInvItemInCDetails
|
{
|
/// <summary>
|
/// SEQ_OUT
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 入库单id
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
|
public decimal ItemInId { get; set; }
|
|
/// <summary>
|
/// 物料条码PSN
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE")]
|
public string ItemBarcode { get; set; }
|
|
/// <summary>
|
/// 客户物料编码（无条码手工录入，有条码为冗余字段）
|
/// </summary>
|
[SugarColumn(ColumnName = "C_ITEM_CODE")]
|
public string CItemCode { get; set; }
|
|
/// <summary>
|
/// 客户物料条码
|
/// </summary>
|
[SugarColumn(ColumnName = "C_ITEM_BARCODE")]
|
public string CItemBarcode { get; set; }
|
|
/// <summary>
|
/// 验收数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QUANTITY")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 入库方式(1:有条码,0:无条码)
|
/// </summary>
|
[SugarColumn(ColumnName = "BARCODE_FLAG")]
|
public short? BarcodeFlag { get; set; }
|
|
/// <summary>
|
/// 环保标志（0-非环保,1-环保.无条码手工录入，有条码为冗余字段）
|
/// </summary>
|
[SugarColumn(ColumnName = "EP_FLAG")]
|
public short? EpFlag { 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>
|
/// 作业方式0-有线条码枪1-无线条码枪
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_TYPE")]
|
public decimal? WorkType { get; set; }
|
|
/// <summary>
|
/// 本司物料编码（无条码手工录入，有条码为冗余字段）
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string ItemNo { get; set; }
|
|
/// <summary>
|
/// 厂家批次
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_NO")]
|
public string LotNo { get; set; }
|
|
/// <summary>
|
/// 是否共管物料(0:否，1:是)
|
/// </summary>
|
[SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
|
public short? ComanagementFlag { get; set; }
|
|
/// <summary>
|
/// 客户编码
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_NO")]
|
public string CustNo { 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 = "CHECK_STATES")]
|
public string CheckStates { get; set; }
|
|
/// <summary>
|
/// 强制入库标记0无，1-强制入库 退料单使用
|
/// </summary>
|
[SugarColumn(ColumnName = "FORCE_IN_FLAG")]
|
public short? ForceInFlag { 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 = "REMARK")]
|
public string Remark { get; set; }
|
|
/// <summary>
|
/// 物料条码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE2")]
|
public string ItemBarcode2 { get; set; }
|
|
/// <summary>
|
/// 新条码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE3")]
|
public string ItemBarcode3 { get; set; }
|
|
/// <summary>
|
/// 使用数量
|
/// </summary>
|
[SugarColumn(ColumnName = "USE_QTY")]
|
public decimal? UseQty { get; set; }
|
|
/// <summary>
|
/// 领料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_QTY")]
|
public decimal? OutQty { get; set; }
|
|
/// <summary>
|
/// 物料简称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_SNAME")]
|
public string ItemSname { get; set; }
|
|
/// <summary>
|
/// 档位低值
|
/// </summary>
|
[SugarColumn(ColumnName = "SPOSTION")]
|
public decimal? Spostion { get; set; }
|
|
/// <summary>
|
/// 档位高值
|
/// </summary>
|
[SugarColumn(ColumnName = "EPOSTION")]
|
public decimal? Epostion { get; set; }
|
|
/// <summary>
|
/// 检验日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT")]
|
public string Unit { get; set; }
|
|
/// <summary>
|
/// 是否检验
|
/// </summary>
|
[SugarColumn(ColumnName = "ISCHECK")]
|
public decimal? Ischeck { get; set; }
|
|
/// <summary>
|
/// 采购订单
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN")]
|
public string Ebeln { get; set; }
|
|
/// <summary>
|
/// 生产日期
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_DATE")]
|
public string LotDate { get; set; }
|
|
/// <summary>
|
/// 入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 入库审核标志
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_OK")]
|
public short? StockOk { 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 = "CB_NO")]
|
public string CbNo { get; set; }
|
|
/// <summary>
|
/// 箱号
|
/// </summary>
|
[SugarColumn(ColumnName = "BOX_NO")]
|
public string BoxNo { get; set; }
|
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_ID")]
|
public decimal? DepotId { get; set; }
|
|
/// <summary>
|
/// 货位ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
|
public decimal? DepotSectionId { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NUM")]
|
public string LineNum { get; set; }
|
|
/// <summary>
|
/// 扫码数量
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_QTY")]
|
public decimal? SmQty { get; set; }
|
|
/// <summary>
|
/// 销售订单
|
/// </summary>
|
[SugarColumn(ColumnName = "VGBEL")]
|
public string Vgbel { get; set; }
|
|
/// <summary>
|
/// 销售订单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "KDPOS")]
|
public decimal? Kdpos { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_NO")]
|
public string WorkNo { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_LINE_NO")]
|
public decimal? EbelnLineNo { get; set; }
|
|
/// <summary>
|
/// 到货单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CBILL_NO")]
|
public string CbillNo { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[SugarColumn(ColumnName = "URGENT_FLAG")]
|
public decimal? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 产品型号
|
/// </summary>
|
[SugarColumn(ColumnName = "BOARD_STYLE")]
|
public string BoardStyle { get; set; }
|
|
/// <summary>
|
/// 任务单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_LINE")]
|
public decimal? WorkLine { get; set; }
|
|
/// <summary>
|
/// 生产工单
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string TaskNo { get; set; }
|
|
/// <summary>
|
/// 供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string SuppNo { get; set; }
|
|
/// <summary>
|
/// 任务汇报单
|
/// </summary>
|
[SugarColumn(ColumnName = "RBILL_NO")]
|
public string RbillNo { 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 decimal? SumQuantity { get; set; }
|
}
|
