AMS - VB

INSERT INTO ASS_ADDNEW (ADDNEW_ID, BUY_DATE, TYPE_ID, GROUP_ID, GOODS_ID, ASSET_NAME, ASSET_SERIAL_NO, ASSET_DESC, BRANCH_ID, DEPT_ID, EMP_ID, DIVISION_ID, AMORT_START_DATE, BUY_PRICE, AMORT_AMT, AMORT_MONTH, AMORT_RATE, IS_MULTIPLE, QTY, PO_ID, PD_ID, REF_ASSET_ID, REF_AMORTIZED_AMT, WARRANTY_MONTHS, NOTES, ENTRY_BOOKED, CORE_NOTE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, CONSTRUCT_ID, POSTED_STATUS, BRANCH_CREATE, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, AMORT_END_DATE, ACCOUNT_GL, VAT, PRICE_VAT, DEPT_CREATE, CONTRACT_ID, SUP_ID, ASS_STATUS, PL_CODE, WAR_EXPIRE_DT, REQ_ID, REQ_CODE, PR_CODE, UNIT, WIN_CRACK, OFFICE_CRACK, FORWARD_CONTENT) VALUES

('ASA000000040024', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001265', NULL, N'Phiếu 1', NULL, N'Phiếu 1', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '1', 3, 'ASPO00000040024', NULL, NULL, NULL, 0, N'Phiếu 1', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:13:21.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', '1', NULL, 'N', '1', NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040025', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001265', NULL, N'Phiếu 2', NULL, N'Phiếu 2', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040025', NULL, NULL, NULL, 0, N'Phiếu 2', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:14:03.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:01.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', '1', NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040026', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000017116', NULL, N'Phiếu 3', NULL, N'Phiếu 3', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '1', 4, 'ASPO00000040026', NULL, NULL, NULL, 0, N'Phiếu 3', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:14:22.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040027', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001466', NULL, N'Phiếu 4', NULL, N'Phiếu 4', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040027', NULL, NULL, NULL, 0, N'Phiếu 4', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:14:43.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:15.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', '1', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040028', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000017120', NULL, N'Phiếu 5', NULL, N'Phiếu 5', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040028', NULL, NULL, NULL, 0, N'Phiếu 5', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:15:11.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:21.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000002', '0', '0', NULL),

('ASA000000040029', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001251', NULL, N'Phiếu 6', NULL, N'Phiếu 6', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '1', 5, 'ASPO00000040029', NULL, NULL, NULL, 0, N'Phiếu 6', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:15:34.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', '1', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040030', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001293', NULL, N'Phiếu 7', NULL, N'Phiếu 7', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040030', NULL, NULL, NULL, 0, N'Phiếu 7', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:15:59.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:31.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000002', '0', '0', NULL),

