|
1
|
INSERT dbo.PL_MASTER
|
|
2
|
(
|
|
3
|
PLAN_ID,
|
|
4
|
PLAN_CODE,
|
|
5
|
PLAN_NAME,
|
|
6
|
BRANCH_ID,
|
|
7
|
DEPT_ID,
|
|
8
|
EFFECT_DT,
|
|
9
|
PLAN_TYPE,
|
|
10
|
TOTAL_AMT,
|
|
11
|
APPROVE_VALUE,
|
|
12
|
VERSON,
|
|
13
|
YEAR,
|
|
14
|
STATUS,
|
|
15
|
NOTES,
|
|
16
|
RECORD_STATUS,
|
|
17
|
MAKER_ID,
|
|
18
|
CREATE_DT,
|
|
19
|
AUTH_STATUS,
|
|
20
|
CHECKER_ID,
|
|
21
|
APPROVE_DT,
|
|
22
|
PLAN_TYPE_ID,
|
|
23
|
COST_ID
|
|
24
|
)
|
|
25
|
VALUES
|
|
26
|
( 'PLMI00001057682', -- PLAN_ID - varchar(15)
|
|
27
|
'', -- PLAN_CODE - varchar(15)
|
|
28
|
N'', -- PLAN_NAME - nvarchar(200)
|
|
29
|
'DV0001', -- BRANCH_ID - varchar(15)
|
|
30
|
'DEP000000000024', -- DEPT_ID - varchar(15)
|
|
31
|
GETDATE(), -- EFFECT_DT - datetime
|
|
32
|
'', -- PLAN_TYPE - varchar(1)
|
|
33
|
13365000000.00, -- TOTAL_AMT - decimal(18, 2)
|
|
34
|
13365000000.00, -- APPROVE_VALUE - decimal(18, 2)
|
|
35
|
0, -- VERSON - int
|
|
36
|
'2020', -- YEAR - varchar(4)
|
|
37
|
'', -- STATUS - varchar(1)
|
|
38
|
N'', -- NOTES - nvarchar(1000)
|
|
39
|
'1', -- RECORD_STATUS - varchar(1)
|
|
40
|
'', -- MAKER_ID - varchar(15)
|
|
41
|
GETDATE(), -- CREATE_DT - datetime
|
|
42
|
'A', -- AUTH_STATUS - varchar(50)
|
|
43
|
'admin', -- CHECKER_ID - varchar(15)
|
|
44
|
GETDATE(), -- APPROVE_DT - datetime
|
|
45
|
'PLTYPE000000020', -- PLAN_TYPE_ID - varchar(15)
|
|
46
|
'DM0000000000052' -- COST_ID - varchar(15)
|
|
47
|
)
|
|
48
|
|
|
49
|
UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID='PLMI00001057682' WHERE TRADE_ID='PLT000000071010'
|