using SqlSugar;

namespace MES.Service.Models;

/// <summary>
/// 送货通知单据明细表
/// </summary>
[SugarTable("DELIVERY_NOTICE_DETAIL")]
public class DeliveryNoticeDetail
{
    /// <summary>
    /// 主键Guid（SEQ_XKY）
    /// </summary>
    [SugarColumn(ColumnName = "id")]
    public Guid Id { get; set; }

    /// <summary>
    /// 项次号
    /// </summary>
    [SugarColumn(ColumnName = "line_no")]
    public string LineNo { get; set; }

    /// <summary>
    /// ERP采购单号
    /// </summary>
    [SugarColumn(ColumnName = "po_erp_no")]
    public string PoErpNo { get; set; }

    /// <summary>
    /// 采购单类型 1：一般采购；2：委外采购
    /// </summary>
    [SugarColumn(ColumnName = "purchase_type")]
    public string PurchaseType { get; set; }

    /// <summary>
    /// 采购单项次
    /// </summary>
    [SugarColumn(ColumnName = "po_line_no")]
    public string PoLineNo { get; set; }

    /// <summary>
    /// 产品编码
    /// </summary>
    [SugarColumn(ColumnName = "product_code")]
    public string ProductCode { get; set; }

    /// <summary>
    /// 产品名称
    /// </summary>
    [SugarColumn(ColumnName = "product_name")]
    public string ProductName { get; set; }

    /// <summary>
    /// 产品规格
    /// </summary>
    [SugarColumn(ColumnName = "product_scale")]
    public string ProductScale { get; set; }

    /// <summary>
    /// 出货单位编码
    /// </summary>
    [SugarColumn(ColumnName = "delivery_unit_code")]
    public string DeliveryUnitCode { get; set; }

    /// <summary>
    /// 出货单位名称
    /// </summary>
    [SugarColumn(ColumnName = "delivery_unit_name")]
    public string DeliveryUnitName { get; set; }

    /// <summary>
    /// 出货数量
    /// </summary>
    [SugarColumn(ColumnName = "delivery_qty")]
    public string DeliveryQty { get; set; }

    /// <summary>
    /// 出货计价数量
    /// </summary>
    [SugarColumn(ColumnName = "delivery_valuation_qty")]
    public string DeliveryValuationQty { get; set; }

    /// <summary>
    /// 出货产品单价
    /// </summary>
    [SugarColumn(ColumnName = "price")]
    public string Price { get; set; }

    /// <summary>
    /// 出货产品含税单价
    /// </summary>
    [SugarColumn(ColumnName = "tax_price")]
    public string TaxPrice { get; set; }

    /// <summary>
    /// 排程自定义项的值
    /// </summary>
    [SugarColumn(ColumnName = "sch_dynamic_value")]
    public string SchDynamicValue { get; set; }

    /// <summary>
    /// 排程批次号
    /// </summary>
    [SugarColumn(ColumnName = "schedule_batch_no")]
    public string ScheduleBatchNo { get; set; }

    /// <summary>
    /// 排程单号
    /// </summary>
    [SugarColumn(ColumnName = "schedule_order_no")]
    public string ScheduleOrderNo { get; set; }

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

    /// <summary>
    /// 是否急料 0:否 ; 1：是
    /// </summary>
    [SugarColumn(ColumnName = "urgent_flag")]
    public string UrgentFlag { get; set; }

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

    /// <summary>
    /// 采购项次的采购说明信息
    /// </summary>
    [SugarColumn(ColumnName = "purchase_desc")]
    public string PurchaseDesc { get; set; }

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

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

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

    /// <summary>
    /// 整单毛重
    /// </summary>
    [SugarColumn(ColumnName = "gross_weight")]
    public string GrossWeight { get; set; }

    /// <summary>
    /// 整单净重
    /// </summary>
    [SugarColumn(ColumnName = "net_weight")]
    public string NetWeight { get; set; }

