AMS - VB

DECLARE @l_REQDT_ID VARCHAR(15)

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000008', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'cần lưu thêm nhiều hồ sơ,chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'318 BIS PHAM HUNG P5 QUAN 8 TPHCM', N'Gia Hân', '0933415275', '1', 'HANPHG1801', CONVERT(DATETIME, '2023-04-06 08:48:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'phamhuynhgiahan@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000009', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Cấp mới', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'292-294-296 Hùng Vương, Phường 3, Tp Tân An, Tỉnh Long An', N'Huỳnh Lê Thị Tuyết Nhung', '0976462555', '1', 'nhunghltt', CONVERT(DATETIME, '2023-04-06 13:32:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'huynhlethituyetnhung@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000010', '', '', 'ASG000000017055', NULL, NULL, NULL, N'', N'PHỤC VỤ CÔNG VIỆC', '', NULL, NULL, '', NULL, NULL, NULL, N'TỦ SẮT LƯU TRỮ HỒ SƠ ĐẢM BẢO TẠI KHO QUỸ', '', N'18 NGUYỄN HUỆ, TT VẠN GIÃ, VẠN NINH, KHÁNH HÒA', N'NGUYỄN DIỆP HÂN', '0965790604', '1', 'hannd', CONVERT(DATETIME, '2023-04-06 13:53:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'NGUYENDIEPHAN@VIETBANK.COM.VN', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000011', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'phục vụ lưu trữ hồ sơ tại đơn vị', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'143A Gò Dầu, P.Tân Quý, Q.Tân Phú, HCM', N'Đoàn Thị Khánh Linh', '0914114889', '1', 'linhdtk1705', CONVERT(DATETIME, '2023-04-06 14:30:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'doanthikhanhlinh@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000012', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Lưu trữ chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'Số 112 Trần Phú, Phường Lê Hồng, TP.Quy Nhơn, Tỉnh Bình Định', N'Nguyễn Thị Mỹ Hoa', '0961800882', '1', 'Hoantm2900', CONVERT(DATETIME, '2023-04-06 14:54:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthimyhoa@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000013', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'phục vụ nhu cầu công việc', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'SH16-19-20 CC The K-Park, Khu đô thị mới Văn Phú, Quận Hà Đông, TP.Hà Nội.', N'chị Trang', '0982139288', '1', 'trangntq0816', CONVERT(DATETIME, '2023-04-06 15:48:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthiquynhtrang@vietbank.com.vn', 'BUYNEW', 4, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000014', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Cấp mới', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'PGD LÊ CHÂN_ 309-311 Tô Hiệu, P.Hồ Nam, Q. Lê Chân, Hải Phòng', N'Vũ Thị Thu Trang', '0936489926', '1', 'TRANGVTT', NULL, 'E', NULL, NULL, NULL, NULL, '', '', N'vuthithutrang@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000017', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Lưu hồ sơ chứng từ tại kho CN', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'NH VIET NAM THƯƠNG TÍN VB TÂY HỒ :LKC08 KHU NHÀ THẤP TẦNG A1 TT1 ĐƯỜNG HOÀNG MINH THAO PHƯỜNG XUÂN TẢO QUẬN BẮC TỪ LIÊM ,HN', N'NGUYỄN BÍCH NGỌC', '0388925295', '1', 'thaolm', CONVERT(DATETIME, '2023-04-07 11:53:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'NGUYENBICHNGOC@VIETBANK.COM.VN', 'BUYNEW', 2, 'EMP000000035894', '2022-04020', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000018', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'LƯU TRỮ CHỨNG TỪ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'118 VÕ VĂN NGÂN-P.BÌNH THO- THỦ ĐÚC-HCM', N'NGÔ THỊ BÍCH NGỌC', '0908083947', '1', 'ngocntb10001', CONVERT(DATETIME, '2023-04-07 13:52:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'ngothibichngoc@vietbank.com.vn', 'BUYNEW', 10, 'EMP000000031397', '0142-10001', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000022', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'CẤP MỚI', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'Vietbank Lê Hồng Phong, số 5 lô 22B Lê Hồng Phong, Đông Khê, Ngô Quyền, Hải Phòng', N'Vũ Thị Dung', '0357289635', '1', 'DUNGVT1', CONVERT(DATETIME, '2023-04-07 14:59:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'vuthidung@vietbank.com.vn', 'BUYNEW', 5, 'EMP000000035191', '2018-09019', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000023', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'lưu trữ hồ sơ tại các TTKD theo bản tin của P.QLRRVH', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'592 Hai Bà Trưng - P.Cẩm Phô - TP Hội An - Quảng Nam', N'Nguyễn Lê Quý Thọ', '0392752825', '1', 'thonlq', CONVERT(DATETIME, '2023-04-07 16:33:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenlequytho@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000024', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'TTKD không đủ kệ sắt lưu trữ chứng từ, ấn chỉ ấn phẩm, quà tặng vật dụng dẫn đến hư hỏng', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'181 Nguyễn Văn Cừ P An Hòa, Tp Cần Thơ', N'Trần Thị Hồng Cẩm', '0907305099', '1', 'camtth', CONVERT(DATETIME, '2023-04-07 17:49:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'tranthihongcam@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000029', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'theo yêu cầu của P.QLRRVH', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'tòa S2.18, căn 01SH15, KĐT Vinhomes Ocean Park, Xã Đa Tốn, Gia Lâm, Hà Nội', N'Triệu Thị Huyền', '0397542486', '1', 'huyenntt0805', CONVERT(DATETIME, '2023-04-10 13:13:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'trieuthihuyen@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000030', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'LƯU HỒ SƠ, CHỨNG TỪ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'299 NGUYỄN VĂN TRỖI, P.1, Q. TÂN BÌNH', N'PHAN THỊ XUÂN THỦY', '0909442578', '1', 'thuyptx1900', CONVERT(DATETIME, '2023-04-10 13:26:00.000', 121), 'E', NULL, NULL, NULL, NULL, '', '', N'phanthixuanthuy@vietbank.com.vn', 'BUYNEW', 2, 'EMP000000035102', '2022-05014', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000031', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'lưu giữ chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'188C Trần Quang Khải, p. Tân Định, Q.1', N'Nguyễn Thị Ngọc Lý', '0901838879', '1', 'ANNHT', CONVERT(DATETIME, '2023-04-10 14:57:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthingocly@vietbank.com.vn', 'BUYNEW', 3, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000032', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'ĐỰNG CHỨNG TỪ GIAO DỊCH', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'221 ÔNG ÍCH ĐƯỜNG CẨM LỆ ĐÀ NẴNG', N'HUỲNH THỊ HOÀNG', '0905848345', '1', 'HOANGHT', CONVERT(DATETIME, '2023-04-10 15:08:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'huynhthihoang@vietbank.com.vn', 'BUYNEW', 5, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000033', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Lưu trữ hồ sơ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'158 Hùng Vương P Hải Châu 1 Quận Hải Châu Tp Đà Nẵng', N'Vũ Thị Thùy Giang', '0905823131', '1', 'GIANGVTT1103', CONVERT(DATETIME, '2023-04-10 15:14:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'vuthithuygiang@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000034', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'kệ sắt lưu trữ chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'885 Ngô quyền - P. An Hải Đông - Q. Sơn Trà - Đà Nẵng', N'NGÔ THỊ TÂM THANH', '0905778086', '1', 'THANHNTT', NULL, 'E', NULL, NULL, NULL, NULL, '', '', N'ngothitamthanh@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000036', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Lưu trữ hồ sơ tại TTKD An Giang', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'95 Nguyễn Trãi, Phường Mỹ Long, TP Long Xuyên, An Giang', N'Lâm Thị Ngọc Tiền', '0918838359', '1', 'tienltn2500', CONVERT(DATETIME, '2023-04-10 15:19:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'lamthingoctien@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000038', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'LƯU TRỮ CHỨNG TỪ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'265 ĐỐNG ĐA, ĐÀ NẴNG', N'NGUYỄN THỊ NHƯ HOA', '0934853637', '1', 'HOANTN', CONVERT(DATETIME, '2023-04-10 16:11:00.000', 121), 'U', 'MINHTTH', CONVERT(DATETIME, '2023-04-11 13:33:00.000', 121), NULL, NULL, '', '', N'nguyenthinhuhoa@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000039', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'đề chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'109-111 LÊ DẠI HÀNH PHƯỜNG 6 QUẬN 11 TP. HỒ CHÍ MINH', N'NGUYỄN HOÀNG CHÂU', '0376818791', '1', 'dattq0500', CONVERT(DATETIME, '2023-04-10 16:49:00.000', 121), 'U', 'huongttn', CONVERT(DATETIME, '2023-04-11 15:22:00.000', 121), NULL, NULL, '', '', N'nguyenhoangchau@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000041', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'ĐỂ LƯU TRỮ CHỨNG TỪ GIAO DỊCH', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'96 LÊ VĂN DUYỆT, P1, BÌNH THẠNH, TP HCM', N'NGUYỄN THỊ THANH TRÂM', '0907772040', '1', 'xuanntn', CONVERT(DATETIME, '2023-04-11 08:49:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthithanhtram@vietbank.com.vn', 'BUYNEW', 3, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000042', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Ngân sách 2023', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'289 Mê Linh - Liên Bảo - Vĩnh Yên - Vĩnh Phúc', N'Nguyễn Thị Thu Hà', '0964091983', '1', 'hantt1', CONVERT(DATETIME, '2023-04-11 09:16:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthithuha1@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000043', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'cấp mới', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'119-121 Nguyễn Văn Linh', N'Trần Thị Tâm Hiền', '0905825282', '1', 'duongntt1100', CONVERT(DATETIME, '2023-04-11 09:42:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'tranthitamhien@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000044', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'Phục vụ công việc lưu trữ chứng từ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'96-98-100 Bàu Cát, P.14, Q.Tân Bình', N'Nguyễn Thị Thu Hảo', '0976717570', '1', 'haontt', CONVERT(DATETIME, '2023-04-11 09:48:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthithuhao@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000047', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'LƯU TRỮ CHỨNG TỪ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'265 ĐIÊN BIÊN PHỦ, P.HÒA KHÊ, Q .THANH KHÊ, TP ĐÀ NẴNG', N'NGUYỄN THỊ LINH', '0905502739', '1', 'LINHNT09024', CONVERT(DATETIME, '2023-04-11 11:06:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'nguyenthilinh@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000052', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'trang bị tủ đựng hồ sơ chứng từ/vật phẩm quảng cáo', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'160-162-164 Lê Hồng Phong, P. Thành Công, Tp Buôn Ma Thuột, ĐakLak', N'Trần Thị Thái My', '0974875556', '1', 'myttt', NULL, 'E', NULL, NULL, NULL, NULL, '', '', N'tranthithaimy@vietbank.com.vn', 'BUYNEW', 1, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000053', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'phục vụ công việc: lưu trữ hồ sơ, chứng từ, quà tặng, văn phòng phẩm...', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'482 Hoàng Diệu, P. Bình Thuận, Q. Hải Châu, TP Đà Nẵng', N'Trương Thị Phi Phượng', '0905181507', '1', 'dattq0500', CONVERT(DATETIME, '2023-04-12 09:05:00.000', 121), 'U', 'huongdtt1104', CONVERT(DATETIME, '2023-04-12 10:14:00.000', 121), NULL, NULL, '', '', N'truongthiphiphuong@vietbank.com.vn', 'BUYNEW', 5, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'));

EXEC SYS_CodeMasters_Gen 'TR_REQUEST_SHOP_DOC_DT', @l_REQDT_ID out INSERT INTO TR_REQUEST_SHOP_DOC_DT (REQDT_ID, REQ_DOC_ID, PLAN_ID, TRADE_ID, ASS_GROUP_ID, ASS_GROUP_CODE, ASS_GROUP_NAME, PL_ID, DESCRIPTION, REASON, ASS_ID, ASS_NAME, ASS_TYPE, UNIT_ID, QUANTITY, PRICE, TOTAL_AMT, NOTES, RECEIVE_BRANCH, RECEIVE_ADDR, RECEIVE_PERSON, RECEIVE_TEL, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, NOTES_DVCM, QUANTITY_USE, RECEIVE_SUBBRANCH, RECEIVE_DEP, RECEIVE_EMAIL, REQ_DT_TYPE, QTY_ETM, EMP_ID, EMP_CODE, AFTER_APPROVE, RECEIVE_FATHER, BRANCH_OLD, SUBBRANCH_OLD, FATHER_OLD, DEP_OLD, TYPE_XL, STATUS_DETAIL, WARRANTY_EXPIRATION_DT, EXPORT_USE_DT, REPAIR_REASON, ALLOCATED, IS_DVCM) VALUES

(@l_REQDT_ID, 'TRSD00000000056', '', '', 'ASG000000001407', NULL, NULL, NULL, N'', N'lưu trữ hồ sơ', '', NULL, NULL, '', NULL, NULL, NULL, N'', '', N'39 Cầu Diễn, Phúc Diễn, Bắc Từ Liêm, Hà Nội', N'Mai Thị Thảo', '0948848287', '1', 'thaomt0813', CONVERT(DATETIME, '2023-04-12 12:58:00.000', 121), 'U', NULL, NULL, NULL, NULL, '', '', N'maithithao@vietbank.com.vn', 'BUYNEW', 2, '', '', NULL, NULL, NULL, NULL, NULL, NULL, 'BUYNEW', NULL, NULL, NULL, NULL, 0, CONVERT(bit, 'False'))