Project

General

Profile

Feature #1549

VẬN HÀNH DỰ ÁN SAU GOLIVE NGÀY 10.07.2023

Added by Luc Tran Van almost 2 years ago. Updated almost 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
07/10/2023
Due date:
% Done:

0%

Estimated time:
1.0. PAYMENT CHECK CAPEX.txt (2.03 KB) 1.0. PAYMENT CHECK CAPEX.txt Luc Tran Van, 07/10/2023 09:51 AM
DATA_BUDGET.xlsx (35.1 KB) DATA_BUDGET.xlsx Luc Tran Van, 07/10/2023 11:31 AM
DONVI.xlsx (10.9 KB) DONVI.xlsx Luc Tran Van, 07/10/2023 11:31 AM
search_pdn_tt.txt (87.3 KB) search_pdn_tt.txt Luc Tran Van, 07/13/2023 02:13 PM
search_pdntt_2.txt (87.5 KB) search_pdntt_2.txt Luc Tran Van, 07/13/2023 02:59 PM
script_alter_stored_pdntt_130723.txt (47.6 KB) script_alter_stored_pdntt_130723.txt Luc Tran Van, 07/13/2023 03:02 PM
check_limit_budget.txt (7.23 KB) check_limit_budget.txt Luc Tran Van, 07/13/2023 03:43 PM
Dieu chuyen han muc.7z (1.65 KB) Dieu chuyen han muc.7z Luc Tran Van, 07/13/2023 05:14 PM
Dieu chuyen han muc.zip (2.68 KB) Dieu chuyen han muc.zip Luc Tran Van, 07/13/2023 05:14 PM
script_update_180723.txt (99.5 KB) script_update_180723.txt Luc Tran Van, 07/18/2023 12:10 AM
script_upd_material.txt (26.8 KB) script_upd_material.txt Luc Tran Van, 07/18/2023 09:53 AM
New Text Document.HTML (168 KB) New Text Document.HTML Luc Tran Van, 07/20/2023 10:31 AM
New Text Document.txt (168 KB) New Text Document.txt Luc Tran Van, 07/20/2023 10:32 AM
request_template_data.txt (206 KB) request_template_data.txt Luc Tran Van, 07/20/2023 10:38 AM

History

#1 Updated by Luc Tran Van almost 2 years ago

UPDATE PL_APPOINT_CONTRACTOR SET AUTH_STATUS='A', PROCESS_ID ='APPROVE' WHERE REQ_CODE ='000059/2023/TTr-PHC-BP.MH'

#3 Updated by Luc Tran Van almost 2 years ago

DECLARE @REQ_PAY_CODE VARCHAR = '032023/000723'
DECLARE @REQ_PAY_ID VARCHAR = (SELECT TOP 1 REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE = @REQ_PAY_CODE)

SELECT * FROM TR_REQ_PAYMENT WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = @REQ_PAY_ID
SELECT * FROM TR_REQ_BUDGET_YEAR_LIMIT_DETAIL WHERE REQ_PAY_ID = @REQ_PAY_ID

#5 Updated by Luc Tran Van almost 2 years ago

000059/2023/TTr-P.HC-BP.MH

#6 Updated by Luc Tran Van almost 2 years ago

SELECT pac.AUTH_STATUS FROM PL_APPOINT_CONTRACTOR pac WHERE pac.REQ_CODE = '000059/2023/TTr-P.HC-BP.MH'

#7 Updated by Luc Tran Van almost 2 years ago

UPDATE PL_APPOINT_CONTRACTOR SET AUTH_STATUS='A', PROCESS_ID ='APPROVE' WHERE REQ_CODE ='000059/2023/TTr-P.HC-BP.MH'

#8 Updated by Luc Tran Van almost 2 years ago

DelayDateWarningMessage
Bạn có đồng ý lùi ngày

#17 Updated by Luc Tran Van almost 2 years ago

ORA-06512: at "FCUBSIT2.VCCBPKS_ASSET_MANAGEMENT", line 560

#18 Updated by Luc Tran Van almost 2 years ago

requestBody:<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:alsb="http://www.alsb.com/">
<soapenv:Header/><soapenv:Body><alsb:TranMultiOffsetRequest><PLocalBranch>069</PLocalBranch><PCcy>VND</PCcy><PExcRate>1</PExcRate><PDrCr>C</PDrCr><PMainAccBrn>069</PMainAccBrn><PMainAccount>0697044000019</PMainAccount><PMainAmount>3609650</PMainAmount><LstPTxnOffset><PTxnOffset><OffsetAccount>861200002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>455000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>120000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>353200002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>328150</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>86910003</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>1103500</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861200002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>325000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861200002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>650000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861200002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>325000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100001</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>119000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100001</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>58500</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100002</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>58000</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100001</OffsetAccount><OffsetBranch>069</OffsetBranch><OffsetAmount>28500</OffsetAmount></PTxnOffset><PTxnOffset><OffsetAccount>861100001</OffsetAccount><OffsetBranch>011</OffsetBranch><OffsetAmount>39000</OffsetAmount></PTxnOffset></LstPTxnOffset><PNarrative>CN VUNG TAU - THANH TOAN CHI PHI VAN PHONG PHAM THANG 06.2023 THEO GDNTT 072023/000432</PNarrative><PMaker>hailtt</PMaker><PChecker>nghihm</PChecker></alsb:TranMultiOffsetRequest></soapenv:Body></soapenv:Envelope>

Also available in: Atom PDF