Statements in WorksheetHeader(RetailStatementTable)

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

ParameterValueData typeExplanation
attributeRetailStatementTable/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

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

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

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

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

Attributes

Name Description First Included in Instance
RecId WorksheetHeader/RetailStatementTable
calculatedDate WorksheetHeader/RetailStatementTable
CalculatedLines WorksheetHeader/RetailStatementTable
calculatedTime WorksheetHeader/RetailStatementTable
closingMethod WorksheetHeader/RetailStatementTable
debugMode WorksheetHeader/RetailStatementTable
DefaultDimension WorksheetHeader/RetailStatementTable
postedDate WorksheetHeader/RetailStatementTable
postedTime WorksheetHeader/RetailStatementTable
postingDate WorksheetHeader/RetailStatementTable
recalculate WorksheetHeader/RetailStatementTable
replicationCounter WorksheetHeader/RetailStatementTable
shiftDate WorksheetHeader/RetailStatementTable
shiftId WorksheetHeader/RetailStatementTable
skipConfirmation WorksheetHeader/RetailStatementTable
staffOrTerminal WorksheetHeader/RetailStatementTable
statementDate WorksheetHeader/RetailStatementTable
statementId WorksheetHeader/RetailStatementTable
statementMethod WorksheetHeader/RetailStatementTable
stmtCalcInfoLog WorksheetHeader/RetailStatementTable
stmtPostInfoLog WorksheetHeader/RetailStatementTable
storeId WorksheetHeader/RetailStatementTable
transFromDate WorksheetHeader/RetailStatementTable
transFromTime WorksheetHeader/RetailStatementTable
transToDate WorksheetHeader/RetailStatementTable
transToTime WorksheetHeader/RetailStatementTable
PostingStatus WorksheetHeader/RetailStatementTable
PostingErrorCode WorksheetHeader/RetailStatementTable
PostingErrorMessage WorksheetHeader/RetailStatementTable
PostingErrorStatus WorksheetHeader/RetailStatementTable
EodCodeVersion WorksheetHeader/RetailStatementTable
PaymentStatus WorksheetHeader/RetailStatementTable
PostingBatchJobId WorksheetHeader/RetailStatementTable
IgnoreReturnLink WorksheetHeader/RetailStatementTable
StatementType WorksheetHeader/RetailStatementTable
AggregateBeforePosting WorksheetHeader/RetailStatementTable
CreationVersionIndicator WorksheetHeader/RetailStatementTable
startAmountCalculation WorksheetHeader/RetailStatementTable
oneStatementPerDay WorksheetHeader/RetailStatementTable
bankDropCalculation WorksheetHeader/RetailStatementTable
tenderDeclarationCalculation WorksheetHeader/RetailStatementTable
stmtCalcBatchEndTime WorksheetHeader/RetailStatementTable
DisableCountingRequired WorksheetHeader/RetailStatementTable
ReserveInventoryDuringStatementCalculation WorksheetHeader/RetailStatementTable
SkipAggregationForReturns WorksheetHeader/RetailStatementTable
UpdateGSTTransactionId_IN WorksheetHeader/RetailStatementTable
DisableTransactionConsistencyChecker WorksheetHeader/RetailStatementTable
MaxNumberOfThreadsCustomerOrder WorksheetHeader/RetailStatementTable
RecalculateDimensionsOnPostingError WorksheetHeader/RetailStatementTable
OfferLedgerDimension WorksheetHeader/RetailStatementTable
MixMatchLedgerDimension WorksheetHeader/RetailStatementTable
MultiBuyLedgerDimension WorksheetHeader/RetailStatementTable
ThresholdLedgerDimension WorksheetHeader/RetailStatementTable
autosettle WorksheetHeader/RetailStatementTable
PrepaymentLedgerDimension WorksheetHeader/RetailStatementTable
PrePaymentLedgerJournalName WorksheetHeader/RetailStatementTable
GiftcardItem WorksheetHeader/RetailStatementTable
ProcessGiftcardsAsPrepayments_RU WorksheetHeader/RetailStatementTable
TaxOnGiftCards WorksheetHeader/RetailStatementTable
AggregatedTransactionsBundleSize WorksheetHeader/RetailStatementTable
UseFinancialDimensionFromReturnStore WorksheetHeader/RetailStatementTable
StmtAutoSettleCustomerDeposit WorksheetHeader/RetailStatementTable
UseChannelCashManagementReconciliation WorksheetHeader/RetailStatementTable
LastAttemptToClear WorksheetHeader/RetailStatementTable
DataAreaId WorksheetHeader/RetailStatementTable
Relationship_DimensionAttributeValueSetRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailStaffTableRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailStatementLineRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailStoreTableRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailStoreWorkShiftTableRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailTerminalTableRelationshipId WorksheetHeader/RetailStatementTable
Relationship_RetailTransactionTableRelationshipId WorksheetHeader/RetailStatementTable
Relationship_BatchJobRelationshipId WorksheetHeader/RetailStatementTable
Relationship_CompanyRelationshipId WorksheetHeader/RetailStatementTable

