1
|
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'PLRDI0001055407',N'0002/2020/TTr-0692104',N'Mua sắm phôi thẻ, ấn phẩm và dich vụ thẻ VISA Debit',N'Aug 4 2020 12:00AM',1,N'Mua sắm phôi thẻ, ấn phẩm và dich vụ thẻ VISA Debit',N'Mua sắm phôi thẻ, ấn phẩm và dich vụ thẻ VISA Debit',N'DV0001',457506500,NULL,N'1',N'andm',N'Aug 4 2020 12:00AM',N'U',N'vinhlk',N'Aug 4 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',NULL,NULL,N'DEP000000000052',N'DEP000000000052',N'DV0001',N'DEP000000000052',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)
|
2
|
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'PLRDI0001055408',N'0003/2020/TTr-0692104',N'Chi tiêu/mua sắm phôi thẻ, ấn phẩm và dịch vụ thẻ tín dụng năm 2020 (lần 2)',N'Aug 4 2020 12:00AM',1,N'Chi tiêu/mua sắm phôi thẻ, ấn phẩm và dịch vụ thẻ tín dụng năm 2020 (lần 2)',N'Chi tiêu/mua sắm phôi thẻ, ấn phẩm và dịch vụ thẻ tín dụng năm 2020 (lần 2)',N'DV0001',1595592471,NULL,N'1',N'andm',N'Aug 4 2020 12:00AM',N'E',N'vinhlk',N'Aug 4 2020 12:00AM',N'APPROVE',NULL,NULL,N'DV0001',NULL,NULL,N'DEP000000000052',N'DEP000000000052',N'DV0001',N'DEP000000000052',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)
|
3
|
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'PLRDDI001055695',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070107',N'GOO000001062699',N'',N'Phôi thẻ thanh toán - VISA Debit',N'I',N'CMU000000000047',6000,55000.00,330000000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112311',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
4
|
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'PLRDDI001055696',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070100',N'GOO000001062685',N'',N'Chi phí cá thể hóa thẻ VISA',N'I',N'CMU000000000047',6000,16258.00,97548000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112313',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
5
|
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'PLRDDI001055697',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070096',N'GOO000001062677',N'',N'Ấn phẩm thẻ thanh toán - VISA Debit Bao thư thẻ',N'I',N'CMU000000000047',6500,874.50,5684250.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
6
|
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'PLRDDI001055698',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070096',N'GOO000001062677',N'',N'Ấn phẩm thẻ thanh toán - VISA Debit Card Mailer',N'I',N'CMU000000000047',6500,990.00,6435000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
7
|
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'PLRDDI001055699',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070096',N'GOO000001062677',N'',N'Ấn phẩm thẻ thanh toán - VISA Debit HDSD',N'I',N'CMU000000000047',6500,990.00,6435000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
8
|
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'PLRDDI001055700',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070095',N'GOO000001062675',N'',N'Ấn phẩm thẻ dùng chung -Bao thư có cửa sổ',N'I',N'CMU000000000047',6500,874.50,5684250.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
9
|
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'PLRDDI001055701',N'PLRDI0001055407',N'PLM000000016667',N'PLT000000070095',N'GOO000001062675',N'',N'Ấn phẩm thẻ dùng chung - PIN Mailer',N'I',N'CMU000000000047',6500,880.00,5720000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'E',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
10
|
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'PLRDDI001055702',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070109',N'GOO000001062703',N'',N'Phôi thẻ tín dụng - VISA Classic',N'O',N'CMU000000000047',13600,47000.00,639200000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112311',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
11
|
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'PLRDDI001055703',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070109',N'GOO000001062703',N'',N'Phôi thẻ tín dụng - JCB Standard',N'I',N'CMU000000000047',15300,46000.00,703800000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112311',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
12
|
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'PLRDDI001055704',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070101',N'GOO000001062687',N'',N'Chi phí cá thể hóa thẻ VISA',N'O',N'CMU000000000047',3600,16258.00,58528800.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112313',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
13
|
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'PLRDDI001055705',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070101',N'GOO000001062687',N'',N'Chi phí cá thể hóa thẻ JCB',N'O',N'CMU000000000047',5300,16258.00,86167400.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112313',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
14
|
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'PLRDDI001055706',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - VISA Classic',N'O',N'CMU000000000047',14000,874.50,12243000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
15
|
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'PLRDDI001055707',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - VISA Classic',N'O',N'CMU000000000047',14000,990.00,13860000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
16
|
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'PLRDDI001055708',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - VISA Classic',N'O',N'CMU000000000047',14000,990.00,13860000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
17
|
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'PLRDDI001055709',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - JCB Standard',N'O',N'CMU000000000047',15500,874.50,13554750.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
18
|
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'PLRDDI001055710',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - JCB Standard',N'O',N'CMU000000000047',15500,990.00,15345000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
19
|
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'PLRDDI001055711',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',N'',N'Ấn phẩm thẻ tín dụng - JCB Standard',N'O',N'CMU000000000047',15500,990.00,15345000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
20
|
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'PLRDDI001055712',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070095',N'GOO000001062675',N'',N'Ấn phẩm thẻ dùng chung - Bao thư có cửa sổ',N'O',N'CMU000000000047',13500,874.50,11805750.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
21
|
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'PLRDDI001055713',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070095',N'GOO000001062675',N'',N'Ấn phẩm thẻ dùng chung - PIN Mailer',N'O',N'CMU000000000047',13500,880.00,11880000.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112312',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
22
|
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'PLRDDI001055714',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070117',N'GOO000001062719',N'',N'Card verification',N'O',N'CMU000000000047',1,2771.00,2771.00,N'1',N'andm',N'Aug 28 2020 12:00AM',N'U',NULL,NULL,N'DM0000000000009',N'HH0000000112314',N'VND',1.00,0.00,N'',N'VCCB',N'DM0000000000022',N'Cái')
|
23
|
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'PLRC00001055627',N'DM0000000000009',N'PLRDI0001055407',N'',N'E',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,NULL,NULL)
|
24
|
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'PLRC00001055628',N'DM0000000000009',N'PLRDI0001055408',N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,NULL,NULL)
|
25
|
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'PLRTI0001055296',N'PLRDI0001055408',N'PLM000000017146',N'PLT000000072290',N'GOO000001064565',N'DV0001',N'DV0001',N'PLM000000016667',N'PLT000000070109',N'GOO000001062703',0,1016273000.00,N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,N'DM0000000000009',N'DEP000000000051',N'DEP000000000052',N'DM0000000000022',N'DM0000000000008',N'')
|
26
|
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'PLRTI0001055297',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070098',N'GOO000001062681',N'DV0001',N'DV0001',N'PLM000000016667',N'PLT000000070101',N'GOO000001062687',0,92656000.00,N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,N'DM0000000000009',N'DEP000000000051',N'DEP000000000052',N'DM0000000000022',N'DM0000000000009',N'')
|
27
|
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'PLRTI0001055298',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070094',N'GOO000001062673',N'DV0001',N'DV0001',N'PLM000000016667',N'PLT000000070097',N'GOO000001062679',0,215901300.00,N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,N'DM0000000000009',N'DEP000000000051',N'DEP000000000052',N'DM0000000000022',N'DM0000000000009',N'')
|
28
|
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'PLRTI0001055299',N'PLRDI0001055408',N'PLM000000016667',N'PLT000000070094',N'GOO000001062673',N'DV0001',N'DV0001',N'PLM000000016667',N'PLT000000070095',N'GOO000001062675',0,39142000.00,N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,N'DM0000000000009',N'DEP000000000051',N'DEP000000000052',N'DM0000000000022',N'DM0000000000009',N'')
|
29
|
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'PLRTI0001055300',N'PLRDI0001055408',N'PLM000000017146',N'PLT000000072290',N'GOO000001064565',N'DV0001',N'DV0001',N'PLM000000016667',N'PLT000000070117',N'GOO000001062719',0,65000000.00,N'',N'U',N'andm',N'Aug 28 2020 12:00AM',NULL,NULL,N'DM0000000000009',N'DEP000000000051',N'DEP000000000052',N'DM0000000000022',N'DM0000000000008',N'')
|