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
| import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn } from "typeorm";
|
| @Entity("vRequire_GoodsList")
| export class vRequireGoodsList {
| /**
| * 要货明细ID
| */
| @PrimaryGeneratedColumn()
| goodsList_Id?: number;
|
| /**
| * 要货单ID
| */
| @Column()
| goods_Id: number;
|
| /**
| * 要货单号
| */
| @Column()
| goodsCode?: string;
|
| /**
| * 仓库ID
| */
| @Column()
| storage_Id?: number;
|
| /**
| * 仓库名称
| */
| @Column()
| storageName?: string;
|
| /**
| * 要货单状态
| */
| @Column()
| goodsText?: string;
|
| /**
| * 下单日期
| */
| @Column()
| placeOrderDate?: Date;
|
| /**
| * 账户ID
| */
| @Column()
| platUser_Id?: number;
|
| /**
| * 账套ID
| */
| @Column()
| userProduct_Id?: number;
|
| /**
| * 物料ID
| */
| @Column()
| product_Id?: number;
|
| /**
| * 物料编号
| */
| @Column()
| productCode?: string;
|
| /**
| * 物料名称
| */
| @Column()
| productName?: string;
|
| /**
| * 物料条码
| */
| @Column()
| productModel?: string;
|
| /**
| * 物料规格
| */
| @Column()
| productSpec?: string;
|
| /**
| * 要货数量
| */
| @Column({
| type: "decimal",
| precision: 14,
| scale: 4
| })
| goodsQuantity?: number;
|
| /**
| * 单价
| */
| @Column({
| type: "decimal",
| precision: 14,
| scale: 4
| })
| productPrice?: number;
|
| /**
| * 金额
| */
| @Column({
| type: "decimal",
| precision: 14,
| scale: 4
| })
| productTotal?: number;
|
| /**
| * 创建人
| */
| @Column()
| creator?: string;
|
| /**
| * 时间时间
| */
| @CreateDateColumn()
| createDate?: Date;
| }
|
|