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.







Found an issue in documentation? Write to us.