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 = "CREATE_ORG")]
|
public decimal CreateOrg { get; set; }
|
|
/// <summary>
|
/// 使用组织
|
/// </summary>
|
[SugarColumn(ColumnName = "USE_ORG")]
|
public decimal UseOrg { 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 decimal? ItemId { get; set; }
|
|
/// <summary>
|
/// 颜色
|
/// </summary>
|
[SugarColumn(ColumnName = "COLOR_NAME")]
|
public string? ColorName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
|
|
/// <summary>
|
/// 接口字段调整：标准版接口新增字段。
|
/// </summary>
|
/// <remarks>
|
/// 修改人：
|
/// <池南骏>
|
/// 修改日期：<2024-12-31>
|
/// 修改说明：
|
/// - 原代码：空
|
/// - 新增：
|
/// </remarks>
|
/// <summary>
|
/// 旧物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "FOLDNUMBER")]
|
public string? FOLDNUMBER { get; set; }
|
|
/// <summary>
|
/// 最小库存
|
/// </summary>
|
[SugarColumn(ColumnName = "FMINSTOCK")]
|
public double? FMINSTOCK { get; set; }
|
|
/// <summary>
|
/// 入库欠收比例(%)
|
/// </summary>
|
[SugarColumn(ColumnName = "FFINISHRECEIPTSHORTRATE")]
|
public decimal? FFINISHRECEIPTSHORTRATE { get; set; }
|
|
/// <summary>
|
/// 默认供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "FDEFAULTVENDOR")]
|
public string? FDEFAULTVENDOR { get; set; }
|
|
/// <summary>
|
/// 数据状态(Z=暂存,A=创建,B=审核中,C=已审核,D=重新审核)
|
/// </summary>
|
[SugarColumn(ColumnName = "FDOCUMENTSTATUS")]
|
public string? FDOCUMENTSTATUS { get; set; }
|
|
/// <summary>
|
/// 制造策略
|
/// </summary>
|
[SugarColumn(ColumnName = "FMFGPOLICYID")]
|
public string? FMFGPOLICYID { get; set; }
|
|
/// <summary>
|
/// 子项单位
|
/// </summary>
|
[SugarColumn(ColumnName = "FBOMUNITID")]
|
public string? FBOMUNITID { get; set; }
|
|
/// <summary>
|
/// 是否关键件
|
/// </summary>
|
[SugarColumn(ColumnName = "FISKITTING")]
|
public string? FISKITTING { get; set; }
|
|
/// <summary>
|
/// 可为联副产品
|
/// </summary>
|
[SugarColumn(ColumnName = "FISCOBY")]
|
public string? FISCOBY { get; set; }
|
|
/// <summary>
|
/// 超发控制方式
|
/// </summary>
|
[SugarColumn(ColumnName = "FOVERCONTROLMODE")]
|
public string? FOVERCONTROLMODE { get; set; }
|
|
/// <summary>
|
/// 模具编号
|
/// </summary>
|
[SugarColumn(ColumnName = "F_MJBH")]
|
public string? F_MJBH { get; set; }
|
|
|
//20250407 yhj 焕媄新增字段
|
/// <summary>
|
/// 套件
|
/// </summary>
|
[SugarColumn(ColumnName = "F_TJ")]
|
public string? F_TJ { get; set; }
|
|
/// <summary>
|
/// 控制
|
/// </summary>
|
[SugarColumn(ColumnName = "F_KZ")]
|
public string? F_KZ { get; set; }
|
/// <summary>
|
/// 试制or量产?
|
/// </summary>
|
[SugarColumn(ColumnName = "F_SC")]
|
public string? F_SC { get; set; }
|
/// <summary>
|
/// 换算方向
|
/// </summary>
|
[SugarColumn(ColumnName = "F_HSFX")]
|
public string? F_HSFX { get; set; }
|
/// <summary>
|
/// 库存控制
|
/// </summary>
|
[SugarColumn(ColumnName = "F_KCKZ")]
|
public string? F_KCKZ { get; set; }
|
/// <summary>
|
/// 销售控制
|
/// </summary>
|
[SugarColumn(ColumnName = "F_XSKZ")]
|
public string? F_XSKZ { get; set; }
|
/// <summary>
|
/// CRM
|
/// </summary>
|
[SugarColumn(ColumnName = "F_CRM")]
|
public string? F_CRM { get; set; }
|
/// <summary>
|
/// 采购控制
|
/// </summary>
|
[SugarColumn(ColumnName = "F_CGKZ")]
|
public string? F_CGKZ { get; set; }
|
/// <summary>
|
/// 委外类型
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWLX")]
|
public string? F_WWLX { get; set; }
|
/// <summary>
|
/// 检验设置
|
/// </summary>
|
[SugarColumn(ColumnName = "F_JYSZ")]
|
public string? F_JYSZ { get; set; }
|
/// <summary>
|
/// 复检周期（）天
|
/// </summary>
|
[SugarColumn(ColumnName = "F_FJZQ")]
|
public string? F_FJZQ { get; set; }
|
/// <summary>
|
/// 生产类型
|
/// </summary>
|
[SugarColumn(ColumnName = "F_SCLX")]
|
public string? F_SCLX { get; set; }
|
/// <summary>
|
/// 组织间受托类型
|
/// </summary>
|
[SugarColumn(ColumnName = "F_ZZSTLX")]
|
public string? F_ZZSTLX { get; set; }
|
/// <summary>
|
/// 倒冲数量
|
/// </summary>
|
[SugarColumn(ColumnName = "F_DCSL")]
|
public string? F_DCSL { get; set; }
|
/// <summary>
|
/// 标准工时
|
/// </summary>
|
[SugarColumn(ColumnName = "F_BZGS")]
|
public string? F_BZGS { get; set; }
|
/// <summary>
|
/// 分组名称
|
/// </summary>
|
[SugarColumn(ColumnName = "WLFZMC")]
|
public string? WLFZMC { get; set; }
|
/// <summary>
|
/// 模具编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MJBM")]
|
public string? MJBM { get; set; }
|
/// <summary>
|
/// 客户物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "KHWLBM")]
|
public string? Khwlbm { get; set; }
|
/// <summary>
|
/// 颜色
|
/// </summary>
|
[SugarColumn(ColumnName = "YS")]
|
public string? Ys { get; set; }
|
/// <summary>
|
/// 下道工序
|
/// </summary>
|
[SugarColumn(ColumnName = "NEXT_GX")]
|
public string? NesxGx { get; set; }
|
|
}
|
