using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     送货单条码表
/// </summary>
[SugarTable("MES_DELIVERY_NOTE_DETAILS")]
public class MesDeliveryNoteDetails
{
    /// <summary>
    ///     SEQ_DELIVERY
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
        OracleSequenceName = "SEQ_DELIVERY")]
    public decimal Id { get; set; }

    /// <summary>
    ///     送货单号
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_NO")]
    public string? DeliveryNo { get; set; }

    /// <summary>
    ///     项次号
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public decimal? LineNo { get; set; }

    /// <summary>
    ///     ERP采购单号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_NO")]
    public string? ErpNo { get; set; }

    /// <summary>
    ///     采购单项次
    /// </summary>
    [SugarColumn(ColumnName = "PO_LINENO")]
    public string? PoLineNo { get; set; }

    /// <summary>
    ///     产品编号
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_CODE")]
    public string? ProductCode { get; set; }

    /// <summary>
    ///     收料单位
    /// </summary>
    [SugarColumn(ColumnName = "SL_UNIT")]
    public string? SlUnit { get; set; }

    /// <summary>
    ///     库存单位
    /// </summary>
    [SugarColumn(ColumnName = "KC_UNIT")]
    public string? KcUnit { get; set; }

    /// <summary>
    ///     创建时间
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    ///     本次应收数量
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_QTY")]
    public decimal? DeliveryQty { get; set; }

    /// <summary>
    ///     订单数量
    /// </summary>
    [SugarColumn(ColumnName = "PURCHASE_QTY")]
    public decimal? PurchaseQty { get; set; }

    /// <summary>
    ///     交货数量
    /// </summary>
    [SugarColumn(ColumnName = "INCLUDE_QTY")]
    public decimal? IncludeQty { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALE_ORDER")]
    public string? SaleOrder { get; set; }

    /// <summary>
    ///     源单单号
    /// </summary>
    [SugarColumn(ColumnName = "FSRCBILL_NO")]
    public string? Fsrcbill_no { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }

    /// <summary>
    ///     本次实收数量
    /// </summary>
    [SugarColumn(ColumnName = "REAL_QTY")]
    public decimal? RealQty { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "FMTONO")]
    public string? FMTONO { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "FLOT")]
    public string? FLOT { get; set; }

    /// <summary>
    ///     生产通知单
    /// </summary>
    [SugarColumn(ColumnName = "F_SLTZ_SCTZDA")]
    public string? F_SLTZ_SCTZDA { get; set; }

    [SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}