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

 

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_MASTER',            -- varchar(776)

                             @from = 'FROM TR_PO_MASTER'                 -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_DETAIL',            -- varchar(776)

                             @from = 'FROM TR_PO_DETAIL'                 -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'TR_PO_PAYMENT',            -- varchar(776)

                             @from = 'FROM TR_PO_PAYMENT'                 -- varchar(800)

Trạng thái: Select thành công 

Column1 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000000001',N'PO069/18/0001',N'PO mẫu để nhập tài sản',NULL,N'CMS000000000018',NULL,N'LAU 7, SO 278, NAM KY KHOI NGHIA, P8, Q3',N'Jun 19 2018 1:24PM',N'Jan 1 1900 12:00AM',159455000,NULL,NULL,NULL,NULL,N'1',N'thieuvq',N'Jun 19 2018 2:20PM',N'A',N'tscd_hoiso',N'Jun 19 2018 2:21PM',1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251002',N'PO069/20/0001',N'',NULL,N'CMS000000251002',NULL,N'',N'Aug 17 2020 2:32PM',N'Jan 1 1900 12:00AM',9000000,N'TRRD00001124102',N'Jul 21 2020 12:00AM',NULL,NULL,N'1',N'cuongvd',N'Aug 17 2020 2:47PM',N'A',NULL,N'Jan 1 1900 12:00AM',0,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251003',N'PO069/20/0002',N'Máy scan',NULL,N'CMS000001126240',NULL,N'',N'Aug 21 2020 9:31AM',N'Jan 1 1900 12:00AM',9200000,N'TRRDI0001124235',N'Jun 24 2020 12:00AM',N'Jul 16 2020 12:00AM',NULL,N'1',N'quanvta',N'Aug 21 2020 9:34AM',N'A',N'vanpt2',N'Aug 21 2020 9:42AM',NULL,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251004',N'PO069/20/0003',N'Khai trương PGD Trảng Bàng',NULL,N'CMS000000251071',NULL,N'SỐ B1/17A, ẤP LONG THỚI, XÃ LONG THÀNH TRUNG, HÒA THÀNH, TÂY NINH',N'Aug 12 2020 12:00AM',N'Jan 1 1900 12:00AM',23804550,N'TRRDI0001124236',NULL,NULL,NULL,N'1',N'quanvta',N'Aug 24 2020 1:16PM',N'A',N'vanpt2',N'Aug 24 2020 1:21PM',NULL,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251005',N'PO069/20/0004',N'Mua sắm CCDC',N'',N'CMS000000251151',NULL,NULL,N'Aug 25 2020 1:55PM',NULL,4455000,N'TRRD00000251001',NULL,NULL,N'',N'1',N'baotq',N'Aug 25 2020 1:55PM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251007',N'PO069/20/0005',N'Mua dây HDMI unitek 5m19a (5m) thay cho phòng họp lầu 10',N'',N'CMS000000251190',NULL,NULL,N'Aug 27 2020 3:06PM',NULL,140000,N'TRRD00000251016',NULL,NULL,N'',N'1',N'dungltm',N'Aug 27 2020 3:06PM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251008',N'PO069/20/0006',N'Mua voucher minigame nội bộ mở tài khoản thanh toán "Gửi người thương nhớ"',N'TRCI00001055215',N'CMS000001126267',NULL,NULL,N'Aug 28 2020 8:54AM',NULL,10000000,N'TRRDI0001056085',NULL,NULL,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251009',N'PO069/20/0007',N'Mua vouchers tặng thưởng cho việc triển khai hoạt động tăng độ nhận biết và gắn kết thương hiệu T6/2',N'TRCI00001055215',N'CMS000001126267',NULL,NULL,N'Aug 28 2020 8:54AM',NULL,6000000,N'TRRDI0001056090',NULL,NULL,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251010',N'PO069/20/0008',N'Mua voucher mua sắm quà tặng khách hàng nhân ngày gia đình Việt Nam',N'TRCI00001055215',N'CMS000001126267',NULL,NULL,N'Aug 28 2020 8:54AM',NULL,7000000,N'TRRDI0001056091',NULL,NULL,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251011',N'PO069/20/0009',N'Quà tặng Mini game cho khách hàng trong hoạt động truyền thông ra mắt thẻ',N'TRCI00001055215',N'CMS000001126267',NULL,NULL,N'Aug 28 2020 8:54AM',NULL,6600000,N'TRRDI0001056088',NULL,NULL,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'A',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251012',N'PO069/20/0010',N'Nạp tiền SIM 4G sử dụng cho máy POS tờ trình 057/2020/TTr-TTT',NULL,N'CMS000000251234',NULL,N'Số 25 Đường Cách Mạng Tháng Tám, Phường 12, Quận 10, Thành phố Hồ Chí Minh, Việt Nam',N'Sep 1 2020 10:13AM',N'Jan 1 1900 12:00AM',4800000,N'TRRDII001055328',N'Nov 6 2020 12:00AM',N'Nov 6 2020 12:00AM',NULL,N'1',N'andm',N'Sep 3 2020 8:05AM',N'A',N'andm',N'Sep 3 2020 11:02AM',0,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251006',N'PO002/20/0001',N'VE SINH SANH BVB DSG',N'',N'',NULL,NULL,N'Aug 25 2020 3:36PM',NULL,990000,N'TRRD00000251009',NULL,NULL,N'',N'1',N'minhnxq',N'Aug 25 2020 3:36PM',N'A',NULL,NULL,1,N'BRN000000000389',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251014',N'PO069/20/0012',N'Mua 15 chỉ vàng trao thưởng cho các ĐVKD đạt thưởng chương trình Hot contest từ tháng 6 tới tháng 8',N'',N'CMS000000251222',NULL,NULL,N'Sep 1 2020 4:26PM',NULL,81300000,N'TRRD00000251012',NULL,NULL,N'',N'1',N'quanvta',N'Sep 1 2020 4:26PM',N'E',NULL,NULL,1,N'DV0001',NULL,NULL) 

