~tjx/NewPdaSqlServer.git

			@@ -1,309 +1,357 @@
			using SqlSugar;

			namespace NewPdaSqlServer.entity
			namespace NewPdaSqlServer.entity;

			/// <summary>
			/// 采购订单明细表
			/// </summary>
			[SugarTable("MES_ROH_IN_DATA")]
			public class MesRohInData
			{
			/// <summary>
			/// 采购订单明细表
			///</summary>
			[SugarTable("MES_ROH_IN_DATA")]
			public class MesRohInData
			{
			/// <summary>
			///
			/// 默认值: (newid())
			///</summary>
			[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
			public Guid Guid { get; set; }
			/// <summary>
			/// 采购单号
			///</summary>
			[SugarColumn(ColumnName="BILL_NO" )]
			public string BillNo { get; set; }
			/// <summary>
			/// 销售订单号
			///</summary>
			[SugarColumn(ColumnName="SALES_ORDER_ID" )]
			public string SalesOrderId { get; set; }
			/// <summary>
			/// 采购订单行号
			///</summary>
			[SugarColumn(ColumnName="ORDER_LINE_ID" )]
			public string OrderLineId { get; set; }
			/// <summary>
			/// 物料编码
			///</summary>
			[SugarColumn(ColumnName="ITEM_ID" )]
			public string ItemId { get; set; }
			/// <summary>
			/// 采购单位
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_UNIT" )]
			public string PurchaseUnit { get; set; }
			/// <summary>
			/// 采购数量
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_QTY" )]
			public decimal? PurchaseQty { get; set; }
			/// <summary>
			/// 库存单位
			///</summary>
			[SugarColumn(ColumnName="INVENTORY_UNIT" )]
			public string InventoryUnit { get; set; }
			/// <summary>
			/// 计价单位
			///</summary>
			[SugarColumn(ColumnName="PRICING_UNIT" )]
			public string PricingUnit { get; set; }
			/// <summary>
			/// 计价数量
			///</summary>
			[SugarColumn(ColumnName="PRICING_QTY" )]
			public decimal? PricingQty { get; set; }
			/// <summary>
			/// 交货日期
			///</summary>
			[SugarColumn(ColumnName="DELIVERY_DATE" )]
			public DateTime? DeliveryDate { get; set; }
			/// <summary>
			/// 最早交货日期
			///</summary>
			[SugarColumn(ColumnName="EARLIEST_DELIVERY_DATE" )]
			public DateTime? EarliestDeliveryDate { get; set; }
			/// <summary>
			/// 最晚交货日期
			///</summary>
			[SugarColumn(ColumnName="LATEST_DELIVERY_DATE" )]
			public DateTime? LatestDeliveryDate { get; set; }
			/// <summary>
			/// 需求组织
			///</summary>
			[SugarColumn(ColumnName="DEMAND_ORG" )]
			public string DemandOrg { get; set; }
			/// <summary>
			/// 收料组织
			///</summary>
			[SugarColumn(ColumnName="RECEIVING_ORG" )]
			public string ReceivingOrg { get; set; }
			/// <summary>
			/// 结算组织
			///</summary>
			[SugarColumn(ColumnName="SETTLEMENT_ORG" )]
			public string SettlementOrg { get; set; }
			/// <summary>
			/// 是否赠品
			///</summary>
			[SugarColumn(ColumnName="IS_GIFT" )]
			public string IsGift { get; set; }
			/// <summary>
			/// 备注
			///</summary>
			[SugarColumn(ColumnName="REMARKS" )]
			public string Remarks { get; set; }
			/// <summary>
			/// 供应商物料编码
			///</summary>
			[SugarColumn(ColumnName="SUPPLIER_ITEM_CODE" )]
			public string SupplierItemCode { get; set; }
			/// <summary>
			/// 供应商物料名称
			///</summary>
			[SugarColumn(ColumnName="SUPPLIER_ITEM_NAME" )]
			public string SupplierItemName { get; set; }
			/// <summary>
			/// 委外订单编号
			///</summary>
			[SugarColumn(ColumnName="OUTSOURCING_ORDER_ID" )]
			public string OutsourcingOrderId { get; set; }
			/// <summary>
			/// 批号
			///</summary>
			[SugarColumn(ColumnName="BATCH_NUMBER" )]
			public string BatchNumber { get; set; }
			/// <summary>
			/// 业务关闭
			///</summary>
			[SugarColumn(ColumnName="BUSINESS_CLOSE" )]
			public string BusinessClose { get; set; }
			/// <summary>
			/// 业务冻结
			///</summary>
			[SugarColumn(ColumnName="BUSINESS_FREEZE" )]
			public string BusinessFreeze { get; set; }
			/// <summary>
			/// 冻结人
			///</summary>
			[SugarColumn(ColumnName="FREEZER" )]
			public string Freezer { get; set; }
			/// <summary>
			/// 冻结时间
			///</summary>
			[SugarColumn(ColumnName="FREEZE_TIME" )]
			public DateTime? FreezeTime { get; set; }
			/// <summary>
			/// 业务终止
			///</summary>
			[SugarColumn(ColumnName="BUSINESS_TERMINATE" )]
			public string BusinessTerminate { get; set; }
			/// <summary>
			/// 终止人
			///</summary>
			[SugarColumn(ColumnName="TERMINATOR" )]
			public string Terminator { get; set; }
			/// <summary>
			/// 终止时间
			///</summary>
			[SugarColumn(ColumnName="TERMINATE_TIME" )]
			public DateTime? TerminateTime { get; set; }
			/// <summary>
			/// 累计收料数量
			///</summary>
			[SugarColumn(ColumnName="TOTAL_RECEIVED_QTY" )]
			public int? TotalReceivedQty { get; set; }
			/// <summary>
			/// 剩余收料数量
			///</summary>
			[SugarColumn(ColumnName="REMAINING_RECEIVED_QTY" )]
			public decimal? RemainingReceivedQty { get; set; }
			/// <summary>
			/// 累计入库数量
			///</summary>
			[SugarColumn(ColumnName="TOTAL_STORED_QTY" )]
			public int? TotalStoredQty { get; set; }
			/// <summary>
			/// 剩余入库数量
			///</summary>
			[SugarColumn(ColumnName="REMAINING_STORED_QTY" )]
			public decimal? RemainingStoredQty { get; set; }
			/// <summary>
			/// 累计退料数量
			///</summary>
			[SugarColumn(ColumnName="TOTAL_RETURNED_QTY" )]
			public int? TotalReturnedQty { get; set; }
			/// <summary>
			/// 收料可退数量
			///</summary>
			[SugarColumn(ColumnName="RETURNABLE_RECEIVED_QTY" )]
			public int? ReturnableReceivedQty { get; set; }
			/// <summary>
			/// 库存可退数量
			///</summary>
			[SugarColumn(ColumnName="RETURNABLE_STORED_QTY" )]
			public int? ReturnableStoredQty { get; set; }
			/// <summary>
			/// 源单类型
			///</summary>
			[SugarColumn(ColumnName="SOURCE_DOCUMENT_TYPE" )]
			public string SourceDocumentType { get; set; }
			/// <summary>
			/// 源单单号
			///</summary>
			[SugarColumn(ColumnName="SOURCE_DOCUMENT_ID" )]
			public string SourceDocumentId { get; set; }
			/// <summary>
			/// 需求跟踪号
			///</summary>
			[SugarColumn(ColumnName="DEMAND_TRACKING_ID" )]
			public string DemandTrackingId { get; set; }
			/// <summary>
			/// 计划跟踪号
			///</summary>
			[SugarColumn(ColumnName="PLAN_TRACKING_ID" )]
			public string PlanTrackingId { get; set; }
			/// <summary>
			/// 变更标志
			///</summary>
			[SugarColumn(ColumnName="CHANGE_FLAG" )]
			public string ChangeFlag { get; set; }
			/// <summary>
			/// 需求来源
			///</summary>
			[SugarColumn(ColumnName="DEMAND_SOURCE" )]
			public string DemandSource { get; set; }
			/// <summary>
			/// 需求单据编号
			///</summary>
			[SugarColumn(ColumnName="DEMAND_DOCUMENT_ID" )]
			public string DemandDocumentId { get; set; }
			/// <summary>
			/// 需求单据行号
			///</summary>
			[SugarColumn(ColumnName="DEMAND_DOCUMENT_LINE_ID" )]
			public string DemandDocumentLineId { get; set; }
			/// <summary>
			/// ERP的ID号
			///</summary>
			[SugarColumn(ColumnName="EBELN_K3ID" )]
			public int? EbelnK3id { get; set; }
			/// <summary>
			/// 客户货号
			///</summary>
			[SugarColumn(ColumnName="REMARK1" )]
			public string Remark1 { get; set; }
			/// <summary>
			/// 包装单号
			///</summary>
			[SugarColumn(ColumnName="REMARK2" )]
			public string Remark2 { get; set; }
			/// <summary>
			/// 主产品
			///</summary>
			[SugarColumn(ColumnName="REMARK3" )]
			public string Remark3 { get; set; }
			/// <summary>
			/// SMT备注
			///</summary>
			[SugarColumn(ColumnName="REMARK4" )]
			public string Remark4 { get; set; }
			/// <summary>
			/// ERP的头ID号
			///</summary>
			[SugarColumn(ColumnName="ERP_ID" )]
			public int? ErpId { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="PURCHASE_ORDER_LINE_NUMBER" )]
			public string PurchaseOrderLineNumber { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="DEMAND" )]
			public string Demand { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="RECEIVING" )]
			public string Receiving { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="SETTLEMENT" )]
			public string Settlement { get; set; }
			/// <summary>
			/// erp推来的已交货数量
			/// 默认值: ((0))
			///</summary>
			[SugarColumn(ColumnName="CGB014" )]
			public int? Cgb014 { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="DEMAND_DEPARTMENT" )]
			public string DemandDepartment { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="RECEIVING_DEPARTMENT" )]
			public string ReceivingDepartment { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="FPREARRIVALDATE" )]
			public DateTime? Fprearrivaldate { get; set; }
			/// <summary>
			///
			///</summary>
			[SugarColumn(ColumnName="FDEMANDBILLNO_LINE" )]
			public string FdemandbillnoLine { get; set; }
			}
			}
			/// 默认值: (newid())
			/// </summary>
			[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
			public Guid Guid { get; set; }

			/// <summary>
			/// 采购单号
			/// </summary>
			[SugarColumn(ColumnName = "BILL_NO")]
			public string? BillNo { get; set; }

			/// <summary>
			/// 销售订单号
			/// </summary>
			[SugarColumn(ColumnName = "SALES_ORDER_ID")]
			public string? SalesOrderId { get; set; }

			/// <summary>
			/// 采购订单行号
			/// </summary>
			[SugarColumn(ColumnName = "ORDER_LINE_ID")]
			public string? OrderLineId { get; set; }

			/// <summary>
			/// 物料编码
			/// </summary>
			[SugarColumn(ColumnName = "ITEM_ID")]
			public string? ItemId { get; set; }

			/// <summary>
			/// 采购单位
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_UNIT")]
			public string? PurchaseUnit { get; set; }

			/// <summary>
			/// 采购数量
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_QTY")]
			public decimal? PurchaseQty { get; set; }

			/// <summary>
			/// 库存单位
			/// </summary>
			[SugarColumn(ColumnName = "INVENTORY_UNIT")]
			public string? InventoryUnit { get; set; }

			/// <summary>
			/// 计价单位
			/// </summary>
			[SugarColumn(ColumnName = "PRICING_UNIT")]
			public string? PricingUnit { get; set; }

			/// <summary>
			/// 计价数量
			/// </summary>
			[SugarColumn(ColumnName = "PRICING_QTY")]
			public decimal? PricingQty { get; set; }

			/// <summary>
			/// 交货日期
			/// </summary>
			[SugarColumn(ColumnName = "DELIVERY_DATE")]
			public DateTime? DeliveryDate { get; set; }

			/// <summary>
			/// 最早交货日期
			/// </summary>
			[SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
			public DateTime? EarliestDeliveryDate { get; set; }

			/// <summary>
			/// 最晚交货日期
			/// </summary>
			[SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
			public DateTime? LatestDeliveryDate { get; set; }

			/// <summary>
			/// 需求组织
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_ORG")]
			public string? DemandOrg { get; set; }

			/// <summary>
			/// 收料组织
			/// </summary>
			[SugarColumn(ColumnName = "RECEIVING_ORG")]
			public string? ReceivingOrg { get; set; }

			/// <summary>
			/// 结算组织
			/// </summary>
			[SugarColumn(ColumnName = "SETTLEMENT_ORG")]
			public string? SettlementOrg { get; set; }

			/// <summary>
			/// 是否赠品
			/// </summary>
			[SugarColumn(ColumnName = "IS_GIFT")]
			public string? IsGift { get; set; }

			/// <summary>
			/// 备注
			/// </summary>
			[SugarColumn(ColumnName = "REMARKS")]
			public string? Remarks { get; set; }

			/// <summary>
			/// 供应商物料编码
			/// </summary>
			[SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
			public string? SupplierItemCode { get; set; }

			/// <summary>
			/// 供应商物料名称
			/// </summary>
			[SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
			public string? SupplierItemName { get; set; }

			/// <summary>
			/// 委外订单编号
			/// </summary>
			[SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
			public string? OutsourcingOrderId { get; set; }

			/// <summary>
			/// 批号
			/// </summary>
			[SugarColumn(ColumnName = "BATCH_NUMBER")]
			public string? BatchNumber { get; set; }

			/// <summary>
			/// 业务关闭
			/// </summary>
			[SugarColumn(ColumnName = "BUSINESS_CLOSE")]
			public string? BusinessClose { get; set; }

			/// <summary>
			/// 业务冻结
			/// </summary>
			[SugarColumn(ColumnName = "BUSINESS_FREEZE")]
			public string? BusinessFreeze { get; set; }

			/// <summary>
			/// 冻结人
			/// </summary>
			[SugarColumn(ColumnName = "FREEZER")]
			public string? Freezer { get; set; }

			/// <summary>
			/// 冻结时间
			/// </summary>
			[SugarColumn(ColumnName = "FREEZE_TIME")]
			public DateTime? FreezeTime { get; set; }

			/// <summary>
			/// 业务终止
			/// </summary>
			[SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
			public string? BusinessTerminate { get; set; }

			/// <summary>
			/// 终止人
			/// </summary>
			[SugarColumn(ColumnName = "TERMINATOR")]
			public string? Terminator { get; set; }

			/// <summary>
			/// 终止时间
			/// </summary>
			[SugarColumn(ColumnName = "TERMINATE_TIME")]
			public DateTime? TerminateTime { get; set; }

			/// <summary>
			/// 累计收料数量
			/// </summary>
			[SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
			public int? TotalReceivedQty { get; set; }

			/// <summary>
			/// 剩余收料数量
			/// </summary>
			[SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
			public decimal? RemainingReceivedQty { get; set; }

			/// <summary>
			/// 累计入库数量
			/// </summary>
			[SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
			public int? TotalStoredQty { get; set; }

			/// <summary>
			/// 剩余入库数量
			/// </summary>
			[SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
			public decimal? RemainingStoredQty { get; set; }

			/// <summary>
			/// 累计退料数量
			/// </summary>
			[SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
			public int? TotalReturnedQty { get; set; }

			/// <summary>
			/// 收料可退数量
			/// </summary>
			[SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
			public int? ReturnableReceivedQty { get; set; }

			/// <summary>
			/// 库存可退数量
			/// </summary>
			[SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
			public int? ReturnableStoredQty { get; set; }

			/// <summary>
			/// 源单类型
			/// </summary>
			[SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
			public string? SourceDocumentType { get; set; }

			/// <summary>
			/// 源单单号
			/// </summary>
			[SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
			public string? SourceDocumentId { get; set; }

			/// <summary>
			/// 需求跟踪号
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
			public string? DemandTrackingId { get; set; }

			/// <summary>
			/// 计划跟踪号
			/// </summary>
			[SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
			public string? PlanTrackingId { get; set; }

			/// <summary>
			/// 变更标志
			/// </summary>
			[SugarColumn(ColumnName = "CHANGE_FLAG")]
			public string? ChangeFlag { get; set; }

			/// <summary>
			/// 需求来源
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_SOURCE")]
			public string? DemandSource { get; set; }

			/// <summary>
			/// 需求单据编号
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
			public string? DemandDocumentId { get; set; }

			/// <summary>
			/// 需求单据行号
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
			public string? DemandDocumentLineId { get; set; }

			/// <summary>
			/// ERP的ID号
			/// </summary>
			[SugarColumn(ColumnName = "EBELN_K3ID")]
			public int? EbelnK3id { get; set; }

			/// <summary>
			/// 客户货号
			/// </summary>
			[SugarColumn(ColumnName = "REMARK1")]
			public string? Remark1 { get; set; }

			/// <summary>
			/// 包装单号
			/// </summary>
			[SugarColumn(ColumnName = "REMARK2")]
			public string? Remark2 { get; set; }

			/// <summary>
			/// 主产品
			/// </summary>
			[SugarColumn(ColumnName = "REMARK3")]
			public string? Remark3 { get; set; }

			/// <summary>
			/// SMT备注
			/// </summary>
			[SugarColumn(ColumnName = "REMARK4")]
			public string? Remark4 { get; set; }

			/// <summary>
			/// ERP的头ID号
			/// </summary>
			[SugarColumn(ColumnName = "ERP_ID")]
			public int? ErpId { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")]
			public string? PurchaseOrderLineNumber { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND")]
			public string? Demand { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "RECEIVING")]
			public string? Receiving { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "SETTLEMENT")]
			public string? Settlement { get; set; }

			/// <summary>
			/// erp推来的已交货数量
			/// 默认值: ((0))
			/// </summary>
			[SugarColumn(ColumnName = "CGB014")]
			public int? Cgb014 { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "DEMAND_DEPARTMENT")]
			public string? DemandDepartment { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
			public string? ReceivingDepartment { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "FPREARRIVALDATE")]
			public DateTime? Fprearrivaldate { get; set; }

			/// <summary>
			/// </summary>
			[SugarColumn(ColumnName = "FDEMANDBILLNO_LINE")]
			public string? FdemandbillnoLine { get; set; }
			}