using SqlSugar;
|
|
namespace MES.Service.Models;
|
|
/// <summary>
|
/// 送货通知单据明细表
|
/// </summary>
|
[SugarTable("DELIVERY_NOTICE_DETAIL")]
|
public class DeliveryNoticeDetail
|
{
|
/// <summary>
|
/// 主键Guid（SEQ_XKY）
|
/// </summary>
|
[SugarColumn(ColumnName = "id")]
|
public string 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; }
|
}
|