INSERT INTO [TR_PO_MASTER] ([PO_ID],[PO_CODE],[PO_NAME],[CONTRACT_ID],[SUP_ID],[SUP_NAME],[SUP_ADDR],[INPUT_DT],[PAYMENT_DT],[TOTAL_AMT],[REQ_DOC_ID],[DELIVERY_DT],[PAYAPP_DT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[PO_TYPE],[BRANCH_ID],[IS_CLOSED],[AMT_ADD])VALUES(N'TRPM00000251015',N'PO069/20/0013',N'Nạp tiền SIM 4G sử dụng cho máy POS theo tờ trình 204/2019/TTr-TTT',NULL,N'CMS000000251234',NULL,N'Số 25 Đường Cách Mạng Tháng Tám, Phường 12, Quận 10, Thành phố Hồ Chí Minh, Việt Nam',N'Sep 3 2020 8:21AM',N'Jan 1 1900 12:00AM',11200000,N'TRRDII001055329',NULL,NULL,NULL,N'1',N'andm',N'Sep 3 2020 11:17AM',N'A',N'andm',N'Sep 3 2020 11:26AM',0,N'DV0001',NULL,NULL) 

Column1 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000000001',N'TRPM00000000001',N'PLM000000000169',N'',N'GOO000000000260',N'',N'CMU000000000001',5,9191000,45955000,N'1',N'Jun 15 2018 12:00AM',N'CTT',0,NULL,N'0001234',N'',N'DV0001',N'TOA NHA HM TOWN 412 NGUYEN THI MINH KHAI, PHUONG 5, QUAN 3, TP. HCM',N'',N'',N'1',N'thieuvq',N'Jun 19 2018 2:20PM',N'U',N'thieuvq',N'Jun 19 2018 1:52PM',NULL,N'Laptop Lenovo V310',N'Mar 4 2018 12:00AM',N'GDRT00000000002',0.00,0,N'',NULL,NULL,NULL) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000000002',N'TRPM00000000001',N'PLM000000000169',N'',N'GOO000000000313',N'',N'CMU000000000001',1,5100000,5100000,N'1',N'Jun 15 2018 12:00AM',N'CTT',0,NULL,N'0001234',N'',N'DV0001',N'TOA NHA HM TOWN 412 NGUYEN THI MINH KHAI, PHUONG 5, QUAN 3, TP. HCM',N'',N'',N'1',N'thieuvq',N'Jun 19 2018 2:20PM',N'U',N'thieuvq',N'Jun 19 2018 1:52PM',NULL,N'Máy in Canon LPB3300',N'Mar 4 2018 12:00AM',N'GDRT00000000002',0.00,0,N'',NULL,NULL,NULL) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000000003',N'TRPM00000000001',N'PLM000000000169',N'',N'GOO000000000005',N'',N'CMU000000000001',10,10840000,108400000,N'1',N'Jun 15 2018 12:00AM',N'CTT',0,NULL,N'0001234',N'',N'DV0001',N'TOA NHA HM TOWN 412 NGUYEN THI MINH KHAI, PHUONG 5, QUAN 3, TP. HCM',N'',N'',N'1',N'thieuvq',N'Jun 19 2018 2:20PM',N'U',N'thieuvq',N'Jun 19 2018 1:52PM',NULL,N'Desktop lenovo V520s',N'Mar 4 2018 12:00AM',N'GDRT00000000002',0.00,0,N'',NULL,NULL,NULL) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251004',N'TRPM00000251002',N'',N'',N'HH0000000112275',N'Theo báo giá',N'',1,9000000,9000000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'DV0001',N'Tòa nhà HM Town 412 Nguyễn Thị Minh Khai, P.5, Q.3, TP.HCM',N'',N'',N'E',N'cuongvd',N'Aug 17 2020 2:47PM',N'E',NULL,N'Jan 1 1900 12:00AM',NULL,N'Quảng cáo Digital',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,9000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251008',N'TRPM00000251004',N'',N'',N'HH0000000112280',N'Khai trương PGD Trảng Bàng',N'',1,23804550,23804550,N'0',NULL,N'CTT',0,NULL,N'',N'',N'BRN000000001838',N'16-17 Quốc lộ 22, Khu phố Lộc An, Phường Trảng Bàng, Thị xã Trảng Bàng, Tỉnh Tây Ninh',N'',N'',N'U',N'quanvta',N'Aug 24 2020 1:16PM',N'U',NULL,N'Jan 1 1900 12:00AM',N'Aug 12 2020 12:00AM',N'Tổ chức sự kiện khai trương',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,23804550.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251009',N'TRPM00000251005',N'',N'',N'HH0000000112051',N'NOYAFA NF-300',N'',3,1485000,4455000,N'',NULL,N'CTT',NULL,NULL,N'',N'NOYAFA NF-300',N'DV0001',N'',N'',N'',N'',N'baotq',N'Aug 25 2020 1:55PM',N'',N'',NULL,NULL,N'Bộ test cáp',NULL,N'HHT000000000006',0.00,0,N'',N'VND',1,4500000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251010',N'TRPM00000251006',N'',N'',N'HH0000000112186',N'THEO BAO GIA',N'',1,990000,990000,N'',NULL,N'CTT',NULL,NULL,N'',N'THEO BAO GIA',N'BRN000000000389',N'',N'',N'',N'',N'minhnxq',N'Aug 25 2020 3:36PM',N'',N'',NULL,NULL,N'Dịch vụ vệ sinh trụ sở',NULL,N'HHT000000000022',0.00,0,N'',N'VND',1,990000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251011',N'TRPM00000251007',N'',N'',N'HH0000000112175',N'CÁP HDMI UNITEK 5M19A',N'',1,140000,140000,N'',NULL,N'CTT',NULL,NULL,N'',N'CÁP HDMI UNITEK 5M19A',N'DV0001',N'',N'',N'',N'',N'dungltm',N'Aug 27 2020 3:06PM',N'',N'',NULL,NULL,N'Dây HDMI',NULL,N'HHT000000000021',0.00,0,N'',N'VND',1,140000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251012',N'TRPM00000251008',N'',N'',N'HH0000000112268',NULL,N'',1,10000000,10000000,N'',NULL,N'CTT',NULL,NULL,N'',NULL,N'',N'',N'',N'',N'',N'phuongvn',N'Aug 28 2020 8:54AM',N'',N'',NULL,NULL,N'Hoạt động truyền thông nội bộ',NULL,N'HHT000000000030',0.00,0,N'',N'VND',1,10000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251013',N'TRPM00000251009',N'',N'',N'HH0000000112268',NULL,N'',1,6000000,6000000,N'',NULL,N'CTT',NULL,NULL,N'',NULL,N'',N'',N'',N'',N'',N'phuongvn',N'Aug 28 2020 8:54AM',N'',N'',NULL,NULL,N'Hoạt động truyền thông nội bộ',NULL,N'HHT000000000030',0.00,0,N'',N'VND',1,6000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251014',N'TRPM00000251010',N'',N'',N'HH0000000112289',NULL,N'',1,7000000,7000000,N'',NULL,N'CTT',NULL,NULL,N'',NULL,N'',N'',N'',N'',N'',N'phuongvn',N'Aug 28 2020 8:54AM',N'',N'',NULL,NULL,N'Quà tặng',NULL,N'HHT000000000032',0.00,0,N'',N'VND',1,7000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251015',N'TRPM00000251011',N'',N'',N'HH0000000112297',NULL,N'',1,6600000,6600000,N'',NULL,N'CTT',NULL,NULL,N'',NULL,N'',N'',N'',N'',N'',N'phuongvn',N'Aug 28 2020 8:54AM',N'',N'',NULL,NULL,N'Truyền thông sản phẩm dịch vụ',NULL,N'HHT000000000024',0.00,0,N'',N'VND',1,6600000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251024',N'TRPM00000251012',N'',N'',N'HH0000000112222',N'Nạp tiền SIM 4G cho POS',N'',480,10000,4800000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'DV0001',N'Tòa nhà HM Town 412 Nguyễn Thị Minh Khai, P.5, Q.3, TP.HCM',N'Mai Anh Tú',N'0923925927',N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',NULL,N'Sim card điện thoại',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,4800000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251006',N'TRPM00000251003',N'',N'',N'HH0000000112065',N'HP scnajet Pro 3000S4',N'',1,9200000,9200000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'BRN000000000433',N'487 Hùng Vương, P.An Lạc, thị xã Buôn Hồ, TP.Buôn Ma Thuột, tỉnh ĐăkLăk',N'',N'',N'U',N'quanvta',N'Aug 21 2020 9:34AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'Jul 20 2020 12:00AM',N'Máy scan',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,9200000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251016',N'TRPM00000251014',N'',N'',N'HH0000000103527',N'Vàng PNJ 24K loại 1 chỉ',N'',5,5420000,27100000,N'',NULL,N'CTT',NULL,NULL,N'',N'Vàng PNJ 24K loại 1 chỉ',N'DV0001',N'',N'',N'',N'',N'quanvta',N'Sep 1 2020 4:26PM',N'',N'',NULL,NULL,N'Vàng',NULL,N'HHT000000000024',0.00,0,N'',N'VND',1,31000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251017',N'TRPM00000251014',N'',N'',N'HH0000000103527',N'Vàng PNJ 24K loại 0.5 chỉ',N'',20,2710000,54200000,N'',NULL,N'CTT',NULL,NULL,N'',N'Vàng PNJ 24K loại 0.5 chỉ',N'DV0001',N'',N'',N'',N'',N'quanvta',N'Sep 1 2020 4:26PM',N'',N'',NULL,NULL,N'Vàng',NULL,N'HHT000000000024',0.00,0,N'',N'VND',1,62000000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251028',N'TRPM00000251015',N'',N'',N'HH0000000112222',N'SIM 4G Viettel',N'',50,50000,2500000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'DV0001',N'Tòa nhà HM Town 412 Nguyễn Thị Minh Khai, P.5, Q.3, TP.HCM',N'Mai Anh Tú',N'0923925927',N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'Sim card điện thoại',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,2500000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251029',N'TRPM00000251015',N'',N'',N'HH0000000112222',N'Nạp tiền SIM 4G cho máy POS (70 SIM từ tháng 3 đến hết tháng 8/2020)',N'',420,10000,4200000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'DV0001',N'Tòa nhà HM Town 412 Nguyễn Thị Minh Khai, P.5, Q.3, TP.HCM',N'Mai Anh Tú',N'0923925927',N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'Sim card điện thoại',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,4200000.00) 

