Create Product Extension Table

In this tutorial you will learn how to create a new product extension table and set up its columns and preferences. The result can then look in the user interface like this:

Open

Let’s say you need to store data which look like on the screenshot and plan to store them in a product extension table. In this sample, the number in the column Average Cost represents the product cost in Euros.

Open

Create New Product Extension Table

In Pricefx navigate to Administration › Configuration › Master Data › Product Master Extension.

On that page, click the Add button to add a new product extension table.

In the dialog, fill in the following:

• Name = ProductCost. The name is used in the calculation logic when you need to read data from this table.

• Label = Product Cost. Used only in the user interface to identify the product extension table.

• Size = 3. The maximum number of Attribute# fields in a data row. This does not include the out-of-the-box fields, like SKU, etc. In our example, we need only the Average Cost, so we use the lowest value which is 3.

Click OK to save the setup.

Select the new Product Extension by clicking its name. Once selected, the right side of the screen displays the current fields of the master table.

Click Edit for the Attribute1 field.

• Name = AverageCost

• Label = Average Cost

• Type = Real

• Format type = Money (EUR) (Note: this does not set up any currency conversions, it only defines how the value is displayed on the screen.)

Click OK to save the field definition. When the confirmation dialog appears, confirm the change.

View Newly Created Product Extension Table

From the toolbar menu, navigate to Master Data › Product Extensions.

On the Product Extensions page, click the Category drop-down menu.

Review the result. There are no records yet, but you can see the configured fields.

Fetch Product Extension Fields Metadata to Your Project

If you already have your project set up in IntelliJ and the connection to a partition is also set up, fetch the new fields metadata to your project, so that you can store it to Git.