AMS - VB

05/23/2023

11:19 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

SELECT * FROM CM_ATTACH_FILE CAF WHERE CAF.REF_MASTER = 'TRSD00000000180' Luc Tran Van

11:05 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

ALTER TABLE ASS_MASTER
ADD CONSTRAINT df_AMORTIZED_AMT_0
DEFAULT 0 FOR AMORTIZED_AMT; Luc Tran Van

10:42 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

INSERT INTO CM_ALLCODE ( CDNAME, CDVAL, CONTENT, CDTYPE, LSTODR) VALUES
( 'ASS_UPDATE', N'A', N'Đã duyệt', 'ASS_UPDA... Luc Tran Van

09:34 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

UPDATE ASS_ENTRIES_POST_SYNC SET TRN_DATE='2023-05-23' WHERE TRN_ID IN (SELECT aad.AMORTDT_ID FROM ASS_AMORT_DT aad W... Luc Tran Van

09:29 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

DELETE FROM ASS_AMORT_DT_LATEST
GO
INSERT INTO ASS_AMORT_DT_LATEST (AMORTDT_ID, AMORT_ID, AMORT_DT, CRDR, BRANCH_ID... Luc Tran Van

09:18 AM Bug #1534: Vận hành VB GOLIVE 23/05/2023

SELECT A.ASSET_ID, A.AMORTIZED_AMT, A.AMORTIZED_MONTH,
A.AMORT_AMT, A.AMORT_MONTH, A.AMORT_END_DATE, A.AMORT_... Luc Tran Van

09:10 AM Bug #1534 (New): Vận hành VB GOLIVE 23/05/2023

Luc Tran Van