Customer (C)

A Customer represents an entity with which you negotiate the quotes, contracts, rebate agreements, etc. It can be a sold to, but also a higher level of customer hierarchy.

Fields

customerId – (unique key) Unique ID of the customer.

name – Name of the customer (usually printed on documents).

attribute1..30 – Fields for storing custom properties/attributes of the customer (e.g. sales organization, country, hierarchy levels,…​). Ideally, values of these attributes should not change in time because there is no value history kept. For keeping attribute values, which also depend on time, it is better to use the Customer Extension table.

isParent – (Boolean) Determines if this record is a parent (i.e. higher level of customer hierarchy).

parentId – ID of the customer record which represents a parent of this record in a customer hierarchy.