InventoryTransaction.cs
5.96 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
using System;
using System.ComponentModel.DataAnnotations.Schema;
namespace WebRepository
{
/// <summary>
/// 库存交易表
/// </summary>
[Table("inventory_transaction")]
public partial class InventoryTransaction : SysEntity
{
public InventoryTransaction()
{
}
/// <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>
/// 上游系统单号
/// </summary>
[Column("sourceCode")]
public string SourceCode { get; set; }
/// <summary>
/// 上游系统行号
/// </summary>
[Column("sourceLine")]
public string SourceLine { get; set; }
/// <summary>
/// 交易类型
/// </summary>
[Column("type")]
public string Type { get; set; }
/// <summary>
/// 物料Id
/// </summary>
[Column("materialId")]
public int? MaterialId { get; set; }
/// <summary>
/// 物料名称
/// </summary>
[Column("materialName")]
public string MaterialName { get; set; }
/// <summary>
/// 物料编码
/// </summary>
[Column("materialCode")]
public string MaterialCode { get; set; }
/// <summary>
/// 单头
/// </summary>
[Column("billId")]
public int? BillId { get; set; }
/// <summary>
/// 单编码
/// </summary>
[Column("billCode")]
public string BillCode { get; set; }
/// <summary>
/// 单明细id
/// </summary>
[Column("billDetailId")]
public int? BillDetailId { get; set; }
/// <summary>
/// 批次
/// </summary>
[Column("batch")]
public string Batch { 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("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>
/// 自定义字段1
/// </summary>
[Column("userDef1")]
public string UserDef1 { get; set; }
/// <summary>
/// 自定义字段2
/// </summary>
[Column("userDef2")]
public string UserDef2 { get; set; }
/// <summary>
/// 自定义字段3
/// </summary>
[Column("userDef3")]
public string UserDef3 { 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("oldBatch")]
public string OldBatch { get; set; }
/// <summary>
/// 错叠张数
/// </summary>
[Column("StackingNumber")]
public decimal? StackingNumber { get; set; }
}
}