Dela via


Customer in ESG data model

Traits

Traits for this entity are listed here.

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"4.3"stringsemantic version number of the entity

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enBase entity from which all ESG Data Model entities are derived.
enA customer is an individual or legal entity that has or has purchased a product or service.

A potential customer is an individual or legal entity that has the desire to acquire a product or service, the financial ability to pay for that product or service and is located in a location in which the product or service can be delivered to them.

The definition of 'customer' is of critical importance for every organization.

It's the customer that is the focus of product planning, marketing, sales, service, reporting and analytics. Without 'customer' there would be no need for the organization to exist since its purpose is to serve the customer and profit from that interaction.

The definition of 'customer' must be consistent with how customers exist and interact with the organization in the real world. An artificial or conceptual definition of 'customer' that is not consistent with these two objectives is doomed to fail because the data will not be consistent with the definition and employees will not accept concepts or terms that aren't consistent with what they see, know and how they interact with customers on a working basis.

Microsoft defines 'customer' to meet these objectives. When we look out into the real world we see two dominant types of customers: human beings and legal entities.

Human beings are obviously male and female individuals of various ages, sex, demographics and a variety of similar dimensions that describe and define them who purchase products, good and services.

Legal entities are those legally-defined entities such as corporations, partnerships, non-profit organizations, government organizations etc. that purchase products, goods and services.

This view of 'customer' is consistent with the real world and consistent with how employees view and interact with customers.

Of course, that is just the start of identifying, defining and understanding each type of 'customer'. There's a great deal of detail, complexity and related data that can be used to define each type of customer to various levels of detail and different dimensions of information.

Microsoft implements these detailed concepts and related data via two distinct business area models that expand the coverage and complexity of each type of customer:

  • INDIVIDUAL CUSTOMER Business Area Model
  • LEGAL ENTITY CUSTOMER Business Area Model

Note: Each of the Microsoft models - enterprise, business area or data warehouse - have a representative level of detail for the appropriate type of customer, which is a 'subset' of the total data available in the associated INDIVIDUAL CUSTOMER or LEGAL ENTITY CUSTOMER business area models.. Reference either of those models to expand the coverage or level of detail in each respective data model.

The actual customer implemented in each model depends upon the dominant use of customer for that industry.

For example, in the pharmaceutical industry the customer is a legal entity, which represents another corporation, company, government organization etc. that purchases the pharmaceutical product and then distributes that product to the end-customer, which is an individual in a retail environment or a government-distribution scheme.

For this example, the pharmaceutical models will have the legal entity customer represented but not the individual 'end customer' since that is represented in the appropriate retail industry models, which are a different offering.

Of course, the entire set of data available for a legal entity customer is contained in the associated LEGAL ENTITY CUSTOMER Business Area Model. Reference the LEGAL ENTITY CUSTOMER Business Area Model to incorporate more data that may be of relevance.

In many industries both types of customers are represented since a legal entity or individual can purchase products, goods or services and enter into contracts. For these industries, both types of customers are represented by some of the more significant or relevant data derived from the associated LEGAL ENTITY or INDIVIDUAL CUSTOMER business area models. These models can be used to expand the scope or level of detail in any of the enterprise, business area or data warehouse models.

entitya reference to the constant entity holding the list of localized text

is.identifiedBy
names a specific identity attribute to use with an entity

ParameterValueData typeExplanation
attributeCustomer/(resolvedAttributes)/CustomerIdattribute

minimumObjectModelVersion
Minimum version of the object model required to fully understand the data schema used.

ParameterValueData typeExplanation
versionNumber"1.2.3"string

is.IDM.modelVersion
Semantic version number of the IDM.

ParameterValueData typeExplanation
versionNumber"2.0.0"string

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{04726B09-A870-49BF-B496-A15F78CB5F23}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nativeTo.businessArea
The name of the business area from which the entity originates.

ParameterValueData typeExplanation
name"Customer"string

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCustomer
entitya reference to the constant entity holding the list of localized text

has.entitySchemaAbstractionLevel
A level of abstraction assigned to an Entity schema. Logical schema descriptions use complex dataTypes, inheritance, and entities as attributes. Resolved descriptions contain none of those things, only final trait and attribute sets are shown. A composition schema manipulates, guides, or restates parts of logical schemas to produce one resolved schema.

ParameterValueData typeExplanation
level"resolved"stringPossible values: logical, composition, resolved

Attributes

Name Description First Included in Instance
CustomerId The unique identifier of a Customer. Sustainability/esg-data-model/Customer
CustomerEstablishedDate The date that the Customer relationship was established. Sustainability/esg-data-model/Customer
CustomerTypeId The unique identifier of a Customer Type. Sustainability/esg-data-model/Customer
ResponsibilityCenterId The unique identifier of a Responsibility Center. Sustainability/esg-data-model/Customer
LedgerId The unique identifier of a Ledger. Sustainability/esg-data-model/Customer
LedgerAccountNumber The unique identifier of a Ledger Account. Sustainability/esg-data-model/Customer
PartyId The unique identifier of a Party. Sustainability/esg-data-model/Customer
GlobalLocationNumber The Global Location Number (GLN) is a simple tool used to uniquely identify locations. It can be used to identify physical locations such as a warehouse, legal entities, or a function / department within a legal entity. The GLN is part of the GS1 system of standards. Sustainability/esg-data-model/Customer
CustomerNote A note, comment, or more information regarding the Customer. Sustainability/esg-data-model/Customer

CustomerId

The unique identifier of a Customer. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameCustomer ID
descriptionThe unique identifier of a Customer.
isPrimaryKeytrue
dataFormatint64

Traits

List of traits for the CustomerId attribute are listed here.

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.identifiedBy
names a specific identity attribute to use with an entity

