Item Price List Master Data Template File Description

The fields in the item_pricelist_template.csv file and the conditions to be maintained when updating this file are described.

Header Field Description
ITEM_PRICELIST Indicates the title of the entity type. Do not modify this row and its contents.
RECORDID (ACTRID) Indicates the identifier of the record for action to be performed. Do not modify the order of this field in the msater data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
ACTION Specify the action to be performed on this record. The valid values are Manage, Create, Modify and Delete. The default value is Manage.
RECORDID (ITMPRCRID1) Indicates the identifier of the record for the price list details. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
PRCLSTNAME Enter the name of the price list. This is a mandatory field. The master data upload will fail if you do not provide a value in this field.
RECORDID (ITMPRCRID2) Indicates the identifier of the record for the price list of the corresponding line. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
ITEMID Enter the identifier of the item. This is a mandatory field. The master data upload will fail if you do not provide a value in this field.
LISTPRICE Enter the unit price of the item.
PRICINGSTATUS Specify the status of the price list line. The valid values are ACTIVE and INACTIVE. If the corresponding action is Create, the default value is INACTIVE.
STRTDATEACTIVE Enter the date on which the price list becomes effective in the organization.
ENDDATEACTIVE Enter the date until which the price list is effective in the organization.
Notes:
  • Ensure that the date is entered in the YYYY-MM-DDTHH:MM:SS format or in the YYYY-MM-DD format, for example, 2012-02-03T15:30:25 or 2012-02-03.
  • Before uploading a Item Price List master data file, ensure that the corresponding item and price list exists in the organization.
  • Do not reuse the values of the RECORDID provided in the template file such as ACTRID, ITMPRCRID1, and so on in the other fields such as PRCLSTNAME, ITEMID, and so on. The master data upload will fail if you provide the same values as that of the RECORDID
  • Ensure that none of the fields contain blank values. If you do not want to use a field in the master data file, you must enter an asterisk as the value in that field such that the unused field is disregarded during the master data file upload.
  • The third and fourth rows of the item_pricelist_template.csv file contain sample data.
  • Do not add a line break in a field.
  • Do not localize the master data file.