Maximum Length of Fields

This section summarizes the maximum length of customizable text/string fields in database, like attribute1, attribute2, and other string fields.

The values are in characters in UTF-8 - max 3bytes/char (no UTF-8 4byte chars).
If numeric values are stored, they are stored in their string representation. This applies to Postgres numeric values too.
In Analytics DB, Number and Money fields are defined as DECIMAL(19,4), which is quite usual for financial applications. This is how they are stored; precision in calculations is up to the logic.

Module	“Text” Fields of Tables	Length (chars)

Module	“Text” Fields of Tables	Length (chars)
Master Data	Product Customer Product/Customer Extensions (with exception of PX50 & CX50) AttributeXX columns Matrix Lookup table Product references Competition data BoM data	255
Master Data	JSON lookup table – attribute extensions	unlimited
Master Data	PX50 / CX50 attribute1..50	70
Price Setting	Price Grid item attribute1..100 Price List item attribute1..100 Simulation item attribute1..100	70
Quoting	Quote.label	255
	Quote – attribute extension	unlimited
	Price Records – attribute 1..30	255
	Price Records – attribute extension	unlimited
Promotions and Agreement	Promotion agreement – attribute extension	unlimited
Analytics	Data Feed Data Source Datamart	255 for Text 4000 for LOB
Rebates	Rebate agreement – attribute extension	unlimited
	Rebate Records attribute1..100	70
	Payout Record attribute1..100	70
Compensation	Compensation agreement - attribute extension	unlimited

This may come in handy when e.g., loading data or working with an Excel spreadsheet containing sheets with definitions of Data Sources, Customers, CXs, Products and PXs.

Since version 13.0.2 (July 2024), the field lengths are shown in Metadata tool window in Studio.