Customer Extension (CX#)

A Customer Extension (CX) table stores values for product attributes that:

• Do not fit into the Product table.

• Depend on another dimension, such as time.

There are several CX table sizes—CX3, CX6, CX8 and others. Choose the smallest option that can hold your data to avoid wasting database storage.

Fields

name – Unique name of the Customer Extension table. Every record keeps a back-reference (name of the table) to which is belongs.

customerId – ID of the customer for which this record keeps data.

createdDate – The date and time when the customer extension was added to the table. Hidden by default.

createdBy – The user who added the customer extension to the table. Hidden by default.

lastUpdateDate – The date and time when the customer extension was updated for the last time.

lastUpdateBy – The user who updated the customer extension for the last time. Hidden by default.

attribute1..# – Values of customer attributes. Some attributes can be used as a part of the business key, e.g. validity of this record or for which sales organization this record is valid, etc.

attributeExtension – Attribute extension columns can be added on the top of the table’s regular attribute columns. Stored in the database in JSON format, they allow you to exceed the character limit that applies to regular columns. Available since version 14.0.

Business Key

The CX# table does not have a database unique constraints because you can use also some attributeX fields as a part of the unique key.

So you can define a business key which tells the system which fields form a unique key from business perspective.