using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 销售发货通知单明细表
    ///</summary>
    [SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
    public class SalesDeliveryNoticeDetail
    {
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_DELIVERY_NOTICE_DETAIL", IsPrimaryKey = true)]
         public decimal? Id { get; set; }
        /// <summary>
        /// 销售订单号 
        ///</summary>
         [SugarColumn(ColumnName="SALES_ORDER_ID"    )]
         public string SalesOrderId { get; set; }
        /// <summary>
        /// 物料编码 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_ID"    )]
         public string MaterialId { get; set; }
        /// <summary>
        /// 物料名称 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_NAME"    )]
         public string MaterialName { get; set; }
        /// <summary>
        /// 物料规格 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_SPECIFICATION"    )]
         public string MaterialSpecification { get; set; }
        /// <summary>
        /// 销售单位 
        ///</summary>
         [SugarColumn(ColumnName="SALES_UNIT_ID"    )]
         public string SalesUnitId { get; set; }
        /// <summary>
        /// 销售数量 
        ///</summary>
         [SugarColumn(ColumnName="SALES_QUANTITY"    )]
         public decimal? SalesQuantity { get; set; }
        /// <summary>
        /// 是否赠品 
        ///</summary>
         [SugarColumn(ColumnName="IS_FREE"    )]
         public string IsFree { get; set; }
        /// <summary>
        /// 要货日期 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_DATE"    )]
         public DateTime? DeliveryDate { get; set; }
        /// <summary>
        /// 出货仓库 
        ///</summary>
         [SugarColumn(ColumnName="WAREHOUSE"    )]
         public string Warehouse { get; set; }
        /// <summary>
        /// 计划跟踪号 
        ///</summary>
         [SugarColumn(ColumnName="PLAN_TRACKING_NUMBER"    )]
         public string PlanTrackingNumber { get; set; }
        /// <summary>
        /// 批号 
        ///</summary>
         [SugarColumn(ColumnName="LOT_NUMBER"    )]
         public string LotNumber { get; set; }
        /// <summary>
        /// 源单编号 
        ///</summary>
         [SugarColumn(ColumnName="SRC_BILL_NO"    )]
         public string SrcBillNo { get; set; }
        /// <summary>
        /// 计价数量 
        ///</summary>
         [SugarColumn(ColumnName="PRICE_QTY"    )]
         public decimal? PriceQty { get; set; }
        /// <summary>
        /// 货主 
        ///</summary>
         [SugarColumn(ColumnName="OWNER_ID"    )]
         public string OwnerId { get; set; }
        /// <summary>
        /// 库存单位 
        ///</summary>
         [SugarColumn(ColumnName="INVENTORY_UNIT"    )]
         public string InventoryUnit { get; set; }
        /// <summary>
        /// 库存数量 
        ///</summary>
         [SugarColumn(ColumnName="INVENTORY_QUANTITY"    )]
         public decimal? InventoryQuantity { get; set; }
        /// <summary>
        /// 物料类别 
        ///</summary>
         [SugarColumn(ColumnName="MATERIAL_CATEGORY"    )]
         public string MaterialCategory { get; set; }
        /// <summary>
        /// 计划发货日期 
        ///</summary>
         [SugarColumn(ColumnName="PLAN_DELIVERY_DATE"    )]
         public DateTime? PlanDeliveryDate { get; set; }
        /// <summary>
        /// 超发控制单位 
        ///</summary>
         [SugarColumn(ColumnName="OUT_LMT_UNIT"    )]
         public string OutLmtUnit { get; set; }
        /// <summary>
        /// 出库上限 
        ///</summary>
         [SugarColumn(ColumnName="OUT_MAX_QTY"    )]
         public decimal? OutMaxQty { get; set; }
        /// <summary>
        /// 出库下限 
        ///</summary>
         [SugarColumn(ColumnName="OUT_MIN_QTY"    )]
         public decimal? OutMinQty { get; set; }
        /// <summary>
        /// 交货地点 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERY_LOC"    )]
         public string DeliveryLoc { get; set; }
        /// <summary>
        /// 交货地址 
        ///</summary>
         [SugarColumn(ColumnName="DELIVERYL_ADDRESS"    )]
         public string DeliverylAddress { get; set; }
        /// <summary>
        /// 源单单号 
        ///</summary>
         [SugarColumn(ColumnName="SOURCE_BILL_NO"    )]
         public string SourceBillNo { get; set; }
        /// <summary>
        /// 订单单号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_BILL_NO"    )]
         public string OrderBillNo { get; set; }
        /// <summary>
        /// 终止状态 
        ///</summary>
         [SugarColumn(ColumnName="TERMINATION_STATUS"    )]
         public string TerminationStatus { get; set; }
        /// <summary>
        /// 终止日期 
        ///</summary>
         [SugarColumn(ColumnName="TERMINATION_DATE"    )]
         public DateTime? TerminationDate { get; set; }
        /// <summary>
        /// 累计出库数量 
        ///</summary>
         [SugarColumn(ColumnName="SUM_OUT_QTY"    )]
         public decimal? SumOutQty { get; set; }
        /// <summary>
        /// 未出库数量 
        ///</summary>
         [SugarColumn(ColumnName="REMAIN_OUT_QTY"    )]
         public decimal? RemainOutQty { get; set; }
        /// <summary>
        /// ERP行ID 
        ///</summary>
         [SugarColumn(ColumnName="ERP_LINE_ID"    )]
         public string ErpLineId { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
         [SugarColumn(ColumnName="ERP_HEAD_ID"    )]
         public string ErpHeadId { get; set; }
        /// <summary>
        /// ERP头ID 
        ///</summary>
        //[SugarColumn(ColumnName = "f_UNW_Base_GDY")]
        //public string GDY { get; set; }
        ///// <summary>
        ///// 备注
        /////</summary>
        //[SugarColumn(ColumnName = "FEntrynote")]
        //public string NOTE { get; set; }
        /// <summary>
        /// 要货日期
        /// </summary>
        [SugarColumn(ColumnName = "FDELIVERYDATE", IsNullable = true)]
        public string? FDeliveryDate { get; set; }

        /// <summary>
        /// 客户物料编码1
        /// </summary>
        [SugarColumn(ColumnName = "FMAPID", IsNullable = true)]
        public string? FMapId { get; set; }

        /// <summary>
        /// 客户物料名称
        /// </summary>
        [SugarColumn(ColumnName = "FMAPNAME", IsNullable = true)]
        public string? FMapName { get; set; }

        /// <summary>
        /// 客户料号2
        /// </summary>
        [SugarColumn(ColumnName = "FMAPID2", IsNullable = true)]
        public string? FMapId2 { get; set; }

        /// <summary>
        /// 项目
        /// </summary>
        [SugarColumn(ColumnName = "FPROJECT", IsNullable = true)]
        public string? FProject { get; set; }

        /// <summary>
        /// 存储地点
        /// </summary>
        [SugarColumn(ColumnName = "FSTORAGELOCATION", IsNullable = true)]
        public string? FStorageLocation { get; set; }

        /// <summary>
        /// 免费品类型
        /// </summary>
        [SugarColumn(ColumnName = "FFREEITEMTYPE", IsNullable = true)]
        public string? FFreeItemType { get; set; }

        /// <summary>
        /// 表体备注
        /// </summary>
        [SugarColumn(ColumnName = "FBODYNOTE", IsNullable = true)]
        public string? FBodyNote { get; set; }

        /// <summary>
        /// 库存可用量
        /// </summary>
        [SugarColumn(ColumnName = "FAVAILABLESTOCK", IsNullable = true)]
        public decimal? FAvailableStock { get; set; }

        /// <summary>
        /// 查询库存时间
        /// </summary>
        [SugarColumn(ColumnName = "FINVENTORYQUERYTIME", IsNullable = true)]
        public string? FInventoryQueryTime { get; set; }

        /// <summary>
        /// 行状态
        /// </summary>
        [SugarColumn(ColumnName = "FLINESTATUS", IsNullable = true)]
        public string? FLineStatus { get; set; }

        /// <summary>
        /// 收货地址全称
        /// </summary>
        [SugarColumn(ColumnName = "FRECEIVEADDRESSFULL", IsNullable = true)]
        public string? FReceiveAddressFull { get; set; }

        /// <summary>
        /// 收货联系人
        /// </summary>
        [SugarColumn(ColumnName = "FRECEIVERCONTACT", IsNullable = true)]
        public string? FReceiverContact { get; set; }

        /// <summary>
        /// 可退换
        /// </summary>
        [SugarColumn(ColumnName = "FRETURNEXCHANGEALLOWED", IsNullable = true)]
        public string? FReturnExchangeAllowed { get; set; }

        /// <summary>
        /// 委外加工件数量
        /// </summary>
        [SugarColumn(ColumnName = "FOUTSOURCEDPROCESSQTY", IsNullable = true)]
        public decimal? FOutsourcedProcessQty { get; set; }

        /// <summary>
        /// 可用日期
        /// </summary>
        [SugarColumn(ColumnName = "FAVAILABLEDATE", IsNullable = true)]
        public string? FAvailableDate { get; set; }

        /// <summary>
        /// 承诺日期
        /// </summary>
        [SugarColumn(ColumnName = "FCOMMITMENTDATE", IsNullable = true)]
        public string? FCommitmentDate { get; set; }

        /// <summary>
        /// 客户确认出货日
        /// </summary>
        [SugarColumn(ColumnName = "FCUSTOMERCONFIRMSHIPDATE", IsNullable = true)]
        public string? FCustomerConfirmShipDate { get; set; }

        /// <summary>
        /// 计划组织
        /// </summary>
        [SugarColumn(ColumnName = "FPLANNEDORG", IsNullable = true)]
        public string? FPlannedOrg { get; set; }

        /// <summary>
        /// 供应商直运
        /// </summary>
        [SugarColumn(ColumnName = "FVENDORDIRECTSHIP", IsNullable = true)]
        public string? FVendorDirectShip { get; set; }

        /// <summary>
        /// 供应来源
        /// </summary>
        [SugarColumn(ColumnName = "FSUPPLYSOURCE", IsNullable = true)]
        public string? FSupplySource { get; set; }

        /// <summary>
        /// 供应类型
        /// </summary>
        [SugarColumn(ColumnName = "FSUPPLYTYPE", IsNullable = true)]
        public string? FSupplyType { get; set; }

        /// <summary>
        /// 供应组织
        /// </summary>
        [SugarColumn(ColumnName = "FSUPPLYORG", IsNullable = true)]
        public string? FSupplyOrg { get; set; }

        /// <summary>
        /// 供应商
        /// </summary>
        [SugarColumn(ColumnName = "FSUPPLIER", IsNullable = true)]
        public string? FSupplier { get; set; }

        /// <summary>
        /// 出货方式
        /// </summary>
        [SugarColumn(ColumnName = "FSHIPPINGMETHOD", IsNullable = true)]
        public string? FShippingMethod { get; set; }

        /// <summary>
        /// MRP/DRP需求
        /// </summary>
        [SugarColumn(ColumnName = "FMRPDR", IsNullable = true)]
        public string? FMRPDR { get; set; }

        /// <summary>
        /// 需求分类
        /// </summary>
        [SugarColumn(ColumnName = "FDEMANDCATEGORY", IsNullable = true)]
        public string? FDemandCategory { get; set; }

        /// <summary>
        /// 库存规划
        /// </summary>
        [SugarColumn(ColumnName = "FINVENTORYPLANNING", IsNullable = true)]
        public string? FInventoryPlanning { get; set; }

        /// <summary>
        /// 行备注
        /// </summary>
        [SugarColumn(ColumnName = "FLINEREMARK", IsNullable = true)]
        public string? FLineRemark { get; set; }

        /// <summary>
        /// 来源单据类别
        /// </summary>
        [SugarColumn(ColumnName = "FSOURCEDOCCATEGORY", IsNullable = true)]
        public string? FSourceDocCategory { get; set; }

        /// <summary>
        /// 来源单号
        /// </summary>
        [SugarColumn(ColumnName = "FSOURCEDOCNO", IsNullable = true)]
        public string? FSourceDocNo { get; set; }

        /// <summary>
        /// 来源单行号
        /// </summary>
        [SugarColumn(ColumnName = "FSOURCEDOCLINENO", IsNullable = true)]
        public decimal? FSourceDocLineNo { get; set; }

        /// <summary>
        /// 行号
        /// </summary>
        [SugarColumn(ColumnName = "FLINE_NO", IsNullable = true)]
        public string? FLINE_NO { get; set; }

    }
}