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