Inventory.cs
7.99 KB
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
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
using System;
using System.ComponentModel.DataAnnotations.Schema;
namespace WebRepository
{
/// <summary>
/// 库存表
/// </summary>
[Table("inventory")]
public partial class Inventory : SysEntity
{
public Inventory()
{
}
/// <summary>
/// 仓库类型
/// </summary>
[Column("warehouseType")]
public string WarehouseType { get; set; }
/// <summary>
/// 库位id
/// </summary>
[Column("locationId")]
public int? LocationId { get; set; }
/// <summary>
/// 库位编号
/// </summary>
[Column("locationCode")]
public string LocationCode { get; set; }
/// <summary>
/// 容器编码
/// </summary>
[Column("containerCode")]
public string ContainerCode { get; set; }
/// <summary>
/// 铜箔桁架任务步骤
/// PP卷打包机任务步骤:0:无任务或正在任务中,1:单笔复核成功,2:托盘上全部符合成功,3:装箱机装箱正在装箱
/// </summary>
[Column("Tasksteps")]
public int? TaskSteps { get; set; }
/// <summary>
/// 物料位置
/// </summary>
[Column("Position")]
public int? Position { get; set; }
/// <summary>
/// 上游系统单号
/// </summary>
[Column("sourceCode")]
public string SourceCode { get; set; }
/// <summary>
/// 上游系统行号
/// </summary>
[Column("sourceLine")]
public string SourceLine { get; set; }
/// <summary>
/// 物料Id
/// </summary>
[Column("materialId")]
public int? MaterialId { get; set; }
/// <summary>
/// 二维码
/// </summary>
[Column("qrCode")]
public string QrCode { get; set; }
/// <summary>
/// 物料编码
/// </summary>
[Column("materialCode")]
public string MaterialCode { get; set; }
/// <summary>
/// 入库单id
/// </summary>
[Column("receiptId")]
public int? ReceiptId { get; set; }
/// <summary>
/// 入库单编码
/// </summary>
[Column("receiptCode")]
public string ReceiptCode { get; set; }
/// <summary>
/// 入库单明细id
/// </summary>
[Column("receiptDetailId")]
public int? ReceiptDetailId { get; set; }
/// <summary>
/// 批次
/// </summary>
[Column("batch")]
public string Batch { get; set; }
/// <summary>
/// 原始批次
/// </summary>
[Column("oldBatch")]
public string OldBatch { get; set; }
/// <summary>
/// 批号
/// </summary>
[Column("lot")]
public string Lot { get; set; }
/// <summary>
/// 项目号
/// </summary>
[Column("project")]
public string Project { get; set; }
/// <summary>
/// 生产日期
/// </summary>
[Column("manufactureDate")]
public System.DateTime? ManufactureDate { get; set; }
/// <summary>
/// 失效日期
/// </summary>
[Column("expirationDate")]
public System.DateTime? ExpirationDate { get; set; }
/// <summary>
/// 库存状态
/// </summary>
[Column("status")]
public string Status { get; set; }
/// <summary>
/// 任务状态
/// </summary>
[Column("taskStatus")]
public string TaskStatus { get; set; }
/// <summary>
/// 容器状态
/// </summary>
[Column("containerStatus")]
public string ContainerStatus { get; set; }
/// <summary>
/// 数量
/// </summary>
[Column("qty")]
public decimal? Qty { get; set; }
/// <summary>
///
/// </summary>
[Column("taskQty")]
public decimal? TaskQty { get; set; }
/// <summary>
/// 成本
/// </summary>
[Column("costPrice")]
public decimal? CostPrice { get; set; }
/// <summary>
/// 标价
/// </summary>
[Column("listPrice")]
public decimal? ListPrice { get; set; }
/// <summary>
/// 净价
/// </summary>
[Column("netPrice")]
public decimal? NetPrice { get; set; }
/// <summary>
/// 是否打包
/// </summary>
[Column("isPack")]
public string IsPack { get; set; }
/// <summary>
/// 叠托数量
/// </summary>
[Column("Combo")]
public string Combo { get; set; }
/// <summary>
/// 是否排板
/// </summary>
[Column("isFold")]
public string IsFold { get; set; }
/// <summary>
/// 供应商
/// </summary>
[Column("supplier")]
public string Supplier { get; set; }
/// <summary>
/// 厚度
/// </summary>
[Column("ResidualWeight")]
public decimal? ResidualWeight { get; set; }
/// <summary>
/// 退料人
/// </summary>
[Column("Retreat")]
public string Retreat { get; set; }
/// <summary>
/// 规格
/// </summary>
[Column("specification")]
public string Specification { get; set; }
/// <summary>
/// 品名
/// </summary>
[Column("nameDescription")]
public string NameDescription { get; set; }
/// <summary>
/// 单位
/// </summary>
[Column("unit")]
public string Unit { get; set; }
/// <summary>
/// 尺寸
/// </summary>
[Column("size")]
public string Size { get; set; }
/// <summary>
/// 张数
/// </summary>
[Column("NumberofSheets")]
public decimal? NumberofSheets { get; set; }
/// <summary>
/// 组数
/// </summary>
[Column("Groupnum")]
public decimal? Groupnum { get; set; }
/// <summary>
/// 错叠张数
/// </summary>
[Column("StackingNumber")]
public decimal? StackingNumber { get; set; }
/// <summary>
/// 客户编号
/// </summary>
[Column("customer")]
public string Customer { get; set; }
/// <summary>
/// 物料正反
/// </summary>
[Column("checkud")]
public string Checkud { get; set; }
/// <summary>
/// 备注
/// </summary>
[Column("remark")]
public string Remark { get; set; }
/// <summary>
/// PP卷物料大小
/// </summary>
[Column("Height")]
public int? Height { get; set; }
/// <summary>
/// ERP仓库
/// </summary>
[Column("SpecialWarehouse")]
public string SpecialWarehouse { get; set; }
/// <summary>
/// 物性卡控:Y不允许出库
/// </summary>
[Column("IsoutControl")]
public string IsoutControl { get; set; }
/// <summary>
/// ERP库位
/// </summary>
[Column("ErpWareCell")]
public string ErpWareCell { get; set; }
/// <summary>
/// 等级判定(A级,B级,E级)
/// </summary>
[Column("Grade")]
public string Grade { get; set; }
/// <summary>
/// 处理意见(0:良品,1:不良品,2:特采)
/// </summary>
[Column("Result")]
public string Result { get; set; }
/// <summary>
/// 入库仓
/// </summary>
[Column("WH")]
public string WH { get; set; }
/// <summary>
/// 线边仓
/// </summary>
[Column("LWH")]
public string LWH { get; set; }
/// <summary>
/// 线边仓储位
/// </summary>
[Column("LWHSL")]
public string LWHSL { get; set; }
/// <summary>
/// 大批号
/// </summary>
[Column("BLot")]
public string BLot { get; set; }
}
}