Page Comparison

...

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 “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

Quote - attribute extension

Price Records - attribute 1..30

Price Records In theory unlimited (with Attribute Extension)- attribute extension

255

unlimited

255

unlimited

Promotions and Agreement

Promotion agreement - attribute extension

unlimited

Analytics

Data Feed
, Data Source
, Datamart

255 for Text type
4000 for LOB

Quoting

Code Block

CREATE TABLE `Quote` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createDate` datetime DEFAULT NULL,
  `createdBy` bigint(20) DEFAULT NULL,
  `deleteDate` datetime DEFAULT NULL,
  `deletedBy` bigint(20) DEFAULT NULL,
  `isDeleted` bit(1) NOT NULL,
  `lastUpdateBy` bigint(20) DEFAULT NULL,
  `lastUpdateDate` datetime DEFAULT NULL,
  `version` bigint(20) DEFAULT NULL,
  `label` varchar(255) DEFAULT NULL,
  `uniqueName` varchar(255) DEFAULT NULL,
  `calculationStatus` int(11) NOT NULL,
  `createdByName` varchar(255) DEFAULT NULL,
  `customerId` varchar(255) DEFAULT NULL,
  `customerName` varchar(255) DEFAULT NULL,
  `dirty` bit(1) NOT NULL,
  `expiryDate` datetime DEFAULT NULL,
  `externalRef` varchar(255) DEFAULT NULL,
  `inputsJson` longtext DEFAULT NULL,
  `lastUpdateByName` varchar(255) DEFAULT NULL,
  `nodeId` bigint(20) DEFAULT NULL,
  `outputsJson` longtext DEFAULT NULL,
  `quoteStatus` int(11) DEFAULT NULL,
  `viewStateJson` longtext DEFAULT NULL,
  `targetDate` datetime DEFAULT NULL,
  `userGroupEdit` varchar(255) DEFAULT NULL,
  `userGroupViewDetails` varchar(255) DEFAULT NULL,
  `workflowStatus` int(11) DEFAULT NULL,
  `partition_id` bigint(20) DEFAULT NULL,
  `submittedByName` varchar(255) DEFAULT NULL,
  `wfLastExecutedByName` varchar(255) DEFAULT NULL,
  `headerText` longtext DEFAULT NULL,
  `additionalInfo1` decimal(20,5) DEFAULT NULL,
  `additionalInfo2` decimal(20,5) DEFAULT NULL,
  `additionalInfo3` varchar(255) DEFAULT NULL,
  `additionalInfo4` varchar(255) DEFAULT NULL,
  `refreshInputs` bit(1) NOT NULL,
  `prevRevUN` varchar(255) DEFAULT NULL,
  `supersededByUN` varchar(255) DEFAULT NULL,
  `appReqEmailAttachmentsJson` varchar(255) DEFAULT NULL,
  `numberOfAttachments` int(11) DEFAULT NULL,
  `cgFieldLabel` varchar(255) DEFAULT NULL,
  `cgFieldName` varchar(255) DEFAULT NULL,
  `cgFieldValue` varchar(255) DEFAULT NULL,
  `cgLabel` varchar(255) DEFAULT NULL,
  `renderInfoJson` longtext DEFAULT NULL,
  `creationWorkflowStatus` int(11) DEFAULT NULL,
  `creationWorkflowCurrentStep` int(11) DEFAULT NULL,
  `creationWorkflowStepCount` int(11) DEFAULT NULL,
  `creationWorkflowStepLabel` varchar(255) DEFAULT NULL,
  `attributeExtension` longtext DEFAULT NULL,
  `ioMeta` longtext DEFAULT NULL,
  `quoteTypeUniqueName` varchar(255) DEFAULT NULL,
  `signature` longtext DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `rootUN` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `partition_id` (`partition_id`,`uniqueName`),
  KEY `FK4AC4E5C2418DABE` (`partition_id`),
  KEY `externalRefIndex` (`partition_id`,`externalRef`),
  CONSTRAINT `FK4AC4E5C2418DABE` FOREIGN KEY (`partition_id`)
      REFERENCES `Partitions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30939 DEFAULT CHARSET=utf8;

Name of Logic

Name of Logic in Classic

Name of Logic in Unity

???

Rebates

Rebate agreement - attribute extension

Rebate Records attribute1..100

Payout Record attribute1..100

unlimited

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.

...

Versions Compared

Old Version 12

New Version 13

Key