Project

General

Profile

Bug #1505

Vận Hành VB GOLIVE 19/04/2023

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

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

0%

Estimated time:
update_fix_pyc_05.txt (371 Bytes) update_fix_pyc_05.txt Luc Tran Van, 04/19/2023 09:03 AM
VALIDATE_PHIEU_REJECT.txt (17 KB) VALIDATE_PHIEU_REJECT.txt Luc Tran Van, 04/19/2023 09:20 AM
UPDATE_SERI.txt (336 Bytes) UPDATE_SERI.txt Luc Tran Van, 04/19/2023 09:44 AM
update_sys_prefix.txt (203 Bytes) update_sys_prefix.txt Luc Tran Van, 04/19/2023 01:42 PM
UPDATE KHAU HAO.txt (25.3 KB) UPDATE KHAU HAO.txt Luc Tran Van, 04/19/2023 04:05 PM
SYS_CODEMASTERS_UPD_ALL_TABLE.txt (3.39 KB) SYS_CODEMASTERS_UPD_ALL_TABLE.txt Luc Tran Van, 04/19/2023 04:33 PM
UPDATE KHAU HAO 2.txt (25.4 KB) UPDATE KHAU HAO 2.txt Luc Tran Van, 04/19/2023 05:10 PM
rpt_ass_entries_post_lst-15b0a8d7-03fc-477e-851b-32b5dd1924b2.xlsx (4 MB) rpt_ass_entries_post_lst-15b0a8d7-03fc-477e-851b-32b5dd1924b2.xlsx Luc Tran Van, 04/19/2023 05:32 PM
rpt_ass_entries_post_lst-7e154407-b983-47d3-94db-75f87eb11ed8.xlsx (4 MB) rpt_ass_entries_post_lst-7e154407-b983-47d3-94db-75f87eb11ed8.xlsx Luc Tran Van, 04/19/2023 05:35 PM
UPDATE KHAU HAO 3.txt (25.4 KB) UPDATE KHAU HAO 3.txt Luc Tran Van, 04/20/2023 09:10 AM
UPDATE KHAU HAO 4.txt (11.9 KB) UPDATE KHAU HAO 4.txt Luc Tran Van, 04/20/2023 09:30 AM
ALTER PROCEDURE AMORT.txt (16.4 KB) ALTER PROCEDURE AMORT.txt Luc Tran Van, 04/20/2023 09:53 AM
UPDATE KHAU HAO 5.txt (695 Bytes) UPDATE KHAU HAO 5.txt Luc Tran Van, 04/20/2023 10:29 AM
UPDATE KHAU HAO 6.txt (50 KB) UPDATE KHAU HAO 6.txt Luc Tran Van, 04/20/2023 02:29 PM
rpt_ass_master.xlsx (13.5 KB) rpt_ass_master.xlsx Luc Tran Van, 04/20/2023 02:29 PM

History

#15 Updated by Luc Tran Van about 2 years ago

INSERT INTO ASS_AMORT_DT_LATEST (AMORTDT_ID, AMORT_ID, AMORT_DT, CRDR, BRANCH_ID, DEP_ID, ASSET_ID, AMORT_AMT, GROUP_ID, EXECUTED, TRN_TYPE, TRN_DESC, TYPE_ID)
SELECT aad.AMORTDT_ID
,aad.AMORT_ID
,aad.AMORT_DT
,aad.CRDR
,aad.BRANCH_ID
,aad.DEP_ID
,aad.ASSET_ID
,aad.AMORT_AMT
,aad.GROUP_ID
,aad.EXECUTED
,aad.TRN_TYPE
,aad.TRN_DESC,'CCLD' FROM ASS_AMORT_DT aad

Also available in: Atom PDF