using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料库存表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_STOCKS")]
|
public class MesInvItemStocks
|
{
|
/// <summary>
|
/// SEQ_ME_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 生产订单
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string? TaskNo { get; set; }
|
|
/// <summary>
|
/// 物料条码
|
/// </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 = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 子库id
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOTS_ID")]
|
public decimal? DepotsId { get; set; }
|
|
/// <summary>
|
/// 货位id
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
|
public decimal? DepotSectionsId { get; set; }
|
|
/// <summary>
|
/// 厂家批次
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_NO")]
|
public string? LotNo { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QUANTITY")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 环保标志（无条码手工录入，有条码为冗余字段）(0-否，1-是)
|
/// </summary>
|
[SugarColumn(ColumnName = "EP_FLAG")]
|
public short? EpFlag { get; set; }
|
|
/// <summary>
|
/// 客户编码
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_NO")]
|
public string? CustomerNo { get; set; }
|
|
/// <summary>
|
/// 重量
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_WT")]
|
public decimal? ItemWt { get; set; }
|
|
/// <summary>
|
/// 子库CODE
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOTS_CODE")]
|
public string? DepotsCode { get; set; }
|
|
/// <summary>
|
/// 货位CODE
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
|
public string? DepotSectionsCode { get; set; }
|
|
/// <summary>
|
/// 检验日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 0 物料 1 半成品 2 成品
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_TYPE")]
|
public short? ItemType { get; set; }
|
|
/// <summary>
|
/// 入库日期
|
/// </summary>
|
[SugarColumn(ColumnName = "INDEP_DATE")]
|
public DateTime? IndepDate { 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 = "IQC_STATUS")]
|
public string? IqcStatus { get; set; }
|
|
/// <summary>
|
/// 小车条码
|
/// </summary>
|
[SugarColumn(ColumnName = "FCAR")]
|
public string? Fcar { get; set; }
|
|
/// <summary>
|
/// 冻结提交重检，0：冻结未提交重检，1：冻结并提交重检
|
/// </summary>
|
[SugarColumn(ColumnName = "VISABLE_SUBMIT")]
|
public short? VisableSubmit { get; set; }
|
|
/// <summary>
|
/// 提交重检人
|
/// </summary>
|
[SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
|
public string? VisableSubmitBy { get; set; }
|
|
/// <summary>
|
/// 提交重检时间
|
/// </summary>
|
[SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
|
public DateTime? VisableSubmitDate { get; set; }
|
|
/// <summary>
|
/// 产品型号
|
/// </summary>
|
[SugarColumn(ColumnName = "BOARD_STYLE")]
|
public string? BoardStyle { 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>
|
/// 供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string? SuppNo { get; set; }
|
|
/// <summary>
|
/// 生产线
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string? LineNo { get; set; }
|
|
/// <summary>
|
/// 半成品入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { 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>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
|
/// <summary>
|
/// 是否占用
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_ZY")]
|
public decimal? IsZy { get; set; }
|
|
/// <summary>
|
/// 销售订单
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER")]
|
public string? SalesOrder { get; set; }
|
|
/// <summary>
|
/// 可见性(0-可见，1-不可见)
|
/// </summary>
|
[SugarColumn(ColumnName = "VISABLE")]
|
public short? Visable { get; set; }
|
|
/// <summary>
|
/// 是否借出
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_JC")]
|
public decimal? IsJc { get; set; }
|
|
/// <summary>
|
/// 借出单号
|
/// </summary>
|
[SugarColumn(ColumnName = "JC_BILL_NO")]
|
public string? JcBillNo { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "FMTONO")]
|
public string? Fmtono { get; set; }
|
|
/// <summary>
|
/// 中箱码
|
/// </summary>
|
[SugarColumn(ColumnName = "MEDIUMBOXCODE")]
|
public string? MediumBoxCode { get; set; }
|
|
/// <summary>
|
/// 栈板码
|
/// </summary>
|
[SugarColumn(ColumnName = "STACKCODE")]
|
public string? StackCode { get; set; }
|
|
/// <summary>
|
/// 仓库ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_ID")]
|
public decimal? DepotId { get; set; }
|
|
/// <summary>
|
/// 物料条码D
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE_D")]
|
public string? ItemBarcodeD { get; set; }
|
|
/// <summary>
|
/// 物料条码Z
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE_Z")]
|
public string? ItemBarcodeZ { get; set; }
|
|
/// <summary>
|
/// 是否推送
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_TS")]
|
public decimal? IsTs { get; set; }
|
}
|
