using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 生产订单表(委外)子表
|
/// </summary>
|
[SugarTable("PRODUCTION_ORDER_SUB")]
|
public class ProductionOrderSub
|
{
|
/// <summary>
|
/// SEQ_ORDER
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ORDER",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 工单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_ORDER_NO")]
|
public string? WorkOrderNo { get; set; }
|
|
/// <summary>
|
/// 序号
|
/// </summary>
|
[SugarColumn(ColumnName = "SEQUENCE_NO")]
|
public long? SequenceNo { get; set; }
|
|
/// <summary>
|
/// 材料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_CODE")]
|
public string? MaterialCode { get; set; }
|
|
/// <summary>
|
/// 需领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "REQUIRED_QTY")]
|
public decimal? RequiredQty { get; set; }
|
|
/// <summary>
|
/// 已领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUED_QTY")]
|
public decimal? IssuedQty { get; set; }
|
|
/// <summary>
|
/// 位置号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOCATION_NO")]
|
public string? LocationNo { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_ORG")]
|
public string? SupplyingOrg { get; set; }
|
|
/// <summary>
|
/// 发料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_ORG")]
|
public string? IssuingOrg { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_OWNER")]
|
public string? StockOwner { 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>
|
/// 仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "WAREHOUSE")]
|
public string? Warehouse { get; set; }
|
|
/// <summary>
|
/// 发料方式
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_METHOD")]
|
public string? IssuingMethod { get; set; }
|
|
/// <summary>
|
/// 工艺
|
/// </summary>
|
[SugarColumn(ColumnName = "PROCESS")]
|
public string? Process { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT")]
|
public string? Unit { get; set; }
|
|
/// <summary>
|
/// 供应类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_TYPE")]
|
public string? SupplyingType { get; set; }
|
|
/// <summary>
|
/// 组成用量
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPOSITION_QTY")]
|
public decimal? CompositionQty { get; set; }
|
|
/// <summary>
|
/// 是否替料
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_SUBSTITUTE")]
|
public string? IsSubstitute { get; set; }
|
|
/// <summary>
|
/// 分子
|
/// </summary>
|
[SugarColumn(ColumnName = "NUMERATOR")]
|
public long? Numerator { get; set; }
|
|
/// <summary>
|
/// 分母
|
/// </summary>
|
[SugarColumn(ColumnName = "DENOMINATOR")]
|
public long? Denominator { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public string? ErpId { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_HEADER_ID")]
|
public string? ErpHeaderId { get; set; }
|
|
/// <summary>
|
/// 固定损耗
|
/// </summary>
|
[SugarColumn(ColumnName = "FIXED_LOSS")]
|
public decimal? FixedLoss { get; set; }
|
|
/// <summary>
|
/// 变动损耗率%
|
/// </summary>
|
[SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
|
public string? VariableLossRate { get; set; }
|
|
/// <summary>
|
/// 子项类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
|
public string? SubItemType { get; set; }
|
|
/// <summary>
|
/// 子项单位
|
/// </summary>
|
[SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
|
public string? SubItemUnit { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER_NO")]
|
public string? SalesOrderNo { get; set; }
|
|
/// <summary>
|
/// 项次号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 发料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_ORG_2")]
|
public string? IssuingOrg2 { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_TYPE")]
|
public string? OwnerType { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER")]
|
public string? Owner { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
|
public string? SupplyingOrg2 { get; set; }
|
}
|
