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? 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 = "SUPP_NO")]
|
public string? SUPPLIER { get; set; }
|
}
|
}
|
