using SqlSugar;

namespace NewPdaSqlServer.entity;

[SugarTable("V_CGTL")]
public class CgtlView
{
    /// <summary>
    ///     采购单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_NO")]
    public string? WorkNo { get; set; }


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


    /// <summary>
    ///     物料编号
    /// </summary>
    [SugarColumn(ColumnName = "item_no")]
    public string? ItemNo { get; set; }


    /// <summary>
    ///     物料名称
    /// </summary>
    [SugarColumn(ColumnName = "item_name")]
    public string? ItemName { get; set; }


    /// <summary>
    ///     规格型号
    /// </summary>
    [SugarColumn(ColumnName = "item_model")]
    public string? ItemModel { get; set; }


    /// <summary>
    ///     入库数量
    /// </summary>
    [SugarColumn(ColumnName = "RK_QTY")]
    public decimal? RkQty { get; set; }


    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }


    /// <summary>
    ///     供应商编号
    /// </summary>
    [SugarColumn(ColumnName = "supp_no")]
    public string? SuppNo { get; set; }


    /// <summary>
    ///     已退料数量
    /// </summary>
    [SugarColumn(ColumnName = "YTL_QTY")]
    public decimal? YtlQty { get; set; }


    /// <summary>
    ///     可退数量
    /// </summary>
    [SugarColumn(ColumnName = "KT_QTY")]
    public decimal? KtQty { get; set; }


    /// <summary>
    ///     到货单号
    /// </summary>
    [SugarColumn(ColumnName = "PBILL_NO")]
    public string? PBillNo { get; set; }


    /// <summary>
    ///     类型（默认为 0）
    /// </summary>
    [SugarColumn(ColumnName = "F_TYPE")]
    public int FType { get; set; } = 0;


    /// <summary>
    ///     采购单内码
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public string? EbelnK3Id { get; set; }


    /// <summary>
    ///     采购行内码
    /// </summary>
    [SugarColumn(ColumnName = "LINE_K3ID")]
    public string? LineK3Id { get; set; }


    /// <summary>
    ///     入库单号
    /// </summary>
    [SugarColumn(ColumnName = "RK_NO")]
    public string? RkNo { get; set; }


    /// <summary>
    ///     入库日期，格式为yyyy-MM-dd
    /// </summary>
    [SugarColumn(ColumnName = "RK_DATE")]
    public string? RkDate { get; set; }


    /// <summary>
    ///     入库单行内码
    /// </summary>
    [SugarColumn(ColumnName = "RK_LINE")]
    public string? RkLine { get; set; }


    /// <summary>
    ///     物料内码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public string? ItemId { get; set; }

    /// <summary>
    ///     供应商id
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_ID")]
    public string? SuppId { get; set; }
}