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'PLRDI000021264',N'96/2020/TTr-TTT 94/2020/TTr-TTT',N'Phục vụ nhu cầu phát triển kinh doanh thẻ năm 2020_2021',N'Aug 13 2020 12:00AM',NULL,N'Phục vụ nhu cầu phát triển kinh doanh thẻ năm 2020_2021',N'Phục vụ nhu cầu phát triển kinh doanh thẻ năm 2020_2021',N'DV0001',5687500,N'TRUNG TAM THE',N'0',N'huytn1',N'Aug 13 2020 12:00AM',N'A',NULL,N'Jan  1 1995 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',N'Jan  1 1995 12:00AM',NULL,NULL,NULL,N'DV0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,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'PLRDDI00022653',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit Bao thư thẻ',N'I',N'CMU000000000001',6500,875.00,5687500.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Cá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'PLRDDI00022654',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit Card Mailer',N'I',N'CMU00000000047',6500,990.00,6435000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022655',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit HDSD',N'I',N'CMU00000000047',6500,990.00,6435000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022656',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic Bao thư thẻ',N'I',N'CMU000000000001',14000,875.00,12250000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Cá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'PLRDDI00022657',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic Card Mailer',N'I',N'CMU00000000047',14000,990.00,13860000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022658',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic HDSD',N'I',N'CMU00000000047',14000,990.00,13860000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022659',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard Bao thư thẻ',N'I',N'CMU000000000001',15500,875.00,13562500.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Cá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'PLRDDI00022660',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard Card Mailer',N'I',N'CMU00000000047',15500,990.00,15345000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022661',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard HDSD',N'I',N'CMU00000000047',15500,990.00,15345000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'Tờ')

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'PLRDDI00022662',N'PLRDI000021264',NULL,NULL,N'GOO000001062671',NULL,N'Ấn phẩm thẻ dùng chung - Bao thư có cửa sổ',N'I',N'CMU000000000001',20000,875.00,17500000.00,N'1',NULL,NULL,N'A',NULL,NULL,N'DM0000000000004',N'HH0000000112312',N'VND',1.00,0.00,NULL,NULL,N'DM0000000000015',N'cái')

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'TRRDI000028116',N'PUR/2020/00009810',NULL,N'Aug 13 2020 12:00AM',NULL,N'',N'DMMS',N'PLRDI000021264',120252000,N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',N'',N'Phục vụ nhu cầu phát triển kinh doanh thẻ năm 2020_2021',N'DV0001',N'huytn1',N'DV0001',N'phuongvn',N'DMMS00000000001',N'',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'TRRDDI00029247',N'TRRDI000028116',N'PLRDDI00022653',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit Bao thư thẻ',NULL,6500,875.00,5684250.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',875.00,5687500.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029248',N'TRRDI000028116',N'PLRDDI00022654',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit Card Mailer',NULL,6500,990.00,6435000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,6435000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029249',N'TRRDI000028116',N'PLRDDI00022655',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Debit HDSD',NULL,6500,990.00,6435000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,6435000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029250',N'TRRDI000028116',N'PLRDDI00022656',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic Bao thư thẻ',NULL,14000,875.00,12243000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',875.00,12250000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029251',N'TRRDI000028116',N'PLRDDI00022657',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic Card Mailer',NULL,14000,990.00,13860000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,13860000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029252',N'TRRDI000028116',N'PLRDDI00022658',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng VISA Classic HDSD',NULL,14000,990.00,13860000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,13860000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029253',N'TRRDI000028116',N'PLRDDI00022659',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard Bao thư thẻ',NULL,15500,875.00,13554750.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',875.00,13562500.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029254',N'TRRDI000028116',N'PLRDDI00022660',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard Card Mailer',NULL,15500,990.00,15345000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,15345000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029255',N'TRRDI000028116',N'PLRDDI00022661',N'GOO000001062671',NULL,N'Ấn phẩm thẻ tính dụng JCB Standard HDSD',NULL,15500,990.00,15345000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',990.00,15345000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',NULL,NULL)

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'TRRDDI00029256',N'TRRDI000028116',N'PLRDDI00022662',N'GOO000001062671',NULL,N'Ấn phẩm thẻ dùng chung - Bao thư có cửa sổ',NULL,20000,875.00,17490000.00,NULL,N'',N'',N'1',N'huytn1',N'Aug 13 2020 12:00AM',N'A',N'phuongtln1',N'Jan  1 1995 12:00AM',875.00,17500000.00,N'Aug 14 2020 12:00AM',NULL,N'HH0000000112312',N'VND',1.00,0.00,N'DM0000000000004',N'',NULL,N'',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'TRRDI000028116',N'DMMS',N'C',N'GDDV',N'',N'',NULL,N'',N'',N'',N'',N'',1,N'')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI000028116',N'2885',N'phuongtln1',N'TP',1,N'U',N'1',N'',N'Oct  9 2020 10:41AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI000028116',N'2885',N'vanpt2',N'KS',2,N'U',N'1',N'',N'Oct  9 2020 10:41AM')

INSERT INTO [PL_REQUEST_PROCESS_CHILD] ([REQ_ID],[PROCESS_ID],[TLNAME],[TYPE_JOB],[LEVEL_JOB],[STATUS_JOB],[RECORD_STATUS],[MAKER_ID],[TRANFER_DT])VALUES(N'TRRDI000028116',N'2885',N'phuongvn',N'XL',3,N'C',N'1',N'',N'Oct  9 2020 10:41AM')

UPDATE dbo.PL_REQUEST_PROCESS_CHILD SET PROCESS_ID=(SELECT ID FROM dbo.PL_REQUEST_PROCESS WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID=PL_REQUEST_PROCESS.REQ_ID AND PROCESS_ID='DMMS')

WHERE PL_REQUEST_PROCESS_CHILD.REQ_ID ='TRRDI000028116'

UPDATE dbo.TR_REQUEST_DOC SET [RECORD_STATUS]=0 WHERE REQ_ID='TRRDI0001056108'