using SqlSugar;
|
|
namespace NewPdaSqlServer.entity
|
{
|
/// <summary>
|
///
|
///</summary>
|
[SugarTable("MES_ITEMS")]
|
public class MesItems
|
{
|
/// <summary>
|
///
|
/// 默认值: (newid())
|
///</summary>
|
[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
|
public Guid Guid { get; set; }
|
/// <summary>
|
/// 物料ID
|
///</summary>
|
[SugarColumn(ColumnName="id" )]
|
public long 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 decimal? Lowlimit { get; set; }
|
/// <summary>
|
/// 最大库存
|
///</summary>
|
[SugarColumn(ColumnName="highlimit" )]
|
public decimal? Highlimit { get; set; }
|
/// <summary>
|
/// 最小包装数
|
///</summary>
|
[SugarColumn(ColumnName="prd_pack" )]
|
public decimal? 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 int? 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 string 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="Fumbrella" )]
|
public string Fumbrella { get; set; }
|
/// <summary>
|
/// 使用组织
|
///</summary>
|
[SugarColumn(ColumnName="FSubsidiary" )]
|
public string FSubsidiary { get; set; }
|
}
|
}
|
