PUR 00341.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 |
( 'TRRD00000252399', -- REQ_ID - varchar(15) |
| 20 |
'GDK_PYC', -- PROCESS_ID - varchar(10) |
| 21 |
'C', -- STATUS - varchar(5) |
| 22 |
'GDK', -- ROLE_USER - varchar(50) |
| 23 |
'', -- BRANCH_ID - varchar(15) |
| 24 |
'', -- CHECKER_ID - varchar(15) |
| 25 |
NULL, -- APPROVE_DT - datetime |
| 26 |
'DMMS', -- PARENT_PROCESS_ID - varchar(10) |
| 27 |
'', -- IS_LEAF - varchar(1) |
| 28 |
'', -- COST_ID - varchar(15) |
| 29 |
'DM0000000000015', -- DVDM_ID - varchar(15) |
| 30 |
N'Chờ giám đốc khối phê duyệt', -- NOTES - nvarchar(500) |
| 31 |
NULL, -- IS_HAS_CHILD - bit |
| 32 |
'' -- DEP_ID - varchar(20) |
| 33 |
) |
| 34 |
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U',PARENT_PROCESS_ID='GDK_PYC' WHERE ID=16589 |
| 35 |
UPDATE dbo.TR_REQUEST_DOC SET PROCESS_ID='GDK_PYC' WHERE REQ_ID='TRRD00000252399' |