Project

General

Profile

Bug #1524

Vận hành VB GOLIVE 04/05/2023

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
05/04/2023
Due date:
% Done:

0%

Estimated time:
BM_PYC.docx (35.3 KB) BM_PYC.docx Luc Tran Van, 05/04/2023 10:38 AM
BM_PYC_DCTS.docx (34.5 KB) BM_PYC_DCTS.docx Luc Tran Van, 05/04/2023 10:38 AM
BM_PYC_SC.docx (33.8 KB) BM_PYC_SC.docx Luc Tran Van, 05/04/2023 10:38 AM
BM_PYC_TH.docx (34 KB) BM_PYC_TH.docx Luc Tran Van, 05/04/2023 10:38 AM
SEARCH_PYC.txt (70.3 KB) SEARCH_PYC.txt Luc Tran Van, 05/04/2023 10:38 AM
UPDATE_PYC.txt (129 KB) UPDATE_PYC.txt Luc Tran Van, 05/04/2023 10:38 AM
UPDATE_CHUC_DANH.txt (510 KB) UPDATE_CHUC_DANH.txt Luc Tran Van, 05/04/2023 11:07 AM
UPDATE_MAYDEMTIENDAI.txt (601 Bytes) UPDATE_MAYDEMTIENDAI.txt Luc Tran Van, 05/04/2023 11:36 AM
compare.txt (564 KB) compare.txt Luc Tran Van, 05/04/2023 01:22 PM
SEARCH_PYC_1.txt (32.2 KB) SEARCH_PYC_1.txt Luc Tran Van, 05/04/2023 01:51 PM
valudate_DCNB.txt (5.47 KB) valudate_DCNB.txt Luc Tran Van, 05/04/2023 02:26 PM
SCRIPT_GET_DATA.txt (1.01 KB) SCRIPT_GET_DATA.txt Luc Tran Van, 05/04/2023 04:04 PM
DATA_DEN_04052023.xlsx (415 KB) DATA_DEN_04052023.xlsx Luc Tran Van, 05/04/2023 04:25 PM
TL_IMPORT.txt (5.49 KB) TL_IMPORT.txt Luc Tran Van, 05/04/2023 05:34 PM
THANHLY.xlsx (21.2 KB) THANHLY.xlsx Luc Tran Van, 05/04/2023 06:01 PM
DATA_DEN_04052023.xlsx (415 KB) DATA_DEN_04052023.xlsx Luc Tran Van, 05/04/2023 06:01 PM

History

#10 Updated by Luc Tran Van about 2 years ago

UPDATE A SET A.BRANCH_ID_USE = B.BRANCH_ID, A.DEP_ID_USE = B.DEPT_ID,A.LIQ_REQ_ID = ''
FROM ASS_LIQUIDATION_DT A
LEFT JOIN ASS_MASTER B ON A.ASSET_ID = B.ASSET_ID
WHERE A.LIQ_ID = ''

Also available in: Atom PDF