INSERT INTO [TR_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[PROCESS_ID],[PL_REQ_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[BRANCH_DO],[REQ_REASON],[BRANCH_CREATE],[USER_REQUEST],[BRANCH_DVMS],[USER_DVMS],[DMMS_ID],[DEP_CREATE],[REQ_PARENT_ID],[SIGN_USER])VALUES(N'TRRDIII1124161',N'PUR/2020/00009706',N'Quảng cáo trên Digital Frame',N'2020-08-07',0,N'Quảng cáo trên Digital Frame',N'APPROVE',N'',2000000000,N'',N'1',N'tudt1',N'2020-08-07',N'A',N'',N'2020-09-07',N'DV0001',N'',N'DV0001',N'phuongtln1',N'DV0001',N'cuongvd',N'DMMS00000000001',N'DEP000000000015',N'',N'')
INSERT INTO [TR_REQUEST_DOC_DT] ([REQDT_ID],[REQ_DOC_ID],[PL_REQDT_ID],[GD_ID],[SUP_ID],[DESCRIPTION],[TRAN_TYPE_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[AMOUNT_PAID],[INVOICENO],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PRICE_ETM],[TOTAL_AMT_ETM],[REQ_DT],[AMORT_MONTH],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[DVDM_ID],[BID_ID],[OFFERING_VALUE],[NOTE_DVMS],[PO_ID],[PO_AMT])VALUES(N'TRRDDII1124784',N'TRRDIII1124161',N'',N'',N'CMS000000251411',N'Chi phí quảng cáo Digital frame tại TP.HCM',N'TRN0000000003',1,2000000000.00,2000000000.00,NULL,N'',N'',N'1',N'phuongtln1',N'2020-09-07',N'A',N'',N'2020-09-07',2000000000.00,2000000000.00,N'2020-09-07',NULL,N'HH0000000112274',N'VND',1.00,0.00,N'',N'',NULL,N'',N'',NULL)
INSERT INTO [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(N'TRRDIII1124161',N'DMMS',N'P',N'GDDV',N'',N'phuongtln1',N'2020-07-09',N'',N'',N'',N'',N'Phê duyệt',NULL,N'')
INSERT INTO [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(N'TRRDIII1124161',N'APPROVE',N'C',N'',N'',N'',NULL,N'',N'',N'',N'',N'Hoàn tất',NULL,N'')

DECLARE @PL_ID INT
SET @PL_ID = (SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE REQ_ID='TRRDIII1124161' AND PROCESS_ID='DMMS')

INSERT dbo.PL_REQUEST_PROCESS_CHILD
(
    REQ_ID,
    PROCESS_ID,
    TLNAME,
    TYPE_JOB,
    LEVEL_JOB,
    STATUS_JOB,
    RECORD_STATUS,
    MAKER_ID,
    TRANFER_DT
)
VALUES
(   'TRRDIII1124161',       -- REQ_ID - varchar(20)
   @PL_ID,       -- PROCESS_ID - varchar(20)
    'phuongtln1',       -- TLNAME - varchar(50)
    'TP',       -- TYPE_JOB - varchar(50)
    1,        -- LEVEL_JOB - int
    'P',       -- STATUS_JOB - varchar(10)
    '1',       -- RECORD_STATUS - varchar(15)
    '',       -- MAKER_ID - varchar(15)
    GETDATE() -- TRANFER_DT - datetime
    )
	INSERT dbo.PL_REQUEST_PROCESS_CHILD
(
    REQ_ID,
    PROCESS_ID,
    TLNAME,
    TYPE_JOB,
    LEVEL_JOB,
    STATUS_JOB,
    RECORD_STATUS,
    MAKER_ID,
    TRANFER_DT
)
VALUES
(   'TRRDIII1124161',       -- REQ_ID - varchar(20)
   @PL_ID,       -- PROCESS_ID - varchar(20)
    'vanpt2',       -- TLNAME - varchar(50)
    'KS',       -- TYPE_JOB - varchar(50)
    2,        -- LEVEL_JOB - int
    'P',       -- STATUS_JOB - varchar(10)
    '1',       -- RECORD_STATUS - varchar(15)
    '',       -- MAKER_ID - varchar(15)
    GETDATE() -- TRANFER_DT - datetime
    )
		INSERT dbo.PL_REQUEST_PROCESS_CHILD
(
    REQ_ID,
    PROCESS_ID,
    TLNAME,
    TYPE_JOB,
    LEVEL_JOB,
    STATUS_JOB,
    RECORD_STATUS,
    MAKER_ID,
    TRANFER_DT
)
VALUES
(   'TRRDIII1124161',       -- REQ_ID - varchar(20)
   @PL_ID,       -- PROCESS_ID - varchar(20)
    'cuongvd',       -- TLNAME - varchar(50)
    'XL',       -- TYPE_JOB - varchar(50)
    3,        -- LEVEL_JOB - int
    'P',       -- STATUS_JOB - varchar(10)
    '1',       -- RECORD_STATUS - varchar(15)
    '',       -- MAKER_ID - varchar(15)
    GETDATE() -- TRANFER_DT - datetime
    )