|
1
|
column1
|
|
2
|
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)
|
|
3
|
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)
|
|
4
|
column1
|
|
5
|
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)
|
|
6
|
column1
|
|
7
|
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)
|
|
8
|
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)
|
|
9
|
column1
|
|
10
|
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)
|
|
11
|
|
|
12
|
|
|
13
|
column1
|
|
14
|
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)
|
|
15
|
column1
|
|
16
|
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)
|
|
17
|
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
|
|
18
|
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
|
|
19
|
column1
|
|
20
|
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)
|
|
21
|
column1
|
|
22
|
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)
|