Customers

Overview

This table contains information associated with customers. The customer configuration in CloudBilling impacts how the various fields are populated in the table. For example, let us assume a customer’s country is present in the address line section and not in the Country section in CloudBilling. Now the Country field in the table will be “NULL”. The same applies for the fields City and Postcode. Please ensure that the configuration is done correctly for the tables to be populated correctly.

In CloudBilling, the customers exist in an organised tree structure called Clusters. The default cluster that all newly created clusters and customers belong to is called “All Customers”. For example, consider a customer named “ABC Netherlands” located in the Netherlands. It will have the cluster structure All Customers -> Netherlands -> ABC Global. Here “ABC Global” is the parent cluster, “Netherlands” is the grandparent cluster, and “All Customers” is the great-grandparent cluster. In the dataset table, this structure is defined as:

1. ClusterName = ABC Global
2. ClusterPath0 = All Customers
3. ClusterPath1 = Netherlands
4. ClusterPath2 = ABC Netherlands

For further contextual information on how customers are configured in CloudBilling, view the Customers page.

---

Fields

Name	Type	Description
Key	String	A unique identifier for each customer across the entire dataset.
Code	String	A unique external identifier for a customer used to link purchases with a customer.
Name	String	The name of the customer.
Country	String	The country the customer is located in.
City	String	The city the customer is located in.
Postcode	String	The postcode the customer is located in.
AddressLine1	String
IsSuspended	Boolean	Whether billing is suspended for a customer. If 0, no billing will occur for this customer.
BillFrom	String	The date from which a customer should be billed (yyyymmdd). If not specified, the createdDate is used.
ClusterName	String	The name of the cluster a customer belongs to.
ClusterPath0 . . . ClusterPath6	String	These are seven separate fields that represent the cluster structure a customer belongs to.
	String	The sixth and last level cluster a customer belongs.
Created	String	The date when a customer was created (yyyymmdd).
Modified	String	The most recent date a customer’s properties were changed (yyyymmdd).