using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     生产订单表(委外) 子表
/// </summary>
[SugarTable("PRODUCTION_ORDER_SUB")]
public class ProductionOrderSub
{
    /// <summary>
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     工单单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_ORDER_NO")]
    public string? WorkOrderNo { get; set; }

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "SEQUENCE_NO")]
    public int? 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 = "UNIT2")]
    public string? Unit2 { 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 decimal? Numerator { get; set; }

    /// <summary>
    ///     分母
    /// </summary>
    [SugarColumn(ColumnName = "DENOMINATOR")]
    public decimal? 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 decimal? 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; }

    /// <summary>
    ///     制程不良退料数量
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "TLNUM1")]
    public int? Tlnum1 { get; set; }

    /// <summary>
    ///     来料不良退料数量
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "TLNUM2")]
    public int? Tlnum2 { get; set; }

    /// <summary>
    ///     良品退料数量
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "TLNUM3")]
    public int? Tlnum3 { get; set; }

    /// <summary>
    ///     补料数量
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "BLNUM")]
    public int? Blnum { get; set; }

    /// <summary>
    ///     ERP生产订单分录内码
    /// </summary>
    [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
    public string? ErpProductionEntryCode { get; set; }
}