('ASA000000040031', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000017120', NULL, N'Phiếu 8', NULL, N'Phiếu 8', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040031', NULL, NULL, NULL, 0, N'Phiếu 8', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:16:17.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:35.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000002', '0', '0', NULL),

('ASA000000040032', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001499', NULL, N'Phiếu 9', NULL, N'Phiếu 9', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '1', 7, 'ASPO00000040032', NULL, NULL, NULL, 0, N'Phiếu 9', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:16:37.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', '1', NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040033', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001447', NULL, N'Phiếu 10', NULL, N'Phiếu 10', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040033', NULL, NULL, NULL, 0, N'Phiếu 10', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:16:54.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:45.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040034', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000001358', NULL, N'Phiếu 11', NULL, N'Phiếu 11', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040034', NULL, NULL, NULL, 0, N'Phiếu 11', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:17:25.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:04.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', '1', NULL, 'N', 'a', NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL),

('ASA000000040035', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'ASG000000017058', NULL, N'Phiếu 12', NULL, N'Phiếu 12', NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1200.00, '0', 1, 'ASPO00000040035', NULL, NULL, NULL, 0, N'Phiếu 12', 'N', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:17:43.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:09.000', 121), NULL, 'N', 'DV0001', 'E', NULL, NULL, NULL, NULL, 'N', NULL, '321000202', 0.00, 0, 'DEP000000000048', NULL, NULL, 'N', NULL, NULL, NULL, NULL, NULL, 'CMU000000000001', '0', '0', NULL)

INSERT INTO ASS_USE_MULTI_MASTER (USER_MASTER_ID, BRANCH_ID, USE_EXPORT_DT, USER_EXPORT, NOTES, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, TYPE_ID, CORE_NOTE, BRANCH_CREATE, DEPT_CREATE, DEP_ID, CONTENT) VALUES

('SMA000000040230', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 1', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:46:51.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:47:09.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 1'),

('SMA000000040231', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 2', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:47:56.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:55:03.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 2'),

('SMA000000040232', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 3', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:48:42.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:57.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 3'),

('SMA000000040233', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 4', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:49:07.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:44.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 4'),

('SMA000000040234', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 5', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:01.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:36.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 5'),

('SMA000000040235', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 6', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:27.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:27.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 6'),

('SMA000000040236', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 7', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:50.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:15.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 7'),

('SMA000000040237', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 8', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:51:19.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:06.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 8'),

('SMA000000040238', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 9', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:51:50.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:59.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 9'),

('SMA000000040239', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 10', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:52:25.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:51.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 10'),

('SMA000000040240', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 11', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:52:59.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:45.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 11'),

('SMA000000040241', 'BRN000000000055', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'Xuất sử dụng Phiếu 12', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:53:26.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:38.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, N'', 'DV0001', 'DEP000000000048', NULL, N'Xuất sử dụng Phiếu 12')

INSERT INTO ASS_USE_MULTI_DT (USE_MULTI_ID, USER_MASTER_ID, ASSET_ID, AMORT_START_DATE, BRANCH_ID, DEPT_ID, EMP_ID, DIVISION_ID, NOTES, CORE_NOTE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, BRANCH_CREATE, AMORT_MONTH, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, AMORT_END_DATE, REQ_ID, NUM_REPORT, ASS_AMORTIZED_MONTH, ASS_AMORTIZED_AMT, BUY_PRICE, REMAIN_VALUE) VALUES

('SDT000000040235', 'SMA000000040230', 'ASS000000040167', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:46:51.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:47:09.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040236', 'SMA000000040231', 'ASS000000040168', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:47:56.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:55:03.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040237', 'SMA000000040232', 'ASS000000040169', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:48:42.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:57.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040238', 'SMA000000040233', 'ASS000000040170', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:49:07.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:44.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040239', 'SMA000000040234', 'ASS000000040171', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:01.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:36.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040240', 'SMA000000040235', 'ASS000000040172', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:27.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:27.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040241', 'SMA000000040236', 'ASS000000040173', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:50:50.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:15.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040242', 'SMA000000040237', 'ASS000000040174', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:51:19.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:54:06.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040243', 'SMA000000040238', 'ASS000000040175', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:51:50.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:59.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040244', 'SMA000000040239', 'ASS000000040176', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:52:25.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:51.000', 121), 'DV0001', 2.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040245', 'SMA000000040240', 'ASS000000040061', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:52:59.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:45.000', 121), 'DV0001', 96.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL),

('SDT000000040246', 'SMA000000040241', 'ASS000000040063', NULL, 'BRN000000000055', NULL, '', '', N'', '', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:53:26.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:53:38.000', 121), 'DV0001', 96.00, 'E', NULL, NULL, NULL, NULL, 'N', NULL, '', N'', NULL, NULL, NULL, NULL)

INSERT INTO ASS_USE_CONFIRM_MASTER (USER_CONFIRM_MASTER_ID, USER_MASTER_ID, USE_EXPORT_DT, BRANCH_ID, DEP_ID, MAKER_ID, CONFIRM_DT, CONFIRM_STATUS) VALUES

('SMAF00000040043', 'SMA000000040241', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:55:19.650', 121), 'Y'),

('SMAF00000040044', 'SMA000000040240', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:55:45.700', 121), 'Y'),

('SMAF00000040045', 'SMA000000040239', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:55:51.170', 121), 'Y'),

('SMAF00000040046', 'SMA000000040238', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:55:57.073', 121), 'Y'),

('SMAF00000040047', 'SMA000000040237', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:02.373', 121), 'Y'),

('SMAF00000040048', 'SMA000000040236', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:08.550', 121), 'Y'),

('SMAF00000040049', 'SMA000000040235', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:24.460', 121), 'Y'),

('SMAF00000040050', 'SMA000000040234', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:30.570', 121), 'Y'),

('SMAF00000040051', 'SMA000000040233', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:35.540', 121), 'Y'),

('SMAF00000040052', 'SMA000000040232', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:41.087', 121), 'Y'),

('SMAF00000040053', 'SMA000000040231', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:47.257', 121), 'Y'),

('SMAF00000040054', 'SMA000000040230', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BRN000000000055', NULL, 'lamtv', CONVERT(DATETIME, '2023-04-05 09:56:53.543', 121), 'Y')

INSERT INTO ASS_TRANSFER_MULTI_MASTER (TRANS_MULTI_MASTER_ID, BRANCH_ID, TRANSFER_DT, USER_TRANSFER, NOTES, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, CORE_NOTE, DEPT_CREATE, TRANSFER_CONTENT, REQ_ID, REQ_CODE, STATUS) VALUES

('TFS000000040268', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 1', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:46:17.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:01.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 1', NULL, NULL, 'APPROVE'),

('TFS000000040269', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 2', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:47:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:14.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 2', NULL, NULL, 'APPROVE'),

('TFS000000040270', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 3', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:47:41.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:23.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 3', NULL, NULL, 'APPROVE'),

('TFS000000040271', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 4', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:48:24.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:30.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 4', NULL, NULL, 'APPROVE'),

('TFS000000040272', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 5', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:49:01.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:37.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 5', NULL, NULL, 'APPROVE'),

('TFS000000040273', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 6', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:49:40.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:44.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 6', NULL, NULL, 'APPROVE'),

('TFS000000040274', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 7', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:50:14.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:50.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 7', NULL, NULL, 'APPROVE'),

('TFS000000040275', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 8', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:51:02.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:54:58.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 8', NULL, NULL, 'APPROVE'),

('TFS000000040276', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 9', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:51:49.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:05.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 9', NULL, NULL, 'APPROVE'),

('TFS000000040277', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 10', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:52:27.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:25.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, NULL, 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 10', NULL, NULL, 'APPROVE'),

('TFS000000040278', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 11', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:53:03.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:33.000', 121), 'E', CONVERT(DATETIME, '2023-04-05 11:02:34.000', 121), NULL, 'loanlt0500', NULL, NULL, 'tttttttnhhmj', 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 11', NULL, NULL, 'APPROVE'),

('TFS000000040279', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 12', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:53:40.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:41.000', 121), 'E', CONVERT(DATETIME, '2023-04-05 11:02:14.000', 121), NULL, 'loanlt0500', NULL, NULL, '123,123', 'DEP000000000048', N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 12', NULL, NULL, 'APPROVE')

INSERT INTO ASS_TRANSFER_MULTI_DT (TRANSFER_MULTI_ID, TRANS_MULTI_MASTER_ID, ASSET_ID, BRANCH_ID, KHOI_ID, CENTER_ID, DEPT_ID, EMP_ID, BRANCH_ID_OLD, KHOI_ID_OLD, CENTER_ID_OLD, DEPT_ID_OLD, EMP_ID_OLD, 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, REMAIN_VALUE, ASS_AMORTIZED_MONTH, ASS_AMORTIZED_AMT, BUY_PRICE) VALUES

('TSDT00000040272', 'TFS000000040268', 'ASS000000040113', 'BRN000000000055', '', '', '', 'EMP000000015056', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 1', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:46:17.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040273', 'TFS000000040269', 'ASS000000040114', 'BRN000000000055', '', '', '', 'EMP000000015057', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 2', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:47:00.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040274', 'TFS000000040270', 'ASS000000040115', 'BRN000000000055', '', '', '', 'EMP000000035513', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 3', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:47:41.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040275', 'TFS000000040271', 'ASS000000040116', 'BRN000000000055', '', '', '', 'EMP000000015056', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 4', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:48:24.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040276', 'TFS000000040272', 'ASS000000040117', 'BRN000000000055', '', '', '', 'EMP000000015056', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 5', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:49:01.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040277', 'TFS000000040273', 'ASS000000040118', 'BRN000000000055', '', '', '', 'EMP000000035513', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 6', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:49:40.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040278', 'TFS000000040274', 'ASS000000040119', 'BRN000000000055', '', '', '', '', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 7', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:50:14.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040279', 'TFS000000040275', 'ASS000000040120', 'BRN000000000055', '', '', '', 'EMP000000015056', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 8', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:51:02.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040280', 'TFS000000040276', 'ASS000000040121', 'BRN000000000055', '', '', '', 'EMP000000035513', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 9', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:51:49.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040281', 'TFS000000040277', 'ASS000000040122', 'BRN000000000055', '', '', '', 'EMP000000015058', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 10', N'', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 08:52:27.000', 121), NULL, NULL, 'DV0001', 'U', NULL, NULL, NULL, NULL, 'N', 20000000, NULL, NULL, 20000000),

('TSDT00000040282', 'TFS000000040278', 'ASS000000040123', 'BRN000000000055', '', '', '', 'EMP000000035513', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 11', N'', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:33.000', 121), NULL, 'E', CONVERT(DATETIME, '2023-04-05 11:02:34.000', 121), NULL, 'loanlt0500', NULL, 'N', 20000000, 0, 0, NULL),

('TSDT00000040283', 'TFS000000040279', 'ASS000000040124', 'BRN000000000055', '', '', '', 'EMP000000034299', 'DV0001', 'DEP000000000041', 'DEP000000000046', 'DEP000000000048', NULL, CONVERT(DATETIME, '2023-04-05', 120), N'ĐIỀU CHUYỂN TÀI SẢN PHIẾU 12', N'', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:55:41.000', 121), NULL, 'E', CONVERT(DATETIME, '2023-04-05 11:02:14.000', 121), NULL, 'loanlt0500', NULL, 'N', 20000000, 0, 0, NULL)

INSERT INTO ASS_COLLECT_MULTI_MASTER (COL_MULTI_MASTER_ID, BRANCH_ID, COLLECT_DT, USER_COLLECT, NOTES, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, AUTH_STATUS_KT, CREATE_DT_KT, APPROVE_DT_KT, MAKER_ID_KT, CHECKER_ID_KT, REPORT_STATUS, CORE_NOTE, DEPT_CREATE, REQ_ID, CONTENT) VALUES

('SMAC00000040190', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 1', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:00:48.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:01:02.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 1'),

('SMAC00000040191', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 2', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:01:47.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:08:24.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 2'),

('SMAC00000040192', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 3', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:02:34.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:08:34.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 3'),

('SMAC00000040193', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 4', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:03:15.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:08:42.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 4'),

('SMAC00000040194', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 5', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:04:04.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:08:48.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 5'),

('SMAC00000040195', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 6', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:04:37.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:08:54.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 6'),

('SMAC00000040196', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 7', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:05:16.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:01.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 7'),

('SMAC00000040197', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 8', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:05:50.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:07.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 8'),

('SMAC00000040198', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 9', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:06:26.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:17.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 9'),

('SMAC00000040199', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 10', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:06:59.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:24.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 10'),

('SMAC00000040200', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 11', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:07:33.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:30.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 11'),

('SMAC00000040201', 'DV0001', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N' Nguyễn Hoàng Nghĩa', N'THU HỒI TÀI SẢN PHIẾU 12', '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:08:06.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:36.000', 121), 'E', NULL, NULL, NULL, NULL, NULL, '', 'DEP000000000048', NULL, N'THU HỒI TÀI SẢN PHIẾU 12')

INSERT INTO ASS_COLLECT_MULTI_DT (COLLECT_MULTI_ID, COL_MULTI_MASTER_ID, ASSET_ID, BRANCH_ID, PURPOSE_ID, COLLECT_DT, LOCATION, COLLECT_NOTE, 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_RECEIVE, DEPT_ID_RECEIVE, DEPT_ID_USE, IS_LIQ, NOTES, ASS_AMORTIZED_MONTH, ASS_AMORTIZED_AMT, BUY_PRICE, REMAIN_VALUE) VALUES

('CSDT00000040191', 'SMAC00000040190', 'ASS000000040125', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 1', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:00:48.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 1', NULL, NULL, 20000000, 20000000),

('CSDT00000040192', 'SMAC00000040191', 'ASS000000040126', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 2', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:01:47.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 2', NULL, NULL, 20000000, 20000000),

('CSDT00000040193', 'SMAC00000040192', 'ASS000000040127', 'DV0001', N'NSNV', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 3', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:02:34.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 3', NULL, NULL, 20000000, 20000000),

('CSDT00000040194', 'SMAC00000040193', 'ASS000000040128', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 4', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:03:15.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 4', NULL, NULL, 20000000, 20000000),

('CSDT00000040195', 'SMAC00000040194', 'ASS000000040137', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 5', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:04:04.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 5', NULL, NULL, 20000000, 20000000),

('CSDT00000040196', 'SMAC00000040195', 'ASS000000040138', 'DV0001', N'NSNV', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 6', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:04:37.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 6', NULL, NULL, 20000000, 20000000),

('CSDT00000040197', 'SMAC00000040196', 'ASS000000040139', 'DV0001', N'NSNV', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 7', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:05:16.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 7', NULL, NULL, 20000000, 20000000),

('CSDT00000040198', 'SMAC00000040197', 'ASS000000040140', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 8', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:05:50.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 8', NULL, NULL, 20000000, 20000000),

('CSDT00000040199', 'SMAC00000040198', 'ASS000000040141', 'DV0001', N'NSNV', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 9', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:06:26.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 9', NULL, NULL, 20000000, 20000000),

('CSDT00000040200', 'SMAC00000040199', 'ASS000000040142', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 10', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:06:59.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 10', NULL, NULL, 20000000, 20000000),

('CSDT00000040201', 'SMAC00000040200', 'ASS000000040143', 'DV0001', N'NSDCCT', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 11', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:07:33.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 11', NULL, NULL, 20000000, 20000000),

('CSDT00000040202', 'SMAC00000040201', 'ASS000000040144', 'DV0001', N'NSNV', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), N'', N'THU HỒI TÀI SẢN PHIẾU 12', '1', 'E', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:08:06.000', 121), NULL, NULL, 'DV0001', NULL, NULL, NULL, NULL, NULL, 'N', 'BRN000000000055', '', 'DEP000000000048', '', N'THU HỒI TÀI SẢN PHIẾU 12', NULL, NULL, 20000000, 20000000)

INSERT INTO ASS_COLLECT_CONFIRM_MASTER (COL_MULTI_MASTER_CONFIRM_ID, COL_MULTI_MASTER_ID, BRANCH_ID, DEP_ID, COLLECT_DT, MAKER_ID, CONFIRM_DT, CONFIRM_STATUS) VALUES

('SMACF0000040009', 'SMAC00000040190', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:01:11.233', 121), 'Y'),

('SMACF0000040010', 'SMAC00000040191', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:49.783', 121), 'Y'),

('SMACF0000040011', 'SMAC00000040192', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:09:55.753', 121), 'Y'),

('SMACF0000040012', 'SMAC00000040193', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:01.850', 121), 'Y'),

('SMACF0000040013', 'SMAC00000040194', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:08.850', 121), 'Y'),

('SMACF0000040014', 'SMAC00000040195', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:15.537', 121), 'Y'),

('SMACF0000040015', 'SMAC00000040196', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:21.950', 121), 'Y'),

('SMACF0000040016', 'SMAC00000040197', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:28.310', 121), 'Y'),

('SMACF0000040017', 'SMAC00000040198', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:35.327', 121), 'Y'),

('SMACF0000040018', 'SMAC00000040199', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:43.420', 121), 'Y'),

('SMACF0000040019', 'SMAC00000040200', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:50.280', 121), 'Y'),

('SMACF0000040020', 'SMAC00000040201', 'DV0001', NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:10:56.927', 121), 'Y')

INSERT INTO ASS_LIQUIDATION (LIQ_ID, BUY_COMPANY_ID, BUY_PRICE, NOTES, CORE_NOTE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, BRANCH_ID, AUTH_STATUS_KT, MAKER_ID_KT, CREATE_DT_KT, CHECKER_ID_KT, APPROVE_DT_KT, DEPT_ID, LIST_LIQ_REQUEST, CONTENTSMINUTES, STATUS, SEND_APP_DT) VALUES

('ASSL00000040013', N'ĐIỆN BIÊN PHỦ', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 1', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:27:43.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:45:49.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 1', '1', CONVERT(DATETIME, '2023-04-05 09:27:49.200', 121)),

('ASSL00000040014', N'ĐIỆN BIÊN PHỦ', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 2', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:29:31.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:02.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 2', '1', CONVERT(DATETIME, '2023-04-05 09:29:37.377', 121)),

('ASSL00000040015', N'HỘI SỞ', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 3', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:31:30.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:10.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 3', '1', CONVERT(DATETIME, '2023-04-05 09:31:36.450', 121)),

('ASSL00000040016', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 4', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:32:18.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:20.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 4', '1', CONVERT(DATETIME, '2023-04-05 09:32:24.443', 121)),

('ASSL00000040017', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 5', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:33:14.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:28.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 5', '1', CONVERT(DATETIME, '2023-04-05 09:33:20.593', 121)),

('ASSL00000040018', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 6', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:34:09.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:36.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 6', '1', CONVERT(DATETIME, '2023-04-05 09:34:15.753', 121)),

('ASSL00000040019', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 7', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:34:56.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:51.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 7', '1', CONVERT(DATETIME, '2023-04-05 09:35:01.963', 121)),

('ASSL00000040020', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 8', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:36:01.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:44.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 8', '1', CONVERT(DATETIME, '2023-04-05 09:36:07.833', 121)),

('ASSL00000040021', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 9', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:36:55.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:46:58.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 9', '1', CONVERT(DATETIME, '2023-04-05 09:37:01.473', 121)),

('ASSL00000040022', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 10', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:43:38.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:47:05.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 10', '1', CONVERT(DATETIME, '2023-04-05 09:43:44.760', 121)),

('ASSL00000040023', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 11', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:44:27.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:47:14.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 11', '1', CONVERT(DATETIME, '2023-04-05 09:44:34.233', 121)),

('ASSL00000040024', N'HS', 20000000, N'THANH LÝ TÀI SẢN PHIẾU 12', NULL, '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 09:45:20.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 09:47:22.000', 121), 'DV0001', 'E', NULL, NULL, NULL, NULL, 'DEP000000000048', NULL, N'THANH LÝ TÀI SẢN PHIẾU 12', '1', CONVERT(DATETIME, '2023-04-05 09:45:26.913', 121))

INSERT INTO ASS_LIQUIDATION_DT (LIQDT_ID, LIQ_ID, ASSET_ID, LIQ_PRICE, LIQ_TYPE, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, REMAIN_VALUE, BUY_PRICE, BUY_PRICE_LIQ, LIQ_REASON, NOTE, LIQ_AMT, REMAIN_AMORTIZED_AMT, AMORT_STATUS_NAME, REQ_AMT, BRANCH_ID_USE, DEP_ID_USE, LIQ_REQ_ID, ASS_AMORTIZED_MONTH, ASS_AMORTIZED_AMT, LIQ_VAT, LIQ_PRICE_VAT, LIQ_AMT_BE_VAT) VALUES

('ASSLD0000040016', 'ASSL00000040013', 'ASS000000040152', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 1', N'THANH LÝ TÀI SẢN PHIẾU 1', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040017', 'ASSL00000040014', 'ASS000000040154', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 2', N'THANH LÝ TÀI SẢN PHIẾU 2', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040018', 'ASSL00000040015', 'ASS000000040153', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 3', N'THANH LÝ TÀI SẢN PHIẾU 3', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040019', 'ASSL00000040016', 'ASS000000040155', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 4', N'THANH LÝ TÀI SẢN PHIẾU 4', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040020', 'ASSL00000040017', 'ASS000000040156', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 5', N'THANH LÝ TÀI SẢN PHIẾU 5', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040021', 'ASSL00000040018', 'ASS000000040165', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 6', N'THANH LÝ TÀI SẢN PHIẾU 6', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040022', 'ASSL00000040019', 'ASS000000040166', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 7', N'THANH LÝ TÀI SẢN PHIẾU 7', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040023', 'ASSL00000040020', 'ASS000000040164', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 8', N'THANH LÝ TÀI SẢN PHIẾU 8', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040024', 'ASSL00000040021', 'ASS000000040157', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 9', N'THANH LÝ TÀI SẢN PHIẾU 9', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040025', 'ASSL00000040022', 'ASS000000040158', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 10', N'THANH LÝ TÀI SẢN PHIẾU 10', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040026', 'ASSL00000040023', 'ASS000000040159', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 11', N'THANH LÝ TÀI SẢN PHIẾU 11', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0),

('ASSLD0000040027', 'ASSL00000040024', 'ASS000000040160', NULL, '', NULL, NULL, NULL, NULL, NULL, 20000000, 20000000, 20000000, N'THANH LÝ TÀI SẢN PHIẾU 12', N'THANH LÝ TÀI SẢN PHIẾU 12', 20000000, 20000000, N'Chờ khấu hao', 20000000, 'BRN000000000055', '', '', NULL, NULL, 0, 0, 0)

INSERT INTO ASS_TRANSACTIONS (ASSET_ID, TRN_ID, TRN_TYPE, TRN_DATE, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, ASSHIST_ID, LOCHIST_ID) VALUES

('ASS000000040084', 'ASA000000040024', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL),

('ASS000000040085', 'ASA000000040024', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL),

('ASS000000040086', 'ASA000000040024', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL),

('ASS000000040087', 'ASA000000040025', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:01.000', 121), NULL, NULL),

('ASS000000040088', 'ASA000000040026', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL),

('ASS000000040089', 'ASA000000040026', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL),

('ASS000000040090', 'ASA000000040026', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL),

('ASS000000040091', 'ASA000000040026', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL),

('ASS000000040092', 'ASA000000040027', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:15.000', 121), NULL, NULL),

('ASS000000040093', 'ASA000000040028', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:21.000', 121), NULL, NULL),

('ASS000000040094', 'ASA000000040029', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL),

('ASS000000040095', 'ASA000000040029', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL),

('ASS000000040096', 'ASA000000040029', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL),

('ASS000000040097', 'ASA000000040029', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL),

('ASS000000040098', 'ASA000000040029', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL),

('ASS000000040099', 'ASA000000040030', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:31.000', 121), NULL, NULL),

('ASS000000040100', 'ASA000000040031', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:35.000', 121), NULL, NULL),

('ASS000000040101', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040102', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040103', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040104', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040105', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040106', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040107', 'ASA000000040032', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL),

('ASS000000040108', 'ASA000000040033', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:45.000', 121), NULL, NULL),

('ASS000000040109', 'ASA000000040034', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:04.000', 121), NULL, NULL),

('ASS000000040110', 'ASA000000040035', 'ADD_NEW', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '1', 'A', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:09.000', 121), NULL, NULL)

INSERT INTO ASS_MASTER (ASSET_ID, TYPE_ID, GROUP_ID, ASSET_CODE, ASSET_NAME, ASSET_SERIAL_NO, ASSET_DESC, SUP_ID, BUY_PRICE, AMORT_AMT, ASS_TYPE, BRANCH_ID, DEPT_ID, EMP_ID, DIVISION_ID, BUY_DATE, USE_DATE, SPECIAL_ASS, AMORT_MONTH, AMORT_RATE, AMORT_START_DATE, AMORT_END_DATE, FIRST_AMORT_AMT, MONTHLY_AMORT_AMT, AMORTIZED_MONTH, AMORTIZED_AMT, LIQUIDATION_DT, PO_ID, PD_ID, WAREHOUSE_ID, LOCATION, REF_ASSET_ID, REF_AMORTIZED_AMT, WARRANTY_MONTHS, NOTES, AMORT_STATUS, ASS_STATUS, ASS_STATUS_DESC, ENTRY_BOOKED, RECORD_STATUS, AUTH_STATUS, MAKER_ID, CREATE_DT, CHECKER_ID, APPROVE_DT, CONSTRUCT_ID, AMORT_START_DATE_OLD, AMORT_END_DATE_OLD, BUY_DATE_KT, USE_DATE_KT, USE_STATUS, BRANCH_CREATE, ACCOUNT_GL, VAT, PRICE_VAT, LIQ_W_STATUS, TINHTRANGTS, ASS_CONTRACT_CODE, PL, REQ_ID, REQ_CODE, ASS_CODE_TMP, OS, MO_LICENSE, CURRENT_TRANS, CURRENT_TRANS_TYPE, IS_COLLECT, REF_GROUP_ID) VALUES

('ASS000000040061', NULL, 'ASG000000001415', N'ASS000000040061', N'laptop dell', NULL, N'win 10', NULL, 0, NULL, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-03 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040010', NULL, NULL, NULL, NULL, NULL, 12, NULL, N'VNM', N'1', N'', 'N', '1', 'U', 'huonglh', CONVERT(DATETIME, '2023-04-03 00:00:00.000', 121), 'bichnn', CONVERT(DATETIME, '2023-04-03 11:12:08.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040061', '0', '0', 'SMA000000040240', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040063', NULL, 'ASG000000001415', N'ASS000000040063', N'laptop dell', NULL, N'win 10', NULL, 0, NULL, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-03 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040010', NULL, NULL, NULL, NULL, NULL, 12, NULL, N'VNM', N'1', N'', 'N', '1', 'U', 'huonglh', CONVERT(DATETIME, '2023-04-03 00:00:00.000', 121), 'bichnn', CONVERT(DATETIME, '2023-04-03 11:12:08.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040063', '0', '0', 'SMA000000040241', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040084', NULL, 'ASG000000001265', N'ASS000000040084', N'Phiếu 1', NULL, N'Phiếu 1', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 60.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040024', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 1', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040084', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040085', NULL, 'ASG000000001265', N'ASS000000040085', N'Phiếu 1', NULL, N'Phiếu 1', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 60.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040024', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 1', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040085', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040086', NULL, 'ASG000000001265', N'ASS000000040086', N'Phiếu 1', NULL, N'Phiếu 1', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 60.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040024', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 1', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:17:57.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040086', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040087', NULL, 'ASG000000001265', N'ASS000000040087', N'Phiếu 2', NULL, N'Phiếu 2', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 60.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040025', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 2', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:01.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040087', '0', '0', 'SMA000000040228', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040088', NULL, 'ASG000000017116', N'ASS000000040088', N'Phiếu 3', NULL, N'Phiếu 3', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040026', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 3', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040088', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040089', NULL, 'ASG000000017116', N'ASS000000040089', N'Phiếu 3', NULL, N'Phiếu 3', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040026', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 3', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040089', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040090', NULL, 'ASG000000017116', N'ASS000000040090', N'Phiếu 3', NULL, N'Phiếu 3', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040026', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 3', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040090', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040091', NULL, 'ASG000000017116', N'ASS000000040091', N'Phiếu 3', NULL, N'Phiếu 3', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040026', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 3', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:10.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040091', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040092', NULL, 'ASG000000001466', N'ASS000000040092', N'Phiếu 4', NULL, N'Phiếu 4', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040027', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 4', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:15.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, '1', NULL, NULL, NULL, 'ASS000000040092', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040093', NULL, 'ASG000000017120', N'ASS000000040093', N'Phiếu 5', NULL, N'Phiếu 5', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040028', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 5', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:21.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040093', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040094', NULL, 'ASG000000001251', N'ASS000000040094', N'Phiếu 6', NULL, N'Phiếu 6', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040029', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 6', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040094', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040095', NULL, 'ASG000000001251', N'ASS000000040095', N'Phiếu 6', NULL, N'Phiếu 6', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040029', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 6', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040095', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040096', NULL, 'ASG000000001251', N'ASS000000040096', N'Phiếu 6', NULL, N'Phiếu 6', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040029', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 6', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040096', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040097', NULL, 'ASG000000001251', N'ASS000000040097', N'Phiếu 6', NULL, N'Phiếu 6', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040029', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 6', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040097', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040098', NULL, 'ASG000000001251', N'ASS000000040098', N'Phiếu 6', NULL, N'Phiếu 6', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040029', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 6', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:26.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040098', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040099', NULL, 'ASG000000001293', N'ASS000000040099', N'Phiếu 7', NULL, N'Phiếu 7', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040030', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 7', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:31.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040099', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040100', NULL, 'ASG000000017120', N'ASS000000040100', N'Phiếu 8', NULL, N'Phiếu 8', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040031', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 8', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:35.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040100', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040101', NULL, 'ASG000000001499', N'ASS000000040101', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040101', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040102', NULL, 'ASG000000001499', N'ASS000000040102', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040102', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040103', NULL, 'ASG000000001499', N'ASS000000040103', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040103', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040104', NULL, 'ASG000000001499', N'ASS000000040104', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040104', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040105', NULL, 'ASG000000001499', N'ASS000000040105', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040105', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040106', NULL, 'ASG000000001499', N'ASS000000040106', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040106', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040107', NULL, 'ASG000000001499', N'ASS000000040107', N'Phiếu 9', NULL, N'Phiếu 9', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 96.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040032', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 9', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:40.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040107', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040108', NULL, 'ASG000000001447', N'ASS000000040108', N'Phiếu 10', NULL, N'Phiếu 10', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040033', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 10', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:18:45.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040108', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040109', NULL, 'ASG000000001358', N'ASS000000040109', N'Phiếu 11', NULL, N'Phiếu 11', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040034', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 11', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:04.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, '1', NULL, NULL, NULL, 'ASS000000040109', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040110', NULL, 'ASG000000017058', N'ASS000000040110', N'Phiếu 12', NULL, N'Phiếu 12', NULL, 0, NULL, '1', NULL, NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, '0', 0.00, 1200.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040035', NULL, NULL, NULL, NULL, NULL, 0, N'Phiếu 12', N'VNM', N'1', N'', 'N', '1', 'U', 'nghianh', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'bichnn0500', CONVERT(DATETIME, '2023-04-05 08:19:09.000', 121), NULL, NULL, NULL, NULL, NULL, 'BT', 'DV0001', '321000202', 0.00, 0, '0', NULL, NULL, NULL, NULL, NULL, 'ASS000000040110', '0', '0', NULL, NULL, CONVERT(bit, 'False'), NULL),

('ASS000000040113', 'CCLD', 'ASG000000001416', N'999131', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999131', '1', '0', 'TFS000000040268', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040114', 'CCLD', 'ASG000000001416', N'999132', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999132', '1', '0', 'TFS000000040269', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040115', 'CCLD', 'ASG000000001416', N'999133', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999133', '1', '0', 'TFS000000040270', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040116', 'CCLD', 'ASG000000001416', N'999134', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999134', '1', '0', 'TFS000000040271', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040117', 'CCLD', 'ASG000000001416', N'999135', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999135', '1', '0', 'TFS000000040272', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040118', 'CCLD', 'ASG000000001416', N'999136', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999136', '1', '0', 'TFS000000040273', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040119', 'CCLD', 'ASG000000001416', N'999137', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999137', '1', '0', 'TFS000000040274', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040120', 'CCLD', 'ASG000000001416', N'999138', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999138', '1', '0', 'TFS000000040275', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040121', 'CCLD', 'ASG000000001416', N'999139', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999139', '1', '0', 'TFS000000040276', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040122', 'CCLD', 'ASG000000001416', N'999140', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999140', '1', '0', 'TFS000000040277', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040123', 'CCLD', 'ASG000000001416', N'999141', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999141', '1', '0', 'TFS000000040278', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040124', 'CCLD', 'ASG000000001416', N'999142', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999142', '1', '0', 'TFS000000040279', 'ASS_TF_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040125', 'CCLD', 'ASG000000001416', N'999143', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999143', '1', '0', 'SMAC00000040190', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040126', 'CCLD', 'ASG000000001416', N'999144', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999144', '1', '0', 'SMAC00000040191', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040127', 'CCLD', 'ASG000000001416', N'999145', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999145', '1', '0', 'SMAC00000040192', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040128', 'CCLD', 'ASG000000001416', N'999146', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999146', '1', '0', 'SMAC00000040193', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040137', 'CCLD', 'ASG000000001416', N'999155', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999155', '1', '0', 'SMAC00000040194', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040138', 'CCLD', 'ASG000000001416', N'999156', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999156', '1', '0', 'SMAC00000040195', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040139', 'CCLD', 'ASG000000001416', N'999157', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999157', '1', '0', 'SMAC00000040196', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040140', 'CCLD', 'ASG000000001416', N'999158', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999158', '1', '0', 'SMAC00000040197', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040141', 'CCLD', 'ASG000000001416', N'999159', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999159', '1', '0', 'SMAC00000040198', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040142', 'CCLD', 'ASG000000001416', N'999160', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999160', '1', '0', 'SMAC00000040199', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040143', 'CCLD', 'ASG000000001416', N'999161', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999161', '1', '0', 'SMAC00000040200', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040144', 'CCLD', 'ASG000000001416', N'999162', N'máy tính để bàn', NULL, N'máy tính để bàn', NULL, 20000000, 20000000, '1', 'DV0001', 'DEP000000000048', NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040037', NULL, NULL, NULL, NULL, NULL, 12, N'máy tính để bàn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 08:40:18.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 10.00, 2000000, '0', NULL, '32', NULL, NULL, NULL, '999162', '1', '0', 'SMAC00000040201', 'ASS_COLL_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040152', 'CCLD', 'ASG000000001416', N'999170', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999170', '1', '1', 'ASSL00000040013', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040153', 'CCLD', 'ASG000000001416', N'999171', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999171', '1', '1', 'ASSL00000040015', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040154', 'CCLD', 'ASG000000001416', N'999172', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999172', '1', '1', 'ASSL00000040014', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040155', 'CCLD', 'ASG000000001416', N'999173', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999173', '1', '1', 'ASSL00000040016', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040156', 'CCLD', 'ASG000000001416', N'999174', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999174', '1', '1', 'ASSL00000040017', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040157', 'CCLD', 'ASG000000001416', N'999175', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999175', '1', '1', 'ASSL00000040021', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040158', 'CCLD', 'ASG000000001416', N'999176', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999176', '1', '1', 'ASSL00000040022', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040159', 'CCLD', 'ASG000000001416', N'999177', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999177', '1', '1', 'ASSL00000040023', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040160', 'CCLD', 'ASG000000001416', N'999178', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999178', '1', '1', 'ASSL00000040024', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040164', 'CCLD', 'ASG000000001416', N'999182', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999182', '1', '1', 'ASSL00000040020', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040165', 'CCLD', 'ASG000000001416', N'999183', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999183', '1', '1', 'ASSL00000040018', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040166', 'CCLD', 'ASG000000001416', N'999184', N'tài sảnnn', NULL, N'tài sảnnn', NULL, 20000000, 20000000, '1', 'BRN000000000055', NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 10.00, 120.00, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2024-02-04 00:00:00.000', 121), 1733342, 2000000, 0.00, 0, NULL, 'ASPO00000040038', NULL, NULL, NULL, NULL, NULL, 0, N'tài sảnnn', N'CKH', N'1', N'', 'Y', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:25:54.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'BT', 'DV0001', '321000202', 1.00, 200000, '0', NULL, '23', NULL, NULL, NULL, '999184', '1', '1', 'ASSL00000040019', 'ASS_LIQ', CONVERT(bit, 'False'), NULL),

('ASS000000040167', 'TSCD', 'ASG000000001418', N'999185', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999185', '0', '0', 'SMA000000040230', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040168', 'TSCD', 'ASG000000001418', N'999186', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999186', '0', '0', 'SMA000000040231', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040169', 'TSCD', 'ASG000000001418', N'999187', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999187', '0', '0', 'SMA000000040232', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040170', 'TSCD', 'ASG000000001418', N'999188', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999188', '0', '0', 'SMA000000040233', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040171', 'TSCD', 'ASG000000001418', N'999189', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999189', '0', '0', 'SMA000000040234', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040172', 'TSCD', 'ASG000000001418', N'999190', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999190', '0', '0', 'SMA000000040235', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040173', 'TSCD', 'ASG000000001418', N'999191', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999191', '0', '0', 'SMA000000040236', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040174', 'TSCD', 'ASG000000001418', N'999192', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999192', '0', '0', 'SMA000000040237', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040175', 'TSCD', 'ASG000000001418', N'999193', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999193', '0', '0', 'SMA000000040238', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL),

('ASS000000040176', 'TSCD', 'ASG000000001418', N'999194', N'TS Dùng để xuất', NULL, N'TS Dùng để xuất', NULL, 44000000, 44000000, '1', 'BRN000000000055', NULL, '', '', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), '0', 2.00, 600.00, NULL, NULL, NULL, NULL, 0.00, 0, NULL, 'ASPO00000040039', NULL, NULL, NULL, NULL, NULL, 0, N'TS Dùng để xuất', N'VNM', N'1', N'', 'N', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 09:45:56.000', 121), NULL, NULL, NULL, CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), NULL, 'BT', 'DV0001', '321000202', 10.00, 4000000, '0', NULL, NULL, NULL, NULL, NULL, '999194', '0', '0', 'SMA000000040239', 'ASS_USE_MUL', CONVERT(bit, 'False'), NULL)

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

('ASSV00000040018', 'ASS000000040113', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040019', 'ASS000000040114', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040020', 'ASS000000040115', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040021', 'ASS000000040116', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040022', 'ASS000000040117', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040023', 'ASS000000040118', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040024', 'ASS000000040119', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040025', 'ASS000000040120', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040026', 'ASS000000040121', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040027', 'ASS000000040122', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040028', 'ASS000000040123', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040029', 'ASS000000040124', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040030', 'ASS000000040125', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040031', 'ASS000000040126', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040032', 'ASS000000040127', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040033', 'ASS000000040128', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040042', 'ASS000000040137', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040043', 'ASS000000040138', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040044', 'ASS000000040139', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040045', 'ASS000000040140', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040046', 'ASS000000040141', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040047', 'ASS000000040142', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040048', 'ASS000000040143', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040049', 'ASS000000040144', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040037', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040057', 'ASS000000040152', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040058', 'ASS000000040153', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040059', 'ASS000000040154', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040060', 'ASS000000040155', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040061', 'ASS000000040156', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040062', 'ASS000000040157', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040063', 'ASS000000040158', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040064', 'ASS000000040159', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040065', 'ASS000000040160', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040069', 'ASS000000040164', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040070', 'ASS000000040165', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000),

('ASSV00000040071', 'ASS000000040166', 'DV0001', CONVERT(DATETIME, '2023-04-05', 120), 'C', 20000000, N'NHAP MOI TSCD/CCLD', 'ASA000000040038', 'ASS_ADDNEW', '1', 'A', 'loanlt0500', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 'annt', CONVERT(DATETIME, '2023-04-05 00:00:00.000', 121), 20000000)

INSERT INTO ASS_LOCATION_HIST (LOCHIST_ID, ASSET_ID, USE_START_DT, USE_END_DT, BRANCH_ID, DEPT_ID, EMP_ID, LOCATION, ISLEAF, PARENT_ID) VALUES

('ASLH00000040100', 'ASS000000040061', CONVERT(DATETIME, '2023-04-03', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040102', 'ASS000000040063', CONVERT(DATETIME, '2023-04-03', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040129', 'ASS000000040084', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040130', 'ASS000000040085', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040131', 'ASS000000040086', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040132', 'ASS000000040087', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040133', 'ASS000000040088', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040134', 'ASS000000040089', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040135', 'ASS000000040090', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040136', 'ASS000000040091', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040137', 'ASS000000040092', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040138', 'ASS000000040093', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040139', 'ASS000000040094', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040140', 'ASS000000040095', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040141', 'ASS000000040096', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040142', 'ASS000000040097', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040143', 'ASS000000040098', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040144', 'ASS000000040099', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040145', 'ASS000000040100', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040146', 'ASS000000040101', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040147', 'ASS000000040102', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040148', 'ASS000000040103', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040149', 'ASS000000040104', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040150', 'ASS000000040105', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040151', 'ASS000000040106', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040152', 'ASS000000040107', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040153', 'ASS000000040108', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040154', 'ASS000000040109', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040155', 'ASS000000040110', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040158', 'ASS000000040113', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040159', 'ASS000000040114', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040160', 'ASS000000040115', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040161', 'ASS000000040116', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040162', 'ASS000000040117', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040163', 'ASS000000040118', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040164', 'ASS000000040119', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040165', 'ASS000000040120', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040166', 'ASS000000040121', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040167', 'ASS000000040122', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040168', 'ASS000000040123', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040169', 'ASS000000040124', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040170', 'ASS000000040125', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040171', 'ASS000000040126', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040172', 'ASS000000040127', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040173', 'ASS000000040128', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040182', 'ASS000000040137', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040183', 'ASS000000040138', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040184', 'ASS000000040139', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040185', 'ASS000000040140', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040186', 'ASS000000040141', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040187', 'ASS000000040142', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040188', 'ASS000000040143', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040189', 'ASS000000040144', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'DV0001', 'DEP000000000048', NULL, N'', 'Y', NULL),

('ASLH00000040197', 'ASS000000040152', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040198', 'ASS000000040153', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040199', 'ASS000000040154', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040200', 'ASS000000040155', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040201', 'ASS000000040156', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040202', 'ASS000000040157', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040203', 'ASS000000040158', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040204', 'ASS000000040159', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040205', 'ASS000000040160', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040209', 'ASS000000040164', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040210', 'ASS000000040165', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040211', 'ASS000000040166', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, NULL, N'', 'Y', NULL),

('ASLH00000040213', 'ASS000000040167', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040214', 'ASS000000040168', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040215', 'ASS000000040169', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040216', 'ASS000000040170', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040217', 'ASS000000040171', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040218', 'ASS000000040172', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040219', 'ASS000000040173', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040220', 'ASS000000040174', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040221', 'ASS000000040175', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040222', 'ASS000000040176', CONVERT(DATETIME, '2023-04-05', 120), NULL, NULL, NULL, NULL, N'', 'Y', NULL),

('ASLH00000040223', 'ASS000000040063', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040224', 'ASS000000040061', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040225', 'ASS000000040176', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040226', 'ASS000000040175', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040227', 'ASS000000040174', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040228', 'ASS000000040173', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040229', 'ASS000000040172', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040230', 'ASS000000040171', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040231', 'ASS000000040170', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040232', 'ASS000000040169', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040233', 'ASS000000040168', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL),

('ASLH00000040234', 'ASS000000040167', CONVERT(DATETIME, '2023-04-05', 120), NULL, 'BRN000000000055', NULL, '', N'', 'Y', NULL)