Components in WorksheetLine(AssetComponent_JP)

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	AssetComponent_JP/(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 Components	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/AssetComponent_JP
Assembling		WorksheetLine/AssetComponent_JP
AssetId		WorksheetLine/AssetComponent_JP
AssetTrans		WorksheetLine/AssetComponent_JP
ComponentRefRecId		WorksheetLine/AssetComponent_JP
CostAmount		WorksheetLine/AssetComponent_JP
CostPrice		WorksheetLine/AssetComponent_JP
DefaultDimension		WorksheetLine/AssetComponent_JP
DisassembledQty		WorksheetLine/AssetComponent_JP
DisassembledQtyUnposted		WorksheetLine/AssetComponent_JP
InitialCostPrice		WorksheetLine/AssetComponent_JP
InventDimId		WorksheetLine/AssetComponent_JP
InventTransId		WorksheetLine/AssetComponent_JP
ItemId		WorksheetLine/AssetComponent_JP
MarketAmount		WorksheetLine/AssetComponent_JP
PriceUnit		WorksheetLine/AssetComponent_JP
Qty		WorksheetLine/AssetComponent_JP
StornoRecId		WorksheetLine/AssetComponent_JP
TransDate		WorksheetLine/AssetComponent_JP
Voucher		WorksheetLine/AssetComponent_JP
DataAreaId		WorksheetLine/AssetComponent_JP
Relationship_AssetTableRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_AssetTransRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_DefaultDimensionRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_InventDimRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_InventTableRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_InventTransOriginRelationshipId		WorksheetLine/AssetComponent_JP
Relationship_CompanyRelationshipId		WorksheetLine/AssetComponent_JP

RecId

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

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

Assembling

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
displayName	Assembling
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

AssetId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the AssetId attribute are listed below.

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

AssetTrans

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ComponentRefRecId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the ComponentRefRecId attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

CostAmount

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
displayName	Amount
dataFormat	decimal
isReadOnly	true
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.readOnly
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 Amount	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

CostPrice

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the CostPrice attribute are listed below.

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

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

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

DefaultDimension

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

DisassembledQty

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the DisassembledQty attribute are listed below.

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

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

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

DisassembledQtyUnposted

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the DisassembledQtyUnposted attribute are listed below.

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

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

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

InitialCostPrice

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
displayName	Initial item cost
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the InitialCostPrice attribute are listed below.

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

is.readOnly
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 Initial item cost	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

InventDimId

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

InventTransId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ItemId

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

MarketAmount

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
displayName	Market value
dataFormat	decimal
isNullable	true

Traits

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

PriceUnit

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
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.readOnly
is.nullable
The attribute value may be set to NULL.

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

Qty

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	decimal

Traits

List of traits for the Qty attribute are listed below.

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

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

StornoRecId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

TransDate

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
displayName	Transaction date
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the TransDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.readOnly
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 Transaction date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

Voucher

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

DataAreaId

First included in: WorksheetLine/AssetComponent_JP (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_AssetTableRelationshipId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_AssetTransRelationshipId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetTransRelationshipId 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/FixedAssets/Transaction/AssetTrans.cdm.json/AssetTrans RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_DefaultDimensionRelationshipId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/AssetComponent_JP (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/AssetComponent_JP (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_InventTransOriginRelationshipId

First included in: WorksheetLine/AssetComponent_JP (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTransOriginRelationshipId 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/Transaction/InventTransOrigin.cdm.json/InventTransOrigin 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/AssetComponent_JP (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