The following table lists the product versions that you want
to create using the CSV format:
Product Version |
Related to... |
Relationship Type |
Pensioners Savings |
|
|
Mortgage Loan Waiver |
|
|
Locker Rental Waiver |
|
|
Prime Credit Card |
|
|
Platinum Debit Card |
|
|
Sr. Citizen Privilege |
|
|
Note that the system will create the above product versions only
when the characteristic types, predefined characteristic values, parameters,
predefined parameter values, are defined in the application. In addition,
the file request type which is used for uploading the product version
file in the CSV format must contain the following field transformation
details:
The following table lists the field transformation details that
you need to specify in the file request type using which you want
to upload product versions in the system:
Sequence |
Field Name |
Map Field XPath |
1 |
Product |
C1_PRODUCT_VER_BO/productCode |
2 |
Effective Date |
C1_PRODUCT_VER_BO/effectiveDate |
3 |
Version Description |
C1_PRODUCT_VER_BO/description |
4 |
Terms and Conditions |
C1_PRODUCT_VER_BO/termsAndCondition |
5 |
Characteristic Type |
C1_PRODUCT_VER_BO/0/productVersionCharacteristic/characteristicType |
6 |
Effective Date |
C1_PRODUCT_VER_BO/0/productVersionCharacteristic/characteristicEffectiveDate |
7 |
Characteristic Value |
C1_PRODUCT_VER_BO/0/productVersionCharacteristic/characteristicValue |
8 |
Eligibility Usage |
C1_PRODUCT_VER_BO/0/productVersionEligibility/eligibilityRuleFlg |
9 |
Start Date |
C1_PRODUCT_VER_BO/0/productVersionEligibility/startDate |
10 |
End Date |
C1_PRODUCT_VER_BO/0/productVersionEligibility/endDate |
11 |
Description |
C1_PRODUCT_VER_BO/0/productVersionEligibility/description |
12 |
Sequence Number |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/sequenceNumber |
13 |
Parameter |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/lhsPriceParmCd |
14 |
Operator |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/operator |
15 |
Parameter Value |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/rhsPriceParmCd |
16 |
Parameter Value Type |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/rhsPriceParmTypeFlg |
17 |
|
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/rhsPriceParmVal |
18 |
Is True |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/trueFlag |
19 |
Is False |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/falseFlag |
20 |
Is Insufficient |
C1_PRODUCT_VER_BO/0/productVersionEligibility/0/productVersionEligibilityDetail/insufficientFlag |
21 |
Sequence Number |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/sequenceNumber |
22 |
Parameter |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/lhsPriceParmCd |
23 |
Operator |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/operator |
24 |
Parameter Value |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/rhsPriceParmCd |
25 |
Parameter Value Type |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/rhsPriceParmTypeFlg |
26 |
|
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/rhsPriceParmVal |
27 |
Is True |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/trueFlag |
28 |
Is False |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/falseFlag |
29 |
Is Insufficient |
C1_PRODUCT_VER_BO/0/productVersionEligibility/1/productVersionEligibilityDetail/insufficientFlag |
30 |
Price List Id |
C1_PRODUCT_VER_BO/0/productVersionPriceList/priceListId |
31 |
Product Service |
C1_PRODUCT_VER_BO/0/productVersionService/serviceCd |
32 |
Mandatory |
C1_PRODUCT_VER_BO/0/productVersionService/mandatorySw |
33 |
Product Service |
C1_PRODUCT_VER_BO/1/productVersionService/serviceCd |
34 |
Mandatory |
C1_PRODUCT_VER_BO/1/productVersionService/mandatorySw |
35 |
Product |
C1_PRODUCT_VER_BO/0/productVersionProduct/productChildCd |
36 |
Product Service |
C1_PRODUCT_VER_BO/0/productVersionProduct/0/productVersionProductService/serviceCd |
37 |
Inclusion |
C1_PRODUCT_VER_BO/0/productVersionProduct/0/productVersionProductService/inclusionSw |
38 |
Product |
C1_PRODUCT_VER_BO/1/productVersionProduct/productChildCd |
39 |
Product Service |
C1_PRODUCT_VER_BO/1/productVersionProduct/0/productVersionProductService/serviceCd |
40 |
Inclusion |
C1_PRODUCT_VER_BO/1/productVersionProduct/0/productVersionProductService/inclusionSw |
41 |
Product |
C1_PRODUCT_VER_BO/2/productVersionProduct/productChildCd |
42 |
Product Service |
C1_PRODUCT_VER_BO/2/productVersionProduct/0/productVersionProductService/serviceCd |
43 |
Inclusion |
C1_PRODUCT_VER_BO/2/productVersionProduct/0/productVersionProductService/inclusionSw |
44 |
Product |
C1_PRODUCT_VER_BO/3/productVersionProduct/productChildCd |
45 |
Product Service |
C1_PRODUCT_VER_BO/3/productVersionProduct/0/productVersionProductService/serviceCd |
46 |
Inclusion |
C1_PRODUCT_VER_BO/3/productVersionProduct/0/productVersionProductService/inclusionSw |
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 |
|
|
147 |
|
|
148 |
|
|
149 |
|
|
150 |
|
|
151 |
|
|
152 |
|
|
153 |
|
|
154 |
|
|
155 |
|
|
156 |
|
|
157 |
|
|
158 |
|
|
159 |
|
|
160 |
|
|
161 |
|
|
162 |
|
|
163 |
|
|
164 |
|
|
165 |
|
|
166 |
|
|
167 |
|
|
168 |
|
|
169 |
|
|
170 |
|
|
171 |
|
|
172 |
|
|
173 |
|
|
174 |
|
|
175 |
|
|
176 |
|
|
177 |
|
|
178 |
|
|
179 |
|
|
180 |
|
|
181 |
|
|
182 |
|
|
183 |
|
|
184 |
|
|
185 |
|
|
186 |
|
|
187 |
|
|
188 |
|
|
189 |
|
|
190 |
|
|
191 |
|
|
192 |
|
|
193 |
|
|
194 |
|
|
195 |
|
|
196 |
|
|
197 |
|
|
198 |
|
|
199 |
|
|
200 |
|
|
201 |
|
|
202 |
|
|
203 |
|
|
204 |
|
|
205 |
|
|
206 |
|
|
207 |
|
|
208 |
|
|
209 |
|
|
210 |
|
|
211 |
|
|
212 |
|
|
213 |
|
|
214 |
|
|
215 |
|
|
216 |
|
|
217 |
|
|
218 |
|
|
219 |
|
|
220 |
|
|
221 |
|
|
222 |
|
|
223 |
|
|
224 |
|
|
225 |
|
|
226 |
|
|
227 |
|
|
228 |
|
|
229 |
|
|
230 |
|
|
231 |
|
|
232 |
|
|
233 |
|
|
234 |
|
|
235 |
|
|
236 |
|
|
237 |
|
|
238 |
|
|
239 |
|
|
240 |
|
|
241 |
|
|
242 |
|
|
243 |
|
|
244 |
|
|
245 |
|
|
246 |
|
|
247 |
|
|
248 |
|
|
249 |
|
|
250 |
|
|
251 |
|
|
252 |
|
|
253 |
|
|
254 |
|
|
255 |
|
|
256 |
|
|
257 |
|
|
258 |
|
|
259 |
|
|
260 |
|
|
261 |
|
|
262 |
|
|
263 |
|
|
264 |
|
|
265 |
|
|
266 |
|
|
267 |
|
|
268 |
|
|
269 |
|
|
270 |
|
|
271 |
|
|
272 |
|
|
273 |
|
|
274 |
|
|
275 |
|
|
276 |
|
|
100,2019-01-01,Pensioners Savings,,,,,ELIG,,,elgcode,,,,,,,,,,,,,,,,,,,001,INTRATE,Y,,,,,,,,,,,,,,,111,2019-01-01,Mortgage Loan Waiver,,,,,ELIG,,,elgcode,,,,,,,,,,,,,,,,,,,001,LOANWAV,Y,,,,,,,,,,,,,,,112,2019-01-01,Locker Rental Waiver,,,,,ELIG,,,elgcode,,,,,,,,,,,,,,,,,,,001,RENTWAV,Y,,,,,,,,,,,,,,,113,2019-01-01,Prime Credit Card,,,,,ELIG,,,elgcode,,,,,,,,,,,,,,,,,,,001,PRIMECCARD,Y,,,,,,,,,,,,,,,114,2019-01-01,Platinum Debit Card,,,,,ELIG,,,elgcode,,,,,,,,,,,,,,,,,,,001,PTDBCARD,N,,,,,,,,,,,,,,,101,2019-01-01,Sr. Citizen Privilege,,Product Usage,2019-01-01,SAVINGACCT,ELIG,2019-01-01,2019-12-31,Age and Resident Eligibility,10,AGE,=,,,60,COND,RLFS,RLFS,20,Indian Resident,=,,,Y,RLTR,RLFS,RLFS,001,UNLATMTXN,Y,SWEEPFCLTY,N,111,LOANWAV,Y,112,RENTWAV,Y,113,PRIMECCARD,Y,114,PTDBCARD,Y
Related Topics