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
| import { Entity, PrimaryGeneratedColumn, Column, ManyToOne, JoinColumn } from "typeorm";
| import { vSaleOuterCase } from "./vSaleOuterCase";
|
| @Entity("vSale_Outer_CaseList")
| export class vSaleOuterCaseList {
| /**
| * 打包单ID
| */
| @PrimaryGeneratedColumn()
| outerList_Id?: number;
|
| /**
| * 箱号
| */
| @Column()
| caseNumber?: string;
|
| /**
| * 物料ID
| */
| @Column()
| product_Id: number;
|
| /**
| * 物料编号
| */
| @Column()
| productCode: string;
|
| /**
| * 物料名称
| */
| @Column()
| productName: string;
|
| /**
| * 条码
| */
| @Column()
| productModel: string;
|
| /**
| * 规格
| */
| @Column()
| productSpec?: string;
|
| /**
| * 数量
| */
| @Column()
| quantityOrder: number;
|
| /**
| * 单价
| */
| @Column({
| type: "decimal",
| precision: 14,
| scale: 4
| })
| salePrice?: number;
|
| /**
| * 物料金额
| */
| @Column({
| type: "decimal",
| precision: 14,
| scale: 4
| })
| rowTotal?: number;
|
| /**
| * 关联出库单号
| */
| @Column()
| orderCode?: string;
|
| /**
| * 批次号
| */
| @Column()
| batchNumber?: string;
|
| /**
| * 单位
| */
| @Column()
| smallUnit?: string;
|
| /**
| * 账套ID
| */
| @Column()
| userProduct_Id?: number;
|
| /**
| * 类别
| */
| @Column()
| typeName?: string;
| /**
| * 打包装箱查询主表数据
| */
| @ManyToOne(() => vSaleOuterCase, t => t.vSaleOuterCaseList)
| @JoinColumn({
| name: "caseNumber",
| referencedColumnName: "caseNumber"
| })
| vSaleOuterCase: vSaleOuterCase;
| }
|
|
