Retail sales line in Miscellaneous(RetailSalesLine)

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
attributeRetailSalesLine/(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
enRetail sales line
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Miscellaneous/RetailSalesLine
Catalog Miscellaneous/RetailSalesLine
LineDscAmount Miscellaneous/RetailSalesLine
LineManualDiscountAmount Miscellaneous/RetailSalesLine
LineManualDiscountPercentage Miscellaneous/RetailSalesLine
LinePercentageDiscount Miscellaneous/RetailSalesLine
ListingId Miscellaneous/RetailSalesLine
PeriodicDiscount Miscellaneous/RetailSalesLine
PeriodicPercentageDiscount Miscellaneous/RetailSalesLine
TotalDiscount Miscellaneous/RetailSalesLine
TotalPctDiscount Miscellaneous/RetailSalesLine
SalesLine Miscellaneous/RetailSalesLine
FulfillmentStoreId Miscellaneous/RetailSalesLine
InventTransId Miscellaneous/RetailSalesLine
ReturnReasonCodeId Miscellaneous/RetailSalesLine
OriginalPrice Miscellaneous/RetailSalesLine
PriceOverrideReasonCode Miscellaneous/RetailSalesLine
IsPriceOverridden Miscellaneous/RetailSalesLine
FulfillmentStatus Miscellaneous/RetailSalesLine
QuantityPicked Miscellaneous/RetailSalesLine
QuantityPacked Miscellaneous/RetailSalesLine
QuantityInvoiced Miscellaneous/RetailSalesLine
InfocodeId Miscellaneous/RetailSalesLine
Information Miscellaneous/RetailSalesLine
SubInfocodeId Miscellaneous/RetailSalesLine
TenderDiscount Miscellaneous/RetailSalesLine
TenderDiscountPercentage Miscellaneous/RetailSalesLine
IsPriceKeyedIn Miscellaneous/RetailSalesLine
TaxExemptPriceInclusiveOriginalPrice Miscellaneous/RetailSalesLine
TaxExemptPriceInclusiveReductionAmount Miscellaneous/RetailSalesLine
DataAreaId Miscellaneous/RetailSalesLine
Relationship_CatalogRelationshipId Miscellaneous/RetailSalesLine
Relationship_SalesLine1RelationshipId Miscellaneous/RetailSalesLine
Relationship_ReturnReasonCodeRelationshipId Miscellaneous/RetailSalesLine
Relationship_CompanyRelationshipId Miscellaneous/RetailSalesLine

RecId

First included in: Miscellaneous/RetailSalesLine (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
attributeRetailSalesLine/(resolvedAttributes)/RecIdattribute

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

Catalog

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

LineDscAmount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

LineManualDiscountAmount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

LineManualDiscountPercentage

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameManual discount percent
dataFormatdecimal
isNullabletrue

Traits

List of traits for the LineManualDiscountPercentage attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enManual discount percent
entitya reference to the constant entity holding the list of localized text

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

LinePercentageDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameLine discount percentage
dataFormatdecimal
isNullabletrue

Traits

List of traits for the LinePercentageDiscount attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enLine discount percentage
entitya reference to the constant entity holding the list of localized text

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

ListingId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PeriodicDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PeriodicPercentageDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TotalDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TotalPctDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

SalesLine

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

FulfillmentStoreId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventTransId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ReturnReasonCodeId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

OriginalPrice

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PriceOverrideReasonCode

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameReason code
dataFormatstring
isNullabletrue

Traits

List of traits for the PriceOverrideReasonCode 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
enReason code
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

IsPriceOverridden

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsPriceOverridden attribute are listed below.

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

is.dataFormat.integer

FulfillmentStatus

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameFulfillment status
dataFormatint32
isNullabletrue

Traits

List of traits for the FulfillmentStatus 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
enFulfillment status
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

QuantityPicked

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameQuantity picked
dataFormatdecimal
isNullabletrue

Traits

List of traits for the QuantityPicked attribute are listed below.

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

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

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

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

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

QuantityPacked

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameQuantity packed
dataFormatdecimal
isNullabletrue

Traits

List of traits for the QuantityPacked attribute are listed below.

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

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

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

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

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

QuantityInvoiced

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameQuantity Invoiced
dataFormatdecimal
isNullabletrue

Traits

List of traits for the QuantityInvoiced attribute are listed below.

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

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

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

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

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

InfocodeId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Information

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

SubInfocodeId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TenderDiscount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameTender discount
dataFormatdecimal
isNullabletrue

Traits

List of traits for the TenderDiscount attribute are listed below.

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

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

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

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

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

TenderDiscountPercentage

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
displayNameTender discount percentage
dataFormatdecimal
isNullabletrue

Traits

List of traits for the TenderDiscountPercentage attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTender discount percentage
entitya reference to the constant entity holding the list of localized text

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

IsPriceKeyedIn

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsPriceKeyedIn attribute are listed below.

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

is.dataFormat.integer

TaxExemptPriceInclusiveOriginalPrice

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TaxExemptPriceInclusiveReductionAmount

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

DataAreaId

First included in: Miscellaneous/RetailSalesLine (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_CatalogRelationshipId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CatalogRelationshipId 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/Merchandising/Main/Catalog.cdm.json/CatalogRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SalesLine1RelationshipId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SalesLine1RelationshipId 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/WorksheetLine/SalesLine.cdm.json/SalesLineRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ReturnReasonCodeRelationshipId

First included in: Miscellaneous/RetailSalesLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ReturnReasonCodeRelationshipId 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/Reference/ReturnReasonCode.cdm.json/ReturnReasonCodeRecId
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: Miscellaneous/RetailSalesLine (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