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) |
|---|---|---|
Master Data | Product | 255 |
Master Data | JSON lookup table - attribute extensions | unlimited |
Master Data | PX50 / CX50 attribute1..50 | 70 |
Price Setting | Price Grid item attribute1..100 | 70 |
Quoting | Quote.label Quote - attribute extension Price Records - attribute 1..30 Price Records - attribute extension | 255 unlimited 255 unlimited |
Promotions and Agreement | Promotion agreement - attribute extension | unlimited |
Analytics | Data Feed, Data Source, Datamart | 255 for Text |
Rebates | Rebate agreement - attribute extension Rebate Records attribute1..100 Payout Record attribute1..100 | unlimited 70 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.
See also: Loaddata and Business Key Length