INSERT INTO dbo.PL_REQUEST_PROCESS ( REQ_ID, PROCESS_ID, STATUS, ROLE_USER, BRANCH_ID, CHECKER_ID, APPROVE_DT, PARENT_PROCESS_ID, IS_LEAF, COST_ID, DVDM_ID, NOTES, IS_HAS_CHILD, DEP_ID ) VALUES ( '', -- REQ_ID - varchar(15) 'DVCM', -- PROCESS_ID - varchar(10) 'P', -- STATUS - varchar(5) 'GDDV', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) 'hoacq', -- CHECKER_ID - varchar(15) '2020-08-08 09:00:00', -- APPROVE_DT - datetime 'DMMS', -- PARENT_PROCESS_ID - varchar(10) '', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) 'DM0000000000004', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) NULL, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) ) INSERT INTO dbo.PL_REQUEST_PROCESS ( REQ_ID, PROCESS_ID, STATUS, ROLE_USER, BRANCH_ID, CHECKER_ID, APPROVE_DT, PARENT_PROCESS_ID, IS_LEAF, COST_ID, DVDM_ID, NOTES, IS_HAS_CHILD, DEP_ID ) VALUES ( '', -- REQ_ID - varchar(15) 'PDYC_01', -- PROCESS_ID - varchar(10) 'P', -- STATUS - varchar(5) 'GDK', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) 'tunt', -- CHECKER_ID - varchar(15) '2020-08-08 10:00:00', -- APPROVE_DT - datetime 'DVCM', -- PARENT_PROCESS_ID - varchar(10) '', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) 'DM0000000000015', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) NULL, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) ) INSERT INTO dbo.PL_REQUEST_PROCESS ( REQ_ID, PROCESS_ID, STATUS, ROLE_USER, BRANCH_ID, CHECKER_ID, APPROVE_DT, PARENT_PROCESS_ID, IS_LEAF, COST_ID, DVDM_ID, NOTES, IS_HAS_CHILD, DEP_ID ) VALUES ( '', -- REQ_ID - varchar(15) 'APPROVE', -- PROCESS_ID - varchar(10) 'C', -- STATUS - varchar(5) '', -- ROLE_USER - varchar(50) '', -- BRANCH_ID - varchar(15) '', -- CHECKER_ID - varchar(15) NULL, -- APPROVE_DT - datetime 'PDYC_01', -- PARENT_PROCESS_ID - varchar(10) 'Y', -- IS_LEAF - varchar(1) '', -- COST_ID - varchar(15) '', -- DVDM_ID - varchar(15) N'', -- NOTES - nvarchar(500) NULL, -- IS_HAS_CHILD - bit '' -- DEP_ID - varchar(20) )