INSERT INTO [TR_PO_DETAIL] ([PD_ID],[PO_ID],[PLAN_ID],[TRADE_ID],[GOODS_ID],[DESCRIPTION],[UNIT_ID],[QUANTITY],[PRICE],[TOTAL_AMT],[IS_DELIVERY],[DELIVERY_DT],[PAYMENT_STATUS],[AMOUNT_PAID],[PAID_DT],[INVOICENO],[NOTES],[RECEIVE_BRANCH],[RECEIVE_ADDR],[RECEIVE_PERSON],[RECEIVE_TEL],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[EXP_DELIVERY_DT],[GOODS_NAME],[INVOICE_DT],[GOODSTYPE_REAL],[VAT],[PRICE_VAT],[CONTRACT_DT],[CURRENCY],[RATE],[TOTAL_AMT_FN])VALUES(N'TRPD00000251030',N'TRPM00000251015',N'',N'',N'HH0000000112222',N'Nạp tiền SIM 4G cho máy POS (50 SIM từ tháng 12/2019 đến hết tháng 8/2020)',N'',450,10000,4500000,N'0',NULL,N'CTT',0,NULL,N'',N'',N'DV0001',N'Tòa nhà HM Town 412 Nguyễn Thị Minh Khai, P.5, Q.3, TP.HCM',N'Mai Anh Tú',N'0923925927',N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'Sim card điện thoại',NULL,N'GDRT00000251003',0.00,0,N'',N'VND',1,4500000.00) 

