Business Keys - Recommendations
Business key (also called "primary key") is a column which uniquely identifies each row in the data. For example, it can be a customer number in a CSM system or SKU number for a product. The business key value can come from a single column or can be composed of several columns (to achieve uniqueness).
General requirements for a business key:
It is unique.
It is always present in the data (i.e., no null values).
It does not change in time.
Pricefx recommendations for business keys:
Do not use values with national special characters. For details see Encoding. Also avoid using other uncommon special characters like %$" etc.
Do not use values with leading (or trailing) spaces or other whitespace characters like tabs.
Found an issue in documentation? Write to us.
Â
Pricefx version 13.1