ParameterValueData typeExplanation
attributeCustomer/(resolvedAttributes)/CustomerIdattribute

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{08E8C0ED-49D2-49B5-8BA3-B926482AD405}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCustomer ID
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Customer.
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

CustomerEstablishedDate

The date that the Customer relationship was established. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameCustomer Established Date
descriptionThe date that the Customer relationship was established.
dataFormatdate
isNullabletrue

Traits

List of traits for the CustomerEstablishedDate attribute are listed here.

is.dataFormat.date
means.measurement.date
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{073563AE-0496-437E-A23A-3EA46ED305CF}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCustomer Established Date
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe date that the Customer relationship was established.
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

CustomerTypeId

The unique identifier of a Customer Type. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameCustomer Type ID
descriptionThe unique identifier of a Customer Type.
dataFormatint32
isNullabletrue

Traits

List of traits for the CustomerTypeId attribute are listed here.

is.dataFormat.integer
is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCustomer Type ID
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Customer Type.
entitya reference to the constant entity holding the list of localized text

is.linkedEntity.identifier
Marks the attributes that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
CustomerType.cdm.json/CustomerTypeCustomerTypeId
entitya reference to the constant entity holding the list of entity references

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{1613820C-CE54-4567-A969-3A7BFB06465C}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.dataFormat.integer

ResponsibilityCenterId

The unique identifier of a Responsibility Center. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameResponsibility Center ID
descriptionThe unique identifier of a Responsibility Center.
dataFormatint32
isNullabletrue

Traits

List of traits for the ResponsibilityCenterId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{0206D5BE-DA4F-4D8B-9177-5D604AA1EBE5}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enResponsibility Center ID
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Responsibility Center.
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

LedgerId

The unique identifier of a Ledger. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameLedger ID
descriptionThe unique identifier of a Ledger.
dataFormatint32
isNullabletrue

Traits

List of traits for the LedgerId attribute are listed here.

is.dataFormat.integer
has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{1D108E00-4075-4644-9F44-B45BA83A7A03}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enLedger ID
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Ledger.
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

LedgerAccountNumber

The unique identifier of a Ledger Account. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameLedger Account Number
descriptionThe unique identifier of a Ledger Account.
dataFormatstring
maximumLength20
isNullabletrue

Traits

List of traits for the LedgerAccountNumber attribute are listed here.

is.dataFormat.character
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{07C60E11-0CBB-43A8-AE73-A1C0D5F3E433}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enLedger Account Number
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Ledger Account.
entitya reference to the constant entity holding the list of localized text

is.constrained
maximum length or value constraints

ParameterValueData typeExplanation
maximumLength"20"integer

is.dataFormat.character
is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

PartyId

The unique identifier of a Party. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameParty ID
descriptionThe unique identifier of a Party.
dataFormatint64
isNullabletrue

Traits

List of traits for the PartyId attribute are listed here.

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enParty ID
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe unique identifier of a Party.
entitya reference to the constant entity holding the list of localized text

is.linkedEntity.identifier
Marks the attributes that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
Party.cdm.json/PartyPartyId
entitya reference to the constant entity holding the list of entity references

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{15BD04D7-7665-4308-8ED6-081A5A8F11C3}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.dataFormat.integer
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

GlobalLocationNumber

The Global Location Number (GLN) is a simple tool used to uniquely identify locations. It can be used to identify physical locations such as a warehouse, legal entities, or a function / department within a legal entity. The GLN is part of the GS1 system of standards. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameGlobal Location Number (GLN)
descriptionThe Global Location Number (GLN) is a simple tool used to uniquely identify locations. It can be used to identify physical locations such as a warehouse, legal entities, or a function / department within a legal entity. The GLN is part of the GS1 system of standards.
dataFormatdecimal
isNullabletrue

Traits

List of traits for the GlobalLocationNumber attribute are listed here.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ParameterValueData typeExplanation
precision"13"integerthe total number of significant digits
scale"0"integerthe number of digits to the right of the decimal place

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{04A12E7C-B495-49B6-9DE1-80225F7A764C}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enGlobal Location Number (GLN)
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enThe Global Location Number (GLN) is a simple tool used to uniquely identify locations. It can be used to identify physical locations such as a warehouse, legal entities, or a function / department within a legal entity. The GLN is part of the GS1 system of standards.
entitya reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

CustomerNote

A note, comment, or more information regarding the Customer. First included in: Sustainability/esg-data-model/Customer (this entity)

Properties

NameValue
displayNameCustomer Note
descriptionA note, comment, or more information regarding the Customer.
dataFormatstring
maximumLength2048
isNullabletrue

Traits

List of traits for the CustomerNote attribute are listed here.

is.dataFormat.character
is.dataFormat.big
indicates an atomic but multi-unit version of a fundamental type such as a multi byte encoded character, a double precision float, a long integer.

is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.

has.schemaObjectIdentifier
The schema object has an identifier, which is a string, specified as the parameter of the trait. It allows writers to define more identification values.

ParameterValueData typeExplanation
identifier"{06CE4247-7D89-44DA-AADD-251AB5A6C937}"stringThe identifier for the schema object. There's no uniqueness guarantee enforced by CDM. It's a contract between reader and writer of the schema.

is.nullable
The attribute value can be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCustomer Note
entitya reference to the constant entity holding the list of localized text

is.localized.describedAs
Holds the list of language specific descriptive text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enA note, comment, or more information regarding the Customer.
entitya reference to the constant entity holding the list of localized text

is.constrained
maximum length or value constraints

ParameterValueData typeExplanation
maximumLength"2048"integer

is.dataFormat.character
is.dataFormat.array
indicates a contiguous sequence of fundamental units that should be taken as a whole and considered one value. Array of Character is a String, and Array of Byte is a Binary Object.