RecId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

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

ParameterValueData typeExplanation
attributeRetailStatementTable/(resolvedAttributes)/RecIdattribute

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

calculatedDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameCalculated date
dataFormatdate
isNullabletrue

Traits

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

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

is.dataFormat.date

CalculatedLines

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameCalculation lines
dataFormatint32
isNullabletrue

Traits

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

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

is.dataFormat.integer

calculatedTime

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameCalculated time
dataFormattime
isNullabletrue

Traits

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

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

is.dataFormat.time

closingMethod

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the closingMethod attribute are listed below.

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

is.dataFormat.integer

debugMode

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the debugMode attribute are listed below.

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

is.dataFormat.integer

DefaultDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

postedDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNamePosted date
dataFormatdate
isNullabletrue

Traits

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

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

is.dataFormat.date

postedTime

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNamePosted time
dataFormattime
isNullabletrue

Traits

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

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

is.dataFormat.time

postingDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNamePosting date
dataFormatdate
isNullabletrue

Traits

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

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

is.dataFormat.date

recalculate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the recalculate attribute are listed below.

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

is.dataFormat.integer

replicationCounter

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the replicationCounter attribute are listed below.

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

is.dataFormat.integer

shiftDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the shiftDate attribute are listed below.

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

is.dataFormat.date

shiftId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

skipConfirmation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the skipConfirmation attribute are listed below.

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

is.dataFormat.integer

staffOrTerminal

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

statementDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the statementDate attribute are listed below.

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

is.dataFormat.date

statementId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the statementId attribute are listed below.

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

statementMethod

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the statementMethod attribute are listed below.

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

is.dataFormat.integer

stmtCalcInfoLog

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

List of traits for the stmtCalcInfoLog attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

stmtPostInfoLog

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

List of traits for the stmtPostInfoLog attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

storeId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the storeId attribute are listed below.

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

transFromDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameTransaction from date
dataFormatdate
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTransaction from date
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

transFromTime

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameTransaction from time
dataFormattime
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTransaction from time
entitya reference to the constant entity holding the list of localized text

is.dataFormat.time

transToDate

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameTransaction end date
dataFormatdate
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTransaction end date
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

transToTime

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameTransaction end time
dataFormattime
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTransaction end time
entitya reference to the constant entity holding the list of localized text

is.dataFormat.time

PostingStatus

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PostingStatus attribute are listed below.

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

is.dataFormat.integer

PostingErrorCode

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PostingErrorCode attribute are listed below.

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

is.dataFormat.integer

PostingErrorMessage

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PostingErrorStatus

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PostingErrorStatus attribute are listed below.

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

is.dataFormat.integer

EodCodeVersion

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the EodCodeVersion attribute are listed below.

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

is.dataFormat.integer

PaymentStatus

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PaymentStatus attribute are listed below.

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

is.dataFormat.integer

PostingBatchJobId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameBatch job ID
dataFormatint64
isNullabletrue

Traits

List of traits for the PostingBatchJobId attribute are listed below.

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

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

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

