CSV File Format for Uploading Product Versions

Before uploading a product version file through the File Upload Interface utility, you need to ensure that the CSV file contains the following data:

Data Description Mandatory (Yes or No)
Product Used to specify the product version. Yes
Effective Date Used to specify the date from when the product version is effective. Yes
Version Description Used to specify the description for the product version. Yes
Terms and Conditions Used to specify the terms and conditions that are applicable for the product version. No
Characteristic Type Used to specify the characteristic type. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product version.
Effective Date Used to specify the date from when the characteristic is effective for the product version. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product version.
Characteristic Value Used to specify the value for the characteristic type. Yes (Conditional)
Note: This data is required when you want to define a characteristic for the product version.
Eligibility Usage Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Start Date Used to specify the date from when the eligibility criteria is effective for the product version. Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
End Date Used to specify the date till when the eligibility criteria is effective for the product version. No
Description Used to specify the description for the eligibility criteria. Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Sequence Number Used to specify the order in which the product version eligibility criteria should be executed. Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Parameter Used to specify the parameter (on the left hand side) which is used in the pricing eligibility criteria. Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Operator Used to specify the relational operator to define the relation between the parameter name and value. The valid values are:
  • <

  • <=

  • <>

  • =

  • >

  • >=

  • BETW

  • IN

  • LIKE

  • NTIN

Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Parameter Value Used to specify the parameter value (on the right hand side) against which you want to compare the parameter (on the left hand side). Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Parameter Value Type Used to specify the parameter value against which you want to compare the parameter. Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
rhsPriceParmVal Used to specify the predefined parameter value for the parameter (on the right hand side) against which you want to compare the parameter (on the left hand side). Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Is True Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Is False Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Is Insufficient Yes (Conditional)
Note: This data is required when you want to define an eligibility criteria for the product version.
Price List Id Used to indicate the price list that you want to associate with the product version. Yes (Conditional)
Note: This data is required when you want to define a price list for the pricing of the product version.
Product Service Used to indicate the predefined service for the product version. Yes (Conditional)
Note: This data is required when you want to associate a predefined service for a product version.
Mandatory Used to specify whether the service is mandatory or not. Yes (Conditional)
Note: This data is required when you want to associate a predefined service for a product version.
Product Used to specify the product which you want to associate with the product version. Yes (Conditional)
Note: This data is required when you want to associate a product with a product version.
Product Service Used to specify the predefined service of the associated product. Yes (Conditional)
Note: This data is required when you want to associate a product with a product version.
Inclusion Used to specify whether the service should be included while defining the pricing of the product version. The valid values are:
  • Y

  • N

Yes (Conditional)
Note: This data is required when you want to associate a product with a product version.