UPDATE ASS_MASTER SET AMORTIZED_MONTH=10.0,AMORTIZED_AMT=18983330.0,AMORT_STATUS='DKH' WHERE ASSET_ID='ASA000000257448'
INSERT INTO [ASS_ENTRIES_POST] ([ET_ID],[REF_NO],[ASSET_ID],[TRN_TYPE],[REF_ID],[DO_BRN],[CR_ACCT],[CR_BRN],[DR_ACCT],[DR_BRN],[AMT],[EXP_TO_CORE],[TRN_DATE],[TRN_DESC],[MAKER_ID],[CHECKER_ID],[TRN_ID])VALUES(N'AEP000000649367',NULL,N'ASS000000278836',N'AMORT',N'ASAD00000664827',N'DV0001',N'305203024',N'DV0001',N'871000001',N'DV0001',18983330,N'Y',N'Dec 26 2022 12:00AM',N'KHAU HAO TSCD KY 12 2022',N'admin',N'admin',N'ASM000000251057')
INSERT INTO [ASS_AMORT] ([AMORT_ID],[AMORT_TERM],[EXECUTE_DT],[TOTAL_AMT],[IS_LEAF],[PARENT_ID],[NOTES],[PROCESS_STATUS],[RECORD_STATUS],[AUTH_STATUS],[MAKER_ID],[CREATE_DT],[CHECKER_ID],[APPROVE_DT],[BRANCH_ID],[ASSET_TYPE])VALUES(N'ASM000000251057',N'12/2022',N'Dec 26 2022 12:00AM',18983330,N'Y',NULL,N'Phân bổ bổ sung kỳ 12/2022',N'S',N'1',N'A',N'admin',N'Dec 26 2022  1:48PM',N'admin',N'Dec 26 2022  1:48PM',N'DV0001',N'ALL')
INSERT INTO [ASS_AMORT_DT] ([AMORTDT_ID],[AMORT_ID],[AMORT_DT],[CRDR],[BRANCH_ID],[DEP_ID],[ASSET_ID],[AMORT_AMT],[GROUP_ID],[EXECUTED],[TRN_TYPE],[TRN_DESC])VALUES(N'ASAD00000664827',N'ASM000000251057',N'2022-12-26',N'C',N'DV0001',N'DEP000000000024',N'ASS000000278836',18983330,NULL,N'1',N'AMORT',N'Phân bổ kỳ 12/2022')