zjh
2 天以前 da3b2cfb3a34a7b1f83dcd9fc762b1d2459547dc
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
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
 
namespace MES.Service.Modes
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("DELIVERY_DETAIL")]
    public class DeliveryDetail
    {
        /// <summary>
        /// SEQ_DELIVERY_DETAIL 
        ///</summary>
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
        public decimal Id { get; set; }
 
        /// <summary>
        /// DELIVERY_MAIN的id 
        ///</summary>
        [SugarColumn(ColumnName = "PID")]
        public decimal? Pid { get; set; }
 
        /// <summary>
        /// 送货单号(主业务标识) 
        ///</summary>
        [SugarColumn(ColumnName = "ZZASN")]
        public string? Zzasn { get; set; }
 
        /// <summary>
        /// 送货单行号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZITEM_ID")]
        public string? ZzitemId { get; set; }
 
        /// <summary>
        /// 采购凭证号(PO单号) 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPO_NO")]
        public string? ZzpoNo { get; set; }
 
        /// <summary>
        /// 采购订单行项目 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPO_ITEM_ID")]
        public string? ZzpoItemId { get; set; }
 
        /// <summary>
        /// 小米退换货单号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZREQNR")]
        public string? Zzreqnr { get; set; }
 
        /// <summary>
        /// 退换货申请单行号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZREQLN")]
        public string? Zzreqln { get; set; }
 
        /// <summary>
        /// 小米内部物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "ZZPRODUCT_ID")]
        public string? ZzproductId { get; set; }
 
        /// <summary>
        /// 工厂实际使用料号 
        ///</summary>
        [SugarColumn(ColumnName = "ZZVPRODUCT_ID")]
        public string? ZzvproductId { get; set; }
 
        /// <summary>
        /// 库存单位编码 
        ///</summary>
        [SugarColumn(ColumnName = "ZZSKU")]
        public string? Zzsku { get; set; }
 
        /// <summary>
        /// 物料描述(如:手机屏幕组件) 
        ///</summary>
        [SugarColumn(ColumnName = "MAKTX")]
        public string? Maktx { get; set; }
 
        /// <summary>
        /// 产品型号(示例:Xiaomi 14 Ultra) 
        ///</summary>
        [SugarColumn(ColumnName = "MODELNUMBER")]
        public string? Modelnumber { get; set; }
 
        /// <summary>
        /// 订单需求数量 
        ///</summary>
        [SugarColumn(ColumnName = "ZZQUANTITY")]
        public string? Zzquantity { get; set; }
 
        /// <summary>
        /// 计量单位(如:个/箱) 
        ///</summary>
        [SugarColumn(ColumnName = "ZZUNIT")]
        public string? Zzunit { get; set; }
 
        /// <summary>
        /// 未完成数量(待补货量) 
        ///</summary>
        [SugarColumn(ColumnName = "ZZOPEN_QTY")]
        public string? ZzopenQty { get; set; }
 
        /// <summary>
        /// 实际收货数量 
        ///</summary>
        [SugarColumn(ColumnName = "ACT_GR_QTY")]
        public string? ActGrQty { get; set; }
 
        /// <summary>
        /// Shipment批次数量 
        ///</summary>
        [SugarColumn(ColumnName = "SHIPMENTID_NUM")]
        public string? ShipmentidNum { get; set; }
 
        /// <summary>
        /// 品牌名称(如:Xiaomi) 
        ///</summary>
        [SugarColumn(ColumnName = "BRAND")]
        public string? Brand { get; set; }
 
        /// <summary>
        /// 生产地(示例:中国深圳) 
        ///</summary>
        [SugarColumn(ColumnName = "PLACE")]
        public string? Place { get; set; }
 
        /// <summary>
        /// 品牌类型(自有/ODM/OEM) 
        ///</summary>
        [SugarColumn(ColumnName = "BRAND_TYPE")]
        public string? BrandType { get; set; }
 
        /// <summary>
        /// 物流批次唯一标识 
        ///</summary>
        [SugarColumn(ColumnName = "ZSHIPMENT_ID")]
        public string? ZshipmentId { get; set; }
 
        /// <summary>
        /// 详细配送地址(省市区街道门牌号) 
        ///</summary>
        [SugarColumn(ColumnName = "ADDRESS_DETAIL")]
        public string? AddressDetail { get; set; }
 
        /// <summary>
        /// 调出项目号(调拨来源标识) 
        ///</summary>
        [SugarColumn(ColumnName = "BEDNR")]
        public string? Bednr { get; set; }
 
        /// <summary>
        /// 调出仓类型(成品仓/原料仓) 
        ///</summary>
        [SugarColumn(ColumnName = "WARE_TYPE_FROM")]
        public string? WareTypeFrom { get; set; }
 
        /// <summary>
        /// 调入仓类型 
        ///</summary>
        [SugarColumn(ColumnName = "WARE_TYPE_TO")]
        public string? WareTypeTo { get; set; }
 
        /// <summary>
        /// 物控调拨单号 
        ///</summary>
        [SugarColumn(ColumnName = "XMSTO_NO")]
        public string? XmstoNo { get; set; }
 
        /// <summary>
        /// 调拨单行项 
        ///</summary>
        [SugarColumn(ColumnName = "XMSTO_ITEM_NO")]
        public string? XmstoItemNo { get; set; }
 
        /// <summary>
        /// 最后修改时间(格式:yyyyMMddHHmmss) 
        ///</summary>
        [SugarColumn(ColumnName = "CHANGED_AT")]
        public string? ChangedAt { get; set; }
 
        /// <summary>
        /// 数据创建时间(格式:yyyyMMddHHmmss) 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_AT")]
        public string? CreatedAt { get; set; }
 
        /// <summary>
        /// 关联项目机型(多值逗号分隔) 
        ///</summary>
        [SugarColumn(ColumnName = "APP_MODELS")]
        public string? AppModels { get; set; }
 
        /// <summary>
        /// 外部系统凭证号(如ERP单号) 
        ///</summary>
        [SugarColumn(ColumnName = "EXT_DOC_NO")]
        public string? ExtDocNo { get; set; }
 
        /// <summary>
        /// 外部凭证行项目 
        ///</summary>
        [SugarColumn(ColumnName = "EXT_DOC_ITEM")]
        public string? ExtDocItem { get; set; }
 
        /// <summary>
        /// 海关HS编码(进出口报关用) 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_ID")]
        public string? BatchId { get; set; }
 
        /// <summary>
        /// 优先采购标识(紧急备料标记) 
        ///</summary>
        [SugarColumn(ColumnName = "BATCH_ROW")]
        public string? BatchRow { get; set; }
 
        /// <summary>
        /// 串号管理标识(Y/N,控制序列号采集) 
        ///</summary>
        [SugarColumn(ColumnName = "IS_IDENTIFICATION")]
        public string? IsIdentification { get; set; }
    }
}