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 double? 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 double? Numerator { get; set; }

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