|
1
|
DROP TABLE dbo.PL_TRADEDETAIL_HIST
|
|
2
|
CREATE TABLE [dbo].[PL_TRADEDETAIL_HIST](
|
|
3
|
[TRADE_ID] [VARCHAR](15) NOT NULL,
|
|
4
|
[PLAN_ID] [VARCHAR](15) NULL,
|
|
5
|
[GOODS_ID] [VARCHAR](15) NULL,
|
|
6
|
[GOODS_CODE] [NVARCHAR](200) NULL,
|
|
7
|
[GOODS_NAME] [NVARCHAR](200) NULL,
|
|
8
|
[GOODS_TYPE] [VARCHAR](15) NULL,
|
|
9
|
[UNIT_ID] [VARCHAR](15) NULL,
|
|
10
|
[M1] [DECIMAL](18, 0) NULL,
|
|
11
|
[M2] [DECIMAL](18, 0) NULL,
|
|
12
|
[M3] [DECIMAL](18, 0) NULL,
|
|
13
|
[M4] [DECIMAL](18, 0) NULL,
|
|
14
|
[M5] [DECIMAL](18, 0) NULL,
|
|
15
|
[M6] [DECIMAL](18, 0) NULL,
|
|
16
|
[M7] [DECIMAL](18, 0) NULL,
|
|
17
|
[M8] [DECIMAL](18, 0) NULL,
|
|
18
|
[AMT_ETM] [DECIMAL](18, 2) NULL,
|
|
19
|
[AMT_EXE] [DECIMAL](18, 2) NULL,
|
|
20
|
[AMT_APP] [DECIMAL](18, 2) NULL,
|
|
21
|
[QUANTITY_ETM] [DECIMAL](18, 0) NULL,
|
|
22
|
[QUANTITY] [DECIMAL](18, 0) NULL,
|
|
23
|
[QUANTITY_EXE] [DECIMAL](18, 0) NULL,
|
|
24
|
[PRICE] [DECIMAL](18, 0) NULL,
|
|
25
|
[START_DT_AMORT] [DATETIME] NULL,
|
|
26
|
[MONTH_AMORT] [INT] NULL,
|
|
27
|
[END_DT_AMORT] [DATETIME] NULL,
|
|
28
|
[RATE_AMORT] [DECIMAL](18, 3) NULL,
|
|
29
|
[NOTES] [NVARCHAR](1000) NULL,
|
|
30
|
[RECORD_STATUS] [VARCHAR](1) NULL,
|
|
31
|
[MAKER_ID] [VARCHAR](12) NULL,
|
|
32
|
[CREATE_DT] [DATETIME] NULL,
|
|
33
|
[AUTH_STATUS] [VARCHAR](50) NULL,
|
|
34
|
[CHECKER_ID] [VARCHAR](12) NULL,
|
|
35
|
[APPROVE_DT] [DATETIME] NULL,
|
|
36
|
[M9] [DECIMAL](18, 0) NULL,
|
|
37
|
[M10] [DECIMAL](18, 0) NULL,
|
|
38
|
[M11] [DECIMAL](18, 0) NULL,
|
|
39
|
[M12] [DECIMAL](18, 0) NULL,
|
|
40
|
[AMT_TF] [DECIMAL](18, 2) NULL,
|
|
41
|
[AMT_RECEIVE_TF] [DECIMAL](18, 2) NULL,
|
|
42
|
[REQ_ID] [VARCHAR](15) NOT NULL,
|
|
43
|
CONSTRAINT [PK_PL_TRADEDETAIL_HIST] PRIMARY KEY NONCLUSTERED
|
|
44
|
(
|
|
45
|
[TRADE_ID] ASC,
|
|
46
|
[REQ_ID] ASC
|
|
47
|
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
|
48
|
) ON [PRIMARY]
|
|
49
|
|
|
50
|
|