--------BBXG DƯỚI 100-----------
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_DUOI_100M''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_DUOI_100M_DT''' -- varchar(800)

---------BXXG 100-500-------------
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_DT_DGC''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_DT_XG''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_XH''' -- varchar(800)

---------BBXG TRÊN 500------------
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_DGVG''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_DPG''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_KNNLNT''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_KT''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_XH''' -- varchar(800)

----------ĐÁNH GIÁ NCC------------
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_RATE_SUPPLIER_MASTER''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_RATE_SUPPLIER_DT''' -- varchar(800)

--------TỜ TRÌNH CDT--------------
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''PL_APPOINT_CONTRACTOR''' -- varchar(800)
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
@from = 'FROM SYS_PREFIX WHERE ID = ''PL_APPOINT_CONTRACTOR_DT''' -- varchar(800)


--------TR_XETGIA_100M_500M_REQ_SECTION----------
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_100M_500M_REQ_SECTION', -- varchar(776)
@from = 'FROM TR_XETGIA_100M_500M_REQ_SECTION' -- varchar(800)

-------TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT------
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT', -- varchar(776)
@from = 'FROM TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT' -- varchar(800)

----------TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT-----
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT', -- varchar(776)
@from = 'FROM TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT' -- varchar(800)

-----------TR_RATE_SUP_CRITERIA------------------
EXEC dbo.sp_generate_inserts @table_name = 'TR_RATE_SUP_CRITERIA', -- varchar(776)
@from = 'FROM TR_RATE_SUP_CRITERIA' -- varchar(800)



-----------INSERT CM_TRAN_TYPE------------------
INSERT INTO [CM_TRAN_TYPE] ([TRN_TYPE],[TRN_TYPE_NAME],[MODULE],[NOTES])VALUES(N'TRN0000000008',N'Mua sắm trực tiếp (HĐNT)',N'HDNT',N'MSTT(HĐNT)')