Sample CSV Format for Uploading Parameters

Using the below example, you can create the following parameters:

  • Country

  • Currency

Note: The system will create the above parameters when the required fields, characteristic types, usage amount, usage counter, validation algorithm, referenced tables, and referenced fields are defined in the application.
The following table lists the field transformation details that you need to specify in the file request type using which you want to upload parameters in the system:
Sequence Field Name Map Field XPath
1 Parameter C1_​PRICE_​PARM_​BO/priceParmCode
2 Description C1_​PRICE_​PARM_​BO/description
3 Value Type C1_​PRICE_​PARM_​BO/priceParmTypeFlag
4 Source Entity C1_​PRICE_​PARM_​BO/sourceEntityFlg
5 Source Type C1_​PRICE_​PARM_​BO/sourceTypeFlg
6 Source Type Code C1_​PRICE_​PARM_​BO/sourceTypeCode
7 Validation Algorithm C1_​PRICE_​PARM_​BO/validationAlgoCd
8 Reference Entity C1_​PRICE_​PARM_​BO/referredTable
9 Field Name C1_​PRICE_​PARM_​BO/referredField
10 Parameter Values C1_​PRICE_​PARM_​BO/0/priceParmValue/priceParmVal
11 Description C1_​PRICE_​PARM_​BO/0/priceParmValue/descr
12 Parameter Values C1_​PRICE_​PARM_​BO/1/priceParmValue/priceParmVal
13 Description C1_​PRICE_​PARM_​BO/1/priceParmValue/descr
14 Parameter Values C1_​PRICE_​PARM_​BO/2/priceParmValue/priceParmVal
15 Description C1_​PRICE_​PARM_​BO/2/priceParmValue/descr
16 Parameter Values C1_​PRICE_​PARM_​BO/3/priceParmValue/priceParmVal
17 Description C1_​PRICE_​PARM_​BO/3/priceParmValue/descr
18 Parameter Values C1_​PRICE_​PARM_​BO/4/priceParmValue/priceParmVal
19 Description C1_​PRICE_​PARM_​BO/4/priceParmValue/descr
20 Parameter Values C1_​PRICE_​PARM_​BO/5/priceParmValue/priceParmVal
21 Description C1_​PRICE_​PARM_​BO/5/priceParmValue/descr
22 Parameter Values C1_​PRICE_​PARM_​BO/6/priceParmValue/priceParmVal
23 Description C1_​PRICE_​PARM_​BO/6/priceParmValue/descr
24 Parameter Values C1_​PRICE_​PARM_​BO/7/priceParmValue/priceParmVal
25 Description C1_​PRICE_​PARM_​BO/7/priceParmValue/descr
26 Parameter Values C1_​PRICE_​PARM_​BO/8/priceParmValue/priceParmVal
27 Description C1_​PRICE_​PARM_​BO/8/priceParmValue/descr
28 Parameter Values C1_​PRICE_​PARM_​BO/9/priceParmValue/priceParmVal
29 Description C1_​PRICE_​PARM_​BO/9/priceParmValue/descr
30 Parameter Values C1_​PRICE_​PARM_​BO/10/priceParmValue/priceParmVal
31 Description C1_​PRICE_​PARM_​BO/10/priceParmValue/descr
32 Parameter Values C1_​PRICE_​PARM_​BO/11/priceParmValue/priceParmVal
33 Description C1_​PRICE_​PARM_​BO/11/priceParmValue/descr
34 Parameter Values C1_​PRICE_​PARM_​BO/12/priceParmValue/priceParmVal
35 Description C1_​PRICE_​PARM_​BO/12/priceParmValue/descr
36 Parameter Values C1_​PRICE_​PARM_​BO/13/priceParmValue/priceParmVal
37 Description C1_​PRICE_​PARM_​BO/13/priceParmValue/descr
38 Parameter Values C1_​PRICE_​PARM_​BO/14/priceParmValue/priceParmVal
39 Description C1_​PRICE_​PARM_​BO/14/priceParmValue/descr
40 Parameter Values C1_​PRICE_​PARM_​BO/15/priceParmValue/priceParmVal
41 Description C1_​PRICE_​PARM_​BO/15/priceParmValue/descr
42 Parameter Values C1_​PRICE_​PARM_​BO/16/priceParmValue/priceParmVal
43 Description C1_​PRICE_​PARM_​BO/16/priceParmValue/descr
44 Parameter Values C1_​PRICE_​PARM_​BO/17/priceParmValue/priceParmVal
45 Description C1_​PRICE_​PARM_​BO/17/priceParmValue/descr
46 Parameter Values C1_​PRICE_​PARM_​BO/18/priceParmValue/priceParmVal
47 Description C1_​PRICE_​PARM_​BO/18/priceParmValue/descr
48 Parameter Values C1_​PRICE_​PARM_​BO/19/priceParmValue/priceParmVal
49 Description C1_​PRICE_​PARM_​BO/19/priceParmValue/descr
50 Parameter Values C1_​PRICE_​PARM_​BO/20/priceParmValue/priceParmVal
51 Description C1_​PRICE_​PARM_​BO/20/priceParmValue/descr
52 Parameter Values C1_​PRICE_​PARM_​BO/21/priceParmValue/priceParmVal
53 Description C1_​PRICE_​PARM_​BO/21/priceParmValue/descr
54 Pricing Eligibility Criteria C1_​PRICE_​PARM_​BO/pricingEligibilitySw
55 Price Item C1_​PRICE_​PARM_​BO/priceItemSw
56 Price List Eligibility Criteria C1_​PRICE_​PARM_​BO/priceListEligibilitySw
57 Product Eligibility Criteria C1_​PRICE_​PARM_​BO/productEligibilitySw
58 Parameter C1_​PRICE_​PARM_​BO/priceParmCode
59 Description C1_​PRICE_​PARM_​BO/description
60 Value Type C1_​PRICE_​PARM_​BO/priceParmTypeFlag
61 Source Entity C1_​PRICE_​PARM_​BO/sourceEntityFlg
62 Source Type C1_​PRICE_​PARM_​BO/sourceTypeFlg
63 Source Type Code C1_​PRICE_​PARM_​BO/sourceTypeCode
64 Validation Algorithm C1_​PRICE_​PARM_​BO/validationAlgoCd
65 Reference Entity C1_​PRICE_​PARM_​BO/referredTable
66 Field Name C1_​PRICE_​PARM_​BO/referredField
67 Parameter Values C1_​PRICE_​PARM_​BO/0/priceParmValue/priceParmVal
68 Description C1_​PRICE_​PARM_​BO/0/priceParmValue/descr
69 Parameter Values C1_​PRICE_​PARM_​BO/1/priceParmValue/priceParmVal
70 Description C1_​PRICE_​PARM_​BO/1/priceParmValue/descr
71 Parameter Values C1_​PRICE_​PARM_​BO/2/priceParmValue/priceParmVal
72 Description C1_​PRICE_​PARM_​BO/2/priceParmValue/descr
73 Parameter Values C1_​PRICE_​PARM_​BO/3/priceParmValue/priceParmVal
74 Description C1_​PRICE_​PARM_​BO/3/priceParmValue/descr
75 Parameter Values C1_​PRICE_​PARM_​BO/4/priceParmValue/priceParmVal
76 Description C1_​PRICE_​PARM_​BO/4/priceParmValue/descr
77 Parameter Values C1_​PRICE_​PARM_​BO/5/priceParmValue/priceParmVal
78 Description C1_​PRICE_​PARM_​BO/5/priceParmValue/descr
79 Parameter Values C1_​PRICE_​PARM_​BO/6/priceParmValue/priceParmVal
80 Description C1_​PRICE_​PARM_​BO/6/priceParmValue/descr
81 Parameter Values C1_​PRICE_​PARM_​BO/7/priceParmValue/priceParmVal
82 Description C1_​PRICE_​PARM_​BO/7/priceParmValue/descr
83 Parameter Values C1_​PRICE_​PARM_​BO/8/priceParmValue/priceParmVal
84 Description C1_​PRICE_​PARM_​BO/8/priceParmValue/descr
85 Parameter Values C1_​PRICE_​PARM_​BO/9/priceParmValue/priceParmVal
86 Description C1_​PRICE_​PARM_​BO/9/priceParmValue/descr
87 Parameter Values C1_​PRICE_​PARM_​BO/10/priceParmValue/priceParmVal
88 Description C1_​PRICE_​PARM_​BO/10/priceParmValue/descr
89 Parameter Values C1_​PRICE_​PARM_​BO/11/priceParmValue/priceParmVal
90 Description C1_​PRICE_​PARM_​BO/11/priceParmValue/descr
91 Parameter Values C1_​PRICE_​PARM_​BO/12/priceParmValue/priceParmVal
92 Description C1_​PRICE_​PARM_​BO/12/priceParmValue/descr
93 Parameter Values C1_​PRICE_​PARM_​BO/13/priceParmValue/priceParmVal
94 Description C1_​PRICE_​PARM_​BO/13/priceParmValue/descr
95 Parameter Values C1_​PRICE_​PARM_​BO/14/priceParmValue/priceParmVal
96 Description C1_​PRICE_​PARM_​BO/14/priceParmValue/descr
97 Parameter Values C1_​PRICE_​PARM_​BO/15/priceParmValue/priceParmVal
98 Description C1_​PRICE_​PARM_​BO/15/priceParmValue/descr
99 Parameter Values C1_​PRICE_​PARM_​BO/16/priceParmValue/priceParmVal
100 Description C1_​PRICE_​PARM_​BO/16/priceParmValue/descr
101 Parameter Values C1_​PRICE_​PARM_​BO/17/priceParmValue/priceParmVal
102 Description C1_​PRICE_​PARM_​BO/17/priceParmValue/descr
103 Parameter Values C1_​PRICE_​PARM_​BO/18/priceParmValue/priceParmVal
104 Description C1_​PRICE_​PARM_​BO/18/priceParmValue/descr
105 Parameter Values C1_​PRICE_​PARM_​BO/19/priceParmValue/priceParmVal
106 Description C1_​PRICE_​PARM_​BO/19/priceParmValue/descr
107 Parameter Values C1_​PRICE_​PARM_​BO/20/priceParmValue/priceParmVal
108 Description C1_​PRICE_​PARM_​BO/20/priceParmValue/descr
109 Parameter Values C1_​PRICE_​PARM_​BO/21/priceParmValue/priceParmVal
110 Description C1_​PRICE_​PARM_​BO/21/priceParmValue/descr
111 Pricing Eligibility Criteria C1_​PRICE_​PARM_​BO/pricingEligibilitySw
112 Price Item C1_​PRICE_​PARM_​BO/priceItemSw
113 Price List Eligibility Criteria C1_​PRICE_​PARM_​BO/priceListEligibilitySw
114 Product Eligibility Criteria C1_​PRICE_​PARM_​BO/productEligibilitySw

Sample CSV

The figure illustrates the contents of a sample CSV file which contains the parameter data.

Related Topics

For more information on... See...
CSV File Format for Uploading Parameters CSV File Format for Uploading Parameters