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>
|
/// 物料编码
|
/// </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 = "Safe_Stock")]
|
public double? SafeStock { 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 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 string? 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 string? 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>
|
/// 物料属性 0=模型，1=按订单拣货，2=按订单装配，3=可选类，4=委外加工件，
|
/// 5=工序委外件，6=虚拟，7=计划，8=系列，9=采购件，10=制造件，
|
/// 11=最终装配件，12=套件，13=工艺，14=低值易耗品，15=商品，
|
/// 16=杂项料品，17=服务，18=资产，19=备件，20=配方，
|
/// 21=重复，22=费用性料品
|
/// </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; }
|
|
/// <summary>
|
/// 设备
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT8")]
|
public string? FWwcText8 { get; set; }
|
|
/// <summary>
|
/// 功率
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DECIMAL")]
|
public string? FWwcDecimal { get; set; }
|
|
/// <summary>
|
/// 单小时产能
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DECIMAL1")]
|
public string? FWwcDecimal1 { get; set; }
|
|
/// <summary>
|
/// 人数
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DECIMAL2")]
|
public string? FWwcDecimal2 { get; set; }
|
|
/// <summary>
|
/// 人工小时工资
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DECIMAL3")]
|
public string? FWwcDecimal3 { get; set; }
|
|
/// <summary>
|
/// 人工定额
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DECIMAL4")]
|
public string? FWwcDecimal4 { get; set; }
|
|
/// <summary>
|
/// 标准产能
|
/// </summary>
|
[SugarColumn(ColumnName = "FBCN")]
|
public string? Fbcn { get; set; }
|
|
/// <summary>
|
/// 钢网
|
/// </summary>
|
[SugarColumn(ColumnName = "FGW")]
|
public string? Fgw { get; set; }
|
|
/// <summary>
|
/// 治具
|
/// </summary>
|
[SugarColumn(ColumnName = "FYJ")]
|
public string? Fyj { get; set; }
|
|
/// <summary>
|
/// 设备
|
/// </summary>
|
[SugarColumn(ColumnName = "FSB")]
|
public string? Fsb { get; set; }
|
|
/// <summary>
|
/// 图号
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT1")]
|
public string? FWwcText1 { get; set; }
|
|
/// <summary>
|
/// 模具编号
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT2")]
|
public string? FWwcText2 { get; set; }
|
|
/// <summary>
|
/// 模具出数
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT3")]
|
public string? FWwcText3 { get; set; }
|
|
/// <summary>
|
/// 注塑周期
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT4")]
|
public string? FWwcText4 { get; set; }
|
|
/// <summary>
|
/// 单双色
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT5")]
|
public string? FWwcText5 { get; set; }
|
|
/// <summary>
|
/// 注塑件吨位
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT6")]
|
public string? FWwcText6 { get; set; }
|
|
/// <summary>
|
/// 外部料号
|
/// </summary>
|
[SugarColumn(ColumnName = "CATALOG_NO")]
|
public string? CatalogNo { get; set; }
|
|
|
/// <summary>
|
/// 领料单位
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_OUT_UOMID")]
|
public string? MaterialOutUomid { get; set; }
|
|
/// <summary>
|
/// 生产部门
|
/// </summary>
|
[SugarColumn(ColumnName = "PUB_DESC_SEG38")]
|
public string? PubDescSeg38 { get; set; }
|
|
/// <summary>
|
/// 项目（研发）
|
/// </summary>
|
[SugarColumn(ColumnName = "DESCRIPTION")]
|
public string? Description { get; set; }
|
|
/// <summary>
|
/// 项目（报表）
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG4")]
|
public string? PrivateDescSeg4 { get; set; }
|
|
/// <summary>
|
/// 报表项目（汇总）
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG9")]
|
public string? PrivateDescSeg9 { get; set; }
|
|
/// <summary>
|
/// 双数量
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_DUAL_QUANTITY")]
|
public string? IsDualQuantity { get; set; }
|
|
/// <summary>
|
/// 双单位
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_DUAL_UOM")]
|
public string? IsDualUom { get; set; }
|
|
/// <summary>
|
/// 多单位
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_MULTY_UOM")]
|
public string? IsMultyUom { get; set; }
|
|
/// <summary>
|
/// 固定转换率
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_VAR_RATIO")]
|
public string? IsVarRatio { get; set; }
|
|
/// <summary>
|
/// 转换率策略
|
/// </summary>
|
[SugarColumn(ColumnName = "CONVER_RATIO_RULE")]
|
public string? ConverRatioRule { get; set; }
|
|
/// <summary>
|
/// 标准库周
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG11")]
|
public string? PrivateDescSeg11 { get; set; }
|
|
/// <summary>
|
/// 品牌分类
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG7")]
|
public string? PrivateDescSeg7 { get; set; }
|
|
/// <summary>
|
/// BU（业务单元）
|
/// </summary>
|
[SugarColumn(ColumnName = "PRIVATE_DESC_SEG2")]
|
public string? PrivateDescSeg2 { get; set; }
|
|
/// <summary>
|
/// BU（业务单元）
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
|
public string? DocumentStatus { get; set; }
|
|
/// <summary>
|
/// 是否生效
|
/// </summary>
|
[SugarColumn(ColumnName = "FORBID_STATUS")]
|
public string? ForbidStatus { get; set; }
|
|
/// <summary>
|
/// 旧物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "Old_ITEM_NO")]
|
public string? OldItemNo { get; set; }
|
|
/// <summary>
|
/// 采购业务员
|
/// </summary>
|
[SugarColumn(ColumnName = "MERCHANDISER")]
|
public string? Merchandiser { get; set; }
|
|
/// <summary>
|
/// 仓管员
|
/// </summary>
|
[SugarColumn(ColumnName = "WAREHOUSEKEEPER")]
|
public string? WarehouseKeeper { get; set; }
|
}
|
