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