CSV File Format for Uploading Price Items
| Column Name | Description | Mandatory (Yes or No) |
|---|---|---|
| Price Item | Used to specify the price item or price item bundle. | Yes |
| Description | Used to specify the description for the price item or price item bundle. | Yes |
| Price Item Usage | Used to indicate whether the price item or price item bundle
is used for only pricing or pricing and billing. The valid values
are:
|
Yes |
| Price Item Type | Used to indicate the type of the price item or price item bundle.
If the price item or price item bundle is used for only pricing, the
valid values are:
However, if the price item or price item bundle is used for the pricing and billing, the valid value is:
|
Yes |
| Status | Used to indicate the status of the price item or price item
bundle. The valid values are:
|
Yes |
| Bundle | Used to indicate whether you want to define a price item bundle.
The valid values are:
|
Yes |
| Bundle Type | Used to indicate the type of the price item bundle. If the
price item bundle is available for pricing and billing, the valid
values are:
However, if the price item bundle is available for only pricing and the price item type is set to FEES, the valid value is:
Note: You cannot define a price item bundle when it is available
for only pricing and when the price item type is set to RATE.
|
Yes (Conditional) Note: This data is required when you are creating
a price item bundle.
|
| Global Price List | Used to indicate whether the price item or price item bundle
can be assigned to a global price list. The valid values are:
|
Yes |
| Contract Type | Used to indicate the contract type that you want to associate with the price item or price item bundle. | Yes (Conditional) Note: This data is required when the price
item or price item bundle is used for pricing and billing.
|
| Price Item Parameter Information | ||
| Effective Start Date | Used to specify the date from when the parameter is effective for the price item or price item bundle. | Yes (Conditional) Note: This data is required when you want
to associate a parameter with the price item or price item bundle.
|
| Effective End Date | Used to specify the date till when the parameter is effective for the price item or price item bundle. | No |
| Parameter | Used to indicate the parameter that you want to associate with
the price item or price item bundle. Note:
You must specify a parameter which is already defined in the system. The system allows you to specify only those parameters where the parameter usage is set to Price Item. |
Yes (Conditional) Note: This data is required when you want
to associate a parameter with the price item or price item bundle.
|
| Business Label | Used to specify a business label for the parameter. If the business label is defined for a parameter, the business label appears instead of the parameter name. | No |
| Display Order | Used to indicate the order in which the parameter and its value should be displayed in the price item parameter information string across the application. | Yes (Conditional) Note: This data is required when you want
to associate a parameter with the price item or price item bundle.
|
| Parameter Usage | Used to indicate whether you want to use the parameter for
aggregation and/or for defining the price item pricing. The valid
values are:
|
Yes (Conditional) Note: This data is required when you want
to associate a parameter with the price item or price item bundle.
|
| Mandatory | Used to indicate whether the parameter is mandatory while defining
the price item pricing. The valid values are:
|
No |
| Priority | Used to indicate the priority in which optional parameters should be considered while determining best fit price for the price item or price item bundle. | Yes (Conditional) Note: This data is required when you want
to associate an optional parameter with the price item or price item
bundle.
|
| Predefined Parameter Values for Price Item | ||
| Predefined Parameter Value for Price Item | Used to indicate the predefined parameter value which you can use for the price item or price item bundle while defining the pricing. | Yes (Conditional) Note: This data is required when you want
to define valid predefined parameter values for the price item or
price item bundle.
|
| Division Information | ||
| Division | Used to indicate the division to which you want to associate the price item or price item bundle. | Yes |
| Division-Specific SQIs for Price Item | ||
| SQI | Used to indicate the SQI to which you want to associate the price item or price item bundle in the division. | Yes (Conditional) Note: This data is required when you want
to define a division-specific SQI for the price item or price item
bundle.
|
| Division-Specific Characteristics for Price Item | ||
| Characteristic Type | Used to specify the characteristic type. Note:
You must specify a characteristic type which is already defined in the system. You must specify a characteristic type where the characteristic entity is set to Division/Price Item Combination. |
Yes (Conditional) Note: This data is required when you are defining
a division-specific characteristic for the price item or price item
bundle.
|
| Effective Date | Used to specify the date from when the price item or price item bundle characteristic is effective for the division. | Yes (Conditional) Note: This data is required when you are defining
a division-specific characteristic for the price item or price item
bundle.
|
| Characteristic Value | Used to specify the value for the characteristic type. | Yes (Conditional) Note: This data is required when you are defining
a division-specific characteristic for the price item or price item
bundle.
|
| Price Item Characteristics | ||
| Characteristic Type | Used to specify the characteristic type. Note:
You must specify a characteristic type which is already defined in the system. You must specify a characteristic type where the characteristic entity is set to Price Item. |
Yes (Conditional) Note: This data is required when you are defining
a characteristic for the price item or price item bundle.
|
| Effective Date | Used to specify the date from when the characteristic is effective for the price item or price item bundle. | Yes (Conditional) Note: This data is required when you are defining
a characteristic for the price item or price item bundle.
|
| Characteristic Value | Used to specify the value for the characteristic type. | Yes (Conditional) Note: This data is required when you are defining
a characteristic for the price item or price item bundle.
|
| Price Item Relationship | ||
| Price Item | Used to indicate the price item or price item bundle that you want to associate with the parent price item or add to the price item bundle. | Yes (Conditional) Note: This data is required when you want
to do either of the following:
|
| Effective Start Date | Used to specify the date from when you want to associate the price item or price item bundle with the parent price item or add the price item or price item bundle to the price item bundle. | Yes (Conditional) Note: This data is required when you want
to do either of the following:
|
| Effective End Date | Used to specify the date till when you want to associate the price item or price item bundle with the parent price item or add the price item or price item bundle to the price item bundle. | No |
| Relationship Type | Used to indicate how the price item or price item bundle is
related to the parent price item or price item bundle. The valid values
are:
Note: You must use the OTHR, CG, PROD, SVC, or SVCG relationship type while associating
a price item or price item bundle to the parent price item. However,
you must use the BNDL relationship type while
adding a price item or price item bundle in the regular and phantom
price item bundles. However, you can use the DENB and NUMB relationship type while adding a
price item or price item bundle in the ratio price item bundles.
|
Yes (Conditional) Note: This data is required when you want
to do either of the following:
|
| Price Item Parameter=Parameter Value | Used to specify the parameter and its value using which you
want to determine the pricing for the child price item or price item
bundle. Note:
You must specify a parameter which is associated with the price item or price item bundle and whose parameter usage is set to Pricing. You cannot specify any special character except underscore (_) in the parameter name. You can specify any special characters except ampersand (&), comma (,), underscore (_), equal to (=), tilde (~), and semi-colon(;) in the parameter value. You cannot specify more than 50 parameter and parameter value combinations while uploading the price item file in the CSV format. |
Yes (Conditional) Note: This data is required when you want
to determine the pricing for the child price item or price item bundle
using a parameter.
|
| Relationship-Specific Characteristics for Price Item | ||
| Characteristic Type | Used to specify the characteristic type. Note:
You must specify a characteristic type which is already defined in the system. You must specify a characteristic type where the characteristic entity is set to Price Item Relationship. |
Yes (Conditional) Note: This data is required when you are defining
a relationship-specific characteristic for the price item or price
item bundle.
|
| Effective Date | Used to specify the date from when the relationship-specific characteristic is effective for the price item or price item bundle. | Yes (Conditional) Note: This data is required when you are defining
a relationship-specific characteristic for the price item or price
item bundle.
|
| Characteristic Value | Used to specify the value for the characteristic type. | Yes (Conditional) Note: This data is required when you are defining
a relationship-specific characteristic for the price item or price
item bundle.
|
Related Topics
| For more information on... | See... |
|---|---|
| How to define a price item or price item bundle | Defining a Price Item or Price Item Bundle |
| How to associate a price item or price item bundle with a parameter | Associating a Parameter with a Price Item or Price Item Bundle |
| How to associate a price item or price item bundle with a division | Associating a Price Item or Price Item Bundle with a Division |
| How to associate a price item or price item bundle with an SQI in a particular division | Associating an SQI with a Price Item or Price Item Bundle for a Division |
| How to define a characteristic for a price item or price item bundle in a particular division | Defining a Division-Specific Characteristic for a Price Item or Price Item Bundle |
| How to define a characteristic for a price item or price item bundle | Defining a Characteristic for a Price Item or Price Item Bundle |
| How to define valid predefined parameter values for a price item or price item bundle | Defining the Valid Predefined Parameter Values for a Price Item or Price Item Bundle |
| How to associate a price item or price item bundle with a parent price item | Associating a Price Item or Price Item Bundle with a Parent Price Item |
| How to add a price item or price item bundle to a price item bundle | Adding a Price Item or Price Item Bundle to a Price Item Bundle |
| Sample CSV Format for Uploading Price Items | Sample CSV Format for Uploading Price Items |