~tjx/NewPdaSqlServer.git

			@@ -1,7 +1,7 @@
			using SqlSugar;

			namespace NewPdaSqlServer.entity
			{
			namespace NewPdaSqlServer.entity;

			/// <summary>
			/// 采购订单明细表
			///</summary>
			@@ -9,301 +9,349 @@
			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; }
			}
			}