    /// <summary>
    /// 重量单位编码
    /// </summary>
    [SugarColumn(ColumnName = "unit_weight_code")]
    public string UnitWeightCode { get; set; }

    /// <summary>
    /// 重量单位名称
    /// </summary>
    [SugarColumn(ColumnName = "unit_weight_name")]
    public string UnitWeightName { get; set; }

    /// <summary>
    /// 包装数
    /// </summary>
    [SugarColumn(ColumnName = "packing_qty")]
    public string PackingQty { get; set; }

    /// <summary>
    /// 品牌名称
    /// </summary>
    [SugarColumn(ColumnName = "brand_name")]
    public string BrandName { get; set; }

    /// <summary>
    /// 其他扩展字段
    /// </summary>
    [SugarColumn(ColumnName = "other_extend")]
    public string OtherExtend { get; set; }

    /// <summary>
    /// 原产国编码
    /// </summary>
    [SugarColumn(ColumnName = "original_country_code")]
    public string OriginalCountryCode { get; set; }

    /// <summary>
    /// 原产国名称
    /// </summary>
    [SugarColumn(ColumnName = "original_country_name")]
    public string OriginalCountryName { get; set; }

    /// <summary>
    /// 备注
    /// </summary>
    [SugarColumn(ColumnName = "remark")]
    public string Remark { get; set; }

    /// <summary>
    /// 扩展字段1
    /// </summary>
    [SugarColumn(ColumnName = "extend_n01")]
    public string ExtendN01 { get; set; }

    /// <summary>
    /// 扩展字段2
    /// </summary>
    [SugarColumn(ColumnName = "extend_n02")]
    public string ExtendN02 { get; set; }

    /// <summary>
    /// 扩展字段3
    /// </summary>
    [SugarColumn(ColumnName = "extend_n03")]
    public string ExtendN03 { get; set; }

    /// <summary>
    /// 扩展字段4
    /// </summary>
    [SugarColumn(ColumnName = "extend_n04")]
    public string ExtendN04 { get; set; }

    /// <summary>
    /// 扩展字段5
    /// </summary>
    [SugarColumn(ColumnName = "extend_n05")]
    public string ExtendN05 { get; set; }

    /// <summary>
    /// 扩展字段6
    /// </summary>
    [SugarColumn(ColumnName = "extend_n06")]
    public string ExtendN06 { get; set; }

    /// <summary>
    /// 库存地点编码
    /// </summary>
    [SugarColumn(ColumnName = "store_code")]
    public string StoreCode { get; set; }

    /// <summary>
    /// 库存地点名称
    /// </summary>
    [SugarColumn(ColumnName = "store_name")]
    public string StoreName { get; set; }

    /// <summary>
    /// 已签收数量
    /// </summary>
    [SugarColumn(ColumnName = "verify_qty")]
    public string VerifyQty { get; set; }

    /// <summary>
    /// 可入库数量
    /// </summary>
    [SugarColumn(ColumnName = "allow_qty")]
    public string AllowQty { get; set; }

    /// <summary>
    /// 让步接收数量
    /// </summary>
    [SugarColumn(ColumnName = "compromise_qty")]
    public string CompromiseQty { get; set; }

    /// <summary>
    /// 拒收数量
    /// </summary>
    [SugarColumn(ColumnName = "refused_qty")]
    public string RefusedQty { get; set; }

    /// <summary>
    /// 退货单ERP编号
    /// </summary>
    [SugarColumn(ColumnName = "rto_erp_no")]
    public string RtoErpNo { get; set; }

    /// <summary>
    /// 退货单项次
    /// </summary>
    [SugarColumn(ColumnName = "rto_line_no")]
    public string RtoLineNo { get; set; }

    /// <summary>
    /// 产品长度
    /// </summary>
    [SugarColumn(ColumnName = "prod_length")]
    public string ProdLength { get; set; }

    /// <summary>
    /// 产品宽度
    /// </summary>
    [SugarColumn(ColumnName = "prod_width")]
    public string ProdWidth { get; set; }

