DECLARE @l_VALUE_ID VARCHAR(15), @l_AMORT_DT_ID VARCHAR(15) EXEC SYS_CodeMasters_Gen 'ASS_VALUES', @l_VALUE_ID out INSERT INTO ASS_VALUES ( VALUE_ID, ASSET_ID, BRANCH_ID, TRN_DT, CRDR, ASSET_AMT, [DESCRIPTION], TRN_ID, TRN_TYPE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, AMORT_AMT ) VALUES ( @l_VALUE_ID, 'ASS000000272117', 'DV0001', CONVERT(datetime, GETDATE(), 103), 'D', 14216855677, N'THANH LY TSCD/CCLD', '', 'ASS_LIQ', '1','A','admin', CONVERT(datetime, GETDATE(), 103), 'admin', CONVERT(datetime, GETDATE(), 103), 23694759 ) SET @l_AMORT_DT_ID = '' EXEC SYS_CodeMasters_Gen 'ASS_AMORT_DT', @l_AMORT_DT_ID OUT 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 ( @l_AMORT_DT_ID,NULL,CONVERT(datetime, GETDATE(), 103),'D' ,'DV0001', 'DEP000000000001','ASS000000272117',189558072, NULL, --Khong chay khau hao theo group '1', 'AMORT', 'THANH LY TSCD - CCLD' )