Sample CSV Format for Uploading Product Versions

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

For more information on... See...
CSV File Format for Uploading Product Versions CSV File Format for Uploading Product Versions