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

INSERT INTO [TR_REQ_ADVANCE_DT] ([REQ_PAYDTID],[REQ_PAY_ID],[REF_ID],[TYPE],[MAKER_ID],[CREATE_DT],[IS_CLOSED],[REF_TYPE])VALUES(N'TUPO00001102349',N'TADY00001119527',N'TRC000001127269',N'ADV_PAY',N'tuyenlt',N'Jun 25 2020 12:00AM',N'N',N'C')

INSERT INTO [TR_REQ_ADVANCE_PAYMENT] ([REQ_PAY_ID],[REQ_PAY_CODE],[BRANCH_ID],[DEP_ID],[REQ_REASON],[REQ_TYPE],[REQ_ENTRIES],[REQ_DESCRIPTION],[REF_ID],[PAY_PHASE],[RECEIVER_DEBIT],[RECEIVER_PO],[REQ_PAY_TYPE],[REQ_TYPE_CURRENCY],[REQ_AMT],[REQ_TEMP_AMT],[MAKER_ID],[CREATE_DT],[EDITOR_ID],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CREATE_DT_KT],[MAKER_ID_KT],[AUTH_STATUS_KT],[CHECKER_ID_KT],[APPROVE_DT_KT],[CONFIRM_NOTES],[BRANCH_CREATE],[NOTES],[RECORD_STATUS],[TRANSFER_MAKER],[TRANSFER_DT],[TRASFER_USER_RECIVE],[PROCESS],[REQ_DT],[PAY_AMT],[DVDM_ID],[RATE],[RECIVER_MONEY],[IS_PERIOD])VALUES(N'TADY00001119527',N'062020/089373',N'DV0001',N'DEP000000000014',N'Tạm ứng 30% Đơn đặt hàng 16 máy in thẻ Datacard SD260L',N'P',N'',N'',N'',NULL,N'',N'',N'1',N'VND',179520000.00,0.00,N'tuyenlt',N'Jun 25 2020 12:00AM',N'',N'A',N'huongvt',N'Jun 25 2020 12:00AM',NULL,N'',N'',N'',NULL,N'',N'DV0001',N'',N'1',NULL,NULL,N'',N'',N'2020-06-25',0,NULL,NULL,N'',N'N')

INSERT INTO [TR_REQ_PAY_METHOD] ([METHOD_ID],[REQ_PAY_ID],[EMP_ID],[REQ_PAY_REASON],[TOTAL_AMT],[REQ_PAY_TYPE],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[TEMP],[MAKER_ID],[CREATE_DT],[ACC_NO],[ACC_NAME],[ISSUED_BY],[ISSUED_DT],[CURRENCY],[RATE],[CHECK_IN],[TYPE_TRANSFER])VALUES(N'TRPMT0001120220',N'TADY00001119527',N'',N'Tạm ứng 30% Đơn đặt hàng 16 máy in thẻ Datacard SD260L',179520000,N'1',N'',N'',NULL,NULL,N'Jun 25 2020 12:00AM',NULL,NULL,NULL,NULL,N'VND',1,N'l',NULL)

INSERT INTO [TR_REQ_PAY_SCHEDULE] ([SCHEDULE_ID],[REQ_PAY_ID],[PAY_ID],[PAY_PHASE],[AMT_PAY],[REQ_ADV_ID],[AMT_ADVANCE],[AMT_PAY_DO],[AMT_REMAIN],[REQ_PAY_DT],[REQ_AD_DT],[PROCESS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS_KT],[PAYMENT_STATUS],[TRN_TYPE],[REF_ID],[REQ_PAY_DESC],[REQ_PAY_ENTRIES],[CURRENCY],[RATE],[AMT_PAY_REAL])VALUES(N'TRPSC0001105566',N'TADY00001119527',NULL,NULL,NULL,N'',NULL,NULL,NULL,N'Jun 25 2020 12:00AM',N'Aug 20 2020 11:00AM',N'',N'tuyenlt',N'Jun 25 2020 12:00AM',N'A',N'',N'',N'TRC000001127269',N'Tạm ứng 30% Đơn đặt hàng 16 máy in thẻ Datacard SD260L',N'',N'VND',NULL,179520000.00)

UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=20 WHERE PAY_ID='TRCPI0001127111'

UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=24 WHERE PAY_ID='TRCPI0001127112'

UPDATE dbo.TR_CONTRACT_PAYMENT SET [PERCENT]=54 WHERE PAY_ID='TRCPI0001127113'