using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 采购退货申请明细表（MES_CGTH_SQ_DETAIL）
|
/// </summary>
|
[SugarTable("MES_CGTH_SQ_DETAIL")]
|
public class MesCgthSqDetail
|
{
|
/// <summary>
|
/// 明细表记录唯一标识（主键）
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
/// 关联主表（MES_CGTH_SQ）的 ID
|
/// </summary>
|
[SugarColumn(ColumnName = "MID")]
|
public Guid? Mid { get; set; }
|
|
/// <summary>
|
/// 库存单据编号
|
/// </summary>
|
[SugarColumn(ColumnName = "INV_BILL_NO")]
|
public string? InvBillNo { get; set; }
|
|
/// <summary>
|
/// 库存作业行号
|
/// </summary>
|
[SugarColumn(ColumnName = "INV_WORK_LINE")]
|
public int? InvWorkLine { get; set; }
|
|
/// <summary>
|
/// 采购订单号（通常来自 ERP 系统）
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN")]
|
public string? Ebeln { get; set; }
|
|
/// <summary>
|
/// 外部系统 ID（关联其他系统记录）
|
/// </summary>
|
[SugarColumn(ColumnName = "EID")]
|
public int? Eid { get; set; }
|
|
/// <summary>
|
/// ERP 系统中的明细记录 ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public int? ErpId { get; set; }
|
|
/// <summary>
|
/// 物料 ID（关联物料主表）
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public int? ItemId { get; set; }
|
|
/// <summary>
|
/// 申请退货数量
|
/// </summary>
|
[SugarColumn(ColumnName = "SQ_NUM")]
|
public decimal? SqNum { get; set; }
|
|
/// <summary>
|
/// 已收退货数量
|
/// </summary>
|
[SugarColumn(ColumnName = "YS_NUM")]
|
public decimal? YsNum { get; set; }
|
|
/// <summary>
|
/// 明细备注信息
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string? Remark { get; set; }
|
|
/// <summary>
|
/// 明细完成标识（0/1）
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_FINISH")]
|
public bool? IsFinish { get; set; }
|
|
/// <summary>
|
/// 明细排序号
|
/// </summary>
|
[SugarColumn(ColumnName = "ORDER_NO")]
|
public int? OrderNo { get; set; }
|
|
/// <summary>
|
/// 入库明细 GUID（关联入库单明细）
|
/// </summary>
|
[SugarColumn(ColumnName = "RKMX_GUID")]
|
public Guid? RkmxGuid { get; set; }
|
|
/// <summary>
|
/// 仓库 ID（关联仓库表）
|
/// </summary>
|
[SugarColumn(ColumnName = "depot_id")]
|
public long? DepotId { get; set; }
|
|
/// <summary>
|
/// 源单单号（关联原始业务单据）
|
/// </summary>
|
[SugarColumn(ColumnName = "FSRCBillNo")]
|
public string? FsrcBillNo { get; set; }
|
|
/// <summary>
|
/// 源单类型（标识原始单据类型）
|
/// </summary>
|
[SugarColumn(ColumnName = "FSRCBillTypeId")]
|
public string? FsrcBillTypeId { get; set; }
|
|
/// <summary>
|
/// 库存单位（物料的库存计量单位）
|
/// </summary>
|
[SugarColumn(ColumnName = "FUnitID")]
|
public string? FUnitId { get; set; }
|
|
/// <summary>
|
/// 仓位（物料在仓库中的具体存储位置）
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTOCKLOCID")]
|
public string? FstockLocId { get; set; }
|
|
/// <summary>
|
/// 批号（物料生产批次编号）
|
/// </summary>
|
[SugarColumn(ColumnName = "FLot")]
|
public string? FLot { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号（跟踪物料计划）
|
/// </summary>
|
[SugarColumn(ColumnName = "FMtoNo")]
|
public string? FMtoNo { get; set; }
|
}
|
