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; }
|
}
|