    /// <summary>
    /// 产品高度
    /// </summary>
    [SugarColumn(ColumnName = "prod_height")]
    public string ProdHeight { get; set; }

    /// <summary>
    /// 采购员姓名
    /// </summary>
    [SugarColumn(ColumnName = "buyer_name")]
    public string BuyerName { get; set; }

    /// <summary>
    /// 预计交期
    /// </summary>
    [SugarColumn(ColumnName = "expected_date")]
    public string ExpectedDate { get; set; }

    /// <summary>
    /// 回复交期
    /// </summary>
    [SugarColumn(ColumnName = "answer_date")]
    public string AnswerDate { get; set; }

    /// <summary>
    /// 币种编码
    /// </summary>
    [SugarColumn(ColumnName = "currency_code")]
    public string CurrencyCode { get; set; }

    /// <summary>
    /// 币种名称
    /// </summary>
    [SugarColumn(ColumnName = "currency_name")]
    public string CurrencyName { get; set; }

    /// <summary>
    /// 发送签收状态
    /// </summary>
    [SugarColumn(ColumnName = "send_verify_status")]
    public string SendVerifyStatus { get; set; }

    /// <summary>
    /// 结果标识
    /// </summary>
    [SugarColumn(ColumnName = "result_flag")]
    public string ResultFlag { get; set; }

    /// <summary>
    /// 申请出货数量
    /// </summary>
    [SugarColumn(ColumnName = "apply_delivery_qty")]
    public string ApplyDeliveryQty { get; set; }

    /// <summary>
    /// 申请出货计价数量
    /// </summary>
    [SugarColumn(ColumnName = "apply_delivery_valuation_qty")]
    public string ApplyDeliveryValuationQty { get; set; }

    /// <summary>
    /// 批号
    /// </summary>
    [SugarColumn(ColumnName = "batch_number")]
    public string BatchNumber { get; set; }

    /// <summary>
    /// 已收货数量
    /// </summary>
    [SugarColumn(ColumnName = "receive_qty")]
    public string ReceiveQty { get; set; }

    /// <summary>
    /// 已入库数量
    /// </summary>
    [SugarColumn(ColumnName = "storage_qty")]
    public string StorageQty { get; set; }

    /// <summary>
    /// 退货数量
    /// </summary>
    [SugarColumn(ColumnName = "return_qty")]
    public string ReturnQty { get; set; }

    /// <summary>
    /// 优先检验:0-正常 1-优先 2-紧急
    /// </summary>
    [SugarColumn(ColumnName = "first_check")]
    public string FirstCheck { get; set; }

    /// <summary>
    /// 采购单项次显示用
    /// </summary>
    [SugarColumn(ColumnName = "po_line_no_show")]
    public string PoLineNoShow { get; set; }

    /// <summary>
    /// 多语言备注
    /// </summary>
    [SugarColumn(ColumnName = "remarks")]
    public string Remarks { get; set; }

    /// <summary>
    /// 创建时间
    /// </summary>
    [SugarColumn(ColumnName = "create_time")]
    public string CreateTime { get; set; }

    /// <summary>
    /// 更新时间
    /// </summary>
    [SugarColumn(ColumnName = "update_time")]
    public string UpdateTime { get; set; }

    /// <summary>
    /// 关联主表ID
    /// </summary>
    [SugarColumn(ColumnName = "pid")]
    public string Pid { get; set; }

    /// <summary>
    /// 排程项次号
    /// </summary>
    [SugarColumn(ColumnName = "plan_line_no")]
    public string PlanLineNo { get; set; }

    /// <summary>
    /// 送货单号
    /// </summary>
    [SugarColumn(ColumnName = "delivery_no")]
    public string DeliveryNo { get; set; }

    /// <summary>
    /// 同步时间
    /// </summary>
    [SugarColumn(ColumnName = "SYNCHRONOUS_DATE")]
    public DateTime? SynchronousDate { get; set; }
}