using SqlSugar;

namespace MES.Service.Modes
{
    /// <summary>
    /// 生产订单表(委外)
    ///</summary>
    [SugarTable("PRODUCTION_ORDER")]
    public class ProductionOrder
    {
        /// <summary>
        /// SEQ_ORDER 
        ///</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? PlanStartDate { get; set; }

        /// <summary>
        /// 预计完工时间 
        ///</summary>
        [SugarColumn(ColumnName = "ESTIMATED_END_TIME")]
        public DateTime? PlanFinishDate { 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 = "SUPP_NO")]
        public string? SUPPLIER { get; set; }
    }
}