Sales statistics in TransactionHeader(MCRSalesStatsCustTable)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

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

Parameter	Value	Data type	Explanation
attribute	MCRSalesStatsCustTable/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.0"	string	semantic version number of the entity

is.application.releaseVersion

Parameter	Value	Data type	Explanation
releaseVersion	"10.0.13.0"	string	semantic version number of the application introducing this entity

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Sales statistics	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		TransactionHeader/MCRSalesStatsCustTable
AvgInvoiceAmountMST		TransactionHeader/MCRSalesStatsCustTable
CustAccount		TransactionHeader/MCRSalesStatsCustTable
CustomerCreationDateTime		TransactionHeader/MCRSalesStatsCustTable
Dirty		TransactionHeader/MCRSalesStatsCustTable
EndDate		TransactionHeader/MCRSalesStatsCustTable
FirstOrderDate		TransactionHeader/MCRSalesStatsCustTable
FrequencyScore		TransactionHeader/MCRSalesStatsCustTable
LastOrderDate		TransactionHeader/MCRSalesStatsCustTable
MCRRFMComposite		TransactionHeader/MCRSalesStatsCustTable
MonetaryScore		TransactionHeader/MCRSalesStatsCustTable
OrderFrequency		TransactionHeader/MCRSalesStatsCustTable
RecencyScore		TransactionHeader/MCRSalesStatsCustTable
StartDate		TransactionHeader/MCRSalesStatsCustTable
StatLastOrderDate		TransactionHeader/MCRSalesStatsCustTable
TotalInvoiceAmountMST		TransactionHeader/MCRSalesStatsCustTable
TotalInvoiceCostAmountMST		TransactionHeader/MCRSalesStatsCustTable
TotalReturnInvoicedAmountMST		TransactionHeader/MCRSalesStatsCustTable
DataAreaId		TransactionHeader/MCRSalesStatsCustTable
Relationship_CustTableRelationshipId		TransactionHeader/MCRSalesStatsCustTable
Relationship_CompanyRelationshipId		TransactionHeader/MCRSalesStatsCustTable

RecId

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	MCRSalesStatsCustTable/(resolvedAttributes)/RecId	attribute

is.readOnly
is.dataFormat.integer
is.dataFormat.big

AvgInvoiceAmountMST

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Average invoiced amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the AvgInvoiceAmountMST attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Average invoiced amount	entity	a 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

CustAccount

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the CustAccount attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.character
is.dataFormat.array

CustomerCreationDateTime

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Customer Creation Date and Time
dataFormat	date
isNullable	true

Traits

List of traits for the CustomerCreationDateTime attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Customer Creation Date and Time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

Dirty

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	New transactions exist
dataFormat	int32
isNullable	true

Traits

List of traits for the Dirty attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en New transactions exist	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

EndDate

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the EndDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

FirstOrderDate

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	First order date
dataFormat	date
isNullable	true

Traits

List of traits for the FirstOrderDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en First order date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

FrequencyScore

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the FrequencyScore attribute are listed below.

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

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

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

LastOrderDate

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Last order date
dataFormat	date
isNullable	true

Traits

List of traits for the LastOrderDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Last order date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

MCRRFMComposite

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRRFMComposite attribute are listed below.

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

is.dataFormat.integer

MonetaryScore

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the MonetaryScore attribute are listed below.

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

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

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

OrderFrequency

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Order frequency
dataFormat	int32
isNullable	true

Traits

List of traits for the OrderFrequency attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Order frequency	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

RecencyScore

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the RecencyScore attribute are listed below.

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

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

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

StartDate

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the StartDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

StatLastOrderDate

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Statistical last order date
dataFormat	date
isNullable	true

Traits

List of traits for the StatLastOrderDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Statistical last order date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

TotalInvoiceAmountMST

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Total invoiced amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the TotalInvoiceAmountMST attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Total invoiced amount	entity	a 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

TotalInvoiceCostAmountMST

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Total cost
dataFormat	decimal
isNullable	true

Traits

List of traits for the TotalInvoiceCostAmountMST attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Total cost	entity	a 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

TotalReturnInvoicedAmountMST

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
displayName	Total return amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the TotalReturnInvoicedAmountMST attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Total return amount	entity	a 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

DataAreaId

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.dataFormat.character
is.dataFormat.array

Relationship_CustTableRelationshipId

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) 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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTable RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_CompanyRelationshipId

First included in: TransactionHeader/MCRSalesStatsCustTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) 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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array