|
1
|
--------BBXG DƯỚI 100-----------
|
|
2
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
3
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_DUOI_100M''' -- varchar(800)
|
|
4
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
5
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_DUOI_100M_DT''' -- varchar(800)
|
|
6
|
|
|
7
|
---------BXXG 100-500-------------
|
|
8
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
9
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M''' -- varchar(800)
|
|
10
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
11
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_DT_DGC''' -- varchar(800)
|
|
12
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
13
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_DT_XG''' -- varchar(800)
|
|
14
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
15
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_100M_500M_XH''' -- varchar(800)
|
|
16
|
|
|
17
|
---------BBXG TRÊN 500------------
|
|
18
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
19
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M''' -- varchar(800)
|
|
20
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
21
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_DGVG''' -- varchar(800)
|
|
22
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
23
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_DPG''' -- varchar(800)
|
|
24
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
25
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_KNNLNT''' -- varchar(800)
|
|
26
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
27
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_KT''' -- varchar(800)
|
|
28
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
29
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_REQ_DOC_XETGIA_TREN_500M_DT_XH''' -- varchar(800)
|
|
30
|
|
|
31
|
----------ĐÁNH GIÁ NCC------------
|
|
32
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
33
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_RATE_SUPPLIER_MASTER''' -- varchar(800)
|
|
34
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
35
|
@from = 'FROM SYS_PREFIX WHERE ID = ''TR_RATE_SUPPLIER_DT''' -- varchar(800)
|
|
36
|
|
|
37
|
--------TỜ TRÌNH CDT--------------
|
|
38
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
39
|
@from = 'FROM SYS_PREFIX WHERE ID = ''PL_APPOINT_CONTRACTOR''' -- varchar(800)
|
|
40
|
EXEC dbo.sp_generate_inserts @table_name = 'SYS_PREFIX', -- varchar(776)
|
|
41
|
@from = 'FROM SYS_PREFIX WHERE ID = ''PL_APPOINT_CONTRACTOR_DT''' -- varchar(800)
|
|
42
|
|
|
43
|
|
|
44
|
--------TR_XETGIA_100M_500M_REQ_SECTION----------
|
|
45
|
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_100M_500M_REQ_SECTION', -- varchar(776)
|
|
46
|
@from = 'FROM TR_XETGIA_100M_500M_REQ_SECTION' -- varchar(800)
|
|
47
|
|
|
48
|
-------TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT------
|
|
49
|
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT', -- varchar(776)
|
|
50
|
@from = 'FROM TR_XETGIA_TREN_500M_CONTENT_ASSESS_KT' -- varchar(800)
|
|
51
|
|
|
52
|
----------TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT-----
|
|
53
|
EXEC dbo.sp_generate_inserts @table_name = 'TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT', -- varchar(776)
|
|
54
|
@from = 'FROM TR_XETGIA_TREN_500M_CONTENT_ASSESS_NT' -- varchar(800)
|
|
55
|
|
|
56
|
-----------TR_RATE_SUP_CRITERIA------------------
|
|
57
|
EXEC dbo.sp_generate_inserts @table_name = 'TR_RATE_SUP_CRITERIA', -- varchar(776)
|
|
58
|
@from = 'FROM TR_RATE_SUP_CRITERIA' -- varchar(800)
|
|
59
|
|
|
60
|
-----------CM_REPORT_TEMPLATE----------------
|
|
61
|
EXEC dbo.sp_generate_inserts @table_name = 'CM_REPORT_TEMPLATE', -- varchar(776)
|
|
62
|
@from = 'FROM CM_REPORT_TEMPLATE WHERE REPORT_TEMPLATE_STORE = ''rpt_PL_APP_CONTRACTOR_Template''' -- varchar(800)
|
|
63
|
EXEC dbo.sp_generate_inserts @table_name = 'CM_REPORT_TEMPLATE', -- varchar(776)
|
|
64
|
@from = 'FROM CM_REPORT_TEMPLATE WHERE REPORT_TEMPLATE_STORE = ''rpt_PL_REQUEST_FUND_Template''' -- varchar(800)
|
|
65
|
|
|
66
|
-----------INSERT CM_TRAN_TYPE------------------
|
|
67
|
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)')
|