using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     生产订单表(委外)
/// </summary>
[SugarTable("PRODUCTION_ORDER")]
public class ProductionOrder
{
    /// <summary>
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { 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>
    ///     业务状态 1计划确认 2下达 3开工 4完工 5结案
    /// </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 decimal? 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 decimal? StorageUpperLimit { get; set; }

    /// <summary>
    ///     入库下限
    /// </summary>
    [SugarColumn(ColumnName = "STORAGE_LOWER_LIMIT")]
    public decimal? 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 int? 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 decimal? Nostockinqty { get; set; }

    /// <summary>
    ///     入库货主
    /// </summary>
    [SugarColumn(ColumnName = "STOCKOWNER")]
    public string? Stockowner { get; set; }

    /// <summary>
    ///     审核状态
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "AUDIT_STATUS")]
    public int? AuditStatus { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "AUDITOR")]
    public string? Auditor { get; set; }

    /// <summary>
    ///     审核时间
    /// </summary>
    [SugarColumn(ColumnName = "AUDIT_DATE")]
    public DateTime? AuditDate { get; set; }

    /// <summary>
    ///     通知备料状态
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "PREPARE_FLAG")]
    public int? PrepareFlag { get; set; }

    /// <summary>
    ///     通知备料人
    /// </summary>
    [SugarColumn(ColumnName = "PREPARER")]
    public string? Preparer { get; set; }

    /// <summary>
    ///     通知备料时间
    /// </summary>
    [SugarColumn(ColumnName = "PREPARE_DATE")]
    public DateTime? PrepareDate { get; set; }

    /// <summary>
    ///     供商编码
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }

    /// <summary>
    ///     备料完成时间
    /// </summary>
    [SugarColumn(ColumnName = "PREPARE_COMP_DATE")]
    public DateTime? PrepareCompDate { get; set; }

    /// <summary>
    ///     备料完成标识
    /// </summary>
    [SugarColumn(ColumnName = "PREPARE_COMP_FLAG")]
    public int? PrepareCompFlag { get; set; }

    /// <summary>
    ///     计划确认时间（执行日期）
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_CONFIRMATION")]
    public DateTime? PlanConfirmation { get; set; }

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

    /// <summary>
    ///     源拆分订单行号
    /// </summary>
    [SugarColumn(ColumnName = "SRC_SPLIT_SEQ")]
    public string? SrcSplitSeq { get; set; }

    /// <summary>
    ///     1，新增；2，变更
    /// </summary>
    [SugarColumn(ColumnName = "TYPEA")]
    public string? Typea { get; set; }
}