column1
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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],[SUB_PROCESS_ID])VALUES(94168,N'AFT000000000241',N'APPNEW',N'P',N'GDDV',N'BRN000000000388',N'cuongddv',N'Mar 13 2023 3:42PM',N'SIGN',N'N',N'',N'',N'Trưởng đơn vị đã duyệt PYC công tác',NULL,N'',NULL)
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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],[SUB_PROCESS_ID])VALUES(94181,N'AFT000000000241',N'APPROVE',N'C',N'',N'',N'',NULL,N'APPNEW',N'Y',NULL,NULL,N'Hoàn tất',NULL,NULL,NULL)
column1
INSERT INTO [TR_REQUEST_JOB_FORM] ([REQ_ID],[REQ_CODE],[REQ_DT],[REF_ID],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[REQ_REASON],[REQ_DESC],[NOTES],[REQ_TYPE_TRANS],[REQ_TYPE_GROUP],[REQ_TYPE_BOOKING_HOTEL],[REQ_TYPE_BOOKING_AIR],[REQ_TYPE_BOOKING_TRAIN],[SENDER_ID],[SEND_DT],[SIGN_USER],[SIGN_DT],[PROCESS_ID],[BRANCH_CREATE],[DEP_CREATE],[BRANCH_ID],[DEP_ID],[FRMDATE],[TODATE],[IS_SEND_APPR],[CONTENT],[REQ_TYPE_BOOKING_CAR],[NUM_TRIP_PEOPLE],[OVERALL_TIME],[TYPE_WORK],[FROM_DATE],[TO_DATE],[HOTEL_NT],[HOTEL_HO],[EMP_ID],[EMP_PHONE],[REQ_CAR_ID])VALUES(N'AFT000000000241',N'AFT-23-000248',NULL,N'bangtt',N'bangtt',N'Mar 13 2023 3:38PM',N'A',N'cuongddv',N'Mar 13 2023 3:42PM',N'Thẩm định khách hàng',NULL,NULL,NULL,N'InGroup',N'HOTEL_N',N'AIR_P',N'TRAIN_N',N'bangtt',N'Mar 13 2023 3:38PM',NULL,NULL,N'APPROVE',N'BRN000000000388',N'DEP000000000083',N'CHI NHANH NAM SAI GON',NULL,NULL,NULL,N'Y',NULL,NULL,1,1,N'DOMESTIC',N'Mar 14 2023 6:45AM',N'Mar 14 2023 8:55PM',NULL,NULL,N'bangtt',N'0969055039',NULL)
column1
INSERT INTO [TR_REQUEST_JOB_TRAIN] ([TRAIN_ID],[REQ_ID],[TIME_TRAIN],[DAY_TRAIN],[FROM_TRAIN],[TO_TRAIN],[NOTES],[AUTH_STATUS],[VEHICLE_TYPE],[CONSIGNMENT],[IS_OLD])VALUES(N'TRJT00000000573',N'AFT000000000241',N'06:45',N'Mar 14 2023 12:00AM',N'79',N'48',N'',NULL,N'AIR',N'No',0)
INSERT INTO [TR_REQUEST_JOB_TRAIN] ([TRAIN_ID],[REQ_ID],[TIME_TRAIN],[DAY_TRAIN],[FROM_TRAIN],[TO_TRAIN],[NOTES],[AUTH_STATUS],[VEHICLE_TYPE],[CONSIGNMENT],[IS_OLD])VALUES(N'TRJT00000000574',N'AFT000000000241',N'20:55',N'Mar 14 2023 12:00AM',N'48',N'79',N'',NULL,N'AIR',N'No',0)
column1
INSERT INTO [TR_REQUEST_JOB_DETAIL] ([REQ_DT_ID],[REQ_ID],[EMP_ID],[TLNANME],[BRANCH_ID],[DEP_ID],[PHONE],[NOTES],[AUTH_STATUS])VALUES(N'TRJD00000000080',N'AFT000000000241',N'EMP000000000719',N'bangtt',N'BRN000000000388',N'DEP000000000083',N'0969055039',N'',NULL)


