Customer (Data Source)

Customer Data Source contains information/attributes about customers which you use for analysis of transactions or customers in a Datamart.

In most scenarios, you will copy the data from Customer Master into this Data Source, so you also need to keep the fields in sync.

The number of customers in this table could be different than the number of records in Customer Master because in analysis you keep data about customers to whom you sold some goods several years back, whereas in Customer Master you only need the active customers.

Fields

The list of fields in Customer Data Source is different in each project, so we will show here the default columns which you can see on a new partition where it will be in sync with the default Customer Master table.

customerId – ID of the customer.

name – Name of the customer as it is used on printed documents.

parentId – Copy of the parentId column from Customer Master.

isParent – If this customer is the actual sold-to customer, or some higher level in the customer hierarchy.

Since 14.0 - Caribou Lou.

Admin users are not allowed to delete any of the default Data Sources created by the system out of the box. This change is related to the following list of Data Sources.

Name	Label

Name	Label
`Customer`	Customer
`Product`	Product
`cal`	Calendar
`ccy`	Currencies
`uom`	Unit of Measures