-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsample_tag_data.sql
More file actions
146 lines (144 loc) · 4.93 KB
/
sample_tag_data.sql
File metadata and controls
146 lines (144 loc) · 4.93 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
SET DEFINE OFF;
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(1, '<ACC_TYPE_CORPORATE>', '1', 'ACC_TYPE_CORPORATE', 'Kurumsal uyelik tipi degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(2, '<ACC_TYPE_INDIVIDUAL>', '0', 'ACC_TYPE_INDIVIDUAL', 'Bireysel uyelik tipi degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(3, '<ACC_SEGMENT_STANDARD>', '0', 'ACC_SEGMENT_STANDARD', 'Standard segment degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(4, '<ACC_SEGMENT_SILVER>', '1', 'ACC_SEGMENT_SILVER', 'Silver segment degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(5, '<ACC_SEGMENT_GOLD>', '2', 'ACC_SEGMENT_GOLD', 'Gold segment degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(6, '<ACC_REGION_LOCAL>', '0', 'ACC_REGION_LOCAL', 'Yerli region degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(7, '<ACC_REGION_FOREIGN>', '1', 'ACC_REGION_FOREIGN', 'Yabanci region degeri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(8, '<LMT_LOCAL_CORPORATE>', '20', 'LMT_LOCAL_CORPORATE', 'Yerli kurumsal uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(9, '<LMT_FOREIGN_CORPORATE>', '25', 'LMT_FOREIGN_CORPORATE', 'Yabanci kurumsal uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(10, '<LMT_LOCAL_GOLD>', '30', 'LMT_LOCAL_GOLD', 'Yerli gold uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(11, '<LMT_LOCAL_SILVER>', '30', 'LMT_LOCAL_SILVER', 'Yerli silver uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(12, '<LMT_LOCAL_STANDARD>', '20', 'LMT_LOCAL_STANDARD', 'Yerli standard uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(13, '<LMT_FOREIGN_GOLD>', '30', 'LMT_FOREIGN_GOLD', 'Yabanci gold uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(14, '<LMT_FOREIGN_STANDARD>', '20', 'LMT_FOREIGN_STANDARD', 'Yabanci standard uye borc limit degeri',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(15, '<BORC_DONEMI_1>', '-1-', 'BORC_DONEMI_1', 'Icinde bulunulan donem 1 olmak uzere geriye dogru fatura donemi/donemleri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(16, '<BORC_DONEMI_2>', '-2-', 'BORC_DONEMI_2', 'Icinde bulunulan donem 1 olmak uzere geriye dogru fatura donemi/donemleri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(17, '<BORC_DONEMI_1_2>', '-1-2-', 'BORC_DONEMI_1_2', 'Icinde bulunulan donem 1 olmak uzere geriye dogru fatura donemi/donemleri',
'1');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(18, '<PREPARATION_TABLE>', 'BATCH_COLLECTION', 'PREPARATION_TABLE', 'Batch verisi hazirlama tablosu',
'0');
Insert into SB_QUERY_TAGS
(T_ID, TAG, TAG_VALUE, TAG_NAME, TAG_DESCRIPTION,
TAG_QUOTED)
Values
(19, '<LIMIT_IHMAL_EDILECEK>', '6', 'LIMIT_IHMAL_EDILECEK', 'Ihmal edilecek borc tutari limit degeri',
'0');
COMMIT;
SET DEFINE OFF;
Insert into SB_QUERY_LIST_TAG_INFO
(L_ID, LIST_TAG, TAG_NAME, TAG_DESCRIPTION)
Values
(1, '<<ACC_SEGMENTLERI_LOCAL_INDIVIDUAL>>', 'ACC_SEGMENTLERI_LOCAL_INDIVIDUAL', 'Yerel bireysel uyelik segmentleri');
Insert into SB_QUERY_LIST_TAG_INFO
(L_ID, LIST_TAG, TAG_NAME, TAG_DESCRIPTION)
Values
(2, '<<ACC_SEGMENTLERI_FOREIGN_CORPORATE>>', 'ACC_SEGMENTLERI_FOREIGN_CORPORATE', 'Yabanci kurumsal uyelik segmentleri');
Insert into SB_QUERY_LIST_TAG_INFO
(L_ID, LIST_TAG, TAG_NAME, TAG_DESCRIPTION)
Values
(3, '<<BORC_DONEMLERI_SON_2>>', 'BORC_DONEMLERI_SON_2', 'Sadece son 2 donemden borcu olanlar icin borclu sayilacagi donem kombinasyonlari');
COMMIT;
SET DEFINE OFF;
Insert into SB_QUERY_LIST_TAGS
(L_ID, T_FROM_ID, T_TO_ID)
Values
(1, 3, 5);
Insert into SB_QUERY_LIST_TAGS
(L_ID, T_FROM_ID, T_TO_ID)
Values
(2, 3, 4);
Insert into SB_QUERY_LIST_TAGS
(L_ID, T_FROM_ID, T_TO_ID)
Values
(3, 16, 17);
COMMIT;