AiDOPWarehouse/server/Plugins/Admin.NET.Plugin.AiDOP/MaterialWarehouse/InventoryPosting/Entity/AdoBarcodeCardTransaction.cs

using SqlSugar;

namespace Admin.NET.Plugin.AiDOP.MaterialWarehouse.InventoryPosting.Entity;

/// <summary>
/// DOP-L3 条码卡历史流水（影子, append-only）。**非旧 MissedPrintTransHist**。
/// 与 <see cref="AdoBarcodeCard"/> 经 barcode_card_id 关联。旧 MissedPrintTransHist 为 append-only 流水（无自然唯一键）。
/// 回灌幂等键 = (tenant_id, source_domain, source_rec_id)；DOP 自生成流水 source_rec_id 为 NULL 不受约束。
/// </summary>
[SugarTable("ado_barcode_card_transaction", "DOP-L3条码卡历史流水(影子,非旧MissedPrintTransHist)")]
[SugarIndex("uk_ado_bctrans_source", nameof(TenantId), OrderByType.Asc, nameof(SourceDomain), OrderByType.Asc, nameof(SourceRecId), OrderByType.Asc, IsUnique = true)]
[SugarIndex("idx_ado_bctrans_card", nameof(TenantId), OrderByType.Asc, nameof(BarcodeCardId), OrderByType.Asc)]
public class AdoBarcodeCardTransaction : AdoInvEntityBase
{
    [SugarColumn(ColumnName = "barcode_card_id", ColumnDescription = "关联条码卡 ado_barcode_card.id", IsNullable = true)]
    public long? BarcodeCardId { get; set; }

    [SugarColumn(ColumnName = "item_num", ColumnDescription = "物料号", Length = 50, IsNullable = false, DefaultValue = "")]
    public string ItemNum { get; set; }

    [SugarColumn(ColumnName = "location", ColumnDescription = "库位", Length = 30, IsNullable = false, DefaultValue = "")]
    public string Location { get; set; }

    [SugarColumn(ColumnName = "lot_serial", ColumnDescription = "批次/序列号(空落空串)", Length = 50, IsNullable = false, DefaultValue = "")]
    public string LotSerial { get; set; }

    [SugarColumn(ColumnName = "qty", ColumnDescription = "数量", Length = 18, DecimalDigits = 5, DefaultValue = "0")]
    public decimal Qty { get; set; }

    [SugarColumn(ColumnName = "status", ColumnDescription = "状态", Length = 10, IsNullable = true)]
    public string Status { get; set; }

    [SugarColumn(ColumnName = "trans_type", ColumnDescription = "事务类型", Length = 50, IsNullable = false, DefaultValue = "")]
    public string TransType { get; set; }

    [SugarColumn(ColumnName = "remark", ColumnDescription = "备注", Length = 500, IsNullable = true)]
    public string Remark { get; set; }

    [SugarColumn(ColumnName = "posting_id", ColumnDescription = "关联过账头 ado_iqc_inventory_posting.id", IsNullable = true)]
    public long? PostingId { get; set; }

    [SugarColumn(ColumnName = "source_domain", ColumnDescription = "回灌来源Domain", Length = 20, IsNullable = true)]
    public string SourceDomain { get; set; }

    [SugarColumn(ColumnName = "source_rec_id", ColumnDescription = "回灌来源RecID", IsNullable = true)]
    public long? SourceRecId { get; set; }
}