using SqlSugar; namespace MES.Service.Modes; /// /// 生产任务单表 /// [SugarTable("WOMCAA")] public class Womcaa { /// /// 默认值: (newid()) /// [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] public Guid Guid { get; set; } /// /// ERPID /// [SugarColumn(ColumnName = "ERPID")] public int? Erpid { get; set; } /// /// 单据编号 /// [SugarColumn(ColumnName = "CAA001")] public string? Caa001 { get; set; } /// /// 单据类型("1、直接入库-普通生产 2、直接入库-返工生产 3、工序汇报-普通生产 4、工序汇报-返工生产") /// [SugarColumn(ColumnName = "CAA004")] public string? Caa004 { get; set; } /// /// 计划下达日期 /// [SugarColumn(ColumnName = "CAA005")] public string? Caa005 { get; set; } /// /// 产品ID /// [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 int? Caa017 { get; set; } /// /// ERP生产订单ID /// [SugarColumn(ColumnName = "CAA018")] public int? Caa018 { get; set; } /// /// ERP生产订单序号 /// [SugarColumn(ColumnName = "CAA019")] public int? Caa019 { get; set; } /// /// ERP生产订单单号 /// [SugarColumn(ColumnName = "CAA020")] public string? Caa020 { get; set; } /// /// 生产车间 /// [SugarColumn(ColumnName = "CAA021")] public string? Caa021 { get; set; } /// /// 审核码 /// [SugarColumn(ColumnName = "FSTATUS")] public int? 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 int? Caa022 { get; set; } /// /// 业务状态("1,计划,2、计划确认 2、下达 4、开工 5、完工 6、结案,7、结算") /// [SugarColumn(ColumnName = "CAA023")] public string? Caa023 { get; set; } /// /// 已入库数量 /// [SugarColumn(ColumnName = "CAA024")] public int? 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 = "ERP_SCZZ")] public int? ErpSczz { get; set; } /// /// 是否委托 /// [SugarColumn(ColumnName = "ERP_WTZZ")] public int? ErpWtzz { get; set; } /// /// [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")] public string? MainProductNo { get; set; } /// /// [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")] public int? MainProductQty { get; set; } /// /// [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")] public string? CustomerItemNumber { get; set; } /// /// [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")] public string? PackingListNumber { get; set; } /// /// [SugarColumn(ColumnName = "CUSTOMER_NAME")] public string? CustomerName { get; set; } /// /// [SugarColumn(ColumnName = "CUSTOMER")] public string? Customer { get; set; } /// /// [SugarColumn(ColumnName = "TYPE")] public string? Type { get; set; } /// /// [SugarColumn(ColumnName = "JA_BS")] public string? JaBs { get; set; } /// /// [SugarColumn(ColumnName = "JA_TIME")] public DateTime? JaTime { get; set; } /// /// [SugarColumn(ColumnName = "YP_NUM")] public int? YpNum { get; set; } /// /// [SugarColumn(ColumnName = "CAA011_1")] public string? Caa0111 { get; set; } /// /// [SugarColumn(ColumnName = "ERP_GYZZ")] public int? ErpGyzz { get; set; } /// /// [SugarColumn(ColumnName = "ERP_FLZZ")] public int? ErpFlzz { get; set; } /// /// 是否入库 /// [SugarColumn(ColumnName = "ERP_SLZZ")] public int? ErpSlzz { get; set; } /// /// 是否退库 /// [SugarColumn(ColumnName = "ERP_RKZZ")] public int? ErpRkzz { get; set; } /// /// 是否换货 /// [SugarColumn(ColumnName = "ERP_RKHZ")] public int? ErpRkhz { get; set; } /// /// 是否寄售 /// [SugarColumn(ColumnName = "ERP_JJDS")] public int? ErpJjds { get; set; } /// /// 是否按款 /// [SugarColumn(ColumnName = "ERP_BZDS")] public int? ErpBzds { get; set; } /// /// 是否新建 /// [SugarColumn(ColumnName = "CAA025")] public int? Caa025 { get; set; } /// /// 采购订单号 /// [SugarColumn(ColumnName = "FPURORDERNO")] public string? Fpurorderno { get; set; } /// /// 采购订单行号 /// [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] public string? Fpurorderentryseq { get; set; } /// /// 备注(表体) /// [SugarColumn(ColumnName = "Btbz")] public string? Btbz { get; set; } /// /// 源拆分订单编号 /// [SugarColumn(ColumnName = "fmoentryid")] public string? Fmoentryid { get; set; } /// /// 排产线别 /// [SugarColumn(ColumnName = "prod_line")] public string? ProdLine { get; set; } /// /// 1,新增;2,变更 /// [SugarColumn(ColumnName = "TYPEA")] public string? Typea { get; set; } /// /// 同步时间 /// [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")] public DateTime? SynchronousDate { get; set; } }