DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRDI01055438',N'0001/2020/TTr-0690402',N'Sản xuất clip phỏng vấn KH về trai nghiệm DV mở TK trực tuyến',N'Aug  5 2020 12:00AM',1,N'Sản xuất clip phỏng vấn KH về trai nghiệm DV mở TK trực tuyến',N'Sản xuất clip phỏng vấn KH về trai nghiệm DV mở TK trực tuyến',N'DV0001',22000000,NULL,N'1',N'oanhpl2',N'Sep 10 2020 12:00AM',N'A',N'namdt',N'Aug 13 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',NULL,NULL,N'DEP000000000058',N'DEP000000000058',N'DV0001',N'DEP000000000058',NULL,NULL,NULL,NULL,0,N'Căn cứ Quyết định 149/2020/QĐ-HC ngày 21/5/2020 về việc Ban hành Quy định mua sắm hàng hóa dịch vụ; Căn cứ nhu cầu mua sắm thực tế',NULL,NULL)

INSERT INTO [PL_REQUEST_DOC] ([REQ_ID],[REQ_CODE],[REQ_NAME],[REQ_DT],[REQ_TYPE],[REQ_CONTENT],[REQ_REASON],[BRANCH_ID],[TOTAL_AMT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PROCESS_ID],[DVDM_APP_ID],[REQ_PARENT_ID],[BRANCH_FEE],[EFFEC_DT],[IS_BACKDAY],[DEP_ID],[DEP_FEE],[BRANCH_CREATE],[DEP_CREATE],[REQ_LINE],[TC_NOTES],[SIGN_USER],[KT_NOTES],[IS_CHECKALL],[BASED_CONTENT],[IS_SETTLMENT],[PL_BASED_ID])VALUES(N'PLRDI01055439',N'0002/2020/TTr-0690402',N'Thanh toán chi phí tiếp khách',N'Sep 10 2020 12:00AM',1,N'Thanh toán chi phí tiếp khách',N'Thanh toán chi phí tiếp khách',N'DV0001',100000000,NULL,N'1',N'oanhpl2',N'Sep 10 2020 12:00AM',N'A',N'namdt',N'Aug 13 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',NULL,NULL,N'DEP000000000058',N'DEP000000000058',N'DV0001',N'DEP000000000058',NULL,NULL,NULL,NULL,0,N'Căn cứ Quyết định 149/2020/QĐ-HC ngày 21/5/2020 về việc Ban hành Quy định mua sắm hàng hóa dịch vụ; Căn cứ nhu cầu mua sắm thực tế',NULL,NULL)

INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDDI01055736',N'PLRDI01055438',N'PLM000000016935',N'PLT000000071131',N'GOO000001062725',N'',N'Sản xuất Clip',N'I',N'',1,22000000.00,22000000.00,N'1',N'oanhpl2',N'Sep 10 2020 12:00AM',N'U',N'namdt',N'Sep 10 2020 11:27PM',N'DM0000000000034',N'HH0000000003515',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000014',N'Gói')

