PL_INSERT_PL_PROCESS.txt
1 |
INSERT INTO dbo.PL_REQUEST_PROCESS |
---|---|
2 |
( |
3 |
REQ_ID, |
4 |
PROCESS_ID, |
5 |
STATUS, |
6 |
ROLE_USER, |
7 |
BRANCH_ID, |
8 |
CHECKER_ID, |
9 |
APPROVE_DT, |
10 |
PARENT_PROCESS_ID, |
11 |
IS_LEAF, |
12 |
COST_ID, |
13 |
DVDM_ID, |
14 |
NOTES, |
15 |
IS_HAS_CHILD, |
16 |
DEP_ID |
17 |
) |
18 |
VALUES |
19 |
( '', -- REQ_ID - varchar(15) |
20 |
'', -- PROCESS_ID - varchar(10) |
21 |
'', -- STATUS - varchar(5) |
22 |
'', -- ROLE_USER - varchar(50) |
23 |
'', -- BRANCH_ID - varchar(15) |
24 |
'', -- CHECKER_ID - varchar(15) |
25 |
GETDATE(), -- APPROVE_DT - datetime |
26 |
'', -- PARENT_PROCESS_ID - varchar(10) |
27 |
'', -- IS_LEAF - varchar(1) |
28 |
'', -- COST_ID - varchar(15) |
29 |
'', -- DVDM_ID - varchar(15) |
30 |
N'', -- NOTES - nvarchar(500) |
31 |
NULL, -- IS_HAS_CHILD - bit |
32 |
'' -- DEP_ID - varchar(20) |
33 |
) |