Result of item price comparison in WorksheetLine(InventItemPriceCompareStorageDetails)

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	InventItemPriceCompareStorageDetails/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.1"	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 Result of item price comparison	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToCostCalculationMethod		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToFromDate		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToMarkup		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToOnhandValue		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToPrice		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToPriceAllocateMarkup		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToMarkupQty		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToPriceUnit		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToUnitID		WorksheetLine/InventItemPriceCompareStorageDetails
CompareToUnitPrice		WorksheetLine/InventItemPriceCompareStorageDetails
CostCalculationMethod		WorksheetLine/InventItemPriceCompareStorageDetails
CostGroupId		WorksheetLine/InventItemPriceCompareStorageDetails
CostGroupType		WorksheetLine/InventItemPriceCompareStorageDetails
CostLevel		WorksheetLine/InventItemPriceCompareStorageDetails
DefaultOrderType		WorksheetLine/InventItemPriceCompareStorageDetails
FromDate		WorksheetLine/InventItemPriceCompareStorageDetails
InventDimId		WorksheetLine/InventItemPriceCompareStorageDetails
InventQty		WorksheetLine/InventItemPriceCompareStorageDetails
ItemId		WorksheetLine/InventItemPriceCompareStorageDetails
ItemName		WorksheetLine/InventItemPriceCompareStorageDetails
Markup		WorksheetLine/InventItemPriceCompareStorageDetails
NetChange		WorksheetLine/InventItemPriceCompareStorageDetails
NetChangeOnhandValue		WorksheetLine/InventItemPriceCompareStorageDetails
OnhandValue		WorksheetLine/InventItemPriceCompareStorageDetails
Price		WorksheetLine/InventItemPriceCompareStorageDetails
PriceAllocateMarkup		WorksheetLine/InventItemPriceCompareStorageDetails
MarkupQty		WorksheetLine/InventItemPriceCompareStorageDetails
PriceUnit		WorksheetLine/InventItemPriceCompareStorageDetails
UnitID		WorksheetLine/InventItemPriceCompareStorageDetails
UnitPrice		WorksheetLine/InventItemPriceCompareStorageDetails
TransactionId		WorksheetLine/InventItemPriceCompareStorageDetails
DataAreaId		WorksheetLine/InventItemPriceCompareStorageDetails
Relationship_BOMCostGroupRelationshipId		WorksheetLine/InventItemPriceCompareStorageDetails
Relationship_InventDimRelationshipId		WorksheetLine/InventItemPriceCompareStorageDetails
Relationship_InventTableRelationshipId		WorksheetLine/InventItemPriceCompareStorageDetails
Relationship_InventItemPriceCompareStorageRelationshipId		WorksheetLine/InventItemPriceCompareStorageDetails
Relationship_CompanyRelationshipId		WorksheetLine/InventItemPriceCompareStorageDetails

RecId

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

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

CompareToCostCalculationMethod

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CompareToCostCalculationMethod attribute are listed below.

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

is.dataFormat.integer

CompareToFromDate

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the CompareToFromDate attribute are listed below.

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

is.dataFormat.date

CompareToMarkup

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CompareToOnhandValue

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
displayName	On-hand value
dataFormat	decimal
isNullable	true

Traits

List of traits for the CompareToOnhandValue attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en On-hand value	entity	a reference to the constant entity holding the list of localized text

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

CompareToPrice

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CompareToPriceAllocateMarkup

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CompareToPriceAllocateMarkup attribute are listed below.

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

is.dataFormat.integer

CompareToMarkupQty

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CompareToPriceUnit

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CompareToUnitID

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CompareToUnitPrice

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CostCalculationMethod

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CostCalculationMethod attribute are listed below.

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

is.dataFormat.integer

CostGroupId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CostGroupType

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CostGroupType attribute are listed below.

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

is.dataFormat.integer

CostLevel

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CostLevel attribute are listed below.

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

is.dataFormat.integer

DefaultOrderType

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
displayName	Default order type
dataFormat	int32
isNullable	true

Traits

List of traits for the DefaultOrderType 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 Default order type	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

FromDate

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	date

Traits

List of traits for the FromDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.dataFormat.date

InventDimId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the InventDimId attribute are listed below.

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

InventQty

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
displayName	On-hand quantity
dataFormat	decimal
isNullable	true

Traits

List of traits for the InventQty attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en On-hand quantity	entity	a reference to the constant entity holding the list of localized text

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

ItemId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ItemId attribute are listed below.

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

ItemName

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Markup

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NetChange

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NetChangeOnhandValue

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
displayName	On-hand value of net change
dataFormat	decimal
isNullable	true

Traits

List of traits for the NetChangeOnhandValue attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en On-hand value of net change	entity	a reference to the constant entity holding the list of localized text

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

OnhandValue

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
displayName	New on-hand value
dataFormat	decimal
isNullable	true

Traits

List of traits for the OnhandValue attribute are listed below.

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

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en New on-hand value	entity	a reference to the constant entity holding the list of localized text

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

Price

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

PriceAllocateMarkup

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PriceAllocateMarkup attribute are listed below.

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

is.dataFormat.integer

MarkupQty

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

PriceUnit

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

UnitID

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the UnitID attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

UnitPrice

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the UnitPrice 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: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true

Traits

List of traits for the TransactionId attribute are listed below.

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

DataAreaId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (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_BOMCostGroupRelationshipId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_InventDimRelationshipId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_InventTableRelationshipId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_InventItemPriceCompareStorageRelationshipId

First included in: WorksheetLine/InventItemPriceCompareStorageDetails (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventItemPriceCompareStorageRelationshipId 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/Inventory/WorksheetHeader/InventItemPriceCompareStorage.cdm.json/InventItemPriceCompareStorage 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: WorksheetLine/InventItemPriceCompareStorageDetails (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