InventoryTransaction.cs
4 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
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; }
}
}