using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes { /// /// 任务单表 /// [SugarTable("WOMCAA")] public class Womcaa { /// /// 自增列 /// [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true , OracleSequenceName = "SEQ_CAA")] public decimal Id { get; set; } /// /// 生产订单行内码 /// [SugarColumn(ColumnName="ERPID" )] public decimal? Erpid { get; set; } /// /// 单据编号 /// [SugarColumn(ColumnName="CAA001" )] public string Caa001 { get; set; } /// /// 单据类型 /// [SugarColumn(ColumnName="CAA004" )] public string Caa004 { get; set; } /// /// 计划下达日期 /// [SugarColumn(ColumnName="CAA005" )] public string Caa005 { get; set; } /// /// 产品编码 /// [SugarColumn(ColumnName="CAA006" )] public string Caa006 { get; set; } /// /// 单位 /// [SugarColumn(ColumnName="CAA009" )] public string Caa009 { get; set; } /// /// 预计开工时间 /// [SugarColumn(ColumnName="CAA010" )] public string Caa010 { get; set; } /// /// 预计完工时间 /// [SugarColumn(ColumnName="CAA011" )] public string Caa011 { get; set; } /// /// 工单数量 /// [SugarColumn(ColumnName="CAA012" )] public decimal? Caa012 { get; set; } /// /// BOM版次 /// [SugarColumn(ColumnName="CAA013" )] public string Caa013 { get; set; } /// /// 销售订单号 /// [SugarColumn(ColumnName="CAA015" )] public string Caa015 { get; set; } /// /// 备注 /// [SugarColumn(ColumnName="CAA016" )] public string Caa016 { get; set; } /// /// 已排数量 /// [SugarColumn(ColumnName="CAA017" )] public decimal? Caa017 { get; set; } /// /// ERP生产订单ID /// [SugarColumn(ColumnName="CAA018" )] public decimal? Caa018 { get; set; } /// /// ERP生产订单序号 /// [SugarColumn(ColumnName="CAA019" )] public string Caa019 { get; set; } /// /// ERP生产订单单号 /// [SugarColumn(ColumnName="CAA020" )] public string Caa020 { get; set; } /// /// 生产车间 /// [SugarColumn(ColumnName="CAA021" )] public string Caa021 { get; set; } /// /// 审核码 /// [SugarColumn(ColumnName="FSTATUS" )] public decimal? Fstatus { get; set; } /// /// 审核日期 /// [SugarColumn(ColumnName="CHECK_DATE" )] public DateTime? CheckDate { get; set; } /// /// 审核人 /// [SugarColumn(ColumnName="CHECK_USER" )] public string CheckUser { get; set; } /// /// 未排数量 /// [SugarColumn(ColumnName="CAA022" )] public decimal? Caa022 { get; set; } /// /// 业务状态 /// [SugarColumn(ColumnName="CAA023" )] public string Caa023 { get; set; } /// /// 已入库数量 /// [SugarColumn(ColumnName="CAA024" )] public decimal? Caa024 { get; set; } /// /// 工艺路线 /// [SugarColumn(ColumnName="ROUTING_ID" )] public string RoutingId { get; set; } /// /// 产线 /// [SugarColumn(ColumnName="WORK_SHOP_ID" )] public string WorkShopId { get; set; } /// /// 仓库 /// [SugarColumn(ColumnName="DEPOT_CODE" )] public string DepotCode { get; set; } /// /// 单据日期 /// [SugarColumn(ColumnName="CREATE_DATE" )] public string CreateDate { get; set; } /// /// 计划组 /// [SugarColumn(ColumnName="WORK_GROUP_ID" )] public string WorkGroupId { get; set; } /// /// 计划员 /// [SugarColumn(ColumnName="PLAN_ID" )] public string PlanId { get; set; } /// /// 入库上限 /// [SugarColumn(ColumnName="STOCK_INLIMITH" )] public string StockInlimith { get; set; } /// /// 入库下限 /// [SugarColumn(ColumnName="STOCK_INLIMITL" )] public string StockInlimitl { get; set; } /// /// 计划跟踪号 /// [SugarColumn(ColumnName="MTONO" )] public string Mtono { get; set; } /// /// 批号 /// [SugarColumn(ColumnName="LOT" )] public string Lot { get; set; } /// /// 销售订单行号 /// [SugarColumn(ColumnName="CAA015_HEAD" )] public string Caa015Head { get; set; } /// /// 生成方式 /// [SugarColumn(ColumnName="CREATE_TYPE" )] public string CreateType { get; set; } /// /// 源单类型 /// [SugarColumn(ColumnName="SRC_BILL_TYPE" )] public string SrcBillType { get; set; } /// /// 源单编码 /// [SugarColumn(ColumnName="SRC_BILL_NO" )] public string SrcBillNo { get; set; } /// /// 源单分录行号 /// [SugarColumn(ColumnName="SRC_BILLENTRYSEQ" )] public string SrcBillentryseq { get; set; } /// /// 需求单据号 /// [SugarColumn(ColumnName="SALE_ORDER_NO" )] public string SaleOrderNo { get; set; } /// /// 需求单据行号 /// [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ" )] public string SaleOrderEntryseq { get; set; } /// /// 结案人 /// [SugarColumn(ColumnName="FORCE_CLOSERID" )] public string ForceCloserid { get; set; } /// /// 结案类型 /// [SugarColumn(ColumnName="CLOSE_TYPE" )] public string CloseType { get; set; } /// /// 源拆分订单编号 /// [SugarColumn(ColumnName="SRC_SPLIT_BILLNO" )] public string SrcSplitBillno { get; set; } /// /// 生产组织 /// [SugarColumn(ColumnName="PRD_ORG" )] public string PrdOrg { get; set; } /// /// 委托组织 /// [SugarColumn(ColumnName="TRUST_ORG" )] public string TrustOrg { get; set; } /// /// 同步时间 /// [SugarColumn(ColumnName="TB_TIME" )] public DateTime? TbTime { get; set; } /// /// 结案时间 /// [SugarColumn(ColumnName="JA_TIME" )] public DateTime? JaTime { get; set; } /// /// 结案标识 /// [SugarColumn(ColumnName="JA_BS" )] public decimal? JaBs { get; set; } /// /// 旧物料编码 /// [SugarColumn(ColumnName="F_WWC_BASEPROPERTY" )] public string FWwcBaseproperty { get; set; } /// /// 计划完工携带日期 /// [SugarColumn(ColumnName="F_WWC_DATETIME" )] public DateTime? FWwcDatetime { get; set; } /// /// 生产入库日期 /// [SugarColumn(ColumnName="F_WWC_SCRKRQ" )] public DateTime? FWwcScrkrq { get; set; } /// /// 工时 /// [SugarColumn(ColumnName="FGS" )] public decimal? Fgs { get; set; } /// /// 产线人数 /// [SugarColumn(ColumnName="F_WWC_DECIMAL" )] public decimal? FWwcDecimal { get; set; } /// /// 线别 /// [SugarColumn(ColumnName="F_WWC_XB" )] public string FWwcXb { get; set; } /// /// 销售员 /// [SugarColumn(ColumnName="F_WWC_BASE" )] public string FWwcBase { get; set; } /// /// 修改标识 /// [SugarColumn(ColumnName="IS_XG" )] public decimal? IsXg { get; set; } /// /// 委外采购订单 /// [SugarColumn(ColumnName="FPURORDERNO" )] public string Fpurorderno { get; set; } /// /// 委外采购订单行号 /// [SugarColumn(ColumnName="FPURORDERENTRYSEQ" )] public string Fpurorderentryseq { get; set; } /// /// 委外订单分录内码 /// [SugarColumn(ColumnName="FSUBENTRYID" )] public decimal? Fsubentryid { get; set; } /// /// 委外入库数 /// [SugarColumn(ColumnName="FSTOCKINQTY" )] public decimal? Fstockinqty { get; set; } /// /// 委外未入库数 /// [SugarColumn(ColumnName="FNOSTOCKINQTY" )] public decimal? Fnostockinqty { get; set; } /// /// BOM备注 -- 委外 /// [SugarColumn(ColumnName="F_XIFG_TEXT_TZK" )] public string FXifgTextTzk { get; set; } /// /// 生产通知单 (沃尔新增) /// [SugarColumn(ColumnName="WR_F_SCDD_SCTZD" )] public string WrFScddSctzd { get; set; } /// /// 型号 (沃尔新增) /// [SugarColumn(ColumnName="WR_F_SCDD_XH" )] public string WrFScddXh { get; set; } /// /// 计划确认时间(执行日期) --委外 /// [SugarColumn(ColumnName="PLANCONFIRMATION" )] public string Planconfirmation { get; set; } /// /// ERP生产订单ID --委外 /// [SugarColumn(ColumnName="FSUBID" )] public string Fsubid { get; set; } /// /// ERP生产订单序号 --委外 /// [SugarColumn(ColumnName="FSUBBILLNOSEQ" )] public string Fsubbillnoseq { get; set; } /// /// ERP生产订单单号 --委外 /// [SugarColumn(ColumnName="FSUBBILLNO" )] public string Fsubbillno { get; set; } /// /// 需求来源 --委外 /// [SugarColumn(ColumnName="FREQSRC" )] public string Freqsrc { get; set; } /// /// 源拆分订单行号 --委外 /// [SugarColumn(ColumnName="SRCSPLITSEQ" )] public string Srcsplitseq { get; set; } /// /// 基本单位入库数量 -- 委外 /// [SugarColumn(ColumnName="FBASESTOCKINQTY" )] public string Fbasestockinqty { get; set; } /// /// 基本单位未入库数量 -- 委外 /// [SugarColumn(ColumnName="FBASENOSTOCKINQTY" )] public string Fbasenostockinqty { get; set; } /// /// 入库货主 -- 委外 /// [SugarColumn(ColumnName="FINSTOCKOWNERID" )] public string Finstockownerid { get; set; } /// /// 生产通知单 -- 委外 /// [SugarColumn(ColumnName="F_WWDD_SCTZD" )] public string FWwddSctzd { get; set; } /// /// 型号 -- 委外 /// [SugarColumn(ColumnName="F_WWDD_XH" )] public string FWwddXh { get; set; } /// /// 表体备注 /// [SugarColumn(ColumnName="BTBZ" )] public string Btbz { get; set; } /// /// 日产能 /// [SugarColumn(ColumnName="RCN" )] public string Rcn { get; set; } /// /// 入库组织 /// [SugarColumn(ColumnName="RK_ORG" )] public string RkOrg { get; set; } /// /// 状态 /// [SugarColumn(ColumnName="TYPEA" )] public string Typea { get; set; } /// /// 要货日期 /// [SugarColumn(ColumnName="F_ZJXF_YHRQ" )] public string FZjxfYhrq { get; set; } /// /// 客户 /// [SugarColumn(ColumnName="F_ZSXG_KH" )] public string FZsxgKh { get; set; } /// /// 采购订单行id /// [SugarColumn(ColumnName= "CG_LINE_ID")] public string Cglineid { get; set; } /// /// 委外组织 /// [SugarColumn(ColumnName = "WW_ORG")] public string WwOrg { get; set; } /// /// 采购组织 /// [SugarColumn(ColumnName = "CG_ORG")] public string CgOrg { get; set; } /// /// 供应商id /// [SugarColumn(ColumnName = "SUPP_ID")] public string SuppId { get; set; } /// /// 客户 /// [SugarColumn(ColumnName = "KH")] public string Kh { get; set; } /// /// 客户基础资料 /// [SugarColumn(ColumnName = "KH_JC")] public string Khjc { get; set; } /// /// 生产批号 /// [SugarColumn(ColumnName = "SC_PH")] public string Scph { get; set; } /// /// 模具号 /// [SugarColumn(ColumnName = "MOLD_NO")] public string Moldno { get; set; } /// /// 旧模具号 /// [SugarColumn(ColumnName = "OLD_MOLD_NO")] public string Oldmoldno { get; set; } /// /// 机台号 /// [SugarColumn(ColumnName = "JT")] public string Jt { get; set; } /// /// 小时产能 /// [SugarColumn(ColumnName = "XS_CN")] public string Xscn { get; set; } /// /// 实际穴数 /// [SugarColumn(ColumnName = "SJ_XS")] public string Sjxs { get; set; } /// /// 下道工序 /// [SugarColumn(ColumnName = "NEXT_GX")] public string Nextgx { get; set; } /// /// 下道工序 /// [SugarColumn(ColumnName = "RKS")] public string Rks { get; set; } } }