using SqlSugar; namespace NewPdaSqlServer.entity { /// /// 任务单表 /// [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; } /// /// 产品编码 /// [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; } } }