Column1 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251001',N'TRPM00000251002',N'1',N'Aug 17 2020 12:00AM',100,9000000,NULL,N'E',N'cuongvd',N'Aug 17 2020 2:47PM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,9000000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251003',N'TRPM00000251003',N'1',N'Aug 21 2020 12:00AM',100,9200000,NULL,N'U',N'quanvta',N'Aug 21 2020 9:34AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,9200000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251005',N'TRPM00000251004',N'1',N'Aug 24 2020 12:00AM',100,23804550,NULL,N'U',N'quanvta',N'Aug 24 2020 1:16PM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,23804550.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251006',N'TRPM00000251005',N'1',N'Aug 25 2020 1:55PM',100,4455000,N'',N'1',N'baotq',N'Aug 25 2020 1:55PM',N'U',N'',NULL,N'VND',1,4455000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251010',N'TRPM00000251007',N'1',N'Aug 27 2020 3:06PM',100,140000,N'',N'1',N'dungltm',N'Aug 27 2020 3:06PM',N'U',N'',NULL,N'VND',1,140000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251012',N'TRPM00000251008',N'1',N'Aug 28 2020 8:54AM',100,10000000,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'U',N'',NULL,N'VND',1,10000000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251014',N'TRPM00000251009',N'1',N'Aug 28 2020 8:54AM',100,6000000,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'U',N'',NULL,N'VND',1,6000000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251016',N'TRPM00000251010',N'1',N'Aug 28 2020 8:54AM',100,7000000,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'U',N'',NULL,N'VND',1,7000000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251018',N'TRPM00000251011',N'1',N'Aug 28 2020 8:54AM',100,6600000,N'',N'1',N'phuongvn',N'Aug 28 2020 8:54AM',N'U',N'',NULL,N'VND',1,6600000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251058',N'TRPM00000251012',N'1',N'Jun 17 2020 12:00AM',15,699840,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251059',N'TRPM00000251012',N'2',N'Sep 3 2020 12:00AM',10,500160,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251060',N'TRPM00000251012',N'3',N'Sep 3 2020 12:00AM',15,699840,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251061',N'TRPM00000251012',N'4',N'Oct 15 2020 12:00AM',21,999840,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251062',N'TRPM00000251012',N'5',N'Dec 15 2020 12:00AM',15,699840,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251063',N'TRPM00000251012',N'6',N'Aug 28 2020 12:00AM',25,1200000,NULL,N'E',N'andm',N'Sep 3 2020 8:05AM',N'E',NULL,N'Jan 1 1900 12:00AM',N'',1,4800000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251008',N'TRPM00000251006',N'1',N'Aug 25 2020 3:36PM',100,990000,N'',N'1',N'minhnxq',N'Aug 25 2020 3:36PM',N'U',N'',NULL,N'VND',1,990000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251020',N'TRPM00000251014',N'1',N'Sep 1 2020 4:26PM',100,54200000,N'',N'1',N'quanvta',N'Sep 1 2020 4:26PM',N'U',N'',NULL,N'VND',1,54200000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251070',N'TRPM00000251015',N'1',N'Dec 24 2019 12:00AM',22,2499840,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251071',N'TRPM00000251015',N'2',N'Dec 24 2019 12:00AM',21,2400160,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251072',N'TRPM00000251015',N'3',N'Feb 12 2020 12:00AM',21,2400160,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251073',N'TRPM00000251015',N'4',N'Apr 20 2020 12:00AM',21,2400160,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251074',N'TRPM00000251015',N'5',N'Jun 29 2020 12:00AM',9,1000160,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

INSERT INTO [TR_PO_PAYMENT] ([PAY_ID],[PO_ID],[PAY_PHASE],[EXP_DT],[PERCENT],[AMOUNT],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENCY],[RATE],[TOTAL_AMT])VALUES(N'TRPP00000251075',N'TRPM00000251015',N'6',N'Sep 3 2020 12:00AM',4,499520,NULL,N'U',N'andm',N'Sep 3 2020 11:17AM',N'U',NULL,N'Jan 1 1900 12:00AM',N'',1,4500000.00) 

Result ErrorDesc 

SUCCESSFULL