DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

INSERT ASS_TRANSFER_MULTI_DT(TRANSFER_MULTI_ID, TRANS_MULTI_MASTER_ID, ASSET_ID, BRANCH_ID, DEPT_ID, EMP_ID, USE_START_DT, DESCRIPTION, LOCATION, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, BRANCH_CREATE, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, BRANCH_ID_OLD, DEPT_ID_OLD, EMP_ID_OLD, REMAIN_VALUE) VALUES (N'TSDT00000251550', 'TFS000000251193', 'ASS000000000450', 'BRN000000001841', 'DEP000000251862', '', '2022-08-03', N'Đã bàn giao 01 bản chính biên bản giao nhận tài sản và 01 tờ trình chủ trương liên quan của đơn vị cho phòng kế toán.', N'', '1', 'A', 'khangpth', '2022-02-24 11:27:27.000', 'chittn', '2023-02-24 11:40:09.000', 'DV0001', 'U', NULL, NULL, NULL, '', 'N', 'BRN000000000404', 'DEP000000000272', 'EMP000000001205', 64900000)

INSERT CAR_DRIVE(CAR_DR_ID, CAR_ID, ASSET_ID, ASSET_NAME, OLD_INDEX_NUMBER, NEW_INDEX_NUMBER, INDEX_NUMBER, POWER_RATE, POWER_RATE_INDEX, CURR_POWER_RATE, INPUT_DT, ISLEAF, PARENT_ID, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, CAR_AMT, INVOICE_NO, DR_ROUTE, REQ_PAY_ID, DIFF_FUEL_CONSUM, REQ_CAR_ID, OLD_FUEL_NUMBER, NEW_FUEL_NUMBER) VALUES (N'CARD00000000001', 'CARM00000000599', NULL, NULL, 0, 50, 0, NULL, NULL, 0.00, '2022-11-16 00:00:00.000', 'N', NULL, NULL, '1', 'admin', '2022-11-16 15:28:53.000', 'U', NULL, NULL, NULL, NULL, N'Import data', NULL, NULL, '', 0.00, NULL)
SELECT * FROM CAR_MASTER

exec TR_BUDGET_CHECK_LIMIT_YEAR_GET_INFO_LIMIT 'GOO000001061929', NULL, 'BRN000000000392', 'dep_id', NULL, NULL, NULL, 'M2', '2023', 'C'

exec TR_BUDGET_CHECK_LIMIT_YEAR_GET_INFO_LIMIT @p_GD_ID=N'GOO000001061929',@p_BRANCH_ID=N'BRN000000000392',@p_DEP_ID=N'',@p_MONTH=N'M3',@p_YEAR=N'2023',@p_BRANCH_KIND=N'Y',@p_GD_CODE=NULL,@p_KHOI_ID=NULL,@p_TLNAME=NULL,@p_ROLENAME=NULL
go