|
1
|
CREATE TABLE [dbo].[PL_TRADE_DETAIL_LOG_PAY](
|
|
2
|
[TRADE_ID] [varchar](15) PRIMARY KEY NOT NULL,
|
|
3
|
[PLAN_ID] [varchar](15) NULL,
|
|
4
|
[GOODS_ID] [varchar](15) NULL,
|
|
5
|
[GOODS_CODE] [nvarchar](200) NULL,
|
|
6
|
[GOODS_NAME] [nvarchar](200) NULL,
|
|
7
|
[GOODS_TYPE] [varchar](15) NULL,
|
|
8
|
[UNIT_ID] [varchar](15) NULL,
|
|
9
|
[M1] [decimal](18, 0) NULL,
|
|
10
|
[M2] [decimal](18, 0) NULL,
|
|
11
|
[M3] [decimal](18, 0) NULL,
|
|
12
|
[M4] [decimal](18, 0) NULL,
|
|
13
|
[M5] [decimal](18, 0) NULL,
|
|
14
|
[M6] [decimal](18, 0) NULL,
|
|
15
|
[M7] [decimal](18, 0) NULL,
|
|
16
|
[M8] [decimal](18, 0) NULL,
|
|
17
|
[M9] [decimal](18, 0) NULL,
|
|
18
|
[M10] [decimal](18, 0) NULL,
|
|
19
|
[M11] [decimal](18, 0) NULL,
|
|
20
|
[M12] [decimal](18, 0) NULL,
|
|
21
|
[QUANTITY] [decimal](18, 0) NULL,
|
|
22
|
[QUANTITY_EXE] [decimal](18, 0) NULL,
|
|
23
|
[PRICE] [decimal](18, 0) NULL,
|
|
24
|
[START_DT_AMORT] [datetime] NULL,
|
|
25
|
[MONTH_AMORT] [int] NULL,
|
|
26
|
[END_DT_AMORT] [datetime] NULL,
|
|
27
|
[RATE_AMORT] [decimal](18, 3) NULL,
|
|
28
|
[NOTES] [nvarchar](1000) NULL,
|
|
29
|
[RECORD_STATUS] [varchar](1) NULL,
|
|
30
|
[MAKER_ID] [varchar](12) NULL,
|
|
31
|
[CREATE_DT] [datetime] NULL,
|
|
32
|
[AUTH_STATUS] [varchar](50) NULL,
|
|
33
|
[CHECKER_ID] [varchar](12) NULL,
|
|
34
|
[APPROVE_DT] [datetime] NULL,
|
|
35
|
[AMT_ETM] [decimal](18, 2) NULL,
|
|
36
|
[AMT_EXE] [decimal](18, 2) NULL,
|
|
37
|
[AMT_APP] [decimal](18, 2) NULL,
|
|
38
|
[QUANTITY_ETM] [decimal](18, 0) NULL,
|
|
39
|
[AMT_TF] [decimal](18, 2) NULL,
|
|
40
|
[AMT_RECEIVE_TF] [decimal](18, 2) NULL,
|
|
41
|
[CREATE_PAY_DT] [datetime] NULL,
|
|
42
|
[NOTES_PAY] [nvarchar](500) NULL
|
|
43
|
)
|
|
44
|
|
|
45
|
|
|
46
|
INSERT INTO PL_TRADE_DETAIL_LOG_PAY
|
|
47
|
SELECT TOP 1 *, GETDATE(), N'Trước khi duyệt kê toán'
|
|
48
|
FROM PL_TRADEDETAIL
|
|
49
|
WHERE TRADE_ID IN (SELECT DISTINCT TRADE_ID FROM tr_req_pay_budget WHERE REQ_PAY_ID = @p_REQ_PAY_ID)
|
|
50
|
|
|
51
|
INSERT INTO PL_TRADE_DETAIL_LOG_PAY
|
|
52
|
SELECT TOP 1 *, GETDATE(), N'Sau khi duyệt kê toán'
|
|
53
|
FROM PL_TRADEDETAIL
|
|
54
|
WHERE TRADE_ID IN (SELECT DISTINCT TRADE_ID FROM tr_req_pay_budget WHERE REQ_PAY_ID = @p_REQ_PAY_ID)
|