Shifts in WorksheetHeader(RetailPosBatchTable)

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	RetailPosBatchTable/(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 Shifts	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/RetailPosBatchTable
TerminalId		WorksheetHeader/RetailPosBatchTable
BatchID		WorksheetHeader/RetailPosBatchTable
CancellationCharges		WorksheetHeader/RetailPosBatchTable
Channel		WorksheetHeader/RetailPosBatchTable
CloseDate		WorksheetHeader/RetailPosBatchTable
CloseDateTimeUtc		WorksheetHeader/RetailPosBatchTable
ClosedAtTerminal		WorksheetHeader/RetailPosBatchTable
CloseTime		WorksheetHeader/RetailPosBatchTable
CustomersCount		WorksheetHeader/RetailPosBatchTable
CustomerOrdersCanceled		WorksheetHeader/RetailPosBatchTable
CustomerOrdersEdited		WorksheetHeader/RetailPosBatchTable
CustomerOrdersPlaced		WorksheetHeader/RetailPosBatchTable
CustomerOrdersVoidedLines		WorksheetHeader/RetailPosBatchTable
DepositCollected		WorksheetHeader/RetailPosBatchTable
DepositRedeemed		WorksheetHeader/RetailPosBatchTable
DepositRefunded		WorksheetHeader/RetailPosBatchTable
DiscountTotal		WorksheetHeader/RetailPosBatchTable
LogonsCount		WorksheetHeader/RetailPosBatchTable
NoSaleCount		WorksheetHeader/RetailPosBatchTable
Origin		WorksheetHeader/RetailPosBatchTable
PaidToAccountTotal		WorksheetHeader/RetailPosBatchTable
Posted		WorksheetHeader/RetailPosBatchTable
ReplicationCounter		WorksheetHeader/RetailPosBatchTable
ReturnsTotal		WorksheetHeader/RetailPosBatchTable
RoundedAmountTotal		WorksheetHeader/RetailPosBatchTable
SalesCount		WorksheetHeader/RetailPosBatchTable
SalesTotal		WorksheetHeader/RetailPosBatchTable
StaffId		WorksheetHeader/RetailPosBatchTable
StartDate		WorksheetHeader/RetailPosBatchTable
StartDateTimeUtc		WorksheetHeader/RetailPosBatchTable
StartTime		WorksheetHeader/RetailPosBatchTable
StatementId		WorksheetHeader/RetailPosBatchTable
Status		WorksheetHeader/RetailPosBatchTable
StoreId		WorksheetHeader/RetailPosBatchTable
TaxTotal		WorksheetHeader/RetailPosBatchTable
TransactionsCount		WorksheetHeader/RetailPosBatchTable
VoidsCount		WorksheetHeader/RetailPosBatchTable
GoodsSoldQty		WorksheetHeader/RetailPosBatchTable
PriceOverrideTotal		WorksheetHeader/RetailPosBatchTable
ReceiptCopiesCount		WorksheetHeader/RetailPosBatchTable
ReceiptCopiesTotal		WorksheetHeader/RetailPosBatchTable
ReturnsCount		WorksheetHeader/RetailPosBatchTable
ReturnsGrandTotal		WorksheetHeader/RetailPosBatchTable
SalesGrandTotal		WorksheetHeader/RetailPosBatchTable
ServicesSoldQty		WorksheetHeader/RetailPosBatchTable
SuspendedCount		WorksheetHeader/RetailPosBatchTable
SuspendedTotal		WorksheetHeader/RetailPosBatchTable
TrainingCount		WorksheetHeader/RetailPosBatchTable
TrainingTotal		WorksheetHeader/RetailPosBatchTable
GiftCardsTotal		WorksheetHeader/RetailPosBatchTable
GiftCardCashOutTotal		WorksheetHeader/RetailPosBatchTable
ReceiptsCount		WorksheetHeader/RetailPosBatchTable
SalesTotalIncludingTax		WorksheetHeader/RetailPosBatchTable
SalesTotalExcludingTax		WorksheetHeader/RetailPosBatchTable
VoidedSalesTotal		WorksheetHeader/RetailPosBatchTable
ShiftReturnsTotal		WorksheetHeader/RetailPosBatchTable
ShiftSalesTotal		WorksheetHeader/RetailPosBatchTable
ChargeTotal		WorksheetHeader/RetailPosBatchTable
ZeroSalesCount		WorksheetHeader/RetailPosBatchTable
HasPendingOfflineTransactions		WorksheetHeader/RetailPosBatchTable
Error		WorksheetHeader/RetailPosBatchTable
ErrorCode		WorksheetHeader/RetailPosBatchTable
ErrorCodeDateTime		WorksheetHeader/RetailPosBatchTable
ErrorCodeEditUser		WorksheetHeader/RetailPosBatchTable
MarkForFinancialStatement		WorksheetHeader/RetailPosBatchTable
DataAreaId		WorksheetHeader/RetailPosBatchTable
Relationship_RetailChannelTableRelationshipId		WorksheetHeader/RetailPosBatchTable
Relationship_RetailStatementTableRelationshipId		WorksheetHeader/RetailPosBatchTable
Relationship_RetailStoreTableRelationshipId		WorksheetHeader/RetailPosBatchTable
Relationship_RetailTerminalTableRelationshipId		WorksheetHeader/RetailPosBatchTable
Relationship_RetailTerminalTableCloseRelationshipId		WorksheetHeader/RetailPosBatchTable
Relationship_CompanyRelationshipId		WorksheetHeader/RetailPosBatchTable

RecId

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

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

TerminalId

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

CancellationCharges

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CancellationCharges 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

Channel

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

CloseDate

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Closed date
dataFormat	date
isNullable	true

Traits

List of traits for the CloseDate 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 Closed date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

CloseDateTimeUtc

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Closed time
dataFormat	date
isNullable	true

Traits

List of traits for the CloseDateTimeUtc 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 Closed time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ClosedAtTerminal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ClosedAtTerminal attribute are listed below.

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

CloseTime

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Closed time
dataFormat	time
isNullable	true

Traits

List of traits for the CloseTime attribute are listed below.

is.dataFormat.time
means.measurement.time
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 Closed time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.time

CustomersCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Customer sales
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the CustomersCount attribute are listed below.

is.dataFormat.integer
is.readOnly
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 sales	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

CustomerOrdersCanceled

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CustomerOrdersCanceled 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

CustomerOrdersEdited

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CustomerOrdersEdited 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

CustomerOrdersPlaced

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CustomerOrdersPlaced 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

CustomerOrdersVoidedLines

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CustomerOrdersVoidedLines 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

DepositCollected

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the DepositCollected 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

DepositRedeemed

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the DepositRedeemed 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

DepositRefunded

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the DepositRefunded 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

DiscountTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Discounts
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the DiscountTotal attribute are listed below.

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

is.readOnly
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 Discounts	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

LogonsCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Logon
dataFormat	int32
isNullable	true

Traits

List of traits for the LogonsCount 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 Logon	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

NoSaleCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Open drawer
dataFormat	int32
isNullable	true

Traits

List of traits for the NoSaleCount 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 Open drawer	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Origin

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Origin attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

PaidToAccountTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	To account
dataFormat	decimal
isNullable	true

Traits

List of traits for the PaidToAccountTotal 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 To account	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

Posted

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the Posted attribute are listed below.

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

is.dataFormat.integer

ReplicationCounter

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReplicationCounter attribute are listed below.

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

is.dataFormat.integer

ReturnsTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Returns
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReturnsTotal 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 Returns	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

RoundedAmountTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Rounded
dataFormat	decimal
isNullable	true

Traits

List of traits for the RoundedAmountTotal 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 Rounded	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

SalesCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Sales
dataFormat	int32
isNullable	true

Traits

List of traits for the SalesCount 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 Sales	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

SalesTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Sales
dataFormat	decimal
isNullable	true

Traits

List of traits for the SalesTotal 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 Sales	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

StaffId

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the StaffId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

StartDate

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Start date
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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.date

StartDateTimeUtc

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Start time
dataFormat	date
isNullable	true

Traits

List of traits for the StartDateTimeUtc 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 Start time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

StartTime

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Start time
dataFormat	time
isNullable	true

Traits

List of traits for the StartTime attribute are listed below.

is.dataFormat.time
means.measurement.time
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 Start time	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.time

StatementId

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the StatementId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

Status

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Status attribute are listed below.

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

is.dataFormat.integer

StoreId

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

TaxTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Taxes
dataFormat	decimal
isNullable	true

Traits

List of traits for the TaxTotal 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 Taxes	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

TransactionsCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Number of transactions
dataFormat	int32
isNullable	true

Traits

List of traits for the TransactionsCount 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 Number of transactions	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

VoidsCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Voided sales
dataFormat	int32
isNullable	true

Traits

List of traits for the VoidsCount 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 Voided sales	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

GoodsSoldQty

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Items sold
dataFormat	decimal
isNullable	true

Traits

List of traits for the GoodsSoldQty 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 Items sold	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

PriceOverrideTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Manual price reductions
dataFormat	decimal
isNullable	true

Traits

List of traits for the PriceOverrideTotal 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 Manual price reductions	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

ReceiptCopiesCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Receipt copies
dataFormat	int32
isNullable	true

Traits

List of traits for the ReceiptCopiesCount 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 Receipt copies	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReceiptCopiesTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Receipt copies
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReceiptCopiesTotal 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 Receipt copies	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

ReturnsCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Returns
dataFormat	int32
isNullable	true

Traits

List of traits for the ReturnsCount 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 Returns	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReturnsGrandTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Grand return
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReturnsGrandTotal 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 Grand return	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

SalesGrandTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Grand sales
dataFormat	decimal
isNullable	true

Traits

List of traits for the SalesGrandTotal 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 Grand sales	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

ServicesSoldQty

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Services sold
dataFormat	decimal
isNullable	true

Traits

List of traits for the ServicesSoldQty 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 Services sold	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

SuspendedCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Suspended
dataFormat	int32
isNullable	true

Traits

List of traits for the SuspendedCount 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 Suspended	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

SuspendedTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Suspended
dataFormat	decimal
isNullable	true

Traits

List of traits for the SuspendedTotal 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 Suspended	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

TrainingCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Training
dataFormat	int32
isNullable	true

Traits

List of traits for the TrainingCount 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 Training	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

TrainingTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Training
dataFormat	decimal
isNullable	true

Traits

List of traits for the TrainingTotal 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 Training	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

GiftCardsTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the GiftCardsTotal 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

GiftCardCashOutTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Gift card cash out total
dataFormat	decimal
isNullable	true

Traits

List of traits for the GiftCardCashOutTotal 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 Gift card cash out total	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

ReceiptsCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Cash receipts
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReceiptsCount attribute are listed below.

is.dataFormat.integer
is.readOnly
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 Cash receipts	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

SalesTotalIncludingTax

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Total Sales including VAT
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the SalesTotalIncludingTax attribute are listed below.

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

is.readOnly
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 Sales including VAT	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

SalesTotalExcludingTax

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Total Sales excluding VAT
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the SalesTotalExcludingTax attribute are listed below.

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

is.readOnly
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 Sales excluding VAT	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

VoidedSalesTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Voided amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the VoidedSalesTotal 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 Voided 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

ShiftReturnsTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Total cash returns
dataFormat	decimal
isNullable	true

Traits

List of traits for the ShiftReturnsTotal 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 cash returns	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

ShiftSalesTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Total cash sales
dataFormat	decimal
isNullable	true

Traits

List of traits for the ShiftSalesTotal 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 cash sales	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

ChargeTotal

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Charge totals
dataFormat	decimal
isNullable	true

Traits

List of traits for the ChargeTotal 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 Charge totals	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

ZeroSalesCount

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Zero sales
dataFormat	int32
isNullable	true

Traits

List of traits for the ZeroSalesCount 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 Zero sales	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

HasPendingOfflineTransactions

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the HasPendingOfflineTransactions attribute are listed below.

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

is.dataFormat.integer

Error

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Error attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ErrorCode

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ErrorCode attribute are listed below.

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

is.dataFormat.integer

ErrorCodeDateTime

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ErrorCodeDateTime attribute are listed below.

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

is.dataFormat.date

ErrorCodeEditUser

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ErrorCodeEditUser attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

MarkForFinancialStatement

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
displayName	Mark for financial statement
dataFormat	int32
isNullable	true

Traits

List of traits for the MarkForFinancialStatement 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 Mark for financial statement	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

DataAreaId

First included in: WorksheetHeader/RetailPosBatchTable (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_RetailChannelTableRelationshipId

First included in: WorksheetHeader/RetailPosBatchTable (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_RetailStatementTableRelationshipId

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailStatementTableRelationshipId 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/RetailStatementTable.cdm.json/RetailStatementTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailStoreTableRelationshipId

First included in: WorksheetHeader/RetailPosBatchTable (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/RetailPosBatchTable (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_RetailTerminalTableCloseRelationshipId

First included in: WorksheetHeader/RetailPosBatchTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailTerminalTableCloseRelationshipId 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_CompanyRelationshipId

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