using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 任务单物料表
|
///</summary>
|
[SugarTable("WOMCAB")]
|
public class Womcab
|
{
|
/// <summary>
|
/// 自增列
|
///</summary>
|
[SugarColumn(ColumnName="ID" ,IsPrimaryKey = true, OracleSequenceName = "SEQ_CAB")]
|
public decimal Id { get; set; }
|
/// <summary>
|
/// 生产用料清单行内码
|
///</summary>
|
[SugarColumn(ColumnName="ERPID" )]
|
public decimal? Erpid { get; set; }
|
/// <summary>
|
/// 工单单号
|
///</summary>
|
[SugarColumn(ColumnName="CAB001" )]
|
public string Cab001 { get; set; }
|
/// <summary>
|
/// 序号
|
///</summary>
|
[SugarColumn(ColumnName="CAB002" )]
|
public string Cab002 { get; set; }
|
/// <summary>
|
/// 材料编码
|
///</summary>
|
[SugarColumn(ColumnName="CAB003" )]
|
public string Cab003 { get; set; }
|
/// <summary>
|
/// 需领用量
|
///</summary>
|
[SugarColumn(ColumnName="CAB006" )]
|
public decimal? Cab006 { get; set; }
|
/// <summary>
|
/// 已领用量
|
///</summary>
|
[SugarColumn(ColumnName="CAB007" )]
|
public decimal? Cab007 { get; set; }
|
/// <summary>
|
/// 工艺
|
///</summary>
|
[SugarColumn(ColumnName="CAB008" )]
|
public string Cab008 { get; set; }
|
/// <summary>
|
/// 单位
|
///</summary>
|
[SugarColumn(ColumnName="CAB009" )]
|
public string Cab009 { get; set; }
|
/// <summary>
|
/// 组成用量
|
///</summary>
|
[SugarColumn(ColumnName="CAB012" )]
|
public decimal? Cab012 { get; set; }
|
/// <summary>
|
/// 是否替料
|
///</summary>
|
[SugarColumn(ColumnName="CAB014" )]
|
public decimal? Cab014 { get; set; }
|
/// <summary>
|
/// 生产订单行内码
|
///</summary>
|
[SugarColumn(ColumnName="PID" )]
|
public decimal? Pid { get; set; }
|
/// <summary>
|
/// 生产订单行内码
|
///</summary>
|
[SugarColumn(ColumnName="EID" )]
|
public decimal? Eid { get; set; }
|
/// <summary>
|
/// 位置号
|
///</summary>
|
[SugarColumn(ColumnName="POSITION_NO" )]
|
public string PositionNo { get; set; }
|
/// <summary>
|
/// 发料组织
|
///</summary>
|
[SugarColumn(ColumnName="ISSUING_ORGANIZATION" )]
|
public string IssuingOrganization { get; set; }
|
/// <summary>
|
/// 供应组织
|
///</summary>
|
[SugarColumn(ColumnName="SUPPLY_ORGANIZATION" )]
|
public string SupplyOrganization { get; set; }
|
/// <summary>
|
/// 货主
|
///</summary>
|
[SugarColumn(ColumnName="OWNER_ID" )]
|
public string OwnerId { get; set; }
|
/// <summary>
|
/// 计划跟踪号
|
///</summary>
|
[SugarColumn(ColumnName="MTONO" )]
|
public string Mtono { get; set; }
|
/// <summary>
|
/// 批号
|
///</summary>
|
[SugarColumn(ColumnName="LOT" )]
|
public string Lot { get; set; }
|
/// <summary>
|
/// 仓库
|
///</summary>
|
[SugarColumn(ColumnName="DEPOT_CODE" )]
|
public string DepotCode { get; set; }
|
/// <summary>
|
/// 发料方式
|
///</summary>
|
[SugarColumn(ColumnName="ISSUE_TYPE" )]
|
public string IssueType { get; set; }
|
/// <summary>
|
/// 供应类型 C采购 Z自制 W委外
|
///</summary>
|
[SugarColumn(ColumnName="SUPPLY_TYPE" )]
|
public string SupplyType { get; set; }
|
/// <summary>
|
/// 分子
|
///</summary>
|
[SugarColumn(ColumnName="NUMERATOR" )]
|
public decimal? Numerator { get; set; }
|
/// <summary>
|
/// 分母
|
///</summary>
|
[SugarColumn(ColumnName="DENOMINATOR" )]
|
public decimal? Denominator { get; set; }
|
/// <summary>
|
/// 固定损耗
|
///</summary>
|
[SugarColumn(ColumnName="SCRAPQTY" )]
|
public decimal? Scrapqty { get; set; }
|
/// <summary>
|
/// 变动损耗率
|
///</summary>
|
[SugarColumn(ColumnName="SCRAPRATE" )]
|
public decimal? Scraprate { get; set; }
|
/// <summary>
|
/// 销售订单号
|
///</summary>
|
[SugarColumn(ColumnName="SALES_ORDER" )]
|
public string SalesOrder { get; set; }
|
/// <summary>
|
/// 需求单据
|
///</summary>
|
[SugarColumn(ColumnName="F_WWC_TEXT1" )]
|
public string FWwcText1 { get; set; }
|
/// <summary>
|
/// 计划完工日期
|
///</summary>
|
[SugarColumn(ColumnName="F_WWC_DATE" )]
|
public DateTime? FWwcDate { get; set; }
|
/// <summary>
|
/// 旧物料编码
|
///</summary>
|
[SugarColumn(ColumnName="F_WWC_BASEPROPERTY" )]
|
public string FWwcBaseproperty { get; set; }
|
/// <summary>
|
/// 使用比例
|
///</summary>
|
[SugarColumn(ColumnName="FUSERATE" )]
|
public decimal? Fuserate { get; set; }
|
/// <summary>
|
/// 子项类型 1标准件 2返还件 3替代件
|
///</summary>
|
[SugarColumn(ColumnName="FMATERIALTYPE" )]
|
public decimal? Fmaterialtype { get; set; }
|
/// <summary>
|
/// 子项单位
|
///</summary>
|
[SugarColumn(ColumnName="FUNITID3" )]
|
public string Funitid3 { get; set; }
|
/// <summary>
|
/// 子项单位
|
///</summary>
|
[SugarColumn(ColumnName="FUNITID2" )]
|
public string Funitid2 { get; set; }
|
/// <summary>
|
/// 生产通知单
|
///</summary>
|
[SugarColumn(ColumnName="F_XIFG_BASE_RE5" )]
|
public string FXifgBaseRe5 { get; set; }
|
/// <summary>
|
/// 货主类型
|
///</summary>
|
[SugarColumn(ColumnName="FOWNERTYPEID" )]
|
public string Fownertypeid { get; set; }
|
/// <summary>
|
/// ERP生产订单分录内码 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="ERP_PRODUCTION_ENTRY_CODE" )]
|
public string ErpProductionEntryCode { get; set; }
|
/// <summary>
|
/// 用料清单备注 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FMEMO" )]
|
public string Fmemo { get; set; }
|
/// <summary>
|
/// 预留类型 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FRESERVETYPE" )]
|
public string Freservetype { get; set; }
|
/// <summary>
|
/// 需求日期 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FNEEDDATE" )]
|
public DateTime? Fneeddate { get; set; }
|
/// <summary>
|
/// 库存状态 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FSTOCKSTATUSID" )]
|
public string Fstockstatusid { get; set; }
|
/// <summary>
|
/// 拨出仓库 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FSRCTRANSSTOCKID" )]
|
public string Fsrctransstockid { get; set; }
|
/// <summary>
|
/// 拨出组织 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FSRCTRANSORGID" )]
|
public string Fsrctransorgid { get; set; }
|
/// <summary>
|
/// 是否关键件 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FISKEYCOMPONENT" )]
|
public string Fiskeycomponent { get; set; }
|
/// <summary>
|
/// 是否发损耗 -- 委外新增
|
///</summary>
|
[SugarColumn(ColumnName="FISGETSCRAP" )]
|
public string Fisgetscrap { get; set; }
|
/// <summary>
|
/// 状态
|
///</summary>
|
[SugarColumn(ColumnName="WR_F_XIFG_BASE_83G" )]
|
public string WrFXifgBase83g { get; set; }
|
/// <summary>
|
/// 状态
|
///</summary>
|
[SugarColumn(ColumnName="WR_F_XIFG_BASE_QTR" )]
|
public string WrFXifgBaseQtr { get; set; }
|
/// <summary>
|
/// 状态
|
///</summary>
|
[SugarColumn(ColumnName="TYPEB" )]
|
public string Typeb { get; set; }
|
/// <summary>
|
/// 子项类型 1标准件 2返还件 3替代件
|
///</summary>
|
[SugarColumn(ColumnName="MATERIAL_TYPE" )]
|
public string MaterialType { get; set; }
|
/// <summary>
|
/// 使用比例（%）
|
///</summary>
|
[SugarColumn(ColumnName="USE_RATE" )]
|
public decimal? UseRate { get; set; }
|
/// <summary>
|
/// 项次号
|
///</summary>
|
[SugarColumn(ColumnName="FREPLACEGROUP" )]
|
public decimal? Freplacegroup { get; set; }
|
/// <summary>
|
/// 应发数量
|
///</summary>
|
[SugarColumn(ColumnName="MUST_QTY" )]
|
public decimal? MustQty { get; set; }
|
/// <summary>
|
/// 未领数
|
///</summary>
|
[SugarColumn(ColumnName="WLSL" )]
|
public string Wlsl { get; set; }
|
|
/// <summary>
|
/// 客户物料代码
|
///</summary>
|
[SugarColumn(ColumnName = "KHWLBM")]
|
public string Khwlbm { get; set; }
|
|
/// <summary>
|
/// 客户物料名称
|
///</summary>
|
[SugarColumn(ColumnName = "KHWLMC")]
|
public string Khwlmc { get; set; }
|
|
/// <summary>
|
/// 需求组织
|
///</summary>
|
[SugarColumn(ColumnName = "XQZZ")]
|
public string Xqzz { get; set; }
|
|
/// <summary>
|
/// 需求部门
|
///</summary>
|
[SugarColumn(ColumnName = "XQBM")]
|
public string Xqbm { get; set; }
|
/// <summary>
|
/// 收料组织
|
///</summary>
|
[SugarColumn(ColumnName = "SLZZ")]
|
public string Slzz { get; set; }
|
/// <summary>
|
/// 收料部门
|
///</summary>
|
[SugarColumn(ColumnName = "SLBM")]
|
public string Slbm { get; set; }
|
}
|
}
|
