Bearbeiten

Freigeben über


Transactions in Transaction(RetailTransactionTable)

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
attributeRetailTransactionTable/(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
enTransactions
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Transaction/RetailTransactionTable
terminal Transaction/RetailTransactionTable
amountToAccount Transaction/RetailTransactionTable
BatchID Transaction/RetailTransactionTable
BatchTerminalId Transaction/RetailTransactionTable
businessDate Transaction/RetailTransactionTable
Channel Transaction/RetailTransactionTable
ChannelReferenceId Transaction/RetailTransactionTable
comment Transaction/RetailTransactionTable
costAmount Transaction/RetailTransactionTable
counter Transaction/RetailTransactionTable
CreatedOffline Transaction/RetailTransactionTable
createdOnPosTerminal Transaction/RetailTransactionTable
currency Transaction/RetailTransactionTable
custAccount Transaction/RetailTransactionTable
custDiscAmount Transaction/RetailTransactionTable
CustPurchaseOrder Transaction/RetailTransactionTable
DefaultDimension Transaction/RetailTransactionTable
Description Transaction/RetailTransactionTable
discAmount Transaction/RetailTransactionTable
discAmountWithoutTax Transaction/RetailTransactionTable
DlvMode Transaction/RetailTransactionTable
entryStatus Transaction/RetailTransactionTable
exchRate Transaction/RetailTransactionTable
FiscalDocumentId Transaction/RetailTransactionTable
FiscalSerialId Transaction/RetailTransactionTable
grossAmount Transaction/RetailTransactionTable
includedInStatistics Transaction/RetailTransactionTable
incomeExpenseAmount Transaction/RetailTransactionTable
infocodeDiscGroup Transaction/RetailTransactionTable
InventLocationId Transaction/RetailTransactionTable
InventSiteId Transaction/RetailTransactionTable
InvoiceComment Transaction/RetailTransactionTable
invoiceId Transaction/RetailTransactionTable
itemsPosted Transaction/RetailTransactionTable
LogisticsPostalAddress Transaction/RetailTransactionTable
loyaltyCardId Transaction/RetailTransactionTable
LoyaltyDiscAmount_RU Transaction/RetailTransactionTable
netAmount Transaction/RetailTransactionTable
netPrice Transaction/RetailTransactionTable
numberOfInvoices Transaction/RetailTransactionTable
numberOfItemLines Transaction/RetailTransactionTable
numberOfItems Transaction/RetailTransactionTable
numberOfPaymentLines Transaction/RetailTransactionTable
openDrawer Transaction/RetailTransactionTable
Origin Transaction/RetailTransactionTable
paymentAmount Transaction/RetailTransactionTable
postAsShipment Transaction/RetailTransactionTable
ReceiptDateRequested Transaction/RetailTransactionTable
receiptEmail Transaction/RetailTransactionTable
receiptEmailSent Transaction/RetailTransactionTable
receiptId Transaction/RetailTransactionTable
refundReceiptId Transaction/RetailTransactionTable
replicated Transaction/RetailTransactionTable
replicationCounterFromOrigin Transaction/RetailTransactionTable
retrievedFromReceiptId Transaction/RetailTransactionTable
roundedAmount Transaction/RetailTransactionTable
saleIsReturnSale Transaction/RetailTransactionTable
salesInvoiceAmount Transaction/RetailTransactionTable
salesOrderAmount Transaction/RetailTransactionTable
salesOrderId Transaction/RetailTransactionTable
salesPaymentDifference Transaction/RetailTransactionTable
sellToContactId Transaction/RetailTransactionTable
shift Transaction/RetailTransactionTable
shiftDate Transaction/RetailTransactionTable
ShippingDateRequested Transaction/RetailTransactionTable
SkipAggregation Transaction/RetailTransactionTable
staff Transaction/RetailTransactionTable
statementCode Transaction/RetailTransactionTable
statementId Transaction/RetailTransactionTable
store Transaction/RetailTransactionTable
timeWhenTotalPressed Transaction/RetailTransactionTable
timeWhenTransClosed Transaction/RetailTransactionTable
toAccount Transaction/RetailTransactionTable
totalDiscAmount Transaction/RetailTransactionTable
TotalManualDiscountAmount Transaction/RetailTransactionTable
TotalManualDiscountPercentage Transaction/RetailTransactionTable
transactionId Transaction/RetailTransactionTable
transCode Transaction/RetailTransactionTable
transDate Transaction/RetailTransactionTable
transTableId Transaction/RetailTransactionTable
transTime Transaction/RetailTransactionTable
type Transaction/RetailTransactionTable
wrongShift Transaction/RetailTransactionTable
CustAccountAsync Transaction/RetailTransactionTable
SourceId Transaction/RetailTransactionTable
PriceOverride Transaction/RetailTransactionTable
FTCExempt Transaction/RetailTransactionTable
CatalogUpSellShown Transaction/RetailTransactionTable
ContinuityOrder Transaction/RetailTransactionTable
ContinuityChild Transaction/RetailTransactionTable
ContinuityLineEval Transaction/RetailTransactionTable
InstallmentOrderSubmitted Transaction/RetailTransactionTable
OutOfBalanceReleaseType Transaction/RetailTransactionTable
PaymOutOfBalanceType Transaction/RetailTransactionTable
InstallmentBillingPrompt Transaction/RetailTransactionTable
AllocationPriority Transaction/RetailTransactionTable
SalesGroup Transaction/RetailTransactionTable
TaxCalculationType Transaction/RetailTransactionTable
ValidationStatus Transaction/RetailTransactionTable
ValidationDateTime Transaction/RetailTransactionTable
IsTaxIncludedInPrice Transaction/RetailTransactionTable
SuspendedTransactionId Transaction/RetailTransactionTable
GiftCardActiveFrom Transaction/RetailTransactionTable
GiftCardExpireDate Transaction/RetailTransactionTable
GiftCardIssueAmount Transaction/RetailTransactionTable
GiftCardBalance Transaction/RetailTransactionTable
GiftCardHistoryDetails Transaction/RetailTransactionTable
GiftCardIdMasked Transaction/RetailTransactionTable
InvoiceRecId Transaction/RetailTransactionTable
RetailTransactionAggregationFieldList Transaction/RetailTransactionTable
TransactionOrderType Transaction/RetailTransactionTable
BeginDateTime Transaction/RetailTransactionTable
DefaultDimensionStamped Transaction/RetailTransactionTable
IsTaxExemptedForPriceInclusive Transaction/RetailTransactionTable
DataAreaId Transaction/RetailTransactionTable
Relationship_CurrencyRelationshipId Transaction/RetailTransactionTable
Relationship_CustTableRelationshipId Transaction/RetailTransactionTable
Relationship_DimensionAttributeValueSetRelationshipId Transaction/RetailTransactionTable
Relationship_LogisticsPostalAddressRelationshipId Transaction/RetailTransactionTable
Relationship_RetailChannelTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailloyaltycardRelationshipId Transaction/RetailTransactionTable
Relationship_RetailPosBatchTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailStatementTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailStoreTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailStoreWorkShiftTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailTerminalTableRelationshipId Transaction/RetailTransactionTable
Relationship_RetailTerminalTable1RelationshipId Transaction/RetailTransactionTable
Relationship_RetailTerminalTableBatchRelationshipId Transaction/RetailTransactionTable
Relationship_SalesTableRelationshipId Transaction/RetailTransactionTable
Relationship_CommissionSalesGroupRelationshipId Transaction/RetailTransactionTable
Relationship_CustInvoiceJourRelationshipId Transaction/RetailTransactionTable
Relationship_RetailTransactionAggregationFieldListRelationshipId Transaction/RetailTransactionTable
Relationship_CompanyRelationshipId Transaction/RetailTransactionTable

RecId

First included in: Transaction/RetailTransactionTable (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
attributeRetailTransactionTable/(resolvedAttributes)/RecIdattribute

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

terminal

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

amountToAccount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

BatchID

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

BatchTerminalId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameShift register ID
dataFormatstring
isNullabletrue

Traits

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

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

is.dataFormat.character
is.dataFormat.array

businessDate

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the businessDate attribute are listed below.

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

is.dataFormat.date

Channel

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

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

ChannelReferenceId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

comment

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

costAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

counter

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the counter attribute are listed below.

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

is.dataFormat.integer

CreatedOffline

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameCreated offline
dataFormatint32
isNullabletrue

Traits

List of traits for the CreatedOffline 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
enCreated offline
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

createdOnPosTerminal

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameCreated at register
dataFormatstring
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCreated at register
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

currency

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

custAccount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

custDiscAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

CustPurchaseOrder

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DefaultDimension

First included in: Transaction/RetailTransactionTable (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

Description

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

discAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

discAmountWithoutTax

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

DlvMode

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

entryStatus

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the entryStatus attribute are listed below.

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

is.dataFormat.integer

exchRate

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

FiscalDocumentId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

FiscalSerialId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

grossAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

includedInStatistics

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the includedInStatistics attribute are listed below.

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

is.dataFormat.integer

incomeExpenseAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

infocodeDiscGroup

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventLocationId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventSiteId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InvoiceComment

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

invoiceId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

itemsPosted

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the itemsPosted attribute are listed below.

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

is.dataFormat.integer

LogisticsPostalAddress

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

loyaltyCardId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LoyaltyDiscAmount_RU

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

netAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

netPrice

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

numberOfInvoices

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the numberOfInvoices attribute are listed below.

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

is.dataFormat.integer

numberOfItemLines

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

numberOfItems

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

numberOfPaymentLines

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the numberOfPaymentLines attribute are listed below.

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

is.dataFormat.integer

openDrawer

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the openDrawer attribute are listed below.

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

is.dataFormat.integer

Origin

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

paymentAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

postAsShipment

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the postAsShipment attribute are listed below.

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

is.dataFormat.integer

ReceiptDateRequested

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ReceiptDateRequested attribute are listed below.

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

is.dataFormat.date

receiptEmail

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

receiptEmailSent

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the receiptEmailSent attribute are listed below.

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

is.dataFormat.integer

receiptId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

refundReceiptId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

replicated

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the replicated attribute are listed below.

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

is.dataFormat.integer

replicationCounterFromOrigin

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameReplication counter from origin
dataFormatint32
isNullabletrue

Traits

List of traits for the replicationCounterFromOrigin 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
enReplication counter from origin
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

retrievedFromReceiptId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameRetrieved from receipt
dataFormatstring
isNullabletrue

Traits

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

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

is.dataFormat.character
is.dataFormat.array

roundedAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

saleIsReturnSale

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the saleIsReturnSale attribute are listed below.

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

is.dataFormat.integer

salesInvoiceAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

salesOrderAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

salesOrderId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

salesPaymentDifference

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

sellToContactId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

shift

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

shiftDate

First included in: Transaction/RetailTransactionTable (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

ShippingDateRequested

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ShippingDateRequested attribute are listed below.

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

is.dataFormat.date

SkipAggregation

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SkipAggregation attribute are listed below.

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

is.dataFormat.integer

staff

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

statementCode

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

statementId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

store

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

timeWhenTotalPressed

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormattime
isNullabletrue

Traits

List of traits for the timeWhenTotalPressed attribute are listed below.

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

is.dataFormat.time

timeWhenTransClosed

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormattime
isNullabletrue

Traits

List of traits for the timeWhenTransClosed attribute are listed below.

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

is.dataFormat.time

toAccount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the toAccount attribute are listed below.

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

is.dataFormat.integer

totalDiscAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TotalManualDiscountAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TotalManualDiscountPercentage

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

transactionId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the transactionId attribute are listed below.

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

transCode

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the transCode attribute are listed below.

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

is.dataFormat.integer

transDate

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the transDate attribute are listed below.

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

is.dataFormat.date

transTableId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the transTableId attribute are listed below.

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

is.dataFormat.integer

transTime

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormattime
isNullabletrue

Traits

List of traits for the transTime attribute are listed below.

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

is.dataFormat.time

type

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the type attribute are listed below.

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

is.dataFormat.integer

wrongShift

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the wrongShift attribute are listed below.

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

is.dataFormat.integer

CustAccountAsync

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

SourceId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PriceOverride

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PriceOverride attribute are listed below.

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

is.dataFormat.integer

FTCExempt

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the FTCExempt attribute are listed below.

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

is.dataFormat.integer

CatalogUpSellShown

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the CatalogUpSellShown attribute are listed below.

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

is.dataFormat.integer

ContinuityOrder

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ContinuityOrder attribute are listed below.

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

is.dataFormat.integer

ContinuityChild

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ContinuityChild attribute are listed below.

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

is.dataFormat.integer

ContinuityLineEval

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ContinuityLineEval attribute are listed below.

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

is.dataFormat.integer

InstallmentOrderSubmitted

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the InstallmentOrderSubmitted attribute are listed below.

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

is.dataFormat.integer

OutOfBalanceReleaseType

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the OutOfBalanceReleaseType attribute are listed below.

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

is.dataFormat.integer

PaymOutOfBalanceType

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PaymOutOfBalanceType attribute are listed below.

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

is.dataFormat.integer

InstallmentBillingPrompt

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the InstallmentBillingPrompt attribute are listed below.

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

is.dataFormat.integer

AllocationPriority

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AllocationPriority attribute are listed below.

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

is.dataFormat.integer

SalesGroup

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxCalculationType

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the TaxCalculationType attribute are listed below.

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

is.dataFormat.integer

ValidationStatus

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ValidationStatus attribute are listed below.

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

is.dataFormat.integer

ValidationDateTime

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameLast validation time
dataFormatdate
isNullabletrue

Traits

List of traits for the ValidationDateTime 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
enLast validation time
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

IsTaxIncludedInPrice

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsTaxIncludedInPrice attribute are listed below.

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

is.dataFormat.integer

SuspendedTransactionId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

GiftCardActiveFrom

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the GiftCardActiveFrom attribute are listed below.

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

is.dataFormat.date

GiftCardExpireDate

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the GiftCardExpireDate attribute are listed below.

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

is.dataFormat.date

GiftCardIssueAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

GiftCardBalance

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

GiftCardHistoryDetails

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

GiftCardIdMasked

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InvoiceRecId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

RetailTransactionAggregationFieldList

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

TransactionOrderType

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the TransactionOrderType attribute are listed below.

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

is.dataFormat.integer

BeginDateTime

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
displayNameBegin date time
dataFormatdate
isNullabletrue

Traits

List of traits for the BeginDateTime 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
enBegin date time
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

DefaultDimensionStamped

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the DefaultDimensionStamped attribute are listed below.

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

is.dataFormat.integer

IsTaxExemptedForPriceInclusive

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsTaxExemptedForPriceInclusive attribute are listed below.

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

is.dataFormat.integer

DataAreaId

First included in: Transaction/RetailTransactionTable (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_CurrencyRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CurrencyRelationshipId 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/Common/Currency/Group/Currency.cdm.json/CurrencyRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CustTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_DimensionAttributeValueSetRelationshipId

First included in: Transaction/RetailTransactionTable (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_LogisticsPostalAddressRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_LogisticsPostalAddressRelationshipId 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/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddressRecId
entitya 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: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

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.

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

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

Relationship_RetailloyaltycardRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_RetailloyaltycardRelationshipId 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/CommerceCustomers/Miscellaneous/RetailLoyaltyCard.cdm.json/RetailLoyaltyCardRecId
entitya 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: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetHeader/RetailPosBatchTable.cdm.json/RetailPosBatchTableRecId
entitya 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: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetHeader/RetailStatementTable.cdm.json/RetailStatementTableRecId
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: Transaction/RetailTransactionTable (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: Transaction/RetailTransactionTable (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: Transaction/RetailTransactionTable (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_RetailTerminalTable1RelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SalesTableRelationshipId 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/SupplyChain/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CommissionSalesGroupRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CommissionSalesGroupRelationshipId 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/SupplyChain/SalesAndMarketing/Group/CommissionSalesGroup.cdm.json/CommissionSalesGroupRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CustInvoiceJourRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CustInvoiceJourRelationshipId 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/AccountsReceivable/Transaction/CustInvoiceJour.cdm.json/CustInvoiceJourRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RetailTransactionAggregationFieldListRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_RetailTransactionAggregationFieldListRelationshipId 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/RetailTransactionAggregationFieldList.cdm.json/RetailTransactionAggregationFieldListRecId
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: Transaction/RetailTransactionTable (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