using SqlSugar;
|
|
namespace NewPdaSqlServer.entity
|
{
|
/// <summary>
|
/// 物料库存表
|
///</summary>
|
[SugarTable("MES_INV_ITEM_STOCKS")]
|
public class MesInvItemStocks
|
{
|
/// <summary>
|
///
|
/// 默认值: (newid())
|
///</summary>
|
[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
|
public Guid Guid { 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 long? DepotsId { get; set; }
|
|
/// <summary>
|
/// 货位id
|
///</summary>
|
[SugarColumn(ColumnName="DEPOT_SECTIONS_ID" )]
|
public long? DepotSectionsId { get; set; }
|
|
/// <summary>
|
/// 厂家批次
|
///</summary>
|
[SugarColumn(ColumnName="LOT_NO" )]
|
public string? LotNo { get; set; }
|
|
/// <summary>
|
/// 数量
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="QUANTITY" )]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 环保标志（无条码手工录入，有条码为冗余字段）(0-否，1-是)
|
///</summary>
|
[SugarColumn(ColumnName="EP_FLAG" )]
|
public byte? 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 成品
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="ITEM_TYPE" )]
|
public byte? ItemType { get; set; }
|
|
/// <summary>
|
/// 入库日期
|
/// 默认值: (getdate())
|
///</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>
|
/// F卡
|
///</summary>
|
[SugarColumn(ColumnName="FCAR" )]
|
public string? Fcar { get; set; }
|
|
/// <summary>
|
/// 可见提交标志（0-否，1-是）
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="VISABLE_SUBMIT" )]
|
public byte? 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 int? 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>
|
/// K3ID
|
///</summary>
|
[SugarColumn(ColumnName="EBELN_K3ID" )]
|
public long? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 行K3ID
|
///</summary>
|
[SugarColumn(ColumnName="LINE_K3ID" )]
|
public long? LineK3id { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
///</summary>
|
[SugarColumn(ColumnName="ITEM_ID" )]
|
public long? ItemId { get; set; }
|
}
|
}
|
