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; }
}