XML File Format for Uploading Price Items
Before uploading a price item file through the File Upload Interface utility, you need to ensure that the XML file contains the following tags:
| Tag Name | Tag Description | Mandatory (Yes or No) | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| C1_PRICEITEM_BO | Used to specify the details of the price item or price item bundle whose record you want to create or update in the system. | Yes | ||||||||
| priceItemCode | 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 | ||||||||
| priceItemAvailFor | 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 | ||||||||
| priceItemType | 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 | ||||||||
| piStatusFlag | Used to indicate the status of the price item or price item
bundle. The valid values are:
|
Yes | ||||||||
| bundleSw | Used to indicate whether you want to define a price item
bundle. The valid values are:
|
Yes | ||||||||
| bundleTypeFlg | 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.
|
||||||||
| asgnGlobalPlSw | Used to indicate whether the price item or price item bundle
can be assigned to a global price list. The valid values are:
|
Yes | ||||||||
| saType | 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.
|
||||||||
| priceItemParm | Used to specify the details of the parameter which you want to associate with the price item or price item bundle. | No | ||||||||
| startDate |
You can use this tag within the following tags:
|
Yes (Conditional) Note: This data is required when you want
to do either of the following:
|
||||||||
| endDate |
You can use this tag within the following tags:
|
No | ||||||||
| priceParmCode | 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.
|
||||||||
| overridePriceParmLabel | 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 | ||||||||
| displayOrder | 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.
|
||||||||
| parmUsageFlg | 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.
|
||||||||
| isRequired | Used to indicate whether the parameter is mandatory while
defining the price item pricing. The valid values are:
|
No | ||||||||
| priorityNum | 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.
|
||||||||
| priceItemParmVal | Used to specify a list of predefined parameter values which
are valid for the price item or price item bundle. Note: The data should
be added in this tag when the value type of the parameter is set to Predefined.
|
No | ||||||||
| priceParmVal | 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.
|
||||||||
| divPriceitem | Used to specify a list of divisions which you want to associate with the price item or price item bundle. | Yes | ||||||||
| division | Used to indicate the division to which you want to associate the price item or price item bundle. | Yes | ||||||||
| priceItemSqi | Used to specify a list of division-specific SQIs for the price item or price item bundle. | No | ||||||||
| serviceQuantityIdentifier | 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.
|
||||||||
| sqlFragment | At present, the data from this tag is not stored in the system. If you want to use this tag, you need to implement a custom logic to meet the requirements. | Not applicable | ||||||||
| sqiCalcAlgCd | At present, the data from this tag is not stored in the system. If you want to use this tag, you need to implement a custom logic to meet the requirements. | Not applicable | ||||||||
| allowIncrUpdateSw | At present, the data from this tag is not stored in the system. If you want to use this tag, you need to implement a custom logic to meet the requirements. | Not applicable | ||||||||
| divPriceItemChar | Used to specify a list of division-specific characteristics for the price item or price item bundle. | No | ||||||||
| characteristicType |
You can use this tag within the following tags:
Note: You must specify a characteristic type which
is already defined in the system. If you are defining a characteristic
for:
|
Yes (Conditional) Note: This data is required when you want
to do the following:
|
||||||||
| effectiveDate |
You can use this tag within the following tags:
|
Yes (Conditional) Note: This data is required when you want
to do the following:
|
||||||||
| characteristicValue |
|
Yes (Conditional) Note: This data is required when you want
to do the following:
|
||||||||
| priceItemChar | Used to specify a list of characteristics for the price item or price item bundle. | No | ||||||||
| priceItemRel | Used to specify a list of price items or price item bundles that you want to associate with the parent price item or add to the price item bundle. | No | ||||||||
| priceItemChildCd | 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:
|
||||||||
| startDate | 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:
|
||||||||
| endDate | 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 | ||||||||
| priceItemReTypeFlg | 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:
|
||||||||
| priceItemParmGroup | Used to specify the parameter and its value based on which you want to determine pricing for the price item or price item bundle. | No | ||||||||
| priceParmCode | Used to specify the parameter using which you want to determine
the pricing for the 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. |
Yes (Conditional) Note: This data is required when you want
to determine the pricing for the price item or price item bundle using
a parameter.
|
||||||||
| priceParmVal | Used to specify the parameter value using which you want
to determine the pricing for the price item or price item bundle. Note: You can specify any special characters except ampersand (&),
comma (,), underscore (_), equal to (=), tilde (~), and semi-colon(;)
in the parameter value.
|
Yes (Conditional) Note: This data is required when you want
to determine the pricing for the price item or price item bundle using
a parameter.
|
||||||||
| priceItemRelCharacteristic | Used to specify a list of relationship-specific characteristics for the price item or price item bundle. | No |
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 XML Format for Uploading Price Items | Sample XML Format for Uploading Price Items |