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