INSERT INTO [PL_REQUEST_DOC_DT] ([REQDT_ID],[REQ_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[NAME],[DESCRIPTION],[REQDT_TYPE],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[DVDM_ID],[HANGHOA_ID],[CURRENCY],[EXCHANGE_RATE],[TAXES],[SUP_ID],[TRADE_TYPE],[KHOI_ID],[UNIT_NAME])VALUES(N'PLRDDI01055737',N'PLRDI01055439',N'PLM000000017957',N'PLT000000077332',N'GOO000001061929',N'',N'Chi phí tiếp khách',N'O',N'CMU000000000047',1,100000000.00,100000000.00,N'1',N'oanhpl2',N'Sep 10 2020 12:00AM',N'U',N'namdt',N'Sep 10 2020 11:31PM',N'',N'HH0000000112233',N'VND',1.00,0.00,N'',N'VCCB',N'',N'Gói')

INSERT INTO [PL_REQUEST_COSTCENTER] ([REQ_COST_ID],[COST_ID],[REQ_ID],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[DVMD_ID],[TOTAL_AMT_GD])VALUES(N'PLRCI001055667',N'DM0000000000034',N'PLRDI01055438',N'Đồng ý',N'A',N'oanhpl2',N'Sep 10 2020 12:00AM',NULL,NULL,NULL,NULL)

INSERT INTO [PL_REQUEST_TRANSFER] ([REQ_TRANSFER_ID],[REQ_DOC_ID],[FR_PLAN_ID],[FR_TRADE_ID],[FR_GOOD_ID],[FR_BRN_ID],[TO_BRN_ID],[TO_PLAN_ID],[TO_TRADE_ID],[TO_GOOD_ID],[QTY],[TOTAL_AMT],[NOTES],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[TO_DVDM_ID],[FR_DEP_ID],[TO_DEP_ID],[TO_KHOI_ID],[FR_DVDM_ID],[FR_KHOI_ID])VALUES(N'PLRTI001055321',N'PLRDI01055439',N'PLM000001057663',N'PLT000001072111',N'GOO000001061899',N'DV0001',N'DV0001',N'PLM000000017957',N'PLT000000077332',N'GOO000001061929',0,100000000.00,N'',N'U',N'oanhpl2',N'Sep 10 2020 12:00AM',NULL,NULL,N'',N'DEP000000000058',N'DEP000000000058',N'',N'',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'PLRDI01055438',N'APPNEW',N'P',N'GDDV',N'DV0001',N'namdt',N'Aug 13 2020 12:00AM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000058')

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'PLRDI01055438',N'KT',N'P',N'KSV',N'',N'nghihm',N'Aug 13 2020 12:00AM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Chờ phòng kế toán xác nhận',1,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'PLRDI01055438',N'PTGD_TT',N'P',N'PTGD',N'',N'tupa',N'Aug 13 2020 12:00AM',N'KT',N'N',N'',N'DM0000000000017',N'Chờ giám đốc khối xác nhận',0,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'PLRDI01055438',N'APPROVE',N'C',N'',N'',N'',N'Aug 13 2020 12:00AM',N'PTGD_TT',N'Y',NULL,NULL,N'Hoàn tất',NULL,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'PLRDI01055439',N'APPNEW',N'P',N'GDDV',N'DV0001',N'namdt',N'Aug 13 2020 12:00AM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000058')

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'PLRDI01055439',N'KT',N'P',N'KSV',N'',N'nghihm',N'Aug 13 2020 12:00AM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Phòng kế toán phê duyệt',1,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'PLRDI01055439',N'TC',N'P',N'TC',N'',N'hoattm',N'Aug 13 2020 12:00AM',N'KT',N'N',N'',N'',N'Phòng tài chính phê duyệt',1,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'PLRDI01055439',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD',N'Y',NULL,NULL,N'Hoàn tất',NULL,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'PLRDI01055439',N'PTGD_DC',N'P',N'PTGD',NULL,N'tupa',N'Aug 13 2020 12:00AM',N'TC',NULL,NULL,N'DM0000000000017',N'Phó tổng giám đốc khối phê duyệt',NULL,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'PLRDI01055439',N'TGD',N'P',N'TGD',NULL,N'trungnq1',N'Aug 13 2020 12:00AM',N'PTGD_DC',NULL,NULL,NULL,N'Tổng giám đốc đã phê duyệt',NULL,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'PLRD00000200154',N'APPNEW',N'P',N'GDDV',N'DV0001',N'thanhnt',N'Sep 13 2020 12:00AM',NULL,N'N',NULL,NULL,N'Trưởng đơn vị phê duyệt',NULL,N'DEP000000000062')

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'PLRD00000200154',N'KT',N'P',N'KSV',N'',N'nghihm',N'Sep 10 2020 12:00AM',N'APPNEW',N'N',N'',N'DM0000000000006',N'Phòng kế toán phê duyệt',1,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'PLRD00000200154',N'GDK_TT',N'P',N'GDK',N'',N'nhannt',N'Sep 10 2020 12:00AM',N'KT',N'N',N'',N'DM0000000000023',N'Giám đốc khối đã phê duyệt',1,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'PLRD00000200154',N'APPROVE',N'U',N'',N'',N'',NULL,N'TGD',N'Y',NULL,NULL,N'Hoàn tất',NULL,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'PLRD00000200154',N'PTGD_DC',N'P',N'PTGD',NULL,N'tupa',N'Sep 10 2020 12:00AM',N'GDK_TT',NULL,NULL,N'DM0000000000017',N'Phó tổng giám đốc khối phê duyệt',NULL,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'PLRD00000200154',N'TGD',N'P',N'TGD',NULL,N'trungnq1',N'Sep 10 2020 12:00AM',N'PTGD_DC',NULL,NULL,NULL,N'Tổng giám đốc đã phê duyệt',NULL,NULL)