End of day report in WorksheetHeader(RetailXZReportTable)

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	RetailXZReportTable/(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 End of day report	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/RetailXZReportTable
StoreId		WorksheetHeader/RetailXZReportTable
TerminalId		WorksheetHeader/RetailXZReportTable
BatchId		WorksheetHeader/RetailXZReportTable
ReportType		WorksheetHeader/RetailXZReportTable
Channel		WorksheetHeader/RetailXZReportTable
ReportId		WorksheetHeader/RetailXZReportTable
ReportDateTime		WorksheetHeader/RetailXZReportTable
ReportValue		WorksheetHeader/RetailXZReportTable
ReplicationCounterFromOrigin		WorksheetHeader/RetailXZReportTable
DataAreaId		WorksheetHeader/RetailXZReportTable
Relationship_RetailStoreTableRelationshipId		WorksheetHeader/RetailXZReportTable
Relationship_RetailTerminalTableRelationshipId		WorksheetHeader/RetailXZReportTable
Relationship_RetailChannelTableRelationshipId		WorksheetHeader/RetailXZReportTable
Relationship_RetailPosBatchTableRelationshipId		WorksheetHeader/RetailXZReportTable
Relationship_CompanyRelationshipId		WorksheetHeader/RetailXZReportTable

RecId

First included in: WorksheetHeader/RetailXZReportTable (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	RetailXZReportTable/(resolvedAttributes)/RecId	attribute

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

StoreId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the StoreId attribute are listed below.

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

TerminalId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TerminalId attribute are listed below.

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

BatchId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the BatchId attribute are listed below.

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

ReportType

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReportType attribute are listed below.

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

is.dataFormat.integer

Channel

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the Channel attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

ReportId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the ReportId attribute are listed below.

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

ReportDateTime

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
displayName	Report date and time
dataFormat	date
isNullable	true

Traits

List of traits for the ReportDateTime 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 Report date and time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ReportValue

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
displayName	XML
dataFormat	string
isNullable	true

Traits

List of traits for the ReportValue attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
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 XML	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ReplicationCounterFromOrigin

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReplicationCounterFromOrigin attribute are listed below.

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

is.dataFormat.integer

DataAreaId

First included in: WorksheetHeader/RetailXZReportTable (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_RetailStoreTableRelationshipId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailStoreTableRelationshipId 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/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailStoreTable.cdm.json/RetailStoreTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailTerminalTableRelationshipId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailTerminalTableRelationshipId 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/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailTerminalTable.cdm.json/RetailTerminalTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailChannelTableRelationshipId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailChannelTableRelationshipId 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/Commerce/ChannelManagement/Main/RetailChannelTable.cdm.json/RetailChannelTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailPosBatchTableRelationshipId

First included in: WorksheetHeader/RetailXZReportTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailPosBatchTableRelationshipId 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/Commerce/TransactionsAndOrders/WorksheetHeader/RetailPosBatchTable.cdm.json/RetailPosBatchTable 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: WorksheetHeader/RetailXZReportTable (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