is.dataFormat.integer
is.dataFormat.big

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IgnoreReturnLink attribute are listed below.

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

is.dataFormat.integer

StatementType

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StatementType attribute are listed below.

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

is.dataFormat.integer

AggregateBeforePosting

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AggregateBeforePosting attribute are listed below.

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

is.dataFormat.integer

CreationVersionIndicator

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the CreationVersionIndicator attribute are listed below.

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

is.dataFormat.integer

startAmountCalculation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the startAmountCalculation attribute are listed below.

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

is.dataFormat.integer

oneStatementPerDay

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the oneStatementPerDay attribute are listed below.

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

is.dataFormat.integer

bankDropCalculation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the bankDropCalculation attribute are listed below.

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

is.dataFormat.integer

tenderDeclarationCalculation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the tenderDeclarationCalculation attribute are listed below.

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

is.dataFormat.integer

stmtCalcBatchEndTime

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameEnd of business day
dataFormattime
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enEnd of business day
entitya reference to the constant entity holding the list of localized text

is.dataFormat.time

DisableCountingRequired

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameDisable counting required
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enDisable counting required
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReserveInventoryDuringStatementCalculation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ReserveInventoryDuringStatementCalculation attribute are listed below.

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

is.dataFormat.integer

SkipAggregationForReturns

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SkipAggregationForReturns attribute are listed below.

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

is.dataFormat.integer

UpdateGSTTransactionId_IN

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameUpdate POS invoice number
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enUpdate POS invoice number
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

DisableTransactionConsistencyChecker

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the DisableTransactionConsistencyChecker attribute are listed below.

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

is.dataFormat.integer

MaxNumberOfThreadsCustomerOrder

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the MaxNumberOfThreadsCustomerOrder attribute are listed below.

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

is.dataFormat.integer

RecalculateDimensionsOnPostingError

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RecalculateDimensionsOnPostingError attribute are listed below.

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

is.dataFormat.integer

OfferLedgerDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

MixMatchLedgerDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

MultiBuyLedgerDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ThresholdLedgerDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

autosettle

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the autosettle attribute are listed below.

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

is.dataFormat.integer

PrepaymentLedgerDimension

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

PrePaymentLedgerJournalName

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

GiftcardItem

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProcessGiftcardsAsPrepayments_RU

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameProcess gift card operations as prepayments
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enProcess gift card operations as prepayments
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

TaxOnGiftCards

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
displayNameTax on gift cards
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTax on gift cards
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

AggregatedTransactionsBundleSize

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AggregatedTransactionsBundleSize attribute are listed below.

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

is.dataFormat.integer

UseFinancialDimensionFromReturnStore

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the UseFinancialDimensionFromReturnStore attribute are listed below.

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

is.dataFormat.integer

StmtAutoSettleCustomerDeposit

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StmtAutoSettleCustomerDeposit attribute are listed below.

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

is.dataFormat.integer

UseChannelCashManagementReconciliation

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the UseChannelCashManagementReconciliation attribute are listed below.

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

is.dataFormat.integer

LastAttemptToClear

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the LastAttemptToClear attribute are listed below.

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

is.dataFormat.date

DataAreaId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

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_DimensionAttributeValueSetRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSetRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RetailStaffTableRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/CommerceEmployees/Main/RetailStaffTable.cdm.json/RetailStaffTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RetailStatementLineRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetLine/RetailStatementLine.cdm.json/RetailStatementLineRecId
entitya 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/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailStoreTable.cdm.json/RetailStoreTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RetailStoreWorkShiftTableRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/CommerceEmployees/WorksheetHeader/RetailStoreWorkShiftTable.cdm.json/RetailStoreWorkShiftTableRecId
entitya 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/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailTerminalTable.cdm.json/RetailTerminalTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RetailTransactionTableRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/TransactionsAndOrders/Transaction/RetailTransactionTable.cdm.json/RetailTransactionTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_BatchJobRelationshipId

First included in: WorksheetHeader/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/System/SystemAdministration/Transaction/BatchJob.cdm.json/BatchJobRecId
entitya 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/RetailStatementTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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