|
1
|
DECLARE @l_VALUE_ID VARCHAR(15), @l_AMORT_DT_ID VARCHAR(15)
|
|
2
|
EXEC SYS_CodeMasters_Gen 'ASS_VALUES', @l_VALUE_ID out
|
|
3
|
INSERT INTO ASS_VALUES
|
|
4
|
(
|
|
5
|
VALUE_ID, ASSET_ID, BRANCH_ID, TRN_DT, CRDR, ASSET_AMT, [DESCRIPTION], TRN_ID, TRN_TYPE,
|
|
6
|
RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, AMORT_AMT
|
|
7
|
)
|
|
8
|
VALUES
|
|
9
|
(
|
|
10
|
@l_VALUE_ID, 'ASS000000272117', 'DV0001', CONVERT(datetime, GETDATE(), 103), 'D', 14216855677, N'THANH LY TSCD/CCLD', '', 'ASS_LIQ',
|
|
11
|
'1','A','admin', CONVERT(datetime, GETDATE(), 103), 'admin', CONVERT(datetime, GETDATE(), 103), 23694759
|
|
12
|
)
|
|
13
|
SET @l_AMORT_DT_ID = ''
|
|
14
|
EXEC SYS_CodeMasters_Gen 'ASS_AMORT_DT', @l_AMORT_DT_ID OUT
|
|
15
|
INSERT INTO ASS_AMORT_DT
|
|
16
|
(
|
|
17
|
AMORTDT_ID,AMORT_ID,AMORT_DT,CRDR,BRANCH_ID,DEP_ID,ASSET_ID,AMORT_AMT,GROUP_ID,EXECUTED,TRN_TYPE,TRN_DESC
|
|
18
|
)
|
|
19
|
VALUES
|
|
20
|
(
|
|
21
|
@l_AMORT_DT_ID,NULL,CONVERT(datetime, GETDATE(), 103),'D' ,'DV0001', 'DEP000000000001','ASS000000272117',189558072,
|
|
22
|
NULL, --Khong chay khau hao theo group
|
|
23
|
'1',
|
|
24
|
'AMORT',
|
|
25
|
'THANH LY TSCD - CCLD'
|
|
26
|
)
|