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