using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 委外投料单
    ///</summary>
    [SugarTable("PRODUCTION_ORDER")]
    public class ProductionOrder
    {
        /// <summary>
        /// SEQ_WW 
        ///</summary>
        [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER", IsPrimaryKey = true)]
        public decimal Id { get; set; }
        /// <summary>
        /// 单据编号 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_NO")]
        public string? OrderNo { get; set; }
        /// <summary>
        /// 贴片工艺属性 
        ///</summary>
        [SugarColumn(ColumnName = "SMT_PROCESS_ATTR")]
        public string? SmtProcessAttr { get; set; }
        /// <summary>
        /// 仓库 
        ///</summary>
        [SugarColumn(ColumnName = "WAREHOUSE")]
        public string? Warehouse { get; set; }
        /// <summary>
        /// 单据日期 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_DATE")]
        public DateTime? OrderDate { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
        [SugarColumn(ColumnName = "ORDER_TYPE")]
        public string? OrderType { get; set; }
        /// <summary>
        /// 业务状态 
        ///</summary>
        [SugarColumn(ColumnName = "BUSINESS_STATUS")]
        public string? BusinessStatus { get; set; }
        /// <summary>
        /// 产品编码 
        ///</summary>
        [SugarColumn(ColumnName = "PRODUCT_CODE")]
        public string? ProductCode { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
        [SugarColumn(ColumnName = "UNIT")]
        public string? Unit { get; set; }
        /// <summary>
        /// 工单数量 
        ///</summary>
        [SugarColumn(ColumnName = "WORK_ORDER_QTY")]
        public double? WorkOrderQty { get; set; }
        /// <summary>
        /// 计划组 
        ///</summary>
        [SugarColumn(ColumnName = "PLANNING_GROUP")]
        public string? PlanningGroup { get; set; }
        /// <summary>
        /// 计划员 
        ///</summary>
        [SugarColumn(ColumnName = "PLANNER")]
        public string? Planner { get; set; }
        /// <summary>
        /// 预计开工时间 
        ///</summary>
        [SugarColumn(ColumnName = "ESTIMATED_START_TIME")]
        public DateTime? EstimatedStartTime { get; set; }
        /// <summary>
        /// 预计完工时间 
        ///</summary>
        [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
        public DateTime? EstimatedEndTime { get; set; }
        /// <summary>
        /// 计划下达日期 
        ///</summary>
        [SugarColumn(ColumnName = "PLAN_RELEASE_DATE")]
        public DateTime? PlanReleaseDate { get; set; }
        /// <summary>
        /// 入库上限 
        ///</summary>
        [SugarColumn(ColumnName = "STORAGE_UPPER_LIMIT")]
        public double? StorageUpperLimit { get; set; }
        /// <summary>
        /// 入库下限 
        ///</summary>
        [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
        public double? StorageLowerLimit { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
        [SugarColumn(ColumnName = "TRACKING_NO")]
        public string? TrackingNo { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_NO")]
        public string? BatchNo { get; set; }
        /// <summary>
        /// BOM版次 
        ///</summary>
        [SugarColumn(ColumnName = "BOM_VERSION")]
        public string? BomVersion { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_NO")]
        public string? SalesOrderNo { get; set; }
        /// <summary>
        /// 销售订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "SALES_ORDER_LINE_NO")]
        public string? SalesOrderLineNo { get; set; }
        /// <summary>
        /// 生成方式 
        ///</summary>
        [SugarColumn(ColumnName = "GENERATION_METHOD")]
        public string? GenerationMethod { get; set; }
        /// <summary>
        /// ERP生产订单ID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_ID")]
        public string? ErpProductionOrderId { get; set; }
        /// <summary>
        /// ERP生产订单序号 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_LINE_NO")]
        public string? ErpProductionOrderLineNo { get; set; }
        /// <summary>
        /// ERP生产订单单号 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ORDER_NO")]
        public string? ErpProductionOrderNo { get; set; }
        /// <summary>
        /// 源单类型 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_TYPE")]
        public string? SourceOrderType { get; set; }
        /// <summary>
        /// 源单编号 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_NO")]
        public string? SourceOrderNo { get; set; }
        /// <summary>
        /// 源单分录行号 
        ///</summary>
        [SugarColumn(ColumnName = "SOURCE_ORDER_ENTRY_NO")]
        public string? SourceOrderEntryNo { get; set; }
        /// <summary>
        /// 需求单据号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_ORDER_NO")]
        public string? DemandOrderNo { get; set; }
        /// <summary>
        /// 需求单据行号 
        ///</summary>
        [SugarColumn(ColumnName = "DEMAND_ORDER_LINE_NO")]
        public string? DemandOrderLineNo { get; set; }
        /// <summary>
        /// 结案人 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSING_PERSON")]
        public string? ClosingPerson { get; set; }
        /// <summary>
        /// 结案类型 
        ///</summary>
        [SugarColumn(ColumnName = "CLOSING_TYPE")]
        public string? ClosingType { get; set; }
        /// <summary>
        /// 源拆分订单编号 
        ///</summary>
        [SugarColumn(ColumnName = "SPLIT_ORDER_NO")]
        public string? SplitOrderNo { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_ID")]
        public string? ErpId { get; set; }
        /// <summary>
        /// ERP生产订单分录内码 
        ///</summary>
        [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
        public string? ErpProductionEntryCode { get; set; }
        /// <summary>
        /// 采购订单 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASEORDERNO")]
        public string? Purchaseorderno { get; set; }
        /// <summary>
        /// 采购订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "PURCHASEORDERENTRYSEQ")]
        public long? Purchaseorderentryseq { get; set; }
        /// <summary>
        /// 标准点数 
        ///</summary>
        [SugarColumn(ColumnName = "STANDARDPOINTS")]
        public decimal? Standardpoints { get; set; }
        /// <summary>
        /// 计价点数 
        ///</summary>
        [SugarColumn(ColumnName = "PRICINGPOINTS")]
        public decimal? Pricingpoints { get; set; }
        /// <summary>
        /// 入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "STOCKINQTY")]
        public decimal? Stockinqty { get; set; }
        /// <summary>
        /// 未入库数量 
        ///</summary>
        [SugarColumn(ColumnName = "NOSTOCKINQTY")]
        public double? Nostockinqty { get; set; }
        /// <summary>
        /// 入库货主 
        ///</summary>
        [SugarColumn(ColumnName = "STOCKOWNER")]
        public string? Stockowner { get; set; }
        /// <summary>
        /// 分钟产能 
        ///</summary>
        [SugarColumn(ColumnName = "MI_CN")]
        public decimal? MiCn { get; set; }
        /// <summary>
        /// 结案标识 
        ///</summary>
        [SugarColumn(ColumnName = "JA_BS")]
        public decimal? JaBs { get; set; }
        /// <summary>
        /// 产品类型 
        ///</summary>
        [SugarColumn(ColumnName = "FPRODUCTTYPE")]
        public string? FProductType { get; set; }
        /// <summary>
        /// 下达日期 
        ///</summary>
        [SugarColumn(ColumnName = "FCONVEYDATE")]
        public string? Fconveydate { get; set; }
        /// <summary>
        /// 需求优先级 
        ///</summary>
        [SugarColumn(ColumnName = "FPRIORITY")]
        public string? Fpriority { get; set; }
        /// <summary>
        /// 需求来源 
        ///</summary>
        [SugarColumn(ColumnName = "FREQSRC")]
        public string? Freqsrc { get; set; }
        /// <summary>
        /// 强制结案原因 
        ///</summary>
        [SugarColumn(ColumnName = "FCLOSEREASON")]
        public string? Fclosereason { get; set; }
        /// <summary>
        /// 源拆分订单编号 
        ///</summary>
        [SugarColumn(ColumnName = "FSRCSPLITBILLNO")]
        public string? Fsrcsplitbillno { get; set; }
        /// <summary>
        /// 源拆分订单行号 
        ///</summary>
        [SugarColumn(ColumnName = "FSRCSPLITSEQ")]
        public string? Fsrcsplitseq { get; set; }
        /// <summary>
        /// 入库组织 
        ///</summary>
        [SugarColumn(ColumnName = "FSTOCKINORGID")]
        public string? Fstockinorgid { get; set; }
        /// <summary>
        /// 采购组织 
        ///</summary>
        [SugarColumn(ColumnName = "FPURORGID")]
        public string? Fpurorgid { get; set; }
        /// <summary>
        /// 生产订单状态 
        ///</summary>
        [SugarColumn(ColumnName = "TEXTA")]
        public string? Texta { get; set; }
        /// <summary>
        /// 用料清单状态 
        ///</summary>
        [SugarColumn(ColumnName = "TEXTB")]
        public string? Textb { get; set; }
    }
}