using SqlSugar;

namespace NewPdaSqlServer.entity
{
    /// <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; }
    }
}