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:
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.
Create New Product Extension Table
In Pricefx navigate to .
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 .
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.
