using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料信息
|
/// </summary>
|
[SugarTable("MES_ITEMS")]
|
public class MesItems
|
{
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 工厂
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string Factory { get; set; }
|
|
/// <summary>
|
/// 公司编号
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string Company { get; set; }
|
|
/// <summary>
|
/// 物料编码 = ERP物料编号||颜色编号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string ItemNo { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NAME")]
|
public string ItemName { get; set; }
|
|
/// <summary>
|
/// 物料简称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_SNAME")]
|
public string ItemSname { get; set; }
|
|
/// <summary>
|
/// 规格型号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_MODEL")]
|
public string ItemModel { get; set; }
|
|
/// <summary>
|
/// 物料描述
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_DESCRIPTION")]
|
public string ItemDescription { get; set; }
|
|
/// <summary>
|
/// 物料单位
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_UNIT")]
|
public string ItemUnit { get; set; }
|
|
/// <summary>
|
/// 物料类型
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_TYPE")]
|
public string ItemType { get; set; }
|
|
/// <summary>
|
/// 产品版本
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_VERSION")]
|
public string ItemVersion { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_NO")]
|
public string CustNo { 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 = "LOWLIMIT")]
|
public double? Lowlimit { get; set; }
|
|
/// <summary>
|
/// 最大库存
|
/// </summary>
|
[SugarColumn(ColumnName = "HIGHLIMIT")]
|
public double? Highlimit { get; set; }
|
|
/// <summary>
|
/// 最小包装数
|
/// </summary>
|
[SugarColumn(ColumnName = "PRD_PACK")]
|
public double? PrdPack { get; set; }
|
|
/// <summary>
|
/// 订单单位
|
/// </summary>
|
[SugarColumn(ColumnName = "ORDERUNIT")]
|
public string Orderunit { get; set; }
|
|
/// <summary>
|
/// 销售单位
|
/// </summary>
|
[SugarColumn(ColumnName = "SALEUNIT")]
|
public string Saleunit { get; set; }
|
|
/// <summary>
|
/// 库房单位
|
/// </summary>
|
[SugarColumn(ColumnName = "STOREUNIT")]
|
public string Storeunit { get; set; }
|
|
/// <summary>
|
/// 生产单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PRODUCTUNIT")]
|
public string Productunit { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "E_ITEM_ID")]
|
public decimal? EItemId { get; set; }
|
|
/// <summary>
|
/// ERP料号
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ITEM_NO")]
|
public string ErpItemNo { get; set; }
|
|
/// <summary>
|
/// 默认仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_CODE")]
|
public string DepotCode { get; set; }
|
|
/// <summary>
|
/// 物料分类编号
|
/// </summary>
|
[SugarColumn(ColumnName = "PPBOM00019124")]
|
public string Ppbom00019124 { get; set; }
|
|
/// <summary>
|
/// 物料分组
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARKS")]
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// 采购员
|
/// </summary>
|
[SugarColumn(ColumnName = "FPURCHASERID")]
|
public string Fpurchaserid { get; set; }
|
|
/// <summary>
|
/// 禁用状态
|
/// </summary>
|
[SugarColumn(ColumnName = "FFORBIDSTATUS")]
|
public string Fforbidstatus { get; set; }
|
|
/// <summary>
|
/// 物料分组
|
/// </summary>
|
[SugarColumn(ColumnName = "FMATERIALGROUP")]
|
public string Fmaterialgroup { get; set; }
|
|
/// <summary>
|
/// 完工超收比例
|
/// </summary>
|
[SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")]
|
public decimal? Ffinishreceiptoverrate { get; set; }
|
|
/// <summary>
|
/// 发料方式
|
/// </summary>
|
[SugarColumn(ColumnName = "FISSUETYPE")]
|
public string Fissuetype { get; set; }
|
|
/// <summary>
|
/// 启用批号管理
|
/// </summary>
|
[SugarColumn(ColumnName = "FISBATCHMANAGE")]
|
public decimal? Fisbatchmanage { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
[SugarColumn(ColumnName = "FPURCHASEUNITID")]
|
public string Fpurchaseunitid { get; set; }
|
|
/// <summary>
|
/// 是否包装
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECKBOX_SFBZ")]
|
public string CheckbosSFBZ { get; set; }
|
|
/// <summary>
|
/// 是否打标
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECKBOX_SFDB")]
|
public string CheckbosSFDB { get; set; }
|
|
/// <summary>
|
/// 自定义字段3
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK3")]
|
public string Remark3 { get; set; }
|
|
/// <summary>
|
/// 自定义字段4
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK4")]
|
public string Remark4 { get; set; }
|
|
/// <summary>
|
/// 自定义字段5
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK5")]
|
public string Remark5 { get; set; }
|
|
/// <summary>
|
/// 生产车间
|
/// </summary>
|
[SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")]
|
public string ProductionWorkshop { get; set; }
|
|
/// <summary>
|
/// 物料属性
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_PROPERTI")]
|
public string MaterialProperti { get; set; }
|
|
/// <summary>
|
/// 生产单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PRODUCE_UNIT")]
|
public string ProduceUnit { get; set; }
|
|
/// <summary>
|
/// 委外单位
|
/// </summary>
|
[SugarColumn(ColumnName = "SUBCON_UNIT")]
|
public string SubconUnit { get; set; }
|
|
/// <summary>
|
/// 图片1
|
/// </summary>
|
[SugarColumn(ColumnName = "BZ06")]
|
public string Bz06 { get; set; }
|
|
/// <summary>
|
/// 图片2
|
/// </summary>
|
[SugarColumn(ColumnName = "BZ07")]
|
public string Bz07 { get; set; }
|
|
/// <summary>
|
/// 图片3
|
/// </summary>
|
[SugarColumn(ColumnName = "BZ08")]
|
public string Bz08 { get; set; }
|
|
/// <summary>
|
/// 图片4
|
/// </summary>
|
[SugarColumn(ColumnName = "BZ09")]
|
public string Bz09 { get; set; }
|
|
/// <summary>
|
/// 图片5
|
/// </summary>
|
[SugarColumn(ColumnName = "BZ10")]
|
public string Bz10 { get; set; }
|
|
/// <summary>
|
/// QC分组ID
|
/// </summary>
|
[SugarColumn(ColumnName = "QC_TEAMID")]
|
public string QcTeamid { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
|
}
|
