| | |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | /// <summary> |
| | | /// 工单表 |
| | | /// </summary> |
| | | [SugarTable("WOMCAA")] |
| | | public class Womcaa |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | /// <summary> |
| | | /// 自增列 SEQ_AOI |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, |
| | | OracleSequenceName = "SEQ_CAA")] |
| | | public decimal? Id { get; set; } |
| | | /// 任务单表 |
| | | ///</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> |
| | | /// ERPID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERPID")] |
| | | public decimal? Erpid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CAA001")] |
| | | public string? Caa001 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单据类型 1、直接入库-普通生产 SCDD03_SYS2、直接入库-返工生产 SCDD04_SYS3、工序汇报-普通生产 |
| | | /// SCDD01_SYS4、工序汇报-返工生产 SCDD02_SYS |
| | | /// </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 = "F_ZSXG_KH")] |
| | | public string? F_ZSXG_KH { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 要货日期 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_ZJXF_YHRQ")] |
| | | public string? F_ZJXF_YHRQ { 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 string? JaBs { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 修改标识 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "IS_XG")] |
| | | public decimal? IsXg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 1,新增;2,变更 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TYPEA")] |
| | | public string? Typea { get; set; } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 生产通知单 (沃尔新增) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WR_F_SCDD_SCTZD")] |
| | | public string? WR_F_SCDD_SCTZD { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 型号 (沃尔新增) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WR_F_SCDD_XH")] |
| | | public string? WR_F_SCDD_XH { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注(表体) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BTBZ")] |
| | | public string? BTBZ { 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> |
| | | /// ERP委外订单分录内码 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FSUBENTRYID")] |
| | | public string? FSUBENTRYID { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP委外订单分录内码 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FPURORDERNO")] |
| | | public string? FPURORDERNO { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 采购订单行号 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] |
| | | public string? FPURORDERENTRYSEQ { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 基本单位入库数量 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FBASESTOCKINQTY")] |
| | | public decimal? FBASESTOCKINQTY { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 基本单位未入库数量 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FBASENOSTOCKINQTY")] |
| | | public decimal? FBASENOSTOCKINQTY { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库货主 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FINSTOCKOWNERID")] |
| | | public string? FINSTOCKOWNERID { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产通知单 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_WWDD_SCTZD")] |
| | | public string? F_WWDD_SCTZD { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 型号 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_WWDD_XH")] |
| | | public string? F_WWDD_XH { get; set; } |
| | | |
| | | /// <summary> |
| | | /// BOM备注 -- 委外 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "F_XIFG_TEXT_TZK")] |
| | | public string? F_XIFG_TEXT_TZK { 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; } |
| | | } |
| | | } |