column1
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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],[SUB_PROCESS_ID])VALUES(94182,N'AFT000000000242',N'APPNEW',N'C',N'GDK',NULL,N'',NULL,N'SIGN',N'N',N'',NULL,N'Chờ giám đốc khối phê duyệt',NULL,NULL,NULL)
column1
INSERT INTO [TR_REQUEST_JOB_FORM] ([REQ_ID],[REQ_CODE],[REQ_DT],[REF_ID],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[REQ_REASON],[REQ_DESC],[NOTES],[REQ_TYPE_TRANS],[REQ_TYPE_GROUP],[REQ_TYPE_BOOKING_HOTEL],[REQ_TYPE_BOOKING_AIR],[REQ_TYPE_BOOKING_TRAIN],[SENDER_ID],[SEND_DT],[SIGN_USER],[SIGN_DT],[PROCESS_ID],[BRANCH_CREATE],[DEP_CREATE],[BRANCH_ID],[DEP_ID],[FRMDATE],[TODATE],[IS_SEND_APPR],[CONTENT],[REQ_TYPE_BOOKING_CAR],[NUM_TRIP_PEOPLE],[OVERALL_TIME],[TYPE_WORK],[FROM_DATE],[TO_DATE],[HOTEL_NT],[HOTEL_HO],[EMP_ID],[EMP_PHONE],[REQ_CAR_ID])VALUES(N'AFT000000000242',N'AFT-23-000249',NULL,N'bangtt',N'bangtt',N'Mar 13 2023 3:40PM',N'U',NULL,NULL,N'Thẩm định khách hàng',NULL,NULL,NULL,N'InGroup',N'HOTEL_N',N'AIR_P',N'TRAIN_N',N'bangtt',N'Mar 13 2023 3:42PM',NULL,NULL,N'SIGN',N'BRN000000000388',N'DEP000000000083',N'CHI NHANH NAM SAI GON',NULL,NULL,NULL,N'Y',NULL,NULL,1,1,N'DOMESTIC',N'Mar 14 2023 6:45AM',N'Mar 14 2023 8:55PM',NULL,NULL,N'anpt',N'0969055039',NULL)
reQ_ID	reQ_CODE	reQ_DT	reF_ID	makeR_ID	creatE_DT	autH_STATUS	checkeR_ID	approvE_DT	reQ_REASON	reQ_DESC	notes	reQ_TYPE_TRANS	reQ_TYPE_GROUP	reQ_TYPE_BOOKING_HOTEL	reQ_TYPE_BOOKING_AIR	reQ_TYPE_BOOKING_TRAIN	sendeR_ID	senD_DT	sigN_USER	sigN_DT	procesS_ID	brancH_CREATE	deP_CREATE	brancH_ID	deP_ID	frmdate	todate	iS_SEND_APPR	content	reQ_TYPE_BOOKING_CAR	nuM_TRIP_PEOPLE	overalL_TIME	typE_WORK	froM_DATE	tO_DATE	hoteL_NT	hoteL_HO	emP_ID	emP_PHONE	reQ_CAR_ID
AFT000000000242	AFT-23-000249		bangtt	bangtt	2023-03-13T15:40:26	U			Thẩm định khách hàng				InGroup	HOTEL_N	AIR_P	TRAIN_N	bangtt	2023-03-13T15:42:04.5			SIGN	BRN000000000388	DEP000000000083	CHI NHANH NAM SAI GON				Y			1	1	DOMESTIC	2023-03-14T06:45:00	2023-03-14T20:55:00			anpt	0969055039	
column1
INSERT INTO [PL_REQUEST_PROCESS] ([ID],[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],[SUB_PROCESS_ID])VALUES(94182,N'AFT000000000242',N'APPNEW',N'C',N'GDK',NULL,N'',NULL,N'SIGN',N'N',N'',NULL,N'Chờ giám đốc khối phê duyệt',NULL,NULL,NULL)
column1
INSERT INTO [TR_REQUEST_JOB_FORM] ([REQ_ID],[REQ_CODE],[REQ_DT],[REF_ID],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[REQ_REASON],[REQ_DESC],[NOTES],[REQ_TYPE_TRANS],[REQ_TYPE_GROUP],[REQ_TYPE_BOOKING_HOTEL],[REQ_TYPE_BOOKING_AIR],[REQ_TYPE_BOOKING_TRAIN],[SENDER_ID],[SEND_DT],[SIGN_USER],[SIGN_DT],[PROCESS_ID],[BRANCH_CREATE],[DEP_CREATE],[BRANCH_ID],[DEP_ID],[FRMDATE],[TODATE],[IS_SEND_APPR],[CONTENT],[REQ_TYPE_BOOKING_CAR],[NUM_TRIP_PEOPLE],[OVERALL_TIME],[TYPE_WORK],[FROM_DATE],[TO_DATE],[HOTEL_NT],[HOTEL_HO],[EMP_ID],[EMP_PHONE],[REQ_CAR_ID])VALUES(N'AFT000000000242',N'AFT-23-000249',NULL,N'bangtt',N'bangtt',N'Mar 13 2023 3:40PM',N'U',NULL,NULL,N'Thẩm định khách hàng',NULL,NULL,NULL,N'InGroup',N'HOTEL_N',N'AIR_P',N'TRAIN_N',N'bangtt',N'Mar 13 2023 3:42PM',NULL,NULL,N'SIGN',N'BRN000000000388',N'DEP000000000083',N'CHI NHANH NAM SAI GON',NULL,NULL,NULL,N'Y',NULL,NULL,1,1,N'DOMESTIC',N'Mar 14 2023 6:45AM',N'Mar 14 2023 8:55PM',NULL,NULL,N'anpt',N'0969055039',NULL)