using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     送货通知单据明细表（对应数据库：JH_MES.GS_MES.dbo.DELIVERY_NOTICE_DETAIL）
/// </summary>
[SugarTable("DELIVERY_NOTICE_DETAIL")]
public class MesDeliveryNoticeDetail
{
    /// <summary>
    ///     主键（SEQ_XKY，对应数据库 id 列）
    /// </summary>
    [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     项次号（对应数据库 line_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "line_no")]
    public string? LineNo { get; set; }

    /// <summary>
    ///     ERP采购单号（对应数据库 po_erp_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "po_erp_no")]
    public string? PoErpNo { get; set; }
    

    /// <summary>
    ///     采购单类型 1：一般采购；2：委外采购（对应数据库 purchase_type 列）
    /// </summary>
    [SugarColumn(ColumnName = "purchase_type")]
    public string? PurchaseType { get; set; }

    /// <summary>
    ///     采购单项次（对应数据库 po_line_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "po_line_no")]
    public string? PoLineNo { get; set; }

    /// <summary>
    ///     产品编码（对应数据库 product_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "product_code")]
    public string? ProductCode { get; set; }

    /// <summary>
    ///     产品名称（对应数据库 product_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "product_name")]
    public string? ProductName { get; set; }

    /// <summary>
    ///     产品规格（对应数据库 product_scale 列）
    /// </summary>
    [SugarColumn(ColumnName = "product_scale")]
    public string? ProductScale { get; set; }

    /// <summary>
    ///     出货单位编码（对应数据库 delivery_unit_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "delivery_unit_code")]
    public string? DeliveryUnitCode { get; set; }

    /// <summary>
    ///     出货单位名称（对应数据库 delivery_unit_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "delivery_unit_name")]
    public string? DeliveryUnitName { get; set; }

    /// <summary>
    ///     出货数量（对应数据库 delivery_qty 列，decimal(18,10) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "delivery_qty")]
    public decimal? DeliveryQty { get; set; }

    /// <summary>
    ///     出货计价数量（对应数据库 delivery_valuation_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "delivery_valuation_qty")]
    public string? DeliveryValuationQty { get; set; }

    /// <summary>
    ///     出货产品单价（对应数据库 price 列）
    /// </summary>
    [SugarColumn(ColumnName = "price")]
    public string? Price { get; set; }

    /// <summary>
    ///     出货产品含税单价（对应数据库 tax_price 列）
    /// </summary>
    [SugarColumn(ColumnName = "tax_price")]
    public string? TaxPrice { get; set; }

    /// <summary>
    ///     排程自定义项的值（对应数据库 sch_dynamic_value 列）
    /// </summary>
    [SugarColumn(ColumnName = "sch_dynamic_value")]
    public string? SchDynamicValue { get; set; }

    /// <summary>
    ///     排程批次号（对应数据库 schedule_batch_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "schedule_batch_no")]
    public string? ScheduleBatchNo { get; set; }

    /// <summary>
    ///     排程单号（对应数据库 schedule_order_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "schedule_order_no")]
    public string? ScheduleOrderNo { get; set; }

    /// <summary>
    ///     对应排程ItemDetail的主键列（对应数据库 schedule_detail_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "schedule_detail_no")]
    public string? ScheduleDetailNo { get; set; }

    /// <summary>
    ///     是否急料 0:否 ; 1：是（对应数据库 urgent_flag 列）
    /// </summary>
    [SugarColumn(ColumnName = "urgent_flag")]
    public string? UrgentFlag { get; set; }

    /// <summary>
    ///     原始单据类型1：订单；2：排程; 3:按退货 4:按备品（对应数据库 src_bill_type 列）
    /// </summary>
    [SugarColumn(ColumnName = "src_bill_type")]
    public string? SrcBillType { get; set; }

    /// <summary>
    ///     采购项次的采购说明信息（对应数据库 purchase_desc 列）
    /// </summary>
    [SugarColumn(ColumnName = "purchase_desc")]
    public string? PurchaseDesc { get; set; }

    /// <summary>
    ///     单据备注，srcBillType=1 对应采购订单单身的备注; srcBillType=2 对应排程项次的备注（对应数据库 src_order_line_remark 列）
    /// </summary>
    [SugarColumn(ColumnName = "src_order_line_remark")]
    public string? SrcOrderLineRemark { get; set; }

    /// <summary>
    ///     状态（1:待签收；2:签收中；3: 已完成；）（对应数据库 status 列）
    /// </summary>
    [SugarColumn(ColumnName = "status")]
    public string? Status { get; set; }

    /// <summary>
    ///     收货状态（0-未收货;1-部分收货;2-全部收货）（对应数据库 receive_status 列）
    /// </summary>
    [SugarColumn(ColumnName = "receive_status")]
    public string? ReceiveStatus { get; set; }

    /// <summary>
    ///     整单毛重（对应数据库 gross_weight 列）
    /// </summary>
    [SugarColumn(ColumnName = "gross_weight")]
    public string? GrossWeight { get; set; }

    /// <summary>
    ///     整单净重（对应数据库 net_weight 列）
    /// </summary>
    [SugarColumn(ColumnName = "net_weight")]
    public string? NetWeight { get; set; }

    /// <summary>
    ///     重量单位编码（对应数据库 unit_weight_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "unit_weight_code")]
    public string? UnitWeightCode { get; set; }

    /// <summary>
    ///     重量单位名称（对应数据库 unit_weight_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "unit_weight_name")]
    public string? UnitWeightName { get; set; }

    /// <summary>
    ///     包装数（对应数据库 packing_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "packing_qty")]
    public string? PackingQty { get; set; }

    /// <summary>
    ///     品牌名称（对应数据库 brand_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "brand_name")]
    public string? BrandName { get; set; }

    /// <summary>
    ///     其他扩展字段（对应数据库 other_extend 列）
    /// </summary>
    [SugarColumn(ColumnName = "other_extend")]
    public string? OtherExtend { get; set; }

    /// <summary>
    ///     原产国编码（对应数据库 original_country_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "original_country_code")]
    public string? OriginalCountryCode { get; set; }

    /// <summary>
    ///     原产国名称（对应数据库 original_country_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "original_country_name")]
    public string? OriginalCountryName { get; set; }

    /// <summary>
    ///     备注（对应数据库 remark 列）
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string? Remark { get; set; }

    /// <summary>
    ///     扩展字段1（对应数据库 extend_n01 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n01")]
    public string? ExtendN01 { get; set; }

    /// <summary>
    ///     扩展字段2（对应数据库 extend_n02 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n02")]
    public string? ExtendN02 { get; set; }

    /// <summary>
    ///     扩展字段3（对应数据库 extend_n03 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n03")]
    public string? ExtendN03 { get; set; }

    /// <summary>
    ///     扩展字段4（对应数据库 extend_n04 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n04")]
    public string? ExtendN04 { get; set; }

    /// <summary>
    ///     扩展字段5（对应数据库 extend_n05 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n05")]
    public string? ExtendN05 { get; set; }

    /// <summary>
    ///     扩展字段6（对应数据库 extend_n06 列）
    /// </summary>
    [SugarColumn(ColumnName = "extend_n06")]
    public string? ExtendN06 { get; set; }

    /// <summary>
    ///     库存地点编码（对应数据库 store_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "store_code")]
    public string? StoreCode { get; set; }

    /// <summary>
    ///     库存地点名称（对应数据库 store_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "store_name")]
    public string? StoreName { get; set; }

    /// <summary>
    ///     已签收数量（对应数据库 verify_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "verify_qty")]
    public string? VerifyQty { get; set; }

    /// <summary>
    ///     可入库数量（对应数据库 allow_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "allow_qty")]
    public string? AllowQty { get; set; }

    /// <summary>
    ///     让步接收数量（对应数据库 compromise_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "compromise_qty")]
    public string? CompromiseQty { get; set; }

    /// <summary>
    ///     拒收数量（对应数据库 refused_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "refused_qty")]
    public string? RefusedQty { get; set; }

    /// <summary>
    ///     退货单ERP编号（对应数据库 rto_erp_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "rto_erp_no")]
    public string? RtoErpNo { get; set; }

    /// <summary>
    ///     退货单项次（对应数据库 rto_line_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "rto_line_no")]
    public string? RtoLineNo { get; set; }

    /// <summary>
    ///     产品长度（对应数据库 prod_length 列）
    /// </summary>
    [SugarColumn(ColumnName = "prod_length")]
    public string? ProdLength { get; set; }

    /// <summary>
    ///     产品宽度（对应数据库 prod_width 列）
    /// </summary>
    [SugarColumn(ColumnName = "prod_width")]
    public string? ProdWidth { get; set; }

    /// <summary>
    ///     产品高度（对应数据库 prod_height 列）
    /// </summary>
    [SugarColumn(ColumnName = "prod_height")]
    public string? ProdHeight { get; set; }

    /// <summary>
    ///     采购员姓名（对应数据库 buyer_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "buyer_name")]
    public string? BuyerName { get; set; }

    /// <summary>
    ///     预计交期（对应数据库 expected_date 列）
    /// </summary>
    [SugarColumn(ColumnName = "expected_date")]
    public string? ExpectedDate { get; set; }

    /// <summary>
    ///     回复交期（对应数据库 answer_date 列）
    /// </summary>
    [SugarColumn(ColumnName = "answer_date")]
    public string? AnswerDate { get; set; }

    /// <summary>
    ///     币种编码（对应数据库 currency_code 列）
    /// </summary>
    [SugarColumn(ColumnName = "currency_code")]
    public string? CurrencyCode { get; set; }

    /// <summary>
    ///     币种名称（对应数据库 currency_name 列）
    /// </summary>
    [SugarColumn(ColumnName = "currency_name")]
    public string? CurrencyName { get; set; }

    /// <summary>
    ///     发送签收状态（对应数据库 send_verify_status 列）
    /// </summary>
    [SugarColumn(ColumnName = "send_verify_status")]
    public string? SendVerifyStatus { get; set; }

    /// <summary>
    ///     结果标识（对应数据库 result_flag 列）
    /// </summary>
    [SugarColumn(ColumnName = "result_flag")]
    public string? ResultFlag { get; set; }

    /// <summary>
    ///     申请出货数量（对应数据库 apply_delivery_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "apply_delivery_qty")]
    public string? ApplyDeliveryQty { get; set; }

    /// <summary>
    ///     申请出货计价数量（对应数据库 apply_delivery_valuation_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "apply_delivery_valuation_qty")]
    public string? ApplyDeliveryValuationQty { get; set; }

    /// <summary>
    ///     批号（对应数据库 batch_number 列）
    /// </summary>
    [SugarColumn(ColumnName = "batch_number")]
    public string? BatchNumber { get; set; }

    /// <summary>
    ///     已收货数量（对应数据库 receive_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "receive_qty")]
    public string? ReceiveQty { get; set; }

    /// <summary>
    ///     已入库数量（对应数据库 storage_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "storage_qty")]
    public string? StorageQty { get; set; }

    /// <summary>
    ///     退货数量（对应数据库 return_qty 列）
    /// </summary>
    [SugarColumn(ColumnName = "return_qty")]
    public string? ReturnQty { get; set; }

    /// <summary>
    ///     优先检验:0-正常 1-优先 2-紧急（对应数据库 first_check 列）
    /// </summary>
    [SugarColumn(ColumnName = "first_check")]
    public string? FirstCheck { get; set; }

    /// <summary>
    ///     采购单项次显示用（对应数据库 po_line_no_show 列）
    /// </summary>
    [SugarColumn(ColumnName = "po_line_no_show")]
    public string? PoLineNoShow { get; set; }

    /// <summary>
    ///     多语言备注（对应数据库 remarks 列）
    /// </summary>
    [SugarColumn(ColumnName = "remarks")]
    public string? Remarks { get; set; }

    /// <summary>
    ///     创建时间（对应数据库 create_time 列）
    /// </summary>
    [SugarColumn(ColumnName = "create_time")]
    public string? CreateTime { get; set; }

    /// <summary>
    ///     更新时间（对应数据库 update_time 列）
    /// </summary>
    [SugarColumn(ColumnName = "update_time")]
    public string? UpdateTime { get; set; }

    /// <summary>
    ///     关联主表ID（对应数据库 pid 列，关联送货通知单主表DELIVERY_NOTICE的id）
    /// </summary>
    [SugarColumn(ColumnName = "pid")]
    public Guid? Pid { get; set; }

    /// <summary>
    ///     排程项次号（对应数据库 plan_line_no 列）
    /// </summary>
    [SugarColumn(ColumnName = "plan_line_no")]
    public string? PlanLineNo { get; set; }

    /// <summary>
    ///     送货单号（对应数据库 delivery_no 列，关联主表DELIVERY_NOTICE的delivery_no）
    /// </summary>
    [SugarColumn(ColumnName = "delivery_no")]
    public string? DeliveryNo { get; set; }

    /// <summary>
    ///     同步时间（对应数据库 SYNCHRONOUS_DATE 列）
    /// </summary>
    [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")]
    public DateTime? SynchronousDate { get; set; }
    
    
    /// <summary>
    ///     采购订单数量（对应数据库 purchase_qty 列，decimal(18,10) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "purchase_qty")]
    public decimal? PurchaseQty { get; set; }

 

    /// <summary>
    ///     本次交货数量（对应数据库 include_qty 列，decimal(18,10) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "include_qty")]
    public decimal? IncludeQty { get; set; }

    /// <summary>
    ///     采购单位（内码）（对应数据库 purchase_unit 列，varchar(50) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "purchase_unit")]
    public string? PurchaseUnit { get; set; }

    /// <summary>
    ///     库存单位（内码）（对应数据库 inventory_unit 列，varchar(50) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "inventory_unit")]
    public string? InventoryUnit { get; set; }

    /// <summary>
    ///     采购单分录内码（对应数据库 erpline_id 列，varchar(50) 类型）
    /// </summary>
    [SugarColumn(ColumnName = "erpline_id")]
    public string? ErplineId { get; set; }

    /// <summary>
    ///     是否赠品（对应数据库 is_gift 列，bit 类型；0=否，1=是）
    /// </summary>
    [SugarColumn(ColumnName = "is_gift")]
    public bool? IsGift { get; set; }
    
}