1

wbc

2025-05-29 1c752c710464609d137012d6c9ca717a942cb6e9

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 销售退货通知单子表
    ///</summary>
    [SugarTable("MES_RETURNWARE_DETAILS")]
    public class MesReturnwareDetails
    {
        /// <summary>
        /// 主键ID 
        ///</summary>
         [SugarColumn(ColumnName="ID" , OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true   )]
         public decimal Id { get; set; }
        /// <summary>
        /// 主表ID 
        ///</summary>
         [SugarColumn(ColumnName="PID")]
         public decimal? Pid { get; set; }
        /// <summary>
        /// 物料编码(品号) 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NO"    )]
         public string ItemNo { get; set; }
        /// <summary>
        /// 物料名称(品名) 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NAME"    )]
         public string ItemName { get; set; }
        /// <summary>
        /// 规格型号 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_MODEL"    )]
         public string ItemModel { get; set; }
        /// <summary>
        /// 类型 
        ///</summary>
         [SugarColumn(ColumnName="TYPE"    )]
         public string Type { get; set; }
        /// <summary>
        /// 数量 
        ///</summary>
        [SugarColumn(ColumnName = "QUANTITY")]
        public decimal? Quantity { get; set; }
        /// <summary>
        /// 退货仓库 
        ///</summary>
        [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 销售退货单别 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_TYPE"    )]
         public string? ReturnType { get; set; }
        /// <summary>
        /// 销售退货单号 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_NO"    )]
         public string ReturnNo { get; set; }
        /// <summary>
        /// 销售退货序号 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_ORDER"    )]
         public string ReturnOrder { get; set; }
        /// <summary>
        /// 订单单别 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_TYPE"    )]
         public string? OrderType { get; set; }
        /// <summary>
        /// 订单序号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_NUMBER"    )]
         public string OrderNumber { get; set; }
        /// <summary>
        /// 订单单号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_NO"    )]
         public string OrderNo { get; set; }
 
        /// <summary>
        /// 赠品量
        ///</summary>
        [SugarColumn(ColumnName = "ACTUAL_QUANTITY")]
        public decimal? ActualQuantity { get; set; }
 
        /// <summary>
        /// 客户品号 
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_NO")]
        public string? CustItemNo { get; set; }
 
        /// <summary>
        /// 客户品名
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_NAME")]
        public string? CustItemName { get; set; }
 
        /// <summary>
        /// 客户规格 
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_MODEL")]
        public string? CustItemModel { get; set; }
 
        /// <summary>
        /// 客户规格 
        ///</summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }
    }
}