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

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

is.CDM.entityVersion

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

is.application.releaseVersion

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

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

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

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

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

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

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

terminal

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
displayName	Shift register ID
dataFormat	string
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Shift register ID	entity	a 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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the Channel attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

ChannelReferenceId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Created offline
dataFormat	int32
isNullable	true

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.

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

is.dataFormat.integer

createdOnPosTerminal

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
displayName	Created at register
dataFormat	string
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Created at register	entity	a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Origin attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

paymentAmount

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Replication counter from origin
dataFormat	int32
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Replication counter from origin	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

retrievedFromReceiptId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
displayName	Retrieved from receipt
dataFormat	string
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Retrieved from receipt	entity	a 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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	time
isNullable	true

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

Name	Value
dataFormat	time
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	time
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Last validation time
dataFormat	date
isNullable	true

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.

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

is.dataFormat.date

IsTaxIncludedInPrice

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Begin date time
dataFormat	date
isNullable	true

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.

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

is.dataFormat.date

DefaultDimensionStamped

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

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

Relationship_CurrencyRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency RecId	entity	a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

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

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

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

Relationship_DimensionAttributeValueSetRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet RecId	entity	a 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

Name	Value
dataFormat	guid

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.

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

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

Relationship_RetailChannelTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailChannelTableRelationshipId attribute are listed below.

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

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

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

Relationship_RetailloyaltycardRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/CommerceCustomers/Miscellaneous/RetailLoyaltyCard.cdm.json/RetailLoyaltyCard RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailPosBatchTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailPosBatchTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetHeader/RetailPosBatchTable.cdm.json/RetailPosBatchTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailStatementTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailStatementTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetHeader/RetailStatementTable.cdm.json/RetailStatementTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailStoreTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailStoreTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailStoreTable.cdm.json/RetailStoreTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailStoreWorkShiftTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/CommerceEmployees/WorksheetHeader/RetailStoreWorkShiftTable.cdm.json/RetailStoreWorkShiftTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailTerminalTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailTerminalTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailTerminalTable.cdm.json/RetailTerminalTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailTerminalTable1RelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailTerminalTable.cdm.json/RetailTerminalTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailTerminalTableBatchRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/ChannelManagement/BrickAndMortarStore/Main/RetailTerminalTable.cdm.json/RetailTerminalTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_SalesTableRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTable RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/Group/CommissionSalesGroup.cdm.json/CommissionSalesGroup RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsReceivable/Transaction/CustInvoiceJour.cdm.json/CustInvoiceJour RecId	entity	a 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

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/TransactionsAndOrders/Transaction/RetailTransactionAggregationFieldList.cdm.json/RetailTransactionAggregationFieldList RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_CompanyRelationshipId

First included in: Transaction/RetailTransactionTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

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

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

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