using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料信息
|
/// </summary>
|
[SugarTable("MES_ITEMS")]
|
public class MesItems
|
{
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "id")]
|
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>
|
/// 物料ID
|
/// </summary>
|
[SugarColumn(ColumnName = "e_item_id")]
|
public long? 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 int? Fisbatchmanage { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
[SugarColumn(ColumnName = "fpurchaseunitid")]
|
public decimal Fpurchaseunitid { get; set; }
|
|
/// <summary>
|
/// 损耗率
|
/// </summary>
|
[SugarColumn(ColumnName = "loss_percent")]
|
public string? LossPercent { get; set; }
|
|
/// <summary>
|
/// 助记码
|
/// </summary>
|
[SugarColumn(ColumnName = "mnemonic_code")]
|
public string? MnemonicCode { get; set; }
|
|
/// <summary>
|
/// 保质期
|
/// </summary>
|
[SugarColumn(ColumnName = "exp_period")]
|
public string? ExpPeriod { 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 long? ItemId { get; set; }
|
|
/// <summary>
|
/// 颜色
|
/// </summary>
|
[SugarColumn(ColumnName = "color_name")]
|
public string? ColorName { get; set; }
|
|
/// <summary>
|
/// 使用組織
|
/// </summary>
|
[SugarColumn(ColumnName = "FSubsidiary")]
|
public string? FSubsidiary { get; set; }
|
|
/// <summary>
|
/// 創建組織
|
/// </summary>
|
[SugarColumn(ColumnName = "Fumbrella")]
|
public string? Fumbrella { get; set; }
|
|
|
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
|
}
|
